-2

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
user111196
  • 1,257
  • 2
  • 13
  • 14

1 Answers1

1

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.

Dave Forgac
  • 3,546
  • 7
  • 37
  • 48
  • 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 04:56
  • http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/ – Dave Forgac May 24 '12 at 14:04