I’ve talked about PERFORMANCE_SCHEMA in the past – almost a year ago now.
Back then the feature was just coming together in to something useable, and was on the cusp of moving towards code review. It entered code review, and went around, and around for 9 months, whilst various refinements were made.
Never the less, Marc Alff persevered (much respect!), and yesterday pushed his final merge in to the mysql-next-mr bzr tree. PERFORMANCE_SCHEMA is now awaiting the next milestone release, and will be a part of the next GA release of MySQL!
We have the initial documentation ready:
This first round adds the infrastructure to take monitoring of the MySQL Server to the next level, initially adding in instrumentation for sync points (mutexes, rw locks, etc.) and file IO, in the SQL layer, and most of the default storage engines (all those controlled by MySQL/Sun).
Here’s a shout out to the other storage engine developers – we’d love you to start looking at instrumenting your own engines as well. Ask away on the internals@ list – I’m sure Marc will be more than willing to help.
And now that we have the above in – what’s next? It’s a good question! Here’s a list of the major outstanding worklogs:
Personally, I’m voting for WL#4895 next (well, I’d like to see InnoDB instrumentation too!), but you can vote for what ever you are most interested in via the votes in Worklog as well.
Thanks for all the hard work Marc!