Kart v wrote: >>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?
This is a topic that could take pages of explanation: http://www.oreilly.com/catalog/hpmysql/ Are you running only on mysql on the box? That's a big issue. If so start with my-huge.cnf and tweak based on your usage patterns and the mysql manual. At a start, give mysqld a lot of memory. Next, look at your queries using explain statements. Nothing will be fast until yo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]