MYSQL records count fluctuating

Question

I just inserted ~140,000 entries into a MYSQL table and when I look at phpmyadmin, the records count looks like ~129,000 and fluctuates on every refresh.

Any ideas why it is doing it?

score 3 · Accepted Answer · answered Jun 02 '13 at 18:51

3

phpMyAdmin uses a quick method to get the row count, and this method only returns an approximate count in the case of InnoDB tables. See $cfg['MaxExactCount'] for a way to modify those results, but this could have a serious impact on performance.

http://www.phpmyadmin.net/documentation/#faq3_11

answered Jun 02 '13 at 18:51

Bastian

10,279
1
30
40

So it's not something I should be worried about then? It's not bothering me, I just want to make sure the data is there... – William Falcon Jun 02 '13 at 18:52
you can always check with `select count(*) from table` – Bastian Jun 02 '13 at 18:54

MYSQL records count fluctuating

1 Answers1