MySQL Optimizer (was MySQL and MariaDB Optimizer) is an effective app that gives you recommendations for optimization of MySQL databases. The app provides a graphical interface to simplify the process of viewing performance metrics, apply changes based on our recommendations, and all MySQL slow-query logs, which are grouped by occurrence number.
Things to consider when applying recommendations:
- When you apply changes MySQL service restarts so your web sites will be offline for couple seconds
- Make sure you understand the changes you make as in some cases they might not be suitable
- Fixed reading variable (join_buffer_size)
- OS X 10.11 or later