Hello everyone,

I want to optimize my server, to handle more requests, and just being faster. I'm using APC as opcode caching, and seems to work great!

But I also want to optimize the mysql a bit, if possible.

I'm sitting on CentOS 5.7 64-bit, with 2.8 ghz dual core processor, and 4gigs DDR3 ram.

but I don't know how I should configure my.cnf for the best performance.

Generally I'm running multiple wordpress + joomla sites, but also WHMCS, getSimple etc.

My my.cnf is empty at the moment, only max_connections=500 is set!

Hope someone knows a little more about it than me!

Best regards,
Lucas Rolff