Config MySQL to maximum speed and memory

Question

I have a server, 8 cores, 12 GB RAM. And this SErver only use to run MySQL only. So, help me config /etc/my.conf to maximum speed, memory for MySQL.

Thanks.

Answer 1

Here are some ideas. You can get a lot out of reading the book High Performance MySQL.

Answer 2

There is no simple answer to your question. Tuning MySQL is very wokrload dependend.

• How your workload looks (mix of SELECTS/DMLs), query types, schema, indexing
• Storage engines used
• Working set size and database size
• Access patern generated by users.

Here is link to my answer to similar question. It has a lot of usefull links, which describe different aspects of tuning MySQL parameters.