Performance Optimization for MySQL with InnoDB and XtraDB

MySQL Emergency? Call right now and get help
  • Are you running into database performance problems?
  • Do you want to know how to get the best performance out of InnoDB?
  • Are demands increasing, and you don't know what architectual decisions you need to take now will protect you in the future?

Our Optimization workshop may be just what you need!

Attendees of this workshop will be able to:

  • Identify successful architectures, and how applications can be made to scale with MySQL.
  • Interpret data from Linux diagnostic tools.
  • Learn to be systematic about fixing performance problems.
  • Optimize query performance.
  • Understand how key features of InnoDB work, including the buffer pool, transaction logs, clustered indexes, insert buffer, adaptive hash, double write buffer.
  • Learn to read diagnostic Information from InnoDB and make informed decisions while tuning configuration.
  • Discover how XtraDB, the Percona and Google patches will provide you better diagnostics and better performance.

Who should attend:

Database Administrators, System Architects.

Prerequisites:

This is an advanced course, and recommends the minimum of:

  • Experience using MySQL (this course won't cover basics like starting/stopping,
    what a storage engine is).
  • Familiarity with Operating Systems (particularly Linux/Unix).
  • Some programming experience is recommended (any language).

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 you MySQL Versions:

5.0, 5.1, 5.1-XtraDB

Upcoming Sessions:
Call us: 1-888-316-9775 | Contacts
MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.
Copyright © 2006-2010 Percona Inc.