Documentation Home
MySQL Enterprise Monitor 3.0 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 5.7Mb
PDF (A4) - 5.7Mb
EPUB - 3.8Mb
HTML Download (TGZ) - 3.6Mb
HTML Download (Zip) - 3.7Mb


MySQL Enterprise Monitor 3.0 Manual  /  Appendices  /  Data Collection Items

Appendix G Data Collection Items

Note

MySQL Enterprise Monitor is available as part of the MySQL Enterprise subscription, learn more at 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 22.2, “Creating Advisors and Rules”.

Table G.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 quanDataOutOfBand string
mysql Agent version string
mysql anonymous_user user_count long
mysql auto_increment_limit table_list string
mysql avail_count avail_count long
mysql broad_host_specifier user string A list of users whose host in the mysql.user table meets the condition: WHERE host = '%'; a single string in wiki markup format.
mysql cluster_data_node_data_memory data_mem_total long
mysql cluster_data_node_data_memory data_mem_used long
mysql cluster_data_node_index_memory index_mem_total long
mysql cluster_data_node_index_memory index_mem_used long
mysql cluster_data_node_redo_buffer redo_buffer_total long
mysql cluster_data_node_redo_buffer redo_buffer_used long
mysql cluster_data_node_redo_logspace redo_logspace_total long
mysql cluster_data_node_redo_logspace redo_logspace_used long
mysql cluster_data_node_undo_buffer undo_buffer_total long
mysql cluster_data_node_undo_buffer undo_buffer_used long
mysql cluster_data_node_undo_logspace undo_logspace_total long
mysql cluster_data_node_undo_logspace undo_logspace_used long
mysql cluster_data_nodes_not_started node_list 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 (cardinality) 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 innodb_active_transactions count long
mysql innodb_blocked_transactions count long
mysql innodb_compression_time compress_seconds long_counter
mysql innodb_compression_time uncompress_seconds long_counter
mysql innodb_lock_wait_transactions count long
mysql innodb_plugins innodb_plugin_list string
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_dictionary_alloc long Size in bytes allocated to the data dictionary tables/indexes
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_io_cur_pages long The number of Buffer Pool LRU list pages accessed total, for the last second
mysql innodbstatus innodb_bp_io_sum_pages long The number of Buffer Pool LRU list pages accessed total, for the last 50 seconds
mysql innodbstatus innodb_bp_io_unzip_cur_pages long The number of Buffer Pool unzip_LRU list pages accessed total, for the last second
mysql innodbstatus innodb_bp_io_unzip_sum_pages long The number of Buffer Pool unzip_LRU list pages accessed total, for the last 50 seconds
mysql innodbstatus innodb_bp_lru_len long The size in 16Kb pages of the Buffer Pool LRU list
mysql innodbstatus innodb_bp_modified_pages long The current number of pages modified.
mysql innodbstatus innodb_bp_not_young_hit_rate long The rate at which pages have been made not young for the past 15 seconds
mysql innodbstatus innodb_bp_old_db_pages long
mysql innodbstatus innodb_bp_pages_created long_counter The total number of pages created.
mysql innodbstatus innodb_bp_pages_evicted_no_access_per_sec double The average number of pages evicted without being accessed for the last 15 seconds
mysql innodbstatus innodb_bp_pages_not_young long_counter The number of pages made not young in the Buffer Pool LRU list
mysql innodbstatus innodb_bp_pages_not_young_per_sec double The per second average of the pages made young in the Buffer Pool LRU list for the last 15 seconds
mysql innodbstatus innodb_bp_pages_read long_counter The total number of pages read.
mysql innodbstatus innodb_bp_pages_read_ahead_per_sec double The average of read ahead operations per second for the last 15 seconds
mysql innodbstatus innodb_bp_pages_written long_counter The total number of pages written.
mysql innodbstatus innodb_bp_pages_young long_counter The number of pages made young in the Buffer Pool LRU list
mysql innodbstatus innodb_bp_pages_young_per_sec double
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_unzip_lru_len long The size in 16Kb pages of the Buffer Pool unzip_LRU list
mysql innodbstatus innodb_bp_written_per_sec double The number of buffer pool pages written per second.
mysql innodbstatus innodb_bp_young_hit_rate long The rate at which pages have been made young for the past 15 seconds
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_free_list_len long The length of the free list for the Insert Buffer index
mysql innodbstatus innodb_ibuf_inserts long_counter The number of change buffer inserts.
mysql innodbstatus innodb_ibuf_merged_recs long_counter The number of change buffer merged records.
mysql innodbstatus innodb_ibuf_merges long_counter The number of change buffer merges.
mysql innodbstatus innodb_ibuf_seg_size long The Insert Buffer index header and tree size, in 16Kb page
mysql innodbstatus innodb_ibuf_size long The Insert Buffer index tree size, in 16Kb pages
mysql innodbstatus innodb_io_ibuf_logs long The number of pending log I/Os.
mysql innodbstatus innodb_io_ibuf_reads long The number of pending change 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_checkpoint_lsn64 long The 64-bit variant of innodb_log_checkpoint_lsn (2.3.10+).
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_flushed_lsn64 long The 64-bit variant of innodb_log_flushed_lsn (2.3.10+).
mysql innodbstatus innodb_log_io_per_sec double The number of log I/Os per second.
mysql innodbstatus innodb_log_io_total long_counter The total number of log I/Os.
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_log_sequence_lsn64 long The 64-bit variant of innodb_log_sequence_lsn (2.3.10+).
mysql innodbstatus innodb_main_thd_log_flush_writes long_counter Count of log flushes initiated within the main thread loop
mysql innodbstatus innodb_main_thd_loops_background long_counter Count of background loops the main thread has done
mysql innodbstatus innodb_main_thd_loops_flush long_counter Count of flush loops the main thread has done
mysql innodbstatus innodb_main_thd_loops_one_sec long_counter Count of one second loops the main thread has done
mysql innodbstatus innodb_main_thd_loops_sleeps long_counter Count of sleeps the main thread has done inside the one second loop
mysql innodbstatus innodb_main_thd_loops_ten_sec long_counter Count of ten second loops the main thread has done
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 from InnoDB tables.
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 into InnoDB tables.
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 from InnoDB tables.
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 in InnoDB tables.
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/mutexspin 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_rounds long_counter Performance.InnoDB
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_rounds long_counter Performance.InnoDB
mysql innodbstatus innodb_sem_shared_spins long_counter The number of shared (read) semaphore spin waits within the sync array.
mysql innodbstatus innodb_sem_spins_per_wait_mutex double Ratio of innodb_sem_mutex_rounds to innodb_sem_mutex_spin_waits
mysql innodbstatus innodb_sem_spins_per_wait_rw_excl double Ratio of RW-Exlusive spin rounds to innodb_sem_rw_excl_spins
mysql innodbstatus innodb_sem_spins_per_wait_rw_shared double Ratio of RW-Shared spin rounds to innodb_sem_shared_spins
mysql innodbstatus innodb_trx_history_list_length long The transaction history list length.
mysql innodbstatus innodb_trx_id_counter long_counter Decoded decimal representation of the hex transaction ID counter in the latest InnoDB
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_id_counter_str string The hex string based transaction ID counter in the latest InnoDB
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 meb_backup_history backup_destination string
mysql meb_backup_history collected_ts integer
mysql meb_backup_history collected_ts_counter integer
mysql meb_backup_history end_time_raw string
mysql meb_backup_history end_time_ts integer
mysql meb_backup_history exit_state string
mysql meb_backup_history last_error string
mysql meb_backup_history last_error_code integer
mysql meb_backup_history lock_time float
mysql meb_backup_history mysql_data_dir string
mysql meb_backup_history progress_log string
mysql meb_backup_history start_time_now string
mysql meb_backup_history start_time_ts integer
mysql meb_backup_history total_time integer
mysql meb_backup_success_history load_full_backup string
mysql meb_incremental total_increments integer
mysql meb_timing lock_time float
mysql meb_timing total_time integer
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 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_SSL_Verify_Server_Cert 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 database string
mysql Statement errors long
mysql Statement exec_time long
mysql Statement explain_plan string
mysql Statement host_from string
mysql Statement host_to string
mysql Statement no_good_index_used long
mysql Statement no_index_used long
mysql Statement query_type string
mysql Statement rows long
mysql Statement source_location string
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 avg_exec_time 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 no_good_index_used long
mysql StatementSummary no_index_used 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_counter General.Logging
mysql status Binlog_cache_use long_counter 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 multi-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 START SLAVE statements.
mysql status Com_slave_stop long_counter Count of STOP SLAVE 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 multi-table 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. For non-transactional tables only.
mysql status Delayed_writes long_counter The number of INSERT DELAYED rows written. For non-transactional tables only.
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 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 in the InnoDB buffer pool.
mysql status Innodb_buffer_pool_pages_flushed long_counter The number of page flush requests in the InnoDB buffer pool.
mysql status Innodb_buffer_pool_pages_free long The number of InnoDB 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 InnoDB 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 Number of waits for pages to be flushed.
mysql status Innodb_buffer_pool_write_requests long_counter The number of writes done to the InnoDB 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 Ndb_number_of_data_nodes long
mysql status Ndb_number_of_ready_data_nodes long
mysql status Not_flushed_delayed_rows long The number of rows waiting to be written in INSERT DELAY queues. For non-transactional tables only.
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 Queries long_counter
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 verification 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 status Uptime_since_flush_status long_counter
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 user_on_missing_table 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_direct_non_transactional_updates string
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 long 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. No longer used as of MEM 2.3.13.
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_profiling 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 ignore_builtin_innodb string
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_flushing string
mysql variables innodb_adaptive_hash_index string
mysql variables innodb_additional_mem_pool_size long Memory.Buffers
mysql variables innodb_autoextend_increment long Amount by which InnoDB auto-extends the data files for a tablespace, 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_change_buffering string
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 location for InnoDB tablespaces
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 by deferring cleanup operations until the server restarts.
mysql variables innodb_file_format string
mysql variables innodb_file_format_check string
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 and associated indexes in an .ibd file in the database directory.
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_io_capacity long
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 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 InnoDB buffer pool.
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 to keep for the database.
mysql variables innodb_old_blocks_pct long
mysql variables innodb_old_blocks_time long
mysql variables innodb_open_files long The maximum number of files that InnoDB keeps open at the same time.
mysql variables innodb_read_ahead_threshold long
mysql variables innodb_read_io_threads long
mysql variables innodb_rollback_on_timeout string Unknown.Unknown
mysql variables innodb_spin_wait_delay long
mysql variables innodb_stats_on_metadata string
mysql variables innodb_stats_sample_pages long
mysql variables innodb_strict_mode string
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 innodb_use_legacy_cardinality_algorithm string Applies only to MySQL 5.1 and earlier.
mysql variables innodb_use_sys_malloc string
mysql variables innodb_write_io_threads long
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 the 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 string 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 double General.Performance
mysql variables low_priority_updates string For non-transactional tables, INSERT, DELETE, and UPDATE statements have lower priority than SELECT statements.
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_mmap_size long
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 optimizer_switch string
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 profiling string
mysql variables profiling_history_size string
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_name_resolve string
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 to 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 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_counter
os mem swap_page_out long_counter
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


User Comments
Sign Up Login You must be logged in to post a comment.