It's just an estimate for the query engine, not a true row count. But good enoug... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

kristjan on June 5, 2012 | parent | context | favorite | on: Loading half a billion rows into MySQL

It's just an estimate for the query engine, not a true row count. But good enough for a progress bar.

From http://dev.mysql.com/doc/refman/5.0/en/tables-table.html:

> For InnoDB tables, the row count is only a rough estimate used in SQL optimization.

fizx on June 6, 2012 | [–]

If you run it a dozen times, it converges on the truth.

jakejake on June 5, 2012 | [–]

aha, thanks

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact