- - Code, Content, and Presentation
- -- Databases
- ---- Fully-indexed Fast Query appearing in the MySQL Slow Log
brotherhood_of_LAN - 2:24 pm on Mar 20, 2011 (gmt 0)
Are they MyISAM tables? Does restarting the MySQL server have any increase/decrease in performance?
Ensure that it's not in the query cache. A 10 second query will take a sub-second time after it is in the query cache.
If you add SQL_NO_CACHE to the query and find that it's in the slow query log all the time then perhaps that's why.
Thread source: http://www.webmasterworld.com/databases_sql_mysql/4284554.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com