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.