MySQL Optimizer is an effective app that gives you recommendations to optimize MySQL / MariaDB databases. The app provides an intuitive interface designed to simplify the process of viewing database metrics and issues. MySQL Optimizer applies recommendations safe as the app makes a backup every step, so you can easily revert to a previous MySQL configuration.
MySQL Optimizer is designed to function with either a dedicated server or a virtual private server. If you don't remember your MySQL root password you can reset with a new one.