406 words
2 minute(s)
The reference below was an excellent source for writing this and there are a few more suggestions in it that you may want to look at as well. Make sure to back up your configuration file and databases before you start playing around with it.
Calculating Free Memory We need to find out how much memory is available for MySQL to use. This example is not going to include swap space in the total because what would be the point in tweaking MySQL to run faster if it is going to be swapping off of the hard drive?