Training for InnoDB and XtraDB from Percona

An intensive one-day workshop for MySQL database administrators and systems administrators that covers InnoDB and XtraDB, the most popular storage engines for MySQL.

• Are you running into MySQL performance problems?
• Do you want to understand how InnoDB works under the hood, so that you can truly extract the best performance out of MySQL?
• Have you been using MySQL for a while, and want to understand what is different in Percona Server with XtraDB?

Attendees of this workshop will be able to:

• Understand the basic operation of InnoDB - including how data is stored on disk and in memory.
• Understand what InnoDB does internally when data is written, and how features like the transaction log files and undo space work.
• See how key features of InnoDB work, including clustered indexes, insert buffer, adaptive hash and double write buffer.
• Learn to read diagnostic information from InnoDB and make informed decisions while changing configuration.
• Discover how Percona Server with XtraDB can provide better diagnostics and performance.

Who should attend:

Database Administrators and System Administrators who are responsible for MySQL servers.

Prerequisites:

This is an advanced course, and we recommend production experience adminstering MySQL. MySQL will be preinstalled on Linux desktops in the morning, but the instructor will not stop the class to explain how MySQL has multiple storage engines, demonstrate starting/stopping the server, or show how to load example databases.

You do not have to have a flawless knowledge of SQL-92 (we think SQL is just a small part of administration), but you should have some working knowledge of the way Operating Systems work, RAID levels, and hardware.

If you are starting out in performance tuning, we recommend you take our developer or DBA courses instead. These courses will provide you many quicker wins initially via query tuning and understanding bottlenecks and buying appropriate hardware. By attending this course, we are assuming that you have already applied these optimizations and are moving on to the next level.

Format:

This course is delivered as a one day intensive. Attendees will be provided with Linux PCs, but given the time restrictions, hands-on exercises will be limited. Attendees are encouraged to use their own laptops if they prefer. Slides will be provided for students wishing to apply additional study after the course is complete.

Applies to MySQL Versions:

MySQL and Percona Server versions 5.0 and newer