My SQL Dump

MySQL musings by a self professed MySQL Geek

Previous Entry Share Next Entry
Sample my.cnf file for InnoDB databases
Brian Moon suggest that community provided example my.cnf files would be a great thing to have on MySQLforge in this recent post:

I pulled out the "innodb heavy" config sample file and modified it with the standard settings that I typically start with when setting up a new InnoDB master. I've also modified the comments in the file a bit and have added some of my own too. I removed the sample slave configuration parameters (master-host, etc) because you should be using 'CHANGE MASTER TO'.

He suggested tagging such files with a 'mycnf' tag and very kindly tagged mine after I posted it :)

Feel free to share yours too and please feel free to make any comments about my configuration choices.

You can find it here (along with any other mycnf tagged files):


Log in