MySQL Optimizer (MySQL and MariaDB before Optimizer) is an effective application that provides recommendations for optimizing MySQL databases. The application provides a graphical interface to simplify the process display performance metrics, implement changes based on our recommendations and all records MySQL slow query, grouped by issue number.
– Performance Metrics (very useful information about your server and mysql)
– slow query already grouped so you can fix slow queries that have the highest occurrence first.
– Option to explain slow queries
– Error logs are available on the main screen of the slow query
– The tab of the recommendations is the main function of the application, where you see a list of issues and recommendations, where applicable you can set the value and the signal just to apply new values.
– Editor Advanced Mysql variables, so you can adjust even more MySQL
Things to consider implementing the recommendations:
– When applying changes, the MySQL service restarts to their websites go offline for a couple of seconds
– Make sure you understand the changes you make because in some cases may not be appropriate
– can always revert changes on the tab backup / restore and select the version you want to return to
– once changes are applied MySQL needs time to collect data again to the new statistics and recommendations , and while it is recommended to wait 24 hours before applying more changes the application will allow you after 6 hours
– using standard connections MySQL can not make changes (implement recommendations or edit variables) – this is only possible when using SSH connection
Supported Linux distributions (to add SSH servers):
– Ubuntu 14.04 (LTS), 14.10, 15.04, 15.10, 16.04, 16.10
– CentOS 6.x, 7.x
– Amazon Linux 2016.03
– Red Hat Enterprise Linux 6.x, 7.x
– Debian 7 and 8