In the last weekend of September, MySQL Connect 2012 will take place in San Francisco as part of Oracle OpenWorld. MySQL Connect is a two day event that allows the attendees to focus on MySQL with the possibility to add on to Oracle OpenWorld or JavaOne.
I will be running the Hands-On Lab session Improving Performance with the MySQL Performance Schema (HOL10472) with the following abstract:
The Performance Schema is a tool first introduced in MySQL 5.5. It gives access to information about server events, from function calls to a group of statements. MySQL 5.6 greatly enhances the Performance Schema with new instrumentation points as well as more flexibility for configuring which connections (such as users and hosts) and parts (from databases to instrumentation points) of MySQL should be instrumented. In this hands-on lab, the attendees will configure the Performance Schema to get the best benefit in their environment; walk through practical examples, using high-level summaries; drill down to detailed wait events; and investigate common problems such as slow queries.
The session is scheduled for Saturday 29 September from 5:30 PM to 6:30 PM.
There will also be a talk on the subject of the Performance Schema by Mark Leith. If you attend both of these sessions, you should be well prepared to take advantage of the new Performance Schema features included in the upcoming MySQL 5.6 release.
There is a total of 78 sessions at MySQL Connect 2012, so if you have not already registered, be sure to do it before 24 August when the Early Bird rate ($500 discount compared to an onsite registration) ends.