Yandex Monitoring metric reference
This section describes Managed Service for MySQL® metrics delivered to Monitoring.
The name
label stores the metric name.
Labels shared by 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
These metrics show processor core workload.
Name Type, units |
Description |
---|---|
cpu.guest DGAUGE , % |
CPU core usage, guest usage type |
cpu.guest_nice DGAUGE , % |
CPU core usage, guest_nice 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.usage_idle DGAUGE , % |
CPU core usage, idle 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 one minute |
load.avg_5min DGAUGE , % |
Average load over five minutes |
Disk metrics
Name Type, units |
Description |
---|---|
disk.free DGAUGE , bytes |
Free space |
disk.free_bytes DGAUGE , bytes |
Free space |
disk.free_inodes DGAUGE , number |
Free inodes |
disk.inodes_free DGAUGE , number |
Free inodes |
disk.inodes_total DGAUGE , number |
Available inodes |
disk.inodes_used DGAUGE , number |
Used inodes |
disk.inodes_used_percent DGAUGE , % |
Percentage of used inodes |
disk.total DGAUGE , bytes |
Available space |
disk.total_bytes DGAUGE , bytes |
Available space |
disk.total_inodes DGAUGE , number |
Available inodes |
disk.used DGAUGE , bytes |
Used space |
disk.used_bytes DGAUGE , bytes |
Used space |
disk.used_inodes DGAUGE , number |
Used inodes |
disk.used_percent DGAUGE , % |
Percentage of used space |
disk.used_percent_inodes DGAUGE , % |
Percentage of used inodes |
Disk I/O metrics
Name Type, units |
Description |
---|---|
io.avg_read_time DGAUGE , milliseconds |
Average disk read time |
io.avg_write_time DGAUGE , milliseconds |
Average disk write time |
io.disk*.avg_read_time DGAUGE , milliseconds |
Average read time for a given disk |
io.disk*.avg_write_time DGAUGE , milliseconds |
Average write time for a given disk |
io.disk*.read_bytes DGAUGE , bytes per second |
Read speed for a given disk |
io.disk*.read_count DGAUGE , operations per second |
Number of reads per second for a given disk |
io.disk*.read_merged_count DGAUGE , operations per second |
Number of merged read operations per second for a given disk |
io.disk*.utilization DGAUGE , % |
Utilization of a given disk; disabled for network drives. |
io.disk*.write_bytes DGAUGE , bytes per second |
Write speed for a given disk |
io.disk*.write_count DGAUGE , operations per second |
Number of writes per second for a given disk |
io.disk*.write_merged_count DGAUGE , operations per second |
Number of merged write operations per second for a given disk |
io.read_bytes DGAUGE , bytes per second |
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 per second |
Disk write speed |
io.write_count DGAUGE , operations per second |
Number of writes 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 |
Active resident memory |
mem.available_bytes DGAUGE , bytes |
RAM usage, available usage type |
mem.available_percent_bytes DGAUGE , % |
Percentage of 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.commit_limit_bytes DGAUGE , bytes |
RAM usage, commit_limit usage type |
mem.committed_as_bytes DGAUGE , bytes |
RAM usage, committed_as usage type |
mem.dirty_bytes DGAUGE , bytes |
RAM usage, dirty usage type |
mem.free_bytes DGAUGE , bytes |
Amount of free RAM available, excluding mem.buffers_bytes and mem.cached_bytes |
mem.high_free_bytes DGAUGE , bytes |
RAM usage, high_free usage type |
mem.high_total_bytes DGAUGE , bytes |
RAM usage, high_total usage type |
mem.huge_pages_free_bytes DGAUGE , bytes |
RAM usage, huge_pages_free usage type |
mem.huge_page_size_bytes DGAUGE , bytes |
RAM usage, huge_page_size usage type |
mem.huge_pages_total_bytes DGAUGE , bytes |
RAM usage, huge_pages_total usage type |
mem.inactive_bytes DGAUGE , bytes |
RAM usage, inactive usage type |
mem.low_free_bytes DGAUGE , bytes |
RAM usage, low_free usage type |
mem.low_total_bytes DGAUGE , bytes |
RAM usage, low_total usage type |
mem.mapped_bytes DGAUGE , bytes |
RAM usage, mapped usage type |
mem.page_tables_bytes DGAUGE , bytes |
RAM usage, page_tables usage type |
mem.shared_bytes DGAUGE , bytes |
RAM usage, shared usage type |
mem.slab_bytes DGAUGE , bytes |
RAM usage, slab usage type |
mem.sreclaimable_bytes DGAUGE , bytes |
RAM usage, sreclaimable usage type |
mem.sunreclaim_bytes DGAUGE , bytes |
RAM usage, sunreclaim usage type |
mem.swap_cached_bytes DGAUGE , bytes |
RAM usage, swap_cached usage type |
mem.swap_free_bytes DGAUGE , bytes |
RAM usage, swap_free usage type |
mem.swap_total_bytes DGAUGE , bytes |
RAM usage, swap_total usage type |
mem.total DGAUGE , bytes |
RAM usage, total usage type |
mem.total_bytes DGAUGE , bytes |
RAM usage, total usage type |
mem.used DGAUGE , bytes |
RAM usage, used usage type |
mem.used_bytes DGAUGE , bytes |
Amount of RAM currently used by running processes |
mem.used_percent DGAUGE , % |
Percentage of used RAM |
mem.vmalloc_chunk_bytes DGAUGE , bytes |
RAM usage, vmalloc_chunk usage type |
mem.vmalloc_total_bytes DGAUGE , bytes |
RAM usage, vmalloc_total usage type |
mem.vmalloc_used_bytes DGAUGE , bytes |
RAM usage, vmalloc_used usage type |
mem.write_back_bytes DGAUGE , bytes |
RAM usage, write_back usage type |
mem.write_back_tmp_bytes DGAUGE , bytes |
RAM usage, write_back_tmp usage type |
Network metrics
Name Type, units |
Description |
---|---|
net.bytes_recv DGAUGE , bytes per second |
Network data receive rate |
net.bytes_sent DGAUGE , bytes per second |
Network data transmit rate |
net.dropin DGAUGE , number |
Dropped receive packets |
net.dropout DGAUGE , number |
Dropped transmit packets |
net.errin DGAUGE , number |
Receive error count |
net.errout DGAUGE , number |
Transmit error count |
net.icmpmsg_intype8 DGAUGE , messages |
Number of ICMP type 8 (echo request) messages received |
net.icmpmsg_outtype0 DGAUGE , messages |
Number of ICMP type 0 (echo reply) messages sent |
net.icmp_outratelimitglobal DGAUGE , messages |
Number of ICMP messages throttled by global rate limits |
net.icmp_outratelimithost DGAUGE , messages |
Number of ICMP messages throttled by host-specific rate limits |
net.ip_outtransmits DGAUGE , packages |
Number of successfully sent IP packets |
net.packets_recv DGAUGE , packets per second |
Network packet receive rate |
net.packets_sent DGAUGE , packets per second |
Network packet transmit rate |
net.speed DGAUGE , bits per second |
Maximum network data transfer rate for this interface |
net.udplite_memerrors DGAUGE , errors |
Number of UDP-Lite out-of-memory errors |
net.udp_memerrors DGAUGE , errors |
Number of UDP out-of-memory errors |
Service metrics
Name Type, units |
Description |
---|---|
dbaas_conf.cpu_fraction DGAUGE , fractions |
Fraction of available CPU resources allocated by the service |
dbaas_conf.cpu_guarantee DGAUGE , fractions |
Guaranteed fraction of CPU resources allocated by the service |
dbaas_conf.cpu_limit DGAUGE , fractions |
Maximum allowed fraction of CPU resource usage |
dbaas_conf.hosts_ha DGAUGE , hosts |
Number of hosts set up for high availability |
dbaas_conf.hosts.total DGAUGE , hosts |
Total hosts used by the service |
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 this MySQL article 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 |
Rate of failed database connection attempts |
mysql_Binlog_cache_disk_use_rate DGAUGE , transactions per second |
Rate of transactions requiring temporary disk file writes due to binlog cache overflowing |
mysql_Binlog_cache_use_rate DGAUGE , transactions per second |
Rate of transactions using the binlog cache |
mysql_Connections_rate DGAUGE , connections per second |
Rate of database connection attempts (both successful and failed) |
mysql_Created_tmp_disk_tables_rate DGAUGE , tables per second |
Rate of temporary tables created on the disk during DB query processing |
mysql_Created_tmp_files_rate DGAUGE , files per second |
Rate of temporary DB file creation |
mysql_Created_tmp_tables_rate DGAUGE , tables per second |
Rate of temporary tables created during DB query processing |
mysql_Innodb_buffer_pool_pages_data DGAUGE , number |
Number of pages with data in the InnoDB buffer. It includes 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 |
Total pages in the InnoDB buffer |
mysql_Innodb_buffer_pool_read_requests_rate DGAUGE , operations per second |
Rate of InnoDB reads |
mysql_Innodb_buffer_pool_reads_rate DGAUGE , operations per second |
Rate of InnoDB reads requiring InnoDB to access the disk |
mysql_Innodb_checkpoint_age DGAUGE , bytes |
Size of InnoDB in-memory data before disk flush |
mysql_Innodb_checkpoint_max_age DGAUGE , bytes |
Maximum size of InnoDB in-memory data before disk flush |
mysql_Innodb_data_fsyncs_rate DGAUGE , operations per second |
Rate of fsync() operations when flushing data to the disk in InnoDB |
mysql_Innodb_data_reads_rate DGAUGE , operations per second |
Disk read rate 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 , milliseconds |
Total InnoDB row lock wait time |
mysql_Innodb_row_lock_waits_rate DGAUGE , operations per second |
Rate of InnoDB operations waiting for row locks |
mysql_Innodb_rows_deleted_rate DGAUGE , rows per second |
Rate of rows deleted from InnoDB |
mysql_Innodb_rows_inserted_rate DGAUGE , rows per second |
Rate of rows inserted in InnoDB |
mysql_Innodb_rows_read_rate DGAUGE , rows per second |
Rate of rows read from InnoDB tables |
mysql_Innodb_rows_updated_rate DGAUGE , rows per second |
Rate of 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 tables opened per unit of time |
mysql_Prepared_stmt_count DGAUGE , number |
Number of prepared statements |
mysql_Queries_rate DGAUGE , queries per second |
Number of running queries, including user queries and stored procedures, per unit of time |
mysql_Questions_rate DGAUGE , requests per second |
Number of running 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 wait time for a transaction on the replication source |
mysql_Rpl_semi_sync_master_tx_wait_time_rate DGAUGE , microseconds |
Total wait time for a transaction on 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 , requests per second |
Number of Joins that use table scans instead of indexes |
mysql_Select_full_range_join_rate DGAUGE , requests per second |
Number of Joins that search by range in a reference table |
mysql_Slow_queries_rate DGAUGE , requests per second |
Number of slow queries taking longer than long_query_time seconds, per unit of time |
mysql_Sort_range_rate DGAUGE , requests per second |
Number of sorts by range per unit of time |
mysql_Sort_rows_rate DGAUGE , requests per second |
Number of rows sorted per unit of time |
mysql_Sort_scan_rate DGAUGE , requests 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. It can be either 1 if a DB host is alive or 0 if it is not. |
mysql_is_primary DGAUGE , 0/1 |
Master host indicator. It can be either 1 if a DB host is a master or 0 if it is not. |
mysql_is_replica DGAUGE , 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.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_replication_io_thread_running DGAUGE , 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_running DGAUGE , 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_role DGAUGE , 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_writable DGAUGE , 0/1 |
Server write access. It can be either 1 if a server is available for writes or 0 if it is not. |
Other metrics
Name Type, units |
Description |
---|---|
can_read DGAUGE , 0/1 |
Read access indicator. It can be either 1 if a cluster is available for reads or 0 if it is not. |
can_write DGAUGE , 0/1 |
Write access indicator. It can be either 1 if a cluster is available for writes or 0 if it is not. |
core_dump_count DGAUGE , number |
Number of core dumps |
n_unique_users DGAUGE , users |
Number of unique users or accounts engaging with the system |