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.guestDGAUGE, % |
CPU core usage, guest usage type |
cpu.idleDGAUGE, % |
CPU core usage, idle usage type |
cpu.iowaitDGAUGE, % |
CPU core usage, iowait usage type |
cpu.irqDGAUGE, % |
CPU core usage, irq usage type |
cpu.niceDGAUGE, % |
CPU core usage, nice usage type |
cpu.softirqDGAUGE, % |
CPU core usage, softirq usage type |
cpu.stealDGAUGE, % |
CPU core usage, steal usage type |
cpu.systemDGAUGE, % |
CPU core usage, system usage type |
cpu.userDGAUGE, % |
CPU core usage, user usage type |
load.avg_15minDGAUGE, % |
Average load over 15 minutes |
load.avg_1minDGAUGE, % |
Average load over 1 minute |
load.avg_5minDGAUGE, % |
Average load over 5 minutes |
Disk metrics
| Name Type, unit |
Description |
|---|---|
disk.free_bytesDGAUGE, bytes |
Free space |
disk.free_inodesDGAUGE, number |
Number of free inodes |
disk.total_bytesDGAUGE, bytes |
Available space |
disk.total_inodesDGAUGE, number |
Available inodes |
disk.used_bytesDGAUGE, bytes |
Used space |
disk.used_inodesDGAUGE, number |
Used inodes |
Disk operation metrics
| Name Type, units |
Description |
|---|---|
io.avg_read_timeDGAUGE, ms |
Average disk read time |
io.avg_write_timeDGAUGE, ms |
Average disk write time |
io.disk*.avg_read_timeDGAUGE, ms |
Average read time for a specific disk |
io.disk*.avg_write_timeDGAUGE, ms |
Average write time for a specific disk |
io.disk*.read_bytesDGAUGE, bytes per second |
Read speed for a specific disk |
io.disk*.read_countDGAUGE, operations per second |
Read operations per second for a specific disk |
io.disk*.read_merged_countDGAUGE, operations per second |
Merged read operations per second for a specific disk |
io.disk*.utilizationDGAUGE, % |
Utilization of a specific disk; disabled for network drives |
io.disk*.write_bytesDGAUGE, bytes per second |
Write speed for a specific disk |
io.disk*.write_countDGAUGE, operations per second |
Number of write operations per second for a specific disk |
io.disk*.write_merged_countDGAUGE, operations per second |
Number of merged write operations per second for a specific disk |
io.read_bytesDGAUGE, bytes/s |
Disk read speed |
io.read_countDGAUGE, operations per second |
Number of read operations per second |
io.read_merged_countDGAUGE, operations per second |
Number of merged read operations per second |
io.utilizationDGAUGE, % |
Disk utilization |
io.write_bytesDGAUGE, bytes/s |
Disk write speed |
io.write_countDGAUGE, operations per second |
Number of write operations per second |
io.write_merged_countDGAUGE, operations per second |
Number of merged write operations per second |
RAM metrics
| Name Type, units |
Description |
|---|---|
mem.active_bytesDGAUGE, bytes |
Amount of RAM used most often and only freed up when absolutely necessary |
mem.available_bytesDGAUGE, bytes |
RAM usage, available usage type |
mem.buffers_bytesDGAUGE, bytes |
RAM usage, buffers usage type |
mem.cached_bytesDGAUGE, bytes |
RAM usage, cached usage type |
mem.free_bytesDGAUGE, bytes |
Amount of free RAM available, excluding mem.buffers_bytes and mem.cached_bytes |
mem.shared_bytesDGAUGE, bytes |
RAM usage, shared usage type |
mem.total_bytesDGAUGE, bytes |
RAM usage, total usage type |
mem.used_bytesDGAUGE, bytes |
Amount of RAM currently used by the running processes |
Network metrics
| Name Type, units |
Description |
|---|---|
net.bytes_recvDGAUGE, bytes/s |
Rate of receiving data over the network |
net.bytes_sentDGAUGE, bytes/s |
Rate of sending data over the network |
net.dropinDGAUGE, number |
Packets dropped upon receipt |
net.dropoutDGAUGE, number |
Packets dropped when being sent |
net.errinDGAUGE, number |
Number of errors upon receipt |
net.erroutDGAUGE, number |
Number of errors at sending |
net.packets_recvDGAUGE, packets per second |
Rate of receiving packets over the network |
net.packets_sentDGAUGE, packets per second |
Rate of sending packets over the network |
Service metrics
| Name Type, units |
Description |
|---|---|
disk.free_inodesDGAUGE, number |
Number of free inodes |
disk.mysql.binlogs_bytesDGAUGE, bytes |
Space used by MySQL service logs |
disk.mysql.data_bytesDGAUGE, bytes |
Space used by data |
disk.mysql.default_tablespace_bytesDGAUGE, bytes |
Space used by data in the default tablespace |
disk.mysql.innodb_logs_bytesDGAUGE, bytes |
Space used by InnoDB logs |
disk.mysql.relaylogs_bytesDGAUGE, bytes |
Space used by MySQL service logs |
disk.mysql.temp_tablespace_bytesDGAUGE, bytes |
Space used by data in the temporary tablespace |
disk.mysql.undo_tablespace_bytesDGAUGE, bytes |
Space used by data in the InnoDB undo tablespace |
mysql.fileio.read_bytesDGAUGE, bytes per second |
Data read speed. Additional labels: filetype |
mysql.fileio.readsDGAUGE, operations per second |
Average speed of file reads per second. Additional labels: filetype |
mysql.fileio.write_bytesDGAUGE, bytes per second |
Data write speed. Additional labels: filetype |
mysql.fileio.writesDGAUGE, operations per second |
Average speed of file writes per second. Additional labels: filetype |
mysql.handlerDGAUGE, number |
Number of handlers of various operations. For more information, see the MySQL documentation. Additional labels: handler. |
mysql.sessionDGAUGE, number |
Number of sessions at a certain stage. Additional labels: stage. |
mysql_Aborted_connects_rateDGAUGE, connections per second |
Number of failed attempts to connect to the DB |
mysql_Binlog_cache_disk_use_rateDGAUGE, 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_rateDGAUGE, transactions per second |
Number of transactions that used the Binlog cache |
mysql_Connections_rateDGAUGE, connections per second |
Attempts to connect to the DB (successful and failed) |
mysql_Created_tmp_disk_tables_rateDGAUGE, tables per second |
Number of temporary tables created on disk when handling DB queries |
mysql_Created_tmp_files_rateDGAUGE, files per second |
Number of temporary DB files |
mysql_Created_tmp_tables_rateDGAUGE, tables per second |
Number of temporary tables created when handling DB queries |
mysql_Innodb_buffer_pool_pages_dataDGAUGE, number |
Number of pages with data in the InnoDB buffer, both dirty and clean |
mysql_Innodb_buffer_pool_pages_dirtyDGAUGE, number |
Number of dirty pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_pages_freeDGAUGE, number |
Number of free pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_pages_miscDGAUGE, number |
Number of service pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_pages_totalDGAUGE, number |
Number of pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_read_requests_rateDGAUGE, operations per second |
Number of InnoDB reads |
mysql_Innodb_buffer_pool_reads_rateDGAUGE, operations per second |
Number of InnoDB reads to handle which InnoDB has to access the disk |
mysql_Innodb_checkpoint_ageDGAUGE, bytes |
Size of data in InnoDB memory before being flushed to the disk |
mysql_Innodb_checkpoint_max_ageDGAUGE, bytes |
Maximum size of data in InnoDB memory before being flushed to the disk |
mysql_Innodb_data_fsyncs_rateDGAUGE, operations per second |
Number of fsync() operations when flushing data to the disk in InnoDB |
mysql_Innodb_data_reads_rateDGAUGE, operations per second |
Number of disk reads in InnoDB |
mysql_Innodb_data_writes_rateDGAUGE, operations per second |
Write rate in InnoDB |
mysql_Innodb_page_sizeDGAUGE, bytes |
Page size in InnoDB (defaults to 16 KB) |
mysql_Innodb_row_lock_current_waitsDGAUGE, number |
Number of row locks in InnoDB |
mysql_Innodb_row_lock_time_rateDGAUGE, ms |
Total waiting time for row locks in InnoDB |
mysql_Innodb_row_lock_waits_rateDGAUGE, operations per second |
Number of InnoDB operations that had to wait for row locks |
mysql_Innodb_rows_deleted_rateDGAUGE, rows per second |
Rows deleted in InnoDB |
mysql_Innodb_rows_inserted_rateDGAUGE, rows per second |
Rows inserted in InnoDB |
mysql_Innodb_rows_read_rateDGAUGE, rows per second |
Rows read from InnoDB tables |
mysql_Innodb_rows_updated_rateDGAUGE, rows per second |
Rows updated in InnoDB |
mysql_Open_table_definitionsDGAUGE, number |
Number of cached table definitions |
mysql_Open_tablesDGAUGE, number |
Number of open tables |
mysql_Opened_table_definitions_rateDGAUGE, tables per second |
Number of table definitions cached per unit of time |
mysql_Opened_tables_rateDGAUGE, tables per second |
Number of table definitions opened per unit of time |
mysql_Prepared_stmt_countDGAUGE, number |
Prepared statements |
mysql_Queries_rateDGAUGE, queries per second |
Number of active queries, including user queries and stored procedures, per unit of time |
mysql_Questions_rateDGAUGE, queries per second |
Number of active user queries per unit of time |
mysql_Rpl_semi_sync_master_clientsDGAUGE, number |
Number of semi-sync replicas |
mysql_Rpl_semi_sync_master_tx_avg_wait_timeDGAUGE, microseconds |
Average waiting time for a transaction by the replication source |
mysql_Rpl_semi_sync_master_tx_wait_time_rateDGAUGE, microseconds |
Total waiting time for a transaction by the replication source, per unit of time |
mysql_Rpl_semi_sync_master_wait_sessionsDGAUGE, number |
Number of sessions waiting for a response from replicas |
mysql_Select_full_join_rateDGAUGE, queries per second |
Number of Joins that use table scans instead of indexes |
mysql_Select_full_range_join_rateDGAUGE, queries per second |
Number of Joins that search by range in a reference table |
mysql_Slow_queries_rateDGAUGE, 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_rateDGAUGE, queries per second |
Number of sorts by range per unit of time |
mysql_Sort_rows_rateDGAUGE, queries per second |
Number of rows sorted per unit of time |
mysql_Sort_scan_rateDGAUGE, queries per second |
Number of sorts using table scans per unit of time |
mysql_Table_locks_immediateDGAUGE, number |
Number of immediate table locks |
mysql_Table_locks_waitedDGAUGE, number |
Number of table locks that had to wait |
mysql_Table_open_cache_hits_rateDGAUGE, operations per second |
Number of hits for a search in the cache of open tables per unit of time |
mysql_Table_open_cache_misses_rateDGAUGE, operations per second |
Number of failed attempts to search in the cache of open tables per unit of time |
mysql_Threads_cachedDGAUGE, number |
Number of threads cached |
mysql_Threads_connectedDGAUGE, number |
Number of threads handling open DB connections |
mysql_Threads_created_rateDGAUGE, threads per second |
Number of threads created per unit of time |
mysql_Threads_runningDGAUGE, number |
Number of threads running at the moment |
mysql_UptimeDGAUGE, seconds |
Server uptime since last restart |
mysql_config_innodb_buffer_pool_sizeDGAUGE, bytes |
Size of the InnoDB buffer pool |
mysql_config_innodb_log_file_sizeDGAUGE, bytes |
Log file size in the log group |
mysql_config_max_connectionsDGAUGE, number |
Maximum number of concurrent connections |
mysql_config_table_open_cacheDGAUGE, number |
Number of open tables cache for all threads |
mysql_config_thread_cache_sizeDGAUGE, number |
Number of threads that need to be cached to be reused |
mysql_is_aliveDGAUGE, 0/1 |
Host health indicator.1 if a DB host is alive, 0 if it is not. |
mysql_is_primaryDGAUGE, 0/1 |
Master host indicator.1 if a DB host is a master, 0 if it is not. |
mysql_is_replicaDGAUGE, 0/1 |
Replica host indicator.1 if a DB host is a replica, 0 if it is not. |
mysql_latency_query_0.5DGAUGE, milliseconds |
Query execution time, median value |
mysql_latency_query_0.75DGAUGE, milliseconds |
Query execution time, 0.75 percentile |
mysql_latency_query_0.90DGAUGE, milliseconds |
Query execution time, 0.90 percentile |
mysql_latency_query_0.95DGAUGE, milliseconds |
Query execution time, 0.95 percentile |
mysql_latency_query_0.99DGAUGE, milliseconds |
Query execution time, 0.99 percentile |
mysql_latency_query_avgDGAUGE, milliseconds |
Average query execution time |
mysql_latency_query_oldestDGAUGE, milliseconds |
Execution time of the oldest query |
mysql_latency_trx_0.5DGAUGE, milliseconds |
Transaction execution time, median value |
mysql_latency_trx_0.75DGAUGE, milliseconds |
Transaction execution time, 0.75 percentile |
mysql_latency_trx_0.90DGAUGE, milliseconds |
Transaction execution time, 0.90 percentile |
mysql_latency_trx_0.95DGAUGE, milliseconds |
Transaction execution time, 0.95 percentile |
mysql_latency_trx_0.99DGAUGE, milliseconds |
Transaction execution time, 0.99 percentile |
mysql_latency_trx_avgDGAUGE, milliseconds |
Average transaction execution time |
mysql_latency_trx_oldestDGAUGE, milliseconds |
Execution time of the oldest transaction |
mysql_replication_lagDGAUGE, seconds |
Time that a replica lags behind the master |
mysql_roleDGAUGE, 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_writableDGAUGE, 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_readDGAUGE, 0/1 |
Read access indicator.1 if a cluster is available for reads, 0 if it is not. |
can_writeDGAUGE, 0/1 |
Write access indicator.1 if a cluster is available for writes, 0 if it is not. |