w3resource

PHP mysqli: get_client_stats() function

mysqli_get_client_stats function

The mysqli_get_client_stats() function returns statistics about client per-process.

Returns client per-process statistics. Available only with mysqlnd.

Syntax:

array mysqli_get_client_stats ( void )

Usage:

mysqli_get_client_stats();

Return value:

Returns an array with client stats if success, FALSE otherwise.

Version: PHP 5, PHP 7

Example:

<?php
$con=mysqli_connect("localhost","user1","datasoft123","hr");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

print_r(mysqli_get_client_stats());

mysqli_close($con);
?>

Output:

Array ( [bytes_sent] => 6381 [bytes_received] => 174703 [packets_sent] => 181 [packets_received] => 3348 [protocol_overhead_in] =>
13392 [protocol_overhead_out] => 724 [bytes_received_ok_packet] => 539 [bytes_received_eof_packet] => 450
[bytes_received_rset_header_packet] => 1257 [bytes_received_rset_field_meta_packet] => 17210 [bytes_received_rset_row_packet] => 151922
[bytes_received_prepare_response_packet] => 0 [bytes_received_change_user_packet] => 0 [packets_sent_command] => 137
[packets_received_ok] => 49 [packets_received_eof] => 50 [packets_received_rset_header] => 88 [packets_received_rset_field_meta] => 292 [packets_received_rset_row] => 2825
[packets_received_prepare_response] => 0 [packets_received_change_user] => 0 [result_set_queries] => 49 [non_result_set_queries] => 22 [no_index_used] => 0 [bad_index_used] => 0
[slow_queries] => 0 [buffered_sets] => 49 [unbuffered_sets] => 0 [ps_buffered_sets] => 0 [ps_unbuffered_sets] => 0 [flushed_normal_sets] => 0 [flushed_ps_sets] => 0
[ps_prepared_never_executed] => 0 [ps_prepared_once_executed] => 0 [rows_fetched_from_server_normal] => 2776 [rows_fetched_from_server_ps] => 0 [rows_buffered_from_client_normal]
=> 2776 [rows_buffered_from_client_ps] => 0 [rows_fetched_from_client_normal_buffered] => 1373 [rows_fetched_from_client_normal_unbuffered] => 0
[rows_fetched_from_client_ps_buffered] => 0 [rows_fetched_from_client_ps_unbuffered] => 0 [rows_fetched_from_client_ps_cursor] => 0 [rows_skipped_normal] => 2776 [rows_skipped_ps]
=> 0 [copy_on_write_saved] => 1387 [copy_on_write_performed] => 2882 [command_buffer_too_small] => 0 [connect_success] => 44 [connect_failure] => 0 [connection_reused] => 0
[reconnect] => 0 [pconnect_success] => 0 [active_connections] => 1 [active_persistent_connections] => 0 [explicit_close] => 36 [implicit_close] => 7 [disconnect_close] => 0
[in_middle_of_command_close] => 0 [explicit_free_result] => 49 [implicit_free_result] => 0 [explicit_stmt_close] => 0 [implicit_stmt_close] => 0 [mem_emalloc_count] => 462
[mem_emalloc_ammount] => 4936582 [mem_ecalloc_count] => 331 [mem_ecalloc_ammount] => 105688 [mem_erealloc_count] => 2846 [mem_erealloc_ammount] => 1342372 [mem_efree_count] => 877
[mem_malloc_count] => 2977 [mem_malloc_ammount] => 1711808 [mem_calloc_count] => 51 [mem_calloc_ammount] => 30864 [mem_realloc_count] => 14 [mem_realloc_ammount] => 14336
[mem_free_count] => 3484 [proto_text_fetched_null] => 0 [proto_text_fetched_bit] => 0 [proto_text_fetched_tinyint] => 0 [proto_text_fetched_short] => 0 [proto_text_fetched_int24]
=> 0 [proto_text_fetched_int] => 0 [proto_text_fetched_bigint] => 1508 [proto_text_fetched_decimal] => 150 [proto_text_fetched_float] => 0 [proto_text_fetched_double] => 0
[proto_text_fetched_date] => 30 [proto_text_fetched_year] => 0 [proto_text_fetched_time] => 0 [proto_text_fetched_datetime] => 45 [proto_text_fetched_timestamp] => 0
[proto_text_fetched_string] => 2364 [proto_text_fetched_blob] => 12 [proto_text_fetched_enum] => 0 [proto_text_fetched_set] => 0 [proto_text_fetched_geometry] => 0
[proto_text_fetched_other] => 0 [proto_binary_fetched_null] => 0 [proto_binary_fetched_bit] => 0 [proto_binary_fetched_tinyint] => 0 [proto_binary_fetched_short] => 0
[proto_binary_fetched_int24] => 0 [proto_binary_fetched_int] => 0 [proto_binary_fetched_bigint] => 0 [proto_binary_fetched_decimal] => 0 [proto_binary_fetched_float] => 0
[proto_binary_fetched_double] => 0 [proto_binary_fetched_date] => 0 [proto_binary_fetched_year] => 0 [proto_binary_fetched_time] => 0 [proto_binary_fetched_datetime] => 0
[proto_binary_fetched_timestamp] => 0 [proto_binary_fetched_string] => 0 [proto_binary_fetched_blob] => 0 [proto_binary_fetched_enum] => 0 [proto_binary_fetched_set] => 0
[proto_binary_fetched_geometry] => 0 [proto_binary_fetched_other] => 0 )

See also

PHP Function Reference

Previous: get_client_info
Next: get_client_version



PHP: Tips of the Day

var_export(): var_export() dumps a PHP parseable representation of the item.

You can pass true as the second parameter to return the contents into a variable.

Example:

<?php
$myarray = [ "PHP", "Tips" ];
$mystring = "PHP Tips";
$myint = 28;

var_export($myarray);
var_export($mystring);
var_export($myint);
?>

Output:

array (
  0 => 'PHP',
  1 => 'Tips',
)'PHP Tips'28

To put the content into a variable, you can do this:

$array_export = var_export($myarray, true);
$string_export = var_export($mystring, true);
$int_export = var_export($myint, 1); // any `Truthy` value

After that, you can output it like this:

printf('$myarray = %s; %s', $array_export, PHP_EOL);
printf('$mystring = %s; %s', $string_export, PHP_EOL);
printf('$myint = %s; %s', $int_export, PHP_EOL);

Example:

<?php
$myarray = [ "PHP", "Tips" ];
$mystring = "PHP Tips";
$myint = 28;
$array_export = var_export($myarray, true);
$string_export = var_export($mystring, true);
$int_export = var_export($myint, 1);
printf('$myarray = %s; %s', $array_export, PHP_EOL);
printf('$mystring = %s; %s', $string_export, PHP_EOL);
printf('$myint = %s; %s', $int_export, PHP_EOL);
?>

This will produce the following output:

Output:

$myarray = array (
  0 => 'PHP',
  1 => 'Tips',
);
$mystring = 'PHP Tips';
$myint = 28;