How to Optimize MySQL with MySQLTuner

MySQLTuner is a script that will assess MySQL performance and recommend steps to maximize performance. To install and run MySQLTuner, log in to your VPS as the root user and follow these steps (for CentOS):

 

1. Download MySQLTuner:

# wget http://mysqltuner.com/mysqltuner.pl

# chmod 755 mysqltuner.pl

2. Run MySQLTuner:

# ./mysqltuner.pl

Configuration can be set in the /etc/my.cnf file.

  • payment
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to close an open DNS resolver - Linux

Locate the BIND configuration file within the operating system. The BIND configuration file is...

How to Modify SSH to Use a Port Other than 22

  A simple, but very effective, step you can take to enhance your server's security is to update...

How to List All Open/Listening Ports

If you find yourself needing to check all open/listening ports that your server is using (a good...

How to Install ConfigServer Firewall (CSF)

ConfigServer Firewall, or CSF, is a common Linux security suite. Log in to your VPS as the root...

How to Check VPS Memory/RAM Usage with SSH

There are a few tools built-in to most Linux distros for gauging and fine-tuning your server's...

Powered by WHMCompleteSolution