I've got a dedicated production server with multiple cpus and 16GB of ram.
I would like to know how can I configure it better to take advantage of the server resources for better performance because website traffic is increasing and mysql starts using a lot of cpu.
This is my current MySQL Server configuration: http://pastebin.com/PTn1HWQu
I am also planning to optimize the database, and check the queries to improve the slow ones.
Thank you, Alex.