Does anyone have any experience/advice on MySQL, specifically the InnoDB engine running on an 8 core box? Current setup is CentOS 5.1.4, 48 GB ram, Hardware RAID 5 on 15K SAS drives (8 drives). hdparm shows 550+ meg per second read speed and 280 write. The MySQL performance does not seem to be where it should be for the given hardware. I cannot get the QPS over about 750. I have the InnoDB buffer set to 20GB. I have tuned all the normal parameters I could think of.
I'm running MySQL Enterprise 5.1.44. I have read that InnoDB does not scale well on multiple cores, but there seems to be debate from both sides about that. Any advice would be appreciated.