PHP MySQLi mysqli_get_connection_stats()

mysqli_get_connection_stats()

The mysqli_get_connection_stats() function returns an associative array containing client statistical data for a specific connection. Unlike general client statistics, this focuses exclusively on activity within the provided connection object.

EXAMPLE

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

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

if (mysqli_connect_errno()) {
    printf("Connection failed: %s<br>", mysqli_connect_error());
    exit();
}

// Retrieve statistics for this specific connection
// NOTE: Since we passed the $connection variable as a parameter, the mysqli_get_connection_stats() 
// function will return traffic statistics (sent bytes, packets, executed SELECT's) that occurred 
// exclusively on this specific connection.
$statistics = mysqli_get_connection_stats($connection);
echo "<pre>";
print_r($statistics); echo "<br>";
echo "</pre>";

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: The function is key for debugging and monitoring resource consumption for individual database connections. The output is similar to general statistics, but limited to a single session:

It returns data on bytes transferred, number of queries, and errors for a specific connection.

It requires the use of the MySQL Native Driver (mysqlnd).

It allows for precise tracking of SQL command performance within a single connection.