A MySQL expert is needed to optimize our [url removed, login to view] settings.
The server is a Quad Opteron 8000 Series with 4 GB ram and a 15k SCSI drive.
MySQL is 5.0.
We transitioned to this server from a similar one that used MySQL 4.1. Ever since, inserts have been running slower.
The system processes 100 inserts per second into heavily indexed tables with 250k rows each. The system simultaneously is queried on from thousands of concurrent users.
We need someone to tweak the system to optimize insert performance, while not crippling select performance in the process.