Yandex Monitoring metric reference
This section describes 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. |