Undrop-for-InnoDB is a tool that does all job behind the scene of https://recovery.twindb.com/ .
“DUMPED” and “LOADED” are relevant to recovery process using undrop-for-innodb.
“DUMPED” is a number of records `c_parser` extracted from InnoDB pages and wrote to a text dump.
“LOADED” is a number of unique records loaded into MySQL.
“DUMPED” is always higher or equal to “LOADED”.
It happens because of several reasons:
- `c_parser` may dump duplicate records. When InnoDB does rebalancing some records may be left in free space of a page. Or same record may be extracted from undo segment or double-write buffer. The duplicate records are possible and happen quite often
- a record may be dumped but not loaded. If a record contains incorrect values and MySQL refuses to load it into a table LOADED will be smaller than DUMPED.
- Guest answered 1 year ago
- You must login to post comments
Please login first to submit.