Monitoring and logs in Managed Service for MySQL®

Written by

Updated at December 10, 2025

How do I view cluster and host charts?

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

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

How do I view logs?

Management console

CLI

Go to the cluster page and open the Logs tab.
At the top of the page, select a log:
- MYSQL_ERROR: Primary MySQL® log with error messages, which is always enabled.
- MYSQL_SLOW_QUERY: Information on slow queries. It is enabled if long_query_time is greater than 0.
- MYSQL_AUDIT: Information on database connections.
- MYSQL_GENERAL: Full query list. We recommend enabling it only for cluster debugging in a development environment.

If you do not have the Yandex Cloud CLI installed yet, install and initialize it.

By default, the CLI uses the folder specified when creating the profile. To change the default folder, use the yc config set folder-id <folder_ID> command. You can also set a different folder for any specific command using the --folder-name or --folder-id parameter.

See the description of the CLI command for viewing logs:
```
yc managed-mysql cluster list-logs --help
```
Run the yc managed-mysql cluster cluster list-logs command.

What is the retention period for logs?

Cluster logs are stored for 30 days.

How do I view current queries?

To view the current user’s queries, run:

SHOW PROCESSLIST;

For a detailed description of the query result, see this MySQL® article.

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 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?

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

When selecting a metric, set service 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?

Create an alert for 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. Their recommended values are as follows:

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

Thresholds values must be specified in bytes. For example, the recommended values for a 100 GB disk are as follows:

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

Monitoring and logs in Managed Service for MySQL®

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

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

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

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

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

How do I set up alerts?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 set up an alert that triggers as soon as a certain percentage of disk space has been used up?

Was the article helpful?