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 6.3, “Editing Built-in Rules” and Section 6.4.2, “Overview of Rule Creation”.
Table F.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 | 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 | 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 | 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 | 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_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 | errors |
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 | 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 | 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 | 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 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 | 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 | 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 |