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 | |
|---|---|
|
Did you attend this event? Give 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.