First of all a big thank you to all of you who attended my two Hands-On Labs (HOL) session at this year's MySQL Connect. I ended up doing two sessions as there was a last minute cancellation, so in addition to the previously announced session about the Performance Schema, I also did an introduction to MySQL.
The slides and the workbook for the Performance Schema session will become available from the official Oracle OpenWorld/MySQL Connect catalog, but you can also get the files from my blog which for the Performance Schema session will also include the helper functions and procedures used and some sample queries used to create load on the server.
HOL10471 – Getting Started with MySQL
This session only had slides, however the slides includes the commands and queries executed during the session. Note that the part on using MySQL Workbench (by Alfredo Kojimais) is not included.
The slides are available at: HOL 10471 – Getting Started with MySQL
HOL10472 – Improving Performance with the MySQL Performance Schema
The Performance Schema lab used several files. The main one to use is the workbook which includes details on the queries and commands to run. The hol10472.tgz also includes some support files (for example stored routines) used.
The following files can be downloaded:
- Slides: HOL 10472 – Improving Performance with the MySQL Performance Schema – Slides
- Workbook: HOL 10472 – Improving Performance with the MySQL Performance Schema – Workbook
- Support files: HOL 10472 – Improving Performance with the MySQL Performance Schema – Support Files
Have fun playing with MySQL!