Appendix D. Data Collection Items
Prev		Next

Appendix D. Data Collection Items

Note

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

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

Table D.1. MySQL Monitor Data Items

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`	General.Logging
mysql	status	`Binlog_cache_use`	`long`	The number of transactions that used the temporary binary log cache.
mysql	status	`Bytes_received`	`long_counter`	The number of bytes received from all clients.
mysql	status	`Bytes_sent`	`long_counter`	The number of bytes sent to all clients.
mysql	status	`Com_admin_commands`	`long_counter`	Count of admin commands.
mysql	status	`Com_alter_db`	`long_counter`	Count of ALTER DATABASE statements.
mysql	status	`Com_alter_db_upgrade`	`long_counter`
mysql	status	`Com_alter_event`	`long_counter`
mysql	status	`Com_alter_function`	`long_counter`
mysql	status	`Com_alter_procedure`	`long_counter`
mysql	status	`Com_alter_server`	`long_counter`
mysql	status	`Com_alter_table`	`long_counter`	Count of ALTER TABLE statements.
mysql	status	`Com_alter_tablespace`	`long_counter`
mysql	status	`Com_analyze`	`long_counter`	Count of ANALYZE statements.
mysql	status	`Com_assign_to_keycache`	`long_counter`
mysql	status	`Com_backup_table`	`long_counter`	Count of BACKUP TABLE statements.
mysql	status	`Com_begin`	`long_counter`	Count of BEGIN statements.
mysql	status	`Com_binlog`	`long_counter`
mysql	status	`Com_call_procedure`	`long_counter`	Number of calls to stored procedures.
mysql	status	`Com_change_db`	`long_counter`	Count of CHANGE DATABASE statements.
mysql	status	`Com_change_master`	`long_counter`	Count of CHANGE MASTER statements.
mysql	status	`Com_check`	`long_counter`	Count of CHECK statements.
mysql	status	`Com_checksum`	`long_counter`	Count of CHECKSUM statements.
mysql	status	`Com_commit`	`long_counter`	Count of COMMIT statements.
mysql	status	`Com_create_db`	`long_counter`	Count of CREATE DATABASE statements.
mysql	status	`Com_create_event`	`long_counter`
mysql	status	`Com_create_function`	`long_counter`	Count of CREATE FUNCTION statements.
mysql	status	`Com_create_index`	`long_counter`	Count of CREATE INDEX statements.
mysql	status	`Com_create_procedure`	`long_counter`
mysql	status	`Com_create_server`	`long_counter`
mysql	status	`Com_create_table`	`long_counter`	Count of CREATE TABLE statements.
mysql	status	`Com_create_trigger`	`long_counter`
mysql	status	`Com_create_udf`	`long_counter`
mysql	status	`Com_create_user`	`long_counter`	Count of CREATE USER statements.
mysql	status	`Com_create_view`	`long_counter`
mysql	status	`Com_dealloc_sql`	`long_counter`	Count of DEALLOCATE PREPARE statements.
mysql	status	`Com_delete`	`long_counter`	Count of DELETE statements.
mysql	status	`Com_delete_multi`	`long_counter`	Count of 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`	`string`	Use concurrent insert with MyISAM.
mysql	variables	`connect_timeout`	`long`	Connections.Overview
mysql	variables	`datadir`	`string`	Path to the database root.
mysql	variables	`date_format`	`string`	The DATE format (For future)
mysql	variables	`datetime_format`	`string`	The DATETIME/TIMESTAMP format (for future)
mysql	variables	`default_week_format`	`long`	The default week format used by WEEK() functions.
mysql	variables	`delay_key_write`	`string`	Type of DELAY_KEY_WRITE.
mysql	variables	`delayed_insert_limit`	`long`	General.Performance
mysql	variables	`delayed_insert_timeout`	`long`	General.Performance
mysql	variables	`delayed_queue_size`	`long`	General.Performance
mysql	variables	`div_precision_increment`	`long`	SQL.Formats
mysql	variables	`engine_condition_pushdown`	`string`	Push supported query conditions to the storage engine.
mysql	variables	`error_count`	`long`
mysql	variables	`event_scheduler`	`string`
mysql	variables	`expire_logs_days`	`long`	General.Miscellaneous
mysql	variables	`flush`	`string`	Flush tables to disk between SQL commands.
mysql	variables	`flush_time`	`long`	A dedicated thread is created to flush all tables at the given interval.
mysql	variables	`foreign_key_checks`	`string`
mysql	variables	`ft_boolean_syntax`	`string`	List of operators for MATCH ... AGAINST ( ... IN BOOLEAN MODE).
mysql	variables	`ft_max_word_len`	`long`	SQL.Full Text Search
mysql	variables	`ft_min_word_len`	`long`	SQL.Full Text Search
mysql	variables	`ft_query_expansion_limit`	`long`	Number of best matches to use for query expansion.
mysql	variables	`ft_stopword_file`	`string`	Use stopwords from this file instead of built-in list.
mysql	variables	`general_log`	`string`
mysql	variables	`general_log_file`	`string`
mysql	variables	`group_concat_max_len`	`long`	The maximum length of the result of function group_concat.
mysql	variables	`have_archive`	`string`	Whether mysqld supports archive tables.
mysql	variables	`have_bdb`	`string`	Is Berkeley DB supported.
mysql	variables	`have_blackhole_engine`	`string`	Whether mysqld supports BLACKHOLE tables.
mysql	variables	`have_community_features`	`string`
mysql	variables	`have_compress`	`string`	Availability of the zlib compression library.
mysql	variables	`have_crypt`	`string`	Availability of the crypt() system call.
mysql	variables	`have_csv`	`string`	Whether mysqld supports csv tables.
mysql	variables	`have_dynamic_loading`	`string`	Whether mysqld supports dynamic loading of plugins.
mysql	variables	`have_example_engine`	`string`	Whether mysqld supports EXAMPLE tables.
mysql	variables	`have_federated_engine`	`string`	Whether mysqld supports FEDERATED tables.
mysql	variables	`have_geometry`	`string`	Whether mysqld supports spatial data types.
mysql	variables	`have_innodb`	`string`	Whether mysqld supports InnoDB tables. 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`	`long`	Whether mysqld is locked in memory with --memlock.
mysql	variables	`log`	`string`	Log connections and queries to file.
mysql	variables	`log_bin`	`string`	Enables binary log.
mysql	variables	`log_bin_trust_function_creators`	`string`	General.Logs
mysql	variables	`log_bin_trust_routine_creators`	`string`	(deprecated) Use log-bin-trust-function-creators.
mysql	variables	`log_error`	`string`	Error log file.
mysql	variables	`log_output`	`string`
mysql	variables	`log_queries_not_using_indexes`	`string`	General.Logs
mysql	variables	`log_slave_updates`	`string`	General.Logs
mysql	variables	`log_slow_queries`	`string`	General.Logs
mysql	variables	`log_update`	`string`	General.Logs
mysql	variables	`log_warnings`	`long`	Log some not critical warnings to the log file.
mysql	variables	`long_query_time`	`long`	General.Performance
mysql	variables	`low_priority_updates`	`string`	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`
os	mem	`swap_page_out`	`long`
os	mem	`swap_total`	`long`	The total amount of available swap memory.
os	mem	`swap_unused`	`long`	The total amount of unused swap memory.
os	net	`address`	`string`	The address of the network interface.
os	net	`broadcast`	`string`	The network interface broadcast address.
os	net	`description`	`string`	The network interface description.
os	net	`destination`	`string`	The network interface destination address.
os	net	`flags`	`long`	The network interface flags.
os	net	`hwaddr`	`string`	The network interface MAC address.
os	net	`metric`	`long`	Operating System.Net
os	net	`mtu`	`long`	The Maximum Transmission Unit.
os	net	`name`	`string`	The network interface name (eth0, eth1 etc.)
os	net	`netmask`	`string`	The network interface subnet mask.
os	net	`rx_bytes`	`long_counter`	The number of bytes received.
os	net	`rx_dropped`	`long_counter`	The number of received packets dropped.
os	net	`rx_errors`	`long_counter`	The number of received packet errors.
os	net	`rx_frame`	`long_counter`	The number received packet frame errors.
os	net	`rx_overruns`	`long_counter`	The number of received packet overruns.
os	net	`rx_packets`	`long_counter`	The number of packets received.
os	net	`speed`	`long`	The network interface connection speed.
os	net	`tx_bytes`	`long_counter`	The number of bytes transmitted.
os	net	`tx_carrier`	`long_counter`	The number of carrier errors on network transmission.
os	net	`tx_collisions`	`long_counter`	The number of network transmission collisions.
os	net	`tx_dropped`	`long_counter`	The number of network transmissions dropped.
os	net	`tx_errors`	`long_counter`	The number of network transmission errors.
os	net	`tx_overruns`	`long_counter`	The number of network transmission overruns.
os	net	`tx_packets`	`long_counter`	The number of packets transmitted.
os	net	`type`	`string`	The network interface type (ethernet, loopback etc.)
os	os	`os_arch`	`string`	The architecture of the OS / CPU.
os	os	`os_description`	`string`	Description of the OS.
os	os	`os_machine`	`string`	Machine CPU architecture.
os	os	`os_name`	`string`	The OS name.
os	os	`os_patchlevel`	`string`	The OS patch level.
os	os	`os_vendor`	`string`	The OS vendor.
os	os	`os_vendor_code_name`	`string`	The OS vendor code name.
os	os	`os_vendor_name`	`string`	The OS vendor name.
os	os	`os_vendor_version`	`string`	The OS vendor version number.
os	os	`os_version`	`string`	The OS version number.
util	LogHistogram	`0`	`long_counter`
util	LogHistogram	`1`	`long_counter`
util	LogHistogram	`10`	`long_counter`
util	LogHistogram	`11`	`long_counter`
util	LogHistogram	`12`	`long_counter`
util	LogHistogram	`13`	`long_counter`
util	LogHistogram	`14`	`long_counter`
util	LogHistogram	`15`	`long_counter`
util	LogHistogram	`16`	`long_counter`
util	LogHistogram	`17`	`long_counter`
util	LogHistogram	`18`	`long_counter`
util	LogHistogram	`19`	`long_counter`
util	LogHistogram	`2`	`long_counter`
util	LogHistogram	`20`	`long_counter`
util	LogHistogram	`21`	`long_counter`
util	LogHistogram	`22`	`long_counter`
util	LogHistogram	`23`	`long_counter`
util	LogHistogram	`24`	`long_counter`
util	LogHistogram	`25`	`long_counter`
util	LogHistogram	`26`	`long_counter`
util	LogHistogram	`27`	`long_counter`
util	LogHistogram	`28`	`long_counter`
util	LogHistogram	`29`	`long_counter`
util	LogHistogram	`3`	`long_counter`
util	LogHistogram	`30`	`long_counter`
util	LogHistogram	`31`	`long_counter`
util	LogHistogram	`32`	`long_counter`
util	LogHistogram	`33`	`long_counter`
util	LogHistogram	`34`	`long_counter`
util	LogHistogram	`35`	`long_counter`
util	LogHistogram	`36`	`long_counter`
util	LogHistogram	`37`	`long_counter`
util	LogHistogram	`38`	`long_counter`
util	LogHistogram	`39`	`long_counter`
util	LogHistogram	`4`	`long_counter`
util	LogHistogram	`40`	`long_counter`
util	LogHistogram	`41`	`long_counter`
util	LogHistogram	`42`	`long_counter`
util	LogHistogram	`43`	`long_counter`
util	LogHistogram	`44`	`long_counter`
util	LogHistogram	`45`	`long_counter`
util	LogHistogram	`46`	`long_counter`
util	LogHistogram	`47`	`long_counter`
util	LogHistogram	`48`	`long_counter`
util	LogHistogram	`49`	`long_counter`
util	LogHistogram	`5`	`long_counter`
util	LogHistogram	`50`	`long_counter`
util	LogHistogram	`51`	`long_counter`
util	LogHistogram	`52`	`long_counter`
util	LogHistogram	`53`	`long_counter`
util	LogHistogram	`54`	`long_counter`
util	LogHistogram	`55`	`long_counter`
util	LogHistogram	`56`	`long_counter`
util	LogHistogram	`57`	`long_counter`
util	LogHistogram	`58`	`long_counter`
util	LogHistogram	`59`	`long_counter`
util	LogHistogram	`6`	`long_counter`
util	LogHistogram	`60`	`long_counter`
util	LogHistogram	`61`	`long_counter`
util	LogHistogram	`62`	`long_counter`
util	LogHistogram	`7`	`long_counter`
util	LogHistogram	`8`	`long_counter`
util	LogHistogram	`9`	`long_counter`
util	LogHistogram	`base`	`long`
util	LogHistogram	`nul`	`long_counter`

Prev		Next
C.2.3. Agent Log and `pid` Files	Home	Appendix E. Error codes