Admin tools development/SUL Audit/Metrics 20130417

From MediaWiki.org
Jump to navigation Jump to search

The following numbers are based on static dumps of all wikis from 2013/04/17, 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 55,277,895 10,844,466 17,962,609 18,974,457 19,788,432 20,662,830 21,452,744 23,176,411 24,484,443 27,197,478 30,030,437 33,061,157 50,711,356 L
attached accounts 50,853,079 10,090,826 16,808,201 17,783,829 18,567,081 19,410,030 20,168,812 21,812,125 23,049,130 25,600,567 28,266,141 31,122,781 46,566,939 LA
non-attached accounts 4,424,816 752,136 1,154,302 1,190,517 1,221,255 1,252,694 1,283,860 1,364,245 1,435,264 1,596,805 1,764,254 1,938,329 4,144,363 LU
… with e-mail 3,566,011 534,315 803,142 835,198 862,104 889,108 916,197 986,725 1,049,463 1,192,035 1,339,659 1,492,929 3,317,581 LUE
… who do not clash with another account 313 78 125 126 190 193 196 212 238 246 246 248 310 LUN
… who clash with a global account 124,582 36,948 50,842 51,652 52,480 53,377 54,399 56,385 57,467 59,397 64,297 70,657 114,379 LUG
… global clash but appear to be merge-able - - - - - - - - - - - - - LUGM
… who clash with 1 or more local accounts 4,379,164 741,286 1,140,456 1,176,173 1,206,316 1,237,124 1,267,535 1,346,576 1,417,151 1,578,124 1,742,340 1,911,948 4,105,206 LUL
… local clash but appear to be merge-able 822,608 127,041 220,315 227,391 233,329 238,788 243,973 257,318 268,759 292,320 317,010 340,387 790,946 LULM
Global accounts total 27,347,859 - - - - - - - - - - - - G
… who clash with 1 or more local accounts - - - - - - - - - - - - - GL
… who do not clash with local accounts - - - - - - - - - - - - - GN