PHP MySQLi mysqli_stat()

mysqli_stat()

The mysqli_stat() function returns a string containing the current server statistics. This data includes the uptime, the number of active threads, the total number of queries, and the number of open tables.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

if (mysqli_connect_errno()) {
    echo "Connection failed: " . mysqli_connect_error();
    exit();
}

// Retrieve the current system statistics of the MySQL server
// NOTE: The mysqli_stat() function returns a string containing the current operational 
// data of the server (Uptime, Threads, Questions, Slow queries, Opens, Flush tables, Open tables, Queries per second).
// Since it returns a raw string, it is recommended to wrap the output in <pre> tags in HTML to preserve alignment.
$status = mysqli_stat($connection);

if ($status) {
    echo "<h3>Current system status:</h3>";
    echo "<pre>" . $status . "</pre>";
} else {
    echo "Could not retrieve status: " . mysqli_error($connection);
}

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This function is extremely useful for quick server diagnostics. Instead of complex queries, you get a short summary that tells you how loaded your system is at any given moment.

Uptime: The time in seconds since the server has been running.

Threads: The number of currently active connections.

Queries: The total number of executed SQL commands.

Slow queries: The number of queries that took longer than the configured limit.