Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Josh Miller (joshuaitsecureadmin.com)
Date: Thu Sep 04 2008 - 17:43:43 CDT
Perrin Harkins wrote:
> What you really need to do is look at which queries are slow and run
> EXPLAIN plans for them. Most big performance problems like you're
> describing are due to index issues, so that's where you should be
> looking. Server tuning comes lat
We definitely need to work on re-designing the queries and indexes. We
have a less than 50% index usage rate which is disastrous.
We'd like to prove InnoDB and move onto that storage engine for the
transaction support, MVCC, etc.. but we're finding that performance is poor.
Josh Miller, RHCE
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql