Home Hosting Domains IT Services Support Contact Us
MyAccount PortalClient AreaAnnouncementsKnowledgebaseSupport TicketsDownloads

Knowledgebase
You are here: MyAccount Portal > Knowledgebase > MySQL > How to I optimise my MySQL my.cnf on my VPS/Dedicated Server?

How to I optimise my MySQL my.cnf on my VPS/Dedicated Server?

Tuning the performance of MySQL can be a really hard job to do.
There are many thinks to consider and no two servers are identical so there is no universal solution.
Tuning Primer is a script that will help you tune your mysql installation by providing very healthy recommendations based on past mysql records.
For the script to be efficient you must run the mysql server for at least 48 hours.

Installation is extremely simple:

  1. Download the script
  2. wget http://day32.com/MySQL/tuning-primer.sh

  3. Change the permissions for the file

    chmod 755 tuning-primer.sh

  4. Run it
  5. ./tuning-primer.sh

  6. Apply the sugesttions


Was this answer helpful?

Add to Favourites
Print this Article

Also Read


Network Status Client Area Knowledgebase Datacentre  
 
Terms of ServicePrivacy PolicyCustomer Security