Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers 3

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

share|improve this answer
add comment

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
add comment

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.


tuning-primer
mysqlreport

.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
add comment

Your Answer

 
discard

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.