Contact UsGet started
© 2024 Iron Hive LLC Belgrade

Yandex Managed Service for MySQL® metrics

Written by
Improved by
Updated at April 15, 2024

This section describes the Managed Service for MySQL® metrics delivered to Monitoring.

The metric name is written in the name label.

Common labels for all Managed Service for MySQL® metrics:

Label Value
service Service ID: managed-mysql
resource_type Resource type: cluster
resource_id Cluster ID
host Host FQDN
node Host type: primary, replica

CPU metrics

Processor core workload.

Name
Type, units		 Description
cpu.guest
DGAUGE, %		 CPU core usage, guest usage type
cpu.idle
DGAUGE, %		 CPU core usage, idle usage type
cpu.iowait
DGAUGE, %		 CPU core usage, iowait usage type
cpu.irq
DGAUGE, %		 CPU core usage, irq usage type
cpu.nice
DGAUGE, %		 CPU core usage, nice usage type
cpu.softirq
DGAUGE, %		 CPU core usage, softirq usage type
cpu.steal
DGAUGE, %		 CPU core usage, steal usage type
cpu.system
DGAUGE, %		 CPU core usage, system usage type
cpu.user
DGAUGE, %		 CPU core usage, user usage type
load.avg_15min
DGAUGE, %		 Average load over 15 minutes
load.avg_1min
DGAUGE, %		 Average load over 1 minute
load.avg_5min
DGAUGE, %		 Average load over 5 minutes

Disk metrics

Name
Type, unit		 Description
disk.free_bytes
DGAUGE, bytes		 Free space
disk.free_inodes
DGAUGE, number		 Number of free inodes
disk.total_bytes
DGAUGE, bytes		 Available space
disk.total_inodes
DGAUGE, number		 Available inodes
disk.used_bytes
DGAUGE, bytes		 Used space
disk.used_inodes
DGAUGE, number		 Used inodes

Disk operation metrics

Name
Type, units		 Description
io.avg_read_time
DGAUGE, ms		 Average disk read time
io.avg_write_time
DGAUGE, ms		 Average disk write time
io.disk*.avg_read_time
DGAUGE, ms		 Average read time for a specific disk
io.disk*.avg_write_time
DGAUGE, ms		 Average write time for a specific disk
io.disk*.read_bytes
DGAUGE, bytes per second		 Read speed for a specific disk
io.disk*.read_count
DGAUGE, operations per second		 Read operations per second for a specific disk
io.disk*.read_merged_count
DGAUGE, operations per second		 Merged read operations per second for a specific disk
io.disk*.utilization
DGAUGE, %		 Utilization of a specific disk; disabled for network drives
io.disk*.write_bytes
DGAUGE, bytes per second		 Write speed for a specific disk
io.disk*.write_count
DGAUGE, operations per second		 Number of write operations per second for a specific disk
io.disk*.write_merged_count
DGAUGE, operations per second		 Number of merged write operations per second for a specific disk
io.read_bytes
DGAUGE, bytes/s		 Disk read speed
io.read_count
DGAUGE, operations per second		 Number of read operations per second
io.read_merged_count
DGAUGE, operations per second		 Number of merged read operations per second
io.utilization
DGAUGE, %		 Disk utilization
io.write_bytes
DGAUGE, bytes/s		 Disk write speed
io.write_count
DGAUGE, operations per second		 Number of write operations per second
io.write_merged_count
DGAUGE, operations per second		 Number of merged write operations per second

RAM metrics

Name
Type, units		 Description
mem.active_bytes
DGAUGE, bytes		 Amount of RAM used most often and only freed up when absolutely necessary
mem.available_bytes
DGAUGE, bytes		 RAM usage, available usage type
mem.buffers_bytes
DGAUGE, bytes		 RAM usage, buffers usage type
mem.cached_bytes
DGAUGE, bytes		 RAM usage, cached usage type
mem.free_bytes
DGAUGE, bytes		 Amount of free RAM available, excluding mem.buffers_bytes and mem.cached_bytes
mem.shared_bytes
DGAUGE, bytes		 RAM usage, shared usage type
mem.total_bytes
DGAUGE, bytes		 RAM usage, total usage type
mem.used_bytes
DGAUGE, bytes		 Amount of RAM currently used by the running processes

Network metrics

Name
Type, units		 Description
net.bytes_recv
DGAUGE, bytes/s		 Rate of receiving data over the network
net.bytes_sent
DGAUGE, bytes/s		 Rate of sending data over the network
net.dropin
DGAUGE, number		 Packets dropped upon receipt
net.dropout
DGAUGE, number		 Packets dropped when being sent
net.errin
DGAUGE, number		 Number of errors upon receipt
net.errout
DGAUGE, number		 Number of errors at sending
net.packets_recv
DGAUGE, packets per second		 Rate of receiving packets over the network
net.packets_sent
DGAUGE, packets per second		 Rate of sending packets over the network

Service metrics

Name
Type, units		 Description
disk.free_inodes
DGAUGE, number		 Number of free inodes
disk.mysql.binlogs_bytes
DGAUGE, bytes		 Space used by MySQL service logs
disk.mysql.data_bytes
DGAUGE, bytes		 Space used by data
disk.mysql.default_tablespace_bytes
DGAUGE, bytes		 Space used by data in the default tablespace
disk.mysql.innodb_logs_bytes
DGAUGE, bytes		 Space used by InnoDB logs
disk.mysql.relaylogs_bytes
DGAUGE, bytes		 Space used by MySQL service logs
disk.mysql.temp_tablespace_bytes
DGAUGE, bytes		 Space used by data in the temporary tablespace
disk.mysql.undo_tablespace_bytes
DGAUGE, bytes		 Space used by data in the InnoDB undo tablespace
mysql.fileio.read_bytes
DGAUGE, bytes per second		 Data read speed.
Additional labels: filetype
mysql.fileio.reads
DGAUGE, operations per second		 Average speed of file reads per second.
Additional labels: filetype
mysql.fileio.write_bytes
DGAUGE, bytes per second		 Data write speed.
Additional labels: filetype
mysql.fileio.writes
DGAUGE, operations per second		 Average speed of file writes per second.
Additional labels: filetype
mysql.handler
DGAUGE, number		 Number of handlers of various operations. For more information, see the MySQL documentation.
Additional labels: handler.
mysql.session
DGAUGE, number		 Number of sessions at a certain stage.
Additional labels: stage.
mysql_Aborted_connects_rate
DGAUGE, connections per second		 Number of failed attempts to connect to the DB
mysql_Binlog_cache_disk_use_rate
DGAUGE, transactions per second		 Number of transactions that used the Binlog cache but exceeded its size and had to write data to a temporary disk file
mysql_Binlog_cache_use_rate
DGAUGE, transactions per second		 Number of transactions that used the Binlog cache
mysql_Connections_rate
DGAUGE, connections per second		 Attempts to connect to the DB (successful and failed)
mysql_Created_tmp_disk_tables_rate
DGAUGE, tables per second		 Number of temporary tables created on disk when handling DB queries
mysql_Created_tmp_files_rate
DGAUGE, files per second		 Number of temporary DB files
mysql_Created_tmp_tables_rate
DGAUGE, tables per second		 Number of temporary tables created when handling DB queries
mysql_Innodb_buffer_pool_pages_data
DGAUGE, number		 Number of pages with data in the InnoDB buffer, both dirty and clean
mysql_Innodb_buffer_pool_pages_dirty
DGAUGE, number		 Number of dirty pages in the InnoDB buffer
mysql_Innodb_buffer_pool_pages_free
DGAUGE, number		 Number of free pages in the InnoDB buffer
mysql_Innodb_buffer_pool_pages_misc
DGAUGE, number		 Number of service pages in the InnoDB buffer
mysql_Innodb_buffer_pool_pages_total
DGAUGE, number		 Number of pages in the InnoDB buffer
mysql_Innodb_buffer_pool_read_requests_rate
DGAUGE, operations per second		 Number of InnoDB reads
mysql_Innodb_buffer_pool_reads_rate
DGAUGE, operations per second		 Number of InnoDB reads to handle which InnoDB has to access the disk
mysql_Innodb_checkpoint_age
DGAUGE, bytes		 Size of data in InnoDB memory before being flushed to the disk
mysql_Innodb_checkpoint_max_age
DGAUGE, bytes		 Maximum size of data in InnoDB memory before being flushed to the disk
mysql_Innodb_data_fsyncs_rate
DGAUGE, operations per second		 Number of fsync() operations when flushing data to the disk in InnoDB
mysql_Innodb_data_reads_rate
DGAUGE, operations per second		 Number of disk reads in InnoDB
mysql_Innodb_data_writes_rate
DGAUGE, operations per second		 Write rate in InnoDB
mysql_Innodb_page_size
DGAUGE, bytes		 Page size in InnoDB (defaults to 16 KB)
mysql_Innodb_row_lock_current_waits
DGAUGE, number		 Number of row locks in InnoDB
mysql_Innodb_row_lock_time_rate
DGAUGE, ms		 Total waiting time for row locks in InnoDB
mysql_Innodb_row_lock_waits_rate
DGAUGE, operations per second		 Number of InnoDB operations that had to wait for row locks
mysql_Innodb_rows_deleted_rate
DGAUGE, rows per second		 Rows deleted in InnoDB
mysql_Innodb_rows_inserted_rate
DGAUGE, rows per second		 Rows inserted in InnoDB
mysql_Innodb_rows_read_rate
DGAUGE, rows per second		 Rows read from InnoDB tables
mysql_Innodb_rows_updated_rate
DGAUGE, rows per second		 Rows updated in InnoDB
mysql_Open_table_definitions
DGAUGE, number		 Number of cached table definitions
mysql_Open_tables
DGAUGE, number		 Number of open tables
mysql_Opened_table_definitions_rate
DGAUGE, tables per second		 Number of table definitions cached per unit of time
mysql_Opened_tables_rate
DGAUGE, tables per second		 Number of table definitions opened per unit of time
mysql_Prepared_stmt_count
DGAUGE, number		 Prepared statements
mysql_Queries_rate
DGAUGE, queries per second		 Number of active queries, including user queries and stored procedures, per unit of time
mysql_Questions_rate
DGAUGE, queries per second		 Number of active user queries per unit of time
mysql_Rpl_semi_sync_master_clients
DGAUGE, number		 Number of semi-sync replicas
mysql_Rpl_semi_sync_master_tx_avg_wait_time
DGAUGE, microseconds		 Average waiting time for a transaction by the replication source
mysql_Rpl_semi_sync_master_tx_wait_time_rate
DGAUGE, microseconds		 Total waiting time for a transaction by the replication source, per unit of time
mysql_Rpl_semi_sync_master_wait_sessions
DGAUGE, number		 Number of sessions waiting for a response from replicas
mysql_Select_full_join_rate
DGAUGE, queries per second		 Number of Joins that use table scans instead of indexes
mysql_Select_full_range_join_rate
DGAUGE, queries per second		 Number of Joins that search by range in a reference table
mysql_Slow_queries_rate
DGAUGE, queries per second		 Number of slow queries that take more seconds than set in long_query_time to execute, per unit of time
mysql_Sort_range_rate
DGAUGE, queries per second		 Number of sorts by range per unit of time
mysql_Sort_rows_rate
DGAUGE, queries per second		 Number of rows sorted per unit of time
mysql_Sort_scan_rate
DGAUGE, queries per second		 Number of sorts using table scans per unit of time
mysql_Table_locks_immediate
DGAUGE, number		 Number of immediate table locks
mysql_Table_locks_waited
DGAUGE, number		 Number of table locks that had to wait
mysql_Table_open_cache_hits_rate
DGAUGE, operations per second		 Number of hits for a search in the cache of open tables per unit of time
mysql_Table_open_cache_misses_rate
DGAUGE, operations per second		 Number of failed attempts to search in the cache of open tables per unit of time
mysql_Threads_cached
DGAUGE, number		 Number of threads cached
mysql_Threads_connected
DGAUGE, number		 Number of threads handling open DB connections
mysql_Threads_created_rate
DGAUGE, threads per second		 Number of threads created per unit of time
mysql_Threads_running
DGAUGE, number		 Number of threads running at the moment
mysql_Uptime
DGAUGE, seconds		 Server uptime since last restart
mysql_config_innodb_buffer_pool_size
DGAUGE, bytes		 Size of the InnoDB buffer pool
mysql_config_innodb_log_file_size
DGAUGE, bytes		 Log file size in the log group
mysql_config_max_connections
DGAUGE, number		 Maximum number of concurrent connections
mysql_config_table_open_cache
DGAUGE, number		 Number of open tables cache for all threads
mysql_config_thread_cache_size
DGAUGE, number		 Number of threads that need to be cached to be reused
mysql_is_alive
DGAUGE, 0/1		 Host health indicator.
1 if a DB host is alive, 0 if it is not.
mysql_is_primary
DGAUGE, 0/1		 Master host indicator.
1 if a DB host is a master, 0 if it is not.
mysql_is_replica
DGAUGE, 0/1		 Replica host indicator.
1 if a DB host is a replica, 0 if it is not.
mysql_latency_query_0.5
DGAUGE, milliseconds		 Query execution time, median value
mysql_latency_query_0.75
DGAUGE, milliseconds		 Query execution time, 0.75 percentile
mysql_latency_query_0.90
DGAUGE, milliseconds		 Query execution time, 0.90 percentile
mysql_latency_query_0.95
DGAUGE, milliseconds		 Query execution time, 0.95 percentile
mysql_latency_query_0.99
DGAUGE, milliseconds		 Query execution time, 0.99 percentile
mysql_latency_query_avg
DGAUGE, milliseconds		 Average query execution time
mysql_latency_query_oldest
DGAUGE, milliseconds		 Execution time of the oldest query
mysql_latency_trx_0.5
DGAUGE, milliseconds		 Transaction execution time, median value
mysql_latency_trx_0.75
DGAUGE, milliseconds		 Transaction execution time, 0.75 percentile
mysql_latency_trx_0.90
DGAUGE, milliseconds		 Transaction execution time, 0.90 percentile
mysql_latency_trx_0.95
DGAUGE, milliseconds		 Transaction execution time, 0.95 percentile
mysql_latency_trx_0.99
DGAUGE, milliseconds		 Transaction execution time, 0.99 percentile
mysql_latency_trx_avg
DGAUGE, milliseconds		 Average transaction execution time
mysql_latency_trx_oldest
DGAUGE, milliseconds		 Execution time of the oldest transaction
mysql_replication_lag
DGAUGE, seconds		 Time that a replica lags behind the master
mysql_role
DGAUGE, 1/2		 Current role of a MySQL server in the replication.
2 if the server is a replica (secondary server), 1 if it is a master (primary server).
mysql_writable
DGAUGE, 0/1		 Server write access.
1 if a server is available for writes, 0 if it is not.

Other metrics

Name
Type, units		 Description
can_read
DGAUGE, 0/1		 Read access indicator.
1 if a cluster is available for reads, 0 if it is not.
can_write
DGAUGE, 0/1		 Write access indicator.
1 if a cluster is available for writes, 0 if it is not.
Previous
Managed Service for MongoDB
Next
Managed Service for OpenSearch