You can download your website's MySQL slow query logs from the Acquia Cloud interface 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 for an environment, complete the following steps:
- Sign in to the Acquia Cloud interface and select your application and environment.
- In the left menu, click Logs, and then click Download Logs.
- In the MySQL slow query log line, click Download.
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:
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.
For another approach to identifying resource consumption issues and bottlenecks, consider using an application monitoring tool, such as New Relic or TraceView.