Appendix D. Data Collection Items

Appendix D. Data Collection Items
Prev		Next

Note

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

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

Table D.1. MySQL Monitor Data Items

Namespace	Namespace Type	Attribute	Type	Description
agent	allocationstats	`agent_dataitem_spec_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_dataitem_spec_free`	`long_counter`	MISSING
agent	allocationstats	`agent_item_attribute_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_item_attribute_free`	`long_counter`	MISSING
agent	allocationstats	`agent_item_class_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_item_class_config_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_item_class_config_free`	`long_counter`	MISSING
agent	allocationstats	`agent_item_class_free`	`long_counter`	MISSING
agent	allocationstats	`agent_item_classes_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_item_classes_free`	`long_counter`	MISSING
agent	allocationstats	`agent_item_instance_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_item_instance_free`	`long_counter`	MISSING
agent	allocationstats	`agent_item_instance_name_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_item_instance_name_free`	`long_counter`	MISSING
agent	allocationstats	`agent_item_namespaces_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_item_namespaces_free`	`long_counter`	MISSING
agent	allocationstats	`agent_item_value_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_item_value_free`	`long_counter`	MISSING
agent	allocationstats	`agent_mysqld_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_mysqld_free`	`long_counter`	MISSING
agent	allocationstats	`agent_plugin_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_plugin_free`	`long_counter`	MISSING
agent	allocationstats	`agent_target_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_target_free`	`long_counter`	MISSING
agent	allocationstats	`agent_task_alloc`	`long_counter`	MISSING
agent	allocationstats	`agent_task_free`	`long_counter`	MISSING
agent	allocationstats	`curl_mem_alloc`	`long_counter`	MISSING
agent	allocationstats	`curl_mem_bytes`	`long`	MISSING
agent	allocationstats	`curl_mem_bytes_max`	`long`	MISSING
agent	allocationstats	`curl_mem_free`	`long_counter`	MISSING
agent	allocationstats	`job_response_alloc`	`long_counter`	MISSING
agent	allocationstats	`job_response_data_alloc`	`long_counter`	MISSING
agent	allocationstats	`job_response_data_free`	`long_counter`	MISSING
agent	allocationstats	`job_response_datum_alloc`	`long_counter`	MISSING
agent	allocationstats	`job_response_datum_free`	`long_counter`	MISSING
agent	allocationstats	`job_response_free`	`long_counter`	MISSING
agent	allocationstats	`job_response_string_alloc`	`long_counter`	MISSING
agent	allocationstats	`job_response_string_free`	`long_counter`	MISSING
agent	allocationstats	`job_task_alloc`	`long_counter`	MISSING
agent	allocationstats	`job_task_free`	`long_counter`	MISSING
agent	allocationstats	`network_backlog_alloc`	`long_counter`	MISSING
agent	allocationstats	`network_backlog_free`	`long_counter`	MISSING
agent	allocationstats	`network_backlog_node_alloc`	`long_counter`	MISSING
agent	allocationstats	`network_backlog_node_bytes`	`long`	MISSING
agent	allocationstats	`network_backlog_node_free`	`long_counter`	MISSING
agent	allocationstats	`scheduler_job_alloc`	`long_counter`	MISSING
agent	allocationstats	`scheduler_job_free`	`long_counter`	MISSING
agent	allocationstats	`xml_mem_alloc`	`long_counter`	MISSING
agent	allocationstats	`xml_mem_bytes`	`long`	MISSING
agent	allocationstats	`xml_mem_bytes_max`	`long`	MISSING
agent	allocationstats	`xml_mem_free`	`long_counter`	MISSING
agent	chassisstats	`glib_mem_alloc`	`long_counter`	MISSING
agent	chassisstats	`glib_mem_bytes`	`long`	MISSING
agent	chassisstats	`glib_mem_bytes_max`	`long`	MISSING
agent	chassisstats	`glib_mem_free`	`long_counter`	MISSING
agent	chassisstats	`lua_mem_alloc`	`long_counter`	MISSING
agent	chassisstats	`lua_mem_bytes`	`long`	MISSING
agent	chassisstats	`lua_mem_bytes_max`	`long`	MISSING
agent	chassisstats	`lua_mem_free`	`long_counter`	MISSING
agent	lua	`mem_size`	`long`	MISSING
agent	proc	`egid`	`long`	MISSING
agent	proc	`euid`	`long`	MISSING
agent	proc	`gid`	`long`	MISSING
agent	proc	`mem_major_faults`	`long_counter`	MISSING
agent	proc	`mem_minor_faults`	`long_counter`	MISSING
agent	proc	`mem_page_faults`	`long_counter`	MISSING
agent	proc	`mem_resident`	`long`	MISSING
agent	proc	`mem_share`	`long`	MISSING
agent	proc	`mem_size`	`long`	MISSING
agent	proc	`name`	`string`	MISSING
agent	proc	`nice`	`long`	MISSING
agent	proc	`ppid`	`long`	MISSING
agent	proc	`priority`	`long`	MISSING
agent	proc	`processor`	`long`	MISSING
agent	proc	`state`	`long`	MISSING
agent	proc	`threads`	`long`	MISSING
agent	proc	`time_start_time`	`long`	MISSING
agent	proc	`time_sys`	`long_counter`	MISSING
agent	proc	`time_total`	`long_counter`	MISSING
agent	proc	`time_user`	`long_counter`	MISSING
agent	proc	`tty`	`long`	MISSING
agent	proc	`uid`	`long`	MISSING
monitor	resourceBundle	`subscription`	`string`	MISSING
monitor	resourceBundle	`version`	`string`	MISSING
mysql	account_old_password	`user`	`string`	MISSING
mysql	active_count	`active_count`	`long`	MISSING
mysql	Agent	`agent.latency`	`long`	MISSING
mysql	Agent	`agent.reachable`	`string`	MISSING
mysql	Agent	`host_id`	`string`	MISSING
mysql	Agent	`name`	`string`	MISSING
mysql	Agent	`quanDataOutOfBand`	`string`	MISSING
mysql	Agent	`version`	`string`	MISSING
mysql	anonymous_user	`user_count`	`long`	MISSING
mysql	auto_increment_limit	`table_list`	`string`	MISSING
mysql	avail_count	`avail_count`	`long`	MISSING
mysql	broad_host_specifier	`user`	`string`	MISSING
mysql	cluster_data_node_data_memory	`data_mem_total`	`long`	MISSING
mysql	cluster_data_node_data_memory	`data_mem_used`	`long`	MISSING
mysql	cluster_data_node_index_memory	`index_mem_total`	`long`	MISSING
mysql	cluster_data_node_index_memory	`index_mem_used`	`long`	MISSING
mysql	cluster_data_node_redo_buffer	`redo_buffer_total`	`long`	MISSING
mysql	cluster_data_node_redo_buffer	`redo_buffer_used`	`long`	MISSING
mysql	cluster_data_node_redo_logspace	`redo_logspace_total`	`long`	MISSING
mysql	cluster_data_node_redo_logspace	`redo_logspace_used`	`long`	MISSING
mysql	cluster_data_node_undo_buffer	`undo_buffer_total`	`long`	MISSING
mysql	cluster_data_node_undo_buffer	`undo_buffer_used`	`long`	MISSING
mysql	cluster_data_node_undo_logspace	`undo_logspace_total`	`long`	MISSING
mysql	cluster_data_node_undo_logspace	`undo_logspace_used`	`long`	MISSING
mysql	cluster_data_nodes_not_started	`node_list`	`string`	MISSING
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`	MISSING
mysql	Database	`Database`	`string`	MISSING
mysql	Database	`name`	`string`	MISSING
mysql	Explain	`extra`	`string`	MISSING
mysql	Explain	`id`	`long`	MISSING
mysql	Explain	`key`	`string`	MISSING
mysql	Explain	`key_len`	`string`	MISSING
mysql	Explain	`possible_keys`	`string`	MISSING
mysql	Explain	`ref`	`string`	MISSING
mysql	Explain	`rows`	`long`	MISSING
mysql	Explain	`select_type`	`string`	MISSING
mysql	Explain	`table`	`string`	MISSING
mysql	Explain	`type`	`string`	MISSING
mysql	falcon_database_io	`logical_reads`	`long`	MISSING
mysql	falcon_database_io	`physical_reads`	`long`	MISSING
mysql	falcon_record_cache_summary	`total_recordcache_mb`	`double`	MISSING
mysql	falcon_record_cache_summary	`total_space_mb`	`double`	MISSING
mysql	falcon_system_memory_summary	`free_system_mb`	`double`	MISSING
mysql	falcon_system_memory_summary	`total_system_mb`	`double`	MISSING
mysql	falcon_transaction_summary	`committed_txns`	`long`	MISSING
mysql	falcon_transaction_summary	`rolled_back_txns`	`long`	MISSING
mysql	global_privileges	`user`	`string`	MISSING
mysql	grant_privileges	`user_spec`	`string`	MISSING
mysql	inappropriate_slave_privileges	`user`	`string`	MISSING
mysql	index	`Cardinality`	`long`	An estimate of the number of unique values in the index
mysql	index	`Collation`	`string`	How the column is sorted in the index
mysql	index	`Column_name`	`string`	The column name
mysql	index	`Comment`	`string`	Remarks about the index
mysql	index	`Index_type`	`string`	The index method used (BTREE, FULLTEXT, HASH, RTREE)
mysql	index	`Key_name`	`string`	The name of the index
mysql	index	`Non_unique`	`long`	Whether the index can contain duplicates
mysql	index	`Null`	`string`	Whether the column may contain NULL values
mysql	index	`Packed`	`string`	Whether the key is packed
mysql	index	`Seq_in_index`	`long`	The column sequence number in the index, starting with 1
mysql	index	`Sub_part`	`string`	The number of indexed characters if the column is only partly indexed
mysql	index	`Table`	`string`	The name of the table associated with the index
mysql	innodb_active_transactions	`count`	`long`	MISSING
mysql	innodb_blocked_transactions	`count`	`long`	MISSING
mysql	innodb_compression_time	`compress_seconds`	`long_counter`	MISSING
mysql	innodb_compression_time	`uncompress_seconds`	`long_counter`	MISSING
mysql	innodb_lock_wait_transactions	`count`	`long`	MISSING
mysql	innodb_plugins	`innodb_plugin_list`	`string`	MISSING
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`	MISSING
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`	MISSING
mysql	innodbstatus	`innodb_bp_io_sum_pages`	`long`	MISSING
mysql	innodbstatus	`innodb_bp_io_unzip_cur_pages`	`long`	MISSING
mysql	innodbstatus	`innodb_bp_io_unzip_sum_pages`	`long`	MISSING
mysql	innodbstatus	`innodb_bp_lru_len`	`long`	MISSING
mysql	innodbstatus	`innodb_bp_modified_pages`	`long`	The current number of pages modified
mysql	innodbstatus	`innodb_bp_not_young_hit_rate`	`long`	MISSING
mysql	innodbstatus	`innodb_bp_old_db_pages`	`long`	MISSING
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`	MISSING
mysql	innodbstatus	`innodb_bp_pages_not_young`	`long_counter`	MISSING
mysql	innodbstatus	`innodb_bp_pages_not_young_per_sec`	`double`	MISSING
mysql	innodbstatus	`innodb_bp_pages_read`	`long_counter`	The total number of pages read
mysql	innodbstatus	`innodb_bp_pages_read_ahead_per_sec`	`double`	MISSING
mysql	innodbstatus	`innodb_bp_pages_written`	`long_counter`	The total number of pages written
mysql	innodbstatus	`innodb_bp_pages_young`	`long_counter`	MISSING
mysql	innodbstatus	`innodb_bp_pages_young_per_sec`	`double`	MISSING
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`	MISSING
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`	MISSING
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`	MISSING
mysql	innodbstatus	`innodb_ibuf_inserts`	`long_counter`	The number of insert buffer inserts
mysql	innodbstatus	`innodb_ibuf_merged_recs`	`long_counter`	The number of insert buffer merged records
mysql	innodbstatus	`innodb_ibuf_merges`	`long_counter`	The number of insert buffer merges
mysql	innodbstatus	`innodb_ibuf_seg_size`	`long`	MISSING
mysql	innodbstatus	`innodb_ibuf_size`	`long`	MISSING
mysql	innodbstatus	`innodb_io_ibuf_logs`	`long`	The number of pending log Ios
mysql	innodbstatus	`innodb_io_ibuf_reads`	`long`	The number of pending insert buffer reads
mysql	innodbstatus	`innodb_io_ibuf_syncs`	`long`	The number of pending synch operations
mysql	innodbstatus	`innodb_io_os_file_fsyncs`	`long_counter`	The number of OS fsyncs
mysql	innodbstatus	`innodb_io_os_file_reads`	`long_counter`	The number of OS file reads
mysql	innodbstatus	`innodb_io_os_file_writes`	`long_counter`	The number of OS file writes
mysql	innodbstatus	`innodb_io_pending_flush_bp`	`long`	The number of pending buffer pool flush operations
mysql	innodbstatus	`innodb_io_pending_flush_log`	`long`	The number of pending log flush operations
mysql	innodbstatus	`innodb_io_pending_reads`	`long`	The number of I/O pending reads
mysql	innodbstatus	`innodb_io_pending_writes`	`long`	The number of I/O pending writes
mysql	innodbstatus	`innodb_io_syncs_per_sec`	`double`	The number of fsyncs() per second
mysql	innodbstatus	`innodb_log_checkpoint_file`	`long`	The log file number the last checkpoint was performed on
mysql	innodbstatus	`innodb_log_checkpoint_lsn`	`long`	The log sequence number of the last checkpoint
mysql	innodbstatus	`innodb_log_flushed_file`	`long`	The log file number the last checkpoint was performed on
mysql	innodbstatus	`innodb_log_flushed_lsn`	`long`	The point up to which the log was last flushed
mysql	innodbstatus	`innodb_log_io_per_sec`	`double`	The number of log I/O's per second
mysql	innodbstatus	`innodb_log_io_total`	`long_counter`	The total number of log I/O's
mysql	innodbstatus	`innodb_log_pending_checkpoint_writes`	`long`	The log pending checkpoint writes
mysql	innodbstatus	`innodb_log_pending_log_writes`	`long`	The log pending log writes
mysql	innodbstatus	`innodb_log_sequence_file`	`long`	The log sequence file number
mysql	innodbstatus	`innodb_log_sequence_lsn`	`long`	The log sequence number
mysql	innodbstatus	`innodb_main_thd_log_flush_writes`	`long_counter`	MISSING
mysql	innodbstatus	`innodb_main_thd_loops_background`	`long_counter`	MISSING
mysql	innodbstatus	`innodb_main_thd_loops_flush`	`long_counter`	MISSING
mysql	innodbstatus	`innodb_main_thd_loops_one_sec`	`long_counter`	MISSING
mysql	innodbstatus	`innodb_main_thd_loops_sleeps`	`long_counter`	MISSING
mysql	innodbstatus	`innodb_main_thd_loops_ten_sec`	`long_counter`	MISSING
mysql	innodbstatus	`innodb_non_hash_searches_per_sec`	`double`	The number of nonadaptive hash index searches
mysql	innodbstatus	`innodb_per_sec_avg`	`double`	The number of seconds the averages for SHOW INNODB STATUS were calculated from
mysql	innodbstatus	`innodb_reads_per_sec`	`double`	The number of reads per second
mysql	innodbstatus	`innodb_row_queries_inside`	`long`	The number of queries executing inside InnoDB
mysql	innodbstatus	`innodb_row_queries_queue`	`long`	The number of queries in the queue, waiting to enter InnoDB
mysql	innodbstatus	`innodb_row_state`	`string`	The current state of the main InnoDB thread
mysql	innodbstatus	`innodb_rows_deleted`	`long_counter`	The number of rows deleted from InnoDB tables
mysql	innodbstatus	`innodb_rows_deleted_per_sec`	`double`	The number of rows deleted per second
mysql	innodbstatus	`innodb_rows_inserted`	`long_counter`	The number of rows inserted into InnoDB tables
mysql	innodbstatus	`innodb_rows_inserted_per_sec`	`double`	The number of rows inserted per second
mysql	innodbstatus	`innodb_rows_read`	`long_counter`	The number of rows read from InnoDB tables
mysql	innodbstatus	`innodb_rows_read_per_sec`	`double`	The number of rows read per second
mysql	innodbstatus	`innodb_rows_updated`	`long_counter`	The number of rows updated in InnoDB tables
mysql	innodbstatus	`innodb_rows_updated_per_sec`	`double`	The number of rows updated per second
mysql	innodbstatus	`innodb_sem_mutex_os_waits`	`long_counter`	The number of semaphore/mutex waits yielded to the OS
mysql	innodbstatus	`innodb_sem_mutex_rounds`	`long_counter`	The number of semaphore/mutex round for the internal sync array
mysql	innodbstatus	`innodb_sem_mutex_spin_waits`	`long_counter`	The number of semaphore/mutex spin waits for the internal sync array
mysql	innodbstatus	`innodb_sem_os_reservation_count`	`long_counter`	The number of times a mutex wait was added to the internal sync array
mysql	innodbstatus	`innodb_sem_os_signal_count`	`long_counter`	Performance.InnoDB
mysql	innodbstatus	`innodb_sem_rw_excl_os_waits`	`long_counter`	The number of exclusive (write) semaphore waits yielded to the OS
mysql	innodbstatus	`innodb_sem_rw_excl_spins`	`long_counter`	Performance.InnoDB
mysql	innodbstatus	`innodb_sem_shared_os_waits`	`long_counter`	The number of shared (read) semaphore waits yielded to the OS
mysql	innodbstatus	`innodb_sem_shared_spins`	`long_counter`	The number of shared (read) semaphore spin waits within the syn array
mysql	innodbstatus	`innodb_sem_spins_per_wait_mutex`	`double`	MISSING
mysql	innodbstatus	`innodb_sem_spins_per_wait_rw_excl`	`double`	MISSING
mysql	innodbstatus	`innodb_sem_spins_per_wait_rw_shared`	`double`	MISSING
mysql	innodbstatus	`innodb_trx_history_list_length`	`long`	The transaction history list length
mysql	innodbstatus	`innodb_trx_id_counter`	`long_counter`	MISSING
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`	MISSING
mysql	innodbstatus	`innodb_trx_purge_done_trx2`	`long`	The transaction count that is already purged
mysql	innodbstatus	`innodb_trx_total_lock_structs`	`long`	MISSING
mysql	innodbstatus	`innodb_writes_per_sec`	`double`	The number of InnoDB writes per second
mysql	locked_processes	`num_locked`	`long`	MISSING
mysql	long_locked_processes	`long_running_time`	`double`	MISSING
mysql	long_locked_processes	`num_long_running`	`long`	MISSING
mysql	long_running_processes	`long_running_time`	`double`	MISSING
mysql	long_running_processes	`num_long_running`	`long`	MISSING
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`	MISSING
mysql	MasterStatus	`Binlog_Ignore_DB`	`string`	MISSING
mysql	MasterStatus	`File`	`string`	MISSING
mysql	MasterStatus	`Position`	`long`	MISSING
mysql	no_password	`user`	`string`	MISSING
mysql	no_root_password	`no_password`	`long`	MISSING
mysql	num_waiting_txns	`num_waiting_txns`	`long`	MISSING
mysql	prepared_count	`prepared_count`	`long`	MISSING
mysql	privileges_on_all_dbs	`user_spec`	`string`	MISSING
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`	MISSING
mysql	rolledback_count	`rolledback_count`	`long`	MISSING
mysql	root_account_exists	`root_account`	`long`	MISSING
mysql	root_remote_login	`remote_login`	`long`	MISSING
mysql	Server	`blackout`	`string`	MISSING
mysql	Server	`displayname`	`string`	The display name of the server in the Dashboard
mysql	Server	`registration-complete`	`string`	MISSING
mysql	Server	`repl.group`	`long`	MISSING
mysql	Server	`repl.groupName`	`string`	MISSING
mysql	Server	`server.connected`	`long`	Whether the server is connected
mysql	Server	`server.last_errno`	`string`	MISSING
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`	MISSING
mysql	Server	`transport`	`string`	MISSING
mysql	Server	`visible.displayname`	`string`	MISSING
mysql	server_admin_privileges	`user_spec`	`string`	MISSING
mysql	SlaveStatus	`Binlog_Do_DB`	`string`	MISSING
mysql	SlaveStatus	`Binlog_Ignore_DB`	`string`	MISSING
mysql	SlaveStatus	`Connect_Retry`	`long`	MISSING
mysql	SlaveStatus	`Exec_Master_Log_Pos`	`long`	MISSING
mysql	SlaveStatus	`File`	`string`	MISSING
mysql	SlaveStatus	`Last_Errno`	`long`	MISSING
mysql	SlaveStatus	`Last_Error`	`string`	MISSING
mysql	SlaveStatus	`Last_IO_Errno`	`long`	MISSING
mysql	SlaveStatus	`Last_IO_Error`	`string`	MISSING
mysql	SlaveStatus	`Last_SQL_Errno`	`long`	MISSING
mysql	SlaveStatus	`Last_SQL_Error`	`string`	MISSING
mysql	SlaveStatus	`Master_Host`	`string`	MISSING
mysql	SlaveStatus	`Master_ip`	`string`	MISSING
mysql	SlaveStatus	`Master_Log_File`	`string`	MISSING
mysql	SlaveStatus	`Master_Port`	`long`	MISSING
mysql	SlaveStatus	`Master_SSL_Allowed`	`string`	MISSING
mysql	SlaveStatus	`Master_SSL_CA_File`	`string`	MISSING
mysql	SlaveStatus	`Master_SSL_CA_Path`	`string`	MISSING
mysql	SlaveStatus	`Master_SSL_Cert`	`string`	MISSING
mysql	SlaveStatus	`Master_SSL_Cipher`	`string`	MISSING
mysql	SlaveStatus	`Master_SSL_Key`	`string`	MISSING
mysql	SlaveStatus	`Master_SSL_Verify_Server_Cert`	`string`	MISSING
mysql	SlaveStatus	`Master_User`	`string`	MISSING
mysql	SlaveStatus	`Master_uuid`	`string`	MISSING
mysql	SlaveStatus	`Position`	`long`	MISSING
mysql	SlaveStatus	`Read_Master_Log_Pos`	`long`	MISSING
mysql	SlaveStatus	`Relay_Log_File`	`string`	MISSING
mysql	SlaveStatus	`Relay_Log_Pos`	`long`	MISSING
mysql	SlaveStatus	`Relay_Log_Space`	`long`	MISSING
mysql	SlaveStatus	`Relay_Master_Log_File`	`string`	MISSING
mysql	SlaveStatus	`Replicate_Do_DB`	`string`	MISSING
mysql	SlaveStatus	`Replicate_Do_Table`	`string`	MISSING
mysql	SlaveStatus	`Replicate_Ignore_DB`	`string`	MISSING
mysql	SlaveStatus	`Replicate_Ignore_Table`	`string`	MISSING
mysql	SlaveStatus	`Replicate_Wild_Do_Table`	`string`	MISSING
mysql	SlaveStatus	`Replicate_Wild_Ignore_Table`	`string`	MISSING
mysql	SlaveStatus	`Seconds_Behind_Master`	`long`	MISSING
mysql	SlaveStatus	`Skip_Counter`	`long`	MISSING
mysql	SlaveStatus	`Slave_IO_Running`	`string`	MISSING
mysql	SlaveStatus	`Slave_IO_State`	`string`	MISSING
mysql	SlaveStatus	`Slave_SQL_Running`	`string`	MISSING
mysql	SlaveStatus	`Until_Condition`	`string`	MISSING
mysql	SlaveStatus	`Until_Log_File`	`string`	MISSING
mysql	SlaveStatus	`Until_Log_Pos`	`long`	MISSING
mysql	sp_with_select_star	`routine`	`string`	MISSING
mysql	Statement	`bytes`	`long`	MISSING
mysql	Statement	`comment`	`string`	MISSING
mysql	Statement	`connection_id`	`long`	MISSING
mysql	Statement	`database`	`string`	MISSING
mysql	Statement	`errors`	`long`	MISSING
mysql	Statement	`exec_time`	`long`	MISSING
mysql	Statement	`explain_plan`	`string`	MISSING
mysql	Statement	`host_from`	`string`	MISSING
mysql	Statement	`host_to`	`string`	MISSING
mysql	Statement	`no_good_index_used`	`long`	MISSING
mysql	Statement	`no_index_used`	`long`	MISSING
mysql	Statement	`query_type`	`string`	MISSING
mysql	Statement	`rows`	`long`	MISSING
mysql	Statement	`source_location`	`string`	MISSING
mysql	Statement	`text`	`string`	MISSING
mysql	Statement	`user`	`string`	MISSING
mysql	Statement	`warnings`	`long`	MISSING
mysql	StatementAnalysisSupport	`auto_explain_min_exec_time_ms`	`long`	MISSING
mysql	StatementAnalysisSupport	`capture_examples`	`string`	MISSING
mysql	StatementAnalysisSupport	`capture_explain`	`string`	MISSING
mysql	StatementAnalysisSupport	`enabled`	`string`	MISSING
mysql	StatementAnalysisSupport	`frequency`	`string`	MISSING
mysql	StatementSummary	`avg_exec_time`	`string`	MISSING
mysql	StatementSummary	`bytes`	`long`	MISSING
mysql	StatementSummary	`bytes_rel`	`long`	MISSING
mysql	StatementSummary	`count`	`long`	MISSING
mysql	StatementSummary	`count_rel`	`long`	MISSING
mysql	StatementSummary	`database`	`string`	MISSING
mysql	StatementSummary	`errors`	`long`	MISSING
mysql	StatementSummary	`exec_time`	`long`	MISSING
mysql	StatementSummary	`exec_time_rel`	`long`	MISSING
mysql	StatementSummary	`max_bytes`	`long`	MISSING
mysql	StatementSummary	`max_exec_time`	`long`	MISSING
mysql	StatementSummary	`max_rows`	`long`	MISSING
mysql	StatementSummary	`min_bytes`	`long`	MISSING
mysql	StatementSummary	`min_exec_time`	`long`	MISSING
mysql	StatementSummary	`min_rows`	`long`	MISSING
mysql	StatementSummary	`no_good_index_used`	`long`	MISSING
mysql	StatementSummary	`no_index_used`	`long`	MISSING
mysql	StatementSummary	`query_type`	`string`	MISSING
mysql	StatementSummary	`rows`	`long`	MISSING
mysql	StatementSummary	`rows_rel`	`long`	MISSING
mysql	StatementSummary	`text`	`string`	MISSING
mysql	StatementSummary	`text_hash`	`string`	MISSING
mysql	StatementSummary	`warnings`	`long`	MISSING
mysql	status	`Aborted_clients`	`long_counter`	Networking.Overview
mysql	status	`Aborted_connects`	`long_counter`	The number of failed attempts to connect to the MySQL server
mysql	status	`Binlog_cache_disk_use`	`long`	General.Logging
mysql	status	`Binlog_cache_use`	`long`	The number of transactions that used the temporary binary log cache
mysql	status	`Bytes_received`	`long_counter`	The number of bytes received from all clients
mysql	status	`Bytes_sent`	`long_counter`	The number of bytes sent to all clients
mysql	status	`Com_admin_commands`	`long_counter`	Count of admin commands
mysql	status	`Com_alter_db`	`long_counter`	Count of ALTER DATABASE statements
mysql	status	`Com_alter_db_upgrade`	`long_counter`	MISSING
mysql	status	`Com_alter_event`	`long_counter`	MISSING
mysql	status	`Com_alter_function`	`long_counter`	MISSING
mysql	status	`Com_alter_procedure`	`long_counter`	MISSING
mysql	status	`Com_alter_server`	`long_counter`	MISSING
mysql	status	`Com_alter_table`	`long_counter`	Count of ALTER TABLE statements
mysql	status	`Com_alter_tablespace`	`long_counter`	MISSING
mysql	status	`Com_analyze`	`long_counter`	Count of ANALYZE statements
mysql	status	`Com_assign_to_keycache`	`long_counter`	MISSING
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`	MISSING
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`	MISSING
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`	MISSING
mysql	status	`Com_create_server`	`long_counter`	MISSING
mysql	status	`Com_create_table`	`long_counter`	Count of CREATE TABLE statements
mysql	status	`Com_create_trigger`	`long_counter`	MISSING
mysql	status	`Com_create_udf`	`long_counter`	MISSING
mysql	status	`Com_create_user`	`long_counter`	Count of CREATE USER statements
mysql	status	`Com_create_view`	`long_counter`	MISSING
mysql	status	`Com_dealloc_sql`	`long_counter`	Count of DEALLOCATE PREPARE statements
mysql	status	`Com_delete`	`long_counter`	Count of DELETE statements
mysql	status	`Com_delete_multi`	`long_counter`	Count of multiple table DELETE statements
mysql	status	`Com_do`	`long_counter`	Count of DO statements
mysql	status	`Com_drop_db`	`long_counter`	Count of DROP DATABASE statements
mysql	status	`Com_drop_event`	`long_counter`	MISSING
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`	MISSING
mysql	status	`Com_drop_server`	`long_counter`	MISSING
mysql	status	`Com_drop_table`	`long_counter`	Count of DROP TABLE statements
mysql	status	`Com_drop_trigger`	`long_counter`	MISSING
mysql	status	`Com_drop_user`	`long_counter`	Count of DROP USER statements
mysql	status	`Com_drop_view`	`long_counter`	MISSING
mysql	status	`Com_empty_query`	`long_counter`	MISSING
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`	MISSING
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`	MISSING
mysql	status	`Com_rename_table`	`long_counter`	Count of RENAME TABLE statements
mysql	status	`Com_rename_user`	`long_counter`	MISSING
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`	MISSING
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`	MISSING
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`	MISSING
mysql	status	`Com_show_create_db`	`long_counter`	Count of SHOW CREATE DATABASE statements
mysql	status	`Com_show_create_event`	`long_counter`	MISSING
mysql	status	`Com_show_create_func`	`long_counter`	MISSING
mysql	status	`Com_show_create_proc`	`long_counter`	MISSING
mysql	status	`Com_show_create_table`	`long_counter`	Count of SHOW CREATE TABLE statements
mysql	status	`Com_show_create_trigger`	`long_counter`	MISSING
mysql	status	`Com_show_databases`	`long_counter`	Count of SHOW DATABASES statements
mysql	status	`Com_show_engine_logs`	`long_counter`	MISSING
mysql	status	`Com_show_engine_mutex`	`long_counter`	MISSING
mysql	status	`Com_show_engine_status`	`long_counter`	MISSING
mysql	status	`Com_show_errors`	`long_counter`	Count of SHOW ERRORS statements
mysql	status	`Com_show_events`	`long_counter`	MISSING
mysql	status	`Com_show_fields`	`long_counter`	Count of SHOW FIELDS statements
mysql	status	`Com_show_function_status`	`long_counter`	MISSING
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`	MISSING
mysql	status	`Com_show_privileges`	`long_counter`	Count of SHOW PRIVILEGES statements
mysql	status	`Com_show_procedure_status`	`long_counter`	MISSING
mysql	status	`Com_show_processlist`	`long_counter`	Count of SHOW PROCESSLIST statements
mysql	status	`Com_show_profile`	`long_counter`	MISSING
mysql	status	`Com_show_profiles`	`long_counter`	MISSING
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`	MISSING
mysql	status	`Com_show_tables`	`long_counter`	Count of SHOW TABLES statements
mysql	status	`Com_show_triggers`	`long_counter`	Count of SHOW TRIGGERS statements
mysql	status	`Com_show_variables`	`long_counter`	Count of SHOW VARIABLES statements
mysql	status	`Com_show_warnings`	`long_counter`	Count of SHOW WARNINGS statements
mysql	status	`Com_slave_start`	`long_counter`	Count of SLAVE START statements
mysql	status	`Com_slave_stop`	`long_counter`	Count of SLAVE STOP statements
mysql	status	`Com_stmt_close`	`long_counter`	Count of STATEMENT CLOSE statements
mysql	status	`Com_stmt_execute`	`long_counter`	Count of STATEMENT EXECUTE statements
mysql	status	`Com_stmt_fetch`	`long_counter`	Count of STATEMENT FETCH statements
mysql	status	`Com_stmt_prepare`	`long_counter`	Count of STATEMENT PREPARE statements
mysql	status	`Com_stmt_reprepare`	`long_counter`	MISSING
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`	MISSING
mysql	status	`Com_unlock_tables`	`long_counter`	Count of UNLOCK TABLES statements
mysql	status	`Com_update`	`long_counter`	Count of UPDATE statements
mysql	status	`Com_update_multi`	`long_counter`	Count of multiple UPDATE statements
mysql	status	`Com_xa_commit`	`long_counter`	Count of XA COMMIT statements
mysql	status	`Com_xa_end`	`long_counter`	Count of XA END statements
mysql	status	`Com_xa_prepare`	`long_counter`	Count of XA PREPARE statements
mysql	status	`Com_xa_recover`	`long_counter`	Count of XA RECOVER statements
mysql	status	`Com_xa_rollback`	`long_counter`	Count of XA ROLLBACK statements
mysql	status	`Com_xa_start`	`long_counter`	Count of XA START statements
mysql	status	`Compression`	`string`	General.Features
mysql	status	`Connections`	`long_counter`	The number of connection attempts
mysql	status	`Created_tmp_disk_tables`	`long_counter`	General.Temporary
mysql	status	`Created_tmp_files`	`long_counter`	How many temporary files mysqld has created
mysql	status	`Created_tmp_tables`	`long_counter`	How many temporary tables mysqld has created
mysql	status	`Delayed_errors`	`long_counter`	Performance.Delayed
mysql	status	`Delayed_insert_threads`	`long`	The number of INSERT DELAYED thread handlers in use
mysql	status	`Delayed_writes`	`long_counter`	The number of INSERT DELAYED rows written
mysql	status	`displayname`	`string`	The display name of the server in the Dashboard
mysql	status	`Flush_commands`	`long_counter`	The number of FLUSH statements executed
mysql	status	`groupname`	`string`	The name of the group to which the server belongs
mysql	status	`Handler_commit`	`long_counter`	The number of internal COMMIT statements
mysql	status	`Handler_delete`	`long_counter`	The number of times that rows have been deleted from tables
mysql	status	`Handler_discover`	`long_counter`	Indicates the number of times that tables have been discovered
mysql	status	`Handler_prepare`	`long_counter`	A counter for the prepare phase of two-phase commit operations
mysql	status	`Handler_read_first`	`long_counter`	The number of times the first entry was read from an index
mysql	status	`Handler_read_key`	`long_counter`	The number of requests to read a row based on a key
mysql	status	`Handler_read_next`	`long_counter`	The number of requests to read the next row in key order
mysql	status	`Handler_read_prev`	`long_counter`	The number of requests to read the previous row in key order
mysql	status	`Handler_read_rnd`	`long_counter`	The number of requests to read a row based on a fixed position
mysql	status	`Handler_read_rnd_next`	`long_counter`	The number of requests to read the next row in the data file
mysql	status	`Handler_rollback`	`long_counter`	Miscellaneous.Handler
mysql	status	`Handler_savepoint`	`long_counter`	The number of requests for a storage engine to place a savepoint
mysql	status	`Handler_savepoint_rollback`	`long_counter`	The number of requests for a storage engine to roll back to a savepoint
mysql	status	`Handler_update`	`long_counter`	The number of requests to update a row in a table
mysql	status	`Handler_write`	`long_counter`	The number of requests to insert a row in a table
mysql	status	`Innodb_buffer_pool_pages_data`	`long`	The number of pages containing data (dirty or clean)
mysql	status	`Innodb_buffer_pool_pages_dirty`	`long`	The number of pages currently dirty
mysql	status	`Innodb_buffer_pool_pages_flushed`	`long_counter`	The number of buffer pool page-flush requests
mysql	status	`Innodb_buffer_pool_pages_free`	`long`	The number of buffer pool pages free
mysql	status	`Innodb_buffer_pool_pages_latched`	`long`	The number of latched pages in InnoDB buffer pool
mysql	status	`Innodb_buffer_pool_pages_misc`	`long`	Performance.InnoDB
mysql	status	`Innodb_buffer_pool_pages_total`	`long`	The total size of the buffer pool, in pages
mysql	status	`Innodb_buffer_pool_read_ahead_rnd`	`long_counter`	The number of random read-aheads initiated by InnoDB
mysql	status	`Innodb_buffer_pool_read_ahead_seq`	`long_counter`	The number of sequential read-aheads initiated by InnoDB
mysql	status	`Innodb_buffer_pool_read_requests`	`long_counter`	The number of logical read requests InnoDB has done
mysql	status	`Innodb_buffer_pool_reads`	`long_counter`	Performance.InnoDB
mysql	status	`Innodb_buffer_pool_wait_free`	`long_counter`	Counts number of waits for pages to be flushed
mysql	status	`Innodb_buffer_pool_write_requests`	`long_counter`	The number of writes done to the buffer pool
mysql	status	`Innodb_data_fsyncs`	`long_counter`	The number of fsync() operations so far
mysql	status	`Innodb_data_pending_fsyncs`	`long`	The current number of pending fsync() operations
mysql	status	`Innodb_data_pending_reads`	`long`	The current number of pending reads
mysql	status	`Innodb_data_pending_writes`	`long`	The number of pending writes
mysql	status	`Innodb_data_read`	`long_counter`	The amount of data read so far, in bytes
mysql	status	`Innodb_data_reads`	`long_counter`	The total number of data reads
mysql	status	`Innodb_data_writes`	`long_counter`	The total number of data writes
mysql	status	`Innodb_data_written`	`long_counter`	The amount of data written in bytes
mysql	status	`Innodb_dblwr_pages_written`	`long_counter`	The number of doublewrite pages that have been written
mysql	status	`Innodb_dblwr_writes`	`long_counter`	The number of doublewrite operations that have been performed
mysql	status	`Innodb_log_waits`	`long_counter`	Performance.InnoDB
mysql	status	`Innodb_log_write_requests`	`long_counter`	The number of log write requests
mysql	status	`Innodb_log_writes`	`long_counter`	The number of physical writes to the log
mysql	status	`Innodb_os_log_fsyncs`	`long_counter`	The number of fsync() writes done to the log file
mysql	status	`Innodb_os_log_pending_fsyncs`	`long`	The number of pending log file fsync() operations
mysql	status	`Innodb_os_log_pending_writes`	`long`	The number of pending log file writes
mysql	status	`Innodb_os_log_written`	`long_counter`	The number of bytes written to the log file
mysql	status	`Innodb_page_size`	`long`	The compiled-in InnoDB page size
mysql	status	`Innodb_pages_created`	`long_counter`	The number of pages created
mysql	status	`Innodb_pages_read`	`long_counter`	The number of pages read
mysql	status	`Innodb_pages_written`	`long_counter`	The number of pages written
mysql	status	`Innodb_row_lock_current_waits`	`long`	The number of row locks currently being waited for
mysql	status	`Innodb_row_lock_time`	`long_counter`	The total time spent in acquiring row locks, in milliseconds
mysql	status	`Innodb_row_lock_time_avg`	`long`	The average time to acquire a row lock, in milliseconds
mysql	status	`Innodb_row_lock_time_max`	`long`	The maximum time to acquire a row lock, in milliseconds
mysql	status	`Innodb_row_lock_waits`	`long_counter`	The number of times a row lock had to be waited for
mysql	status	`Innodb_rows_deleted`	`long_counter`	The number of rows deleted from InnoDB tables
mysql	status	`Innodb_rows_inserted`	`long_counter`	The number of rows inserted into InnoDB tables
mysql	status	`Innodb_rows_read`	`long_counter`	The number of rows read from InnoDB tables
mysql	status	`Innodb_rows_updated`	`long_counter`	The number of rows updated in InnoDB tables
mysql	status	`Key_blocks_not_flushed`	`long`	Performance.Keys
mysql	status	`Key_blocks_unused`	`long`	The number of unused blocks in the key cache
mysql	status	`Key_blocks_used`	`long`	The number of used blocks in the key cache
mysql	status	`Key_read_requests`	`long_counter`	The number of requests to read a key block from the cache
mysql	status	`Key_reads`	`long_counter`	The number of physical reads of a key block from disk
mysql	status	`Key_write_requests`	`long_counter`	The number of requests to write a key block to the cache
mysql	status	`Key_writes`	`long_counter`	The number of physical writes of a key block to disk
mysql	status	`Last_query_cost`	`long`	Performance.Cost
mysql	status	`Max_used_connections`	`long`	Networking.Overview
mysql	status	`Ndb_number_of_data_nodes`	`long`	MISSING
mysql	status	`Ndb_number_of_ready_data_nodes`	`long`	MISSING
mysql	status	`Not_flushed_delayed_rows`	`long`	The number of rows waiting to be written in INSERT DELAY queues
mysql	status	`Open_files`	`long`	The number of files that are open
mysql	status	`Open_streams`	`long`	The number of streams that are open (used mainly for logging)
mysql	status	`Open_table_definitions`	`long`	MISSING
mysql	status	`Open_tables`	`long`	The number of tables that are open
mysql	status	`Opened_files`	`long_counter`	MISSING
mysql	status	`Opened_table_definitions`	`long_counter`	MISSING
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`	MISSING
mysql	status	`Questions`	`long_counter`	The number of statements that clients have sent to the server
mysql	status	`Rpl_status`	`long`	The status of fail-safe replication (not yet implemented)
mysql	status	`Select_full_join`	`long_counter`	Performance.Selects
mysql	status	`Select_full_range_join`	`long_counter`	The number of joins that used a range search on a reference table
mysql	status	`Select_range`	`long_counter`	The number of joins that used ranges on the first table
mysql	status	`Select_range_check`	`long_counter`	The number of joins without keys that check for key usage after each row
mysql	status	`Select_scan`	`long_counter`	The number of joins that did a full scan of the first table
mysql	status	`Slave_open_temp_tables`	`long`	Networking.Replication
mysql	status	`Slave_retried_transactions`	`long_counter`	Networking.Replication
mysql	status	`Slave_running`	`string`	This is ON if this server is a slave that is connected to a master
mysql	status	`Slow_launch_threads`	`long_counter`	Performance.Slow Items
mysql	status	`Slow_queries`	`long_counter`	The number of queries that have taken more than long_query_time seconds
mysql	status	`Sort_merge_passes`	`long_counter`	The number of merge passes that the sort algorithm has had to do
mysql	status	`Sort_range`	`long_counter`	The number of sorts that were done using ranges
mysql	status	`Sort_rows`	`long_counter`	The number of sorted rows
mysql	status	`Sort_scan`	`long_counter`	The number of sorts that were done by scanning the table
mysql	status	`Ssl_accept_renegotiates`	`long_counter`	The number of renegotiates needed to establish the connection
mysql	status	`Ssl_accepts`	`long_counter`	The number of attempted SSL connections
mysql	status	`Ssl_callback_cache_hits`	`long_counter`	The number of callback cache hits
mysql	status	`Ssl_cipher`	`string`	SSL cipher to use (implies --ssl)
mysql	status	`Ssl_cipher_list`	`string`	The list of SSL cipher strings
mysql	status	`Ssl_client_connects`	`long_counter`	The number of attempted connections to an SSL enabled master
mysql	status	`Ssl_connect_renegotiates`	`long_counter`	Number of renegotiates needed to connect to an SSL-enabled master
mysql	status	`Ssl_ctx_verify_depth`	`long`	The SSL context verification depth
mysql	status	`Ssl_ctx_verify_mode`	`long`	The SSL certificate verification mode used by the server
mysql	status	`Ssl_default_timeout`	`long`	The SSL default timeout
mysql	status	`Ssl_finished_accepts`	`long_counter`	The number of successful SSL connections to the server
mysql	status	`Ssl_finished_connects`	`long_counter`	The number of successful SSL slave connections to the server
mysql	status	`Ssl_session_cache_hits`	`long_counter`	The number of SSL session cache hits
mysql	status	`Ssl_session_cache_misses`	`long_counter`	The number of SSL session cache misses
mysql	status	`Ssl_session_cache_mode`	`string`	The SSL session cache mode
mysql	status	`Ssl_session_cache_overflows`	`long_counter`	The number of SSL cache overflows
mysql	status	`Ssl_session_cache_size`	`long`	The size of the SSL session cache
mysql	status	`Ssl_session_cache_timeouts`	`long_counter`	The number of session cache timeouts
mysql	status	`Ssl_sessions_reused`	`long`	The number of SSL sessions from the cache that were reused
mysql	status	`Ssl_used_session_cache_entries`	`long`	The number of SSL session cache entries used
mysql	status	`Ssl_verify_depth`	`long`	Depth of verification for replication SSL connections
mysql	status	`Ssl_verify_mode`	`long`	Mode of veritifaction for replication SSL connections
mysql	status	`Ssl_version`	`string`	The SSL version number
mysql	status	`Table_locks_immediate`	`long_counter`	The number of times that a table lock was acquired immediately
mysql	status	`Table_locks_waited`	`long_counter`	Performance.Locks
mysql	status	`Tc_log_max_pages_used`	`long`	General.Logging
mysql	status	`Tc_log_page_size`	`long`	General.Logging
mysql	status	`Tc_log_page_waits`	`long`	General.Logging
mysql	status	`Threads_cached`	`long`	The number of threads in the thread cache
mysql	status	`Threads_connected`	`long`	The number of currently open connections
mysql	status	`Threads_created`	`long_counter`	The number of threads created to handle connections
mysql	status	`Threads_running`	`long`	The number of threads that are not sleeping
mysql	status	`Uptime`	`long`	The number of seconds the server has been up
mysql	status	`Uptime_since_flush_status`	`long_counter`	MISSING
mysql	strong_privileges	`user`	`string`	MISSING
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`	MISSING
mysql	tables_no_unique_keys	`table_list`	`string`	MISSING
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`	MISSING
mysql	transactions_in_serial_log	`transactions_in_serial_log`	`long`	MISSING
mysql	trigger_with_select_star	`trigger_defn`	`string`	MISSING
mysql	user_on_missing_db	`db_name`	`string`	MISSING
mysql	user_on_missing_db	`user`	`string`	MISSING
mysql	user_on_missing_table	`user`	`string`	MISSING
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`	MISSING
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`	MISSING
mysql	variables	`binlog_cache_size`	`long`	Memory.Caches
mysql	variables	`binlog_direct_non_transactional_updates`	`string`	MISSING
mysql	variables	`binlog_format`	`string`	MISSING
mysql	variables	`bulk_insert_buffer_size`	`long`	Size of tree cache used in bulk insert optimization
mysql	variables	`character_set_client`	`string`	Current client character set
mysql	variables	`character_set_connection`	`string`	Current connection character set
mysql	variables	`character_set_database`	`string`	The character set used by the default database
mysql	variables	`character_set_filesystem`	`string`	Set the file system character set
mysql	variables	`character_set_results`	`string`	Current result character set
mysql	variables	`character_set_server`	`string`	SQL.Charsets
mysql	variables	`character_set_system`	`string`	The character set used by the server for storing identifiers
mysql	variables	`character_sets_dir`	`string`	Directory where character sets are
mysql	variables	`collation_connection`	`string`	The collation of the connection
mysql	variables	`collation_database`	`string`	The collation used by the default database
mysql	variables	`collation_server`	`string`	Set the default collation
mysql	variables	`completion_type`	`long`	Default completion type
mysql	variables	`concurrent_insert`	`string`	Use concurrent insert with MyISAM
mysql	variables	`connect_timeout`	`long`	Connections.Overview
mysql	variables	`datadir`	`string`	Path to the database root
mysql	variables	`date_format`	`string`	The DATE format (For future)
mysql	variables	`datetime_format`	`string`	The DATETIME/TIMESTAMP format (for future)
mysql	variables	`default_week_format`	`long`	The default week format used by WEEK() functions
mysql	variables	`delay_key_write`	`string`	Type of DELAY_KEY_WRITE
mysql	variables	`delayed_insert_limit`	`long`	General.Performance
mysql	variables	`delayed_insert_timeout`	`long`	General.Performance
mysql	variables	`delayed_queue_size`	`long`	General.Performance
mysql	variables	`div_precision_increment`	`long`	SQL.Formats
mysql	variables	`engine_condition_pushdown`	`string`	Push supported query conditions to the storage engine
mysql	variables	`error_count`	`long`	MISSING
mysql	variables	`event_scheduler`	`string`	MISSING
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`	MISSING
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`	MISSING
mysql	variables	`general_log_file`	`string`	MISSING
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`	MISSING
mysql	variables	`have_compress`	`string`	Availability of the zlib compression library
mysql	variables	`have_crypt`	`string`	Availability of the crypt() system call
mysql	variables	`have_csv`	`string`	Whether mysqld supports csv tables
mysql	variables	`have_dynamic_loading`	`string`	Whether mysqld supports dynamic loading of plugins
mysql	variables	`have_example_engine`	`string`	Whether mysqld supports EXAMPLE tables
mysql	variables	`have_federated_engine`	`string`	Whether mysqld supports FEDERATED tables
mysql	variables	`have_geometry`	`string`	Whether mysqld supports spatial data types
mysql	variables	`have_innodb`	`string`	Whether mysqld supports InnoDB tables
mysql	variables	`have_isam`	`string`	Whether mysqld supports isam tables
mysql	variables	`have_merge_engine`	`string`	Whether mysqld supports merge tables
mysql	variables	`have_ndbcluster`	`string`	Whether mysqld supports NDB Cluster tables
mysql	variables	`have_openssl`	`string`	Whether mysqld supports ssl connections
mysql	variables	`have_partitioning`	`string`	MISSING
mysql	variables	`have_profiling`	`string`	MISSING
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`	MISSING
mysql	variables	`ignore_builtin_innodb`	`string`	MISSING
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`	MISSING
mysql	variables	`innodb_adaptive_hash_index`	`string`	MISSING
mysql	variables	`innodb_additional_mem_pool_size`	`long`	Memory.Buffers
mysql	variables	`innodb_autoextend_increment`	`long`	Data file autoextend increment in megabytes
mysql	variables	`innodb_autoinc_lock_mode`	`long`	MISSING
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`	MISSING
mysql	variables	`innodb_checksums`	`string`	Enable InnoDB checksums validation
mysql	variables	`innodb_commit_concurrency`	`long`	Helps in performance tuning in heavily concurrent environments
mysql	variables	`innodb_concurrency_tickets`	`long`	Table Types.InnoDB
mysql	variables	`innodb_data_file_path`	`string`	Path to individual files and their sizes
mysql	variables	`innodb_data_home_dir`	`string`	The common part for InnoDB table spaces
mysql	variables	`innodb_doublewrite`	`string`	Enable InnoDB doublewrite buffer
mysql	variables	`innodb_fast_shutdown`	`long`	Speeds up the shutdown process of the InnoDB storage engine
mysql	variables	`innodb_file_format`	`string`	MISSING
mysql	variables	`innodb_file_format_check`	`string`	MISSING
mysql	variables	`innodb_file_io_threads`	`long`	Number of file I/O threads in InnoDB
mysql	variables	`innodb_file_per_table`	`string`	Stores each InnoDB table to an .ibd file in the database dir
mysql	variables	`innodb_flush_log_at_trx_commit`	`long`	Table Types.InnoDB
mysql	variables	`innodb_flush_method`	`string`	With which method to flush data
mysql	variables	`innodb_force_recovery`	`long`	Table Types.InnoDB
mysql	variables	`innodb_io_capacity`	`long`	MISSING
mysql	variables	`innodb_lock_wait_timeout`	`long`	Table Types.InnoDB
mysql	variables	`innodb_locks_unsafe_for_binlog`	`string`	Table Types.InnoDB
mysql	variables	`innodb_log_arch_dir`	`string`	Where full logs should be archived
mysql	variables	`innodb_log_archive`	`string`	Set to 1 if you want to have logs archived
mysql	variables	`innodb_log_buffer_size`	`long`	General.Logs
mysql	variables	`innodb_log_file_size`	`long`	Size of each log file in a log group
mysql	variables	`innodb_log_files_in_group`	`long`	General.Logs
mysql	variables	`innodb_log_group_home_dir`	`string`	Path to InnoDB log files
mysql	variables	`innodb_max_dirty_pages_pct`	`long`	Percentage of dirty pages allowed in bufferpool
mysql	variables	`innodb_max_purge_lag`	`long`	Desired maximum length of the purge queue (0 = no limit)
mysql	variables	`innodb_mirrored_log_groups`	`long`	Number of identical copies of log groups we keep for the database
mysql	variables	`innodb_old_blocks_pct`	`long`	MISSING
mysql	variables	`innodb_old_blocks_time`	`long`	MISSING
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`	MISSING
mysql	variables	`innodb_read_io_threads`	`long`	MISSING
mysql	variables	`innodb_rollback_on_timeout`	`string`	Unknown.Unknown
mysql	variables	`innodb_spin_wait_delay`	`long`	MISSING
mysql	variables	`innodb_stats_on_metadata`	`string`	MISSING
mysql	variables	`innodb_stats_sample_pages`	`long`	MISSING
mysql	variables	`innodb_strict_mode`	`string`	MISSING
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`	MISSING
mysql	variables	`innodb_use_sys_malloc`	`string`	MISSING
mysql	variables	`innodb_write_io_threads`	`long`	MISSING
mysql	variables	`insert_id`	`long`	MISSING
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`	MISSING
mysql	variables	`key_buffer_size`	`long`	The size of the buffer used for index blocks for MyISAM tables
mysql	variables	`key_cache_age_threshold`	`long`	Memory.Caches
mysql	variables	`key_cache_block_size`	`long`	The default size of key cache blocks
mysql	variables	`key_cache_division_limit`	`long`	The minimum percentage of warm blocks in key cache
mysql	variables	`language`	`string`	Client error messages in given language. May be given as a full path
mysql	variables	`large_files_support`	`string`	Whether large files are supported
mysql	variables	`large_page_size`	`long`	General.Features
mysql	variables	`large_pages`	`string`	Enable support for large pages
mysql	variables	`last_insert_id`	`long`	MISSING
mysql	variables	`lc_time_names`	`string`	General.Miscellaneous
mysql	variables	`license`	`string`	Type of license for the server
mysql	variables	`local_infile`	`string`	Enable/disable LOAD DATA LOCAL INFILE (takes values 1\|0)
mysql	variables	`locked_in_memory`	`long`	Whether mysqld is locked in memory with --memlock
mysql	variables	`log`	`string`	Log connections and queries to file
mysql	variables	`log_bin`	`string`	Enables binary log
mysql	variables	`log_bin_trust_function_creators`	`string`	General.Logs
mysql	variables	`log_bin_trust_routine_creators`	`string`	(deprecated) Use log-bin-trust-function-creators
mysql	variables	`log_error`	`string`	Error log file
mysql	variables	`log_output`	`string`	MISSING
mysql	variables	`log_queries_not_using_indexes`	`string`	General.Logs
mysql	variables	`log_slave_updates`	`string`	General.Logs
mysql	variables	`log_slow_queries`	`string`	General.Logs
mysql	variables	`log_update`	`string`	General.Logs
mysql	variables	`log_warnings`	`long`	Log some not critical warnings to the log file
mysql	variables	`long_query_time`	`long`	General.Performance
mysql	variables	`low_priority_updates`	`string`	INSERT/DELETE/UPDATE has lower priority than selects
mysql	variables	`lower_case_file_system`	`string`	General.Features
mysql	variables	`lower_case_table_names`	`long`	SQL.Overview
mysql	variables	`max_allowed_packet`	`long`	Max packetlength to send/receive from to server
mysql	variables	`max_binlog_cache_size`	`long`	General.Logs
mysql	variables	`max_binlog_size`	`long`	General.Logs
mysql	variables	`max_connect_errors`	`long`	Connections.Overview
mysql	variables	`max_connections`	`long`	The number of simultaneous clients allowed
mysql	variables	`max_delayed_threads`	`long`	General.Performance
mysql	variables	`max_error_count`	`long`	Max number of errors/warnings to store for a statement
mysql	variables	`max_heap_table_size`	`long`	Don't allow creation of heap tables bigger than this
mysql	variables	`max_insert_delayed_threads`	`long`	This variable is a synonym for max_delayed_threads
mysql	variables	`max_join_size`	`long`	General.Performance
mysql	variables	`max_length_for_sort_data`	`long`	Max number of bytes in sorted records
mysql	variables	`max_prepared_stmt_count`	`long`	Maximum number of prepared statements in the server
mysql	variables	`max_relay_log_size`	`long`	General.Logs
mysql	variables	`max_seeks_for_key`	`long`	Limit assumed max number of seeks when looking up rows based on a key
mysql	variables	`max_sort_length`	`long`	The number of bytes to use when sorting BLOB or TEXT values
mysql	variables	`max_sp_recursion_depth`	`long`	Maximum stored procedure recursion depth
mysql	variables	`max_tmp_tables`	`long`	Maximum number of temporary tables a client can keep open at a time
mysql	variables	`max_user_connections`	`long`	Connections.Overview
mysql	variables	`max_write_lock_count`	`long`	After this many write locks, allow some read locks to run in between
mysql	variables	`min_examined_row_limit`	`long`	MISSING
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`	MISSING
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`	MISSING
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`	MISSING
mysql	variables	`old_alter_table`	`string`	MISSING
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`	MISSING
mysql	variables	`pid_file`	`string`	Pid file used by safe_mysqld
mysql	variables	`plugin_dir`	`string`	MISSING
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`	MISSING
mysql	variables	`profiling_history_size`	`string`	MISSING
mysql	variables	`protocol_version`	`long`	The version of the client/server protocol used by the MySQL server
mysql	variables	`pseudo_thread_id`	`long`	MISSING
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`	MISSING
mysql	variables	`rand_seed2`	`long`	MISSING
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`	MISSING
mysql	variables	`relay_log_index`	`string`	MISSING
mysql	variables	`relay_log_info_file`	`string`	MISSING
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`	MISSING
mysql	variables	`report_password`	`string`	MISSING
mysql	variables	`report_port`	`long`	MISSING
mysql	variables	`report_user`	`string`	MISSING
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`	MISSING
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`	MISSING
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`	MISSING
mysql	variables	`slow_query_log_file`	`string`	MISSING
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`	MISSING
mysql	variables	`sql_big_selects`	`string`	General.Features
mysql	variables	`sql_big_tables`	`string`	MISSING
mysql	variables	`sql_buffer_result`	`string`	MISSING
mysql	variables	`sql_log_bin`	`string`	MISSING
mysql	variables	`sql_log_off`	`string`	MISSING
mysql	variables	`sql_log_update`	`string`	MISSING
mysql	variables	`sql_low_priority_updates`	`string`	MISSING
mysql	variables	`sql_max_join_size`	`long`	MISSING
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`	MISSING
mysql	variables	`sql_safe_updates`	`string`	MISSING
mysql	variables	`sql_select_limit`	`long`	MISSING
mysql	variables	`sql_slave_skip_counter`	`long`	MISSING
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`	MISSING
mysql	variables	`table_lock_wait_timeout`	`long`	General.Miscellaneous
mysql	variables	`table_open_cache`	`long`	MISSING
mysql	variables	`table_type`	`string`	A synonym for storage_engine
mysql	variables	`thread_cache_size`	`long`	How many threads we should keep in a cache for reuse
mysql	variables	`thread_handling`	`string`	MISSING
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`	MISSING
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`	MISSING
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`	MISSING
mysql	waiting_db	`waiting_db`	`string`	MISSING
mysql	waiting_statement	`waiting_statement`	`string`	MISSING
mysql	waiting_thread	`waiting_thread`	`long`	MISSING
mysql	waiting_time	`waiting_time`	`long`	MISSING
mysql	waiting_user	`waiting_user`	`string`	MISSING
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`	MISSING
os	disk	`disk_servicetime`	`double`	MISSING
os	disk	`disk_snaptime`	`long`	MISSING
os	disk	`disk_time`	`long`	MISSING
os	disk	`disk_writes`	`long_counter`	The number of disk writes
os	disk	`disk_wtime`	`long`	MISSING
os	disk	`fs_avail`	`long`	The amount of available space for the mount point
os	disk	`fs_files`	`long`	The number of files on the mount point
os	disk	`fs_free_files`	`long`	The number of free files on the mount point
os	disk	`fs_total`	`long`	The total amount of space for the mount point
os	disk	`fs_unused`	`long`	The amount of unused space for the mount point
os	disk	`fs_used`	`long`	The amount of used space for the mount point
os	fs	`fs_avail`	`long`	MISSING
os	fs	`fs_dev_name`	`string`	MISSING
os	fs	`fs_dir_name`	`string`	MISSING
os	fs	`fs_files`	`long`	MISSING
os	fs	`fs_flags`	`long`	MISSING
os	fs	`fs_free_files`	`long`	MISSING
os	fs	`fs_options`	`string`	MISSING
os	fs	`fs_sys_type_name`	`string`	MISSING
os	fs	`fs_total`	`long`	MISSING
os	fs	`fs_type_name`	`string`	MISSING
os	fs	`fs_unused`	`long`	MISSING
os	fs	`fs_used`	`long`	MISSING
os	Host	`host_id`	`string`	The host unique identifier
os	Host	`name`	`string`	MISSING
os	loadavg	`0`	`double`	MISSING
os	loadavg	`1`	`double`	MISSING
os	loadavg	`2`	`double`	MISSING
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`	MISSING
os	mem	`swap_page_out`	`long`	MISSING
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`	MISSING
util	LogHistogram	`1`	`long_counter`	MISSING
util	LogHistogram	`10`	`long_counter`	MISSING
util	LogHistogram	`11`	`long_counter`	MISSING
util	LogHistogram	`12`	`long_counter`	MISSING
util	LogHistogram	`13`	`long_counter`	MISSING
util	LogHistogram	`14`	`long_counter`	MISSING
util	LogHistogram	`15`	`long_counter`	MISSING
util	LogHistogram	`16`	`long_counter`	MISSING
util	LogHistogram	`17`	`long_counter`	MISSING
util	LogHistogram	`18`	`long_counter`	MISSING
util	LogHistogram	`19`	`long_counter`	MISSING
util	LogHistogram	`2`	`long_counter`	MISSING
util	LogHistogram	`20`	`long_counter`	MISSING
util	LogHistogram	`21`	`long_counter`	MISSING
util	LogHistogram	`22`	`long_counter`	MISSING
util	LogHistogram	`23`	`long_counter`	MISSING
util	LogHistogram	`24`	`long_counter`	MISSING
util	LogHistogram	`25`	`long_counter`	MISSING
util	LogHistogram	`26`	`long_counter`	MISSING
util	LogHistogram	`27`	`long_counter`	MISSING
util	LogHistogram	`28`	`long_counter`	MISSING
util	LogHistogram	`29`	`long_counter`	MISSING
util	LogHistogram	`3`	`long_counter`	MISSING
util	LogHistogram	`30`	`long_counter`	MISSING
util	LogHistogram	`31`	`long_counter`	MISSING
util	LogHistogram	`32`	`long_counter`	MISSING
util	LogHistogram	`33`	`long_counter`	MISSING
util	LogHistogram	`34`	`long_counter`	MISSING
util	LogHistogram	`35`	`long_counter`	MISSING
util	LogHistogram	`36`	`long_counter`	MISSING
util	LogHistogram	`37`	`long_counter`	MISSING
util	LogHistogram	`38`	`long_counter`	MISSING
util	LogHistogram	`39`	`long_counter`	MISSING
util	LogHistogram	`4`	`long_counter`	MISSING
util	LogHistogram	`40`	`long_counter`	MISSING
util	LogHistogram	`41`	`long_counter`	MISSING
util	LogHistogram	`42`	`long_counter`	MISSING
util	LogHistogram	`43`	`long_counter`	MISSING
util	LogHistogram	`44`	`long_counter`	MISSING
util	LogHistogram	`45`	`long_counter`	MISSING
util	LogHistogram	`46`	`long_counter`	MISSING
util	LogHistogram	`47`	`long_counter`	MISSING
util	LogHistogram	`48`	`long_counter`	MISSING
util	LogHistogram	`49`	`long_counter`	MISSING
util	LogHistogram	`5`	`long_counter`	MISSING
util	LogHistogram	`50`	`long_counter`	MISSING
util	LogHistogram	`51`	`long_counter`	MISSING
util	LogHistogram	`52`	`long_counter`	MISSING
util	LogHistogram	`53`	`long_counter`	MISSING
util	LogHistogram	`54`	`long_counter`	MISSING
util	LogHistogram	`55`	`long_counter`	MISSING
util	LogHistogram	`56`	`long_counter`	MISSING
util	LogHistogram	`57`	`long_counter`	MISSING
util	LogHistogram	`58`	`long_counter`	MISSING
util	LogHistogram	`59`	`long_counter`	MISSING
util	LogHistogram	`6`	`long_counter`	MISSING
util	LogHistogram	`60`	`long_counter`	MISSING
util	LogHistogram	`61`	`long_counter`	MISSING
util	LogHistogram	`62`	`long_counter`	MISSING
util	LogHistogram	`7`	`long_counter`	MISSING
util	LogHistogram	`8`	`long_counter`	MISSING
util	LogHistogram	`9`	`long_counter`	MISSING
util	LogHistogram	`base`	`long`	MISSING
util	LogHistogram	`nul`	`long_counter`	MISSING

Prev		Next
Appendix C. MySQL Enterprise Monitor Component Reference	Home	Appendix E. Error codes