Appendix D 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/.

This appendix documents the data collection items used to create rules and graphs. 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 2.3.3, “Editing Built-in Rules” and Section 4.1.3, “Overview of Rule Creation”.

Table D.1 MySQL Monitor Data Items

NamespaceNamespace TypeAttributeTypeDescription
agentallocationstatsagent_dataitem_spec_alloclong_counter 
agentallocationstatsagent_dataitem_spec_freelong_counter 
agentallocationstatsagent_item_attribute_alloclong_counter 
agentallocationstatsagent_item_attribute_freelong_counter 
agentallocationstatsagent_item_class_alloclong_counter 
agentallocationstatsagent_item_class_config_alloclong_counter 
agentallocationstatsagent_item_class_config_freelong_counter 
agentallocationstatsagent_item_class_freelong_counter 
agentallocationstatsagent_item_classes_alloclong_counter 
agentallocationstatsagent_item_classes_freelong_counter 
agentallocationstatsagent_item_instance_alloclong_counter 
agentallocationstatsagent_item_instance_freelong_counter 
agentallocationstatsagent_item_instance_name_alloclong_counter 
agentallocationstatsagent_item_instance_name_freelong_counter 
agentallocationstatsagent_item_namespaces_alloclong_counter 
agentallocationstatsagent_item_namespaces_freelong_counter 
agentallocationstatsagent_item_value_alloclong_counter 
agentallocationstatsagent_item_value_freelong_counter 
agentallocationstatsagent_mysqld_alloclong_counter 
agentallocationstatsagent_mysqld_freelong_counter 
agentallocationstatsagent_plugin_alloclong_counter 
agentallocationstatsagent_plugin_freelong_counter 
agentallocationstatsagent_target_alloclong_counter 
agentallocationstatsagent_target_freelong_counter 
agentallocationstatsagent_task_alloclong_counter 
agentallocationstatsagent_task_freelong_counter 
agentallocationstatscurl_mem_alloclong_counter 
agentallocationstatscurl_mem_byteslong 
agentallocationstatscurl_mem_bytes_maxlong 
agentallocationstatscurl_mem_freelong_counter 
agentallocationstatsjob_response_alloclong_counter 
agentallocationstatsjob_response_data_alloclong_counter 
agentallocationstatsjob_response_data_freelong_counter 
agentallocationstatsjob_response_datum_alloclong_counter 
agentallocationstatsjob_response_datum_freelong_counter 
agentallocationstatsjob_response_freelong_counter 
agentallocationstatsjob_response_string_alloclong_counter 
agentallocationstatsjob_response_string_freelong_counter 
agentallocationstatsjob_task_alloclong_counter 
agentallocationstatsjob_task_freelong_counter 
agentallocationstatsnetwork_backlog_alloclong_counter 
agentallocationstatsnetwork_backlog_freelong_counter 
agentallocationstatsnetwork_backlog_node_alloclong_counter 
agentallocationstatsnetwork_backlog_node_byteslong 
agentallocationstatsnetwork_backlog_node_freelong_counter 
agentallocationstatsscheduler_job_alloclong_counter 
agentallocationstatsscheduler_job_freelong_counter 
agentallocationstatsxml_mem_alloclong_counter 
agentallocationstatsxml_mem_byteslong 
agentallocationstatsxml_mem_bytes_maxlong 
agentallocationstatsxml_mem_freelong_counter 
agentchassisstatsglib_mem_alloclong_counter 
agentchassisstatsglib_mem_byteslong 
agentchassisstatsglib_mem_bytes_maxlong 
agentchassisstatsglib_mem_freelong_counter 
agentchassisstatslua_mem_alloclong_counter 
agentchassisstatslua_mem_byteslong 
agentchassisstatslua_mem_bytes_maxlong 
agentchassisstatslua_mem_freelong_counter 
agentluamem_sizelong 
agentprocegidlong 
agentproceuidlong 
agentprocgidlong 
agentprocmem_major_faultslong_counter 
agentprocmem_minor_faultslong_counter 
agentprocmem_page_faultslong_counter 
agentprocmem_residentlong 
agentprocmem_sharelong 
agentprocmem_sizelong 
agentprocnamestring 
agentprocnicelong 
agentprocppidlong 
agentprocprioritylong 
agentprocprocessorlong 
agentprocstatelong 
agentprocthreadslong 
agentproctime_start_timelong 
agentproctime_syslong_counter 
agentproctime_totallong_counter 
agentproctime_userlong_counter 
agentprocttylong 
agentprocuidlong 
monitorresourceBundlesubscriptionstring 
monitorresourceBundleversionstring 
mysqlaccount_old_passworduserstring 
mysqlactive_countactive_countlong 
mysqlAgentagent.latencylong 
mysqlAgentagent.reachablestring 
mysqlAgenthost_idstring 
mysqlAgentnamestring 
mysqlAgentquanDataOutOfBandstring 
mysqlAgentversionstring 
mysqlanonymous_useruser_countlong 
mysqlauto_increment_limittable_liststring 
mysqlavail_countavail_countlong 
mysqlbroad_host_specifieruserstringA list of users whose host in the mysql.user table meets the condition: WHERE host = '%'; a single string in wiki markup format.
mysqlcluster_data_node_data_memorydata_mem_totallong 
mysqlcluster_data_node_data_memorydata_mem_usedlong 
mysqlcluster_data_node_index_memoryindex_mem_totallong 
mysqlcluster_data_node_index_memoryindex_mem_usedlong 
mysqlcluster_data_node_redo_bufferredo_buffer_totallong 
mysqlcluster_data_node_redo_bufferredo_buffer_usedlong 
mysqlcluster_data_node_redo_logspaceredo_logspace_totallong 
mysqlcluster_data_node_redo_logspaceredo_logspace_usedlong 
mysqlcluster_data_node_undo_bufferundo_buffer_totallong 
mysqlcluster_data_node_undo_bufferundo_buffer_usedlong 
mysqlcluster_data_node_undo_logspaceundo_logspace_totallong 
mysqlcluster_data_node_undo_logspaceundo_logspace_usedlong 
mysqlcluster_data_nodes_not_startednode_liststring 
mysqlcolumnDefaultstringThe default value of the column.
mysqlcolumnExtrastringAny additional information about the column.
mysqlcolumnFieldstringThe name of the column.
mysqlcolumnKeystringWhether the column is indexed.
mysqlcolumnNullstringWhether NULL is allowed.
mysqlcolumnTypestringThe data type of the column.
mysqlcommitted_countcommitted_countlong 
mysqlDatabaseDatabasestring 
mysqlDatabasenamestring 
mysqlExplainextrastring 
mysqlExplainidlong 
mysqlExplainkeystring 
mysqlExplainkey_lenstring 
mysqlExplainpossible_keysstring 
mysqlExplainrefstring 
mysqlExplainrowslong 
mysqlExplainselect_typestring 
mysqlExplaintablestring 
mysqlExplaintypestring 
mysqlfalcon_database_iological_readslong 
mysqlfalcon_database_iophysical_readslong 
mysqlfalcon_record_cache_summarytotal_recordcache_mbdouble 
mysqlfalcon_record_cache_summarytotal_space_mbdouble 
mysqlfalcon_system_memory_summaryfree_system_mbdouble 
mysqlfalcon_system_memory_summarytotal_system_mbdouble 
mysqlfalcon_transaction_summarycommitted_txnslong 
mysqlfalcon_transaction_summaryrolled_back_txnslong 
mysqlglobal_privilegesuserstring 
mysqlgrant_privilegesuser_specstring 
mysqlinappropriate_slave_privilegesuserstring 
mysqlindexCardinalitylongAn estimate of the number of unique values (cardinality) in the index.
mysqlindexCollationstringHow the column is sorted in the index.
mysqlindexColumn_namestringThe column name.
mysqlindexCommentstringRemarks about the index.
mysqlindexIndex_typestringThe index method used (BTREE, FULLTEXT, HASH, RTREE)
mysqlindexKey_namestringThe name of the index.
mysqlindexNon_uniquelongWhether the index can contain duplicates.
mysqlindexNullstringWhether the column may contain NULL values.
mysqlindexPackedstringWhether the key is packed.
mysqlindexSeq_in_indexlongThe column sequence number in the index, starting with 1
mysqlindexSub_partstringThe number of indexed characters if the column is only partly indexed.
mysqlindexTablestringThe name of the table associated with the index.
mysqlinnodb_active_transactionscountlong 
mysqlinnodb_blocked_transactionscountlong 
mysqlinnodb_compression_timecompress_secondslong_counter 
mysqlinnodb_compression_timeuncompress_secondslong_counter 
mysqlinnodb_lock_wait_transactionscountlong 
mysqlinnodb_pluginsinnodb_plugin_liststring 
mysqlinnodbstatusinnodb_bp_add_alloclongThe total memory allocated for the additional buffer pool measured in bytes.
mysqlinnodbstatusinnodb_bp_created_per_secdoubleThe number of buffer pool pages created per second.
mysqlinnodbstatusinnodb_bp_db_pageslongThe current number of buffer pool pages.
mysqlinnodbstatusinnodb_bp_dictionary_alloclongSize in bytes allocated to the data dictionary tables/indexes
mysqlinnodbstatusinnodb_bp_free_bufferslongThe current number of free buffer pool pages.
mysqlinnodbstatusinnodb_bp_hit_ratelongThe buffer pool hit rate.
mysqlinnodbstatusinnodb_bp_io_cur_pageslongThe number of Buffer Pool LRU list pages accessed total, for the last second
mysqlinnodbstatusinnodb_bp_io_sum_pageslongThe number of Buffer Pool LRU list pages accessed total, for the last 50 seconds
mysqlinnodbstatusinnodb_bp_io_unzip_cur_pageslongThe number of Buffer Pool unzip_LRU list pages accessed total, for the last second
mysqlinnodbstatusinnodb_bp_io_unzip_sum_pageslongThe number of Buffer Pool unzip_LRU list pages accessed total, for the last 50 seconds
mysqlinnodbstatusinnodb_bp_lru_lenlongThe size in 16Kb pages of the Buffer Pool LRU list
mysqlinnodbstatusinnodb_bp_modified_pageslongThe current number of pages modified.
mysqlinnodbstatusinnodb_bp_not_young_hit_ratelongThe rate at which pages have been made not young for the past 15 seconds
mysqlinnodbstatusinnodb_bp_old_db_pageslong 
mysqlinnodbstatusinnodb_bp_pages_createdlong_counterThe total number of pages created.
mysqlinnodbstatusinnodb_bp_pages_evicted_no_access_per_secdoubleThe average number of pages evicted without being accessed for the last 15 seconds
mysqlinnodbstatusinnodb_bp_pages_not_younglong_counterThe number of pages made not young in the Buffer Pool LRU list
mysqlinnodbstatusinnodb_bp_pages_not_young_per_secdoubleThe per second average of the pages made young in the Buffer Pool LRU list for the last 15 seconds
mysqlinnodbstatusinnodb_bp_pages_readlong_counterThe total number of pages read.
mysqlinnodbstatusinnodb_bp_pages_read_ahead_per_secdoubleThe average of read ahead operations per second for the last 15 seconds
mysqlinnodbstatusinnodb_bp_pages_writtenlong_counterThe total number of pages written.
mysqlinnodbstatusinnodb_bp_pages_younglong_counterThe number of pages made young in the Buffer Pool LRU list
mysqlinnodbstatusinnodb_bp_pages_young_per_secdouble 
mysqlinnodbstatusinnodb_bp_pending_pageslongThe number of pending page writes.
mysqlinnodbstatusinnodb_bp_pending_writes_flush_listlongThe number of pages to be flushed during checkpointing.
mysqlinnodbstatusinnodb_bp_pending_writes_lrulongThe number of old dirty pages to be written from the bottom of the LRU list.
mysqlinnodbstatusinnodb_bp_pending_writes_single_pagelongThe number of pending independent page writes.
mysqlinnodbstatusinnodb_bp_reads_per_secdoubleThe number of buffer pool reads per second.
mysqlinnodbstatusinnodb_bp_sizelongThe total buffer pool size in bytes.
mysqlinnodbstatusinnodb_bp_total_alloclongThe total memory allocated for the buffer pool.
mysqlinnodbstatusinnodb_bp_unzip_lru_lenlongThe size in 16Kb pages of the Buffer Pool unzip_LRU list
mysqlinnodbstatusinnodb_bp_written_per_secdoubleThe number of buffer pool pages written per second.
mysqlinnodbstatusinnodb_bp_young_hit_ratelongThe rate at which pages have been made young for the past 15 seconds
mysqlinnodbstatusinnodb_bytes_per_readlongThe number of bytes per read.
mysqlinnodbstatusinnodb_datetimestringThe date and time the SHOW ENGINE INNODB STATUS snapshot was taken.
mysqlinnodbstatusinnodb_hash_node_heaplongNumber of buffer pool pages reserved for the Adaptive Hash Index.
mysqlinnodbstatusinnodb_hash_searches_per_secdoubleThe number of hash searches per second.
mysqlinnodbstatusinnodb_hash_table_sizelongThe size of the hash table.
mysqlinnodbstatusinnodb_hash_used_cellslongNumber of buffer pool pages used for the Adaptive Hash Index.
mysqlinnodbstatusinnodb_ibuf_free_list_lenlongThe length of the free list for the Insert Buffer index
mysqlinnodbstatusinnodb_ibuf_insertslong_counterThe number of change buffer inserts.
mysqlinnodbstatusinnodb_ibuf_merged_recslong_counterThe number of change buffer merged records.
mysqlinnodbstatusinnodb_ibuf_mergeslong_counterThe number of change buffer merges.
mysqlinnodbstatusinnodb_ibuf_seg_sizelongThe Insert Buffer index header and tree size, in 16Kb page
mysqlinnodbstatusinnodb_ibuf_sizelongThe Insert Buffer index tree size, in 16Kb pages
mysqlinnodbstatusinnodb_io_ibuf_logslongThe number of pending log I/Os.
mysqlinnodbstatusinnodb_io_ibuf_readslongThe number of pending change buffer reads.
mysqlinnodbstatusinnodb_io_ibuf_syncslongThe number of pending synch operations.
mysqlinnodbstatusinnodb_io_os_file_fsyncslong_counterThe number of OS fsyncs.
mysqlinnodbstatusinnodb_io_os_file_readslong_counterThe number of OS file reads.
mysqlinnodbstatusinnodb_io_os_file_writeslong_counterThe number of OS file writes.
mysqlinnodbstatusinnodb_io_pending_flush_bplongThe number of pending buffer pool flush operations.
mysqlinnodbstatusinnodb_io_pending_flush_loglongThe number of pending log flush operations.
mysqlinnodbstatusinnodb_io_pending_readslongThe number of I/O pending reads.
mysqlinnodbstatusinnodb_io_pending_writeslongThe number of I/O pending writes.
mysqlinnodbstatusinnodb_io_syncs_per_secdoubleThe number of fsyncs() per second.
mysqlinnodbstatusinnodb_log_checkpoint_filelongThe log file number the last checkpoint was performed on.
mysqlinnodbstatusinnodb_log_checkpoint_lsnlongThe log sequence number of the last checkpoint.
mysqlinnodbstatusinnodb_log_checkpoint_lsn64longThe 64-bit variant of innodb_log_checkpoint_lsn (2.3.10+).
mysqlinnodbstatusinnodb_log_flushed_filelongThe log file number the last checkpoint was performed on.
mysqlinnodbstatusinnodb_log_flushed_lsnlongThe point up to which the log was last flushed.
mysqlinnodbstatusinnodb_log_flushed_lsn64longThe 64-bit variant of innodb_log_flushed_lsn (2.3.10+).
mysqlinnodbstatusinnodb_log_io_per_secdoubleThe number of log I/Os per second.
mysqlinnodbstatusinnodb_log_io_totallong_counterThe total number of log I/Os.
mysqlinnodbstatusinnodb_log_pending_checkpoint_writeslongThe log pending checkpoint writes.
mysqlinnodbstatusinnodb_log_pending_log_writeslongThe log pending log writes.
mysqlinnodbstatusinnodb_log_sequence_filelongThe log sequence file number.
mysqlinnodbstatusinnodb_log_sequence_lsnlongThe log sequence number.
mysqlinnodbstatusinnodb_log_sequence_lsn64longThe 64-bit variant of innodb_log_sequence_lsn (2.3.10+).
mysqlinnodbstatusinnodb_main_thd_log_flush_writeslong_counterCount of log flushes initiated within the main thread loop
mysqlinnodbstatusinnodb_main_thd_loops_backgroundlong_counterCount of background loops the main thread has done
mysqlinnodbstatusinnodb_main_thd_loops_flushlong_counterCount of flush loops the main thread has done
mysqlinnodbstatusinnodb_main_thd_loops_one_seclong_counterCount of one second loops the main thread has done
mysqlinnodbstatusinnodb_main_thd_loops_sleepslong_counterCount of sleeps the main thread has done inside the one second loop
mysqlinnodbstatusinnodb_main_thd_loops_ten_seclong_counterCount of ten second loops the main thread has done
mysqlinnodbstatusinnodb_non_hash_searches_per_secdoubleThe number of nonadaptive hash index searches.
mysqlinnodbstatusinnodb_per_sec_avgdoubleThe number of seconds the averages for SHOW INNODB STATUS were calculated from.
mysqlinnodbstatusinnodb_reads_per_secdoubleThe number of reads per second.
mysqlinnodbstatusinnodb_row_queries_insidelongThe number of queries executing inside InnoDB.
mysqlinnodbstatusinnodb_row_queries_queuelongThe number of queries in the queue, waiting to enter InnoDB.
mysqlinnodbstatusinnodb_row_statestringThe current state of the main InnoDB thread.
mysqlinnodbstatusinnodb_rows_deletedlong_counterThe number of rows deleted from InnoDB tables.
mysqlinnodbstatusinnodb_rows_deleted_per_secdoubleThe number of rows deleted per second from InnoDB tables.
mysqlinnodbstatusinnodb_rows_insertedlong_counterThe number of rows inserted into InnoDB tables.
mysqlinnodbstatusinnodb_rows_inserted_per_secdoubleThe number of rows inserted per second into InnoDB tables.
mysqlinnodbstatusinnodb_rows_readlong_counterThe number of rows read from InnoDB tables.
mysqlinnodbstatusinnodb_rows_read_per_secdoubleThe number of rows read per second from InnoDB tables.
mysqlinnodbstatusinnodb_rows_updatedlong_counterThe number of rows updated in InnoDB tables.
mysqlinnodbstatusinnodb_rows_updated_per_secdoubleThe number of rows updated per second in InnoDB tables.
mysqlinnodbstatusinnodb_sem_mutex_os_waitslong_counterThe number of semaphore/mutex waits yielded to the OS.
mysqlinnodbstatusinnodb_sem_mutex_roundslong_counterThe number of semaphore/mutex round for the internal sync array.
mysqlinnodbstatusinnodb_sem_mutex_spin_waitslong_counterThe number of semaphore/mutexspin waits for the internal sync array.
mysqlinnodbstatusinnodb_sem_os_reservation_countlong_counterThe number of times a mutex wait was added to the internal sync array.
mysqlinnodbstatusinnodb_sem_os_signal_countlong_counterPerformance.InnoDB
mysqlinnodbstatusinnodb_sem_rw_excl_os_waitslong_counterThe number of exclusive (write) semaphore waits yielded to the OS.
mysqlinnodbstatusinnodb_sem_rw_excl_roundslong_counterPerformance.InnoDB
mysqlinnodbstatusinnodb_sem_rw_excl_spinslong_counterPerformance.InnoDB
mysqlinnodbstatusinnodb_sem_shared_os_waitslong_counterThe number of shared (read) semaphore waits yielded to the OS.
mysqlinnodbstatusinnodb_sem_shared_roundslong_counterPerformance.InnoDB
mysqlinnodbstatusinnodb_sem_shared_spinslong_counterThe number of shared (read) semaphore spin waits within the sync array.
mysqlinnodbstatusinnodb_sem_spins_per_wait_mutexdoubleRatio of innodb_sem_mutex_rounds to innodb_sem_mutex_spin_waits
mysqlinnodbstatusinnodb_sem_spins_per_wait_rw_excldoubleRatio of RW-Exlusive spin rounds to innodb_sem_rw_excl_spins
mysqlinnodbstatusinnodb_sem_spins_per_wait_rw_shareddoubleRatio of RW-Shared spin rounds to innodb_sem_shared_spins
mysqlinnodbstatusinnodb_trx_history_list_lengthlongThe transaction history list length.
mysqlinnodbstatusinnodb_trx_id_counterlong_counterDecoded decimal representation of the hex transaction ID counter in the latest InnoDB
mysqlinnodbstatusinnodb_trx_id_counter1longThe transaction counter roll over variable.
mysqlinnodbstatusinnodb_trx_id_counter2longThe main transaction count.
mysqlinnodbstatusinnodb_trx_id_counter_strstringThe hex string based transaction ID counter in the latest InnoDB
mysqlinnodbstatusinnodb_trx_purge_done_trx2longThe transaction count that is already purged.
mysqlinnodbstatusinnodb_trx_total_lock_structslong 
mysqlinnodbstatusinnodb_writes_per_secdoubleThe number of InnoDB writes per second.
mysqllocked_processesnum_lockedlong 
mysqllong_locked_processeslong_running_timedouble 
mysqllong_locked_processesnum_long_runninglong 
mysqllong_running_processeslong_running_timedouble 
mysqllong_running_processesnum_long_runninglong 
mysqlmasterlogsFile_sizelongThe size of a binary log file.
mysqlmasterlogsfilecountlongThe number of binary log files.
mysqlmasterlogsfilesizesumlongThe total size of all the binary log files.
mysqlmasterlogsLog_namestringThe name of the binary log file.
mysqlMasterStatusBinlog_Do_DBstring 
mysqlMasterStatusBinlog_Ignore_DBstring 
mysqlMasterStatusFilestring 
mysqlMasterStatusPositionlong 
mysqlmeb_backup_historybackup_destinationstring 
mysqlmeb_backup_historycollected_tsinteger 
mysqlmeb_backup_historycollected_ts_counterinteger 
mysqlmeb_backup_historyend_time_rawstring 
mysqlmeb_backup_historyend_time_tsinteger 
mysqlmeb_backup_historyexit_statestring 
mysqlmeb_backup_historylast_errorstring 
mysqlmeb_backup_historylast_error_codeinteger 
mysqlmeb_backup_historylock_timefloat 
mysqlmeb_backup_historymysql_data_dirstring 
mysqlmeb_backup_historyprogress_logstring 
mysqlmeb_backup_historystart_time_nowstring 
mysqlmeb_backup_historystart_time_tsinteger 
mysqlmeb_backup_historytotal_timeinteger 
mysqlmeb_backup_success_historyload_full_backupstring 
mysqlmeb_incrementaltotal_incrementsinteger 
mysqlmeb_timinglock_timefloat 
mysqlmeb_timingtotal_timeinteger 
mysqlno_passworduserstring 
mysqlno_root_passwordno_passwordlong 
mysqlnum_waiting_txnsnum_waiting_txnslong 
mysqlprepared_countprepared_countlong 
mysqlprivileges_on_all_dbsuser_specstring 
mysqlprocesslistCommandstringThe type of command the thread is executing.
mysqlprocesslistdbstringThe default database, if one is selected.
mysqlprocesslistHoststringThe host name of the client issuing the statement.
mysqlprocesslistIdlongThe connection identifier.
mysqlprocesslistInfostringThe statement that the thread is executing.
mysqlprocesslistStatestringAn action, event, or state that indicates what the thread is doing.
mysqlprocesslistTimelongThe time in seconds that the thread has been in its current state.
mysqlprocesslistUserstringThe MySQL user who issued the statement.
mysqlrepl_slave_privilegesrepl_slaveslong 
mysqlrolledback_countrolledback_countlong 
mysqlroot_account_existsroot_accountlong 
mysqlroot_remote_loginremote_loginlong 
mysqlServerblackoutstring 
mysqlServerdisplaynamestringThe display name of the server in the Dashboard.
mysqlServerregistration-completestring 
mysqlServerrepl.grouplong 
mysqlServerrepl.groupNamestring 
mysqlServerserver.connectedlongWhether the server is connected.
mysqlServerserver.last_errnostring 
mysqlServerserver.last_errorstringThe last MySQL server error message.
mysqlServerserver.reachablelongWhether the server is reachable.
mysqlServerserver.version_numericlongThe MySQL server version number.
mysqlServerTimelong 
mysqlServertransportstring 
mysqlServervisible.displaynamestring 
mysqlserver_admin_privilegesuser_specstring 
mysqlSlaveStatusBinlog_Do_DBstring 
mysqlSlaveStatusBinlog_Ignore_DBstring 
mysqlSlaveStatusConnect_Retrylong 
mysqlSlaveStatusExec_Master_Log_Poslong 
mysqlSlaveStatusFilestring 
mysqlSlaveStatusLast_Errnolong 
mysqlSlaveStatusLast_Errorstring 
mysqlSlaveStatusLast_IO_Errnolong 
mysqlSlaveStatusLast_IO_Errorstring 
mysqlSlaveStatusLast_SQL_Errnolong 
mysqlSlaveStatusLast_SQL_Errorstring 
mysqlSlaveStatusMaster_Hoststring 
mysqlSlaveStatusMaster_ipstring 
mysqlSlaveStatusMaster_Log_Filestring 
mysqlSlaveStatusMaster_Portlong 
mysqlSlaveStatusMaster_SSL_Allowedstring 
mysqlSlaveStatusMaster_SSL_CA_Filestring 
mysqlSlaveStatusMaster_SSL_CA_Pathstring 
mysqlSlaveStatusMaster_SSL_Certstring 
mysqlSlaveStatusMaster_SSL_Cipherstring 
mysqlSlaveStatusMaster_SSL_Keystring 
mysqlSlaveStatusMaster_SSL_Verify_Server_Certstring 
mysqlSlaveStatusMaster_Userstring 
mysqlSlaveStatusMaster_uuidstring 
mysqlSlaveStatusPositionlong 
mysqlSlaveStatusRead_Master_Log_Poslong 
mysqlSlaveStatusRelay_Log_Filestring 
mysqlSlaveStatusRelay_Log_Poslong 
mysqlSlaveStatusRelay_Log_Spacelong 
mysqlSlaveStatusRelay_Master_Log_Filestring 
mysqlSlaveStatusReplicate_Do_DBstring 
mysqlSlaveStatusReplicate_Do_Tablestring 
mysqlSlaveStatusReplicate_Ignore_DBstring 
mysqlSlaveStatusReplicate_Ignore_Tablestring 
mysqlSlaveStatusReplicate_Wild_Do_Tablestring 
mysqlSlaveStatusReplicate_Wild_Ignore_Tablestring 
mysqlSlaveStatusSeconds_Behind_Masterlong 
mysqlSlaveStatusSkip_Counterlong 
mysqlSlaveStatusSlave_IO_Runningstring 
mysqlSlaveStatusSlave_IO_Statestring 
mysqlSlaveStatusSlave_SQL_Runningstring 
mysqlSlaveStatusUntil_Conditionstring 
mysqlSlaveStatusUntil_Log_Filestring 
mysqlSlaveStatusUntil_Log_Poslong 
mysqlsp_with_select_starroutinestring 
mysqlStatementbyteslong 
mysqlStatementcommentstring 
mysqlStatementconnection_idlong 
mysqlStatementdatabasestring 
mysqlStatementerrorslong 
mysqlStatementexec_timelong 
mysqlStatementexplain_planstring 
mysqlStatementhost_fromstring 
mysqlStatementhost_tostring 
mysqlStatementno_good_index_usedlong 
mysqlStatementno_index_usedlong 
mysqlStatementquery_typestring 
mysqlStatementrowslong 
mysqlStatementsource_locationstring 
mysqlStatementtextstring 
mysqlStatementuserstring 
mysqlStatementwarningslong 
mysqlStatementAnalysisSupportauto_explain_min_exec_time_mslong 
mysqlStatementAnalysisSupportcapture_examplesstring 
mysqlStatementAnalysisSupportcapture_explainstring 
mysqlStatementAnalysisSupportenabledstring 
mysqlStatementAnalysisSupportfrequencystring 
mysqlStatementSummaryavg_exec_timestring 
mysqlStatementSummarybyteslong 
mysqlStatementSummarybytes_rellong 
mysqlStatementSummarycountlong 
mysqlStatementSummarycount_rellong 
mysqlStatementSummarydatabasestring 
mysqlStatementSummaryerrorslong 
mysqlStatementSummaryexec_timelong 
mysqlStatementSummaryexec_time_rellong 
mysqlStatementSummarymax_byteslong 
mysqlStatementSummarymax_exec_timelong 
mysqlStatementSummarymax_rowslong 
mysqlStatementSummarymin_byteslong 
mysqlStatementSummarymin_exec_timelong 
mysqlStatementSummarymin_rowslong 
mysqlStatementSummaryno_good_index_usedlong 
mysqlStatementSummaryno_index_usedlong 
mysqlStatementSummaryquery_typestring 
mysqlStatementSummaryrowslong 
mysqlStatementSummaryrows_rellong 
mysqlStatementSummarytextstring 
mysqlStatementSummarytext_hashstring 
mysqlStatementSummarywarningslong 
mysqlstatusAborted_clientslong_counterNetworking.Overview
mysqlstatusAborted_connectslong_counterThe number of failed attempts to connect to the MySQL server.
mysqlstatusBinlog_cache_disk_uselong_counterGeneral.Logging
mysqlstatusBinlog_cache_uselong_counterThe number of transactions that used the temporary binary log cache.
mysqlstatusBytes_receivedlong_counterThe number of bytes received from all clients.
mysqlstatusBytes_sentlong_counterThe number of bytes sent to all clients.
mysqlstatusCom_admin_commandslong_counterCount of admin commands.
mysqlstatusCom_alter_dblong_counterCount of ALTER DATABASE statements.
mysqlstatusCom_alter_db_upgradelong_counter 
mysqlstatusCom_alter_eventlong_counter 
mysqlstatusCom_alter_functionlong_counter 
mysqlstatusCom_alter_procedurelong_counter 
mysqlstatusCom_alter_serverlong_counter 
mysqlstatusCom_alter_tablelong_counterCount of ALTER TABLE statements.
mysqlstatusCom_alter_tablespacelong_counter 
mysqlstatusCom_analyzelong_counterCount of ANALYZE statements.
mysqlstatusCom_assign_to_keycachelong_counter 
mysqlstatusCom_backup_tablelong_counterCount of BACKUP TABLE statements.
mysqlstatusCom_beginlong_counterCount of BEGIN statements.
mysqlstatusCom_binloglong_counter 
mysqlstatusCom_call_procedurelong_counterNumber of calls to stored procedures.
mysqlstatusCom_change_dblong_counterCount of CHANGE DATABASE statements.
mysqlstatusCom_change_masterlong_counterCount of CHANGE MASTER statements.
mysqlstatusCom_checklong_counterCount of CHECK statements.
mysqlstatusCom_checksumlong_counterCount of CHECKSUM statements.
mysqlstatusCom_commitlong_counterCount of COMMIT statements.
mysqlstatusCom_create_dblong_counterCount of CREATE DATABASE statements.
mysqlstatusCom_create_eventlong_counter 
mysqlstatusCom_create_functionlong_counterCount of CREATE FUNCTION statements.
mysqlstatusCom_create_indexlong_counterCount of CREATE INDEX statements.
mysqlstatusCom_create_procedurelong_counter 
mysqlstatusCom_create_serverlong_counter 
mysqlstatusCom_create_tablelong_counterCount of CREATE TABLE statements.
mysqlstatusCom_create_triggerlong_counter 
mysqlstatusCom_create_udflong_counter 
mysqlstatusCom_create_userlong_counterCount of CREATE USER statements.
mysqlstatusCom_create_viewlong_counter 
mysqlstatusCom_dealloc_sqllong_counterCount of DEALLOCATE PREPARE statements.
mysqlstatusCom_deletelong_counterCount of DELETE statements.
mysqlstatusCom_delete_multilong_counterCount of multi-table DELETE statements.
mysqlstatusCom_dolong_counterCount of DO statements.
mysqlstatusCom_drop_dblong_counterCount of DROP DATABASE statements.
mysqlstatusCom_drop_eventlong_counter 
mysqlstatusCom_drop_functionlong_counterCount of DROP FUNCTION statements.
mysqlstatusCom_drop_indexlong_counterCount of DROP INDEX statements.
mysqlstatusCom_drop_procedurelong_counter 
mysqlstatusCom_drop_serverlong_counter 
mysqlstatusCom_drop_tablelong_counterCount of DROP TABLE statements.
mysqlstatusCom_drop_triggerlong_counter 
mysqlstatusCom_drop_userlong_counterCount of DROP USER statements.
mysqlstatusCom_drop_viewlong_counter 
mysqlstatusCom_empty_querylong_counter 
mysqlstatusCom_execute_sqllong_counterCount of EXECUTE statements.
mysqlstatusCom_flushlong_counterCount of FLUSH statements.
mysqlstatusCom_grantlong_counterCount of GRANT statements.
mysqlstatusCom_ha_closelong_counterCount of HANDLER CLOSE statements.
mysqlstatusCom_ha_openlong_counterCount of HANDLER OPEN statements.
mysqlstatusCom_ha_readlong_counterCount of HANDLER READ statements.
mysqlstatusCom_helplong_counterCount of HELP statements.
mysqlstatusCom_insertlong_counterCount of INSERT statements.
mysqlstatusCom_insert_selectlong_counterCount of INSERT SELECT statements.
mysqlstatusCom_install_pluginlong_counter 
mysqlstatusCom_killlong_counterCount of KILL statements.
mysqlstatusCom_loadlong_counterCount of LOAD statements.
mysqlstatusCom_load_master_datalong_counterCount of LOAD MASTER DATA statements.
mysqlstatusCom_load_master_tablelong_counterCount of LOAD MASTER TABLE statements.
mysqlstatusCom_lock_tableslong_counterCount of LOCK TABLES statements.
mysqlstatusCom_optimizelong_counterCount of OPTIMIZE statements.
mysqlstatusCom_preload_keyslong_counterCount of PRELOAD KEYS statements.
mysqlstatusCom_prepare_sqllong_counterCount of PREPARE statements.
mysqlstatusCom_purgelong_counterCount of PURGE statements.
mysqlstatusCom_purge_before_datelong_counterCount of PURGE BEFORE DATE statements.
mysqlstatusCom_release_savepointlong_counter 
mysqlstatusCom_rename_tablelong_counterCount of RENAME TABLE statements.
mysqlstatusCom_rename_userlong_counter 
mysqlstatusCom_repairlong_counterCount of REPAIR statements.
mysqlstatusCom_replacelong_counterCount of REPLACE statements.
mysqlstatusCom_replace_selectlong_counterCount of REPLACE SELECT statements.
mysqlstatusCom_resetlong_counterCount of RESET statements.
mysqlstatusCom_restore_tablelong_counterCount of RESTORE TABLE statements.
mysqlstatusCom_revokelong_counterCount of REVOKE statements.
mysqlstatusCom_revoke_alllong_counterCount of REVOKE ALL statements.
mysqlstatusCom_rollbacklong_counterCount of ROLLBACK statements.
mysqlstatusCom_rollback_to_savepointlong_counter 
mysqlstatusCom_savepointlong_counterCount of SAVEPOINT statements.
mysqlstatusCom_selectlong_counterCount of SELECT statements.
mysqlstatusCom_set_optionlong_counterCount of SET OPTION statements.
mysqlstatusCom_show_authorslong_counter 
mysqlstatusCom_show_binlog_eventslong_counterCount of SHOW BINLOG EVENTS statements.
mysqlstatusCom_show_binlogslong_counterCount of SHOW BINLOGS statements.
mysqlstatusCom_show_charsetslong_counterCount of SHOW CHARSETS statements.
mysqlstatusCom_show_collationslong_counterCount of SHOW COLLATIONS statements.
mysqlstatusCom_show_column_typeslong_counterCount of SHOW COLUMN TYPES statements.
mysqlstatusCom_show_contributorslong_counter 
mysqlstatusCom_show_create_dblong_counterCount of SHOW CREATE DATABASE statements.
mysqlstatusCom_show_create_eventlong_counter 
mysqlstatusCom_show_create_funclong_counter 
mysqlstatusCom_show_create_proclong_counter 
mysqlstatusCom_show_create_tablelong_counterCount of SHOW CREATE TABLE statements.
mysqlstatusCom_show_create_triggerlong_counter 
mysqlstatusCom_show_databaseslong_counterCount of SHOW DATABASES statements.
mysqlstatusCom_show_engine_logslong_counter 
mysqlstatusCom_show_engine_mutexlong_counter 
mysqlstatusCom_show_engine_statuslong_counter 
mysqlstatusCom_show_errorslong_counterCount of SHOW ERRORS statements.
mysqlstatusCom_show_eventslong_counter 
mysqlstatusCom_show_fieldslong_counterCount of SHOW FIELDS statements.
mysqlstatusCom_show_function_statuslong_counter 
mysqlstatusCom_show_grantslong_counterCount of SHOW GRANTS statements.
mysqlstatusCom_show_innodb_statuslong_counterCount of SHOW INNODB STATUS statements.
mysqlstatusCom_show_keyslong_counterCount of SHOW KEYS statements.
mysqlstatusCom_show_logslong_counterCount of SHOW LOGS statements.
mysqlstatusCom_show_master_statuslong_counterCount of SHOW MASTER STATUS statements.
mysqlstatusCom_show_ndb_statuslong_counterCount of SHOW NDB STATUS statements.
mysqlstatusCom_show_new_masterlong_counterCount of SHOW NEW MASTER statements.
mysqlstatusCom_show_open_tableslong_counterCount of SHOW OPEN TABLES statements.
mysqlstatusCom_show_pluginslong_counter 
mysqlstatusCom_show_privilegeslong_counterCount of SHOW PRIVILEGES statements.
mysqlstatusCom_show_procedure_statuslong_counter 
mysqlstatusCom_show_processlistlong_counterCount of SHOW PROCESSLIST statements.
mysqlstatusCom_show_profilelong_counter 
mysqlstatusCom_show_profileslong_counter 
mysqlstatusCom_show_slave_hostslong_counterCount of SHOW SLAVE HOSTS statements.
mysqlstatusCom_show_slave_statuslong_counterCount of SHOW SLAVE STATUS statements.
mysqlstatusCom_show_statuslong_counterCount of SHOW STATUS statements.
mysqlstatusCom_show_storage_engineslong_counterCount of SHOW STORAGE ENGINES statements.
mysqlstatusCom_show_table_statuslong_counter 
mysqlstatusCom_show_tableslong_counterCount of SHOW TABLES statements.
mysqlstatusCom_show_triggerslong_counterCount of SHOW TRIGGERS statements.
mysqlstatusCom_show_variableslong_counterCount of SHOW VARIABLES statements.
mysqlstatusCom_show_warningslong_counterCount of SHOW WARNINGS statements.
mysqlstatusCom_slave_startlong_counterCount of START SLAVE statements.
mysqlstatusCom_slave_stoplong_counterCount of STOP SLAVE statements.
mysqlstatusCom_stmt_closelong_counterCount of STATEMENT CLOSE statements.
mysqlstatusCom_stmt_executelong_counterCount of STATEMENT EXECUTE statements.
mysqlstatusCom_stmt_fetchlong_counterCount of STATEMENT FETCH statements.
mysqlstatusCom_stmt_preparelong_counterCount of STATEMENT PREPARE statements.
mysqlstatusCom_stmt_repreparelong_counter 
mysqlstatusCom_stmt_resetlong_counterCount of STATEMENT RESET statements.
mysqlstatusCom_stmt_send_long_datalong_counterCount of STATEMENT SEND LONG DATA statements.
mysqlstatusCom_truncatelong_counterCount of TRUNCATE statements.
mysqlstatusCom_uninstall_pluginlong_counter 
mysqlstatusCom_unlock_tableslong_counterCount of UNLOCK TABLES statements.
mysqlstatusCom_updatelong_counterCount of UPDATE statements.
mysqlstatusCom_update_multilong_counterCount of multi-table UPDATE statements.
mysqlstatusCom_xa_commitlong_counterCount of XA COMMIT statements.
mysqlstatusCom_xa_endlong_counterCount of XA END statements.
mysqlstatusCom_xa_preparelong_counterCount of XA PREPARE statements.
mysqlstatusCom_xa_recoverlong_counterCount of XA RECOVER statements.
mysqlstatusCom_xa_rollbacklong_counterCount of XA ROLLBACK statements.
mysqlstatusCom_xa_startlong_counterCount of XA START statements.
mysqlstatusCompressionstringGeneral.Features
mysqlstatusConnectionslong_counterThe number of connection attempts.
mysqlstatusCreated_tmp_disk_tableslong_counterGeneral.Temporary
mysqlstatusCreated_tmp_fileslong_counterHow many temporary files mysqld has created.
mysqlstatusCreated_tmp_tableslong_counterHow many temporary tables mysqld has created.
mysqlstatusDelayed_errorslong_counterPerformance.Delayed
mysqlstatusDelayed_insert_threadslongThe number of INSERT DELAYED thread handlers in use. For non-transactional tables only.
mysqlstatusDelayed_writeslong_counterThe number of INSERT DELAYED rows written. For non-transactional tables only.
mysqlstatusdisplaynamestringThe display name of the server in the Dashboard.
mysqlstatusFlush_commandslong_counterThe number of FLUSH statements executed.
mysqlstatusgroupnamestringThe name of the group to which the server belongs.
mysqlstatusHandler_commitlong_counterThe number of internal COMMIT statements.
mysqlstatusHandler_deletelong_counterThe number of times that rows have been deleted from tables.
mysqlstatusHandler_discoverlong_counterThe number of times that tables have been discovered.
mysqlstatusHandler_preparelong_counterA counter for the prepare phase of two-phase commit operations.
mysqlstatusHandler_read_firstlong_counterThe number of times the first entry was read from an index.
mysqlstatusHandler_read_keylong_counterThe number of requests to read a row based on a key.
mysqlstatusHandler_read_nextlong_counterThe number of requests to read the next row in key order.
mysqlstatusHandler_read_prevlong_counterThe number of requests to read the previous row in key order.
mysqlstatusHandler_read_rndlong_counterThe number of requests to read a row based on a fixed position.
mysqlstatusHandler_read_rnd_nextlong_counterThe number of requests to read the next row in the data file.
mysqlstatusHandler_rollbacklong_counterMiscellaneous.Handler
mysqlstatusHandler_savepointlong_counterThe number of requests for a storage engine to place a savepoint.
mysqlstatusHandler_savepoint_rollbacklong_counterThe number of requests for a storage engine to roll back to a savepoint.
mysqlstatusHandler_updatelong_counterThe number of requests to update a row in a table.
mysqlstatusHandler_writelong_counterThe number of requests to insert a row in a table.
mysqlstatusInnodb_buffer_pool_pages_datalongThe number of pages containing data (dirty or clean)
mysqlstatusInnodb_buffer_pool_pages_dirtylongThe number of pages currently dirty in the InnoDB buffer pool.
mysqlstatusInnodb_buffer_pool_pages_flushedlong_counterThe number of page flush requests in the InnoDB buffer pool.
mysqlstatusInnodb_buffer_pool_pages_freelongThe number of InnoDB buffer pool pages free.
mysqlstatusInnodb_buffer_pool_pages_latchedlongThe number of latched pages in InnoDB buffer pool.
mysqlstatusInnodb_buffer_pool_pages_misclongPerformance.InnoDB
mysqlstatusInnodb_buffer_pool_pages_totallongThe total size of the InnoDB buffer pool, in pages.
mysqlstatusInnodb_buffer_pool_read_ahead_rndlong_counterThe number of random read-aheads initiated by InnoDB.
mysqlstatusInnodb_buffer_pool_read_ahead_seqlong_counterThe number of sequential read-aheads initiated by InnoDB.
mysqlstatusInnodb_buffer_pool_read_requestslong_counterThe number of logical read requests InnoDB has done.
mysqlstatusInnodb_buffer_pool_readslong_counterPerformance.InnoDB
mysqlstatusInnodb_buffer_pool_wait_freelong_counterNumber of waits for pages to be flushed.
mysqlstatusInnodb_buffer_pool_write_requestslong_counterThe number of writes done to the InnoDB buffer pool.
mysqlstatusInnodb_data_fsyncslong_counterThe number of fsync() operations so far.
mysqlstatusInnodb_data_pending_fsyncslongThe current number of pending fsync() operations.
mysqlstatusInnodb_data_pending_readslongThe current number of pending reads.
mysqlstatusInnodb_data_pending_writeslongThe number of pending writes.
mysqlstatusInnodb_data_readlong_counterThe amount of data read so far, in bytes.
mysqlstatusInnodb_data_readslong_counterThe total number of data reads.
mysqlstatusInnodb_data_writeslong_counterThe total number of data writes.
mysqlstatusInnodb_data_writtenlong_counterThe amount of data written in bytes.
mysqlstatusInnodb_dblwr_pages_writtenlong_counterThe number of doublewrite pages that have been written.
mysqlstatusInnodb_dblwr_writeslong_counterThe number of doublewrite operations that have been performed.
mysqlstatusInnodb_log_waitslong_counterPerformance.InnoDB
mysqlstatusInnodb_log_write_requestslong_counterThe number of log write requests.
mysqlstatusInnodb_log_writeslong_counterThe number of physical writes to the log.
mysqlstatusInnodb_os_log_fsyncslong_counterThe number of fsync() writes done to the log file.
mysqlstatusInnodb_os_log_pending_fsyncslongThe number of pending log file fsync() operations.
mysqlstatusInnodb_os_log_pending_writeslongThe number of pending log file writes.
mysqlstatusInnodb_os_log_writtenlong_counterThe number of bytes written to the log file.
mysqlstatusInnodb_page_sizelongThe compiled-in InnoDB page size.
mysqlstatusInnodb_pages_createdlong_counterThe number of pages created.
mysqlstatusInnodb_pages_readlong_counterThe number of pages read.
mysqlstatusInnodb_pages_writtenlong_counterThe number of pages written.
mysqlstatusInnodb_row_lock_current_waitslongThe number of row locks currently being waited for.
mysqlstatusInnodb_row_lock_timelong_counterThe total time spent in acquiring row locks, in milliseconds.
mysqlstatusInnodb_row_lock_time_avglongThe average time to acquire a row lock, in milliseconds.
mysqlstatusInnodb_row_lock_time_maxlongThe maximum time to acquire a row lock, in milliseconds.
mysqlstatusInnodb_row_lock_waitslong_counterThe number of times a row lock had to be waited for.
mysqlstatusInnodb_rows_deletedlong_counterThe number of rows deleted from InnoDB tables.
mysqlstatusInnodb_rows_insertedlong_counterThe number of rows inserted into InnoDB tables.
mysqlstatusInnodb_rows_readlong_counterThe number of rows read from InnoDB tables.
mysqlstatusInnodb_rows_updatedlong_counterThe number of rows updated in InnoDB tables.
mysqlstatusKey_blocks_not_flushedlongPerformance.Keys
mysqlstatusKey_blocks_unusedlongThe number of unused blocks in the key cache.
mysqlstatusKey_blocks_usedlongThe number of used blocks in the key cache.
mysqlstatusKey_read_requestslong_counterThe number of requests to read a key block from the cache.
mysqlstatusKey_readslong_counterThe number of physical reads of a key block from disk.
mysqlstatusKey_write_requestslong_counterThe number of requests to write a key block to the cache.
mysqlstatusKey_writeslong_counterThe number of physical writes of a key block to disk.
mysqlstatusLast_query_costlongPerformance.Cost
mysqlstatusMax_used_connectionslongNetworking.Overview
mysqlstatusNdb_number_of_data_nodeslong 
mysqlstatusNdb_number_of_ready_data_nodeslong 
mysqlstatusNot_flushed_delayed_rowslongThe number of rows waiting to be written in INSERT DELAY queues. For non-transactional tables only.
mysqlstatusOpen_fileslongThe number of files that are open.
mysqlstatusOpen_streamslongThe number of streams that are open (used mainly for logging)
mysqlstatusOpen_table_definitionslong 
mysqlstatusOpen_tableslongThe number of tables that are open.
mysqlstatusOpened_fileslong_counter 
mysqlstatusOpened_table_definitionslong_counter 
mysqlstatusOpened_tableslong_counterThe number of tables that have been opened.
mysqlstatusPrepared_stmt_countlongThe current number of prepared statements.
mysqlstatusQcache_free_blockslongThe number of free memory blocks in the query cache.
mysqlstatusQcache_free_memorylongThe amount of free memory for the query cache.
mysqlstatusQcache_hitslong_counterThe number of query cache hits.
mysqlstatusQcache_insertslong_counterThe number of query cache inserts.
mysqlstatusQcache_lowmem_pruneslong_counterPerformance.Query Cache
mysqlstatusQcache_not_cachedlong_counterPerformance.Query Cache
mysqlstatusQcache_queries_in_cachelongThe number of queries registered in the query cache.
mysqlstatusQcache_total_blockslongThe total number of blocks in the query cache.
mysqlstatusQuerieslong_counter 
mysqlstatusQuestionslong_counterThe number of statements that clients have sent to the server.
mysqlstatusRpl_statuslongThe status of fail-safe replication (not yet implemented)
mysqlstatusSelect_full_joinlong_counterPerformance.Selects
mysqlstatusSelect_full_range_joinlong_counterThe number of joins that used a range search on a reference table.
mysqlstatusSelect_rangelong_counterThe number of joins that used ranges on the first table.
mysqlstatusSelect_range_checklong_counterThe number of joins without keys that check for key usage after each row.
mysqlstatusSelect_scanlong_counterThe number of joins that did a full scan of the first table.
mysqlstatusSlave_open_temp_tableslongNetworking.Replication
mysqlstatusSlave_retried_transactionslong_counterNetworking.Replication
mysqlstatusSlave_runningstringThis is ON if this server is a slave that is connected to a master.
mysqlstatusSlow_launch_threadslong_counterPerformance.Slow Items
mysqlstatusSlow_querieslong_counterThe number of queries that have taken more than long_query_time seconds.
mysqlstatusSort_merge_passeslong_counterThe number of merge passes that the sort algorithm has had to do.
mysqlstatusSort_rangelong_counterThe number of sorts that were done using ranges.
mysqlstatusSort_rowslong_counterThe number of sorted rows.
mysqlstatusSort_scanlong_counterThe number of sorts that were done by scanning the table.
mysqlstatusSsl_accept_renegotiateslong_counterThe number of renegotiates needed to establish the connection.
mysqlstatusSsl_acceptslong_counterThe number of attempted SSL connections.
mysqlstatusSsl_callback_cache_hitslong_counterThe number of callback cache hits.
mysqlstatusSsl_cipherstringSSL cipher to use (implies --ssl)
mysqlstatusSsl_cipher_liststringThe list of SSL cipher strings.
mysqlstatusSsl_client_connectslong_counterThe number of attempted connections to an SSL-enabled master.
mysqlstatusSsl_connect_renegotiateslong_counterNumber of renegotiates needed to connect to an SSL-enabled master.
mysqlstatusSsl_ctx_verify_depthlongThe SSL context verification depth.
mysqlstatusSsl_ctx_verify_modelongThe SSL certificate verification mode used by the server.
mysqlstatusSsl_default_timeoutlongThe SSL default timeout.
mysqlstatusSsl_finished_acceptslong_counterThe number of successful SSL connections to the server.
mysqlstatusSsl_finished_connectslong_counterThe number of successful SSL slave connections to the server.
mysqlstatusSsl_session_cache_hitslong_counterThe number of SSL session cache hits.
mysqlstatusSsl_session_cache_misseslong_counterThe number of SSL session cache misses.
mysqlstatusSsl_session_cache_modestringThe SSL session cache mode.
mysqlstatusSsl_session_cache_overflowslong_counterThe number of SSL cache overflows.
mysqlstatusSsl_session_cache_sizelongThe size of the SSL session cache.
mysqlstatusSsl_session_cache_timeoutslong_counterThe number of session cache timeouts.
mysqlstatusSsl_sessions_reusedlongThe number of SSL sessions from the cache that were reused.
mysqlstatusSsl_used_session_cache_entrieslongThe number of SSL session cache entries used.
mysqlstatusSsl_verify_depthlongDepth of verification for replication SSL connections.
mysqlstatusSsl_verify_modelongMode of verification for replication SSL connections.
mysqlstatusSsl_versionstringThe SSL version number.
mysqlstatusTable_locks_immediatelong_counterThe number of times that a table lock was acquired immediately.
mysqlstatusTable_locks_waitedlong_counterPerformance.Locks
mysqlstatusTc_log_max_pages_usedlongGeneral.Logging
mysqlstatusTc_log_page_sizelongGeneral.Logging
mysqlstatusTc_log_page_waitslongGeneral.Logging
mysqlstatusThreads_cachedlongThe number of threads in the thread cache.
mysqlstatusThreads_connectedlongThe number of currently open connections.
mysqlstatusThreads_createdlong_counterThe number of threads created to handle connections.
mysqlstatusThreads_runninglongThe number of threads that are not sleeping.
mysqlstatusUptimelongThe number of seconds the server has been up.
mysqlstatusUptime_since_flush_statuslong_counter 
mysqlstrong_privilegesuserstring 
mysqltablenum_rowslongMySQL Network.Table Data
mysqltabletable_auto_incrementlongThe next AUTO_INCREMENT value.
mysqltabletable_avg_row_lengthlongThe average row length.
mysqltabletable_collationstringThe table's character set and collation.
mysqltabletable_commentstringThe table comment.
mysqltabletable_create_timestringWhen the data file was created.
mysqltabletable_data_freelongThe number of allocated but unused bytes.
mysqltabletable_data_lengthlongThe length of the data file.
mysqltabletable_enginestringThe storage engine used by a table.
mysqltabletable_index_lengthlongThe length of the index file.
mysqltabletable_max_data_lengthlongThe maximum length of the data file.
mysqltabletable_namestringThe name of a table.
mysqltabletable_row_formatstringThe row storage format (Fixed, Dynamic, Compressed, Redundant, Compact)
mysqltabletable_versionlongThe version number of the table's .frm file.
mysqltables_no_myisam_index_statstable_liststring 
mysqltables_no_unique_keystable_liststring 
mysqltablestatusAuto_incrementlongThe next AUTO_INCREMENT value.
mysqltablestatusAvg_row_lengthlongThe average row length.
mysqltablestatusCheck_timestringWhen the table was last checked.
mysqltablestatusChecksumstringThe live checksum value (if any)
mysqltablestatusCollationstringThe table's character set.
mysqltablestatusCommentstringThe comment used when creating the table.
mysqltablestatusCreate_optionsstringExtra options used with CREATE TABLE
mysqltablestatusCreate_timestringWhen the table was created.
mysqltablestatusData_freelongThe number of allocated but unused bytes.
mysqltablestatusData_lengthlongThe length of the data file.
mysqltablestatusEnginestringThe storage engine for the table.
mysqltablestatusIndex_lengthlongThe length of the index file.
mysqltablestatusMax_data_lengthlongThe maximum length of the data file.
mysqltablestatusNamestringThe table name.
mysqltablestatusRow_formatstringThe row storage format (Fixed, Dynamic, Compressed, Redundant, Compact).
mysqltablestatusRowslongThe number of rows in the table.
mysqltablestatusUpdate_timestringWhen the data file was last updated.
mysqltablestatusVersionlongThe version number of the table's .frm file.
mysqltest_databaseDatabase (test)string 
mysqltransactions_in_serial_logtransactions_in_serial_loglong 
mysqltrigger_with_select_startrigger_defnstring 
mysqluser_on_missing_dbdb_namestring 
mysqluser_on_missing_dbuserstring 
mysqluser_on_missing_tableuserstring 
mysqlvariablesauto_increment_incrementlongAuto-increment columns are incremented by this value.
mysqlvariablesauto_increment_offsetlongOffset added to auto-increment columns.
mysqlvariablesautocommitstring 
mysqlvariablesautomatic_sp_privilegesstringCreating and dropping stored procedures alters ACLs.
mysqlvariablesback_loglongThe number of outstanding connection requests MySQL can have.
mysqlvariablesbasedirstringGeneral.Directories / Files
mysqlvariablesbig_tablesstring 
mysqlvariablesbinlog_cache_sizelongMemory.Caches
mysqlvariablesbinlog_direct_non_transactional_updatesstring 
mysqlvariablesbinlog_formatstring 
mysqlvariablesbulk_insert_buffer_sizelongSize of tree cache used in bulk insert optimization.
mysqlvariablescharacter_set_clientstringCurrent client character set.
mysqlvariablescharacter_set_connectionstringCurrent connection character set.
mysqlvariablescharacter_set_databasestringThe character set used by the default database.
mysqlvariablescharacter_set_filesystemstringSet the file system character set.
mysqlvariablescharacter_set_resultsstringCurrent result character set.
mysqlvariablescharacter_set_serverstringSQL.Charsets
mysqlvariablescharacter_set_systemstringThe character set used by the server for storing identifiers.
mysqlvariablescharacter_sets_dirstringDirectory where character sets are.
mysqlvariablescollation_connectionstringThe collation of the connection.
mysqlvariablescollation_databasestringThe collation used by the default database.
mysqlvariablescollation_serverstringSet the default collation.
mysqlvariablescompletion_typelongDefault completion type.
mysqlvariablesconcurrent_insertlongUse concurrent insert with MyISAM.
mysqlvariablesconnect_timeoutlongConnections.Overview
mysqlvariablesdatadirstringPath to the database root.
mysqlvariablesdate_formatstringThe DATE format (For future)
mysqlvariablesdatetime_formatstringThe DATETIME/TIMESTAMP format (for future)
mysqlvariablesdefault_week_formatlongThe default week format used by WEEK() functions.
mysqlvariablesdelay_key_writestringType of DELAY_KEY_WRITE.
mysqlvariablesdelayed_insert_limitlongGeneral.Performance
mysqlvariablesdelayed_insert_timeoutlongGeneral.Performance
mysqlvariablesdelayed_queue_sizelongGeneral.Performance
mysqlvariablesdiv_precision_incrementlongSQL.Formats
mysqlvariablesengine_condition_pushdownstringPush supported query conditions to the storage engine.
mysqlvariableserror_countlong 
mysqlvariablesevent_schedulerstring 
mysqlvariablesexpire_logs_dayslongGeneral.Miscellaneous
mysqlvariablesflushstringFlush tables to disk between SQL commands.
mysqlvariablesflush_timelongA dedicated thread is created to flush all tables at the given interval.
mysqlvariablesforeign_key_checksstring 
mysqlvariablesft_boolean_syntaxstringList of operators for MATCH ... AGAINST ( ... IN BOOLEAN MODE).
mysqlvariablesft_max_word_lenlongSQL.Full Text Search
mysqlvariablesft_min_word_lenlongSQL.Full Text Search
mysqlvariablesft_query_expansion_limitlongNumber of best matches to use for query expansion.
mysqlvariablesft_stopword_filestringUse stopwords from this file instead of built-in list.
mysqlvariablesgeneral_logstring 
mysqlvariablesgeneral_log_filestring 
mysqlvariablesgroup_concat_max_lenlongThe maximum length of the result of function group_concat.
mysqlvariableshave_archivestringWhether mysqld supports archive tables.
mysqlvariableshave_bdbstringIs Berkeley DB supported.
mysqlvariableshave_blackhole_enginestringWhether mysqld supports BLACKHOLE tables.
mysqlvariableshave_community_featuresstring 
mysqlvariableshave_compressstringAvailability of the zlib compression library.
mysqlvariableshave_cryptstringAvailability of the crypt() system call.
mysqlvariableshave_csvstringWhether mysqld supports csv tables.
mysqlvariableshave_dynamic_loadingstringWhether mysqld supports dynamic loading of plugins.
mysqlvariableshave_example_enginestringWhether mysqld supports EXAMPLE tables.
mysqlvariableshave_federated_enginestringWhether mysqld supports FEDERATED tables.
mysqlvariableshave_geometrystringWhether mysqld supports spatial data types.
mysqlvariableshave_innodbstringWhether mysqld supports InnoDB tables. No longer used as of MEM 2.3.13.
mysqlvariableshave_isamstringWhether mysqld supports isam tables.
mysqlvariableshave_merge_enginestringWhether mysqld supports merge tables.
mysqlvariableshave_ndbclusterstringWhether mysqld supports NDB Cluster tables.
mysqlvariableshave_opensslstringWhether mysqld supports SSL connections.
mysqlvariableshave_partitioningstring 
mysqlvariableshave_profilingstring 
mysqlvariableshave_query_cachestringWhether mysqld supports query cache.
mysqlvariableshave_raidstringWhether mysqld supports the RAID option.
mysqlvariableshave_rtree_keysstringGeneral.Features
mysqlvariableshave_sslstringWhether the server supports an SSL connection.
mysqlvariableshave_symlinkstringIs symbolic link support enabled.
mysqlvariableshostnamestringThe name of the server host.
mysqlvariablesidentitylong 
mysqlvariablesignore_builtin_innodbstring 
mysqlvariablesinit_connectstringCommand(s) that are executed for each new connection.
mysqlvariablesinit_filestringRead SQL commands from this file at startup.
mysqlvariablesinit_slavestringCommand(s) that are executed when a slave connects to a master.
mysqlvariablesinnodb_adaptive_flushingstring 
mysqlvariablesinnodb_adaptive_hash_indexstring 
mysqlvariablesinnodb_additional_mem_pool_sizelongMemory.Buffers
mysqlvariablesinnodb_autoextend_incrementlongAmount by which InnoDB auto-extends the data files for a tablespace, in megabytes.
mysqlvariablesinnodb_autoinc_lock_modelong 
mysqlvariablesinnodb_buffer_pool_awe_mem_mblongMemory.Buffers
mysqlvariablesinnodb_buffer_pool_sizelongMemory.Buffers
mysqlvariablesinnodb_change_bufferingstring 
mysqlvariablesinnodb_checksumsstringEnable InnoDB checksums validation.
mysqlvariablesinnodb_commit_concurrencylongHelps in performance tuning in heavily concurrent environments.
mysqlvariablesinnodb_concurrency_ticketslongTable Types.InnoDB
mysqlvariablesinnodb_data_file_pathstringPath to individual files and their sizes.
mysqlvariablesinnodb_data_home_dirstringThe common location for InnoDB tablespaces
mysqlvariablesinnodb_doublewritestringEnable InnoDB doublewrite buffer
mysqlvariablesinnodb_fast_shutdownlongSpeeds up the shutdown process of the InnoDB storage engine by deferring cleanup operations until the server restarts.
mysqlvariablesinnodb_file_formatstring 
mysqlvariablesinnodb_file_format_checkstring 
mysqlvariablesinnodb_file_io_threadslongNumber of file I/O threads in InnoDB.
mysqlvariablesinnodb_file_per_tablestringStores each InnoDB table and associated indexes in an .ibd file in the database directory.
mysqlvariablesinnodb_flush_log_at_trx_commitlongTable Types.InnoDB
mysqlvariablesinnodb_flush_methodstringWith which method to flush data.
mysqlvariablesinnodb_force_recoverylongTable Types.InnoDB
mysqlvariablesinnodb_io_capacitylong 
mysqlvariablesinnodb_lock_wait_timeoutlongTable Types.InnoDB
mysqlvariablesinnodb_locks_unsafe_for_binlogstringTable Types.InnoDB
mysqlvariablesinnodb_log_arch_dirstringWhere full logs should be archived.
mysqlvariablesinnodb_log_archivestringSet to 1 to have logs archived.
mysqlvariablesinnodb_log_buffer_sizelongGeneral.Logs
mysqlvariablesinnodb_log_file_sizelongSize of each log file in a log group.
mysqlvariablesinnodb_log_files_in_grouplongGeneral.Logs
mysqlvariablesinnodb_log_group_home_dirstringPath to InnoDB log files.
mysqlvariablesinnodb_max_dirty_pages_pctlongPercentage of dirty pages allowed in InnoDB buffer pool.
mysqlvariablesinnodb_max_purge_laglongDesired maximum length of the purge queue (0 = no limit)
mysqlvariablesinnodb_mirrored_log_groupslongNumber of identical copies of log groups to keep for the database.
mysqlvariablesinnodb_old_blocks_pctlong 
mysqlvariablesinnodb_old_blocks_timelong 
mysqlvariablesinnodb_open_fileslongThe maximum number of files that InnoDB keeps open at the same time.
mysqlvariablesinnodb_read_ahead_thresholdlong 
mysqlvariablesinnodb_read_io_threadslong 
mysqlvariablesinnodb_rollback_on_timeoutstringUnknown.Unknown
mysqlvariablesinnodb_spin_wait_delaylong 
mysqlvariablesinnodb_stats_on_metadatastring 
mysqlvariablesinnodb_stats_sample_pageslong 
mysqlvariablesinnodb_strict_modestring 
mysqlvariablesinnodb_support_xastringEnable InnoDB support for the XA two-phase commit.
mysqlvariablesinnodb_sync_spin_loopslongCount of spin-loop rounds in InnoDB mutexes
mysqlvariablesinnodb_table_locksstringEnable InnoDB locking in LOCK TABLES
mysqlvariablesinnodb_thread_concurrencylongTable Types.InnoDB
mysqlvariablesinnodb_thread_sleep_delaylongTable Types.InnoDB
mysqlvariablesinnodb_use_legacy_cardinality_algorithmstringApplies only to MySQL 5.1 and earlier.
mysqlvariablesinnodb_use_sys_mallocstring 
mysqlvariablesinnodb_write_io_threadslong 
mysqlvariablesinsert_idlong 
mysqlvariablesinteractive_timeoutlongConnections.Overview
mysqlvariablesjoin_buffer_sizelongThe size of the buffer that is used for full joins.
mysqlvariableskeep_files_on_createstring 
mysqlvariableskey_buffer_sizelongThe size of the buffer used for index blocks for MyISAM tables.
mysqlvariableskey_cache_age_thresholdlongMemory.Caches
mysqlvariableskey_cache_block_sizelongThe default size of key cache blocks.
mysqlvariableskey_cache_division_limitlongThe minimum percentage of warm blocks in the key cache.
mysqlvariableslanguagestringClient error messages in given language. May be given as a full path.
mysqlvariableslarge_files_supportstringWhether large files are supported.
mysqlvariableslarge_page_sizelongGeneral.Features
mysqlvariableslarge_pagesstringEnable support for large pages.
mysqlvariableslast_insert_idlong 
mysqlvariableslc_time_namesstringGeneral.Miscellaneous
mysqlvariableslicensestringType of license for the server.
mysqlvariableslocal_infilestringEnable/disable LOAD DATA LOCAL INFILE (takes values 1|0)
mysqlvariableslocked_in_memorystringWhether mysqld is locked in memory with --memlock.
mysqlvariableslogstringLog connections and queries to file.
mysqlvariableslog_binstringEnables binary log.
mysqlvariableslog_bin_trust_function_creatorsstringGeneral.Logs
mysqlvariableslog_bin_trust_routine_creatorsstring(deprecated) Use log-bin-trust-function-creators.
mysqlvariableslog_errorstringError log file.
mysqlvariableslog_outputstring 
mysqlvariableslog_queries_not_using_indexesstringGeneral.Logs
mysqlvariableslog_slave_updatesstringGeneral.Logs
mysqlvariableslog_slow_queriesstringGeneral.Logs
mysqlvariableslog_updatestringGeneral.Logs
mysqlvariableslog_warningslongLog some not critical warnings to the log file.
mysqlvariableslong_query_timedoubleGeneral.Performance
mysqlvariableslow_priority_updatesstringFor non-transactional tables, INSERT, DELETE, and UPDATE statements have lower priority than SELECT statements.
mysqlvariableslower_case_file_systemstringGeneral.Features
mysqlvariableslower_case_table_nameslongSQL.Overview
mysqlvariablesmax_allowed_packetlongMax packetlength to send/receive from to server.
mysqlvariablesmax_binlog_cache_sizelongGeneral.Logs
mysqlvariablesmax_binlog_sizelongGeneral.Logs
mysqlvariablesmax_connect_errorslongConnections.Overview
mysqlvariablesmax_connectionslongThe number of simultaneous clients allowed.
mysqlvariablesmax_delayed_threadslongGeneral.Performance
mysqlvariablesmax_error_countlongMax number of errors/warnings to store for a statement.
mysqlvariablesmax_heap_table_sizelongDon't allow creation of heap tables bigger than this.
mysqlvariablesmax_insert_delayed_threadslongThis variable is a synonym for max_delayed_threads.
mysqlvariablesmax_join_sizelongGeneral.Performance
mysqlvariablesmax_length_for_sort_datalongMax number of bytes in sorted records.
mysqlvariablesmax_prepared_stmt_countlongMaximum number of prepared statements in the server.
mysqlvariablesmax_relay_log_sizelongGeneral.Logs
mysqlvariablesmax_seeks_for_keylongLimit assumed max number of seeks when looking up rows based on a key.
mysqlvariablesmax_sort_lengthlongThe number of bytes to use when sorting BLOB or TEXT values.
mysqlvariablesmax_sp_recursion_depthlongMaximum stored procedure recursion depth.
mysqlvariablesmax_tmp_tableslongMaximum number of temporary tables a client can keep open at a time.
mysqlvariablesmax_user_connectionslongConnections.Overview
mysqlvariablesmax_write_lock_countlongAfter this many write locks, allow some read locks to run in between.
mysqlvariablesmin_examined_row_limitlong 
mysqlvariablesmulti_range_countlongGeneral.Performance
mysqlvariablesmyisam_data_pointer_sizelongDefault pointer size to be used for MyISAM tables.
mysqlvariablesmyisam_max_extra_sort_file_sizelongDeprecated option.
mysqlvariablesmyisam_max_sort_file_sizelongTable Types.MyISAM
mysqlvariablesmyisam_mmap_sizelong 
mysqlvariablesmyisam_recover_optionsstringThe value of the --myisam-recover option.
mysqlvariablesmyisam_repair_threadslongTable Types.MyISAM
mysqlvariablesmyisam_sort_buffer_sizelongMemory.Buffers
mysqlvariablesmyisam_stats_methodstringSpecifies how MyISAM index statistics collection code should treat NULLs.
mysqlvariablesmyisam_use_mmapstring 
mysqlvariablesnamed_pipestringIndicates whether the server supports connections over named pipes.
mysqlvariablesnet_buffer_lengthlongBuffer length for TCP/IP and socket communication.
mysqlvariablesnet_read_timeoutlongConnections.Networking
mysqlvariablesnet_retry_countlongConnections.Networking
mysqlvariablesnet_write_timeoutlongConnections.Networking
mysqlvariablesnewstringUse very new, possibly 'unsafe' functions.
mysqlvariablesoldstring 
mysqlvariablesold_alter_tablestring 
mysqlvariablesold_passwordsstringUse old password encryption method (needed for 4.0 and older clients)
mysqlvariablesopen_files_limitlongGeneral.Directories / Files
mysqlvariablesoptimizer_prune_levellongGeneral.Features
mysqlvariablesoptimizer_search_depthlongMaximum depth of search performed by the query optimizer.
mysqlvariablesoptimizer_switchstring 
mysqlvariablespid_filestringPid file used by safe_mysqld.
mysqlvariablesplugin_dirstring 
mysqlvariablesportlongPort number to use for connection.
mysqlvariablespreload_buffer_sizelongThe size of the buffer that is allocated when preloading indexes.
mysqlvariablesprepared_stmt_countlongThe current number of prepared statements.
mysqlvariablesprofilingstring 
mysqlvariablesprofiling_history_sizestring 
mysqlvariablesprotocol_versionlongThe version of the client/server protocol used by the MySQL server.
mysqlvariablespseudo_thread_idlong 
mysqlvariablesquery_alloc_block_sizelongAllocation block size for query parsing and execution.
mysqlvariablesquery_cache_limitlongDon't cache results that are bigger than this.
mysqlvariablesquery_cache_min_res_unitlongMemory.Caches
mysqlvariablesquery_cache_sizelongThe memory allocated to store results from old queries.
mysqlvariablesquery_cache_typestringQuery cache type.
mysqlvariablesquery_cache_wlock_invalidatestringInvalidate queries in query cache on LOCK for write.
mysqlvariablesquery_prealloc_sizelongPersistent buffer for query parsing and execution.
mysqlvariablesrand_seed1long 
mysqlvariablesrand_seed2long 
mysqlvariablesrange_alloc_block_sizelongAllocation block size for storing ranges during optimization.
mysqlvariablesread_buffer_sizelongMemory.Buffers
mysqlvariablesread_onlystringMake all nontemporary tables read only.
mysqlvariablesread_rnd_buffer_sizelongMemory.Buffers
mysqlvariablesrelay_logstring 
mysqlvariablesrelay_log_indexstring 
mysqlvariablesrelay_log_info_filestring 
mysqlvariablesrelay_log_purgestringDetermines whether relay logs are purged.
mysqlvariablesrelay_log_space_limitlongMaximum space to use for all relay logs.
mysqlvariablesreport_hoststring 
mysqlvariablesreport_passwordstring 
mysqlvariablesreport_portlong 
mysqlvariablesreport_userstring 
mysqlvariablesrpl_recovery_ranklongNot used.
mysqlvariablessecure_authstringDisallow authentication for accounts that have old (pre-4.1) passwords.
mysqlvariablessecure_file_privstringUnknown.Unknown
mysqlvariablesserver_idlongGeneral.Overview
mysqlvariablesshared_memorystringWhether the server allows shared-memory connections.
mysqlvariablesshared_memory_base_namestringThe name of shared memory to use for shared-memory connections.
mysqlvariablesskip_external_lockingstringSkip system (external) locking.
mysqlvariablesskip_name_resolvestring 
mysqlvariablesskip_networkingstringDon't allow connection with TCP/IP.
mysqlvariablesskip_show_databasestringDon't allow SHOW DATABASE commands.
mysqlvariablesslave_compressed_protocolstringUse compression on master/slave protocol.
mysqlvariablesslave_exec_modestring 
mysqlvariablesslave_load_tmpdirstringGeneral.Replication
mysqlvariablesslave_net_timeoutlongConnections.Networking
mysqlvariablesslave_skip_errorsstringGeneral.Replication
mysqlvariablesslave_transaction_retrieslongGeneral.Replication
mysqlvariablesslow_launch_timelongGeneral.Performance
mysqlvariablesslow_query_logstring 
mysqlvariablesslow_query_log_filestring 
mysqlvariablessocketstringSocket file to use for connection.
mysqlvariablessort_buffer_sizelongEach thread that needs to do a sort allocates a buffer of this size.
mysqlvariablessql_auto_is_nullstring 
mysqlvariablessql_big_selectsstringGeneral.Features
mysqlvariablessql_big_tablesstring 
mysqlvariablessql_buffer_resultstring 
mysqlvariablessql_log_binstring 
mysqlvariablessql_log_offstring 
mysqlvariablessql_log_updatestring 
mysqlvariablessql_low_priority_updatesstring 
mysqlvariablessql_max_join_sizelong 
mysqlvariablessql_modestringSet the SQL server mode.
mysqlvariablessql_notesstringIf set to 1, warnings of Note level are recorded.
mysqlvariablessql_quote_show_createstring 
mysqlvariablessql_safe_updatesstring 
mysqlvariablessql_select_limitlong 
mysqlvariablessql_slave_skip_counterlong 
mysqlvariablessql_warningsstringGeneral.Miscellaneous
mysqlvariablesssl_castringCA file in PEM format (check OpenSSL docs, implies --ssl)
mysqlvariablesssl_capathstringCA directory (check OpenSSL docs, implies --ssl)
mysqlvariablesssl_certstringX509 certification in PEM format (implies --ssl)
mysqlvariablesssl_cipherstringSSL cipher to use (implies --ssl)
mysqlvariablesssl_keystringX509 key in PEM format (implies ssl)
mysqlvariablesstorage_enginestringThe default storage engine.
mysqlvariablessync_binloglongSynchronously flush binary log to disk after every #th event.
mysqlvariablessync_frmstringSync .frm to disk on create. Enabled by default.
mysqlvariablessync_replicationlongDeprecated.
mysqlvariablessync_replication_slave_idlongDeprecated.
mysqlvariablessync_replication_timeoutlongDeprecated.
mysqlvariablessystem_time_zonestringThe server system time zone.
mysqlvariablestable_cachelongDeprecated; use --table_open_cache instead.
mysqlvariablestable_definition_cachelong 
mysqlvariablestable_lock_wait_timeoutlongGeneral.Miscellaneous
mysqlvariablestable_open_cachelong 
mysqlvariablestable_typestringA synonym for storage_engine.
mysqlvariablesthread_cache_sizelongHow many threads to keep in a cache for reuse.
mysqlvariablesthread_handlingstring 
mysqlvariablesthread_stacklongThe stack size for each thread.
mysqlvariablestime_formatstringThe TIME format (for future)
mysqlvariablestime_zonestringThe current time zone.
mysqlvariablestimed_mutexesstringGeneral.Miscellaneous
mysqlvariablestimestamplong 
mysqlvariablestmp_table_sizelongMemory.Overview
mysqlvariablestmpdirstringPath for temporary files.
mysqlvariablestransaction_alloc_block_sizelongAllocation block size for transactions to be stored in binary log.
mysqlvariablestransaction_prealloc_sizelongPersistent buffer for transactions to be stored in binary log.
mysqlvariablestx_isolationstringThe default transaction isolation level.
mysqlvariablesunique_checksstring 
mysqlvariablesupdatable_views_with_limitstringSQL.Overview
mysqlvariablesversionstringOutput version information and exit.
mysqlvariablesversion_commentstringGeneral.Overview
mysqlvariablesversion_compile_machinestringThe type of machine or architecture on which MySQL was built.
mysqlvariablesversion_compile_osstringThe type of operating system on which MySQL was built.
mysqlvariableswait_timeoutlongConnections.Overview
mysqlvariableswarning_countlong 
mysqlwaiting_dbwaiting_dbstring 
mysqlwaiting_statementwaiting_statementstring 
mysqlwaiting_threadwaiting_threadlong 
mysqlwaiting_timewaiting_timelong 
mysqlwaiting_userwaiting_userstring 
oscpucpu_cache_sizelongThe size of the CPU cache.
oscpucpu_idlelong_counterThe CPU idle time.
oscpucpu_mhzlongThe MHz rating of the CPU.
oscpucpu_namestringThe CPU name.
oscpucpu_syslong_counterCPU system / kernel time.
oscpucpu_userlong_counterCPU user space time.
oscpucpu_vendorstringThe name of the CPU vendor.
oscpucpu_waitlong_counterCPU IO wait time.
osdiskdisk_bytes_readlong_counterThe number of bytes read from disk.
osdiskdisk_bytes_writtenlong_counterThe number of bytes written to disk.
osdiskdisk_queuelongThe size of the disk IO queue.
osdiskdisk_readslong_counterThe number of disk reads.
osdiskdisk_rtimelong 
osdiskdisk_servicetimedouble 
osdiskdisk_snaptimelong 
osdiskdisk_timelong 
osdiskdisk_writeslong_counterThe number of disk writes.
osdiskdisk_wtimelong 
osfsfs_availlong 
osfsfs_dev_namestring 
osfsfs_dir_namestring 
osfsfs_fileslong 
osfsfs_flagslong 
osfsfs_free_fileslong 
osfsfs_optionsstring 
osfsfs_sys_type_namestring 
osfsfs_totallong 
osfsfs_type_namestring 
osfsfs_unusedlong 
osfsfs_usedlong 
osHosthost_idstringThe host unique identifier.
osHostnamestring 
osloadavg0double 
osloadavg1double 
osloadavg2double 
osmemram_totallongThe total amount of available RAM.
osmemram_unusedlongThe total amount of unused RAM.
osmemswap_page_inlong_counter 
osmemswap_page_outlong_counter 
osmemswap_totallongThe total amount of available swap memory.
osmemswap_unusedlongThe total amount of unused swap memory.
osnetaddressstringThe address of the network interface.
osnetbroadcaststringThe network interface broadcast address.
osnetdescriptionstringThe network interface description.
osnetdestinationstringThe network interface destination address.
osnetflagslongThe network interface flags.
osnethwaddrstringThe network interface MAC address.
osnetmetriclongOperating System.Net
osnetmtulongThe Maximum Transmission Unit.
osnetnamestringThe network interface name (eth0, eth1 etc.)
osnetnetmaskstringThe network interface subnet mask.
osnetrx_byteslong_counterThe number of bytes received.
osnetrx_droppedlong_counterThe number of received packets dropped.
osnetrx_errorslong_counterThe number of received packet errors.
osnetrx_framelong_counterThe number received packet frame errors.
osnetrx_overrunslong_counterThe number of received packet overruns.
osnetrx_packetslong_counterThe number of packets received.
osnetspeedlongThe network interface connection speed.
osnettx_byteslong_counterThe number of bytes transmitted.
osnettx_carrierlong_counterThe number of carrier errors on network transmission.
osnettx_collisionslong_counterThe number of network transmission collisions.
osnettx_droppedlong_counterThe number of network transmissions dropped.
osnettx_errorslong_counterThe number of network transmission errors.
osnettx_overrunslong_counterThe number of network transmission overruns.
osnettx_packetslong_counterThe number of packets transmitted.
osnettypestringThe network interface type (ethernet, loopback etc.)
ososos_archstringThe architecture of the OS / CPU.
ososos_descriptionstringDescription of the OS.
ososos_machinestringMachine CPU architecture.
ososos_namestringThe OS name.
ososos_patchlevelstringThe OS patch level.
ososos_vendorstringThe OS vendor.
ososos_vendor_code_namestringThe OS vendor code name.
ososos_vendor_namestringThe OS vendor name.
ososos_vendor_versionstringThe OS vendor version number.
ososos_versionstringThe OS version number.
utilLogHistogram0long_counter 
utilLogHistogram1long_counter 
utilLogHistogram10long_counter 
utilLogHistogram11long_counter 
utilLogHistogram12long_counter 
utilLogHistogram13long_counter 
utilLogHistogram14long_counter 
utilLogHistogram15long_counter 
utilLogHistogram16long_counter 
utilLogHistogram17long_counter 
utilLogHistogram18long_counter 
utilLogHistogram19long_counter 
utilLogHistogram2long_counter 
utilLogHistogram20long_counter 
utilLogHistogram21long_counter 
utilLogHistogram22long_counter 
utilLogHistogram23long_counter 
utilLogHistogram24long_counter 
utilLogHistogram25long_counter 
utilLogHistogram26long_counter 
utilLogHistogram27long_counter 
utilLogHistogram28long_counter 
utilLogHistogram29long_counter 
utilLogHistogram3long_counter 
utilLogHistogram30long_counter 
utilLogHistogram31long_counter 
utilLogHistogram32long_counter 
utilLogHistogram33long_counter 
utilLogHistogram34long_counter 
utilLogHistogram35long_counter 
utilLogHistogram36long_counter 
utilLogHistogram37long_counter 
utilLogHistogram38long_counter 
utilLogHistogram39long_counter 
utilLogHistogram4long_counter 
utilLogHistogram40long_counter 
utilLogHistogram41long_counter 
utilLogHistogram42long_counter 
utilLogHistogram43long_counter 
utilLogHistogram44long_counter 
utilLogHistogram45long_counter 
utilLogHistogram46long_counter 
utilLogHistogram47long_counter 
utilLogHistogram48long_counter 
utilLogHistogram49long_counter 
utilLogHistogram5long_counter 
utilLogHistogram50long_counter 
utilLogHistogram51long_counter 
utilLogHistogram52long_counter 
utilLogHistogram53long_counter 
utilLogHistogram54long_counter 
utilLogHistogram55long_counter 
utilLogHistogram56long_counter 
utilLogHistogram57long_counter 
utilLogHistogram58long_counter 
utilLogHistogram59long_counter 
utilLogHistogram6long_counter 
utilLogHistogram60long_counter 
utilLogHistogram61long_counter 
utilLogHistogram62long_counter 
utilLogHistogram7long_counter 
utilLogHistogram8long_counter 
utilLogHistogram9long_counter 
utilLogHistogrambaselong 
utilLogHistogramnullong_counter