Hailiang Ji wrote:
Folks,
A help needed. My manager's pushed me to optimize the tables that I
created in distributed in several DBs. I have tried best to explain to him
that I have followed the strict formula design to do the Join, Search and
so on. However, the system performance is not good enough yet when our
system get thousands' users visiting in the same time.
Maybe you're missing some indexes.
Enable slow-query-log and see where your time is being spent.
http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html
Once you have some data, use explain to work out whether a query is
using an index.
Or try mysql_explain_log:
http://dev.mysql.com/doc/refman/4.1/en/mysql-explain-log.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
