From: Josh Miller (joshuaitsecureadmin.com)
Date: Thu Sep 04 2008 - 17:43:43 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.

Thanks!
Josh Miller, RHCE

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]