UESPWiki:Zabbix/mysql-zabbix.stats

#
 # Used by the send_mysql_stats.php script for sending MySQL stats to a Zabbix server.
 # Each line contains a status variable that should be sent. Lines starting with a '#'
 # are ignored as are blank lines.
 # 
 
 #
 # General settings
 #
 clientversion
 version
 
 #
 # Settings
 #
 max_connect_errors
 max_connections
 read_only
 read_rnd_buffer_size
 sort_buffer_size
 table_cache
 thread_cache_size
 thread_stack
 tmp_table_size
 wait_timeout
 
 #
 # General statistics
 #
 Binlog_cache_disk_use
 Binlog_cache_use
 Bytes_received
 Bytes_sent
 Uptime
 
 #
 # Key statistics
 #
 Key_blocks_not_flushed
 Key_blocks_unused
 Key_blocks_used
 Key_read_requests
 Key_reads
 Key_write_requests
 Key_writes
 
 #
 # InnoDB Statistics
 #
 Innodb_buffer_pool_pages_data
 Innodb_buffer_pool_pages_dirty
 Innodb_buffer_pool_pages_flushed
 Innodb_buffer_pool_pages_free
 Innodb_buffer_pool_pages_misc
 Innodb_buffer_pool_pages_total
 Innodb_buffer_pool_read_ahead_rnd
 Innodb_buffer_pool_read_ahead_seq
 Innodb_buffer_pool_read_requests
 Innodb_buffer_pool_reads
 Innodb_buffer_pool_wait_free
 Innodb_buffer_pool_write_requests
 Innodb_data_fsyncs
 Innodb_data_pending_fsyncs
 Innodb_data_pending_reads
 Innodb_data_pending_writes
 Innodb_data_read
 Innodb_data_reads
 Innodb_data_writes
 Innodb_data_written
 Innodb_dblwr_pages_written
 Innodb_dblwr_writes
 Innodb_log_waits
 Innodb_log_write_requests
 Innodb_log_writes
 Innodb_os_log_fsyncs
 Innodb_os_log_pending_fsyncs
 Innodb_os_log_pending_writes
 Innodb_os_log_written
 Innodb_page_size
 Innodb_pages_created
 Innodb_pages_read
 Innodb_pages_written
 Innodb_row_lock_current_waits
 Innodb_row_lock_time
 Innodb_row_lock_time_avg
 Innodb_row_lock_time_max
 Innodb_row_lock_waits
 Innodb_rows_deleted
 Innodb_rows_inserted
 Innodb_rows_read
 Innodb_rows_updated
 
 #
 # Handler Stats
 #
 Handler_commit
 Handler_delete
 Handler_discover
 Handler_prepare
 Handler_read_first
 Handler_read_key
 Handler_read_next
 Handler_read_prev
 Handler_read_rnd
 Handler_read_rnd_next
 Handler_rollback
 Handler_savepoint
 Handler_savepoint_rollback
 Handler_update
 Handler_write
 
 #
 # Slave Status
 #
 Slave_IO_State
 Master_Host
 Master_User
 Master_Port
 Connect_Retry
 Master_Log_File
 Read_Master_Log_Pos
 Relay_Log_File
 Relay_Log_Pos
 Relay_Master_Log_File
 Slave_IO_Running
 Slave_SQL_Running
 Replicate_Do_DB
 Replicate_Ignore_DB
 Replicate_Do_Table
 Replicate_Ignore_Table
 Replicate_Wild_Do_Table
 Replicate_Wild_Ignore_Table
 Last_Errno
 Last_Error
 Skip_Counter
 Exec_Master_Log_Pos
 Relay_Log_Space
 Until_Condition
 Until_Log_File
 Until_Log_Pos
 Master_SSL_Allowed
 Seconds_Behind_Master
 
 #
 # Master Status
 # Note that these stats have 'MasterStatus_' prepended to them to make their origin clearer.
 #
 MasterStatus_File
 MasterStatus_Position
 MasterStatus_Binlog_do_db
 MasterStatus_Binlog_ignore_db
 
 #
 # Privileges (these are computed statistics)
 #
 Insert_priv_count
 Update_priv_count
 Delete_priv_count
 Drop_priv_count
 Shut_down_priv_count
 Process_priv_count
 File_priv_count
 Grant_priv_count
 Alter_priv_count
 Super_priv_count
 Lock_tables_priv_count
 
 #
 # Resources
 #
 Created_tmp_disk_tables
 Created_tmp_files
 Created_tmp_tables
 Max_used_connections
 Not_flushed_delayed_rows
 Open_files
 Open_streams
 Open_tables
 Opened_tables
 Threads_cached
 Threads_connected
 Threads_created
 Threads_running
 
 # 
 # Connection/query stats
 # 
 Aborted_clients
 Aborted_connects
 Connections
 Delayed_errors
 Delayed_insert_threads
 Delayed_writes
 Flush_commands
 Prepared_stmt_count
 Queries
 Questions
 Select_full_join
 Select_full_range_join
 Select_range
 Select_range_check
 Select_scan
 Slave_open_temp_tables
 Slave_retried_transactions
 Slave_running
 Slow_launch_threads
 Slow_queries
 Sort_merge_passes
 Sort_range
 Sort_rows
 Sort_scan
 Table_locks_immediate
 Table_locks_waited
 
 #
 # Query cache settings
 #
 query_cache_limit
 query_cache_min_res_unit
 query_cache_size
 query_cache_type
 query_cache_wlock_invalidate
 
 #
 # Query cache parameters
 #
 Qcache_free_blocks
 Qcache_free_memory
 Qcache_hits
 Qcache_inserts
 Qcache_lowmem_prunes
 Qcache_not_cached
 Qcache_queries_in_cache
 Qcache_total_blocks
 
 #
 # Command statistics
 # 
 Com_admin_commands
 Com_alter_db
 Com_alter_table
 Com_analyze
 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_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_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_load_master_data
 Com_load_master_table
 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_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_table
 Com_show_databases
 Com_show_errors
 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_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