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:

1. my-small.cnf
2. my-medium.cnf
3. my-large.cnf
4. my-huge.cnf
5. 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:

• http://www.brennan.id.au/17-MySQL_Server.html

That’s it for now. This is a resource page/blog post pointing to example MySQL configuration files.

Incoming search terms:

• mysql config
• mysql settings for production
• mysql configuration
• config mysql
• mysql configuration for production
• mysql config example
• mysql example config
• mysql configuration examples
• mysql production configuration
• mysql configuration example

Related posts:

1. How to Check MySQL Version on Command Line
2. Working with MySQL SET Data Type
3. How to Add MySQL Access Logs
4. MySQL Search Across Columns with Concat