Viewing MySQL cluster logs
Managed Service for MySQL allows you to get a cluster log snippet for the selected period and view logs in real time.
Note
Cluster logs are kept for 30 days.
Getting a cluster log
- Go to the folder page and select Managed Service for MySQL.
- Click the cluster name and select the
Logs tab. - Specify the time period for logs to be displayed: enter it manually or select in the calendar by clicking the date input field.
- Select the type of events to display. By default, the
MYSQL_ERROR
type is used. - Select the hosts and logging level in the drop-down lists next to the date input field, if required.
A list of log entries for the selected time period will be displayed. To view detailed information about an event, click the respective entry in the list.
If there are too many records and not all of them are displayed, click the Load more link at the end of the list.
If you do not have the Yandex Cloud 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 cluster logs:
yc managed-mysql cluster list-logs --help
-
Run the following command to get cluster logs (our example does not contain a complete list of available parameters):
yc managed-mysql cluster list-logs <cluster_name_or_ID> \ --limit <record_number_limit> \ --format <output_format> \ --service-type <service_type> \ --columns <list_of_columns> \ --filter <filter_settings> \ --since <left_boundary_of_time_range> \ --until <right_boundary_of_time_range>
Where:
-
--limit
: limits on the number of entries to output. -
--format
: Format for log entries (text
,yaml
,json
, orjson-rest
). -
--service-type
: Service type to display records for (mysql-error
,mysql-general
,mysql-slow-query
, ormysql-audit
). -
--columns
: List of columns with output data:hostname
: Host name.id
: Query ID.message
: Message output by the service.status
: Message status, such asNote
orWarning
.
Note
The example only contains the main columns. A list of columns to output depends on the selected
--service-type
.To output separate columns, provide the
--format
key and specify the output format (yaml
,json
, orjson-rest
). Columns are not supported fortext
output format that is set by default. -
--filter
: record filter settings, for example,message.hostname='node1.mdb.yandexcloud.net'
. -
--since
: Left boundary of a time range in RFC-3339 ,HH:MM:SS
format or a time interval relative to the current time. Examples:2006-01-02T15:04:05Z
,15:04:05
,2h
,3h30m ago
. -
--until
: right boundary of a time range, the format is similar to that of--since
.
-
You can request the cluster name and ID with a list of clusters in the folder.
To get a cluster log, use the listLogs REST API method for the Cluster resource or the ClusterService/ListLogs gRPC API call, and provide in the request:
-
Cluster ID in the
clusterId
parameter.To find out the cluster ID, get a list of clusters in the folder.
-
Log type, in the
serviceType
parameter:-
MYSQL_ERROR
: Log of errors related to starting, running, and stopping MySQL instances. -
MYSQL_GENERAL
: Log of client connections and queries.This log is disabled by default. To enable this log, change the value of the General log setting when updating the MySQL settings.
-
MYSQL_SLOW_QUERY
: Slow query log.This log is disabled by default. To enable the log, change the value of the Slow query log setting when updating the MySQL settings. For details, see also the Log slow filter, Log slow rate limit, Log slow rate type, Log slow sp statements, and Slow query log always write time settings.
-
MYSQL_AUDIT
: Audit log.This log is disabled by default. To enable the log, change the value of the Audit log setting when updating the MySQL settings.
-
Getting a cluster log stream
This method allows you to get cluster logs in real time.
If you do not have the Yandex Cloud 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.
To view cluster logs as they become available, run this command:
yc managed-mysql cluster list-logs <cluster_name_or_ID> --follow
You can request the cluster name and ID with a list of clusters in the folder.
To get a cluster log stream, use the streamLogs REST API method for the Cluster resource or the ClusterService/StreamLogs gRPC API call, and provide in the request:
-
Cluster ID in the
clusterId
parameter.To find out the cluster ID, get a list of clusters in the folder.
-
Log type, in the
serviceType
parameter:-
MYSQL_ERROR
: Log of errors related to starting, running, and stopping MySQL instances. -
MYSQL_GENERAL
: Log of client connections and queries.This log is disabled by default. To enable this log, change the value of the General log setting when updating the MySQL settings.
-
MYSQL_SLOW_QUERY
: Slow query log.This log is disabled by default. To enable the log, change the value of the Slow query log setting when updating the MySQL settings. For details, see also the Log slow filter, Log slow rate limit, Log slow rate type, Log slow sp statements, and Slow query log always write time settings.
-
MYSQL_AUDIT
: Audit log.This log is disabled by default. To enable the log, change the value of the Audit log setting when updating the MySQL settings.
-