Available in VPC
Monitoring supports 3 types of dashboards for you to check various kinds of monitoring information on DB instance performance and history. Monitoring is a service included in NAVER Cloud Platform's Cloud DB Serverless so it can be used without additional charges. Monitoring provides the following dashboards:
- DB dashboard: Monitoring information related to DB Instance in operation
- OS Dashboard: Monitoring information related to the operating system of the DB Instance in operation
- DB logs: Records the occurrence time and content of all logs that occur from the DB Instance in operation
Through these 3 types of dashboard, you can check the average value of performance of the DB instance in the last year as well as the log for the last 60 days. 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 automatically when monitoring results show that a certain indicator has exceeded its threshold or met specific conditions by having them recognized as events. For details about configuring events and notifications, see Event.
Since intuitive view and management for the DB instance performance information is available, if you wish to operate the database stably in an environment without a professional database manager, we recommend utilizing the monitoring indicators provided through the dashboard.
Monitoring interface
The basics of using Monitoring are as follows:
| Component | Description |
|---|---|
| ① Menu name | Current menu name. |
| ② Basic features | Check details for Cloud DB Serverless, refresh the Monitoring interface. |
| ③ List of DB clusters | List of operating DB clusters and DB instances within the clusters. |
| ④ Dashboard | DB dashboard, OS dashboard, and DB logs of the selected DB instance from the DB cluster list |
View Monitoring dashboards
Dashboards provided by Monitoring consist of multiple graphic charts. A user can view needed information by selecting a \certain DB instance. 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 Serverless.
- Click the Monitoring menu.
- Click the DB instance to be monitored from the list of DB clusters.
- 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, the period is up to 1 year for DB Dashboard and OS Dashboard, and for DB Log, it can be selected up to 60 days.
From the Services > Database > Cloud DB Serverless > DB Server menu, click and select the server you want, and then 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 |
|---|---|---|
| MySQL Select | query/sec | Number of MySQL select queries |
| MySQL Insert | query/sec | Number of MySQL insert queries |
| MySQL Update | query/sec | Number of MySQL update queries |
| MySQL Delete | query/sec | Number of MySQL delete queries |
| MySQL Replace | query/sec | Number of MySQL replace queries |
| MySQL Query Cache | query/sec | Number of MySQL query caches |
| MySQL Call | query/sec | Number of MySQL stored procedure calls |
| MySQL Total Connections | num | Number of MySQL access sessions |
| MySQL Running Connections | num | Number of MySQL sessions in operation |
| MySQL Slow Queries | num/min | Number of queries that run longer than the value specified in MySQL long_query_time (the default: 1 second) |
| MySQL Read Requests Per Second | query/sec | Number of MySQL read requests |
| MySQL Write Requests Per Second | query/sec | Number of MySQL write requests |
| MySQL Replication Status | num | MySQL Replication status
|
| MySQL Replication Delay | sec | MySQL Replication delay time |
| MySQL Aborted Connections | count/min | Number of abnormal client login terminations |
| MySQL Aborted Clients | count/min | Number of abnormal client query terminations during execution |
| MySQL InnoDB Buffer Pool Size(GB) | GB | Page size allocated to the buffer pool |
OS Dashboard graph charts
The following are some descriptions for the graph charts configured in OS Dashboard:
| Graph chart | Unit | Description |
|---|---|---|
| CPU Total | core/sec | CPU usage. |
| Memory Used | bytes | Memory usage. |
| Network Transmitted | bytes/sec | Network Output volume |
| Network Received | bytes/sec | Network Input volume |
| Disk Read | bytes/sec | Disk read volume |
| Disk Write | bytes/sec | Disk write volume |
| Unit Usage | unit | Unit usage |
| Minimum Unit | unit | Max. Unit |
| Maximum Unit | unit | Min. Unit |
| Unit Utilization | % | Unit utilization rate |
| Disk MySQL Used | bytes | MySQL Disk usage |
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. |
In DB Logs, you can check the Error log, Slow log, and General log of the MySQL Server in operation.
The General Log is not basically collected. In DB Config management, after changing the general_log setting, collection and retrieval are available.