Yandex Monitoring metric reference
This section describes Managed Service for MySQL® metrics delivered to Monitoring.
The name label contains the metric name.
Labels shared by all Managed Service for MySQL® metrics:
| Label | Value |
|---|---|
| dc | Availability zone |
| host | Host FQDN |
| node | Host type: primary or replica |
| resource_id | Cluster ID |
| resource_type | Resource type: cluster |
| service | Service ID: managed-mysql |
| shard | Shard ID |
| subcluster_name | Subcluster name |
CPU metrics
These metrics show CPU core workload.
The consumption type goes into the systag label.
| Name Type, units |
Description |
|---|---|
cpu.guestDGAUGE, % |
CPU core usage, guest usage type |
cpu.guest_niceDGAUGE, % |
CPU core usage, guest_nice 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.usage_idleDGAUGE, % |
CPU core usage, idle usage type |
cpu.userDGAUGE, % |
CPU core usage, user usage type |
load.avg_15minDGAUGE, % |
Average load over 15 minutes |
load.avg_1minDGAUGE, % |
Average load over one minute |
load.avg_5minDGAUGE, % |
Average load over five minutes |
Disk metrics
| Name Type, units |
Description |
|---|---|
disk.freeDGAUGE, bytes |
Free space |
disk.free_bytesDGAUGE, bytes |
Free space |
disk.free_inodesDGAUGE, count |
Free inodes |
disk.inodes_freeDGAUGE, count |
Free inodes |
disk.inodes_totalDGAUGE, count |
Available inodes |
disk.inodes_usedDGAUGE, count |
Used inodes |
disk.inodes_used_percentDGAUGE, % |
Percentage of used inodes |
disk.totalDGAUGE, bytes |
Available space |
disk.total_bytesDGAUGE, bytes |
Available space |
disk.total_inodesDGAUGE, count |
Available inodes |
disk.usedDGAUGE, bytes |
Used space |
disk.used_bytesDGAUGE, bytes |
Used space |
disk.used_inodesDGAUGE, count |
Used inodes |
disk.used_percentDGAUGE, % |
Percentage of used space |
disk.used_percent_inodesDGAUGE, % |
Percentage of used inodes |
Disk operation metrics
| Name Type, units |
Description |
|---|---|
io.avg_read_timeDGAUGE, milliseconds |
Average disk read time |
io.avg_write_timeDGAUGE, milliseconds |
Average disk write time |
io.disk*.avg_read_timeDGAUGE, milliseconds |
Average read time for a given disk |
io.disk*.avg_write_timeDGAUGE, milliseconds |
Average write time for a given disk |
io.disk*.read_bytesDGAUGE, bytes per second |
Read speed for a given disk |
io.disk*.read_countDGAUGE, operations per second |
Number of reads per second for a given disk |
io.disk*.read_merged_countDGAUGE, operations per second |
Number of merged read operations per second for a given disk |
io.disk*.utilizationDGAUGE, % |
Utilization of a given disk; disabled for network drives. |
io.disk*.write_bytesDGAUGE, bytes per second |
Write speed for a given disk |
io.disk*.write_countDGAUGE, operations per second |
Number of writes per second for a given disk |
io.disk*.write_merged_countDGAUGE, operations per second |
Number of merged write operations per second for a given disk |
io.read_bytesDGAUGE, bytes per second |
Disk read rate |
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 disabled for network drives |
io.write_bytesDGAUGE, bytes per second |
Disk write speed |
io.write_countDGAUGE, operations per second |
Number of writes per second |
io.write_merged_countDGAUGE, operations per second |
Number of merged write operations per second |
RAM metrics
The consumption type goes into the systag label.
| Name Type, units |
Description |
|---|---|
mem.active_bytesDGAUGE, bytes |
Active resident memory (frequently accessed and released when absolutely necessary) |
mem.available_bytesDGAUGE, bytes |
RAM usage, available usage type |
mem.available_percent_bytesDGAUGE, % |
Percentage of RAM usage, available usage type |
mem.buffers_bytesDGAUGE, bytes |
RAM usage, buffers usage type |
mem.cached_bytesDGAUGE, bytes |
RAM usage, cached usage type |
mem.commit_limit_bytesDGAUGE, bytes |
RAM usage, commit_limit usage type |
mem.committed_as_bytesDGAUGE, bytes |
RAM usage, committed_as usage type |
mem.dirty_bytesDGAUGE, bytes |
RAM usage, dirty usage type |
mem.free_bytesDGAUGE, bytes |
Amount of free RAM available, excluding mem.buffers_bytes and mem.cached_bytes |
mem.high_free_bytesDGAUGE, bytes |
RAM usage, high_free usage type |
mem.high_total_bytesDGAUGE, bytes |
RAM usage, high_total usage type |
mem.huge_pages_free_bytesDGAUGE, bytes |
RAM usage, huge_pages_free usage type |
mem.huge_page_size_bytesDGAUGE, bytes |
RAM usage, huge_page_size usage type |
mem.huge_pages_total_bytesDGAUGE, bytes |
RAM usage, huge_pages_total usage type |
mem.inactive_bytesDGAUGE, bytes |
RAM usage, inactive usage type |
mem.low_free_bytesDGAUGE, bytes |
RAM usage, low_free usage type |
mem.low_total_bytesDGAUGE, bytes |
RAM usage, low_total usage type |
mem.mapped_bytesDGAUGE, bytes |
RAM usage, mapped usage type |
mem.page_tables_bytesDGAUGE, bytes |
RAM usage, page_tables usage type |
mem.shared_bytesDGAUGE, bytes |
RAM usage, shared usage type |
mem.slab_bytesDGAUGE, bytes |
RAM usage, slab usage type |
mem.sreclaimable_bytesDGAUGE, bytes |
RAM usage, sreclaimable usage type |
mem.sunreclaim_bytesDGAUGE, bytes |
RAM usage, sunreclaim usage type |
mem.swap_cached_bytesDGAUGE, bytes |
RAM usage, swap_cached usage type |
mem.swap_free_bytesDGAUGE, bytes |
RAM usage, swap_free usage type |
mem.swap_total_bytesDGAUGE, bytes |
RAM usage, swap_total usage type |
mem.totalDGAUGE, bytes |
RAM usage, total usage type |
mem.total_bytesDGAUGE, bytes |
RAM usage, total usage type |
mem.usedDGAUGE, bytes |
RAM usage, used usage type |
mem.used_bytesDGAUGE, bytes |
Amount of RAM currently used by running processes |
mem.used_percent_bytesDGAUGE, % |
Percentage of used RAM |
mem.vmalloc_chunk_bytesDGAUGE, bytes |
RAM usage, vmalloc_chunk usage type |
mem.vmalloc_total_bytesDGAUGE, bytes |
RAM usage, vmalloc_total usage type |
mem.vmalloc_used_bytesDGAUGE, bytes |
RAM usage, vmalloc_used usage type |
mem.write_back_bytesDGAUGE, bytes |
RAM usage, write_back usage type |
mem.write_back_tmp_bytesDGAUGE, bytes |
RAM usage, write_back_tmp usage type |
Network metrics
| Name Type, units |
Description |
|---|---|
dmesg_events.mysql.oomDGAUGE, events |
Number of MySQL® out-of-memory events |
dmesg_events.system.oomDGAUGE, events |
Number of system out-of-memory events |
net.bytes_recvDGAUGE, bytes per second |
Network data receive rate |
net.bytes_sentDGAUGE, bytes per second |
Network data transmit rate |
net.dropinDGAUGE, count |
Dropped receive packets |
net.dropoutDGAUGE, count |
Dropped transmit packets |
net.errinDGAUGE, count |
Receive error count |
net.erroutDGAUGE, count |
Transmit error count |
net.icmpmsg_intype8DGAUGE, messages |
Number of ICMP type 8 (echo request) messages received |
net.icmpmsg_outtype0DGAUGE, messages |
Number of ICMP type 0 (echo reply) messages sent |
net.icmp_outratelimitglobalDGAUGE, messages |
Number of ICMP messages throttled by global rate limits |
net.icmp_outratelimithostDGAUGE, messages |
Number of ICMP messages throttled by host-specific rate limits |
net.ip_outtransmitsDGAUGE, packets |
Number of successfully sent IP packets |
net.packets_recvDGAUGE, packets per second |
Network packet receive rate |
net.packets_sentDGAUGE, packets per second |
Network packet transmit rate |
net.speedDGAUGE, bits per second |
Maximum network data transfer rate for this interface |
net.udplite_memerrorsDGAUGE, errors |
Number of UDP-Lite out-of-memory errors |
net.udp_memerrorsDGAUGE, errors |
Number of UDP out-of-memory errors |
Service metrics
| Name Type, units |
Description |
|---|---|
dbaas_conf.cpu.fractionDGAUGE, fractions |
Fraction of available CPU resources allocated by the service |
dbaas_conf.cpu.guaranteeDGAUGE, fractions |
Guaranteed fraction of CPU resources allocated by the service |
dbaas_conf.cpu.limitDGAUGE, fractions |
Maximum allowed fraction of CPU resource usage |
dbaas_conf.hosts.haDGAUGE, hosts |
Number of hosts set up for high availability |
dbaas_conf.hosts.subcluster.source.totalDGAUGE, hosts |
Number of hosts in the source subcluster |
dbaas_conf.hosts.subcluster.target.totalDGAUGE, hosts |
Number of hosts in the target subcluster |
dbaas_conf.hosts.totalDGAUGE, hosts |
Total hosts used by the service |
disk.mysql.binlogs_bytesDGAUGE, bytes |
Amount of space used by MySQL® service logs |
disk.mysql.data_bytesDGAUGE, bytes |
Amount of space used by data |
disk.mysql.default_tablespace_bytesDGAUGE, bytes |
Amount of space used by data in the default tablespace |
disk.mysql.innodb_logs_bytesDGAUGE, bytes |
Amount of space used by InnoDB logs |
disk.mysql.relaylogs_bytesDGAUGE, bytes |
Amount of space used by MySQL® service logs |
disk.mysql.temp_tablespace_bytesDGAUGE, bytes |
Amount of 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 rate. Additional label: filetype. |
mysql.fileio.readsDGAUGE, operations per second |
Average file reads per second. Additional label: filetype. |
mysql.fileio.write_bytesDGAUGE, bytes per second |
Data write rate. Additional label: filetype. |
mysql.fileio.writesDGAUGE, operations per second |
Average file writes per second. Additional label: filetype. |
mysql.handlerDGAUGE, count |
Number of handlers for various operations. For more information, see this MySQL® guide. Additional label: handler. |
mysql.sessionDGAUGE, count |
Number of sessions at a certain stage. Additional label: stage. |
mysql_Aborted_connects_rateDGAUGE, connections per second |
Rate of failed database connection attempts |
mysql_Binlog_cache_disk_use_rateDGAUGE, transactions per second |
Rate of transactions requiring temporary disk file writes due to binlog cache overflowing |
mysql_Binlog_cache_use_rateDGAUGE, transactions per second |
Rate of transactions using the binlog cache |
mysql_Connections_rateDGAUGE, connections per second |
Rate of database connection attempts (both successful and failed) |
mysql_connections.systemDGAUGE, connections |
Number of system connections |
mysql_connections.userDGAUGE, connections |
Number of user connections |
mysql_Created_tmp_disk_tables_rateDGAUGE, tables per second |
Rate of temporary tables created on the disk during DB query processing |
mysql_Created_tmp_files_rateDGAUGE, files per second |
Rate of temporary DB file creation |
mysql_Created_tmp_tables_rateDGAUGE, tables per second |
Rate of temporary tables created during DB query processing |
mysql_Innodb_buffer_pool_pages_dataDGAUGE, count |
Number of pages with data in the InnoDB buffer, including dirty and clean |
mysql_Innodb_buffer_pool_pages_dirtyDGAUGE, count |
Number of dirty pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_pages_freeDGAUGE, count |
Number of free pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_pages_miscDGAUGE, count |
Number of service pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_pages_totalDGAUGE, count |
Total pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_read_requests_rateDGAUGE, operations per second |
Rate of InnoDB reads |
mysql_Innodb_buffer_pool_reads_rateDGAUGE, operations per second |
Rate of InnoDB reads requiring InnoDB to access the disk |
mysql_Innodb_checkpoint_ageDGAUGE, bytes |
Size of InnoDB in-memory data before disk flush |
mysql_Innodb_checkpoint_max_ageDGAUGE, bytes |
Maximum size of InnoDB in-memory data before disk flush |
mysql_Innodb_data_fsyncs_rateDGAUGE, operations per second |
Rate of fsync() operations when flushing data to the disk in InnoDB |
mysql_Innodb_data_reads_rateDGAUGE, operations per second |
InnoDB disk read rate |
mysql_Innodb_data_writes_rateDGAUGE, operations per second |
InnoDB write rate |
mysql_Innodb_page_sizeDGAUGE, bytes |
Page size in InnoDB (defaults to 16 KB) |
mysql_Innodb_row_lock_current_waitsDGAUGE, count |
Number of row locks in InnoDB |
mysql_Innodb_row_lock_time_rateDGAUGE, milliseconds |
Total InnoDB row lock wait time |
mysql_Innodb_row_lock_waits_rateDGAUGE, operations per second |
Rate of InnoDB operations waiting for row locks |
mysql_Innodb_rows_deleted_rateDGAUGE, rows per second |
InnoDB row deletion rate |
mysql_Innodb_rows_inserted_rateDGAUGE, rows per second |
InnoDB row insertion rate |
mysql_Innodb_rows_read_rateDGAUGE, rows per second |
Rate of row reads from InnoDB tables |
mysql_Innodb_rows_updated_rateDGAUGE, rows per second |
InnoDB row update rate |
mysql_Open_table_definitionsDGAUGE, count |
Number of cached table definitions |
mysql_Open_tablesDGAUGE, count |
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 tables opened per unit of time |
mysql_Prepared_stmt_countDGAUGE, count |
Number of prepared statements |
mysql_Queries_rateDGAUGE, queries per second |
Query execution rate, including user queries and stored procedures |
mysql_Questions_rateDGAUGE, queries per second |
User query execution rate |
mysql_Rpl_semi_sync_master_clientsDGAUGE, count |
Number of semi-sync replicas |
mysql_Rpl_semi_sync_master_tx_avg_wait_timeDGAUGE, microseconds |
Average wait time for a transaction on the replication source |
mysql_Rpl_semi_sync_master_tx_wait_time_rateDGAUGE, microseconds |
Total wait time for a transaction on the replication source, per unit of time |
mysql_Rpl_semi_sync_master_wait_sessionsDGAUGE, count |
Number of sessions waiting for a response from replicas |
mysql_Select_full_join_rateDGAUGE, queries per second |
Rate of joins using table scans rather than indexes |
mysql_Select_full_range_join_rateDGAUGE, queries per second |
Number of joins searching by range in the reference table |
mysql_Slow_queries_rateDGAUGE, queries per second |
Number of slow queries running longer than the long_query_time per unit of time |
mysql_Sort_range_rateDGAUGE, queries per second |
Number of range sorts 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, count |
Number of immediate table locks |
mysql_Table_locks_waitedDGAUGE, count |
Number of table locks that had to wait |
mysql_Table_open_cache_hits_rateDGAUGE, operations per second |
Open table cache hit rate |
mysql_Table_open_cache_misses_rateDGAUGE, operations per second |
Number of misses for open table cache lookups per unit of time |
mysql_Threads_cachedDGAUGE, count |
Number of cached threads |
mysql_Threads_connectedDGAUGE, count |
Number of threads handling open DB connections |
mysql_Threads_created_rateDGAUGE, threads per second |
Thread creation rate |
mysql_Threads_runningDGAUGE, count |
Number of currently running threads |
mysql_UptimeDGAUGE, seconds |
Server uptime |
mysql_config_innodb_buffer_pool_sizeDGAUGE, bytes |
InnoDB buffer pool size |
mysql_config_innodb_log_file_sizeDGAUGE, bytes |
Log file size in the log group |
mysql_config_max_connectionsDGAUGE, count |
Maximum number of concurrent connections |
mysql_config_table_open_cacheDGAUGE, count |
Number of open tables across all threads |
mysql_config_thread_cache_sizeDGAUGE, number |
Number of threads to cache for reuse |
mysql_is_aliveDGAUGE, 0/1 |
Host health indicator. It can be either 1 if the database host is healthy or 0 if it is not. |
mysql_is_primaryDGAUGE, 0/1 |
Master host indicator. It can be either 1 if the database host is a master or 0 if it is not. |
mysql_is_replicaDGAUGE, 0/1 |
Replica host indicator. It can be either 1 if a DB host is a replica or 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, 75th percentile |
mysql_latency_query_0.90DGAUGE, milliseconds |
Query execution time, 90th percentile |
mysql_latency_query_0.95DGAUGE, milliseconds |
Query execution time, 95th percentile |
mysql_latency_query_0.99DGAUGE, milliseconds |
Query execution time, 99th 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, 75th percentile |
mysql_latency_trx_0.90DGAUGE, milliseconds |
Transaction execution time, 90th percentile |
mysql_latency_trx_0.95DGAUGE, milliseconds |
Transaction execution time, 95th percentile |
mysql_latency_trx_0.99DGAUGE, milliseconds |
Transaction execution time, 99th 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 |
Replica's lag behind the master |
mysql_replication.io_thread_runningDGAUGE, 0/1 |
State of MySQL® replication I/O thread.It can be either 1 if the thread is running or 0 if it is stopped. |
mysql_replication.sql_thread_runningDGAUGE, 0/1 |
State of MySQL® replication SQL thread.It can be either 1 if the thread is running or 0 if it is stopped. |
mysql_roleDGAUGE, 1/2 |
Current MySQL® server role in the replication. It can be either 2 if the server is a replica (secondary server) or 1 if it is a master (primary server). |
mysql_writableDGAUGE, 0/1 |
Server write access. It can be either 1 if a server is available for writes or 0 if it is not. |
oom_countDGAUGE, count |
Number of out-of-memory events |
Other metrics
| Name Type, units |
Description |
|---|---|
can_readDGAUGE, 0/1 |
Host read access indicator.1 if the host service is available for reads, 0 if not. |
can_writeDGAUGE, 0/1 |
Host write access indicator.1 if the host service is available for writes, 0 if not. |
core_dump.countDGAUGE, count |
Number of core dumps |
n_unique_usersDGAUGE, users |
Number of unique users or accounts engaging with the system |