1. 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

Discussion in 'Troubleshooting and Problems' started by Jake Bunce, Mar 25, 2011.

  1. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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:

    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
    Fuhrmann likes this.
  2. Luke F

    Luke F Well-Known Member

    InnoDB can only provide a rough value without a full table scan
    Fuhrmann likes this.

Share This Page