Monitoring
  • PDF

Monitoring

  • PDF

Available in Classic and VPC

Monitoring supports four types of dashboards, enabling you to check various monitoring information for MySQL Server performance. 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 occurrence time and content of all logs that occur from MySQL Servers in operation
  • Query timeline: Query execution history of MySQL Servers in operation

Through these four types of dashboard, you can check the average value of MySQL Server performance information within the last year, logs within the last 60 days, and Query Timeline metrics within the last 72 hours. 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

When a certain indicator exceeds the threshold or satisfies specific conditions from the result of monitoring, you can set it up so that it is recognized as an event and the user is notified about it. For detailed usage methods for event and notification settings, please refer to 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 page

The basics of using monitoring are as follows.

database-database-5-3_main_vpc_en.png

Area Description
① Menu name Name of the menu currently being checked
② 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

Check monitoring dashboard

The 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 the average values. The following describes how to use the dashboards.

  1. From the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MySQL menus, in that order.
  2. Click the Monitoring menu.
  3. Click the MySQL Server you want to monitor from the list of DB services.
  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 see the maximum and minimum values in a graph chart: Mouse-over to the specific point on the graphic chart.
    • If you want to see the detailed graph: Double-click with the mouse on the graphic chart.
    • Print graphic chart: Click clouddbforredis_ico-03_vpc_ko.png, and then click the Print chart menu.
    • Download graphic chart to your local PC as a file: Click clouddbforredis_ico-03_vpc_ko.png, and then click 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 .pdf extension
Caution
  • In Step 5, the default value is Select all, and in Step 6, the default value is 1 day.
  • In Step 6, you can select a period of up to 1 year for DB Dashboard and OS Dashboard, up to 60 days for DB Log, and up to 72 hours for Query Timeline.
Note

From the Services > Database > Cloud DB for MySQL > 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 the descriptions for the graphic charts configured in DB dashboard.

database-database-5-3_DBcharts_vpc_en.png

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 ready 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 the MySQL binary log
Connection Aborted connection count The number of client programs terminated abnormally and the number of MySQL server connection failures

OS dashboard graphic charts

The following are the descriptions for the graphic charts configured in OS dashboard.

database-database-5-3_OScharts_vpc_en.png

Graphic chart Unit Description
CPU Usage used(%) CPU usage
Load Average - Server load
Memory Usage used(%) Memory usage
Swap used(%) Generated swap memory
Disk Used GB Disk usage
Disk I/O MB / sec Generated disk input/output per second
Network I/O MB / sec Generated network input/output 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.

database-database-5-3_eachlog_vpc_en.png

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. However, for slow query, you need to change the value of log_min_duration_statement in DB Config to a value (ms) other than the default value (-1).

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.

database-database-5-3_eachquery_vpc_en.png

Field Description
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

Was this article helpful?

What's Next