Written by: Will Kruss on 28 August 2012 08:33 AM
This tutorial explains how to optimize MySQL performance including configuring, tuning & measuring performance. Read to learn today.
If you are running a MySQL database back end for your site, or using products such as Magento or Joomla, you can optimise MySQL to use query caching. This can speed up the site quite substantially.
To do this:
SSH into your server (for help see: https://www.vpsblocks.com.au/support/Knowledgebase/Article/View/41/0/how-do-i-use-ssh)
Find and modify (or add) the lines:
Save and exit (ctrl-x)
A cache size value of between 64mb and 256mb is recommended. If you have only 1GB of RAM we don't recommend setting this above 64mb.
You will need to restart MySQL after making this change, to do this type: /etc/init.d/mysqld restart