User:Yurik/Query API Performance

6/20/2006 7:55:34 AM							6/24/2006 9:02:01 PM							7/1/2006 2:23:27 AM
Perf	Count	Avg	Change	Req/Day	DaySrvLoad		Perf	Count	Avg	Change	Req/Day	DaySrvLoad		Perf	Count	Avg	Change	Req/Day	DaySrvLoad
_db_total	1584136	37	-1	254,273	9,408s		_db_total	1250666	37	0	275,105	10179		_db_total	1723677	37	0	276,975	10248
_db_revisions	754221	41	3	121,062	4,964s		_db_revisions	611910	42	1	134,600	5653		_db_revisions	788118	44	2	126,642	5572
_db_imagelinks	332175	43	1	53,318	2,293s		_db_imagelinks	246409	41	-2	54,202	2222		_db_imagelinks	334282	41	0	53,715	2202
_db_usercontribs	255962	30	3	41,085	1,233s		_db_usercontribs	207206	30	0	45,578	1367		_db_usercontribs	324473	29	-1	52,139	1512
_db_pageInfo	1573915	2	1	252,632	505s		_db_category	138811	15	1	30,534	458		_db_category	190112	13	-2	30,549	397
_db_category	176786	14	1	28,376	397s		_db_pageInfo	1242752	1	-1	273,364	273		_db_pageInfo	1699090	1	0	273,024	273
_db_recentchanges	54220	5	0	8,703	44s		_db_recentchanges	38793	4	-1	8,533	34		_db_recentchanges	71020	3	-1	11,412	34
_db_backlinks	907	64	38	146	9s		_db_langlinks	1273	13	4	280	4		_db_backlinks	507	323	-527	81	26
_db_embeddedin	11	2931		2	6s		_db_content	412	18	3	91	2		_db_embeddedin	31	3428	3335	5	17
_db_nolanglinks	78	234	-269	13	3s		_db_backlinks	6	850	786	1	1		_db_content	1473	25	7	237	6
_db_langlinks	1327	9		213	2s		_db_allpages	103	2	0	23	0		_db_nolanglinks	449	55	-284	72	4
_db_content	481	15	-15	77	1s		_db_embeddedin	1	93	-2838	0	0		_db_langlinks	642	17	4	103	2
_db_allpages	131	2	-2	21	0s		_db_imageinfo	2	1	-1	0	0		_db_allpages	235	3	1	38	0
_db_imageinfo	22	2		4	0s		_db_links	28	14	4	6	0		_db_imageinfo	4	1	0	1	0
_db_links	48	10	-2	8	0s		_db_nolanglinks	1	339	105	0	0		_db_links	35	11	-3	6	0
_db_permissions	1	2	0	0	0s		_db_permissions	3	1	-1	1	0		_db_permissions	2	1	0	0	0
_db_redirects	76	13		12	0s		_db_redirects	135	11	-2	30	0		_db_redirects	67	16	5	11	0
_db_templates	17	21	9	3	0s		_db_templates	26	13	-8	6	0		_db_templates	31	6	-7	5	0
_db_users	6	10		1	0s		_db_users	5	3	-7	1	0		_db_users	2	20	17	0	0
grandTotal	1582453	152		254,003	38,608s		grandTotal	1250656	160	8	275,102	44016		grandTotal	1723632	154	-6	276,968	42653
total	1584136	106	6	254,273	26,953s		total	1250666	109	3	275,105	29986		total	1723677	106	-3	276,975	29359
startup	1582453	65		254,003	16,510s		startup	1250656	69	4	275,102	18982		startup	1723632	65	-4	276,968	18003
revisions	754221	42	4	121,062	5,085s		revisions	611910	43	1	134,600	5788		revisions	788118	44	1	126,642	5572
imagelinks	332175	45	3	53,318	2,399s		imagelinks	246409	43	-2	54,202	2331		imagelinks	334282	43	0	53,715	2310
usercontribs	255962	30	3	41,085	1,233s		usercontribs	207206	30	0	45,578	1367		usercontribs	324473	30	0	52,139	1564
pageInfo	1583818	4	1	254,222	1,017s		pageInfo	1250426	4	0	275,052	1100		pageInfo	1723284	4	0	276,912	1108
category	176786	18	2	28,376	511s		category	138811	19	1	30,534	580		category	190112	17	-2	30,549	519
recentchanges	54220	6	0	8,703	52s		recentchanges	38793	5	-1	8,533	43		recentchanges	71020	5	0	11,412	57
backlinks	907	66	39	146	10s		langlinks	1273	14	5	280	4		backlinks	507	324	-529	81	26
embeddedin	11	2938		2	6s		content	412	18	2	91	2		embeddedin	31	3467	3372	5	17
nolanglinks	78	240	-268	13	3s		backlinks	6	853	787	1	1		content	1473	25	7	237	6
langlinks	1327	9		213	2s		allpages	103	8	-1	23	0		nolanglinks	449	61	-283	72	4
content	481	16	-7	77	1s		embeddedin	1	95	-2843	0	0		langlinks	642	18	4	103	2
allpages	131	9	-3	21	0s		imageinfo	2	2	-1	0	0		allpages	235	10	2	38	0
grandrtup	1	133		0	0s		info	56	0	0	12	0		imageinfo	4	2	0	1	0
imageinfo	30	3		5	0s		links	28	19	7	6	0		info	314	0	0	50	0
info	37	0	0	6	0s		namespaces	3	0	0	1	0		links	35	15	-4	6	0
links	48	12	-3	8	0s		nolanglinks	1	344	104	0	0		namespaces	248	0	0	40	0
namespaces	6	0	0	1	0s		permissions	3	2	0	1	0		permissions	2	2	0	0	0
permissions	1	2	-7	0	0s		redirects	135	12	-2	30	0		redirects	67	16	4	11	0
redirects	76	14		12	0s		templates	26	14	-8	6	0		templates	31	7	-7	5	0
templates	17	22	10	3	0s		userinfo	169	5	-2	37	0		userinfo	167	6	1	27	0
userinfo	419	7	-1	67	0s		users	5	4	-11	1	0		users	2	21	17	0	0
users	6	15		1	0s