Breaking Down Query Latency With DTrace

breaking_down_mysql_latency_w_dtrace

There have been many high-level talks about how to use MySQL and DTrace together, but very little technical detail. This talk will show you how to instrument MySQL and InnoDB internals at a very deep level, using filesystem operation latency as a key example. Other topics will include tracing InnoDB’s thread concurrency code. Presented by [...]

Using Percona XtraBackup

using_percona_xtrabackup

This presentation will cover tasks such as creating backups, setting up slaves, and copying InnoDB tables between servers. These features can greatly simplify day-to-day maintenance and operation of your database. Learn how to tap into the power and features of XtraBackup! Presented by Vadim Tkachenko at Percona Live NYC 2011. New York Video Production Services [...]

InnoDB Performance Tuning

Peter Zaitsev’s talk at the 2009 Percona Performance Conference. Slides. Direct Download: http://blip.tv/file/get/Percona-InnoDBPerformanceTuning840.m4v

The Life of a Dirty Page in InnoDB

Mark Callaghan’s talk from Percona Performance Conference 2009. Slides Direct Download: http://blip.tv/file/get/Percona-mark_callaghan574.m4v

Intro to XtraDB, a Scalable InnoDB-based Storage Engine

intro-to-xtradb

Intro to XtraDB, a Scalable InnoDB-based Storage Engine by Ewen Fortune, Percona Consultant.

InnoDB Data Recovery Tutorial

innodb-recovery

This three-part screencast demonstrates how to perform InnoDB data recovery with Percona’s InnoDB data recovery tools. If you need help, Percona provides expert MySQL and InnoDB data recovery services. Part 1 of 3: Part 2 of 3: Part 3 of 3:

Answering Vadim’s .ibd Recovery Challenge

ibd-recovery

Ryan posts the answer to Vadim’s .iby recovery challenge (http://www.mysqlperformanceblog.com/2009/05/15/friday-challange-ibd-recovery/)