xtech Posted July 1, 2017 Share Posted July 1, 2017 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? Link to comment Share on other sites More sharing options...
newbie LAC Posted July 2, 2017 Share Posted July 2, 2017 Hello, 8 hours ago, xtech said: 31880 members. This is correct. Link to comment Share on other sites More sharing options...
SJ77 Posted July 8, 2017 Share Posted July 8, 2017 how can one run a recount? Link to comment Share on other sites More sharing options...
newbie LAC Posted July 8, 2017 Share Posted July 8, 2017 2 hours ago, superj707 said: how can one run a recount? Not sure what you mean Link to comment Share on other sites More sharing options...
CP_User Posted July 8, 2017 Share Posted July 8, 2017 I don't think you can, as this would mess up your member ID surely? Link to comment Share on other sites More sharing options...
opentype Posted July 8, 2017 Share Posted July 8, 2017 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. Link to comment Share on other sites More sharing options...
Stuart Silvester Posted July 8, 2017 Share Posted July 8, 2017 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.