MySQL Connect 2013 was held this past Saturday through Monday, and I would like to extend a big thank you to everyone who attended my sessions, I talked to or otherwise took part in the conference.
I had two sessions as well as participated in a Birds of the Feather session with the Community and Support teams. The slides have been uploaded the the Content Catalog but they are not available for download from there yet. Until then you can download them from the the links below:
- CON5282: Making the Performance Schema Easier to Use
- HOL9733: Improving Performance with MySQL Performance Schema
This is the workbook from the Hands On Lab which includes the instructions used during the lab. The queries that are started in the second part when queries are investigated are just arbitrary queries meant to generate some background workload that will show up when looking in the Performance Schema tables and the views from
ps_tools. Any workload should work fine.
The ps_helper views, procedures, and functions used in the above presentations can be downloaded from https://github.com/MarkLeith/dbahelper:
git clone https://github.com/MarkLeith/dbahelper
ps_tools, I will follow up on this site with more information although some of the tools can be found in Easier Overview of Current Performance Schema Setting. Note: the presentation uses the naming convention that Performance Schema tools are prefixed
ps_ – that was not the case in the above blog, so e.g.
ps_setup_tree_consumers is in the blog called
And again: thanks for attending MySQL Connect 2013 – hope to see you again next year.