English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية
PHP MySQLi руководство пользователя
mysqli_get_client_stats()Функция retrieves each process statistics of the client and returns it. In the form of an array.
mysqli_get_client_stats($con);
Эта функция не принимает никаких параметров.
Функция PHP mysqli_get_client_stats() возвращает массив, содержащий статистическую информацию о клиенте по процессу. Если функция не удается, она возвращает булево значениеfalse.
Эта функция была введена в PHP версии 5 и может использоваться во всех более поздних версиях.
Ниже приведен примерmysqli_get_client_stats()Использование функции (процедурный стиль)-
<?php
//Установление соединения
$con = mysqli_connect("localhost", "root", "password", "mydb");
//Статус
$stat = mysqli_get_client_stats();
print_r($stat);
//Закрытие соединения
mysqli_close($con);
?>Результат вывода
Массив ( [ bytes_sent ] => 138 [ bytes_received ] => 93 [ packets_sent ] => 2 [ packets_received ] => 2 [ protocol_overhead_in ] => 8 [ protocol_overhead_out ] => 8 [ bytes_received_ok_packet ] => 0 [ 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 [ packets_sent_command ] => 0 [ packets_received_ok ] => 0 [ packets_received_eof ] => 0 [ packets_received_rset_header ] => 0 [ packets_received_rset_field_meta ] => 0 [ packets_received_rset_row ] => 0 [ packets_received_prepare_response ] => 0 [ packets_received_change_user ] => 0 [ result_set_queries ] => 0 [ non_result_set_queries ] => 0 [ no_index_used ] => 0 [ bad_index_used ] => 0 [ slow_queries ] => 0 [ buffered_sets ] => 0 [ unbuffered_sets ] => 0 [ ps_buffered_sets ] => 0 [ ps_unbuffered_sets ] => 0 [ flushed_normal_sets ] => 0 [очищенные_ps_сеты] => 0 [psподготовленныйникогда_не_исполнен] => 0 [psподготовленный_один_раз_исполнен] => 0 [полученные_строки_от_сервера_обычные] => 0 [полученные_строки_от_сервера_ps] => 0 [буферизированные_строки_от_клиента_обычные] => 0 [буферизированные_строки_от_клиента_ps] => 0 [полученные_строки_от_клиента_обычныебуферизированные] => 0 [полученные_строки_от_клиента_обычныене буферизированные] => 0 [полученные_строки_от_клиента_psбуферизированные] => 0 [полученные_строки_от_клиента_psне буферизированные] => 0 [полученные_строки_от_клиента_psкурсор] => 0 [влиявшие_строки_обычные] => 0 [влиявшие_строки_ps] => 0 [пропущенные_строки_обычные] => 0 [пропущенные_строки_ps] => 0 [сохранение_копирования_по_записи] => 0 [выполнение_копирования_по_записи] => 0 [буфер_команд_слишком_маленький] => 0 [успешное_подключение] => 1 [неуспешное_подключение] => 0 [повторное_использование_соединения] => 0 [повторное_подключение] => 0 [успешное_pconnect] => 0 [активные_соединения] => 1 [активные_постоянные_соединения] => 0 [явное_закрытие] => 0 [неявное_закрытие] => 0 [разрыв_соединения] => 0 [в_середине_закрытия_команды] => 0 [явный_свободный_результат] => 0 [implicit_free_result] => 0 [explicit_stmt_close] => 0 [implicit_stmt_close] => 0 [mem_emalloc_count] => 4 [mem_emalloc_amount] => 4195 [mem_ecalloc_count] => 5 [mem_ecalloc_amount] => 2120 [mem_erealloc_count] => 0 [mem_erealloc_amount] => 0 [mem_efree_count] => 2 [mem_efree_amount] => 44 [mem_malloc_count] => 0 [mem_malloc_amount] => 0 [mem_calloc_count] => 0 [mem_calloc_amount] => 0 [mem_realloc_count] => 0 [mem_realloc_amount] => 0 [mem_free_count] => 0 [mem_free_amount] => 0 [mem_estrndup_count] => 5 [mem_strndup_count] => 0 [mem_estrdup_count] => 4 [mem_strdup_count] => 0 [mem_edupl_count] => 0 [mem_dupl_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_json] => 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 [init_command_executed_count] => 0 [init_command_failed_count] => 0 [com_quit] => 0 [com_init_db] => 0 [com_query] => 0 [com_field_list] => 0 [com_create_db] => 0 [com_drop_db] => 0 [com_refresh] => 0 [com_shutdown] => 0 [com_statistics] => 0 [com_process_info] => 0 [com_connect] => 0 [com_process_kill] => 0 [com_debug] => 0 [com_ping] => 0 [com_time] => 0 [com_delayed_insert] => 0 [com_change_user] => 0 [com_binlog_dump] => 0 [com_table_dump] => 0 [com_connect_out] => 0 [com_register_slave] => 0 [com_stmt_prepare] => 0 [com_stmt_execute] => 0 [com_stmt_send_long_data] => 0 [com_stmt_close] => 0 [com_stmt_reset] => 0 [com_stmt_set_option] => 0 [com_stmt_fetch] => 0 [com_deamon] => 0 [bytes_received_real_data_normal] => 0 [bytes_received_real_data_ps] => 0 )