User:Yurik/Query API Performance

7/1/2006 2:23:27 AM							7/23/2006 8:47:37 PM							8/23/2006 4:39:01 PM
Perf	Count	Avg	Change	Req/Day	DaySrvLoad		Perf	Count	Avg	Change	Req/Day	DaySrvLoad		Perf	Count	Avg	Change	Req/Day	DaySrvLoad
_db_total	1723677	37	0	276,975	10248		_db_total	6000113	54	17	263,547	14232		_db_total	4643821	48	-6	150,640	7231
_db_revisions	788118	44	2	126,642	5572		_db_revisions	2657646	53	9	116,733	6187		_db_revisions	2415964	39	-14	78,371	3056
_db_imagelinks	334282	41	0	53,715	2202		_db_imagelinks	1192744	69	28	52,390	3615		_db_category	595979	63	30	19,333	1218
_db_usercontribs	324473	29	-1	52,139	1512		_db_usercontribs	1177063	44	15	51,701	2275		_db_imagelinks	606758	59	-10	19,682	1161
_db_category	190112	13	-2	30,549	397		_db_pageInfo	5955301	4	3	261,579	1046		_db_usercontribs	534326	49	5	17,333	849
_db_pageInfo	1699090	1	0	273,024	273		_db_category	703830	33	20	30,915	1020		_db_pageInfo	4471402	2	-2	145,047	290
_db_recentchanges	71020	3	-1	11,412	34		_db_embeddedin	7754	319	-3109	341	109		_db_content	208088	29	9	6,750	196
_db_backlinks	507	323	-527	81	26		_db_backlinks	1492	1553	1230	66	102		_db_backlinks	10647	430	-1123	345	148
_db_embeddedin	31	3428	3335	5	17		_db_recentchanges	210967	8	5	9,266	74		_db_links	14873	297	285	482	143
_db_content	1473	25	7	237	6		_db_content	6512	20	-5	286	6		_db_embeddedin	16499	264	-55	535	141
_db_nolanglinks	449	55	-284	72	4		_db_langlinks	4730	30	13	208	6		_db_recentchanges	187392	5	-3	6,079	30
_db_langlinks	642	17	4	103	2		_db_nolanglinks	583	114	59	26	3		_db_categories	19147	41		621	25
_db_allpages	235	3	1	38	0		_db_templates	3325	15	9	146	2		_db_imageinfo_shrd	169884	4		5,511	22
_db_imageinfo	4	1	0	1	0		_db_allpages	2309	12	9	101	1		_db_imageinfo	176118	2	-4	5,713	11
_db_links	35	11	-3	6	0		_db_redirects	1248	21	5	55	1		_db_allpages	15029	8	-4	488	4
_db_permissions	2	1	0	0	0		_db_imageinfo	16	6	5	1	0		_db_langlinks	9896	8	-22	321	3
_db_redirects	67	16	5	11	0		_db_links	337	12	1	15	0		_db_nolanglinks	468	184	70	15	3
_db_templates	31	6	-7	5	0		_db_users	9	105	85	0	0		_db_templates	7898	3	-12	256	1
_db_users	2	20	17	0	0									_db_permissions	30	2		1	0
														_db_redirects	1107	13	-8	36	0
grandTotal	1723632	154	-6	276,968	42653		grandTotal	6000069	185	31	263,545	48756		_db_users	74	110	5	2	0
total	1723677	106	-3	276,975	29359		total	6000113	141	35	263,547	37160
startup	1723632	65	-4	276,968	18003		startup	6000069	82	17	263,545	21611		grandTotal	4643659	191	6	150,634	28771
revisions	788118	44	1	126,642	5572		revisions	2657646	54	10	116,733	6304		total	4643821	133	-8	150,640	20035
imagelinks	334282	43	0	53,715	2310		imagelinks	1192744	71	28	52,390	3720		startup	4643659	57	-25	150,634	8586
usercontribs	324473	30	0	52,139	1564		usercontribs	1177063	44	14	51,701	2275		revisions	2448906	79	25	79,439	6276
pageInfo	1723284	4	0	276,912	1108		pageInfo	5998915	7	3	263,494	1844		category	595979	70	32	19,333	1353
category	190112	17	-2	30,549	519		category	703830	38	21	30,915	1175		imagelinks	606758	61	-10	19,682	1201
recentchanges	71020	5	0	11,412	57		embeddedin	7754	336	-3131	341	115		usercontribs	534401	53	9	17,335	919
backlinks	507	324	-529	81	26		backlinks	1492	1563	1239	66	103		pageInfo	4641144	5	-2	150,553	753
embeddedin	31	3467	3372	5	17		recentchanges	210967	9	4	9,266	83		links	14873	575	558	482	277
content	1473	25	7	237	6		langlinks	4730	35	17	208	7		content	208088	29	9	6,750	196
nolanglinks	449	61	-283	72	4		content	6512	20	-5	286	6		backlinks	10647	436	-1127	345	150
langlinks	642	18	4	103	2		nolanglinks	583	120	59	26	3		embeddedin	16499	276	-60	535	148
allpages	235	10	2	38	0		templates	3325	18	11	146	3		recentchanges	187392	7	-2	6,079	43
imageinfo	4	2	0	1	0		allpages	2309	18	8	101	2		categories	19147	55		621	34
info	314	0	0	50	0		redirects	1248	23	7	55	1		allpages	15029	51	33	488	25
links	35	15	-4	6	0		userinfo	954	12	6	42	1		imageinfo_shrd	169884	4		5,511	22
namespaces	248	0	0	40	0		imageinfo	16	11	9	1	0		imageinfo	181558	2	-9	5,890	12
permissions	2	2	0	0	0		info	193	7	7	8	0		langlinks	9896	8	-27	321	3
redirects	67	16	4	11	0		links	337	17	2	15	0		nolanglinks	468	196	76	15	3
templates	31	7	-7	5	0		namespaces	62	0	0	3	0		templates	7898	5	-13	256	1
userinfo	167	6	1	27	0		users	9	106	85	0	0		info	758	9	2	25	0
users	2	21	17	0	0						0	0		namespaces	545	1	1	18	0
														permissions	31	2		1	0
														redirects	1107	13	-10	36	0
														userinfo	201999	0	-12	6,553	0
														users	74	112	6	2	0