• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

phpmyadmin - row count changes every time I "Browse" xf_post

Jake Bunce

XenForo moderator
Staff member
#1
This confused me when I was trying to confirm the number of post records following my import. Phpmyadmin keeps reporting different row counts for xf_post. And I noticed it is using a tilda (~) which indicates an approximation:

Screen shot 2011-03-24 at 5.10.08 PM.png
Screen shot 2011-03-24 at 5.10.33 PM.png
Screen shot 2011-03-24 at 5.10.43 PM.png

But if I run this query it always returns the same number:

Code:
SELECT COUNT(*)
FROM xf_post
Screen shot 2011-03-24 at 5.11.52 PM.png

My vB database doesn't do this. I am guessing it's related to the InnoDB table type in xenForo?

Another interesting thing is that not all tables do this. Only the large tables show approximate counts:

Screen shot 2011-03-24 at 5.20.13 PM.png