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.

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.