Skip to content
This repository has been archived by the owner on May 13, 2018. It is now read-only.

Incorrect number of fields #16

Open
tsanchev opened this issue Feb 8, 2017 · 1 comment
Open

Incorrect number of fields #16

tsanchev opened this issue Feb 8, 2017 · 1 comment

Comments

@tsanchev
Copy link

tsanchev commented Feb 8, 2017

image

the actual number of recordrs is 776

@mateuszjarzewski
Copy link

mateuszjarzewski commented Apr 1, 2018

Yes, this is cuz InnoDB is slow when counting total number of rows, so they just get the value from systemic MySQL table INNODB_SYS_INDEXES.
But that counter is ofully inaccurate :(

Take a look into file: inc/functions_dump.php line 80:

$erg=mysql_fetch_array($res);
// Get nr of records -> need to do it this way because of incorrect returns when using InnoDBs
$sql_2="SELECT count(*) as `count_records` FROM `".$databases['Name'][$dump['dbindex']]."`.`".$erg['Name']."`";

By the way that is well known InnoDB limitation.
I'm afraid there is no way to fix this, maybe except running count(*) on all tables, but this will consume wast amount of resources and take forever to complete on big dataset.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants