Approximate number of users on this entire site: Is incorrect

  • Resolved JoeLyons23

    (@joelyons23)


    2 years, 1 month ago

    We have 40,000 users on the site. However on the Index for Speed page under users it reports that we only have 7,209 users. Almost all users are subscribers. We are using WordPress Multisite (latest version)

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for letting me know about this.

    I retrieve the approximate number of users from the MySQL / MariaDB table metadata because COUNT(*) is *really* slow on big tables. That table metadata is imperfect. But, I’ve never seen it quite so wrong before. This is a sign that MySQL / MariaDB’s optimization statistics are stale. The database software uses those statistics to choose how to access your data efficiently.

    You can fix this with the https://www.ads-software.com/plugins/advanced-database-cleaner/ Advanced Database Cleaner plugin. Go to the second tab “Tables”.

    Check your wp_users table (and maybe your wp_usermeta table). Then choose Optimize from the Bulk Actions dropdown menu and Apply.

    If your site is super-busy you probably should do this at a low-traffic time.

    Optimizing tables may also help with your site’s performance.

    Plugin Author OllieJones

    (@olliejones)

    And, there’s a better way to get this user-count information fast from WordPress. The next version of the plugin will use that instead.

    Plugin Author OllieJones

    (@olliejones)

    Version 1,1,1 offers a more accurate result.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Approximate number of users on this entire site: Is incorrect’ is closed to new replies.