https://bugzilla.wikimedia.org/show_bug.cgi?id=52777
--- Comment #1 from MZMcBride <[email protected]> --- Thank you for researching this. (In reply to comment #0) > Sampling 1000 users with user_id<10M, we find that the main culprits are: > > searchNs-1 : 968 users > skin: 964 users > thumbsize: 912 users > > 75% of the skin rows have an empty string as their value, which causes > Skin::newFromKey() to return the default skin, same as if the row was > missing. The rest are mostly "monobook", presumably manually set via the > UsabilityInitiative OptIn extension. I've filed bug 52778 to track the skin issue, as I think it's more complex than the other two issues mentioned and I think it should be resolved with a maintenance script to allow third-party MediaWiki users to clean up their own databases. > "searchNs-1" is a bug, it relates to searching the special namespace, which > is not possible. It is "0" in all sampled rows. > > "thumbsize" is "3" in all sampled rows, which is not the default, the default > is "4" on all WMF wikis other than svwiki. In addition to bloat of the > user_properties table, this causes fragmentation of the parser cache. There's > no way 91% of users prior to 2009 manually set this value, it must have been > set by a bug. I'm not sure correcting these database table row anomalies will require a maintenance script. The cleanup for "searchNs-1" and "thumbsize" can probably be done with a simple query across all.dblist. However, if a maintenance script is needed for either of these, separate bugs should be filed as dependencies of this bug. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
