MySQL metrics

Database metrics comprehensively collect the database workload and resource usage. The WhaTap monitoring service continuously collects metric data to identify bottlenecks in the database and provides data to help identify the root cause of the performance issue.

For more information about other metrics, see the following.

agent_status_summary

This category collects metrics related to agent status every 10 seconds.

Fields

Field name	Unit	Description	Remarks
inActTime	Millisecond(ms)	Amount of time the agent remains inactive	-
isActive	-	Whether the agent is active or not	true / false
isRestart	-	Whether the agent has been recently restarted	true / false
lastActTime	Millisecond(ms)	Time when the agent was last activated	0: If disabled
oid	-	Unique IDs for each agent in the project	-
startTime	Millisecond(ms)	Timestamp when the agent was started.	-

db_mysql_counter

Tags

The following lists the tags that are collected in the db_mysql_counter category.

Tag name	Description	Remarks
agentIp	IP address per agent.	-
dbIsMulti	Whether to support the multitenant or not.	-
dbName	Database name.	-
dbType	Database type.	-
dbVersion	Version of the database in use.	-
oname	Agent name	Unique value

Field

The following lists the fields that are collected in the db_mysql_counter category.

Metrics	Description	Category
Aborted_clients	Number of abnormal client disconnections.	Connection
Aborted_connects	Number of client connection failures.	Connection
Acl_cache_items_count	Number of ACL (access control list) cache entries.	Info
Binlog_bytes_written	-	Number of bytes recorded in the binary log.	Performance
Binlog_cache_disk_use	Number of uses of the binary log cache written on the disk.	I/O
Binlog_cache_use	Number of uses of the binary log cache.	I/O
Binlog_commits	-	Number of commits recorded in the binary log.	Performance
Binlog_stmt_cache_disk_use	Number of uses of the binary log statement cache written on the disk.	I/O
Binlog_stmt_cache_use	Number of uses of the binary log statement cache.	I/O
Bytes_received	Total number of bytes of data received by the DB server. If this value is high, it indicates that the server is heavily focused on write operations (such as insert).	MySQL Resource
Bytes_sent	Total number of bytes of data transmitted by the database server. If this value is high, it indicates that the server is heavily focused on read operations (such as select). By using this value along with Questions and Uptime, you can calculate metrics such as average bytes per query and bytes processed per hour.	MySQL Resource
Com_admin_commands	Number of administrative commands executed.	Performance
Com_alter_db	Number of executions of ALTER DATABASE command.	Performance
Com_alter_event	Number of executions of the ALTER EVENT command.	Performance
Com_alter_function	Number of executions of the ALTER FUNCTION command.	Performance
Com_alter_instance	Number of executions of the ALTER INSTANCE command.	Performance
Com_alter_procedure	Number of executions of the ALTER PROCEDURE command.	Performance
Com_alter_resource_group	Number of executions of the ALTER RESOURCE GROUP command.	Performance
Com_alter_server	Number of executions of the ALTER SERVER command.	Performance
Com_alter_table	Number of executions of ALTER TABLE command.	Performance
Com_alter_tablespace	Number of executions of ALTER TABLESPACE command.	Performance
Com_alter_user	Number of executions of the ALTER USER command.	Performance
Com_alter_user_default_role	Number of executions of the ALTER USER DEFAULT ROLE command.	Performance
Com_analyze	Number of executions of the ANALYZE command.	Performance
Com_assign_to_keycache	Number of executions of the command assigned to the KEYCACHE.	Performance
Com_begin	Number of executions of the BEGIN command.	Performance
Com_binlog	Number of executions of the BINLOG command.	Performance
Com_call_procedure	Number of executions of the CALL PROCEDURE command.	Performance
Com_change_db	Number of executions of CHANGE DATABASE command.	Performance
Com_change_master	Number of executions of the CHANGE MASTER command.	Performance
Com_change_repl_filter	Number of executions of the CHANGE REPLICATION FILTER command.	Performance
Com_change_replication_source	Number of executions of the CHANGE REPLICATION SOURCE command.	Performance
Com_check	Number of executions of the CHECK command.	Performance
Com_checksum	Number of executions of the CHECKSUM command.	Performance
Com_clone	Number of executions of the CLONE command.	Performance
Com_commit	Number of executions of the COMMIT command.	Throughput
Com_create_db	Number of executions of CREATE DATABASE command.	Performance
Com_create_event	Number of executions of the CREATE EVENT command.	Performance
Com_create_function	Number of executions of the CREATE FUNCTION command.	Performance
Com_create_index	Number of executions of the CREATE INDEX command.	Performance
Com_create_procedure	Number of executions of the CREATE PROCEDURE command.	Performance
Com_create_resource_group	Number of executions of the CREATE RESOURCE GROUP command.	Performance
Com_create_role	Number of executions of the CREATE ROLE command.	Performance
Com_create_server	Number of executions of the CREATE SERVER command.	Performance
Com_create_spatial_reference_system	Number of executions of the CREATE SPATIAL REFERENCE SYSTEM command.	Performance
Com_create_table	Number of executions of the CREATE TABLE command.	Performance
Com_create_trigger	Number of executions of the CREATE TRIGGER command.	Performance
Com_create_udf	Number of executions of the CREATE UDF command.	Performance
Com_create_user	Number of executions of the CREATE USER command.	Performance
Com_create_view	Number of executions of the CREATE VIEW command.	Performance
Com_dealloc_sql	Number of executions of the DEALLOC SQL command.	Performance
Com_delete	Number of executions of the DELETE command. It counts the number of rows deleted from the table that are different from handler_delete.	Throughput
Com_delete_multi	Number of executions of the DELETE MULTI command.	Performance
Com_do	Number of executions of the DO command.	Performance
Com_drop_db	Number of executions of DROP DATABASE command.	Performance
Com_drop_event	Number of executions of the DROP EVENT command.	Performance
Com_drop_function	Number of executions of the DROP FUNCTION command.	Performance
Com_drop_index	Number of executions of the DROP INDEX command.	Performance
Com_drop_procedure	Number of executions of the DROP PROCEDURE command.	Performance
Com_drop_resource_group	Number of executions of the DROP RESOURCE GROUP command.	Performance
Com_drop_role	Number of executions of the DROP ROLE command.	Performance
Com_drop_server	Number of executions of the DROP SERVER command.	Performance
Com_drop_spatial_reference_system	Number of executions of the DROP SPATIAL REFERENCE SYSTEM command.	Performance
Com_drop_table	Number of executions of the DROP TABLE command.	Performance
Com_drop_trigger	Number of executions of the DROP TRIGGER command.	Performance
Com_drop_user	Number of executions of the DROP USER command.	Performance
Com_drop_view	Number of executions of the DROP VIEW command.	Performance
Com_empty_query	Number of executions of empty query.	Performance
Com_execute_sql	Number of executions of the SQL command.	Performance
Com_explain_other	Number of executions of the EXPLAIN OTHER command.	Performance
Com_flush	Number of executions of the FLUSH command.	Performance
Com_get_diagnostics	Number of executions of the GET DIAGNOSTICS command.	Performance
Com_grant	Number of executions of the GRANT command.	Performance
Com_grant_roles	Number of executions of the GRANT ROLES command.	Performance
Com_group_replication_start	Number of executions of the GROUP REPLICATION START command.	Performance
Com_group_replication_stop	Number of executions of the GROUP REPLICATION STOP command.	Performance
Com_ha_close	Number of executions of the HA CLOSE command.	Performance
Com_ha_open	Number of executions of the HA OPEN command.	Performance
Com_ha_read	Number of executions of the HA READ command.	Performance
Com_help	Number of executions of the HELP command.	Info
Com_import	Number of executions of the IMPORT command.	Performance
Com_insert	Number of executions of the INSERT command.	Throughput
Com_insert_select	Number of executions of the INSERT SELECT command.	Performance
Com_install_component	Number of executions of the INSTALL COMPONENT command.	Performance
Com_install_plugin	Number of executions of the INSTALL PLUGIN command.	Performance
Com_kill	Number of executions of the KILL command.	Performance
Com_load	Number of executions of the LOAD command.	Performance
Com_lock_instance	Number of executions of the LOCK INSTANCE command.	Performance
Com_lock_tables	Number of executions of LOCK TABLES command.	Performance
Com_optimize	Number of executions of the OPTIMIZE command.	Performance
Com_preload_keys	Number of executions of the PRELOAD KEYS command.	Performance
Com_prepare_sql	Number of preparations of the SQL command.	Performance
Com_purge	Number of executions of the PURGE command.	Performance
Com_purge_before_date	Number of data purges before a specific date.	Performance
Com_release_savepoint	Number of executions of the SAVEPOINT release command.	Performance
Com_rename_table	Number of executions of the RENAME TABLE command.	Performance
Com_rename_user	Number of executions of the RENAME USER command.	Performance
Com_repair	Number of executions of the REPAIR command.	Performance
Com_replace	Number of executions of the REPLACE command.	Performance
Com_replace_select	Number of executions of the REPLACE SELECT command.	Performance
Com_replica_start	Number of executions of the REPLICA START command.	Connection
Com_replica_stop	Number of executions of the REPLICA STOP command.	Connection
Com_reset	Number of executions of the RESET command.	Performance
Com_resignal	Number of executions of the RESIGNAL command.	Performance
Com_restart	Number of executions of the RESTART command.	Performance
Com_revoke	Number of executions of the REVOKE command.	Performance
Com_revoke_all	Number of executions of the REVOKE ALL command.	Performance
Com_revoke_roles	Number of executions of the REVOKE ROLES command.	Performance
Com_rollback	Number of executions of the ROLLBACK command.	Throughput
Com_rollback_to_savepoint	Number of rollbacks to a specific SAVEPOINT.	Performance
Com_savepoint	Number of executions of the SAVEPOINT command.	Performance
Com_select	Number of executions of the SELECT command.	Throughput
Com_set_option	Number of executions of the SET OPTION command.	Performance
Com_set_password	Number of executions of the SET PASSWORD command.	Performance
Com_set_resource_group	Number of executions of the SET RESOURCE GROUP command.	Performance
Com_set_role	Number of executions of the SET ROLE command.	Performance
Com_show_binlog_events	Number of executions of the SHOW BINLOG EVENTS command.	Info
Com_show_binlogs	Number of executions of the SHOW BINLOGS command.	Info
Com_show_charsets	Number of executions of SHOW CHARSETS command.	Info
Com_show_collations	Number of executions of the SHOW COLLATIONS command.	Info
Com_show_create_db	Number of executions of the SHOW CREATE DATABASE command.	Info
Com_show_create_event	Number of executions of the SHOW CREATE EVENT command.	Info
Com_show_create_func	Number of executions of the SHOW CREATE FUNCTION command.	Info
Com_show_create_proc	Number of executions of the SHOW CREATE PROCEDURE command.	Info
Com_show_create_table	Number of executions of the SHOW CREATE TABLE command.	Info
Com_show_create_trigger	Number of executions of the SHOW CREATE TRIGGER command.	Info
Com_show_create_user	Number of executions of the SHOW CREATE USER command.	Info
Com_show_databases	Number of executions of SHOW DATABASE command.	Info
Com_show_engine_logs	Number of executions of the SHOW ENGINE LOGS command.	Info
Com_show_engine_mutex	Number of executions of the SHOW ENGINE MUTEX command.	Info
Com_show_engine_status	Number of executions of the SHOW ENGINE STATUS command.	Info
Com_show_errors	Number of executions of the SHOW ERRORS command.	Info
Com_show_events	Number of executions of the SHOW EVENTS command.	Info
Com_show_fields	Number of executions of the SHOW FIELDS command.	Info
Com_show_function_code	Number of executions of the SHOW FUNCTION CODE command.	Info
Com_show_function_status	Number of executions of the SHOW FUNCTION STATUS command.	Info
Com_show_grants	Number of executions of the SHOW GRANTS command.	Info
Com_show_keys	Number of executions of the SHOW KEYS command.	Info
Com_show_master_status	Number of executions of the SHOW MASTER STATUS command.	Info
Com_show_open_tables	Number of executions of the SHOW OPEN TABLES command.	Info
Com_show_plugins	Number of executions of the SHOW PLUGINS command.	Info
Com_show_privileges	Number of executions of the SHOW PRIVILEGES command.	Info
Com_show_procedure_code	Number of executions of the SHOW PROCEDURE CODE command.	Info
Com_show_procedure_status	Number of executions of the SHOW PROCEDURE STATUS command.	Info
Com_show_processlist	Number of executions of the SHOW PROCESSLIST command.	Info
Com_show_profile	Number of executions of the SHOW PROFILE command.	Info
Com_show_profiles	Number of executions of the SHOW PROFILES command.	Info
Com_show_relaylog_events	Number of executions of the SHOW RELAYLOG EVENTS command.	Info
Com_show_replica_status	Number of executions of the SHOW REPLICA STATUS command.	Info
Com_show_replicas	Number of executions of the SHOW REPLICAS command.	Info
Com_show_slave_hosts	Number of executions of the SHOW SLAVE HOSTS command.	Info
Com_show_slave_status	Number of executions of the SHOW SLAVE STATUS command.	Info
Com_show_status	Number of executions of the SHOW STATUS command.	Info
Com_show_storage_engines	Number of executions of the SHOW STORAGE ENGINES command.	Info
Com_show_table_status	Number of executions of the SHOW TABLE STATUS command.	Info
Com_show_tables	Number of executions of SHOW TABLES command.	Info
Com_show_triggers	Number of executions of the SHOW TRIGGERS command.	Info
Com_show_variables	Number of executions of SHOW VARIABLES command.	Info
Com_show_warnings	Number of executions of the SHOW WARNINGS command.	Info
Com_shutdown	Number of executions of the SHUTDOWN command.	Performance
Com_signal	Number of executions of the SIGNAL command.	Performance
Com_slave_start	Number of executions of the SLAVE START command.	Connection
Com_slave_stop	Number of executions of the SLAVE STOP command.	Connection
Com_stmt_close	Number of executions of the STMT CLOSE command.	Performance
Com_stmt_execute	Number of executions of the STMT EXECUTE command.	Performance
Com_stmt_fetch	Number of executions of the STMT FETCH command.	Performance
Com_stmt_prepare	Number of executions of the STMT PREPARE command.	Performance
Com_stmt_reprepare	Number of executions of the STMT REPREPARE command.	Performance
Com_stmt_reset	Number of executions of the STMT RESET command.	Performance
Com_stmt_send_long_data	Number of executions of the STMT SEND LONG DATA command.	Performance
Com_truncate	Number of executions of the TRUNCATE command.	Performance
Com_uninstall_component	Number of executions of the UNINSTALL COMPONENT command.	Performance
Com_uninstall_plugin	Number of executions of the UNINSTALL PLUGIN command.	Performance
Com_unlock_instance	Number of executions of the UNLOCK INSTANCE command.	Performance
Com_unlock_tables	Number of executions of UNLOCK TABLES command.	Performance
Com_update	Number of executions of the UPDATE command.	Throughput
Com_update_multi	Number of executions of the UPDATE MULTI command.	Performance
Com_xa_commit	Number of executions of the XA COMMIT command.	Performance
Com_xa_end	Number of executions of the XA END command.	Performance
Com_xa_prepare	Number of executions of the XA PREPARE command.	Performance
Com_xa_recover	Number of executions of the XA RECOVER command.	Performance
Com_xa_rollback	Number of executions of the XA ROLLBACK command.	Performance
Com_xa_start	Number of executions of the XA START command.	Performance
Connection_errors_accept	Number of client connection errors.	Connection
Connection_errors_internal	Number of internal connection errors.	Connection
Connection_errors_max_connections	Number of connection errors rejected by the limit of max_connections.	Connection
Connection_errors_peer_address	Number of peer address connection errors.	Connection
Connection_errors_select	Number of SELECT connection errors.	Connection
Connection_errors_tcpwrap	Number of TCP WRAP connection errors.	Connection
Connections	Total number of client connections.	Connection
Created_tmp_disk_tables	Number of temporary tables on disk created by the server while executing commands. Because the disk usage can degrade the performance, if this value increases, consider adjusting the value for tmp_table_size or max_heap_table_size.	MySQL Resource
Created_tmp_files	Number of temporary files created by mysqld.	MySQL Resource
Created_tmp_tables	Number of internal temporary tables created by the server while executing commands. Temporary tables can be used in a few cases, typically when using UNION ALL in a query or when using ORDER BY, GROUP BY, or DISTINCT. It is recommended that the number of temporary tables on disk (Created_tmp_disk_tables) is not high (less than 10%) relative to the total number of internal temporary tables (Created_tmp_disk_tables + Created_tmp_tables).	MySQL Resource
Delayed_errors	Number of errors among delayed inserts.	Performance
Delayed_insert_threads	Number of threads handling delayed inserts.	Performance
Delayed_writes	Number of delayed inserts.	Performance
Deprecated_use_i_s_processlist_count	Number of uses of the deprecated INFORMATION_SCHEMA PROCESSLIST.	Info
Deprecated_use_i_s_processlist_last_timestamp	Timestamp of the last used deprecated INFORMATION_SCHEMA PROCESSLIST.	Info
Error_log_buffered_bytes	Number of bytes in the buffered error log.	I/O
Error_log_buffered_events	Number of buffered error log events.	I/O
Error_log_expired_events	Number of events in the expired error log.	I/O
Error_log_latest_write	Recorded time of the last error log.	Info
Flush_commands	Number of executions of the FLUSH command.	Performance
Global_connection_memory	Usage of the global connection memory.	MySQL Resource
Handler_commit	Number of COMMIT operations.	I/O
Handler_delete	Number of DELETE operations.	I/O
Handler_discover	Number of DISCOVER operations.	I/O
Handler_external_lock	Number of external lock operations.	I/O
Handler_mrr_init	MRR (Multi-range Read) initialization count.	I/O
Handler_prepare	Number of PREPARE operations.	I/O
Handler_read_first	Number of read operations of the first record.	I/O
Handler_read_key	Number of key read operations.	I/O
Handler_read_last	Number of read operations of the last record.	I/O
Handler_read_next	Number of read operations of the next record.	I/O
Handler_read_prev	Number of read operations of the previous record.	I/O
Handler_read_rnd	Number of read operations of the random record.	I/O
Handler_read_rnd_next	Number of read operations of the random next record.	I/O
Handler_rollback	Number of ROLLBACK operations.	I/O
Handler_savepoint	Number of SAVEPOINT operations.	I/O
Handler_savepoint_rollback	Number of SAVEPOINT ROLLBACK operations.	I/O
Handler_update	Number of UPDATE operations.	I/O
Handler_write	Number of WRITE operations.	I/O
Innodb_buffer_pool_bytes_data	Number of bytes containing data in the InnoDB buffer pool.	MySQL Resource
Innodb_buffer_pool_bytes_dirty	Number of bytes changed in the InnoDB buffer pool (number of dirty data).	MySQL Resource
Innodb_buffer_pool_pages_data	Number of pages being used in the InnoDB buffer pool.	MySQL Resource
Innodb_buffer_pool_pages_dirty	Number of pages changed in the InnoDB buffer pool (number of dirty pages).	MySQL Resource
Innodb_buffer_pool_pages_flushed	Number of pages flushed from the InnoDB buffer pool. Because excessive flushing can put a burden on the disk while writing dirty data, it must be monitored along with the disk performance.	MySQL Resource
Innodb_buffer_pool_pages_free	Number of pages available in the InnoDB buffer pool.	MySQL Resource
Innodb_buffer_pool_pages_misc	Number of administrative pages in the InnoDB buffer pool.	MySQL Resource
Innodb_buffer_pool_pages_total	Total number of pages in the InnoDB buffer pool.	MySQL Resource
Innodb_buffer_pool_read_ahead	Number of read-ahead occurrences in the InnoDB buffer pool.	MySQL Resource
Innodb_buffer_pool_read_ahead_evicted	Number of read-ahead pages removed from the buffer pool.	MySQL Resource
Innodb_buffer_pool_read_ahead_rnd	Number of random read-ahead occurrences.	MySQL Resource
Innodb_buffer_pool_read_requests	Number of logical read requests in the InnoDB buffer pool. Inodb buffer pool hit ratio can be calculated as follows, and 90% or higher is recommended. If the hit ratio is low, consider adding Innodb_buffer_pool_size. Calculation method: Buffer Hit Ratio = (1 - (Innodb_buffer_pool_reads/Innodb_buffer_pool_read_requests)) * 100	MySQL Resource
Innodb_buffer_pool_reads	Number of read operations occurred from the physical disk in the InnoDB buffer pool. It is the number of logical read requests that required reading directly from the disk because there is no data in the InnoDB buffer pool.	MySQL Resource
Innodb_buffer_pool_resize_status_code	InnoDB buffer pool size adjustment status code.	MySQL Resource
Innodb_buffer_pool_resize_status_progress	InnoDB buffer pool size adjustment progress ratio.	MySQL Resource
Innodb_buffer_pool_wait_free	Number of waits occurred when the InnoDB buffer pool is full.	MySQL Resource
Innodb_buffer_pool_write_requests	Number of write requests in the InnoDB buffer pool.	MySQL Resource
Innodb_data_fsyncs	Number of data file fsync calls.	MySQL Resource
Innodb_data_pending_fsyncs	Number of pending fsync operations.	MySQL Resource
Innodb_data_pending_reads	Number of pending read operations.	MySQL Resource
Innodb_data_pending_writes	Number of pending write operations.	MySQL Resource
Innodb_data_read	Number of data bytes read from the InnoDB.	MySQL Resource
Innodb_data_reads	Number of read operations in the InnoDB.	MySQL Resource
Innodb_data_writes	Number of write operations in the InnoDB.	MySQL Resource
Innodb_data_written	Number of data bytes written to the InnoDB.	MySQL Resource
Innodb_dblwr_pages_written	Number of pages written in the InnoDB double write buffer.	MySQL Resource
Innodb_dblwr_writes	Number of write operations in the InnoDB double write buffer.	MySQL Resource
Innodb_log_waits	The number of times waited for the log buffer to be flushed because it was small. The redo log contention rate can be calculated as (Innodb_log_waits/Innodb_log_writes), a value less than 1 is recommended. If Wait is high, consider increasing innodb_log_buffer_size.	MySQL Resource
Innodb_log_write_requests	Number of write requests to the InnoDB log.	MySQL Resource
Innodb_log_writes	Number of physical writes to the InnoDB Redo log file.	MySQL Resource
Innodb_num_open_files	Number of files open in the InnoDB.	MySQL Resource
Innodb_os_log_fsyncs	Number of fsync calls to the operating system log file.	MySQL Resource
Innodb_os_log_pending_fsyncs	Number of pending fsync operations for the operating system log file.	MySQL Resource
Innodb_os_log_pending_writes	Number of pending write operations to the operating system log file.	MySQL Resource
Innodb_os_log_written	Number of bytes written to the operating system log file.	MySQL Resource
Innodb_page_size	InnoDB page size.	MySQL Resource
Innodb_pages_created	Number of pages created in the InnoDB.	MySQL Resource
Innodb_pages_read	Number of pages read from the InnoDB.	MySQL Resource
Innodb_pages_written	Number of pages written in the InnoDB.	MySQL Resource
Innodb_redo_log_capacity_resized	Number of adjusts to the InnoDB Redo log capacity.	MySQL Resource
Innodb_redo_log_checkpoint_lsn	InnoDB Redo log checkpoint LSN.	MySQL Resource
Innodb_redo_log_current_lsn	Current LSN of the InnoDB Redo log.	MySQL Resource
Innodb_redo_log_flushed_to_disk_lsn	LSN at which the InnoDB Redo log has been written to disk.	MySQL Resource
Innodb_redo_log_logical_size	Logical size of the InnoDB Redo log.	MySQL Resource
Innodb_redo_log_physical_size	Physical size of the InnoDB Redo log.	MySQL Resource
Innodb_redo_log_uuid	UUID of the InnoDB Redo log.	MySQL Resource
Innodb_row_lock_current_waits	Current number of the pending InnoDB row locks.	MySQL Resource
Innodb_row_lock_time	Time spent to acquire the InnoDB row lock (in milliseconds).	Performance
Innodb_row_lock_time_avg	Average time for the InnoDB row locks.	Performance
Innodb_row_lock_time_max	Maximum time for the InnoDB row locks.	Performance
Innodb_row_lock_waits	Number of pending InnoDB row locks. This is the waiting count to acquire a lock, not the number of lock acquisitions. If this metric increases more than usual, the query wait occurs (lock contention) and query tuning is required.	Performance
Innodb_rows_deleted	Number of rows deleted from the InnoDB.	MySQL Resource
Innodb_rows_inserted	Number of rows inserted in the InnoDB.	MySQL Resource
Innodb_rows_read	Number of rows read in the InnoDB (rows processed by SELECT).	Throughput
Innodb_rows_updated	Number of rows updated in the InnoDB.	MySQL Resource
Innodb_rows_writes	Number of rows written in the InnoDB (rows processed by WRITE). It is the same as the formula: Innodb_rows_inserted + Innodb_rows_updated + Innodb_rows_deleted.	Throughput
Innodb_sampled_pages_read	Number of pages sampled in the InnoDB.	MySQL Resource
Innodb_sampled_pages_skipped	Number of pages skipped from sampling in the InnoDB.	MySQL Resource
Innodb_system_rows_deleted	Number of rows deleted from the InnoDB system.	MySQL Resource
Innodb_system_rows_inserted	Number of rows inserted by the InnoDB system.	MySQL Resource
Innodb_system_rows_read	Number of rows read by the InnoDB system.	MySQL Resource
Innodb_system_rows_updated	Number of rows updated by the InnoDB system.	MySQL Resource
Innodb_truncated_status_writes	Number of truncated records in the InnoDB.	MySQL Resource
Innodb_undo_tablespaces_active	Number of undo tablespaces enabled in the InnoDB.	MySQL Resource
Innodb_undo_tablespaces_explicit	Number of undo tablespaces explicitly created in the InnoDB.	MySQL Resource
Innodb_undo_tablespaces_implicit	Number of undo tablespaces implicitly created in the InnoDB.	MySQL Resource
Innodb_undo_tablespaces_total	Total number of InnoDB undo tablespaces.	MySQL Resource
Key_blocks_not_flushed	Number of unflushed key blocks.	I/O
Key_blocks_unused	Number of unused key blocks.	I/O
Key_blocks_used	Number of used key blocks.	I/O
Key_read_requests	Number of key read requests.	I/O
Key_reads	Number of key blocks read from disk.	I/O
Key_write_requests	Number of key write requests.	I/O
Key_writes	Number of key blocks written to disk.	I/O
Locked_connects	Number of closed connections.	Connection
Max_execution_time_exceeded	Number of queries that exceeded the maximum execution time.	Performance
Max_execution_time_set	Number of cases whose maximum execution time has been set.	Performance
Max_execution_time_set_failed	Number of cases whose maximum execution time has not been set.	Performance
Max_used_connections	Maximum number of connections made since the startup.	Connection
Mysqlx_aborted_clients	Number of clients aborted in the MySQL X protocol.	Connection
Mysqlx_bytes_received	Number of bytes received in the MySQL X protocol.	Throughput
Mysqlx_bytes_received_compressed_payload	Number of bytes received using compressed payloads in the MySQL X protocol.	Throughput
Mysqlx_bytes_received_uncompressed_frame	Number of bytes received using uncompressed frames in the MySQL X protocol.	Throughput
Mysqlx_bytes_sent	Number of bytes transmitted from the MySQL X protocol.	Throughput
Mysqlx_bytes_sent_compressed_payload	Number of bytes transmitted using the compressed payload in the MySQL X protocol.	Throughput
Mysqlx_bytes_sent_uncompressed_frame	Number of bytes transmitted using uncompressed frames in the MySQL X protocol.	Throughput
Mysqlx_connection_accept_errors	Number of connection acceptance errors in the MySQL X protocol.	Connection
Mysqlx_connection_errors	Number of connection errors occurred in the MySQL X protocol.	Connection
Mysqlx_connections_accepted	Number of connections accepted in the MySQL X protocol.	Connection
Mysqlx_connections_closed	Number of connections closed in the MySQL X protocol.	Connection
Mysqlx_connections_rejected	Number of connections rejected in the MySQL X protocol.	Connection
Mysqlx_crud_create_view	Number of CREATE VIEW commands executed in the MySQL X protocol.	Performance
Mysqlx_crud_delete	Number of DELETE commands executed in the MySQL X protocol.	Performance
Mysqlx_crud_drop_view	Number of DROP VIEW commands executed in the MySQL X protocol.	Performance
Mysqlx_crud_find	Number of FIND commands executed in the MySQL X protocol.	Performance
Mysqlx_crud_insert	Number of INSERT commands executed in the MySQL X protocol.	Performance
Mysqlx_crud_modify_view	Number of MODIFY VIEW commands executed in the MySQL X protocol.	Performance
Mysqlx_crud_update	Number of UPDATE commands executed in the MySQL X protocol.	Performance
Mysqlx_cursor_close	Number of cursor closing commands executed in the MySQL X protocol.	Performance
Mysqlx_cursor_fetch	Number of cursor fetch commands in the MySQL X protocol.	Performance
Mysqlx_cursor_open	Number of cursor opening commands executed in the MySQL X protocol.	Performance
Mysqlx_errors_sent	Number of errors sent to clients from the MySQL X protocol.	Info
Mysqlx_errors_unknown_message_type	Number of unknown message type errors in the MySQL X protocol.	Info
Mysqlx_expect_close	Number of EXPECT CLOSE commands in the MySQL X protocol.	Performance
Mysqlx_expect_open	Number of EXPECT OPEN commands in the MySQL X protocol.	Performance
Mysqlx_init_error	Number of initialization errors in the MySQL X protocol.	Info
Mysqlx_messages_sent	Number of messages sent to clients from the MySQL X protocol.	Info
Mysqlx_notice_global_sent	Number of global notifications sent from the MySQL X protocol.	Info
Mysqlx_notice_other_sent	Number of other notifications sent from the MySQL X protocol.	Info
Mysqlx_notice_warning_sent	Number of alerts sent from the MySQL X protocol.	Info
Mysqlx_notified_by_group_replication	Number of group replication notifications from the MySQL X protocol.	Connection
Mysqlx_port	Port used in the MySQL X protocol.	Info
Mysqlx_prep_deallocate	Number of SQL DEALLOCATE commands prepared in the MySQL X protocol.	Performance
Mysqlx_prep_execute	Number of SQL EXECUTE commands prepared in the MySQL X protocol.	Performance
Mysqlx_prep_prepare	Number of SQL PREPARE commands prepared in the MySQL X protocol.	Performance
Mysqlx_rows_sent	Number of rows sent to clients from the MySQL X protocol.	Throughput
Mysqlx_sessions	Number of active sessions in the MySQL X protocol.	Connection
Mysqlx_sessions_accepted	Number of sessions accepted in the MySQL X protocol.	Connection
Mysqlx_sessions_closed	Number of sessions closed in the MySQL X protocol.	Connection
Mysqlx_sessions_fatal_error	Number of sessions closed in the MySQL X protocol due to fatal errors.	Connection
Mysqlx_sessions_killed	Number of sessions forcibly terminated in the MySQL X protocol.	Connection
Mysqlx_sessions_rejected	Number of sessions rejected in the MySQL X protocol.	Connection
Mysqlx_ssl_accepts	Number of SSL connections accepted in the MySQL X protocol.	Connection
Mysqlx_ssl_ctx_verify_depth	SSL verification depth in the MySQL X protocol.	Info
Mysqlx_ssl_ctx_verify_mode	SSL verification mode in the MySQL X protocol.	Info
Mysqlx_ssl_finished_accepts	Number of SSL connections completed in the MySQL X protocol.	Connection
Mysqlx_stmt_create_collection	Number of CREATE COLLECTION commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_create_collection_index	Number of CREATE COLLECTION INDEX commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_disable_notices	Number of DISABLE NOTICES commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_drop_collection	Number of DROP COLLECTION commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_drop_collection_index	Number of DROP COLLECTION INDEX commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_enable_notices	Number of ENABLE NOTICES commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_ensure_collection	Number of ENSURE COLLECTION commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_execute_mysqlx	Number of EXECUTE MYSQLX commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_execute_sql	Number of EXECUTE SQL commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_execute_xplugin	Number of EXECUTE XPLUGIN commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_get_collection_options	Number of GET COLLECTION OPTIONS commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_kill_client	Number of KILL CLIENT commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_list_clients	Number of LIST CLIENTS commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_list_notices	Number of LIST NOTICES commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_list_objects	Number of LIST OBJECTS commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_modify_collection_options	Number of MODIFY COLLECTION OPTIONS commands executed in the MySQL X protocol.	Performance
Mysqlx_stmt_ping	Number of PING commands executed in the MySQL X protocol.	Performance
Mysqlx_worker_threads	Number of worker threads activated in the MySQL X protocol.	MySQL Resource
Mysqlx_worker_threads_active	Number of active worker threads in the MySQL X protocol.	MySQL Resource
Not_flushed_delayed_rows	Number of unflushed pending rows.	I/O
Ongoing_anonymous_transaction_count	Number of anonymous transactions in progress.	Connection
Open_files	Number of open files.	I/O
Open_streams	Number of open streams.	I/O
Open_table_definitions	Number of open table definitions.	I/O
Open_tables	Number of open tables.	I/O
Opened_files	Number of open files.	I/O
Opened_table_definitions	Number of open table definitions.	I/O
Opened_tables	Number of open tables.	I/O
Performance_schema_accounts_lost	Number of lost Performance Schema accounts.	Info
Performance_schema_cond_classes_lost	Number of lost Performance Schema condition classes.	Info
Performance_schema_cond_instances_lost	Number of lost Performance Schema condition instances.	Info
Performance_schema_digest_lost	Number of lost Performance Schema digests.	Info
Performance_schema_file_classes_lost	Number of lost Performance Schema file classes.	Info
Performance_schema_file_handles_lost	Number of lost Performance Schema file handles.	Info
Performance_schema_file_instances_lost	Number of lost Performance Schema file instances.	Info
Performance_schema_hosts_lost	Number of lost Performance Schema hosts.	Info
Performance_schema_index_stat_lost	Number of lost Performance Schema index statistics.	Info
Performance_schema_locker_lost	Number of lost Performance Schema lockers.	Info
Performance_schema_memory_classes_lost	Number of lost Performance Schema memory classes.	Info
Performance_schema_metadata_lock_lost	Number of lost Performance Schema metadata locks.	Info
Performance_schema_mutex_classes_lost	Number of lost Performance Schema mutex classes.	Info
Performance_schema_mutex_instances_lost	Number of lost Performance Schema mutex instances.	Info
Performance_schema_nested_statement_lost	Number of lost Performance Schema nested sentences.	Info
Performance_schema_prepared_statements_lost	Number of lost Performance Schema prepared sentences.	Info
Performance_schema_program_lost	Number of lost Performance Schema programs.	Info
Performance_schema_rwlock_classes_lost	Number of lost Performance Schema read/write lock classes.	Info
Performance_schema_rwlock_instances_lost	Number of lost Performance Schema read/write lock instances.	Info
Performance_schema_session_connect_attrs_longest_seen	Maximum length for session connection attributes seen in the Performance Schema.	Info
Performance_schema_session_connect_attrs_lost	Number of lost Performance Schema session connection attributes.	Info
Performance_schema_socket_classes_lost	Number of lost Performance Schema socket classes.	Info
Performance_schema_socket_instances_lost	Number of lost Performance Schema socket instances.	Info
Performance_schema_stage_classes_lost	Number of lost Performance Schema stage classes.	Info
Performance_schema_statement_classes_lost	Number of lost Performance Schema sentence classes.	Info
Performance_schema_table_handles_lost	Number of lost Performance Schema table handles.	Info
Performance_schema_table_instances_lost	Number of lost Performance Schema table instances.	Info
Performance_schema_table_lock_stat_lost	Number of lost Performance Schema table lock statistics.	Info
Performance_schema_thread_classes_lost	Number of lost Performance Schema thread classes.	Info
Performance_schema_thread_instances_lost	Number of lost Performance Schema thread instances.	Info
Performance_schema_users_lost	Number of lost Performance Schema users.	Info
Prepared_stmt_count	Number of prepared sentences.	Performance
Queries	Number of statements executed by the servers, excluding com_ping and com_statistics. It differs from Questions because it also counts the queries executed in the stored program.	Throughput
Questions	Number of executed queries.	Throughput
Replica_open_temp_tables	Number of open temporary tables.	I/O
Secondary_engine_execution_count	Number of tasks executed by the secondary engine.	I/O
Select_full_join	Number of full scans for driven tables without using indexes when joining more than one table.	Throughput
Select_full_range_join	Number of join operations in full range.	I/O
Select_range	Number of range selection operations.	I/O
Select_range_check	Number of range checking operations.	I/O
Select_scan	Number of full scans for the driving table. In this case, ALL appears in the type column of the plan.	Throughput
Slave_open_temp_tables	Number of open temporary tables.	I/O
Slaves_running	Number of running slave SQL threads.	Performance
Slow_launch_threads	Number of slowly launched threads.	Performance
Slow_queries	Number of queries executed longer than the time set in the DB parameter option, long_query_time (seconds).	Performance
Sort_merge_passes	Number of sorting and merging operations.	I/O
Sort_range	Number of range sorting operations.	I/O
Sort_rows	Number of sorted rows.	I/O
Sort_scan	Number of scan sorting operations.	I/O
Ssl_accept_renegotiates	Number of SSL connection renegotiations.	Connection
Ssl_accepts	Number of accepted SSL connections.	Connection
Ssl_callback_cache_hits	Number of SSL callback cache hits.	Performance
Ssl_client_connects	Number of SSL client connections.	Connection
Ssl_connect_renegotiates	Number of SSL connection renegotiations.	Connection
Ssl_ctx_verify_depth	Verification depth of the SSL context.	Info
Ssl_ctx_verify_mode	Verification mode of the SSL context.	Info
Ssl_default_timeout	SSL default timeout.	Info
Ssl_finished_accepts	Number of finished SSL connections.	Connection
Ssl_finished_connects	Number of finished SSL client connections.	Connection
Ssl_session_cache_hits	Number of SSL session cache hits.	Performance
Ssl_session_cache_misses	Number of SSL session cache misses.	Performance
Ssl_session_cache_overflows	Number of SSL session cache overflows.	Performance
Ssl_session_cache_size	SSL session cache size.	MySQL Resource
Ssl_session_cache_timeout	SSL session cache timeout.	Info
Ssl_session_cache_timeouts	Number of SSL session cache timeouts.	Info
Ssl_sessions_reused	Number of reused SSL sessions.	Connection
Ssl_used_session_cache_entries	Number of used SSL session cache entries.	Performance
Ssl_verify_depth	Verification depth of the SSL.	Info
Ssl_verify_mode	Verification mode of the SSL.	Info
Table_locks_immediate	Number of immediately acquired table locks.	I/O
Table_locks_waited	Number of table locks acquired after waiting.	I/O
Table_open_cache_hits	Number of table open cache hits.	I/O
Table_open_cache_misses	Number of table open cache misses.	I/O
Table_open_cache_overflows	Number of table open cache overflows.	I/O
Tc_log_max_pages_used	Maximum number of used Tc log pages.	I/O
Tc_log_page_size	Tc log page size.	Info
Tc_log_page_waits	Number of Tc log page waits.	I/O
Threads_cached	Number of cached threads.	MySQL Resource
Threads_connected	Number of connected threads.	Connection
Threads_created	Number of created threads.	Connection
Threads_running	Number of running threads.	Connection
Uptime	Server uptime.	Info
Uptime_since_flush_status	Time elapsed since the last flush.	Info
Writes	Number of commands used by Write. It is the same as the formula: Com_insert + Com_update + Com_delete.	Throughput
active_sessions	Number of active sessions. It is the same value as the Threads_running metric.	Connection
connect_error	Number of connection errors.	Connection
fatal_count	Number of fatal errors.	Connection
lock_wait_sessions	Number of pending sessions for acquiring a row lock. It is the number of innodb_lock_waits (data_lock_waits).	Performance
long_running_sessions	Number of long running sessions.	Connection
max_connections	Maximum number of concurrent client connections. Too ManyConnection Error may occur if the number of connections is insufficient.	Info
node_state	This database consists of replication relationships. 1: Master, 2: Slave.	Info
replication_broken	Whether replication failed or not.	Connection
replication_delay	Replication delay time. Delay time reflected in the replication database for the replication structure, this is a metric measured in the slave DB.	Performance
seconds_behind_master	Delay time behind the master (seconds).	Connection
total_runtime	Total query execution time.	Performance
wait/io/file/csv/data	CSV data file waiting time.	I/O
wait/io/file/csv/metadata	CSV metadata file waiting time.	I/O
wait/io/file/innodb/innodb_data_file	InnoDB data file waiting time.	I/O
wait/io/file/innodb/innodb_dblwr_file	InnoDB double write file waiting time.	I/O
wait/io/file/innodb/innodb_log_file	InnoDB log file waiting time.	I/O
wait/io/file/innodb/innodb_temp_file	InnoDB temporary file waiting time.	I/O
wait/io/file/mysys/charset	MySys character set file waiting time.	I/O
wait/io/file/mysys/cnf	MySys configuration file waiting time.	I/O
wait/io/file/sql/ERRMSG	SQL error message file waiting time.	I/O
wait/io/file/sql/binlog	SQL binary log file waiting time.	I/O
wait/io/file/sql/binlog_index	SQL binary log index file waiting time.	I/O
wait/io/file/sql/casetest	SQL case test file waiting time.	I/O
wait/io/file/sql/misc	SQL miscellaneous files waiting time.	I/O
wait/io/file/sql/pid	SQL PID file waiting time.	I/O
wait/io/file/sql/relaylog	SQL relay log file waiting time.	I/O
wait/io/file/sql/relaylog_index	SQL relay log index file waiting time.	I/O
wait/io/file/sql/slow_log	SQL slow log file waiting time.	I/O
wait/io/table/sql/handler	SQL handler table waiting time.	I/O
wait/lock/table/sql/handler	SQL handler table lock waiting time.	I/O
waiting_for_table_flush_sessions	Number of sessions waiting for table flush	I/O
warning_count	Number of warnings.	Info

XOS-related metrics

The following describes the metrics collected from the XOS agent.

Metric	Unit	Description
cpu(xos)	pct	CPU utilization, cpu_user + cpu_sys + cpu_iowait.
cpu_user(xos)	pct	Time spent for CPU to execute user code.
cpu_sys(xos)	pct	Time spent for CPU to execute the kernel code.
cpu_iowait(xos)	pct	CPU time waited for IO.
cpu_idle(xos)	pct	CPU processor's idle time.
disk_reads(xos)	block	Amount of data read from disk.
disk_read_bytes(xos)	byte	Amount of data read from disk.
disk_writes(xos)	block	Amount of data written to disk.
disk_write_bytes(xos)	byte	Amount of data written to disk.
mem(xos)	pct	Memory utilization.
mem_total(xos)	MB	Total amount of memory.
mem_free(xos)	MB	Amount of memory not in use by the system.
mem_used(xos)	MB	Amount of memory in use by the system.
mem_buffcache(xos)	MB	Amount of memory used by the buff/cache.
mem_swaptotal(xos)	MB	Set this in preparation for the case where the total Swap size and physical memory are insufficient.
mem_swapfree(xos)	MB	Because the unused Swap area and Swap area are secured in disk space, the system performance may drop drastically while using Swap.
mem_available(xos)	MB	Available memory area.
net_recv_bytes(xos)	byte	Amount of data received over the network.
net_recv_packets(xos)	-	Number of data packets received over the network.
net_send_bytes(xos)	byte	Amount of data transmitted over the network.
net_send_packets(xos)	-	Number of data packets transmitted over the network.