Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on MySQL and partitioning tables with millions of rows. Parent comment
1) Have you run Mysqltuner? If not, wget http://mysqltuner.com/mysqltuner.pl chmod to executable and execute it. I find it rather helpful.
2) Are you indexing every field that is part of any WHERE statement (at least for the big tables)?
3) Have you run EXPLAIN on the original query? (Suggested by someone else in this thread, and a critical question.)
4) Is the slow_query_log enabled, and are you sure about which query is causing the slowdown?
5) Have you tried tools like MySQL Administrator, which lets you monitor connections, threads, keys, queries, etc, in realtime?
There are no comments on this comment yet.
1) Have you run Mysqltuner? If not, wget http://mysqltuner.com/mysqltuner.pl chmod to executable and execute it. I find it rather helpful.
2) Are you indexing every field that is part of any WHERE statement (at least for the big tables)?
3) Have you run EXPLAIN on the original query? (Suggested by someone else in this thread, and a critical question.)
4) Is the slow_query_log enabled, and are you sure about which query is causing the slowdown?
5) Have you tried tools like MySQL Administrator, which lets you monitor connections, threads, keys, queries, etc, in realtime?