Monitoring and logs in Managed Service for MySQL®

Written by

Updated at June 9, 2025

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?

Management console

CLI

Go to the cluster page and click the Logs tab.
At the top of the page, select an available log:
- MYSQL_ERROR: Primary MySQL® log containing error messages. Always enabled.
- MYSQL_SLOW_QUERY: Information on slow queries. 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 purposes in the 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.

View a description of the CLI command to view the 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 output, see the MySQL® documentation.

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?

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?

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%)

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?