Take the 2-minute tour ×
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. It's 100% free, no registration required.

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?

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
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
add comment

1 Answer 1

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.

innodb_buffer_pool_size=12G

query_cache_size=500M

innodb_log_file_size=64M
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
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.