froscon2010 - PREVIEW

FrOSCon
Free and Open Source Software Conference

Speakers
Aleksandr Kuzminsky
Schedule
Day Day 1 - 2010-08-21
Room HS6
Start time 16:30
Duration 01:00
Info
ID 606
Event type Lecture
Track OpenSQLCamp
Language used for presentation English
Feedback

Recovery of Lost or Corrupted InnoDB Tables

When an InnoDB table is deleted physically its records remain untouched some time. Knowing how InnoDB stores information and the table’s structure it is possible to recover the records.

The session covers topics:

* InnoDB page format
* Internal system tables SYS_INDEXES and SYS_TABLES
* InnoDB Primary and Secondary keys
* Typical failure scenarios
* Dealing with corrupted InnoDB tablespace
* Recovery from a raw partition

The session is illustrated with examples using Percona in-house InnoDB Recovery Tool.