Documentation Index

Fetch the complete documentation index at: https://guide.ncloud-docs.com/llms.txt

Use this file to discover all available pages before exploring further.

Monitoring

Prev Next

Available in VPC

Monitoring provides 4 types of dashboards that let you view a wide range of monitoring data related to MySQL Server performance and history. Monitoring is included in NAVER Cloud Platform's Cloud DB for MySQL and is a free service. Monitoring provides the following dashboards:

  • DB Dashboard: Monitoring information for running MySQL Servers
  • OS Dashboard: Operation system for running MySQL Servers
  • DB logs: Timestamps and details of all logs generated by running MySQL Servers
  • Query timeline: Query execution history for running MySQL Servers

With these 4 dashboards, you can view average MySQL Server performance data from the past year, logs from the past 60 days, and query timeline metrics from the past 72 hours. Each dashboard consists of multiple graph charts. You can print specific charts or download them to your local PC in various extensions for effective use.

Note

You can set the user to be notified when monitoring results show that a certain metric has exceeded its threshold or met specific conditions by having them recognized as events. For details about configuring events and notifications, see Event.

Because you can intuitively view and manage MySQL performance data at no additional cost, we recommend using the dashboard metrics to operate servers reliably in environments without dedicated database administrators.

Monitoring interface

The basics of using Monitoring are as follows:

database-database-5-3_main_vpc_ko.png

Component Description
① Menu name The name of the current menu.
② Basic features View Cloud DB for MySQL details and refresh the Monitoring interface.
③ DB service list List running DB services and MySQL Servers by service.
④ Dashboard DB Dashboard, OS Dashboard, DB logs, and query timeline for the selected server from MySQL Server list.

View Monitoring dashboards

Dashboards provided by Monitoring consist of multiple graph charts. You can display and intuitively check only the information you need from the dashboard of each server. The information shown in the dashboard is collected every minute to be displayed, but it shows only the average values. To use dashboards:

  1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > All services > Database > Cloud DB for MySQL.
  2. Click the Monitoring menu.
  3. From the DB service list, click the MySQL Server you want to monitor.
  4. Click the button for the dashboard you want to check from the interface on the right.
  5. Click and select all graph charts you want to display and check on the dashboard.
  6. Select a period from the date or query time range selection box, or enter the desired period manually.
  7. Check the results from the dashboard.
    • To view the exact metric value at a specific point in time: Hover over a specific point on the graph chart.
    • To view the maximum and minimum values: Hover over the graph chart.
    • To view a detailed graph: Double-click the graph chart.
    • Print a graph chart: Select clouddbforredis_ico-03_vpc_ko.png, then click Print chart.
    • Download a graph chart to your local PC: Select clouddbforredis_ico-03_vpc_ko.png, then click the file extension menu to download.
      • Download PNG image: An image file with a PNG extension.
      • Download JPEG image: An image file with a JPEG extension.
      • Download PDF document: A document file with a PDF extension.
      • Download SVG vector image: A vector image file with an SVG extension.
      • Download CSV: A document file with a CSV extension.
Caution
  • In step 5, the default setting is select all, and in step 6, the default time range is the past 1 hour.
  • In step 6, you can select up to 1 year for the DB Dashboard and OS Dashboard, up to 60 days for DB logs, and up to 72 hours for the query timeline.
Note

Navigate to Menu > All services > Database > Cloud DB for MySQL > DB Server, select the desired server, and click [Monitoring] to go directly to the interface in Step 4.

DB Dashboard graph charts

The following are some descriptions for the graph charts configured in DB Dashboard:

database-database-5-3_DBcharts

Graph chart Unit Description
Connections connection count Number of database connection sessions
Database Activity Average activity/sec select, insert, update, replace, delete, call, qcache_hits activity information
Write QPS Average activity/sec Number of write queries per second
Read QPS Average activity/sec Number of read queries per second
Replication Delay(Standby Master, Slave) sec Replication delay
Slow Query total/min Number of queries running longer than the value specified in long_query_time (default: 1 second)
Row Accesses avg / sec Number of read and write queries per second on rows in data pages
Temp Tablespace GB Size of the temporary tablespace data file used internally by the database server
Binary Log Total Size GB Total size of MySQL binary logs
Connection Aborted connection count Number of abnormal client terminations and failed MySQL server connections
Replication Status -
  • Replication status is normal when the value is 1.
  • The graph is available only on standby master or slave servers.
  • Because it is not a default metric, you can enable it manually.
InnoDB Buffer Pool GB Page size allocated to the buffer pool
  • Total: Total size of buffer pool
  • Used: Size of buffer pool in use
  • Modified: modified Page size of buffer pool
  • Old: Size of OLD LRU Page in buffer pool
Connection Percent (%) used MySQL connection usage rate based on max_connections
Failover Status -
  • A value of 1 indicates that a failover has occurred.
  • Displayed as 1 only on the server that became the Master after the failover.

OS Dashboard graph charts

The following are some descriptions for the graph charts configured in OS Dashboard:

database-database-5-3_OScharts

Graph chart Unit Description
CPU Usage(%) used CPU usage.
Load Average - Server load.
Memory Usage(%) used Memory usage.
Swap(%) used Swap memory usage.
Disk Used GB Disk usage.
Disk I/O MB/sec Disk input/output per second.
Network I/O MB/sec Network input/output per second.
Free Memory GB Available memory (the sum of free space and buffer cache)
Free Storage Space GB Available storage space

DB logs graph charts

The following are the descriptions for the graph charts configured in DB logs:

clouddbformysql_dblogs_chart

database-database-5-3_eachlog_vpc_ko.png

Field Description
Event time Time when the DB log occurred.
Log content DB log details.
Note

DB logs lets you view error logs, slow logs, general logs, and audit logs for running MySQL Servers.

  • General logs are not collected by default. (You can view them after enabling general_log in DB Config management.)
  • Audit logs are not collected by default. (You can view them after enabling the audit plugin in DB service details.)

Query timeline graph charts

The query timeline graph charts display the query timeline for 5 minutes before and after the selected time. The following describes the chart fields:

clouddbformysql_querytime_chart

database-database-5-3_eachquery

Field Description
LogTime Query time
PID Process ID.
User User name of the logged-in user.
Host IP address of the connected client
DB Connected DB name
Command Executed command
Time Time when the query occurred
Status Session process status.
Business Registration Number: 129-86-31394 E-commerce Permit Number:No. 2009-GyeonggiSeongnam-0510
CEO: Kim Yuwon Address: NAVER Green Factory 17th–26th Floors, Buljeong-ro 6, Bundang-gu, Seongnam-si, Gyeonggi-do 13561, Republic of Korea. Customer Support Number: 1544-5876
© NAVER Cloud Corp. All Rights Reserved.