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: