PHP MySQLi mysqli_get_client_stats()

mysqli_get_client_stats()

The mysqli_get_client_stats() function returns an associative array containing detailed statistical data about all client activities on the current process. This includes the number of packets sent, time spent, and the amount of data transferred.

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 and display client (driver) statistics
// NOTE: This function returns detailed performance statistics for the built-in mysqlnd driver. 
// It will output an array containing interesting data, such as the number of bytes sent (bytes_sent), 
// the number of bytes received (bytes_received), and the total number of commands executed (rows_fetched).
$statistics = mysqli_get_client_stats();
echo "<pre>";
print_r($statistics); echo "<br>";
echo "</pre>";

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This function is primarily intended for optimization and identifying bottlenecks in communication between PHP and the database. Take a look at the example output of the complete statistics below:

It returns an array with more than 40 different parameters (e.g., bytes_sent, rows_fetched).

It is only available if you are using the MySQL Native Driver (mysqlnd).

It helps with a precise performance analysis of your web application.