Two things catch my attention
- MEMORY
- CPU
I have addressed these issue in past posts
- Is the CPU performance relevant for a database server?
- Insert-heavy InnoDB table won't use all my CPU
Please follow suggestions centered around InnoDB as multiple core engagement is only available in MySQL 5.5's native InnoDB as well Percona's XtraDB.
