Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 new centos 6.2 setup. Below is the configuration file. The machine is going to be fully innodb and it had 8Gb ram. What else must I include in the .cnf?

# Disabling symbolic-links is recommended to prevent assorted security risks

share|improve this question
What version of MySQL are you using ? Did you load all the data into the database already? – RolandoMySQLDBA May 21 '12 at 15:33
I am using the version which comes with centos 6.2 that is 5.1. No is a brand new server we do not know how much full load data yet. So what settings is best here? – newbie14 May 23 '12 at 2:32
up vote 2 down vote accepted

The first thing you should configure is the innoDB buffer pool size. According to this blog entry by Percona, the ideal buffer pool size is 10% larger than your total data size.

Other settings to add: InnoDB log file size, query cache size.



share|improve this answer
I have read the blog but how do we decide the total data size is it based on the ibdata files size. I have set it to be per table basis. My server only have 8Gb ram so how it relates to 12G I am kind of confuse here. – newbie14 May 21 '12 at 12:45

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.