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
and copy one of the pre-configured settings file for MySQL to
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:
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.