Slow SQL Query Logging
This feature is only available with PHP Extension 5.1.8+ and Daemon 1.6.8+. |
The Slow SQL Log feature in Tideways is similar to MySQL’s, and other databases, slow query logfiles, but extended by application context information such as Stacktrace, which URL and transaction the query occurred on and others. In addition Slow SQL queries are grouped by similarity, so that you don’t get notified about the same Slow SQL over and over again.
SQL slow log is enabled on all current plans and licenses, but the bigger your license the lower you can set the possible query duration threshold.
Plan | Minimal Threshold |
---|---|
Pro |
100 ms |
Standard |
100 ms |
Basic |
250 ms |
Flex |
1s |
Lite (Legacy) |
Not available |
Hosting Lite (Legacy) |
Not available |
By default the slow SQL threshold is configured at 1 second in the PHP extension. To change the slow SQL logging threshold to your need, reduce the INI setting from its default of 1 seconds to a lower value:
tideways.sql_long_query_time_ms=250
The example above means that every query slower than 250ms is considered a slow query and appears in the slow query log.

Currently, slow SQL queries do not trigger notifications configured for the "New Error/Exception" notification type. However, you can configure notifactions to be sent when a Slow SQL query occurs. |