Cloud DB for MySQL (VPC) metrics

Prev Next

Available in VPC

This section provides information on the performance and operational metrics of the Cloud DB for MySQL service. Performance/operational metrics can be managed in an integrated manner through NAVER Cloud Platform's Cloud Insight service and can be used for various monitoring purposes.

Note

See the Cloud Insight API Guide for information on how to use performance/operational metrics for monitoring.

Basic information

The following is the basic information of the Cloud DB for MySQL service for using performance/operational metrics.

  • Product name (prodName)
    • System/Cloud DB for MySQL(VPC)
  • Product key (cw_key)
    • 470208511578607616

Performance/operation metrics

The performance/operational metrics of the Cloud DB for MySQL service are as follows.

  • Metric
    Metric name Data type Unit Metric type Description Interval Aggregation
    mysql_select FLOAT query/sec Basic, Default mysql select qps Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_insert FLOAT query/sec Basic, Default mysql insert qps Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_update FLOAT query/sec Basic, Default mysql update qps Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_delete FLOAT query/sec Basic, Default mysql delete qps Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_replace FLOAT query/sec Basic, Default mysql replace qps Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_qcache FLOAT query/sec Basic, Default mysql query cache qps Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_call FLOAT query/sec Basic, Default mysql procedure call qps Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_totalconn FLOAT num Basic, Default mysql total connection Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_runconn FLOAT num Basic, Default mysql running threads Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_slow FLOAT num/min Basic, Default mysql slow queries Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_user FLOAT % Basic CPU user Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_sys FLOAT % Basic CPU kernel Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_iowait FLOAT % Basic CPU iowaitd Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_total FLOAT % Basic CPU Total Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_load_1 FLOAT % Basic Load avg 1min Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_load_5 FLOAT % Basic Load avg 5min Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_load_15 FLOAT % Basic Load avg 15min Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_mysql_used FLOAT bytes Basic mysql disk used Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mem_pct FLOAT % Basic Memory used Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    nic_tx FLOAT MB Basic nic send Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    nic_rx FLOAT MB Basic nic receive Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    nic_total FLOAT MB Basic nic total Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    swap_pct FLOAT % Basic Swap used Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_read FLOAT KB/sec Basic Disk I/O Read bytes Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_write FLOAT KB/sec Basic Disk I/O Write bytes Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_total FLOAT KB/sec Basic Disk I/O Total Byte Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_pct FLOAT % Basic CPU used Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_rqps FLOAT query/sec Basic mysql row read Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_wqps FLOAT query/sec Basic mysql row write Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_slaverun FLOAT num Basic mysql replication stop Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_slavedelay FLOAT sec Basic mysql replication delay Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_rrps FLOAT query/sec Basic read rowaccess Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_wrps FLOAT query/sec Basic write rowaccess Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_ibtmp FLOAT MB Basic InnoDB Temporary Size Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_active FLOAT num Basic Could not connect (0 or 100) Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_mysql_free FLOAT KB Basic Free StorageSpace Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mem_free FLOAT KB Basic Free Memory Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mysql_total_binlog_size FLOAT GB Basic Total Binary Log Size Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    aborted_connects FLOAT count/min Basic The number of failed attempts to connect to the MySQL server. Min1,Min5,Min30,Hour2,Day1 AVG,MIN,MAX,COUNT,SUM
    aborted_clients FLOAT count/min Basic The number of connections that were aborted because the client died without closing the connection properly. ​ Min1,Min5,Min30,Hour2,Day1 AVG,MIN,MAX,COUNT,SUM
    innodb_buffer_pool_total FLOAT bytes Basic Total size of buffer pool Min1,Min5,Min30,Hour2,Day1 AVG,MIN,MAX,COUNT,SUM
    innodb_buffer_pool_used FLOAT bytes Basic Size of buffer pool(used) Min1,Min5,Min30,Hour2,Day1 AVG,MIN,MAX,COUNT,SUM
    innodb_buffer_pool_modified FLOAT bytes Basic Size of buffer pool(modified) Min1,Min5,Min30,Hour2,Day1 AVG,MIN,MAX,COUNT,SUM
    innodb_buffer_pool_old FLOAT bytes Basic Size of buffer pool(old) Min1,Min5,Min30,Hour2,Day1 AVG,MIN,MAX,COUNT,SUM
  • Dimension
    Dimension name Data type
    instanceNo STRING