MySQL Metrics

Prometheus plugin: mysqld_exporter (opens in a new tab)
Prometheus Built-in Chart: Grafana MySQL (opens in a new tab)

Note: The sign of behind Metric indicates that the platform provides Built-in Chart.

Description	Metrics
The number of connections that were aborted because the client died without closing the connection properly	MegaEase`mysql-aborted-clients-metric` Datadog`mysql.net.aborted_clients` Prometheus `mysql_global_status_aborted_clients` Telegraf `mysql_aborted_clients` MegaEase Dashboard - `mysql-aborted-clients-avg-metric` - `mysql-aborted-clients-ratio-metric` - `mysql-aborted-clients-sum-metric`
The number of failed attempts to connect to the MySQL server	MegaEase`mysql-aborted-connects-metric` Datadog`mysql.net.aborted_connects` Prometheus `mysql_global_status_aborted_connects` Telegraf `mysql_aborted_connects` MegaEase Dashboard - `mysql-aborted-connects-avg-metric` - `mysql-aborted-connects-sum-metric` - `mysql-aborted-connects-ratio-metric`
The size of the database server binary file is based on bytes	MegaEase`mysql-binary-size-bytes-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_binary_size_bytes` MegaEase Dashboard - `mysql-binary-size-bytes-avg-metric` - `mysql-binary-size-bytes-sum-metric`
The number of transactions that used the temporary binary log cache but that exceeded the value of binlogcachesize and used a temporary file to store statements from the transaction	MegaEase`mysql-binlog-cache-disk-use-metric` Datadog`mysql.binlog.cache_disk_use` Prometheus `mysql_global_status_binlog_cache_disk_use` Telegraf `mysql_binlog_cache_disk_use` MegaEase Dashboard - `mysql-binlog-cache-disk-use-avg-metric` - `mysql-binlog-cache-disk-use-sum-metric`
Binary log sentence cache usage. It means that when the sentence cache is insufficient, the MySQL server needs to write the number of statements to the disk	MegaEase`mysql-binlog-stmt-cache-disk-use-metric` Datadog`NotSupport` Prometheus `mysql_global_status_binlog_stmt_cache_disk_use` Telegraf `mysql_binlog_stmt_cache_disk_use` MegaEase Dashboard - `mysql-binlog-stmt-cache-disk-use-sum-metric` - `mysql-binlog-stmt-cache-disk-use-avg-metric`
Receive the number of times to receive the client request to execute the storage procedure	MegaEase`mysql-com-call-procedure-metric` Datadog`NotSupport` Prometheus `mysql_global_status_commands_total{command="call_procedure"}` Telegraf `mysql_com_call_procedure` MegaEase Dashboard - `mysql-com-call-procedure-sum-metric` - `mysql-com-call-procedure-avg-metric` - `mysql-com-call-procedure-ratio-metric`
The number of internal COMMIT statements	MegaEase`mysql-com-commit-metric` Datadog`NotSupport` Prometheus `mysql_global_status_commands_total{command="commit"}` Telegraf `mysql_com_commit` MegaEase Dashboard - `mysql-com-commit-avg-metric` - `mysql-com-commit-sum-metric` - `mysql-com-commit-ratio-metric`
The total of delete statements	MegaEase`mysql-com-delete-metric` Datadog`mysql.performance.com_delete` Prometheus `mysql_global_status_commands_total{command="delete"}` Telegraf `mysql_com_delete` MegaEase Dashboard - `mysql-com-delete-sum-metric` - `mysql-com-delete-avg-metric` - `mysql-com-delete-ratio-metric`
The total of delete-multi statements	MegaEase`mysql-com-delete-multi-metric` Datadog`mysql.performance.com_delete_multi` Prometheus `mysql_global_status_commands_total{command="delete_multi"}` Telegraf `mysql_com_delete_multi` MegaEase Dashboard - `mysql-com-delete-multi-avg-metric` - `mysql-com-delete-multi-sum-metric` - `mysql-com-delete-multi-ratio-metric`
The total of insert statements	MegaEase`mysql-com-insert-metric` Datadog`mysql.performance.com_insert` Prometheus `mysql_global_status_commands_total{command="insert"}` Telegraf `mysql_com_insert` MegaEase Dashboard - `mysql-com-insert-avg-metric` - `mysql-com-insert-sum-metric` - `mysql-com-insert-ratio-metric`
The total of insert-select statements	MegaEase`mysql-com-insert-select-metric` Datadog`mysql.performance.com_insert_select` Prometheus `mysql_global_status_commands_total{command="insert_select"}` Telegraf `mysql_com_insert_select` MegaEase Dashboard - `mysql-com-insert-select-avg-metric` - `mysql-com-insert-select-sum-metric` - `mysql-com-insert-select-ratio-metric`
The total of replace statements	MegaEase`mysql-com-replace-metric` Datadog`mysql.performance.com_replace` Prometheus `mysql_global_status_commands_total{command="replace"}` Telegraf `mysql_com_replace` MegaEase Dashboard - `mysql-com-replace-avg-metric` - `mysql-com-replace-ratio-metric` - `mysql-com-replace-sum-metric`
The total of replace-select statements	MegaEase`mysql-com-replace-select-metric` Datadog`mysql.performance.com_replace_select` Prometheus `mysql_global_status_commands_total{command="replace_select"}` Telegraf `mysql_com_replace_select` MegaEase Dashboard - `mysql-com-replace-select-avg-metric` - `mysql-com-replace-select-ratio-metric` - `mysql-com-replace-select-sum-metric`
The number of transactions which originated on this member and were rolled back by the group	MegaEase`mysql-com-rollback-metric` Datadog`mysql.replication.group.transactions_rollback` Prometheus `mysql_global_status_commands_total{command="rollback"}` Telegraf `mysql_com_rollback` MegaEase Dashboard - `mysql-com-rollback-avg-metric` - `mysql-com-rollback-sum-metric` - `mysql-com-rollback-ratio-metric`
The rate of select statements	MegaEase`mysql-com-select-metric` Datadog`The rate of select statements.` Prometheus `mysql_global_status_commands_total{command="select"}` Telegraf `mysql_com_select` MegaEase Dashboard - `mysql-com-select-sum-metric` - `mysql-com-select-avg-metric` - `mysql-com-select-ratio-metric`
Receive the number of times the client request to execute the pre -processing statement	MegaEase`mysql-com-stmt-execute-metric` Datadog`NotSupport` Prometheus `mysql_global_status_commands_total{command="stmt_execute"}` Telegraf `mysql_com_stmt_execute` MegaEase Dashboard - `mysql-com-stmt-execute-avg-metric` - `mysql-com-stmt-execute-sum-metric` - `mysql-com-stmt-execute-ratio-metric`
The rate of update statements	MegaEase`mysql-com-update-metric` Datadog`mysql.performance.com_update` Prometheus `mysql_global_status_commands_total{command="update"}` Telegraf `mysql_com_update` MegaEase Dashboard - `mysql-com-update-avg-metric` - `mysql-com-update-sum-metric` - `mysql-com-update-ratio-metric`
The rate of update-multi	MegaEase`mysql-com-update-multi-metric` Datadog`mysql.performance.com_update_multi` Prometheus `mysql_global_status_commands_total{command="update_multi"}` Telegraf `mysql_com_update_multi` MegaEase Dashboard - `mysql-com-update-multi-avg-metric` - `mysql-com-update-multi-sum-metric` - `mysql-com-update-multi-ratio-metric`
The rate of internal on-disk temporary tables created by second by the server while executing statements	MegaEase`mysql-created-tmp-disk-tables-metric` Datadog`mysql.performance.created_tmp_disk_tables` Prometheus `mysql_global_status_created_tmp_disk_tables` Telegraf `mysql_created_tmp_disk_tables` MegaEase Dashboard - `mysql-created-tmp-disk-tables-sum-metric` - `mysql-created-tmp-disk-tables-avg-metric`
used to measure the execution progress in MySQL master-slave replication	MegaEase`mysql-exec-master-log-pos-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_exec_master_log_pos` MegaEase Dashboard - `mysql-exec-master-log-pos-sum-metric` - `mysql-exec-master-log-pos-avg-metric`
The number of requests to flush pages from the InnoDB buffer pool	MegaEase`mysql-innodb-buffer-pool-pages-flushed-metric` Datadog`mysql.innodb.buffer_pool_pages_flushed` Prometheus `mysql_global_status_buffer_pool_page_changes_total{operation="flushed"}` Telegraf `mysql_innodb_buffer_pool_pages_flushed` MegaEase Dashboard - `mysql-innodb-buffer-pool-pages-flushed-avg-metric` - `mysql-innodb-buffer-pool-pages-flushed-sum-metric`
The number of logical read requests	MegaEase`mysql-innodb-buffer-pool-read-requests-metric` Datadog`mysql.innodb.buffer_pool_read_requests` Prometheus `mysql_global_status_innodb_buffer_pool_read_requests` Telegraf `mysql_innodb_buffer_pool_read_requests` MegaEase Dashboard - `mysql-innodb-buffer-pool-read-requests-avg-metric` - `mysql-innodb-buffer-pool-read-requests-sum-metric`
The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk	MegaEase`mysql-innodb-buffer-pool-reads-metric` Datadog`mysql.innodb.buffer_pool_reads` Prometheus `mysql_global_status_innodb_buffer_pool_reads` Telegraf `mysql_innodb_buffer_pool_reads` MegaEase Dashboard - `mysql-innodb-buffer-pool-reads-sum-metric` - `mysql-innodb-buffer-pool-reads-avg-metric`
When InnoDB needs to read or create a page and no clean pages are available, InnoDB flushes some dirty pages first and waits for that operation to finish. This counter counts instances of these waits.	MegaEase`mysql-innodb-buffer-pool-wait-free-metric` Datadog`mysql.innodb.buffer_pool_wait_free` Prometheus `mysql_global_status_innodb_buffer_pool_wait_free` Telegraf `mysql_innodb_buffer_pool_wait_free` MegaEase Dashboard - `mysql-innodb-buffer-pool-wait-free-avg-metric` - `mysql-innodb-buffer-pool-wait-free-sum-metric`
The number of writes done to the InnoDB buffer pool	MegaEase`mysql-innodb-buffer-pool-write-requests-metric` Datadog`mysql.innodb.buffer_pool_write_requests` Prometheus `mysql_global_status_innodb_buffer_pool_write_requests` Telegraf `mysql_innodb_buffer_pool_write_requests` MegaEase Dashboard - `mysql-innodb-buffer-pool-write-requests-sum-metric` - `mysql-innodb-buffer-pool-write-requests-avg-metric`
The number of row locks currently being waited for by operations on InnoDB tables	MegaEase`mysql-innodb-row-lock-current-waits-metric` Datadog`mysql.innodb.row_lock_current_waits` Prometheus `mysql_global_status_innodb_row_lock_current_waits` Telegraf `mysql_innodb_row_lock_current_waits` MegaEase Dashboard - `mysql-innodb-row-lock-current-waits-sum-metric` - `mysql-innodb-row-lock-current-waits-avg-metric`
Number of rows deleted from InnoDB tables	MegaEase`mysql-innodb-rows-deleted-metric` Datadog`mysql.innodb.rows_deleted` Prometheus `mysql_global_status_innodb_system_rows_deleted` Telegraf `mysql_innodb_rows_deleted` MegaEase Dashboard - `mysql-innodb-rows-deleted-avg-metric` - `mysql-innodb-rows-deleted-sum-metric` - `mysql-innodb-rows-deleted-ratio-metric`
Number of rows inserted into InnoDB tables	MegaEase`mysql-innodb-rows-inserted-metric` Datadog`mysql.innodb.rows_inserted` Prometheus `mysql_global_status_innodb_system_rows_inserted` Telegraf `mysql_innodb_rows_inserted` MegaEase Dashboard - `mysql-innodb-rows-inserted-ratio-metric` - `mysql-innodb-rows-inserted-avg-metric` - `mysql-innodb-rows-inserted-sum-metric`
Number of rows read from InnoDB tables	MegaEase`mysql-innodb-rows-read-metric` Datadog`mysql.innodb.rows_read` Prometheus `mysql_global_status_innodb_system_rows_read` Telegraf `mysql_innodb_rows_read` MegaEase Dashboard - `mysql-innodb-rows-read-avg-metric` - `mysql-innodb-rows-read-ratio-metric` - `mysql-innodb-rows-read-sum-metric`
Number of rows updated in InnoDB tables	MegaEase`mysql-innodb-rows-updated-metric` Datadog`mysql.innodb.rows_updated` Prometheus `mysql_global_status_innodb_system_rows_updated` Telegraf `mysql_innodb_rows_updated` MegaEase Dashboard - `mysql-innodb-rows-updated-sum-metric` - `mysql-innodb-rows-updated-avg-metric` - `mysql-innodb-rows-updated-ratio-metric`
Error number of most recent error that caused I/O thread to stop	MegaEase`mysql-last-io-errno-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_last_io_errno` MegaEase Dashboard - `mysql-last-io-errno-sum-metric` - `mysql-last-io-errno-avg-metric`
last error that occurred during an I/O operation	MegaEase`mysql-last-io-error-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_last_io_error` MegaEase Dashboard - `mysql-last-io-error-max-metric` - `mysql-last-io-error-avg-metric` - `mysql-last-io-error-min-metric`
Error number of most recent error that caused SQL thread to stop	MegaEase`mysql-last-sql-errno-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_last_sql_errno` MegaEase Dashboard - `mysql-last-sql-errno-avg-metric` - `mysql-last-sql-errno-sum-metric`
last error that occurred during an SQL statement execution	MegaEase`mysql-last-sql-error-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_last_sql_error` MegaEase Dashboard - `mysql-last-sql-error-min-metric` - `mysql-last-sql-error-max-metric` - `mysql-last-sql-error-avg-metric`
the number of times a client was unable to connect to the MySQL server because the maximum number of allowed connections had been reached	MegaEase`mysql-locked-connects-metric` Datadog`NotSupport` Prometheus `mysql_global_status_locked_connects` Telegraf `mysql_locked_connects` MegaEase Dashboard - `mysql-locked-connects-sum-metric` - `mysql-locked-connects-ratio-metric` - `mysql-locked-connects-avg-metric`
the position of the binary log file that the slave server is currently reading in MySQL master-slave replication	MegaEase`mysql-read-master-log-pos-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_read_master_log_pos` MegaEase Dashboard - `mysql-read-master-log-pos-sum-metric` - `mysql-read-master-log-pos-avg-metric`
The lag in seconds between the master and the slave	MegaEase`mysql-seconds-behind-master-metric` Datadog`mysql.replication.seconds_behind_master` Prometheus `NotSupport` Telegraf `mysql_seconds_behind_master` MegaEase Dashboard - `mysql-seconds-behind-master-avg-metric` - `mysql-seconds-behind-master-sum-metric`
the status of the I/O thread responsible for fetching the binary log events from the master. value is: Yes or ON	MegaEase`mysql-slave-io-running-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_slave_io_running` MegaEase Dashboard - `mysql-slave-io-running-max-metric` - `mysql-slave-io-running-avg-metric` - `mysql-slave-io-running-min-metric`
It represents the status of the SQL thread responsible for executing the received binary log events on the slave server. value is: Yes or ON	MegaEase`mysql-slave-sql-running-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_slave_sql_running` MegaEase Dashboard - `mysql-slave-sql-running-min-metric` - `mysql-slave-sql-running-avg-metric` - `mysql-slave-sql-running-max-metric`
The rate of slow queries	MegaEase`mysql-slow-queries-metric` Datadog`mysql.performance.slow_queries` Prometheus `mysql_global_status_slow_queries` Telegraf `mysql_slow_queries` MegaEase Dashboard - `mysql-slow-queries-sum-metric` - `mysql-slow-queries-avg-metric` - `mysql-slow-queries-ratio-metric`
Display the delay time of master and backup that has been set, in seconds;	MegaEase`mysql-sql-delay-metric` Datadog`NotSupport` Prometheus `NotSupport` Telegraf `mysql_sql_delay` MegaEase Dashboard - `mysql-sql-delay-sum-metric` - `mysql-sql-delay-avg-metric`
the length of the data file, in bytes	MegaEase`mysql-table-schema-data-length-metric` Datadog`NotSupport` Prometheus `mysql_info_schema_table_size{component="data_length"}` Telegraf `mysql_table_schema_data_length` MegaEase Dashboard - `mysql-table-schema-data-length-avg-metric` - `mysql-table-schema-data-length-sum-metric`
the length of the index file, in bytes	MegaEase`mysql-table-schema-index-length-metric` Datadog`NotSupport` Prometheus `mysql_info_schema_table_size{component="index_length"}` Telegraf `mysql_table_schema_index_length` MegaEase Dashboard - `mysql-table-schema-index-length-avg-metric` - `mysql-table-schema-index-length-sum-metric`
The number of currently open connections	MegaEase`mysql-threads-connected-metric` Datadog`mysql.performance.threads_connected` Prometheus `mysql_global_status_threads_connected` Telegraf `mysql_threads_connected` MegaEase Dashboard - `mysql-threads-connected-sum-metric` - `mysql-threads-connected-avg-metric`
The number of threads that are not sleeping	MegaEase`mysql-threads-running-metric` Datadog`mysql.performance.threads_running` Prometheus `mysql_global_status_threads_running` Telegraf `mysql_threads_running` MegaEase Dashboard - `mysql-threads-running-avg-metric` - `mysql-threads-running-sum-metric`
The total size of the InnoDB buffer pool, in pages	MegaEase`mysql-innodb-buffer-pool-pages-total-metric` Datadog`mysql.innodb.buffer_pool_pages_total` Prometheus `mysql_innodb_buffer_pool_pages_total` Telegraf `mysql_innodb_buffer_pool_pages_total` MegaEase Dashboard - `mysql-innodb-buffer-pool-pages-total-max-metric` - `mysql-innodb-buffer-pool-pages-total-avg-metric` - `mysql-innodb-buffer-pool-pages-total-min-metric`
The number of free pages in the InnoDB buffer pool	MegaEase`mysql-innodb-buffer-pool-pages-free-metric` Datadog`mysql.innodb.buffer_pool_pages_free` Prometheus `mysql_innodb_buffer_pool_pages_free` Telegraf `mysql_innodb_buffer_pool_pages_free` MegaEase Dashboard - `mysql-innodb-buffer-pool-pages-free-max-metric` - `mysql-innodb-buffer-pool-pages-free-avg-metric` - `mysql-innodb-buffer-pool-pages-free-min-metric`
The rate of connections to the server	MegaEase`mysql-connections-metric` Datadog`mysql.net.connections` Prometheus `mysql_global_status_connections` Telegraf `mysql_connections` MegaEase Dashboard - `mysql-connections-ratio-metric`
The maximum number of connections that have been in use simultaneously since the server started	MegaEase`mysql-variables-max-connections-metric` Datadog`mysql.net.max_connections` Prometheus `mysql_global_status_max_used_connections mysql_global_variables_max_connections` Telegraf `mysql_variables_max_connections` MegaEase Dashboard - `mysql-variables-max-connections-max-by-service-metric`
The rate of data reads	MegaEase`mysql-innodb-data-reads-metric` Datadog`mysql.innodb.data_reads` Prometheus `mysql_global_status_innodb_data_reads` Telegraf `mysql_innodb_data_reads` MegaEase Dashboard - `mysql-innodb-data-reads-ratio-metric`
The rate of data writes	MegaEase`mysql-innodb-data-writes-metric` Datadog`mysql.innodb.data_writes` Prometheus `mysql_global_status_innodb_data_writes` Telegraf `mysql_innodb_data_writes` MegaEase Dashboard - `mysql-innodb-data-writes-ratio-metric`
Number of fsync log writes (innodb_os_log_fsyncs)	MegaEase`mysql-os-log-fsyncs-metric` Datadog`mysql.innodb.os_log_fsyncs` Prometheus `mysql_global_status_innodb_os_log_fsyncs` Telegraf `mysql_os_log_fsyncs` MegaEase Dashboard - `mysql-os-log-fsyncs-ratio-metric`
The total number of times that a request for a table lock could not be granted immediately and a wait was needed	MegaEase`mysql-table-locks-waited-metric` Datadog`table_locks_waited` Prometheus `mysql_global_status_table_locks_waited` Telegraf `mysql_table_locks_waited` MegaEase Dashboard - `mysql-table-locks-waited-ratio-metric`
Percentage of CPU time spent in user space by MySQL	MegaEase`NotSupport` Datadog`mysql.performance.user_time` Prometheus `NotSupport`
The number of bytes received from all clients	MegaEase`mysql-bytes-received-metric` Datadog`mysql.performance.bytes_received` Prometheus `mysql_global_status_bytes_received` Telegraf `mysql_bytes_received` MegaEase Dashboard - `mysql-bytes-received-ratio-metric`
The number of bytes sent to all clients	MegaEase`mysql-bytes-sent-metric` Datadog`mysql.performance.bytes_sent` Prometheus `mysql_global_status_bytes_sent` Telegraf `mysql_bytes_sent` MegaEase Dashboard - `mysql-bytes-sent-ratio-metric`

MinIO Metrics Redis Metrics