Monitoring

Prev Next

Available in VPC

Monitoring supports three 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. The types of dashboards provided by Monitoring are as follows:

  • DB Dashboard: Monitoring information related to the DB instance in operation
  • OS Dashboard: Monitoring information related to the operation system of the DB instance in operation
  • DB Logs: Records occurrence time and content of all logs that occur from DB instances in operation

Through these three 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 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.

Note

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 detailed usage for event and notification settings, 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 page

The basics of using Monitoring are as follows:

severless_monitoring01_ko

Component Description
① Menu name Shows the current menu name.
② Basic features Check details for Cloud DB Serverless, refresh the Monitoring page.
③ 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:

  1. In the VPC environment of the NAVER Cloud Platform console, navigate to i_menu > Services > Database > Cloud DB Serverless.
  2. Click Monitoring menu.
  3. Click the DB instance to be monitored from the list of DB clusters.
  4. Click the button for the dashboard you want to check from the page on the right.
  5. Click and select all graphic charts you want to display and check on the dashboard.
  6. From the period or search time selection box, click and select the period you want to search, or enter it directly.
  7. 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 clouddbforredis_ico-03_vpc_ko.png, followed by the Print chart menu
    • Download a graphic chart to your local PC as a file: Click clouddbforredis_ico-03_vpc_ko.png, 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: Image file with the .svg extension
      • Download CSV: Document file with the .csv extension
Caution
  • In step 5, the default value is select all, and in step 6, the default is the last 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.
Note

From the Services > Database > Cloud DB Serverless > DB server menu, click and select the server you want, and then click the [Monitoring] button 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:

severless_monitoring05_ko

Graphic 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
  • 0: Replication stop
  • 1: Replication in progress
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 graphic charts

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

severless_monitoring06_ko

Graphic 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 graphic charts

The following are the descriptions for the graphic charts configured in DB Logs:

severless_monitoring07_ko

Field Description
Event occurrence time Time when DB Log occurred
Log content DB Log content
Note

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.