Web Hosting Talk : Web Hosting Main Forums : Dedicated Server : INNO DB Question

[php4ever]

I converted several tables to INNO DB and there is a strange thing when it shows the number of records.
Each of the tables has the ~ before the number of records.
ie, this example;

en_products ~480,046

Also, If I refresh the PHPMyAdmin I notice that all 4 INNO DB Tables change their actual values. I can hit refresh multiple times and the number of records literally shows a different number with each refresh.

Any ideas?

[mariushm]

That means the result you see is an approximation, which is a number determined by phpMyAdmin very fast, without scanning the table itself.

If you wish to see the exact number, you need to run something like this: SELECT COUNT(*) FROM table_name;

[Mr X]

It's an estimation.

Edit: I was too slow.

[php4ever]

So this isn't bad then. I notice my DB is very very fast now but the numbers had me worried.

[streaky81]

Being MVCC at any given time the answer could be one of a bunch of different numbers anyways.. COUNT() or not.

[No1Resource]

As the others have stated, this is completely normal.

http://wiki.phpmyadmin.net/pma/FAQ_3.11

[php4ever]

excellent thanks