Slow SQL Query Logging

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.

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:

The example above means that every query slower than 250ms is considered a slow query and appears in the slow query log.