PHP mysqli: функция get_connection_stats ()

Функция mysqli_get_connection_stats () / mysqli :: get_connection_stats

Функция mysqli_get_connection_stats () / mysqli :: get_connection_stats возвращает статистику о клиентском соединении.

Синтаксис:

Объектно-ориентированный стиль

 bool mysqli :: get_connection_stats (void)

Процедурный стиль

 массив mysqli_get_connection_stats (mysqli $ link)

Использование: Процедурный стиль

 mysqli_get_connection_stats (соединение); 

Параметр:

Возвращаемое значение:

Возвращает массив со статистикой соединения в случае успеха, иначе FALSE.

Версия: PHP 5> = 5.3.0, PHP 7

Пример:

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
print_r(mysqli_get_connection_stats($con));
mysqli_close($con);
?>

Выход:

 Массив ([bytes_sent] => 66 [bytes_received] => 81 [packages_sent] => 1 [packages_received] => 2 [protocol_overhead_in] => 8 
 [protocol_overhead_out] => 4 [bytes_received_ok_packet] => 11 [bytes_received_eof_packet] => 0 [bytes_received_rset_header_packet] => 0 
 [bytes_received_rset_field_meta_packet] => 0 [bytes_received_rset_row_packet] => 0 [bytes_received_prepare_response_packet] => 0 
 [bytes_received_change_user_packet] => 0 [packages_sent_command] => 0 [packages_received_ok] => 1 [packages_received_eof] => 0 
 [packages_received_rset_header] => 0 [packages_received_rset_field_meta] => 0 [packages_received_rset_row] => 0 [packages_received_prepare_response] => 0 [packages_received_change_user] => 0 [result_set_queries] => 0 [=] __0_0_0_N = ] => 0 
 [slow_queries] => 0 [buffered_sets] => 0 [unbuffered_sets] => 0 [ps_buffered_sets] => 0 [ps_unbuffered_sets] => 0 [flhed_normal_sets] => 0 [flhed_ps_sets] => 0 
 [ps_prepared_never_executed] => 0 [ps_prepared_once_executed] => 0 [row_fetched_from_server_normal] => 0 [lines_fetched_from_server_ps] => 0 [row_buffered_from_client_normal] => 0 
 [Rows_buffered_from_client_ps] => 0 [rows_fetched_from_client_normal_buffered] => 0 [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] => 0 [rows_skipped_ps] => 0 [copy_on_write_saved ] => 0 [copy_on_write_performed] => 0 [command_buffer_too_small] => 0 [connect_success] => 1 [connect_failure] => 0 [connection_reused] => 0 [connect] => 0 [pconnect_success] => 0 
 [active_connections] => 1 [active_persistent_connections] => 0 [licit_close] => 0 [implicit_close] => 0 [disconnect_close] => 0 [in_middle_of_command_close] => 0 
 [licit_free_result] => 0 [implicit_free_result] => 0 [licit_stmt_close] => 0 [implicit_stmt_close] => 0 [mem_emalloc_count] => 0 [mem_emalloc_ammount] => 0 
 [mem_ecalloc_count] => 0 [mem_ecalloc_ammount] => 0 [mem_erealloc_count] => 0 [mem_erealloc_ammount] => 0 [mem_efree_count] => 0 [mem_malloc_count] => 0 [mem_malloc_ammount] => 0 
 [mem_calloc_count] => 0 [mem_calloc_ammount] => 0 [mem_realloc_count] => 0 [mem_realloc_ammount] => 0 [mem_free_count] => 0 [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] => 0 [proto_text_fetched_decimal] => 0 [proto_text_fetched_float] => 0 [proto_text_fetched_double] => 0 [proto_text_fetched_date] => 0 
 [proto_text_fetched_year] => 0 [proto_text_fetched_time] => 0 [proto_text_fetched_datetime] => 0 [proto_text_fetched_timestamp] => 0 [proto_text_fetched_string] => 0 
 [proto_text_fetched_blob] => 0 [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)

Смотрите также

Справочник по функциям PHP

Предыдущая: get_client_version
Далее: host_info