1

I'm currently importing a table with about 17 million rows in MySQL. What catches my attention is, the number of row seems to be fluctuate.

I used the command show table status while my importing process was running. One time, I got 1.5 million of rows, then I ran that command again and got lower than 1.5 million. How is that possible?

Vérace
  • 30,923
  • 9
  • 73
  • 85
Ahmad Hayam
  • 21
  • 3

1 Answers1

1

The answer is innodb only estimates number of rows by command show table status. Please refer to http://dev.mysql.com/doc/refman/5.7/en/show-table-status.html for further explanation.

Ahmad Hayam
  • 21
  • 3