I am running a request on a table of records with phpmyadmin, and the results count varies. For example, when showing the results it says "Showing records 1 - (~180,234 )".
This number changes each time I refresh, and no data is being added or removed.
When I do a SQL request for the record, the result stays the same. Is this an issue with phpMyAdmin?
Asked
Active
Viewed 5,316 times
7
Dharman
- 26,923
- 21
- 73
- 125
Designer023
- 1,782
- 1
- 25
- 40
-
What storage engine are you using? Can you drop in your schema for that table? – JamesHalsall Feb 14 '11 at 14:49
-
The engin I am using is MyISAM. I can't put the schema on as it is something which i'm not allowed to share unfortunately. – Designer023 Feb 14 '11 at 14:53
-
Are you certain the engine is not InnoDB for that specific table? Also, does this issue affect all tables in the database, or only certain ones? – Chris Baker Feb 14 '11 at 15:02
-
Use `SHOW CREATE TABLE tbl_name` and then check the engine at the end of the returned create string. – JamesHalsall Feb 14 '11 at 15:06
-
Ah yes you are right. My bad! – Designer023 Feb 14 '11 at 15:09
1 Answers
8
For InnoDB tables, from phpMyAdmin's FAQ:
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://docs.phpmyadmin.net/en/latest/config.html?highlight=maxexactcount#cfg_MaxExactCount
Roni
- 3,246
- 3
- 19
- 27
Chris Baker
- 48,371
- 12
- 98
- 115