Available in VPC
Monitoring supports four types of dashboards for you to check various monitoring information on MySQL Server performance and history. Monitoring is a service included in NAVER Cloud Platform's Cloud DB for MySQL so it can be used without additional charges. The types of dashboards provided by Monitoring are as follows:
- 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
You can check the average values of MySQL Server performance information within the recent one year, log within the recent 60 days, and the Query Timeline indicators within the recent 72 hours through the four types of dashboards. Each dashboard is configured with various graphic charts. You can utilize these charts in your business by printing specific graphic charts or downloading them to your local PC as files using various extensions.
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 detailed usage for event and notification settings, see Event.
Since the intuitive search and management for the MySQL performance information is available without additional charges, if you wish to operate servers stably in an environment without a professional database manager, then we recommend utilizing the monitoring indicators provided through the dashboard.
Monitoring interface
The basics of using Monitoring are as follows:
| Component | Description |
|---|---|
| ① Menu name | Shows the current menu name. |
| ② Basic features | Check details for Cloud DB for MySQL, refresh the Monitoring page. |
| ③ DB Service list | The list of DB Services in operation and the list of MySQL Servers by service |
| ④ Dashboard | DB Dashboard, OS Dashboard, DB Logs, and Query Timeline of the selected server from the MySQL Server list |
View Monitoring dashboards
Dashboards provided by Monitoring consist of multiple graphic 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 > Services > Database > Cloud DB for MySQL.
- Click the Monitoring menu.
- Click the MySQL Server to monitor from the list of DB Services.
- Click the button for the dashboard you want to check from the page on the right.
- Click and select all graphic charts you want to display and check on the dashboard.
- From the period or search time selection box, click and select the period you want to search, or enter it directly.
- 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 value is select all, and in step 6, the default is the last 1 hour.
- In step 6, you can select the period from up to 1 year for DB Dashboard and OS Dashboard, from up to 60 days for DB Log, and from up to 72 hours for Query Timeline.
From the Menu > **Services **> **Database ** > **Cloud DB for MySQL ** > DB server menu, click and select the server you want, and then click [Monitoring] to go directly to the page in Step 4.
DB Dashboard graphic charts
The following are some descriptions for the graphic charts configured in DB Dashboard:
| Graphic chart | Unit | Description |
|---|---|---|
| Connections | connection count | Number of DB access 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 time |
| Slow Query | total / min | Number of queries that run longer than the value specified in long_query_time (the default: 1 second) |
| Row Accesses | avg / sec | The amount off Read and Write Queries per second for the row of the data page |
| Temp Tablespace | GB | The size of the Temporary Tablespace Data file used internally in the DB Server |
| Binary Log Total Size | GB | Overall size of MySQL Binary Log |
| Connection Aborted | connection count | The number of abnormal ends of the client program and the number of failures of MySQL Server connection |
| 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 graphic charts
The following are some descriptions for the graphic charts configured in OS Dashboard:
| Graphic chart | Unit | Description |
|---|---|---|
| CPU Usage(%) | used | CPU usage |
| Load Average | - | Server load |
| Memory Usage(%) | used | Memory usage |
| Swap(%) | used | Swap memory volume |
| Disk Used | GB | Disk usage |
| Disk I/O | MB/sec | Disk Input/Output volume per second |
| Network I/O | MB/sec | Network Input/Output volume per second |
| Free Memory | GB | Free memory space (sum of free space and buffer cache) |
| Free Storage Space | GB | Free storage space |
DB Logs graphic charts
The following are the descriptions for the graphic charts configured in DB Logs:
| Field | Description |
|---|---|
| Event occurrence time | Time when DB Log occurred |
| Log content | DB Log content |
In DB Logs, you can check the Error log, Slow log, General log and Audit log of the MySQL Server in operation.
- The General Log is not basically collected. (You can view it after adding the general_log settings in DB Config Management)
- The Audit Log is not basically collected. (You can view it after setting the Audit Plugin in View Details of DB Service)
Query Timeline graphic charts
The graphic charts configured in Query Timeline displays the Query Timeline of 5 minutes before/after the selected search time. The detailed descriptions for the charts are as follows:
| Field | Description |
|---|---|
| LogTime | View time |
| PID | Process ID |
| User | User name of the logged-in user |
| Host | IP address of the connected Client |
| DB | Name of the connected DB |
| Command | Executed command |
| Time | Time when the Query occurred |
| Status | Session process status |