When it comes the moment of tuning mysql server, people usually face trouble knowing and choosing the right options and values to use in the configuration file (my.cnf)
I have recently faced this situation, and I found a few examples on my Debian that could be useful on your own MySQL configuration
The primary config file for MySQL can be find usually in /etc/mysql as the name of my.cnf.
There are lots of options in it, but keep in mind that most of them aren’t shown in the file (even commented), and in most case, it’s the default value that is pick at startup.
Recently, I was looking for documentation about it, and I found a few examples in /usr/share/doc/mysql-server-5.0/examples
The files in here display optimized configuration for various system, depending on the amount of RAM on the server…
Nowdays, most of the server have more than 2GB of RAM, so I believe one of the best configuration for that is my-huge.cnf which pretty fits my need…
I hope you enjoy this little post, and don’t forget to visit my blog: http://pierre.linux.edu/