Admin tools development/SUL Audit/Metrics 20130506

The following numbers are based on static dumps of all wikis from 2013/05/06, and slaved centralauth; consequently the numbers won't add up perfectly.

The following data is using the user_touched field in the user tables. This is not a particularly accurate number, but is conservative when it exists.

Group Total Accounts touched in last … Group name
1mo 2mo 3mo 4mo 5mo 6mo 9mo 12mo 18mo 24mo 30mo 36mo
Local accounts total 56,005,516 3,483,786 15,605,798 19,054,133 20,034,383 20,835,395 21,696,459 23,600,069 24,946,078 27,630,071 30,456,283 33,494,327 51,119,876 L
attached accounts 51,883,291 3,344,173 14,753,485 17,929,187 18,877,035 19,651,855 20,484,231 22,309,382 23,590,537 26,127,695 28,797,533 31,675,270 47,278,470 LA
non-attached accounts 4,122,225 139,220 852,017 1,124,927 1,157,329 1,183,517 1,212,210 1,290,668 1,355,531 1,502,361 1,658,737 1,819,039 3,841,391 LU
… with e-mail - - - - - - - - - - - - - LUE
… who do not clash with another account 69 64 65 66 67 67 67 67 67 67 67 67 68 LUN
… who clash with a global account 114,604 5,934 39,035 48,945 49,825 50,613 51,474 53,945 54,966 56,877 60,240 64,544 106,180 LUG
… global clash but appear to be merge-able - - - - - - - - - - - - - LUGM
… who clash with 1 or more local accounts 4,085,049 136,836 840,133 1,111,379 1,143,142 1,168,831 1,196,910 1,273,597 1,338,087 1,484,375 1,639,012 1,796,825 3,808,727 LUL
… local clash but appear to be merge-able 76,694 2,155 9,300 11,286 12,166 12,910 13,598 15,451 16,918 19,961 23,053 25,981 72,344 LULM
Global accounts total 27,655,712 - - - - - - - - - - - - G
… who clash with 1 or more local accounts - - - - - - - - - - - - - GL
… who do not clash with local accounts - - - - - - - - - - - - - GN