Last active
August 29, 2015 13:57
-
-
Save ivancp/9539388 to your computer and use it in GitHub Desktop.
What happens when repair a 2Gb MyISAM table
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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