Skip navigation links
MySQL Enterprise Monitor 2.1 :: F Data Collection Items
»
Section Navigation      [Toggle]

Appendix F. Data Collection Items

Note

MySQL Enterprise subscription, MySQL Enterprise Monitor, MySQL Replication Monitor, and MySQL Query Analyzer are only available to commercial customers. To learn more, see: http://www.mysql.com/products/enterprise/features.html.

This appendix documents the data collection items used to create rules. These items are listed in the order that they appear in the Data Item drop-down list box when creating a rule definition. For more information about creating and editing rules see Section 6.3, “Editing Built-in Rules” and Section 6.4.2, “Overview of Rule Creation”.

Table F.1. MySQL Monitor Data Items

Namespace Namespace Type Attribute Type Description
agent allocationstats agent_dataitem_spec_alloc long_counter  
agent allocationstats agent_dataitem_spec_free long_counter  
agent allocationstats agent_item_attribute_alloc long_counter  
agent allocationstats agent_item_attribute_free long_counter  
agent allocationstats agent_item_class_alloc long_counter  
agent allocationstats agent_item_class_config_alloc long_counter  
agent allocationstats agent_item_class_config_free long_counter  
agent allocationstats agent_item_class_free long_counter  
agent allocationstats agent_item_classes_alloc long_counter  
agent allocationstats agent_item_classes_free long_counter  
agent allocationstats agent_item_instance_alloc long_counter  
agent allocationstats agent_item_instance_free long_counter  
agent allocationstats agent_item_instance_name_alloc long_counter  
agent allocationstats agent_item_instance_name_free long_counter  
agent allocationstats agent_item_namespaces_alloc long_counter  
agent allocationstats agent_item_namespaces_free long_counter  
agent allocationstats agent_item_value_alloc long_counter  
agent allocationstats agent_item_value_free long_counter  
agent allocationstats agent_mysqld_alloc long_counter  
agent allocationstats agent_mysqld_free long_counter  
agent allocationstats agent_plugin_alloc long_counter  
agent allocationstats agent_plugin_free long_counter  
agent allocationstats agent_target_alloc long_counter  
agent allocationstats agent_target_free long_counter  
agent allocationstats agent_task_alloc long_counter  
agent allocationstats agent_task_free long_counter  
agent allocationstats curl_mem_alloc long_counter  
agent allocationstats curl_mem_bytes long  
agent allocationstats curl_mem_bytes_max long  
agent allocationstats curl_mem_free long_counter  
agent allocationstats job_response_alloc long_counter  
agent allocationstats job_response_data_alloc long_counter  
agent allocationstats job_response_data_free long_counter  
agent allocationstats job_response_datum_alloc long_counter  
agent allocationstats job_response_datum_free long_counter  
agent allocationstats job_response_free long_counter  
agent allocationstats job_response_string_alloc long_counter  
agent allocationstats job_response_string_free long_counter  
agent allocationstats job_task_alloc long_counter  
agent allocationstats job_task_free long_counter  
agent allocationstats network_backlog_alloc long_counter  
agent allocationstats network_backlog_free long_counter  
agent allocationstats network_backlog_node_alloc long_counter  
agent allocationstats network_backlog_node_bytes long  
agent allocationstats network_backlog_node_free long_counter  
agent allocationstats scheduler_job_alloc long_counter  
agent allocationstats scheduler_job_free long_counter  
agent allocationstats xml_mem_alloc long_counter  
agent allocationstats xml_mem_bytes long  
agent allocationstats xml_mem_bytes_max long  
agent allocationstats xml_mem_free long_counter  
agent chassisstats glib_mem_alloc long_counter  
agent chassisstats glib_mem_bytes long  
agent chassisstats glib_mem_bytes_max long  
agent chassisstats glib_mem_free long_counter  
agent chassisstats lua_mem_alloc long_counter  
agent chassisstats lua_mem_bytes long  
agent chassisstats lua_mem_bytes_max long  
agent chassisstats lua_mem_free long_counter  
agent lua mem_size long  
agent proc egid long  
agent proc euid long  
agent proc gid long  
agent proc mem_major_faults long_counter  
agent proc mem_minor_faults long_counter  
agent proc mem_page_faults long_counter  
agent proc mem_resident long  
agent proc mem_share long  
agent proc mem_size long  
agent proc name string  
agent proc nice long  
agent proc ppid long  
agent proc priority long  
agent proc processor long  
agent proc state long  
agent proc threads long  
agent proc time_start_time long  
agent proc time_sys long_counter  
agent proc time_total long_counter  
agent proc time_user long_counter  
agent proc tty long  
agent proc uid long  
monitor resourceBundle subscription string  
monitor resourceBundle version string  
mysql account_old_password user string  
mysql active_count active_count long  
mysql Agent agent.latency long  
mysql Agent agent.reachable string  
mysql Agent host_id string  
mysql Agent name string  
mysql Agent version string  
mysql anonymous_user user_count long  
mysql avail_count avail_count long  
mysql broad_host_specifier user string  
mysql column Default string The default value of the column
mysql column Extra string Any additional information about the column
mysql column Field string The name of the column
mysql column Key string Whether the column is indexed
mysql column Null string Whether NULL is allowed
mysql column Type string The data type of the column
mysql committed_count committed_count long  
mysql Database Database string  
mysql Database name string  
mysql Explain extra string  
mysql Explain id long  
mysql Explain key string  
mysql Explain key_len string  
mysql Explain possible_keys string  
mysql Explain ref string  
mysql Explain rows long  
mysql Explain select_type string  
mysql Explain table string  
mysql Explain type string  
mysql falcon_database_io logical_reads long  
mysql falcon_database_io physical_reads long  
mysql falcon_record_cache_summary total_recordcache_mb double  
mysql falcon_record_cache_summary total_space_mb double  
mysql falcon_system_memory_summary free_system_mb double  
mysql falcon_system_memory_summary total_system_mb double  
mysql falcon_transaction_summary committed_txns long  
mysql falcon_transaction_summary rolled_back_txns long  
mysql global_privileges user string  
mysql grant_privileges user_spec string  
mysql inappropriate_slave_privileges user string  
mysql index Cardinality long An estimate of the number of unique values in the index
mysql index Collation string How the column is sorted in the index
mysql index Column_name string The column name
mysql index Comment string Remarks about the index
mysql index Index_type string The index method used (BTREE, FULLTEXT, HASH, RTREE)
mysql index Key_name string The name of the index
mysql index Non_unique long Whether the index can contain duplicates
mysql index Null string Whether the column may contain NULL values
mysql index Packed string Whether the key is packed
mysql index Seq_in_index long The column sequence number in the index, starting with 1
mysql index Sub_part string The number of indexed characters if the column is only partly indexed
mysql index Table string The name of the table associated with the index
mysql innodbstatus innodb_bp_add_alloc long The total memory allocated for the additional buffer pool measured in bytes
mysql innodbstatus innodb_bp_created_per_sec double The number of buffer pool pages created per second
mysql innodbstatus innodb_bp_db_pages long The current number of buffer pool pages
mysql innodbstatus innodb_bp_free_buffers long The current number of free buffer pool pages
mysql innodbstatus innodb_bp_hit_rate long The buffer pool hit rate
mysql innodbstatus innodb_bp_modified_pages long The current number of pages modified
mysql innodbstatus innodb_bp_pages_created long_counter The total number of pages created
mysql innodbstatus innodb_bp_pages_read long_counter The total number of pages read
mysql innodbstatus innodb_bp_pages_written long_counter The total number of pages written
mysql innodbstatus innodb_bp_pending_pages long The number of pending page writes
mysql innodbstatus innodb_bp_pending_writes_flush_list long The number of pages to be flushed during checkpointing
mysql innodbstatus innodb_bp_pending_writes_lru long The number of old dirty pages to be written from the bottom of the LRU list
mysql innodbstatus innodb_bp_pending_writes_single_page long The number of pending independent page writes
mysql innodbstatus innodb_bp_reads_per_sec double The number of buffer pool reads per second
mysql innodbstatus innodb_bp_size long The total buffer pool size in bytes
mysql innodbstatus innodb_bp_total_alloc long The total memory allocated for the buffer pool
mysql innodbstatus innodb_bp_written_per_sec double The number of buffer pool pages written per second
mysql innodbstatus innodb_bytes_per_read long The number of bytes per read
mysql innodbstatus innodb_datetime string The date and time the SHOW ENGINE INNODB STATUS snapshot was taken
mysql innodbstatus innodb_hash_node_heap long Number of buffer pool pages reserved for the Adaptive Hash Index
mysql innodbstatus innodb_hash_searches_per_sec double The number of hash searches per second
mysql innodbstatus innodb_hash_table_size long The size of the hash table
mysql innodbstatus innodb_hash_used_cells long Number of buffer pool pages used for the Adaptive Hash Index
mysql innodbstatus innodb_ibuf_inserts long_counter The number of insert buffer inserts
mysql innodbstatus innodb_ibuf_merged_recs long_counter The number of insert buffer merged records
mysql innodbstatus innodb_ibuf_merges long_counter The number of insert buffer merges
mysql innodbstatus innodb_io_ibuf_logs long The number of pending log Ios
mysql innodbstatus innodb_io_ibuf_reads long The number of pending insert buffer reads
mysql innodbstatus innodb_io_ibuf_syncs long The number of pending synch operations
mysql innodbstatus innodb_io_os_file_fsyncs long_counter The number of OS fsyncs
mysql innodbstatus innodb_io_os_file_reads long_counter The number of OS file reads
mysql innodbstatus innodb_io_os_file_writes long_counter The number of OS file writes
mysql innodbstatus innodb_io_pending_flush_bp long The number of pending buffer pool flush operations
mysql innodbstatus innodb_io_pending_flush_log long The number of pending log flush operations
mysql innodbstatus innodb_io_pending_reads long The number of I/O pending reads
mysql innodbstatus innodb_io_pending_writes long The number of I/O pending writes
mysql innodbstatus innodb_io_syncs_per_sec double The number of fsyncs() per second
mysql innodbstatus innodb_log_checkpoint_file long The log file number the last checkpoint was performed on
mysql innodbstatus innodb_log_checkpoint_lsn long The log sequence number of the last checkpoint
mysql innodbstatus innodb_log_flushed_file long The log file number the last checkpoint was performed on
mysql innodbstatus innodb_log_flushed_lsn long The point up to which the log was last flushed
mysql innodbstatus innodb_log_io_per_sec double The number of log I/O's per second
mysql innodbstatus innodb_log_io_total long_counter The total number of log I/O's
mysql innodbstatus innodb_log_pending_checkpoint_writes long The log pending checkpoint writes
mysql innodbstatus innodb_log_pending_log_writes long The log pending log writes
mysql innodbstatus innodb_log_sequence_file long The log sequence file number
mysql innodbstatus innodb_log_sequence_lsn long The log sequence number
mysql innodbstatus innodb_non_hash_searches_per_sec double The number of nonadaptive hash index searches
mysql innodbstatus innodb_per_sec_avg double The number of seconds the averages for SHOW INNODB STATUS were calculated from
mysql innodbstatus innodb_reads_per_sec double The number of reads per second
mysql innodbstatus innodb_row_queries_inside long The number of queries executing inside InnoDB
mysql innodbstatus innodb_row_queries_queue long The number of queries in the queue, waiting to enter InnoDB
mysql innodbstatus innodb_row_state string The current state of the main InnoDB thread
mysql innodbstatus innodb_rows_deleted long_counter The number of rows deleted from InnoDB tables
mysql innodbstatus innodb_rows_deleted_per_sec double The number of rows deleted per second
mysql innodbstatus innodb_rows_inserted long_counter The number of rows inserted into InnoDB tables
mysql innodbstatus innodb_rows_inserted_per_sec double The number of rows inserted per second
mysql innodbstatus innodb_rows_read long_counter The number of rows read from InnoDB tables
mysql innodbstatus innodb_rows_read_per_sec double The number of rows read per second
mysql innodbstatus innodb_rows_updated long_counter The number of rows updated in InnoDB tables
mysql innodbstatus innodb_rows_updated_per_sec double The number of rows updated per second
mysql innodbstatus innodb_sem_mutex_os_waits long_counter The number of semaphore/mutex waits yielded to the OS
mysql innodbstatus innodb_sem_mutex_rounds long_counter The number of semaphore/mutex round for the internal sync array
mysql innodbstatus innodb_sem_mutex_spin_waits long_counter The number of semaphore/mutex spin waits for the internal sync array
mysql innodbstatus innodb_sem_os_reservation_count long_counter The number of times a mutex wait was added to the internal sync array
mysql innodbstatus innodb_sem_os_signal_count long_counter Performance.InnoDB
mysql innodbstatus innodb_sem_rw_excl_os_waits long_counter The number of exclusive (write) semaphore waits yielded to the OS
mysql innodbstatus innodb_sem_rw_excl_spins long_counter Performance.InnoDB
mysql innodbstatus innodb_sem_shared_os_waits long_counter The number of shared (read) semaphore waits yielded to the OS
mysql innodbstatus innodb_sem_shared_spins long_counter The number of shared (read) semaphore spin waits within the syn array
mysql innodbstatus innodb_trx_history_list_length long The transaction history list length
mysql innodbstatus innodb_trx_id_counter1 long The transaction counter roll over variable
mysql innodbstatus innodb_trx_id_counter2 long The main transaction count
mysql innodbstatus innodb_trx_purge_done_trx2 long The transaction count that is already purged
mysql innodbstatus innodb_trx_total_lock_structs long  
mysql innodbstatus innodb_writes_per_sec double The number of InnoDB writes per second
mysql locked_processes num_locked long  
mysql long_locked_processes long_running_time double  
mysql long_locked_processes num_long_running long  
mysql long_running_processes long_running_time double  
mysql long_running_processes num_long_running long  
mysql masterlogs File_size long The size of a binary log file
mysql masterlogs filecount long The number of binary log files
mysql masterlogs filesizesum long The total size of all the binary log files
mysql masterlogs Log_name string The name of the binary log file
mysql MasterStatus Binlog_Do_DB string  
mysql MasterStatus Binlog_Ignore_DB string  
mysql MasterStatus File string  
mysql MasterStatus Position long  
mysql no_password user string  
mysql no_root_password no_password long  
mysql num_waiting_txns num_waiting_txns long  
mysql prepared_count prepared_count long  
mysql privileges_on_all_dbs user_spec string  
mysql processlist Command string The type of command the thread is executing
mysql processlist db string The default database, if one is selected
mysql processlist Host string The host name of the client issuing the statement
mysql processlist Id long The connection identifier
mysql processlist Info string The statement that the thread is executing
mysql processlist State string An action, event, or state that indicates what the thread is doing
mysql processlist Time long The time in seconds that the thread has been in its current state
mysql processlist User string The MySQL user who issued the statement
mysql repl_slave_privileges repl_slaves long  
mysql rolledback_count rolledback_count long  
mysql root_account_exists root_account long  
mysql root_remote_login remote_login long  
mysql Server agent.reachable string Whether the agent is reachable or not
mysql Server blackout string  
mysql Server displayname string The display name of the server in the Dashboard
mysql Server registration-complete string  
mysql Server repl.group long  
mysql Server repl.groupName string  
mysql Server server.connected long Whether the server is connected
mysql Server server.last_errno string  
mysql Server server.last_error string The last MySQL server error message
mysql Server server.reachable long Whether the server is reachable
mysql Server server.version_numeric long The MySQL server version number
mysql Server Time long  
mysql Server transport string  
mysql Server visible.displayname string  
mysql server_admin_privileges user_spec string  
mysql SlaveStatus Binlog_Do_DB string  
mysql SlaveStatus Binlog_Ignore_DB string  
mysql SlaveStatus Connect_Retry long  
mysql SlaveStatus Exec_Master_Log_Pos long  
mysql SlaveStatus File string  
mysql SlaveStatus Last_Errno long  
mysql SlaveStatus Last_Error string  
mysql SlaveStatus Last_IO_Errno long  
mysql SlaveStatus Last_IO_Error string  
mysql SlaveStatus Last_SQL_Errno long  
mysql SlaveStatus Last_SQL_Error string  
mysql SlaveStatus Master_Host string  
mysql SlaveStatus Master_ip string  
mysql SlaveStatus Master_Log_File string  
mysql SlaveStatus Master_Port long  
mysql SlaveStatus Master_SSL_Allowed string  
mysql SlaveStatus Master_SSL_CA_File string  
mysql SlaveStatus Master_SSL_CA_Path string  
mysql SlaveStatus Master_SSL_Cert string  
mysql SlaveStatus Master_SSL_Cipher string  
mysql SlaveStatus Master_SSL_Key string  
mysql SlaveStatus Master_User string  
mysql SlaveStatus Master_uuid string  
mysql SlaveStatus Position long  
mysql SlaveStatus Read_Master_Log_Pos long  
mysql SlaveStatus Relay_Log_File string  
mysql SlaveStatus Relay_Log_Pos long  
mysql SlaveStatus Relay_Log_Space long  
mysql SlaveStatus Relay_Master_Log_File string  
mysql SlaveStatus Replicate_Do_DB string  
mysql SlaveStatus Replicate_Do_Table string  
mysql SlaveStatus Replicate_Ignore_DB string  
mysql SlaveStatus Replicate_Ignore_Table string  
mysql SlaveStatus Replicate_Wild_Do_Table string  
mysql SlaveStatus Replicate_Wild_Ignore_Table string  
mysql SlaveStatus Seconds_Behind_Master long  
mysql SlaveStatus Skip_Counter long  
mysql SlaveStatus Slave_IO_Running string  
mysql SlaveStatus Slave_IO_State string  
mysql SlaveStatus Slave_SQL_Running string  
mysql SlaveStatus Until_Condition string  
mysql SlaveStatus Until_Log_File string  
mysql SlaveStatus Until_Log_Pos long  
mysql sp_with_select_star routine string  
mysql Statement bytes long  
mysql Statement comment string  
mysql Statement connection_id long  
mysql Statement errors long  
mysql Statement exec_time long  
mysql Statement host_from string  
mysql Statement host_to string  
mysql Statement max_bytes long  
mysql Statement rows long  
mysql Statement text string  
mysql Statement user string  
mysql Statement warnings long  
mysql StatementAnalysisSupport auto_explain_min_exec_time_ms long  
mysql StatementAnalysisSupport capture_examples string  
mysql StatementAnalysisSupport capture_explain string  
mysql StatementAnalysisSupport enabled string  
mysql StatementAnalysisSupport frequency string  
mysql StatementSummary bytes long  
mysql StatementSummary bytes_rel long  
mysql StatementSummary count long  
mysql StatementSummary count_rel long  
mysql StatementSummary database string  
mysql StatementSummary errors long  
mysql StatementSummary exec_time long  
mysql StatementSummary exec_time_rel long  
mysql StatementSummary max_bytes long  
mysql StatementSummary max_exec_time long  
mysql StatementSummary max_rows long  
mysql StatementSummary min_bytes long  
mysql StatementSummary min_exec_time long  
mysql StatementSummary min_rows long  
mysql StatementSummary query_type string  
mysql StatementSummary rows long  
mysql StatementSummary rows_rel long  
mysql StatementSummary text string  
mysql StatementSummary text_hash string  
mysql StatementSummary warnings long  
mysql status Aborted_clients long_counter Networking.Overview
mysql status Aborted_connects long_counter The number of failed attempts to connect to the MySQL server
mysql status Binlog_cache_disk_use long General.Logging
mysql status Binlog_cache_use long The number of transactions that used the temporary binary log cache
mysql status Bytes_received long_counter The number of bytes received from all clients
mysql status Bytes_sent long_counter The number of bytes sent to all clients
mysql status Com_admin_commands long_counter Count of admin commands
mysql status Com_alter_db long_counter Count of ALTER DATABASE statements
mysql status Com_alter_db_upgrade long_counter  
mysql status Com_alter_event long_counter  
mysql status Com_alter_function long_counter  
mysql status Com_alter_procedure long_counter  
mysql status Com_alter_server long_counter  
mysql status Com_alter_table long_counter Count of ALTER TABLE statements
mysql status Com_alter_tablespace long_counter  
mysql status Com_analyze long_counter Count of ANALYZE statements
mysql status Com_assign_to_keycache long_counter  
mysql status Com_backup_table long_counter Count of BACKUP TABLE statements
mysql status Com_begin long_counter Count of BEGIN statements
mysql status Com_binlog long_counter  
mysql status Com_call_procedure long_counter Number of calls to stored procedures
mysql status Com_change_db long_counter Count of CHANGE DATABASE statements
mysql status Com_change_master long_counter Count of CHANGE MASTER statements
mysql status Com_check long_counter Count of CHECK statements
mysql status Com_checksum long_counter Count of CHECKSUM statements
mysql status Com_commit long_counter Count of COMMIT statements
mysql status Com_create_db long_counter Count of CREATE DATABASE statements
mysql status Com_create_event long_counter  
mysql status Com_create_function long_counter Count of CREATE FUNCTION statements
mysql status Com_create_index long_counter Count of CREATE INDEX statements
mysql status Com_create_procedure long_counter  
mysql status Com_create_server long_counter  
mysql status Com_create_table long_counter Count of CREATE TABLE statements
mysql status Com_create_trigger long_counter  
mysql status Com_create_udf long_counter  
mysql status Com_create_user long_counter Count of CREATE USER statements
mysql status Com_create_view long_counter  
mysql status Com_dealloc_sql long_counter Count of DEALLOCATE PREPARE statements
mysql status Com_delete long_counter Count of DELETE statements
mysql status Com_delete_multi long_counter Count of multiple table DELETE statements
mysql status Com_do long_counter Count of DO statements
mysql status Com_drop_db long_counter Count of DROP DATABASE statements
mysql status Com_drop_event long_counter  
mysql status Com_drop_function long_counter Count of DROP FUNCTION statements
mysql status Com_drop_index long_counter Count of DROP INDEX statements
mysql status Com_drop_procedure long_counter  
mysql status Com_drop_server long_counter  
mysql status Com_drop_table long_counter Count of DROP TABLE statements
mysql status Com_drop_trigger long_counter  
mysql status Com_drop_user long_counter Count of DROP USER statements
mysql status Com_drop_view long_counter  
mysql status Com_empty_query long_counter  
mysql status Com_execute_sql long_counter Count of EXECUTE statements
mysql status Com_flush long_counter Count of FLUSH statements
mysql status Com_grant long_counter Count of GRANT statements
mysql status Com_ha_close long_counter Count of HANDLER CLOSE statements
mysql status Com_ha_open long_counter Count of HANDLER OPEN statements
mysql status Com_ha_read long_counter Count of HANDLER READ statements
mysql status Com_help long_counter Count of HELP statements
mysql status Com_insert long_counter Count of INSERT statements
mysql status Com_insert_select long_counter Count of INSERT SELECT statements
mysql status Com_install_plugin long_counter  
mysql status Com_kill long_counter Count of KILL statements
mysql status Com_load long_counter Count of LOAD statements
mysql status Com_load_master_data long_counter Count of LOAD MASTER DATA statements
mysql status Com_load_master_table long_counter Count of LOAD MASTER TABLE statements
mysql status Com_lock_tables long_counter Count of LOCK TABLES statements
mysql status Com_optimize long_counter Count of OPTIMIZE statements
mysql status Com_preload_keys long_counter Count of PRELOAD KEYS statements
mysql status Com_prepare_sql long_counter Count of PREPARE statements
mysql status Com_purge long_counter Count of PURGE statements
mysql status Com_purge_before_date long_counter Count of PURGE BEFORE DATE statements
mysql status Com_release_savepoint long_counter  
mysql status Com_rename_table long_counter Count of RENAME TABLE statements
mysql status Com_rename_user long_counter  
mysql status Com_repair long_counter Count of REPAIR statements
mysql status Com_replace long_counter Count of REPLACE statements
mysql status Com_replace_select long_counter Count of REPLACE SELECT statements
mysql status Com_reset long_counter Count of RESET statements
mysql status Com_restore_table long_counter Count of RESTORE TABLE statements
mysql status Com_revoke long_counter Count of REVOKE statements
mysql status Com_revoke_all long_counter Count of REVOKE ALL statements
mysql status Com_rollback long_counter Count of ROLLBACK statements
mysql status Com_rollback_to_savepoint long_counter  
mysql status Com_savepoint long_counter Count of SAVEPOINT statements
mysql status Com_select long_counter Count of SELECT statements
mysql status Com_set_option long_counter Count of SET OPTION statements
mysql status Com_show_authors long_counter  
mysql status Com_show_binlog_events long_counter Count of SHOW BINLOG EVENTS statements
mysql status Com_show_binlogs long_counter Count of SHOW BINLOGS statements
mysql status Com_show_charsets long_counter Count of SHOW CHARSETS statements
mysql status Com_show_collations long_counter Count of SHOW COLLATIONS statements
mysql status Com_show_column_types long_counter Count of SHOW COLUMN TYPES statements
mysql status Com_show_contributors long_counter  
mysql status Com_show_create_db long_counter Count of SHOW CREATE DATABASE statements
mysql status Com_show_create_event long_counter  
mysql status Com_show_create_func long_counter  
mysql status Com_show_create_proc long_counter  
mysql status Com_show_create_table long_counter Count of SHOW CREATE TABLE statements
mysql status Com_show_create_trigger long_counter  
mysql status Com_show_databases long_counter Count of SHOW DATABASES statements
mysql status Com_show_engine_logs long_counter  
mysql status Com_show_engine_mutex long_counter  
mysql status Com_show_engine_status long_counter  
mysql status Com_show_errors long_counter Count of SHOW ERRORS statements
mysql status Com_show_events long_counter  
mysql status Com_show_fields long_counter Count of SHOW FIELDS statements
mysql status Com_show_function_status long_counter  
mysql status Com_show_grants long_counter Count of SHOW GRANTS statements
mysql status Com_show_innodb_status long_counter Count of SHOW INNODB STATUS statements
mysql status Com_show_keys long_counter Count of SHOW KEYS statements
mysql status Com_show_logs long_counter Count of SHOW LOGS statements
mysql status Com_show_master_status long_counter Count of SHOW MASTER STATUS statements
mysql status Com_show_ndb_status long_counter Count of SHOW NDB STATUS statements
mysql status Com_show_new_master long_counter Count of SHOW NEW MASTER statements
mysql status Com_show_open_tables long_counter Count of SHOW OPEN TABLES statements
mysql status Com_show_plugins long_counter  
mysql status Com_show_privileges long_counter Count of SHOW PRIVILEGES statements
mysql status Com_show_procedure_status long_counter  
mysql status Com_show_processlist long_counter Count of SHOW PROCESSLIST statements
mysql status Com_show_profile long_counter  
mysql status Com_show_profiles long_counter  
mysql status Com_show_slave_hosts long_counter Count of SHOW SLAVE HOSTS statements
mysql status Com_show_slave_status long_counter Count of SHOW SLAVE STATUS statements
mysql status Com_show_status long_counter Count of SHOW STATUS statements
mysql status Com_show_storage_engines long_counter Count of SHOW STORAGE ENGINES statements
mysql status Com_show_table_status long_counter  
mysql status Com_show_tables long_counter Count of SHOW TABLES statements
mysql status Com_show_triggers long_counter Count of SHOW TRIGGERS statements
mysql status Com_show_variables long_counter Count of SHOW VARIABLES statements
mysql status Com_show_warnings long_counter Count of SHOW WARNINGS statements
mysql status Com_slave_start long_counter Count of SLAVE START statements
mysql status Com_slave_stop long_counter Count of SLAVE STOP statements
mysql status Com_stmt_close long_counter Count of STATEMENT CLOSE statements
mysql status Com_stmt_execute long_counter Count of STATEMENT EXECUTE statements
mysql status Com_stmt_fetch long_counter Count of STATEMENT FETCH statements
mysql status Com_stmt_prepare long_counter Count of STATEMENT PREPARE statements
mysql status Com_stmt_reprepare long_counter  
mysql status Com_stmt_reset long_counter Count of STATEMENT RESET statements
mysql status Com_stmt_send_long_data long_counter Count of STATEMENT SEND LONG DATA statements
mysql status Com_truncate long_counter Count of TRUNCATE statements
mysql status Com_uninstall_plugin long_counter  
mysql status Com_unlock_tables long_counter Count of UNLOCK TABLES statements
mysql status Com_update long_counter Count of UPDATE statements
mysql status Com_update_multi long_counter Count of multiple UPDATE statements
mysql status Com_xa_commit long_counter Count of XA COMMIT statements
mysql status Com_xa_end long_counter Count of XA END statements
mysql status Com_xa_prepare long_counter Count of XA PREPARE statements
mysql status Com_xa_recover long_counter Count of XA RECOVER statements
mysql status Com_xa_rollback long_counter Count of XA ROLLBACK statements
mysql status Com_xa_start long_counter Count of XA START statements
mysql status Compression string General.Features
mysql status Connections long_counter The number of connection attempts
mysql status Created_tmp_disk_tables long_counter General.Temporary
mysql status Created_tmp_files long_counter How many temporary files mysqld has created
mysql status Created_tmp_tables long_counter How many temporary tables mysqld has created
mysql status Delayed_errors long_counter Performance.Delayed
mysql status Delayed_insert_threads long The number of INSERT DELAYED thread handlers in use
mysql status Delayed_writes long_counter The number of INSERT DELAYED rows written
mysql status displayname string The display name of the server in the Dashboard
mysql status Flush_commands long_counter The number of FLUSH statements executed
mysql status groupname string The name of the group to which the server belongs
mysql status Handler_commit long_counter The number of internal COMMIT statements
mysql status Handler_delete long_counter The number of times that rows have been deleted from tables
mysql status Handler_discover long_counter Indicates the number of times that tables have been discovered
mysql status Handler_prepare long_counter A counter for the prepare phase of two-phase commit operations
mysql status Handler_read_first long_counter The number of times the first entry was read from an index
mysql status Handler_read_key long_counter The number of requests to read a row based on a key
mysql status Handler_read_next long_counter The number of requests to read the next row in key order
mysql status Handler_read_prev long_counter The number of requests to read the previous row in key order
mysql status Handler_read_rnd long_counter The number of requests to read a row based on a fixed position
mysql status Handler_read_rnd_next long_counter The number of requests to read the next row in the data file
mysql status Handler_rollback long_counter Miscellaneous.Handler
mysql status Handler_savepoint long_counter The number of requests for a storage engine to place a savepoint
mysql status Handler_savepoint_rollback long_counter The number of requests for a storage engine to roll back to a savepoint
mysql status Handler_update long_counter The number of requests to update a row in a table
mysql status Handler_write long_counter The number of requests to insert a row in a table
mysql status Innodb_buffer_pool_pages_data long The number of pages containing data (dirty or clean)
mysql status Innodb_buffer_pool_pages_dirty long The number of pages currently dirty
mysql status Innodb_buffer_pool_pages_flushed long_counter The number of buffer pool page-flush requests
mysql status Innodb_buffer_pool_pages_free long The number of buffer pool pages free
mysql status Innodb_buffer_pool_pages_latched long The number of latched pages in InnoDB buffer pool
mysql status Innodb_buffer_pool_pages_misc long Performance.InnoDB
mysql status Innodb_buffer_pool_pages_total long The total size of the buffer pool, in pages
mysql status Innodb_buffer_pool_read_ahead_rnd long_counter The number of random read-aheads initiated by InnoDB
mysql status Innodb_buffer_pool_read_ahead_seq long_counter The number of sequential read-aheads initiated by InnoDB
mysql status Innodb_buffer_pool_read_requests long_counter The number of logical read requests InnoDB has done
mysql status Innodb_buffer_pool_reads long_counter Performance.InnoDB
mysql status Innodb_buffer_pool_wait_free long_counter Counts number of waits for pages to be flushed
mysql status Innodb_buffer_pool_write_requests long_counter The number of writes done to the buffer pool
mysql status Innodb_data_fsyncs long_counter The number of fsync() operations so far
mysql status Innodb_data_pending_fsyncs long The current number of pending fsync() operations
mysql status Innodb_data_pending_reads long The current number of pending reads
mysql status Innodb_data_pending_writes long The number of pending writes
mysql status Innodb_data_read long_counter The amount of data read so far, in bytes
mysql status Innodb_data_reads long_counter The total number of data reads
mysql status Innodb_data_writes long_counter The total number of data writes
mysql status Innodb_data_written long_counter The amount of data written in bytes
mysql status Innodb_dblwr_pages_written long_counter The number of doublewrite pages that have been written
mysql status Innodb_dblwr_writes long_counter The number of doublewrite operations that have been performed
mysql status Innodb_log_waits long_counter Performance.InnoDB
mysql status Innodb_log_write_requests long_counter The number of log write requests
mysql status Innodb_log_writes long_counter The number of physical writes to the log
mysql status Innodb_os_log_fsyncs long_counter The number of fsync() writes done to the log file
mysql status Innodb_os_log_pending_fsyncs long The number of pending log file fsync() operations
mysql status Innodb_os_log_pending_writes long The number of pending log file writes
mysql status Innodb_os_log_written long_counter The number of bytes written to the log file
mysql status Innodb_page_size long The compiled-in InnoDB page size
mysql status Innodb_pages_created long_counter The number of pages created
mysql status Innodb_pages_read long_counter The number of pages read
mysql status Innodb_pages_written long_counter The number of pages written
mysql status Innodb_row_lock_current_waits long The number of row locks currently being waited for
mysql status Innodb_row_lock_time long_counter The total time spent in acquiring row locks, in milliseconds
mysql status Innodb_row_lock_time_avg long The average time to acquire a row lock, in milliseconds
mysql status Innodb_row_lock_time_max long The maximum time to acquire a row lock, in milliseconds
mysql status Innodb_row_lock_waits long_counter The number of times a row lock had to be waited for
mysql status Innodb_rows_deleted long_counter The number of rows deleted from InnoDB tables
mysql status Innodb_rows_inserted long_counter The number of rows inserted into InnoDB tables
mysql status Innodb_rows_read long_counter The number of rows read from InnoDB tables
mysql status Innodb_rows_updated long_counter The number of rows updated in InnoDB tables
mysql status Key_blocks_not_flushed long Performance.Keys
mysql status Key_blocks_unused long The number of unused blocks in the key cache
mysql status Key_blocks_used long The number of used blocks in the key cache
mysql status Key_read_requests long_counter The number of requests to read a key block from the cache
mysql status Key_reads long_counter The number of physical reads of a key block from disk
mysql status Key_write_requests long_counter The number of requests to write a key block to the cache
mysql status Key_writes long_counter The number of physical writes of a key block to disk
mysql status Last_query_cost long Performance.Cost
mysql status Max_used_connections long Networking.Overview
mysql status Not_flushed_delayed_rows long The number of rows waiting to be written in INSERT DELAY queues
mysql status Open_files long The number of files that are open
mysql status Open_streams long The number of streams that are open (used mainly for logging)
mysql status Open_table_definitions long  
mysql status Open_tables long The number of tables that are open
mysql status Opened_files long_counter  
mysql status Opened_table_definitions long_counter  
mysql status Opened_tables long_counter The number of tables that have been opened
mysql status Prepared_stmt_count long The current number of prepared statements
mysql status Qcache_free_blocks long The number of free memory blocks in the query cache
mysql status Qcache_free_memory long The amount of free memory for the query cache
mysql status Qcache_hits long_counter The number of query cache hits
mysql status Qcache_inserts long_counter The number of query cache inserts
mysql status Qcache_lowmem_prunes long_counter Performance.Query Cache
mysql status Qcache_not_cached long_counter Performance.Query Cache
mysql status Qcache_queries_in_cache long The number of queries registered in the query cache
mysql status Qcache_total_blocks long The total number of blocks in the query cache
mysql status Questions long_counter The number of statements that clients have sent to the server
mysql status Rpl_status long The status of fail-safe replication (not yet implemented)
mysql status Select_full_join long_counter Performance.Selects
mysql status Select_full_range_join long_counter The number of joins that used a range search on a reference table
mysql status Select_range long_counter The number of joins that used ranges on the first table
mysql status Select_range_check long_counter The number of joins without keys that check for key usage after each row
mysql status Select_scan long_counter The number of joins that did a full scan of the first table
mysql status Slave_open_temp_tables long Networking.Replication
mysql status Slave_retried_transactions long_counter Networking.Replication
mysql status Slave_running string This is ON if this server is a slave that is connected to a master
mysql status Slow_launch_threads long_counter Performance.Slow Items
mysql status Slow_queries long_counter The number of queries that have taken more than long_query_time seconds
mysql status Sort_merge_passes long_counter The number of merge passes that the sort algorithm has had to do
mysql status Sort_range long_counter The number of sorts that were done using ranges
mysql status Sort_rows long_counter The number of sorted rows
mysql status Sort_scan long_counter The number of sorts that were done by scanning the table
mysql status Ssl_accept_renegotiates long_counter The number of renegotiates needed to establish the connection
mysql status Ssl_accepts long_counter The number of attempted SSL connections
mysql status Ssl_callback_cache_hits long_counter The number of callback cache hits
mysql status Ssl_cipher string SSL cipher to use (implies --ssl)
mysql status Ssl_cipher_list string The list of SSL cipher strings
mysql status Ssl_client_connects long_counter The number of attempted connections to an SSL enabled master
mysql status Ssl_connect_renegotiates long_counter Number of renegotiates needed to connect to an SSL-enabled master
mysql status Ssl_ctx_verify_depth long The SSL context verification depth
mysql status Ssl_ctx_verify_mode long The SSL certificate verification mode used by the server
mysql status Ssl_default_timeout long The SSL default timeout
mysql status Ssl_finished_accepts long_counter The number of successful SSL connections to the server
mysql status Ssl_finished_connects long_counter The number of successful SSL slave connections to the server
mysql status Ssl_session_cache_hits long_counter The number of SSL session cache hits
mysql status Ssl_session_cache_misses long_counter The number of SSL session cache misses
mysql status Ssl_session_cache_mode string The SSL session cache mode
mysql status Ssl_session_cache_overflows long_counter The number of SSL cache overflows
mysql status Ssl_session_cache_size long The size of the SSL session cache
mysql status Ssl_session_cache_timeouts long_counter The number of session cache timeouts
mysql status Ssl_sessions_reused long The number of SSL sessions from the cache that were reused
mysql status Ssl_used_session_cache_entries long The number of SSL session cache entries used
mysql status Ssl_verify_depth long Depth of verification for replication SSL connections
mysql status Ssl_verify_mode long Mode of veritifaction for replication SSL connections
mysql status Ssl_version string The SSL version number
mysql status Table_locks_immediate long_counter The number of times that a table lock was acquired immediately
mysql status Table_locks_waited long_counter Performance.Locks
mysql status Tc_log_max_pages_used long General.Logging
mysql status Tc_log_page_size long General.Logging
mysql status Tc_log_page_waits long General.Logging
mysql status Threads_cached long The number of threads in the thread cache
mysql status Threads_connected long The number of currently open connections
mysql status Threads_created long_counter The number of threads created to handle connections
mysql status Threads_running long The number of threads that are not sleeping
mysql status Uptime long The number of seconds the server has been up
mysql strong_privileges user string  
mysql table num_rows long MySQL Network.Table Data
mysql table table_auto_increment long The next AUTO_INCREMENT value
mysql table table_avg_row_length long The average row length
mysql table table_collation string The table's character set and collation
mysql table table_comment string The table comment
mysql table table_create_time string When the data file was created
mysql table table_data_free long The number of allocated but unused bytes
mysql table table_data_length long The length of the data file
mysql table table_engine string The storage engine used by a table
mysql table table_index_length long The length of the index file
mysql table table_max_data_length long The maximum length of the data file
mysql table table_name string The name of a table
mysql table table_row_format string The row storage format (Fixed, Dynamic, Compressed, Redundant, Compact)
mysql table table_version long The version number of the table's .frm file
mysql tables_no_myisam_index_stats table_list string  
mysql tables_no_unique_keys table_list string  
mysql tablestatus Auto_increment long The next AUTO_INCREMENT value
mysql tablestatus Avg_row_length long The average row length
mysql tablestatus Check_time string When the table was last checked
mysql tablestatus Checksum string The live checksum value (if any)
mysql tablestatus Collation string The table's character set
mysql tablestatus Comment string The comment used when creating the table
mysql tablestatus Create_options string Extra options used with CREATE TABLE
mysql tablestatus Create_time string When the table was created
mysql tablestatus Data_free long The number of allocated but unused bytes
mysql tablestatus Data_length long The length of the data file
mysql tablestatus Engine string The storage engine for the table
mysql tablestatus Index_length long The length of the index file
mysql tablestatus Max_data_length long The maximum length of the data file
mysql tablestatus Name string The table name
mysql tablestatus Row_format string The row storage format (Fixed, Dynamic, Compressed, Redundant, Compact).
mysql tablestatus Rows long The number of rows in the table
mysql tablestatus Update_time string When the data file was last updated
mysql tablestatus Version long The version number of the table's .frm file.
mysql test_database Database (test) string  
mysql transactions_in_serial_log transactions_in_serial_log long  
mysql trigger_with_select_star trigger_defn string  
mysql user_on_missing_db db_name string  
mysql user_on_missing_db user string  
mysql variables auto_increment_increment long Auto-increment columns are incremented by this value
mysql variables auto_increment_offset long Offset added to Auto-increment columns
mysql variables autocommit string  
mysql variables automatic_sp_privileges string Creating and dropping stored procedures alters ACLs
mysql variables back_log long The number of outstanding connection requests MySQL can have
mysql variables basedir string General.Directories / Files
mysql variables big_tables string  
mysql variables binlog_cache_size long Memory.Caches
mysql variables binlog_format string  
mysql variables bulk_insert_buffer_size long Size of tree cache used in bulk insert optimization
mysql variables character_set_client string Current client character set
mysql variables character_set_connection string Current connection character set
mysql variables character_set_database string The character set used by the default database
mysql variables character_set_filesystem string Set the file system character set
mysql variables character_set_results string Current result character set
mysql variables character_set_server string SQL.Charsets
mysql variables character_set_system string The character set used by the server for storing identifiers
mysql variables character_sets_dir string Directory where character sets are
mysql variables collation_connection string The collation of the connection
mysql variables collation_database string The collation used by the default database
mysql variables collation_server string Set the default collation
mysql variables completion_type long Default completion type
mysql variables concurrent_insert string Use concurrent insert with MyISAM
mysql variables connect_timeout long Connections.Overview
mysql variables datadir string Path to the database root
mysql variables date_format string The DATE format (For future)
mysql variables datetime_format string The DATETIME/TIMESTAMP format (for future)
mysql variables default_week_format long The default week format used by WEEK() functions
mysql variables delay_key_write string Type of DELAY_KEY_WRITE
mysql variables delayed_insert_limit long General.Performance
mysql variables delayed_insert_timeout long General.Performance
mysql variables delayed_queue_size long General.Performance
mysql variables div_precision_increment long SQL.Formats
mysql variables engine_condition_pushdown string Push supported query conditions to the storage engine
mysql variables error_count long  
mysql variables event_scheduler string  
mysql variables expire_logs_days long General.Miscellaneous
mysql variables flush string Flush tables to disk between SQL commands
mysql variables flush_time long A dedicated thread is created to flush all tables at the given interval
mysql variables foreign_key_checks string  
mysql variables ft_boolean_syntax string List of operators for MATCH ... AGAINST ( ... IN BOOLEAN MODE)
mysql variables ft_max_word_len long SQL.Full Text Search
mysql variables ft_min_word_len long SQL.Full Text Search
mysql variables ft_query_expansion_limit long Number of best matches to use for query expansion
mysql variables ft_stopword_file string Use stopwords from this file instead of built-in list
mysql variables general_log string  
mysql variables general_log_file string  
mysql variables group_concat_max_len long The maximum length of the result of function group_concat
mysql variables have_archive string Whether mysqld supports archive tables
mysql variables have_bdb string Is Berkeley DB supported
mysql variables have_blackhole_engine string Whether mysqld supports BLACKHOLE tables
mysql variables have_community_features string  
mysql variables have_compress string Availability of the zlib compression library
mysql variables have_crypt string Availability of the crypt() system call
mysql variables have_csv string Whether mysqld supports csv tables
mysql variables have_dynamic_loading string Whether mysqld supports dynamic loading of plugins
mysql variables have_example_engine string Whether mysqld supports EXAMPLE tables
mysql variables have_federated_engine string Whether mysqld supports FEDERATED tables
mysql variables have_geometry string Whether mysqld supports spatial data types
mysql variables have_innodb string Whether mysqld supports InnoDB tables
mysql variables have_isam string Whether mysqld supports isam tables
mysql variables have_merge_engine string Whether mysqld supports merge tables
mysql variables have_ndbcluster string Whether mysqld supports NDB Cluster tables
mysql variables have_openssl string Whether mysqld supports ssl connections
mysql variables have_partitioning string  
mysql variables have_query_cache string Whether mysqld supports query cache
mysql variables have_raid string Whether mysqld supports the RAID option
mysql variables have_rtree_keys string General.Features
mysql variables have_ssl string Whether the server supports an SSL connection
mysql variables have_symlink string Is symbolic link support enabled
mysql variables hostname string The name of the server host
mysql variables identity long  
mysql variables init_connect string Command(s) that are executed for each new connection
mysql variables init_file string Read SQL commands from this file at startup
mysql variables init_slave string Command(s) that are executed when a slave connects to a master
mysql variables innodb_adaptive_hash_index string  
mysql variables innodb_additional_mem_pool_size long Memory.Buffers
mysql variables innodb_autoextend_increment long Data file autoextend increment in megabytes
mysql variables innodb_autoinc_lock_mode long  
mysql variables innodb_buffer_pool_awe_mem_mb long Memory.Buffers
mysql variables innodb_buffer_pool_size long Memory.Buffers
mysql variables innodb_checksums string Enable InnoDB checksums validation
mysql variables innodb_commit_concurrency long Helps in performance tuning in heavily concurrent environments
mysql variables innodb_concurrency_tickets long Table Types.InnoDB
mysql variables innodb_data_file_path string Path to individual files and their sizes
mysql variables innodb_data_home_dir string The common part for InnoDB table spaces
mysql variables innodb_doublewrite string Enable InnoDB doublewrite buffer
mysql variables innodb_fast_shutdown long Speeds up the shutdown process of the InnoDB storage engine
mysql variables innodb_file_io_threads long Number of file I/O threads in InnoDB
mysql variables innodb_file_per_table string Stores each InnoDB table to an .ibd file in the database dir
mysql variables innodb_flush_log_at_trx_commit long Table Types.InnoDB
mysql variables innodb_flush_method string With which method to flush data
mysql variables innodb_force_recovery long Table Types.InnoDB
mysql variables innodb_lock_wait_timeout long Table Types.InnoDB
mysql variables innodb_locks_unsafe_for_binlog string Table Types.InnoDB
mysql variables innodb_log_arch_dir string Where full logs should be archived
mysql variables innodb_log_archive string Set to 1 if you want to have logs archived
mysql variables innodb_log_buffer_size long General.Logs
mysql variables innodb_log_file_size long Size of each log file in a log group
mysql variables innodb_log_files_in_group long General.Logs
mysql variables innodb_log_group_home_dir string Path to InnoDB log files
mysql variables innodb_max_dirty_pages_pct long Percentage of dirty pages allowed in bufferpool
mysql variables innodb_max_purge_lag long Desired maximum length of the purge queue (0 = no limit)
mysql variables innodb_mirrored_log_groups long Number of identical copies of log groups we keep for the database
mysql variables innodb_open_files long The maximum number of files that InnoDB keeps open at the same time
mysql variables innodb_rollback_on_timeout string Unknown.Unknown
mysql variables innodb_support_xa string Enable InnoDB support for the XA two-phase commit
mysql variables innodb_sync_spin_loops long Count of spin-loop rounds in InnoDB mutexes
mysql variables innodb_table_locks string Enable InnoDB locking in LOCK TABLES
mysql variables innodb_thread_concurrency long Table Types.InnoDB
mysql variables innodb_thread_sleep_delay long Table Types.InnoDB
mysql variables insert_id long  
mysql variables interactive_timeout long Connections.Overview
mysql variables join_buffer_size long The size of the buffer that is used for full joins
mysql variables keep_files_on_create string  
mysql variables key_buffer_size long The size of the buffer used for index blocks for MyISAM tables
mysql variables key_cache_age_threshold long Memory.Caches
mysql variables key_cache_block_size long The default size of key cache blocks
mysql variables key_cache_division_limit long The minimum percentage of warm blocks in key cache
mysql variables language string Client error messages in given language. May be given as a full path
mysql variables large_files_support string Whether large files are supported
mysql variables large_page_size long General.Features
mysql variables large_pages string Enable support for large pages
mysql variables last_insert_id long  
mysql variables lc_time_names string General.Miscellaneous
mysql variables license string Type of license for the server
mysql variables local_infile string Enable/disable LOAD DATA LOCAL INFILE (takes values 1|0)
mysql variables locked_in_memory long Whether mysqld is locked in memory with --memlock
mysql variables log string Log connections and queries to file
mysql variables log_bin string Enables binary log
mysql variables log_bin_trust_function_creators string General.Logs
mysql variables log_bin_trust_routine_creators string (deprecated) Use log-bin-trust-function-creators
mysql variables log_error string Error log file
mysql variables log_output string  
mysql variables log_queries_not_using_indexes string General.Logs
mysql variables log_slave_updates string General.Logs
mysql variables log_slow_queries string General.Logs
mysql variables log_update string General.Logs
mysql variables log_warnings long Log some not critical warnings to the log file
mysql variables long_query_time long General.Performance
mysql variables low_priority_updates string INSERT/DELETE/UPDATE has lower priority than selects
mysql variables lower_case_file_system string General.Features
mysql variables lower_case_table_names long SQL.Overview
mysql variables max_allowed_packet long Max packetlength to send/receive from to server
mysql variables max_binlog_cache_size long General.Logs
mysql variables max_binlog_size long General.Logs
mysql variables max_connect_errors long Connections.Overview
mysql variables max_connections long The number of simultaneous clients allowed
mysql variables max_delayed_threads long General.Performance
mysql variables max_error_count long Max number of errors/warnings to store for a statement
mysql variables max_heap_table_size long Don't allow creation of heap tables bigger than this
mysql variables max_insert_delayed_threads long This variable is a synonym for max_delayed_threads
mysql variables max_join_size long General.Performance
mysql variables max_length_for_sort_data long Max number of bytes in sorted records
mysql variables max_prepared_stmt_count long Maximum number of prepared statements in the server
mysql variables max_relay_log_size long General.Logs
mysql variables max_seeks_for_key long Limit assumed max number of seeks when looking up rows based on a key
mysql variables max_sort_length long The number of bytes to use when sorting BLOB or TEXT values
mysql variables max_sp_recursion_depth long Maximum stored procedure recursion depth
mysql variables max_tmp_tables long Maximum number of temporary tables a client can keep open at a time
mysql variables max_user_connections long Connections.Overview
mysql variables max_write_lock_count long After this many write locks, allow some read locks to run in between
mysql variables min_examined_row_limit long  
mysql variables multi_range_count long General.Performance
mysql variables myisam_data_pointer_size long Default pointer size to be used for MyISAM tables
mysql variables myisam_max_extra_sort_file_size long Deprecated option
mysql variables myisam_max_sort_file_size long Table Types.MyISAM
mysql variables myisam_recover_options string The value of the --myisam-recover option
mysql variables myisam_repair_threads long Table Types.MyISAM
mysql variables myisam_sort_buffer_size long Memory.Buffers
mysql variables myisam_stats_method string Specifies how MyISAM index statistics collection code should treat NULLs
mysql variables myisam_use_mmap string  
mysql variables named_pipe string Indicates whether the server supports connections over named pipes
mysql variables net_buffer_length long Buffer length for TCP/IP and socket communication
mysql variables net_read_timeout long Connections.Networking
mysql variables net_retry_count long Connections.Networking
mysql variables net_write_timeout long Connections.Networking
mysql variables new string Use very new, possibly 'unsafe' functions
mysql variables old string  
mysql variables old_alter_table string  
mysql variables old_passwords string Use old password encryption method (needed for 4.0 and older clients)
mysql variables open_files_limit long General.Directories / Files
mysql variables optimizer_prune_level long General.Features
mysql variables optimizer_search_depth long Maximum depth of search performed by the query optimizer
mysql variables pid_file string Pid file used by safe_mysqld
mysql variables plugin_dir string  
mysql variables port long Port number to use for connection
mysql variables preload_buffer_size long The size of the buffer that is allocated when preloading indexes
mysql variables prepared_stmt_count long The current number of prepared statements
mysql variables protocol_version long The version of the client/server protocol used by the MySQL server
mysql variables pseudo_thread_id long  
mysql variables query_alloc_block_size long Allocation block size for query parsing and execution
mysql variables query_cache_limit long Don't cache results that are bigger than this
mysql variables query_cache_min_res_unit long Memory.Caches
mysql variables query_cache_size long The memory allocated to store results from old queries
mysql variables query_cache_type string Query cache type
mysql variables query_cache_wlock_invalidate string Invalidate queries in query cache on LOCK for write
mysql variables query_prealloc_size long Persistent buffer for query parsing and execution
mysql variables rand_seed1 long  
mysql variables rand_seed2 long  
mysql variables range_alloc_block_size long Allocation block size for storing ranges during optimization
mysql variables read_buffer_size long Memory.Buffers
mysql variables read_only string Make all nontemporary tables read-only
mysql variables read_rnd_buffer_size long Memory.Buffers
mysql variables relay_log string  
mysql variables relay_log_index string  
mysql variables relay_log_info_file string  
mysql variables relay_log_purge string Determines whether relay logs are purged
mysql variables relay_log_space_limit long Maximum space to use for all relay logs
mysql variables report_host string  
mysql variables report_password string  
mysql variables report_port long  
mysql variables report_user string  
mysql variables rpl_recovery_rank long Not used
mysql variables secure_auth string Disallow authentication for accounts that have old (pre-4.1) passwords
mysql variables secure_file_priv string Unknown.Unknown
mysql variables server_id long General.Overview
mysql variables shared_memory string Whether the server allows shared-memory connections
mysql variables shared_memory_base_name string The name of shared memory to use for shared-memory connections
mysql variables skip_external_locking string Skip system (external) locking
mysql variables skip_networking string Don't allow connection with TCP/IP
mysql variables skip_show_database string Don't allow 'SHOW DATABASE' commands
mysql variables slave_compressed_protocol string Use compression on master/slave protocol
mysql variables slave_exec_mode string  
mysql variables slave_load_tmpdir string General.Replication
mysql variables slave_net_timeout long Connections.Networking
mysql variables slave_skip_errors string General.Replication
mysql variables slave_transaction_retries long General.Replication
mysql variables slow_launch_time long General.Performance
mysql variables slow_query_log string  
mysql variables slow_query_log_file string  
mysql variables socket string Socket file to use for connection
mysql variables sort_buffer_size long Each thread that needs to do a sort allocates a buffer of this size
mysql variables sql_auto_is_null string  
mysql variables sql_big_selects string General.Features
mysql variables sql_big_tables string  
mysql variables sql_buffer_result string  
mysql variables sql_log_bin string  
mysql variables sql_log_off string  
mysql variables sql_log_update string  
mysql variables sql_low_priority_updates string  
mysql variables sql_max_join_size long  
mysql variables sql_mode string Set the SQL server mode
mysql variables sql_notes string If set to 1, warnings of Note level are recorded
mysql variables sql_quote_show_create string  
mysql variables sql_safe_updates string  
mysql variables sql_select_limit long  
mysql variables sql_slave_skip_counter long  
mysql variables sql_warnings string General.Miscellaneous
mysql variables ssl_ca string CA file in PEM format (check OpenSSL docs, implies --ssl)
mysql variables ssl_capath string CA directory (check OpenSSL docs, implies --ssl)
mysql variables ssl_cert string X509 certification in PEM format (implies --ssl)
mysql variables ssl_cipher string SSL cipher to use (implies --ssl)
mysql variables ssl_key string X509 key in PEM format (implies ssl)
mysql variables storage_engine string The default storage engine
mysql variables sync_binlog long Synchronously flush binary log to disk after every #th event
mysql variables sync_frm string Sync .frm to disk on create. Enabled by default
mysql variables sync_replication long Deprecated
mysql variables sync_replication_slave_id long Deprecated
mysql variables sync_replication_timeout long Deprecated
mysql variables system_time_zone string The server system time zone
mysql variables table_cache long Deprecated; use --table_open_cache instead
mysql variables table_definition_cache long  
mysql variables table_lock_wait_timeout long General.Miscellaneous
mysql variables table_open_cache long  
mysql variables table_type string A synonym for storage_engine
mysql variables thread_cache_size long How many threads we should keep in a cache for reuse
mysql variables thread_handling string  
mysql variables thread_stack long The stack size for each thread
mysql variables time_format string The TIME format (for future)
mysql variables time_zone string The current time zone.
mysql variables timed_mutexes string General.Miscellaneous
mysql variables timestamp long  
mysql variables tmp_table_size long Memory.Overview
mysql variables tmpdir string Path for temporary files
mysql variables transaction_alloc_block_size long Allocation block size for transactions to be stored in binary log
mysql variables transaction_prealloc_size long Persistent buffer for transactions to be stored in binary log
mysql variables tx_isolation string The default transaction isolation level
mysql variables unique_checks string  
mysql variables updatable_views_with_limit string SQL.Overview
mysql variables version string Output version information and exit
mysql variables version_comment string General.Overview
mysql variables version_compile_machine string The type of machine or architecture on which MySQL was built
mysql variables version_compile_os string The type of operating system on which MySQL was built
mysql variables wait_timeout long Connections.Overview
mysql variables warning_count long  
mysql waiting_db waiting_db string  
mysql waiting_statement waiting_statement string  
mysql waiting_thread waiting_thread long  
mysql waiting_time waiting_time long  
mysql waiting_user waiting_user string  
os cpu cpu_cache_size long The size of the CPU cache
os cpu cpu_idle long_counter The CPU idle time
os cpu cpu_mhz long The MHz rating of the CPU
os cpu cpu_name string The CPU name
os cpu cpu_sys long_counter CPU system / kernel time
os cpu cpu_user long_counter CPU user space time
os cpu cpu_vendor string The name of the CPU vendor
os cpu cpu_wait long_counter CPU IO wait time
os disk disk_bytes_read long_counter The number of bytes read from disk
os disk disk_bytes_written long_counter The number of bytes written to disk
os disk disk_queue long The size of the disk IO queue
os disk disk_reads long_counter The number of disk reads
os disk disk_rtime long  
os disk disk_servicetime double  
os disk disk_snaptime long  
os disk disk_time long  
os disk disk_writes long_counter The number of disk writes
os disk disk_wtime long  
os disk fs_avail long The amount of available space for the mount point
os disk fs_files long The number of files on the mount point
os disk fs_free_files long The number of free files on the mount point
os disk fs_total long The total amount of space for the mount point
os disk fs_unused long The amount of unused space for the mount point
os disk fs_used long The amount of used space for the mount point
os fs fs_avail long  
os fs fs_dev_name string  
os fs fs_dir_name string  
os fs fs_files long  
os fs fs_flags long  
os fs fs_free_files long  
os fs fs_options string  
os fs fs_sys_type_name string  
os fs fs_total long  
os fs fs_type_name string  
os fs fs_unused long  
os fs fs_used long  
os Host host_id string The host unique identifier
os Host name string  
os loadavg 0 double  
os loadavg 1 double  
os loadavg 2 double  
os mem ram_total long The total amount of available RAM
os mem ram_unused long The total amount of unused RAM
os mem swap_page_in long  
os mem swap_page_out long  
os mem swap_total long The total amount of available swap memory
os mem swap_unused long The total amount of unused swap memory
os net address string The address of the network interface
os net broadcast string The network interface broadcast address
os net description string The network interface description
os net destination string The network interface destination address
os net flags long The network interface flags
os net hwaddr string The network interface MAC address
os net metric long Operating System.Net
os net mtu long The Maximum Transmission Unit
os net name string The network interface name (eth0, eth1 etc.)
os net netmask string The network interface subnet mask
os net rx_bytes long_counter The number of bytes received
os net rx_dropped long_counter The number of received packets dropped
os net rx_errors long_counter The number of received packet errors
os net rx_frame long_counter The number received packet frame errors
os net rx_overruns long_counter The number of received packet overruns
os net rx_packets long_counter The number of packets received
os net speed long The network interface connection speed
os net tx_bytes long_counter The number of bytes transmitted
os net tx_carrier long_counter The number of carrier errors on network transmission
os net tx_collisions long_counter The number of network transmission collisions
os net tx_dropped long_counter The number of network transmissions dropped
os net tx_errors long_counter The number of network transmission errors
os net tx_overruns long_counter The number of network transmission overruns
os net tx_packets long_counter The number of packets transmitted
os net type string The network interface type (ethernet, loopback etc.)
os os os_arch string The architecture of the OS / CPU
os os os_description string Description of the OS
os os os_machine string Machine CPU architecture
os os os_name string The OS name
os os os_patchlevel string The OS patch level
os os os_vendor string The OS vendor
os os os_vendor_code_name string The OS vendor code name
os os os_vendor_name string The OS vendor name
os os os_vendor_version string The OS vendor version number
os os os_version string The OS version number
util LogHistogram 0 long_counter  
util LogHistogram 1 long_counter  
util LogHistogram 10 long_counter  
util LogHistogram 11 long_counter  
util LogHistogram 12 long_counter  
util LogHistogram 13 long_counter  
util LogHistogram 14 long_counter  
util LogHistogram 15 long_counter  
util LogHistogram 16 long_counter  
util LogHistogram 17 long_counter  
util LogHistogram 18 long_counter  
util LogHistogram 19 long_counter  
util LogHistogram 2 long_counter  
util LogHistogram 20 long_counter  
util LogHistogram 21 long_counter  
util LogHistogram 22 long_counter  
util LogHistogram 23 long_counter  
util LogHistogram 24 long_counter  
util LogHistogram 25 long_counter  
util LogHistogram 26 long_counter  
util LogHistogram 27 long_counter  
util LogHistogram 28 long_counter  
util LogHistogram 29 long_counter  
util LogHistogram 3 long_counter  
util LogHistogram 30 long_counter  
util LogHistogram 31 long_counter  
util LogHistogram 32 long_counter  
util LogHistogram 33 long_counter  
util LogHistogram 34 long_counter  
util LogHistogram 35 long_counter  
util LogHistogram 36 long_counter  
util LogHistogram 37 long_counter  
util LogHistogram 38 long_counter  
util LogHistogram 39 long_counter  
util LogHistogram 4 long_counter  
util LogHistogram 40 long_counter  
util LogHistogram 41 long_counter  
util LogHistogram 42 long_counter  
util LogHistogram 43 long_counter  
util LogHistogram 44 long_counter  
util LogHistogram 45 long_counter  
util LogHistogram 46 long_counter  
util LogHistogram 47 long_counter  
util LogHistogram 48 long_counter  
util LogHistogram 49 long_counter  
util LogHistogram 5 long_counter  
util LogHistogram 50 long_counter  
util LogHistogram 51 long_counter  
util LogHistogram 52 long_counter  
util LogHistogram 53 long_counter  
util LogHistogram 54 long_counter  
util LogHistogram 55 long_counter  
util LogHistogram 56 long_counter  
util LogHistogram 57 long_counter  
util LogHistogram 58 long_counter  
util LogHistogram 59 long_counter  
util LogHistogram 6 long_counter  
util LogHistogram 60 long_counter  
util LogHistogram 61 long_counter  
util LogHistogram 62 long_counter  
util LogHistogram 7 long_counter  
util LogHistogram 8 long_counter  
util LogHistogram 9 long_counter  
util LogHistogram base long  
util LogHistogram nul long_counter