Skip to content

Instantly share code, notes, and snippets.

@dotmanila
Created August 25, 2015 07:50
Show Gist options
  • Save dotmanila/dcd4453b07e33020fdec to your computer and use it in GitHub Desktop.
Save dotmanila/dcd4453b07e33020fdec to your computer and use it in GitHub Desktop.
mysqlnd stats name to source code constant mapping
bytes_sent STAT_BYTES_SENT
bytes_received STAT_BYTES_RECEIVED
packets_sent STAT_PACKETS_SENT
packets_received STAT_PACKETS_RECEIVED
protocol_overhead_in STAT_PROTOCOL_OVERHEAD_IN
protocol_overhead_out STAT_PROTOCOL_OVERHEAD_OUT
bytes_received_ok_packet STAT_BYTES_RECEIVED_OK
bytes_received_eof_packet STAT_BYTES_RECEIVED_EOF
bytes_received_rset_header_packet STAT_BYTES_RECEIVED_RSET_HEADER
bytes_received_rset_field_meta_packet STAT_BYTES_RECEIVED_RSET_FIELD_META
bytes_received_rset_row_packet STAT_BYTES_RECEIVED_RSET_ROW
bytes_received_prepare_response_packet STAT_BYTES_RECEIVED_PREPARE_RESPONSE
bytes_received_change_user_packet STAT_BYTES_RECEIVED_CHANGE_USER
packets_sent_command STAT_PACKETS_SENT_CMD
packets_received_ok STAT_PACKETS_RECEIVED_OK
packets_received_eof STAT_PACKETS_RECEIVED_EOF
packets_received_rset_header STAT_PACKETS_RECEIVED_RSET_HEADER
packets_received_rset_field_meta STAT_PACKETS_RECEIVED_RSET_FIELD_META
packets_received_rset_row STAT_PACKETS_RECEIVED_RSET_ROW
packets_received_prepare_response STAT_PACKETS_RECEIVED_PREPARE_RESPONSE
packets_received_change_user STAT_PACKETS_RECEIVED_CHANGE_USER
result_set_queries STAT_RSET_QUERY
non_result_set_queries STAT_NON_RSET_QUERY
no_index_used STAT_NO_INDEX_USED
bad_index_used STAT_BAD_INDEX_USED
slow_queries STAT_QUERY_WAS_SLOW
buffered_sets STAT_BUFFERED_SETS
unbuffered_sets STAT_UNBUFFERED_SETS
ps_buffered_sets STAT_PS_BUFFERED_SETS
ps_unbuffered_sets STAT_PS_UNBUFFERED_SETS
flushed_normal_sets STAT_FLUSHED_NORMAL_SETS
flushed_ps_sets STAT_FLUSHED_PS_SETS
ps_prepared_never_executed STAT_PS_PREPARED_NEVER_EXECUTED
ps_prepared_once_executed STAT_PS_PREPARED_ONCE_USED
rows_fetched_from_server_normal STAT_ROWS_FETCHED_FROM_SERVER_NORMAL
rows_fetched_from_server_ps STAT_ROWS_FETCHED_FROM_SERVER_PS
rows_buffered_from_client_normal STAT_ROWS_BUFFERED_FROM_CLIENT_NORMAL
rows_buffered_from_client_ps STAT_ROWS_BUFFERED_FROM_CLIENT_PS
rows_fetched_from_client_normal_buffered STAT_ROWS_FETCHED_FROM_CLIENT_NORMAL_BUF
rows_fetched_from_client_normal_unbuffered STAT_ROWS_FETCHED_FROM_CLIENT_NORMAL_UNBUF
rows_fetched_from_client_ps_buffered STAT_ROWS_FETCHED_FROM_CLIENT_PS_BUF
rows_fetched_from_client_ps_unbuffered STAT_ROWS_FETCHED_FROM_CLIENT_PS_UNBUF
rows_fetched_from_client_ps_cursor STAT_ROWS_FETCHED_FROM_CLIENT_PS_CURSOR
rows_affected_normal STAT_ROWS_AFFECTED_NORMAL
rows_affected_ps STAT_ROWS_AFFECTED_PS
rows_skipped_normal STAT_ROWS_SKIPPED_NORMAL
rows_skipped_ps STAT_ROWS_SKIPPED_PS
copy_on_write_saved STAT_COPY_ON_WRITE_SAVED
copy_on_write_performed STAT_COPY_ON_WRITE_PERFORMED
command_buffer_too_small STAT_CMD_BUFFER_TOO_SMALL
connect_success STAT_CONNECT_SUCCESS
connect_failure STAT_CONNECT_FAILURE
connection_reused STAT_CONNECT_REUSED
reconnect STAT_RECONNECT
pconnect_success STAT_PCONNECT_SUCCESS
active_connections STAT_OPENED_CONNECTIONS
active_persistent_connections STAT_OPENED_PERSISTENT_CONNECTIONS
explicit_close STAT_CLOSE_EXPLICIT
implicit_close STAT_CLOSE_IMPLICIT
disconnect_close STAT_CLOSE_DISCONNECT
in_middle_of_command_close STAT_CLOSE_IN_MIDDLE
explicit_free_result STAT_FREE_RESULT_EXPLICIT
implicit_free_result STAT_FREE_RESULT_IMPLICIT
explicit_stmt_close STAT_STMT_CLOSE_EXPLICIT
implicit_stmt_close STAT_STMT_CLOSE_IMPLICIT
mem_emalloc_count STAT_MEM_EMALLOC_COUNT
mem_emalloc_amount STAT_MEM_EMALLOC_AMOUNT
mem_ecalloc_count STAT_MEM_ECALLOC_COUNT
mem_ecalloc_amount STAT_MEM_ECALLOC_AMOUNT
mem_erealloc_count STAT_MEM_EREALLOC_COUNT
mem_erealloc_amount STAT_MEM_EREALLOC_AMOUNT
mem_efree_count STAT_MEM_EFREE_COUNT
mem_efree_amount STAT_MEM_EFREE_AMOUNT
mem_malloc_count STAT_MEM_MALLOC_COUNT
mem_malloc_amount STAT_MEM_MALLOC_AMOUNT
mem_calloc_count STAT_MEM_CALLOC_COUNT
mem_calloc_amount STAT_MEM_CALLOC_AMOUNT
mem_realloc_count STAT_MEM_REALLOC_COUNT
mem_realloc_amount STAT_MEM_REALLOC_AMOUNT
mem_free_count STAT_MEM_FREE_COUNT
mem_free_amount STAT_MEM_FREE_AMOUNT
mem_estrndup_count STAT_MEM_ESTRNDUP_COUNT
mem_strndup_count STAT_MEM_STRNDUP_COUNT
mem_estndup_count STAT_MEM_ESTRDUP_COUNT
mem_strdup_count STAT_MEM_STRDUP_COUNT
proto_text_fetched_null STAT_TEXT_TYPE_FETCHED_NULL
proto_text_fetched_bit STAT_TEXT_TYPE_FETCHED_BIT
proto_text_fetched_tinyint STAT_TEXT_TYPE_FETCHED_INT8
proto_text_fetched_short STAT_TEXT_TYPE_FETCHED_INT16
proto_text_fetched_int24 STAT_TEXT_TYPE_FETCHED_INT24
proto_text_fetched_int STAT_TEXT_TYPE_FETCHED_INT32
proto_text_fetched_bigint STAT_TEXT_TYPE_FETCHED_INT64
proto_text_fetched_decimal STAT_TEXT_TYPE_FETCHED_DECIMAL
proto_text_fetched_float STAT_TEXT_TYPE_FETCHED_FLOAT
proto_text_fetched_double STAT_TEXT_TYPE_FETCHED_DOUBLE
proto_text_fetched_date STAT_TEXT_TYPE_FETCHED_DATE
proto_text_fetched_year STAT_TEXT_TYPE_FETCHED_YEAR
proto_text_fetched_time STAT_TEXT_TYPE_FETCHED_TIME
proto_text_fetched_datetime STAT_TEXT_TYPE_FETCHED_DATETIME
proto_text_fetched_timestamp STAT_TEXT_TYPE_FETCHED_TIMESTAMP
proto_text_fetched_string STAT_TEXT_TYPE_FETCHED_STRING
proto_text_fetched_blob STAT_TEXT_TYPE_FETCHED_BLOB
proto_text_fetched_enum STAT_TEXT_TYPE_FETCHED_ENUM
proto_text_fetched_set STAT_TEXT_TYPE_FETCHED_SET
proto_text_fetched_geometry STAT_TEXT_TYPE_FETCHED_GEOMETRY
proto_text_fetched_other STAT_TEXT_TYPE_FETCHED_OTHER
proto_binary_fetched_null STAT_BINARY_TYPE_FETCHED_NULL
proto_binary_fetched_bit STAT_BINARY_TYPE_FETCHED_BIT
proto_binary_fetched_tinyint STAT_BINARY_TYPE_FETCHED_INT8
proto_binary_fetched_short STAT_BINARY_TYPE_FETCHED_INT16
proto_binary_fetched_int24 STAT_BINARY_TYPE_FETCHED_INT24
proto_binary_fetched_int STAT_BINARY_TYPE_FETCHED_INT32
proto_binary_fetched_bigint STAT_BINARY_TYPE_FETCHED_INT64
proto_binary_fetched_decimal STAT_BINARY_TYPE_FETCHED_DECIMAL
proto_binary_fetched_float STAT_BINARY_TYPE_FETCHED_FLOAT
proto_binary_fetched_double STAT_BINARY_TYPE_FETCHED_DOUBLE
proto_binary_fetched_date STAT_BINARY_TYPE_FETCHED_DATE
proto_binary_fetched_year STAT_BINARY_TYPE_FETCHED_YEAR
proto_binary_fetched_time STAT_BINARY_TYPE_FETCHED_TIME
proto_binary_fetched_datetime STAT_BINARY_TYPE_FETCHED_DATETIME
proto_binary_fetched_timestamp STAT_BINARY_TYPE_FETCHED_TIMESTAMP
proto_binary_fetched_string STAT_BINARY_TYPE_FETCHED_STRING
proto_binary_fetched_blob STAT_BINARY_TYPE_FETCHED_BLOB
proto_binary_fetched_enum STAT_BINARY_TYPE_FETCHED_ENUM
proto_binary_fetched_set STAT_BINARY_TYPE_FETCHED_SET
proto_binary_fetched_geometry STAT_BINARY_TYPE_FETCHED_GEOMETRY
proto_binary_fetched_other STAT_BINARY_TYPE_FETCHED_OTHER
init_command_executed_count STAT_INIT_COMMAND_EXECUTED_COUNT
init_command_failed_count STAT_INIT_COMMAND_FAILED_COUNT
com_quit STAT_COM_QUIT
com_init_db STAT_COM_INIT_DB
com_query STAT_COM_QUERY
com_field_list STAT_COM_FIELD_LIST
com_create_db STAT_COM_CREATE_DB
com_drop_db STAT_COM_DROP_DB
com_refresh STAT_COM_REFRESH
com_shutdown STAT_COM_SHUTDOWN
com_statistics STAT_COM_STATISTICS
com_process_info STAT_COM_PROCESS_INFO
com_connect STAT_COM_CONNECT
com_process_kill STAT_COM_PROCESS_KILL
com_debug STAT_COM_DEBUG
com_ping STAT_COM_PING
com_time STAT_COM_TIME
com_delayed_insert STAT_COM_DELAYED_INSERT
com_change_user STAT_COM_CHANGE_USER
com_binlog_dump STAT_COM_BINLOG_DUMP
com_table_dump STAT_COM_TABLE_DUMP
com_connect_out STAT_COM_CONNECT_OUT
com_register_slave STAT_COM_REGISTER_SLAVE
com_stmt_prepare STAT_COM_STMT_PREPARE
com_stmt_execute STAT_COM_STMT_EXECUTE
com_stmt_send_long_data STAT_COM_STMT_SEND_LONG_DATA
com_stmt_close STAT_COM_STMT_CLOSE
com_stmt_reset STAT_COM_STMT_RESET
com_stmt_set_option STAT_COM_SET_OPTION
com_stmt_fetch STAT_COM_STMT_FETCH
com_deamon STAT_COM_DAEMON
bytes_received_real_data_normal STAT_BYTES_RECEIVED_PURE_DATA_TEXT
bytes_received_real_data_ps STAT_BYTES_RECEIVED_PURE_DATA_PS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment