“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 2 years ago
- last edited 8 months ago
- You must login to post comments
Please login first to submit.