Linux setup steps/Tweak MySQL configuration

From Nick Jenkins

Edit configuration file:

nano /etc/mysql/my.cnf

... and add these settings to increase performance a bit:

# change from listed default of 16 to 64  :
- key_buffer              = 16M
+ key_buffer              = 64M
# uncomment, and change from default of 64 to 256:
- # table_cache             = 64
+ table_cache             = 256
# Add this on the line after the above
+ sort_buffer             = 4M

Then to make changes take effect:

/etc/init.d/mysql restart