Slow SQL 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 own 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 Sloe 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

This example means every query slower than 250ms is considered slow query and appears in the log.

image

You can configure notifactions to be sent when a Slow SQL query occurs.

Still need help? Email [email protected]