slider

what is the difference between the row counts on the DUMP vs. LOADED columns.

  1. Backup and Data Recovery for MySQL
  2. what is the difference between the row counts on the DUMP vs. LOADED columns.
0
0

On behalf of a user:

“I am assuming I will get the total row counts as shown on the DUMP
column and LOADED is what I could achieve by using standard MySQL dump. is
that it?”

  • You must to post comments
0
0

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.

screenshot-2016-01-05-23-16-34

  • You must to post comments
Showing 1 result
Your Answer

Please first to submit.