5

Mysql slow query log not tally with mysqladmin

view full story
linux-howto

http://serverfault.com – I have enabled my slow query log. So I saw the query which was taking some time then I did some indexing it improve and my slow query log is not being showing any more queies. But when I run this command mysqladmin -u root -p status Enter password: Uptime: 9395 Threads: 2 Questions: 474976 Slow queries: 13 Opens: 99 Flush tables: 1 Open tables: 54 Queries per second avg: 50.556 It is showing me slow queries:13. What does the thread n questions means here? Here is how I set my.cnf file. log-slow-queries = /var/log/mysql/mysql-slow.log long_query_time = 2 log_warnings = 2 (HowTos)