How to optimize MySQL


On, you find two interesting tools for MySQL. A configuration wizard that recommends a MySQL configuration based on your server settings. There is also a query analyzer tool that analyzes your SQL query and provides feedback. To use the tools, you need to log in, but they are free!

MySQL settings optimizer

The MySQL optimizer will ask you to fill in your server configuration and database settings. Through a wizard, the optimizer collects info about your current server environment and will give a recommendation how to optimize your MySQL. Examples that are given:

  • buffer pool size
  • logging
  • caching
  • connection limit
  • startup

When you finished the wizard, you can download the a fully configured my.ini file. The optimizer can be found here.


MySQL query analyzer

The query analyzer gives you feedback how you can make your query better and faster. The query analyzer can be found here.


Add comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Tag Cloud