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