MySQL Performance Analyzer is open source

On behalf of Yahoo database engineering team, I am pleased to announce that MySQL Performance Analyzer has been released as open source.

After numerous iterations of development spanning 40 thousand lines of code and 1080 man hours, this has been an amazing journey. What kicked off as a side project 3 years ago after winning an internal hack day competition at Yahoo and having only 1 person working on it in his spare time wearing multiple hats of DBA/DBE/Developer, we have certainly come a long way.

Having presented this at prestigious conferences like Percona Live and Oracle Open World since 2014, the ever increasing demand from MySQL community was to make it open source. No wonder within hours of releasing this, over 50 forks have already been created on GitHub. We not only incorporated feedback from the community on what additional features should be included but also rewrote the entire code to comply with open source standards.

MySQL Performance Analyzer has real time tracking features and continually gathers the most important performance metrics, provides visualization and statistical analysis for quickly identifying performance patterns, bottlenecks and possible tuning opportunities.

Salient Features:

• Lightweight Agentless Java Web Application
• Self contained, easy to deploy anywhere
• Rich UI
• Performance Metrics Hub
• Detects anomalies and sends custom notifications
• Access to real time performance data

Performance Tuning for long has been a niche limited to few professional experts and geeks. And we really wanted to break that paradigm by taking this to all end users: developers and DBAs alike simplifying the performance monitoring and troubleshooting so that it’s no longer seen as a daunting task.

As a central database team at Yahoo responsible for thousands of MySQL instances across the board, this tool allows us to proactively identify any possible performance optimization opportunities.

Give it a try and preferably join us in contributing further to open source.

Here is the GitHub: https://github.com/yahoo/mysql_perf_analyzer

My heartfelt gratitude to Xiang Rao for single handedly developing this from scratch, Ashwin Nellore for taking this out to various external conferences, Gil Yehuda for his assistance on open source standards compliance and last but not the least Satish Mehta who planted the very seed of it while working on this patent