> If your not using the cpu fully, you definitely need > to optimize > mysqld's settings and/or optimize your queries. > Even if the cpu is > running full out, optimizing queries to examine > fewer rows can help.
Yes Ware, the CPU is not fully utilized. It shows just 10 -15% utilization. Could you provide some direction on how to optimize the mysqld's settings? will using my_huge.cnf will do or do we need to change any parameters? Thanks Kareen __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]