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 related to MySQL Servers in operation
- OS Dashboard: Monitoring information related to the operating system of MySQL Servers in operation
- DB Logs: Records of occurrence time and content of all logs that occur from MySQL Servers in operation
- Query Timeline: Query execution history of MySQL Servers in operation
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.
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:
| Component | Description |
|---|---|
| ① Menu name | Current menu name. |
| ② Basic features | View Cloud DB for MySQL details and refresh the Monitoring page. |
| ③ 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:
- In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > All Services > Database > Cloud DB for MySQL.
- Click the Monitoring menu.
- From the DB Service list, click the MySQL Server you want to monitor.
- Click the button for the dashboard you want to check from the interface on the right.
- Click and select all graph charts you want to display and check on the dashboard.
- Select a period from the period or query time range selection box, or enter the desired period manually.
- Check the results from the dashboard.
- If you want to see the precise indicator value of a specific point on the graphic chart: Mouse-over to the specific point on the graphic chart
- If you want to check the maximum value and the minimum value on a graphic chart: Mouse-over to the graphic chart
- To see the detailed graph, double-click the graphic chart.
- Print graphic chart: Click
, followed by Print chart - Download a graphic chart to your local PC as a file: Click , followed by the file extension menu for the file you want to download
- Download PNG image: Image file with the .png extension
- Download JPEG image: Image file with the .jpeg extension
- Download PDF document: Document file with the .pdf extension
- Download SVG vector image: Vector image file with the .svg extension
- Download CSV: Document file with the .csv extension
- 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.
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:
| 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 | - |
|
| InnoDB Buffer Pool | GB | Page size allocated to the buffer pool
|
| Connection Percent (%) | used | MySQL connection usage rate based on max_connections |
| Failover Status | - |
|
OS Dashboard graph charts
The following are some descriptions for the graph charts configured in OS Dashboard:
| 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:
| Field | Description |
|---|---|
| Event time | Time of DB log occurrence |
| Log content | DB log details |
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:
| 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 of query occurrence |
| Status | Session process status |