My DB Advisor

PHP Single-page app to check for MySQL performance metrics and give hints on performance.

While administering MySvQL Server platform, many times I needed to consult, learn and research on MySQL tunning parameters, limits, monitoring status variables and so on.

Although some tunning recommmendations are widely known (as well as many tools), some other aren't and additionally should be made carefully depending on each scenario.

As I cannot remember all of them when I need to tune or review performance of MySQL server, I written this single-page php code that includes all performance checks and tunning hints I have found during my research.

Please note that some literature is contradicting or not clear on why some settings are recommended as well as many things may depend on MySQL version. So feel free to send recommendaions, fixes, comments and so on. Specially new tunning hints (so we learn even more).

• An error occurred while fetching this feed: https://www.l3jane.net/websvn/rss.php?repname=Factory&path=%2Ftrunk%2FWebFolder%2Fdb%2Fmyadvisor.php&

Full Change Log

I intented to make as simple as possible and deliver only a single PHP file for easy deployment, although there are something usefull to have:

• Obviously HTTP Server and PHP and MySQL DataBase ;)
• The page make use of jQuery-UI locally installed, you can change the URLs for the CDN ones

• PHP single file
• CSS style (optional)