Profiling/Live aggregate 20040617
The backup running on en at the time is thought to have contributed to the very slow query times.
+------------------------------------------------------------------------+------------+-------+--------------------+---------------------+
| name | total | count | each | percent |
+------------------------------------------------------------------------+------------+-------+--------------------+---------------------+
| -total | 486293 | 172 | 2827.2843386628 | 100 |
| Parser::internalParse | 219051 | 108 | 2028.2526041667 | 45.045131943049 |
| Article::view | 200254 | 101 | 1982.713490099 | 41.179721095304 |
| LinkCache::addLinkObj | 187501 | 1236 | 151.70017951052 | 38.557301466908 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 186961 | 1236 | 151.26291970065 | 38.44616410133 |
| Parser::parse | 159643 | 73 | 2186.8953339041 | 32.828642434058 |
| wfMsg | 154019 | 9192 | 16.755731886423 | 31.671999636536 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 129263 | 4928 | 26.230303875812 | 26.581292023525 |
| Parser::replaceInternalLinks | 106818 | 216 | 494.52564380787 | 21.965679056726 |
| OutputPage::output | 103251 | 174 | 593.39646192529 | 21.232262088956 |
| Parser::replaceVariables | 86072.2 | 698 | 123.31260073424 | 17.699660884679 |
| PageHistory::history | 68797 | 11 | 6254.2698863636 | 14.147228525401 |
| Setup.php | 50057 | 175 | 286.04011160714 | 10.293594434116 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 34306.8 | 11 | 3118.7972301136 | 7.0547542623649 |
| ParserCache::get | 28478.3 | 98 | 290.59462691327 | 5.8561975861642 |
| Skin::makeLink | 26896.6 | 251 | 107.15787630727 | 5.530951944279 |
| Setup.php-MessageCache | 26164.7 | 175 | 149.51237723214 | 5.3804334135555 |
| Article::getContent | 14395.4 | 76 | 189.41375411184 | 2.9602416830443 |
| Setup.php-misc | 13893.9 | 175 | 79.393900669643 | 2.8571119254708 |
| LinkCache::preFill | 12720.3 | 63 | 201.90969122024 | 2.6157713557795 |
| Parser::tidy | 9350.59 | 73 | 128.0903119649 | 1.9228314156469 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 8848.02 | 85 | 104.09438189338 | 1.8194841724442 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X' | 8765.8 | 144 | 60.873582628038 | 1.8025753174222 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 7921.39 | 139 | 56.988428788219 | 1.6289342286828 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 7145.62 | 59 | 121.1121805482 | 1.4694063105807 |
| -overhead-total | 6407.09 | 53632 | 0.11946386369145 | 1.3175363767709 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 5486.18 | 60 | 91.436385091146 | 1.128164329555 |
| query: COMMIT | 5182.51 | 128 | 40.488342285156 | 1.0657173374098 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 4614.34 | 63 | 73.243489583333 | 0.94888076392745 |
| Title::secureAndSplit | 4405.8 | 12536 | 0.35145192003281 | 0.90599743753331 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 4233.14 | 44 | 96.207652698864 | 0.87049115139133 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X' | 4227 | 1 | 4226.9956054688 | 0.86922830893521 |
| Skin::outputPage | 4225.52 | 6 | 704.25358072917 | 0.86892517453312 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 4055.13 | 7 | 579.30472237723 | 0.83388694437502 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 3712.8 | 31 | 119.76759387601 | 0.76348952708093 |
| Skin::doAfterContent | 3635.17 | 6 | 605.86218261719 | 0.74752747757219 |
| Parser::replaceExternalLinks | 3299.89 | 108 | 30.554581253617 | 0.67858172162893 |
| Skin::doAfterContent-3 | 3232.92 | 7 | 461.84594726562 | 0.66480953954063 |
| -overhead-internal | 3163.46 | 53632 | 0.058984592592517 | 0.65052597503768 |
| Setup.php-includes | 3115.22 | 175 | 17.801234654018 | 0.64060487504862 |
| main-misc-setup | 3063.77 | 175 | 17.507248883929 | 0.63002534384337 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat | 2848.75 | 13 | 219.13433368389 | 0.58580873816533 |
| Setup.php-OutputPage | 2270.39 | 175 | 12.973681640625 | 0.46687793671869 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu | 2118.7 | 1 | 2118.6987304688 | 0.43568365962952 |
| query: SHOW COLUMNS FROM cur LIKE 'X'; | 2022.97 | 161 | 12.565019500922 | 0.4159978715808 |
| Title::newFromText | 1871.15 | 10752 | 0.17402764729091 | 0.38477741287674 |
| Parser::doBlockLevels | 1797.53 | 73 | 24.623740836366 | 0.36963999637918 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 1704.86 | 24 | 71.035842895508 | 0.35058299382548 |
| Skin::makeKnownLinkObj | 1697.61 | 5520 | 0.3075372889422 | 0.34909121912797 |
| LinksUpdate::doUpdate | 1664.83 | 1 | 1664.8330078125 | 0.34235190076094 |
| Setup.php-memcached | 1624.6 | 174 | 9.3368046201509 | 0.33407931372765 |
| Setup.php-User | 1524.09 | 175 | 8.7091078404018 | 0.31341067337856 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 1367.08 | 33 | 41.426694927794 | 0.28112294361012 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 1169.6 | 7 | 167.08621651786 | 0.24051420462706 |
| query: BEGIN | 861.789 | 128 | 6.732723236084 | 0.17721594601582 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 854.135 | 4 | 213.53372192383 | 0.17564206195848 |
| Skin::doBeforeContent | 812.477 | 8 | 101.55965423584 | 0.16707569109985 |
| query: SELECT N FROM user_newtalk WHERE user_id=N | 729.451 | 2 | 364.72546386719 | 0.15000237888713 |
| query: DELETE FROM brokenlinks WHERE bl_from=N AND bl_to IN('X') | 623.89 | 1 | 623.88970947266 | 0.12829504635051 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie | 619.124 | 1 | 619.12371826172 | 0.12731498039649 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N,N,N,N) | 600.62 | 1 | 600.61981201172 | 0.12350988556328 |
| Setup.php-language | 512.535 | 175 | 2.9287723214286 | 0.10539638758097 |
| Setup.php-SetupSession | 499.402 | 174 | 2.8701250799771 | 0.10269567116804 |
| Skin::doAfterContent-4 | 463.133 | 6 | 77.188898722331 | 0.095237538195939 |
| Skin::quickBar | 462.531 | 6 | 77.088521321615 | 0.095113690120724 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N | 423.212 | 31 | 13.651988367881 | 0.087028133449005 |
| Parser::removeHTMLtags | 403.39 | 108 | 3.7350918805158 | 0.082952047605713 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N | 353.971 | 1 | 353.97061157227 | 0.072789589776638 |
| query: SELECT user_id FROM user WHERE user_name='X' | 323.591 | 2 | 161.79566955566 | 0.066542475728604 |
| Parser::doAllQuotes | 305.958 | 108 | 2.8329467773438 | 0.062916453853397 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 283.53 | 7 | 40.504250662667 | 0.05830431638929 |
| query: INSERT INTO links (l_from,l_to) VALUES (N,N) | 259.844 | 1 | 259.84381103516 | 0.053433600962621 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat | 231.173 | 1 | 231.17333984375 | 0.047537880333567 |
| Skin::makeBrokenLinkObj | 226.89 | 358 | 0.63377158735051 | 0.046657112484146 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 138.763 | 3 | 46.254282633464 | 0.028534828725026 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user | 107.963 | 2 | 53.981548309326 | 0.022201248513206 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time | 98.8172 | 1 | 98.817222595215 | 0.020320514925302 |
| Setup.php-DateFormatter | 94.0433 | 175 | 0.53739031110491 | 0.019338818895913 |
| Setup.php-database | 82.2654 | 175 | 0.47008823939732 | 0.016916850078878 |
| Setup.php-extensions | 82.0105 | 175 | 0.46863159179688 | 0.01686443036911 |
| query: UPDATE cur SET cur_text='X' | 77.0099 | 1 | 77.009910583496 | 0.015836116380424 |
| query: DELETE FROM imagelinks WHERE il_from='X' | 62.989 | 1 | 62.988994598389 | 0.01295289192765 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X' | 58.8288 | 1 | 58.828826904297 | 0.012097405935437 |
| query: DELETE FROM categorylinks WHERE cl_from='X' | 56.874 | 1 | 56.874034881592 | 0.011695427622042 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 55.208 | 1 | 55.20796585083 | 0.011352821548758 |
| Parser::doHeadings | 43.2138 | 108 | 0.40012758749503 | 0.0088863684610787 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X' | 42.6197 | 1 | 42.619701385498 | 0.0087642038034558 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 39.593 | 1 | 39.592979431152 | 0.008141796625509 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 32.8438 | 1 | 32.843826293945 | 0.0067539184454113 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N | 27.5314 | 1 | 27.531368255615 | 0.0056614784838053 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 27.5185 | 2 | 13.759243965149 | 0.0056588298074311 |
| Skin::initPage | 25.9103 | 138 | 0.18775552943133 | 0.0053281186561671 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 22.5778 | 1 | 22.577758789062 | 0.0046428312029408 |
| Parser::replaceInternalLinks-setup | 20.5768 | 216 | 0.095263004302979 | 0.0042313611128156 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o | 18.5701 | 1 | 18.570056915283 | 0.0038186978828222 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= | 17.6002 | 1 | 17.600170135498 | 0.0036192529048429 |
| Setup.php-BlockCache | 2.0142 | 175 | 0.011509700502668 | 0.0004141943182966 |
| Skin::doAfterContent-2 | 0.316657 | 7 | 0.04523669396128 | 6.5116487133408e-05 |
| Skin::doAfterContent-1 | 0.00992367 | 8 | 0.0012404582230374 | 2.0406766491464e-06 |
| Parser::replaceInternalLinks-prefixhandling | -85.029 | 4192 | -0.020283628056068 | -0.017485134518356 |
+------------------------------------------------------------------------+------------+-------+--------------------+---------------------+