Copyright 1997-2008 the PHP Documentation Group.

Configuration File (php.ini) Settings

In PHP 5.3 the following php.ini settings are available for the MySQL Native Driver:

mysqlnd.collect_statistics

type:boolean, default:"1", changeable:PHP_INI_SYSTEM

Available since 5.3.0

Enables the collection of various client statistics which can be accessed through mysqli_get_client_stats(), mysqli_get_connection_stats(), mysqli_get_cache_stats() and are shown in mysqlnd section of the output of the phpinfo() function as well.

When enabled the following statistics will be collected:

bytes_sent, bytes_received, packets_sent, packets_received, protocol_overhead_in, protocol_overhead_out, bytes_received_ok_packet, bytes_received_eof_packet, bytes_received_rset_header_packet, bytes_received_rset_field_meta_packet, bytes_received_rset_row_packet, bytes_received_prepare_response_packet, bytes_received_change_user_packet, packets_sent_command, packets_received_ok, packets_received_eof, packets_received_rset_header, packets_received_rset_field_meta, packets_received_rset_row, packets_received_prepare_response, packets_received_change_user, result_set_queries, non_result_set_queries, no_index_used, bad_index_used, slow_queries, buffered_sets, unbuffered_sets, ps_buffered_sets, ps_unbuffered_sets, flushed_normal_sets, flushed_ps_sets, ps_prepared_never_executed, ps_prepared_once_executed, rows_fetched_from_server_normal, rows_fetched_from_server_ps, rows_buffered_from_client_normal, rows_buffered_from_client_ps, rows_fetched_from_client_normal_buffered, rows_fetched_from_client_normal_unbuffered, rows_fetched_from_client_ps_buffered, rows_fetched_from_client_ps_unbuffered, rows_fetched_from_client_ps_cursor, rows_skipped_normal, rows_skipped_ps, copy_on_write_saved, copy_on_write_performed, command_buffer_too_small, connect_success, connect_failure

mysqlnd.collect_memory_statistics

type:boolean, default:"0", changeable:PHP_INI_SYSTEM

Available since 5.3.0

Enable the collection of various memory statistics which can be accessed through mysqli_get_client_stats(), mysqli_get_connection_stats(), mysqli_get_cache_stats() and are shown in mysqlnd section of the output of the phpinfo() function as well.

When enabled the following statistics will be collected:

TBD