MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
mysqli::stat
mysqli_stat
Gets the current system status
Object oriented style
public string mysqli::stat();
Procedural style
string mysqli_stat(mysqli link);
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
Procedural style only: A link identifier returned by
mysqli_connect
or
mysqli_init
A string describing the server status.
false
if an error occurred.
Example 3.66 mysqli::stat
example
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(); ?>
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); ?>
The above examples will output:
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_get_server_info
|