Monitoring and logs in Managed Service for MySQL®

• How do I view cluster and host charts?

• How do I view logs?

• How do I view current queries?

• What other diagnostic information is available?

• How do I set up alerts?

• How do I set up an alert that triggers as soon as a certain percentage of disk space has been used up?

How do I view cluster and host charts?How do I view cluster and host charts?

In the management console, go to the cluster page. To view cluster charts, go to Monitoring. To find individual host charts, go to Hosts → Monitoring.

To view charts in Yandex Monitoring, on the home page, select the Managed Service for MySQL service dashboard. To view individual metrics, go to Metrics and set the service parameter to Managed Service for MySQL.

How do I view logs?How do I view logs?

What is the retention period for logs?What is the retention period for logs?

Cluster logs are stored for 30 days.

How do I view current queries?How do I view current queries?

To view the current user's queries, run:

SHOW PROCESSLIST;

For a detailed description of the output, see the MySQL® documentation.

What other diagnostic information is available?What other diagnostic information is available?

A user with the PROCESS cluster-level privilege can run the following queries:

• SHOW FULL PROCESSLIST
• SHOW ENGINE INNODB STATUS
• SELECT from the performance_schema and the sys system schemas.

To grant a user the PROCESS privilege, run this CLI command:

yc managed-mysql user update \
    --global-permissions PROCESS <username> \
    --cluster-id <cluster_ID>

How do I set up alerts?How do I set up alerts?

Use Yandex Monitoring. For the setup guide, see Creating an alert.

When selecting a metric, set the service parameter to Managed Service for MySQL.

How do I set up an alert that triggers as soon as a certain percentage of disk space has been used up?How do I set up an alert that triggers as soon as a certain percentage of disk space has been used up?

Create an alert with the disk.used_bytes metric in Yandex Monitoring. This metric shows the disk space usage in the Managed Service for MySQL® cluster.

For disk.used_bytes, use notification thresholds. The recommended values are as follows:

• Alarm: 90% of the disk space
• Warning: 80% of the disk space

Thresholds are set in bytes only. For example, the recommended values for a 100 GB disk are as follows:

• Alarm: 96636764160 bytes (90%)
• Warning: 85899345920 bytes (80%)