mysqltuner.pl returns [OK] Slow queries: 0% (138/682K) I want to see those 138 queries. In my my.cnf I have slow_query_log = 1 log_slow_queries ="/var/log/mysql-slow.log" long_query_time = 1 however if I go to /var/log there is no mysql-slow.log file any ideas?
Can u try to make an empty file at that location and chmod it to 0777. Restart mysql and test wih a known slow query. Usually ones that run on unindexed columns