Returns statistics about the client connection.


(PECL mysqlnd-uh >= 1.0.0-alpha)

MysqlndUhConnection::getStatisticsReturns statistics about the client connection.

Описание

public array MysqlndUhConnection::getStatistics ( mysqlnd_connection $connection )

Returns statistics about the client connection.

Внимание

К настоящему времени эта функция еще не была документирована; для ознакомления доступен только список аргументов.

Список параметров

connection

Mysqlnd connection handle. Do not modify!

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

Connection statistics collected by mysqlnd.

Примеры

Пример #1 MysqlndUhConnection::getStatistics() example

<?php
class proxy extends MysqlndUhConnection {
 public function 
getStatistics($res) {
  
printf("%s(%s)\n"__METHOD__var_export(func_get_args(), true));
  
$ret parent::getStatistics($res);
  
printf("%s returns %s\n"__METHOD__var_export($rettrue));
  return 
$ret;
 }
}
mysqlnd_uh_set_connection_proxy(new proxy());

$mysqli = new mysqli("localhost""root""""test");
var_dump($mysqli->get_connection_stats());
?>

Результат выполнения данного примера:

 proxy::getStatistics(array (   0 => NULL, )) proxy::getStatistics returns array (   'bytes_sent' => '73',   'bytes_received' => '77',   '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',   'flushed_ps_sets' => '0',   'ps_prepared_never_executed' => '0',   'ps_prepared_once_executed' => '0',   'rows_fetched_from_server_normal' => '0',   'rows_fetched_from_server_ps' => '0',   'rows_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_affected_normal' => '0',   'rows_affected_ps' => '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',   'reconnect' => '0',   'pconnect_success' => '0',   'active_connections' => '1',   'active_persistent_connections' => '0',   'explicit_close' => '0',   'implicit_close' => '0',   'disconnect_close' => '0',   'in_middle_of_command_close' => '0',   'explicit_free_result' => '0',   'implicit_free_result' => '0',   'explicit_stmt_close' => '0',   'implicit_stmt_close' => '0',   'mem_emalloc_count' => '0',   'mem_emalloc_amount' => '0',   'mem_ecalloc_count' => '0',   'mem_ecalloc_amount' => '0',   'mem_erealloc_count' => '0',   'mem_erealloc_amount' => '0',   'mem_efree_count' => '0',   'mem_efree_amount' => '0',   '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' => '0',   'mem_strndup_count' => '0',   'mem_estndup_count' => '0',   'mem_strdup_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',   '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', ) array(160) {   ["bytes_sent"]=>   string(2) "73"   ["bytes_received"]=>   string(2) "77"   ["packets_sent"]=>   string(1) "2"   ["packets_received"]=>   string(1) "2"   ["protocol_overhead_in"]=>   string(1) "8"   ["protocol_overhead_out"]=>   string(1) "8"   ["bytes_received_ok_packet"]=>   string(1) "0"   ["bytes_received_eof_packet"]=>   string(1) "0"   ["bytes_received_rset_header_packet"]=>   string(1) "0"   ["bytes_received_rset_field_meta_packet"]=>   string(1) "0"   ["bytes_received_rset_row_packet"]=>   string(1) "0"   ["bytes_received_prepare_response_packet"]=>   string(1) "0"   ["bytes_received_change_user_packet"]=>   string(1) "0"   ["packets_sent_command"]=>   string(1) "0"   ["packets_received_ok"]=>   string(1) "0"   ["packets_received_eof"]=>   string(1) "0"   ["packets_received_rset_header"]=>   string(1) "0"   ["packets_received_rset_field_meta"]=>   string(1) "0"   ["packets_received_rset_row"]=>   string(1) "0"   ["packets_received_prepare_response"]=>   string(1) "0"   ["packets_received_change_user"]=>   string(1) "0"   ["result_set_queries"]=>   string(1) "0"   ["non_result_set_queries"]=>   string(1) "0"   ["no_index_used"]=>   string(1) "0"   ["bad_index_used"]=>   string(1) "0"   ["slow_queries"]=>   string(1) "0"   ["buffered_sets"]=>   string(1) "0"   ["unbuffered_sets"]=>   string(1) "0"   ["ps_buffered_sets"]=>   string(1) "0"   ["ps_unbuffered_sets"]=>   string(1) "0"   ["flushed_normal_sets"]=>   string(1) "0"   ["flushed_ps_sets"]=>   string(1) "0"   ["ps_prepared_never_executed"]=>   string(1) "0"   ["ps_prepared_once_executed"]=>   string(1) "0"   ["rows_fetched_from_server_normal"]=>   string(1) "0"   ["rows_fetched_from_server_ps"]=>   string(1) "0"   ["rows_buffered_from_client_normal"]=>   string(1) "0"   ["rows_buffered_from_client_ps"]=>   string(1) "0"   ["rows_fetched_from_client_normal_buffered"]=>   string(1) "0"   ["rows_fetched_from_client_normal_unbuffered"]=>   string(1) "0"   ["rows_fetched_from_client_ps_buffered"]=>   string(1) "0"   ["rows_fetched_from_client_ps_unbuffered"]=>   string(1) "0"   ["rows_fetched_from_client_ps_cursor"]=>   string(1) "0"   ["rows_affected_normal"]=>   string(1) "0"   ["rows_affected_ps"]=>   string(1) "0"   ["rows_skipped_normal"]=>   string(1) "0"   ["rows_skipped_ps"]=>   string(1) "0"   ["copy_on_write_saved"]=>   string(1) "0"   ["copy_on_write_performed"]=>   string(1) "0"   ["command_buffer_too_small"]=>   string(1) "0"   ["connect_success"]=>   string(1) "1"   ["connect_failure"]=>   string(1) "0"   ["connection_reused"]=>   string(1) "0"   ["reconnect"]=>   string(1) "0"   ["pconnect_success"]=>   string(1) "0"   ["active_connections"]=>   string(1) "1"   ["active_persistent_connections"]=>   string(1) "0"   ["explicit_close"]=>   string(1) "0"   ["implicit_close"]=>   string(1) "0"   ["disconnect_close"]=>   string(1) "0"   ["in_middle_of_command_close"]=>   string(1) "0"   ["explicit_free_result"]=>   string(1) "0"   ["implicit_free_result"]=>   string(1) "0"   ["explicit_stmt_close"]=>   string(1) "0"   ["implicit_stmt_close"]=>   string(1) "0"   ["mem_emalloc_count"]=>   string(1) "0"   ["mem_emalloc_amount"]=>   string(1) "0"   ["mem_ecalloc_count"]=>   string(1) "0"   ["mem_ecalloc_amount"]=>   string(1) "0"   ["mem_erealloc_count"]=>   string(1) "0"   ["mem_erealloc_amount"]=>   string(1) "0"   ["mem_efree_count"]=>   string(1) "0"   ["mem_efree_amount"]=>   string(1) "0"   ["mem_malloc_count"]=>   string(1) "0"   ["mem_malloc_amount"]=>   string(1) "0"   ["mem_calloc_count"]=>   string(1) "0"   ["mem_calloc_amount"]=>   string(1) "0"   ["mem_realloc_count"]=>   string(1) "0"   ["mem_realloc_amount"]=>   string(1) "0"   ["mem_free_count"]=>   string(1) "0"   ["mem_free_amount"]=>   string(1) "0"   ["mem_estrndup_count"]=>   string(1) "0"   ["mem_strndup_count"]=>   string(1) "0"   ["mem_estndup_count"]=>   string(1) "0"   ["mem_strdup_count"]=>   string(1) "0"   ["proto_text_fetched_null"]=>   string(1) "0"   ["proto_text_fetched_bit"]=>   string(1) "0"   ["proto_text_fetched_tinyint"]=>   string(1) "0"   ["proto_text_fetched_short"]=>   string(1) "0"   ["proto_text_fetched_int24"]=>   string(1) "0"   ["proto_text_fetched_int"]=>   string(1) "0"   ["proto_text_fetched_bigint"]=>   string(1) "0"   ["proto_text_fetched_decimal"]=>   string(1) "0"   ["proto_text_fetched_float"]=>   string(1) "0"   ["proto_text_fetched_double"]=>   string(1) "0"   ["proto_text_fetched_date"]=>   string(1) "0"   ["proto_text_fetched_year"]=>   string(1) "0"   ["proto_text_fetched_time"]=>   string(1) "0"   ["proto_text_fetched_datetime"]=>   string(1) "0"   ["proto_text_fetched_timestamp"]=>   string(1) "0"   ["proto_text_fetched_string"]=>   string(1) "0"   ["proto_text_fetched_blob"]=>   string(1) "0"   ["proto_text_fetched_enum"]=>   string(1) "0"   ["proto_text_fetched_set"]=>   string(1) "0"   ["proto_text_fetched_geometry"]=>   string(1) "0"   ["proto_text_fetched_other"]=>   string(1) "0"   ["proto_binary_fetched_null"]=>   string(1) "0"   ["proto_binary_fetched_bit"]=>   string(1) "0"   ["proto_binary_fetched_tinyint"]=>   string(1) "0"   ["proto_binary_fetched_short"]=>   string(1) "0"   ["proto_binary_fetched_int24"]=>   string(1) "0"   ["proto_binary_fetched_int"]=>   string(1) "0"   ["proto_binary_fetched_bigint"]=>   string(1) "0"   ["proto_binary_fetched_decimal"]=>   string(1) "0"   ["proto_binary_fetched_float"]=>   string(1) "0"   ["proto_binary_fetched_double"]=>   string(1) "0"   ["proto_binary_fetched_date"]=>   string(1) "0"   ["proto_binary_fetched_year"]=>   string(1) "0"   ["proto_binary_fetched_time"]=>   string(1) "0"   ["proto_binary_fetched_datetime"]=>   string(1) "0"   ["proto_binary_fetched_timestamp"]=>   string(1) "0"   ["proto_binary_fetched_string"]=>   string(1) "0"   ["proto_binary_fetched_blob"]=>   string(1) "0"   ["proto_binary_fetched_enum"]=>   string(1) "0"   ["proto_binary_fetched_set"]=>   string(1) "0"   ["proto_binary_fetched_geometry"]=>   string(1) "0"   ["proto_binary_fetched_other"]=>   string(1) "0"   ["init_command_executed_count"]=>   string(1) "0"   ["init_command_failed_count"]=>   string(1) "0"   ["com_quit"]=>   string(1) "0"   ["com_init_db"]=>   string(1) "0"   ["com_query"]=>   string(1) "0"   ["com_field_list"]=>   string(1) "0"   ["com_create_db"]=>   string(1) "0"   ["com_drop_db"]=>   string(1) "0"   ["com_refresh"]=>   string(1) "0"   ["com_shutdown"]=>   string(1) "0"   ["com_statistics"]=>   string(1) "0"   ["com_process_info"]=>   string(1) "0"   ["com_connect"]=>   string(1) "0"   ["com_process_kill"]=>   string(1) "0"   ["com_debug"]=>   string(1) "0"   ["com_ping"]=>   string(1) "0"   ["com_time"]=>   string(1) "0"   ["com_delayed_insert"]=>   string(1) "0"   ["com_change_user"]=>   string(1) "0"   ["com_binlog_dump"]=>   string(1) "0"   ["com_table_dump"]=>   string(1) "0"   ["com_connect_out"]=>   string(1) "0"   ["com_register_slave"]=>   string(1) "0"   ["com_stmt_prepare"]=>   string(1) "0"   ["com_stmt_execute"]=>   string(1) "0"   ["com_stmt_send_long_data"]=>   string(1) "0"   ["com_stmt_close"]=>   string(1) "0"   ["com_stmt_reset"]=>   string(1) "0"   ["com_stmt_set_option"]=>   string(1) "0"   ["com_stmt_fetch"]=>   string(1) "0"   ["com_deamon"]=>   string(1) "0"   ["bytes_received_real_data_normal"]=>   string(1) "0"   ["bytes_received_real_data_ps"]=>   string(1) "0" } 

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