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.

We have a new centos 6.2 setup. Below is the configuration file. The machine is going to be fully innodb and it has 8Gb ram. What else must I include in the .cnf? I know one major thing is the innodb_buffer_pool if I set 6Gb is it ok?

[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

closed as not a real question by mgorven, Magellan, HopelessN00b, Ward, Iain Nov 21 '12 at 9:26

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

1 Answer

It's getting a little old but this is still one of the best run-downs for a new server configuration:

What to tune in MySQL Server after installation

The new Percona MySQL Configuration Wizard is also worth checking out.

share|improve this answer
    
I been to bought the but I am want to know more about this innodb_log_file_size if I adjust now my conf will it have any effect on my log file? There is normally 2 files rite? –  user111196 May 24 '12 at 4:56
    
add comment

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