MySQL Tuning

MySQL has various configurations to customize the way MySQL functions. One of the easiest way I have found to change the set up of MySQL in terms on scaling is the default configuration files for different sized servers. In Ubuntu 8.04 they can be found in
/usr/share/doc/mysql-server-5.0/examples
and copy one of the pre-configured settings file for MySQL to
/etc/mysql
Make sure you make a backup of the existing MySQL config file. You can use the example config files by moving it to the MySQL director for example using the command:
cp -v /usr/share/doc/mysql-server-5.0/examples/my-huge.cnf /etc/mysql/my.cnf
Some configs my be compressed with a “.gz” extension. To extract the file from this compression use Gunzip:
gunzip my-huge.cnf.gz
The values in the config could be further tuned but as the different targeted sized config was fine for me.

The only extra step I had to take was to enable InnoDB support. There is a comment in the config file of the small version of my.cnf which tells you how to do this.

Linux Compression and other commands

About Danny

I.T software professional always studying and applying the knowledge gained and one way of doing this is to blog. Danny also has participates in a part time project called Energy@Home [http://code.google.com/p/energyathome/] for monitoring energy usage on a premise. Dedicated to I.T since studying pure Information Technology since the age of 16, Danny Tsang working in the field that he has aimed for since leaving school. View all posts by Danny → This entry was posted in Linux and tagged example config files, gunzip, Linux, mysql server, servers. Bookmark the permalink.

This site uses Akismet to reduce spam. Learn how your comment data is processed.