Glossary

Slow query log

What is the slow query log?

In short

The slow query log is a database log of every query that took longer than a set time, so you can find the queries that make pages slow.

Why it matters

One missing index can turn a 5 ms query into a 5 second one once a table grows. The slow log shows exactly which query, how often and how long.

How to check it on Linux

MySQL: is it on, and what counts as slow?

mysql -e "SHOW VARIABLES LIKE 'slow_query%'; SHOW VARIABLES LIKE 'long_query_time';"

What Opservo does about it

Opservo’s database insights read the MySQL slow query log, strip the values out of each query so repeats group together, and show the slowest patterns. Opservo features

Slow query log, answered

What is the slow query log?+

The slow query log is a database log of every query that took longer than a set time, so you can find the queries that make pages slow.

How do I check the slow query log on Linux?+

MySQL: is it on, and what counts as slow? mysql -e "SHOW VARIABLES LIKE 'slow_query%'; SHOW VARIABLES LIKE 'long_query_time';"

How does Opservo handle the slow query log?+

Opservo’s database insights read the MySQL slow query log, strip the values out of each query so repeats group together, and show the slowest patterns.

Related terms

Opservo watches all of this on every server and explains problems in plain English. Free for 2 servers.