As http://lens.treetwo.com traffic shows a nice growth, performance issues arise. You have 2 friends to do basic tuning of MYSQL, named:
1. MYSQL slow-query-log
to find out which SQL is slow
http://blog.longwin.com.tw/2005/10/mysql_query_slow_find/
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
2. EXPLAIN query
to find if a slow query had been improved
http://dev.mysql.com/doc/refman/5.0/en/explain.html
+—-+—————+——-+——–+——————-+—–+———–+——+——-+——–+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+—-+—————+——-+——–+——————-+—–+———–+——+——-+——–+
先留意 Extra 唔應該出現 filesort 或 tempery, key 也不應該 NULL, 詳細的 tuning 請服用 http://www.databasejournal.com/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm
