New answers tagged optimization
Regarding server load: you don't say what operating system this is. For most flavours of Unix (including Linux) as long as the load is less than the number of CPUs then you probably shouldn't worry about it. In this scenario, each process gets to stay in the CPU for as long as it can do useful stuff there (more or less). But when there is a queue of proceses ...
Even though I have accepted @ewwhite's answer above, I wanted to come back and report on a slightly conflicting answer that I just discovered elsewhere on the web, that is based on empirical data: Our results from the testing showed a 16% increase in reads while utilizing (2) SSDs in a RAID 0, with a 2% decrease in write performance. The performance ...
Percona has a pretty decent configuration wizard which will spit out a my.cnf file closely tuned to your server and workload: https://tools.percona.com/wizard It wont give you a perfect configuration, but you can compare to what you are currently running and see why they selected certain settings.
Top 50 recent answers are included