Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a server, 8 cores, 12 GB RAM. This server is only used to run MySQL. So, help me config /etc/my.cnf to maximum speed, memory for MySQL.

share|improve this question

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

share|improve this answer

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.

share|improve this answer

MySQL performance tuning is not a one day task, it is on going process. The best way is to monitor the performance of your MySQL and make the appropriate changes by tuning the mysql parameters. The below tools might help you.


.These tools will analyze the current settings and will tell you whether you need to increase the value or decrease the same. E.g. InnoDB buffer pool, query_cache and many more.

I am using these tools and they are of great help.

Happy tunning...

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.