Skip to content

Instantly share code, notes, and snippets.

@ivancp
Last active August 29, 2015 13:57
Show Gist options
  • Save ivancp/9539388 to your computer and use it in GitHub Desktop.
Save ivancp/9539388 to your computer and use it in GitHub Desktop.
What happens when repair a 2Gb MyISAM table
mysql> repair table dbdemo.table;
+---------------+--------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------+--------+----------+-------------------------------------------------------------------+
| dbdemo.table | repair | info | Key 1 - Found wrong stored record at 381432048 |
| dbdemo.table | repair | info | Key 1 - Found wrong stored record at 390303976 |
| dbdemo.table | repair | info | Wrong aligned block at 391242113 |
| dbdemo.table | repair | info | Delete link points outside datafile at 391242113 |
| dbdemo.table | repair | info | Key 1 - Found wrong stored record at 393273584 |
| dbdemo.table | repair | info | Key 1 - Found wrong stored record at 396046628 |
| dbdemo.table | repair | info | Key 1 - Found wrong stored record at 594145524 |
| dbdemo.table | repair | info | Wrong aligned block at 602284419 |
| dbdemo.table | repair | info | Wrong bytesec: 48- 55- 53 at 602284419; Skipped |
| dbdemo.table | repair | info | Key 1 - Found wrong stored record at 607154412 |
| dbdemo.table | repair | info | Wrong aligned block at 607322499 |
| dbdemo.table | repair | info | Wrong bytesec: 48- 55- 50 at 607322499; Skipped |
| dbdemo.table | repair | info | Wrong aligned block at 608432513 |
| dbdemo.table | repair | info | Wrong bytesec: 248- 8- 52 at 608432513; Skipped |
| dbdemo.table | repair | info | Key 1 - Found wrong stored record at 608518416 |
| dbdemo.table | repair | warning | Duplicate key for record at 393852452 against record at 393818024 |
| dbdemo.table | repair | warning | Duplicate key for record at 604802700 against record at 472148116 |
| dbdemo.table | repair | warning | Number of rows changed from 9628140 to 16594799 |
| dbdemo.table | repair | status | OK |
+---------------+--------+----------+-------------------------------------------------------------------+
19 rows in set (6 min 53.91 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment