The MYSQL tuner is a useful package that connects to a running instance of your database service and provides a series of configuration recommendations based on the current workload. Naturally, such a tool will not always provide the perfect answer for your system, but you should allow the database system to run for one or more days under a typical workload before introducing a modified configuration.

To install the mysqltuner package (part of the EPEL repository), you should type this:

# yum install mysqltuner

To run the mysqltuner package from the command line, you can use the following syntax at any time:

# mysqltuner

Now, depending on your system configuration and hardware, the output of mysqltuner will look similar to this:

>>  MySQLTuner 1.2.0 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
Please enter your MySQL...