Tuning MariaDB and MySQL
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 <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL...
