View logs of slow queries in MySQL sync cloud databases

View logs of slow queries in MySQL sync cloud databases

In MySQL sync cloud databases, you can view logs of slow queries and download them.

Slow queries are database queries that take longer than the time specified in the long_query_time parameter. The default value of long_query_time is two seconds — if necessary, you can change the value in the DBMS settings.

In the logs you can see what the slow request looked like, its duration, when and which user made it.

Queries can be filtered by time interval, cluster nodes, and databases.

1. In the Control panel, on the top menu, click Products and select Cloud Databases.
2. Open the Active tab.
3. Open the cluster page → Logs tab.
4. Enter the time period (no more than two weeks) for which you want to display the logs.
5. Mark the cluster and database nodes for which you want to collect logs.
6. The first 200 requests are displayed in the list. To view all requests for a specified time period, click Download Logs.