User:Yurik/Query API Performance
From Wikipedia, the free encyclopedia
| 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 |
