Monitoring

Prev Next

Available in Classic

Monitoring provides four types of dashboards that let you view a wide range of monitoring data related to MySQL Server performance and history. Monitoring is included with Cloud DB for MySQL on the NAVER Cloud Platform and is available at no additional cost. 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 four 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 file formats for effective use.

Note

You can configure the system to recognize events and notify you with alerts when certain metrics exceed thresholds or meet specific conditions. 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 following explains the basic components of Monitoring:

database-database-5-3_main_vpc_ko.png

Component Description
① Menu name Show the current menu name.
② 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.

The dashboards provided by Monitoring consist of multiple graphical charts. You can display only the information you want for each server to review it intuitively. The dashboard collects data every minute and displays averaged values. To use the dashboard:

  1. In the Classic environment of the NAVER Cloud Platform console, navigate to i_menu > Services > Database > Cloud DB for MySQL.
  2. Click Monitoring.
  3. From the DB Service list, click the MySQL server you want to monitor.
  4. On the right interface, click the dashboard button you want to view.
  5. Select all graph charts you want to display on the dashboard.
  6. Select a period from the date or time range selection box, or enter the desired period manually.
  7. Review the results on the dashboard.
    • To view the exact metric value at a specific point in time: Hover over the desired 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 to click Print chart.
    • Download a graph chart to your local PC: Select clouddbforredis_ico-03_vpc_ko.png and click the file extension menu to download.
      • Download PNG image: An image file in PNG format.
      • Download JPEG image: An image file in JPEG format.
      • Download PDF document: A document file in PDF format.
      • Download SVG vector image: A vector image file in SVG format.
      • Download CSV: A document file in CSV format.
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

From i_menu > Services > Database > Cloud DB for MySQL > DB Server , select the desired server, then click [Monitoring] to go directly to the interface in step 4.

DB Dashboard graph charts

The following describes the graph charts that make up the 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.

OS Dashboard graph charts

The following describes the graph charts that make up the 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 describes the graph charts that make up DB Logs:

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:

database-database-5-3_eachquery

Field Description
LogTime Query time
PID Process ID
User Logged-in user name
Host IP address of the connected client
DB Connected database name
Command Executed command
Time Time when the query occurred
Status Session process status