Recount members - where/how?

[xtech]

Hi,

i have a community site from 2002 that has always been an IPS community. After so many updates since the first IPS version, some things got odd, such as some inconsistencies. One of them is the number of members. When i run a SELECT COUNT(*) on the members table, i get 31880 members.

In the ACP, in the tables lists, it shows:

core_members     30028     InnoDB 

Which one is right? Is there any hidden recount feature so that i can be sure of how many members i have?

[newbie LAC]

Hello,

8 hours ago, xtech said:

31880 members.

This is correct.

[SJ77]

how can one run a recount?

[newbie LAC]

2 hours ago, superj707 said:

how can one run a recount?

Not sure what you mean

[CP_User]

I don't think you can, as this would mess up your member ID surely?

[opentype]

I guess there is a misunderstanding – based on the assumption that the software keeps a member count somewhere independent from the actual table entries and in that case there could be an option to count the actual members again and update the number kept separately. I don’t think it works that way though. There is no recount function since there is no need for it. 

[Stuart Silvester]

This is just how InnoDB works, it doesn't keep track of exactly how many rows are in the table, it makes an estimate.

Quote

Rows

The number of rows. Some storage engines, such as MyISAM, store the exact count. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. In such cases, use SELECT COUNT(*) to obtain an accurate count.

https://dev.mysql.com/doc/refman/5.5/en/show-table-status.html