Admin tools development/SUL Audit/Metrics 20130315

The following numbers are based on static dumps of all wikis from 2013/03/15, 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 …
			1mo	2mo	3mo	4mo	5mo	6mo	9mo	12mo	18mo	24mo	30mo	36mo
Local accounts	total	54,198,377	7,648,878	9,123,939	10,299,704	11,545,854	12,652,651	13,547,083	15,814,906	17,843,964	21,905,645	25,293,304	28,892,101	49,263,580
	attached accounts	39,150,667	6,855,298	8,271,373	9,389,564	10,575,563	11,637,797	12,480,472	14,620,109	16,509,664	20,285,066	23,370,389	26,668,163	34,665,382
	non-attached accounts	15,047,702	742,646	815,976	875,891	933,846	989,056	1,039,421	1,174,877	1,314,077	1,602,817	1,908,554	2,209,775	14,582,053
	non-attached accounts, with e-mail	11,184,787	480,274	543,942	595,580	645,384	692,919	735,763	850,603	968,926	1,215,401	1,475,717	1,733,459	10,821,581
	… who do not clash with another account	10,642,704	336,340	361,361	382,570	402,734	420,400	436,263	481,066	528,077	620,525	729,246	828,661	10,474,862
	… who clash with a global account	121,035	13,435	14,565	15,629	16,693	18,009	19,234	23,136	26,024	30,718	37,112	44,179	109,027
	… who clash with 1 or more local accounts	4,360,291	403,411	451,100	489,182	526,309	563,013	596,628	684,384	774,750	968,265	1,161,147	1,358,436	4,069,605
	… local clash but appear to be merge-able	822,261	92,227	101,768	109,252	115,879	122,106	127,564	142,124	155,987	182,461	210,049	236,028	789,390
Global accounts	total	16,375,981	-	-	-	-	-	-	-	-	-	-	-	-
	… who clash with 1 or more local accounts	-	-	-	-	-	-	-	-	-	-	-	-	-
	… who do not clash with local accounts	-	-	-	-	-	-	-	-	-	-	-	-	-