Skip to main content

Slow Query Log

Learn Slow Query Log (MySQL Performance Tuning, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction The slow query log records every statement that runs longer than long_query_time seconds (default 10). It is the first tool for finding which queries hurt, because it records real workload, not guesses.

More lessons in MySQL Performance Tuning