MySQL database server counter reference
Posted: April 21st, 2008 | Author: TnT Admin | Filed under: Concepts | Tags: MySQL | No Comments »
These are the counters provided by running show status command in MySQL (as of this writing, I’m writing based on MySQL 6.0). It will be the same command to retrieve statistics as mentioned in “How-to configure MySQL database monitoring” which you can refer back again to for concept and configuration details. I’ve list down the counters for your convenience at first glance if you are looking for what to monitor in MySQL. I believed that you can agree with me that we are not experts in MySQL during load test projects.
Anyway, the definition of the counters can be found in “MySQL 6.0 Reference Manual :: 5 MySQL Server Administration :: 5.1 The MySQL Server :: 5.1.5 Status Variables” which you should refer to when in doubt.
List of MySQL counters
| Aborted_clients Aborted_connects Binlog_cache_disk_use Binlog_cache_use Bytes_received Bytes_sent Com_admin_commands Com_alter_db Com_alter_event Com_alter_table Com_analyze Com_backup Com_backup_table Com_begin Com_call_procedure Com_change_db Com_change_master Com_check Com_checksum Com_commit Com_create_db Com_create_event Com_create_function Com_create_index Com_create_table Com_create_user Com_dealloc_sql Com_delete Com_delete_multi Com_do Com_drop_db Com_drop_event Com_drop_function Com_drop_index Com_drop_table Com_drop_user Com_execute_sql Com_flush Com_grant Com_ha_close Com_ha_open Com_ha_read Com_help Com_insert Com_insert_select Com_kill Com_load Com_lock_tables Com_optimize Com_preload_keys Com_prepare_sql Com_purge Com_purge_before_date Com_rename_table Com_repair Com_replace Com_replace_select Com_reset Com_restore Com_restore_table Com_revoke Com_revoke_all Com_rollback Com_savepoint Com_select Com_set_option Com_show_binlog_events Com_show_binlogs Com_show_charsets Com_show_collations Com_show_column_types Com_show_create_db Com_show_create_event Com_show_create_table Com_show_databases Com_show_engine_logs Com_show_engine_mutex Com_show_engine_status Com_show_errors Com_show_events Com_show_fields Com_show_grants Com_show_innodb_status Com_show_keys Com_show_logs Com_show_master_status Com_show_ndb_status Com_show_new_master Com_show_open_tables Com_show_plugins Com_show_privileges Com_show_processlist Com_show_slave_hosts Com_show_slave_status Com_show_status Com_show_storage_engines Com_show_tables Com_show_triggers Com_show_variables Com_show_warnings Com_slave_start Com_slave_stop Com_stmt_close Com_stmt_execute Com_stmt_fetch Com_stmt_prepare Com_stmt_reset Com_stmt_send_long_data Com_truncate Com_unlock_tables Com_update Com_update_multi Com_xa_commit Com_xa_end Com_xa_prepare Com_xa_recover Com_xa_rollback Com_xa_start Compression Connections Created_tmp_disk_tables Created_tmp_files Created_tmp_tables |
Delayed_errors
Delayed_insert_threads |
Leave a Reply