Skip to main content
View logs of slow queries in MySQL semi-sync cloud databases
Last update:

View logs of slow queries in MySQL semi-sync cloud databases

In MySQL semi-sync cloud databases, you can see the logs of slow queries and download them.

Slow queries are database queries that take longer than the time specified in the parameter long_query_time. The default value is long_query_time equals 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 control panel go to Cloud platform → Databases.
  2. Open the cluster page → tab Logs.
  3. Enter the time period (no more than two weeks) for which you want to display the logs.
  4. Mark the cluster and database nodes for which you want to collect logs.
  5. The list displays the first 200 requests. To view all requests for a specified time period, tap Download logs.