To help optimize your VPS, do take a look at MySQL Tuner

MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.  The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.

----- Download/Installation -----

You can download the entire repository by using 'git clone' followed by the cloning URL above.  The simplest and shortest method is:

    wget mysqltuner.pl
    ./mysqltuner.pl
   
Of course, you can add the execute bit (chmod +x mysqltuner.pl) so you can execute it without calling perl directly.

----- End -----
Was this answer helpful? 251 Users Found This Useful (548 Votes)

Most Popular Articles

cPanel/WHM Upgrade - Access Lost

If you run a new cPanel/WHM Upgrade and for some reason after a reboot your system is...
Diskspace Usage - Where and Why?

In most cases if not all majorities, a large amount of your VPS Diskspace it taken up by the...
How to change server hostname?

To change your hostname, enter the following command as root:$ hostname...
Installing Apache Booster

ApacheBooster is a integration of nginx and varnish, this Plugin will reduce the server load...
Preferred Port to use SSL?

Since HTTP uses default port number 80, it's not recommended for SSL. Secure HTTP (HTTPS) by...