Downloading your slow query log

You can download your website's MySQL slow query logs from the Cloud > Logs page. By analyzing the slow query log, you can identify database-related issues that may be impairing your website's performance. Slow queries are database queries that took longer than one second.

To download the MySQL slow query log, complete the following steps:

  1. Sign in to Acquia.
  2. Go to the Cloud > Logs page for your website, and then select the environment for which you want to download the log.
  3. Click Download logs.
  4. In the MySQL slow query log line for your environment, click Download.

Download the MySQL slow query log

Acquia Cloud generates the slow query log. The slow query log includes data generated since the last time the MySQL log was rotated, which occurs daily. It should begin downloading as soon as it is generated, with a file name of the form: slow_query_log_[sitename]_[timestamp:1349352001].sql

A slow query log is generated on demand; unlike other logs on the Acquia platform, slow query logs are not retained and can be accessed only by using the Download button.

You can examine the slow query log using tools like Percona Tools pt-query-digest and the MySQL EXPLAIN statement. For more information, see Tools for parsing a slow query log.

For another approach to identifying resource consumption issues and bottlenecks, consider using New Relic, which is available to all Acquia subscribers at no additional cost. Read more about using New Relic.

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
By submitting this form, you accept the Mollom privacy policy.

Contact supportStill need assistance? Contact Acquia Support