Profiling/Live aggregate 20040708
05:27, search index update script running. Whoa! What is that update cur_touched query!
+------------------------------------------------------------------------+-----------+-------+---------------------+---------------------+ | name | total | count | each | percent | +------------------------------------------------------------------------+-----------+-------+---------------------+---------------------+ | -total | 157172 | 168 | 935.54920014881 | 100 | | OutputPage::output | 54252.8 | 168 | 322.93305896577 | 34.518019887613 | | Article::view | 37530.7 | 99 | 379.09824810606 | 23.878720850182 | | LinksUpdate::doUpdate | 34937.3 | 4 | 8734.31640625 | 22.228645420406 | | query: UPDATE cur SET cur_touched='X' | 26016.5 | 7 | 3716.63671875 | 16.552829424323 | | Parser::internalParse | 23122.3 | 118 | 195.95130429025 | 14.711408411849 | | LinkCache::addLinkObj | 22596.7 | 1002 | 22.551572635978 | 14.377012185575 | | query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 22225.7 | 1002 | 22.181381377869 | 14.141008944704 | | Parser::parse | 22057.9 | 59 | 373.86245365466 | 14.034209329433 | | Setup.php | 17741.8 | 169 | 104.98109282544 | 11.288126831378 | | Parser::replaceInternalLinks | 11478.6 | 236 | 48.637989108845 | 7.3031748852399 | | Setup.php-MessageCache | 11265.3 | 169 | 66.658682738536 | 7.1674969741103 | | Parser::replaceVariables | 10804.4 | 644 | 16.777069281347 | 6.8742615462234 | | ParserCache::get | 9561.51 | 96 | 99.599090576172 | 6.0834604994023 | | PageHistory::history | 9177.81 | 4 | 2294.4521484375 | 5.8393308496599 | | query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu | 8724.6 | 1 | 8724.5966796875 | 5.5509772318888 | | wfMsg | 8550.33 | 7693 | 1.111442880297 | 5.4401010535315 | | query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 7656.83 | 4 | 1914.2065429688 | 4.8716140480812 | | LinkCache::preFill | 7100.56 | 51 | 139.22666781556 | 4.5176927560077 | | query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 4943.6 | 176 | 28.088609175249 | 3.1453355941555 | | query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie | 4365.47 | 4 | 1091.3685302734 | 2.7775091895089 | | query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 3965.37 | 279 | 14.212791743672 | 2.5229444143443 | | query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X' | 3871.47 | 1 | 3871.4731445312 | 2.4632037523517 | | query: COMMIT | 3869.63 | 119 | 32.517896123293 | 2.4620308317655 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 2933.18 | 5 | 586.63671875 | 1.8662221239136 | | query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 2817.65 | 5 | 563.52954101562 | 1.7927130425165 | | Skin::outputPage | 2801.4 | 10 | 280.13952636719 | 1.7823725149803 | | Setup.php-misc | 2775.35 | 169 | 16.422172591531 | 1.7657995556229 | | Parser::tidy | 2654.9 | 59 | 44.998253773835 | 1.6891637733279 | | -overhead-total | 2608.69 | 39172 | 0.066595849763942 | 1.6597665094281 | | query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 2542.49 | 49 | 51.887605628189 | 1.617647150196 | | Skin::makeLink | 2237.09 | 150 | 14.913924153646 | 1.423335481073 | | query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 2204.8 | 128 | 17.225034713745 | 1.4027948471646 | | query: DELETE FROM imagelinks WHERE il_from='X' | 2167.99 | 4 | 541.99627685547 | 1.3793687447342 | | Title::secureAndSplit | 2070.19 | 9174 | 0.22565813648797 | 1.3171457037337 | | query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VAL | 2036.69 | 3 | 678.896484375 | 1.2958325980898 | | query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 2033.77 | 67 | 30.354807383979 | 1.2939764446604 | | query: SELECT bl_from FROM brokenlinks WHERE bl_to='X' | 1996.24 | 4 | 499.06118774414 | 1.2700998761063 | | Article::getContent | 1699.33 | 67 | 25.363126384678 | 1.0811891404734 | | query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 1640.41 | 5 | 328.08234863281 | 1.0437030583232 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 1513.59 | 64 | 23.649845123291 | 0.96301346924776 | | query: SELECT N FROM user_newtalk WHERE user_ip='X' | 1458.91 | 128 | 11.397723197937 | 0.9282226501823 | | Parser::replaceExternalLinks | 1428.43 | 118 | 12.105339438228 | 0.90883086022254 | | query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 1336.2 | 54 | 24.744427716291 | 0.85014941495324 | | -overhead-internal | 1320.64 | 39172 | 0.033713911912128 | 0.84025088788426 | | query: UPDATE cur SET cur_text='X' | 1212.46 | 4 | 303.11529541016 | 0.77142183884621 | | query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X') | 1201.04 | 3 | 400.34631347656 | 0.76415449993911 | | Title::newFromText | 1183.92 | 7402 | 0.15994594999662 | 0.75326261740079 | | Setup.php-includes | 1157.39 | 169 | 6.8484724597818 | 0.73638427307816 | | query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 1014.32 | 71 | 14.286217917859 | 0.64535652529693 | | Setup.php-memcached | 962.443 | 169 | 5.6949278701692 | 0.61234900841533 | | query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 845.367 | 43 | 19.659692098928 | 0.53786000786607 | | query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N),(N,N) | 788.434 | 1 | 788.43444824219 | 0.50163713369337 | | main-misc-setup | 774.026 | 169 | 4.5800333418084 | 0.49246960440997 | | query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 769.666 | 4 | 192.4165802002 | 0.4896960145864 | | Skin::makeKnownLinkObj | 750.686 | 3194 | 0.23503016290921 | 0.4776201051419 | | query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link | 731.384 | 11 | 66.489490855824 | 0.46533935011097 | | query: DELETE FROM categorylinks WHERE cl_from='X' | 718.412 | 4 | 179.60307312012 | 0.45708591755911 | | Parser::doBlockLevels | 639.105 | 59 | 10.832296080508 | 0.40662738187846 | | Skin::doAfterContent | 588.647 | 8 | 73.580894470215 | 0.37452355440761 | | Skin::doBeforeContent | 582.042 | 8 | 72.755187988281 | 0.37032074430673 | | query: SHOW COLUMNS FROM cur LIKE 'X'; | 535.564 | 162 | 3.3059526608314 | 0.34074989561613 | | query: SELECT math_outputhash,math_html_conservativeness,math_html,mat | 488.289 | 39 | 12.520226894281 | 0.3106711269544 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 473.003 | 43 | 11.000061035156 | 0.30094534976054 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 456.162 | 10 | 45.61618347168 | 0.29023048875885 | | Setup.php-language | 433.478 | 169 | 2.5649578387921 | 0.27579794248821 | | query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t | 373.976 | 3 | 124.65855916341 | 0.23793999278633 | | Setup.php-User | 355.194 | 169 | 2.1017398269924 | 0.22599027210639 | | Skin::doAfterContent-3 | 335.401 | 8 | 41.925170898438 | 0.21339729745179 | | query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 307.16 | 7 | 43.879978724888 | 0.1954287862765 | | Setup.php-SetupSession | 301.331 | 169 | 1.7830248951207 | 0.19172034332975 | | query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 282.651 | 4 | 70.66276550293 | 0.1798352024053 | | Skin::doAfterContent-4 | 251.016 | 8 | 31.377052307129 | 0.15970783233216 | | Skin::quickBar | 250.352 | 8 | 31.294055938721 | 0.15928538442468 | | query: SELECT user_id FROM user WHERE user_name='X' | 210.968 | 7 | 30.138301304408 | 0.13422731312801 | | query: BEGIN | 192.133 | 120 | 1.601110458374 | 0.12224373953055 | | query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 185.304 | 10 | 18.530351257324 | 0.11789835301819 | | DifferenceEngine::showDiffPage | 162.789 | 1 | 162.78889465332 | 0.10357354970101 | | Parser::doAllQuotes | 157.698 | 118 | 1.3364253933147 | 0.100334620605 | | Parser::removeHTMLtags | 156.647 | 118 | 1.3275172346729 | 0.099665824036127 | | Setup.php-OutputPage | 143.939 | 169 | 0.85171102489945 | 0.091580510489958 | | query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N | 98.6633 | 1 | 98.663314819336 | 0.062773997961408 | | Skin::makeBrokenLinkObj | 90.2314 | 439 | 0.20553847814747 | 0.057409232823571 | | Setup.php-extensions | 84.5515 | 169 | 0.50030458890475 | 0.053795416887758 | | Setup.php-DateFormatter | 77.4082 | 169 | 0.458036750026 | 0.049250553490833 | | query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 72.5571 | 4 | 18.139274597168 | 0.04616405960692 | | query: SELECT * FROM ipblocks WHERE ipb_user=N | 70.0395 | 41 | 1.708280795958 | 0.044562259350123 | | query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 52.0023 | 5 | 10.400453948975 | 0.033086161568063 | | query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 46.9388 | 4 | 11.73469543457 | 0.029864544836602 | | Setup.php-database | 43.1477 | 169 | 0.25531188693978 | 0.027452495337676 | | Parser::doHeadings | 41.0097 | 118 | 0.3475399017334 | 0.026092204143947 | | Parser::replaceInternalLinks-setup | 29.2905 | 236 | 0.12411240399894 | 0.018635938870815 | | Skin::initPage | 18.9498 | 124 | 0.15282135625039 | 0.012056737936362 | | query: SELECT N FROM user_newtalk WHERE user_id=N | 17.9547 | 3 | 5.9849122365316 | 0.011423603673458 | | query: SELECT user_name,user_password,user_newpassword,user_email,user | 16.1835 | 3 | 5.3945083618164 | 0.010296679901568 | | Setup.php-BlockCache | 3.02617 | 169 | 0.017906310290275 | 0.0019253819540125 | | query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 2.43826 | 3 | 0.81275224685669 | 0.0015513276027894 | | query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ | 1.56191 | 1 | 1.5619134902954 | 0.00099375897146002 | | query: DELETE FROM linkscc WHERE lcc_pageid='X' | 1.47522 | 4 | 0.36880585551262 | 0.0009386028865743 | | Parser::replaceInternalLinks-prefixhandling | 1.38533 | 2419 | 0.00057268689712644 | 0.00088140843337726 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 1.24768 | 1 | 1.2476778030396 | 0.00079382822285988 | | Skin::doAfterContent-2 | 0.408226 | 8 | 0.051028233021498 | 0.00025973148796237 | | Skin::doAfterContent-1 | 0.0670489 | 8 | 0.0083811096847057 | 4.2659483981493e-05 | +------------------------------------------------------------------------+-----------+-------+---------------------+---------------------+