MySQL Optimizer is an alternative to existing scripts that gives you suggestions on how to optimize your mysql databases. The app provides a graphical interface and automation tools designed to simplify the process of viewing performance metrics, apply changes based on our recommendations and all mysql slow query logs. This page includes answers to some common questions about getting started with MySQL Optimizer app, directions to access help, and links to additional documentation and resources.

What exactly is MySQL Optimizer?

MySQL Optimizer app reads mysql variables and similar to phpmyadmin or mysqltuner it displays issues found with your databases and make some recommendations that can improve your database speed/stability. It also displays mysql slow query logs and performance metrics.
MySQL Optimizer is a one-time purchase app, and runs on the Mac desktop, sending direct commands to the servers instead of being hosted on the server. Also, with the app you can control unlimited servers at no extra cost.


What are the main features?

The app has 3 main features:

  • - Performance Metrics (very useful info about your server and mysql)
  • - Slow Query logs that are already grouped so you can fix slow queries that have highest occurrence first.
  • - Recommendations the app main function is where you see a list of issues and recommendations, where applicable you can set the value and just tick to apply new values

Is it safe to apply recommendations?

There are few things to consider:

  • - 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
  • - You can always revert changes by going to Backup/restore tab and select the version you want to revert to
  • - Once you apply some changes MySQL needs time to collect data again for new statistics and recommendations and while it's recommended to wait 24hours before applying more changes, the app will allow you to do it after 6hours

What Servers can I connect to?

  • 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

Can I use servers with Installed services?

  • Yes you can use servers with preinstalled Apache/Nginx and MySQL, on our testing all worked fine, but if do have issues with the app with an existing mySQL server contact us 

     

What authentication methods do you support to servers?

  • Username and password
  • Username and PEM file, with or without passphrase protection
  • Username and private key (usually called ID_RSA), with or without passphrase protection
  • Ability to supply a SUDO password if needed when logging in using key pairs or private keys

*we only support authentication with root or a sudo user, logging in with a normal user then using SU to gain root access is not supported.

Can I uninstall MySQL Optimizer from my servers?

MySQL Optimizer does not install its own software on your servers so if you stop using it there’s nothing to uninstall from your servers.

Does MySQL Optimizer use many resources to run?

Because nothing is installed on your server the app does not use any of your server resources.

What languages do you support?

The App is in English only for now.

your Linux should be in English too (locale to LANG=en_US), because we parse server responses and app is expecting these to be in English.

How do I request technical support?

If you require technical support or even have a feature suggestion - submit a ticket using form below. We will try to reply all tickets within 24hrs