Monitoring and logs in Managed Service for MySQL
How do I view cluster and host charts?
In the management console
How do I view logs?
- 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
: Slow query information; enabled iflong_query_time
is greater than0
.MYSQL_AUDIT
: Information on database connections.MYSQL_GENERAL
: Full query list. We recommend enabling it only for cluster debugging purposes in a development environment.
If you don't have the Nebius AI command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
-
View a description of the CLI command to view the logs:
ncp managed-mysql cluster list-logs --help
-
Run the command:
ncp managed-mysql cluster cluster list-logs
.
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;
Fore a detailed description of the output, please see the MySQL documentation
What other troubleshooting information is available?
A user with a PROCESS
cluster-level privilege can run the queries below:
SHOW FULL PROCESSLIST;
SHOW ENGINE INNODB STATUS;
SELECT
from theperformance_schema
and thesys
system schemas.
To grant a user the PROCESS
privilege, run the CLI command below:
ncp managed-mysql user update \
--global-permissions PROCESS <username> \
--cluster-id <cluster ID>