I recently was on the search for a few examples of active MySQL configuration files (my.cnf). It’s always nice to see someone else’s production version of a configuration file and during this search I realized that not a lot of examples of MySQL config files were to be found on the internet.
The first place to start is MySQL’s examle config files. You can find this in mysql’s doc share, ie:
/usr/share/doc/mysql-server-5.*.*/
There are 5 example MySQL configuration files provided with most systems:
- my-small.cnf
- my-medium.cnf
- my-large.cnf
- my-huge.cnf
- my-innodb-heavy-4G.cnf
You can take a look at the example MySQL config files above to get an idea of how these settings can be handled.
Here are a couple links to pages with MySQL config file examples:
- http://www.felipecruz.com/mysql-server-production-my-cnf-file.php
- http://forge.mysql.com/tools/tool.php?id=138
- http://www.astahost.com/info.php/Sample-Mycnf-Mysql-Configuration-File_t2727.html
- http://www.notesbit.com/index.php/web-mysql/mysql/mysql-tuning-optimizing-my-cnf-file/
- http://www.joehruska.com/?p=7
Here’s a link worth reading:
That’s it for now. This is a resource page/blog post pointing to example MySQL configuration files.