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

[Jake Bunce]

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:





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

SELECT COUNT(*)
FROM xf_post

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:

 

[Luke F]

InnoDB can only provide a rough value without a full table scan