Forum und email
mysqli
PHP Manual

mysqli_stat

mysqli->stat()

(PHP 5)

mysqli->stat() — Gets the current system status

설명

Procedural style:

string mysqli_stat ( mysqli $link )

Object oriented style (method):

mysqli
string stat ( void )

mysqli_stat() returns a string containing information similar to that provided by the 'mysqladmin status' command. This includes uptime in seconds and the number of running threads, questions, reloads, and open tables.

매개변수

link

순차 형식 전용: mysqli_connect()나 mysqli_init()가 반환한 연결 식별자.

반환값

A string describing the server status. FALSE if an error occurred.

예제

Example#1 Object oriented style

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

printf ("System status: %s\n", $mysqli->stat());

$mysqli->close();
?>

Example#2 Procedural style

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

printf("System status: %s\n", mysqli_stat($link));

mysqli_close($link);
?>

위 예제의 출력:

System status: Uptime: 272  Threads: 1  Questions: 5340  Slow queries: 0
Opens: 13  Flush tables: 1  Open tables: 0  Queries per second avg: 19.632
Memory in use: 8496K  Max memory used: 8560K

참고

mysqli
PHP Manual