A MySQL log that records queries taking longer than long_query_time seconds. Analysing the slow query log with tools like pt-query-digest is a fundamental DBA practice for finding performance bottlenecks.
