Profiling/Live aggregate 20040712
This is the first profiling run with Ariel as the master. Ran for a few hours ending at 07:38.
+------------------------------------------------------------------------+------------+--------+---------------------+---------------------+ | name | total | count | each | percent | +------------------------------------------------------------------------+------------+--------+---------------------+---------------------+ | -total | 717285 | 1070 | 670.36022196262 | 100 | | Article::view | 265982 | 705 | 377.28014184397 | 37.081820722172 | | Parser::parse | 235264 | 468 | 502.70072115385 | 32.799207289079 | | Parser::internalParse | 178982 | 790 | 226.55990901899 | 24.952734123366 | | LinkCache::addLinkObj | 159821 | 7409 | 21.57115290525 | 22.281321147692 | | query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 156570 | 7409 | 21.132461364557 | 21.82818694824 | | Setup.php | 143706 | 1070 | 134.3042786215 | 20.034643199486 | | OutputPage::output | 137587 | 1070 | 128.5863317757 | 19.181676889962 | | Parser::replaceInternalLinks | 114789 | 1580 | 72.651137262658 | 16.003224222017 | | Setup.php-MessageCache | 76123 | 1070 | 71.142961448598 | 10.61264662159 | | Parser::tidy | 62980.6 | 468 | 134.5740100828 | 8.7804148008721 | | wfMsg | 57469.3 | 54173 | 1.0608477412641 | 8.012055129378 | | Parser::replaceVariables | 55413.8 | 4571 | 12.122902024995 | 7.7254858748265 | | ParserCache::get | 37318.9 | 682 | 54.719843979106 | 5.2028009551985 | | Title::secureAndSplit | 27496.8 | 72381 | 0.3798898688019 | 3.8334541810282 | | Setup.php-misc | 24842.4 | 1070 | 23.217160119743 | 3.4633857080258 | | -overhead-total | 23533.3 | 302774 | 0.077725478100002 | 3.280877134251 | | query: COMMIT | 18879.4 | 1469 | 12.851860321647 | 2.6320599618335 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 18804.2 | 43 | 437.30736736919 | 2.6215807283659 | | DifferenceEngine::showDiffPage | 18412.1 | 10 | 1841.212890625 | 2.5669179860145 | | Setup.php-memcached | 17321.7 | 1070 | 16.188482038551 | 2.4148929945688 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 13654.7 | 86 | 158.7759583939 | 1.9036678716728 | | PageHistory::history | 13194.9 | 8 | 1649.3663330078 | 1.8395648334994 | | Parser::replaceExternalLinks | 13132.3 | 790 | 16.623108682753 | 1.8308270561223 | | query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 13092.3 | 905 | 14.466664148826 | 1.8252609589174 | | query: BEGIN | 12761.2 | 1469 | 8.6869808064585 | 1.7790929715742 | | Article::getContent | 12681.4 | 497 | 25.515909912601 | 1.7679722135112 | | Skin::makeLink | 11799.1 | 1529 | 7.716877989086 | 1.6449666797135 | | Setup.php-includes | 11414.8 | 1070 | 10.668013471086 | 1.5913852167203 | | -overhead-internal | 11405 | 302774 | 0.037668479238021 | 1.5900275589817 | | main-misc-setup | 11060.3 | 1070 | 10.336686806367 | 1.5419600488979 | | Title::newFromText | 10789.4 | 60181 | 0.17928213106608 | 1.5041958703766 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 10215.1 | 493 | 20.720245547033 | 1.4241305511918 | | LinkCache::preFill | 9731.39 | 398 | 24.450740028266 | 1.3566976300491 | | query: SELECT N FROM user_newtalk WHERE user_ip='X' | 9075.49 | 911 | 9.9621166643798 | 1.265254779587 | | query: SHOW COLUMNS FROM cur LIKE 'X'; | 9005.84 | 1033 | 8.7181459114835 | 1.2555454573219 | | Skin::makeKnownLinkObj | 8787.49 | 28719 | 0.30598169439221 | 1.2251033998233 | | query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 8240.74 | 347 | 23.748533749099 | 1.1488789232442 | | query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 7651.97 | 1116 | 6.8566045726927 | 1.0667957695886 | | Parser::doBlockLevels | 7131.4 | 468 | 15.238035022703 | 0.99422071295362 | | query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 6549.96 | 8 | 818.74499511719 | 0.91315947857055 | | query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 5847.17 | 970 | 6.0280137524162 | 0.81518082399989 | | Skin::outputPage | 4672.82 | 31 | 150.73624936996 | 0.651459445037 | | query: SELECT 'X' as type, cur_namespace as namespace, cur_title as ti | 4554.33 | 1 | 4554.3349609375 | 0.63494039092875 | | query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 4212.4 | 410 | 10.274136575838 | 0.587269136646 | | query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 3971.12 | 426 | 9.3218787824604 | 0.55363181150992 | | query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 3934.74 | 383 | 10.273462360273 | 0.5485593152007 | | Setup.php-User | 3606.23 | 1070 | 3.370307708455 | 0.50276069462889 | | Setup.php-language | 3602.29 | 1070 | 3.3666293990946 | 0.50221198824091 | | query: SELECT user_id FROM user WHERE user_name='X' | 3326.6 | 23 | 144.63482931386 | 0.46377646893448 | | Setup.php-SetupSession | 3111.6 | 1070 | 2.9080358772634 | 0.4338019742206 | | Skin::doAfterContent | 2895.93 | 24 | 120.66388956706 | 0.40373513781386 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 2207.85 | 197 | 11.207349748176 | 0.30780603996169 | | query: SELECT user_rights as type, N as namespace, user_name as title, | 1924.09 | 3 | 641.36238606771 | 0.26824567426174 | | Skin::doAfterContent-3 | 1612.43 | 24 | 67.184717814128 | 0.2247965932724 | | query: SELECT * FROM ipblocks WHERE ipb_user=N | 1519.33 | 159 | 9.5555458308766 | 0.21181690128895 | | Parser::doAllQuotes | 1372.84 | 790 | 1.7377745809434 | 0.19139408764943 | | Parser::removeHTMLtags | 1356.1 | 790 | 1.7165808569027 | 0.1890598646028 | | Skin::doAfterContent-4 | 1275.8 | 24 | 53.158320109049 | 0.17786499152469 | | Skin::quickBar | 1273.53 | 22 | 57.887584339489 | 0.1775481264345 | | query: UPDATE cur SET cur_text='X' | 1266.08 | 16 | 79.130249023438 | 0.17651048218513 | | query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 1226.73 | 151 | 8.1240565824193 | 0.1710243202791 | | query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 1215.43 | 17 | 71.49605066636 | 0.16944898052919 | | query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 1145.62 | 16 | 71.601432800293 | 0.15971646222146 | | query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X' | 1053.81 | 5 | 210.76127929687 | 0.14691590563406 | | Setup.php-OutputPage | 1002.13 | 1070 | 0.93657466139749 | 0.13971214739673 | | query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link | 898.147 | 10 | 89.81474609375 | 0.12521479093008 | | Skin::doBeforeContent | 827.28 | 24 | 34.469983418783 | 0.11533478289119 | | Skin::makeBrokenLinkObj | 685.818 | 3902 | 0.1757606338196 | 0.095612981570403 | | query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 655.341 | 53 | 12.364919986365 | 0.09136401284842 | | Setup.php-extensions | 644.339 | 1070 | 0.60218574310018 | 0.089830172401512 | | query: SELECT math_outputhash,math_html_conservativeness,math_html,mat | 607.751 | 6 | 101.29185994466 | 0.084729331991766 | | Setup.php-DateFormatter | 551.542 | 1070 | 0.51546003395152 | 0.076892992314252 | | query: DELETE FROM linkscc WHERE lcc_pageid='X' | 529.734 | 16 | 33.108352661133 | 0.073852557835893 | | query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 508.753 | 20 | 25.437669372559 | 0.070927605783321 | | query: SELECT img_size,img_description,img_user,img_user_text,img_time | 504.2 | 12 | 42.016682942708 | 0.070292824718402 | | query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 473.081 | 36 | 13.141142103407 | 0.065954373390253 | | Parser::replaceInternalLinks-prefixhandling | 438.336 | 22184 | 0.019759112473992 | 0.061110421069025 | | query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 425.53 | 16 | 26.59564781189 | 0.059325108630863 | | query: SELECT user_name FROM user WHERE (user_id=N) | 405.664 | 262 | 1.5483350680985 | 0.056555419451381 | | Parser::doHeadings | 327.788 | 790 | 0.4149215505093 | 0.045698407881359 | | Setup.php-database | 312.309 | 1070 | 0.29187739006827 | 0.043540380306835 | | Parser::replaceInternalLinks-setup | 262.922 | 1580 | 0.16640644314923 | 0.036655167724046 | | query: SELECT 'X' as type, rc_namespace AS namespace, rc_title AS titl | 254.005 | 1 | 254.0054473877 | 0.035412045764235 | | query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 235.025 | 22 | 10.68293207342 | 0.032765827009451 | | query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 231.725 | 3 | 77.241577148438 | 0.032305790600316 | | query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 229.068 | 20 | 11.453407287598 | 0.031935423999453 | | query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 224.956 | 20 | 11.247794342041 | 0.031362115425746 | | query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 205.999 | 3 | 68.666356404622 | 0.028719259926961 | | Skin::initPage | 165.444 | 888 | 0.18631063925253 | 0.023065273461132 | | query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat | 160.252 | 7 | 22.89321245466 | 0.022341522468539 | | query: SELECT oi_size AS img_size, oi_description AS img_description,o | 148.607 | 12 | 12.383895874023 | 0.020717937757977 | | query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 137.533 | 16 | 8.5957908630371 | 0.019174047961708 | | query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N | 107.34 | 3 | 35.77983601888 | 0.014964685248701 | | query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t | 105.81 | 6 | 17.634962717692 | 0.014751418441581 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 91.0001 | 10 | 9.1000076293945 | 0.012686731325693 | | query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= | 88.4268 | 12 | 7.3689002990723 | 0.012327979764523 | | query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges | 74.9266 | 2 | 37.463314056396 | 0.01044585937419 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 70.2976 | 2 | 35.148788452148 | 0.0098005024539895 | | query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu | 60.3817 | 1 | 60.381732940674 | 0.0084180898961404 | | query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user, | 52.9119 | 2 | 26.455963134766 | 0.0073766904363692 | | query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ | 52.469 | 8 | 6.5586223602295 | 0.0073149371419988 | | query: SELECT N FROM user_newtalk WHERE user_id=N | 50.8078 | 8 | 6.3509726524353 | 0.0070833420787917 | | query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO | 41.8996 | 1 | 41.899608612061 | 0.0058414135324001 | | query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N | 41.6351 | 5 | 8.3270210266113 | 0.00580453790867 | | query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 36.9741 | 3 | 12.324708302816 | 0.0051547296202354 | | Setup.php-BlockCache | 35.9496 | 1070 | 0.033597782170661 | 0.0050118997324001 | | query: SELECT user_name,user_password,user_newpassword,user_email,user | 32.0886 | 8 | 4.0110731124878 | 0.0044736144388687 | | query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ | 14.2162 | 1 | 14.216176986694 | 0.0019819413922919 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 12.2557 | 1 | 12.255656242371 | 0.0017086163473618 | | query: UPDATE user SET user_name= 'X' WHERE user_id=N | 10.3872 | 2 | 5.1936058998108 | 0.0014481280751809 | | query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES | 9.742 | 2 | 4.8710007667542 | 0.0013581764001041 | | query: INSERT INTO cur (cur_namespace,cur_title,cur_text,cur_comment,c | 9.04562 | 1 | 9.0456190109253 | 0.0012610905698089 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 8.10509 | 2 | 4.0525450706482 | 0.001129967195423 | | query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 5.65832 | 3 | 1.886105855306 | 0.00078885158823791 | | query: DELETE FROM user_newtalk WHERE user_ip='X' | 5.30759 | 1 | 5.3075890541077 | 0.00073995494354473 | | query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 4.04978 | 3 | 1.3499256769816 | 0.0005645976928041 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 3.60813 | 1 | 3.6081330776215 | 0.000503026116102 | | query: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_fro | 3.2735 | 1 | 3.2735047340393 | 0.00045637406852266 | | query: SELECT * FROM ipblocks ORDER BY ipb_timestamp DESC | 3.06716 | 1 | 3.0671577453613 | 0.00042760630357302 | | query: SELECT cur_namespace,cur_title,cur_id FROM brokenlinks,cur WHER | 2.98359 | 1 | 2.9835877418518 | 0.00041595543222663 | | query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp > | 2.15777 | 1 | 2.1577744483948 | 0.00030082507403404 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 1.36111 | 2 | 0.68055295944214 | 0.00018975791891555 | | Skin::doAfterContent-2 | 1.091 | 24 | 0.045458480715752 | 0.0001521017268914 | | query: SELECT N FROM boardvote.log WHERE log_user_key='X' LIMIT N | 0.997052 | 1 | 0.99705213308334 | 0.00013900353763746 | | query: SELECT max(user_id) as m FROM user LIMIT N | 0.971969 | 2 | 0.48598432540894 | 0.00013550653617136 | | query: DELETE FROM user_newtalk WHERE user_id=N | 0.809938 | 2 | 0.40496879816055 | 0.00011291705560677 | | query: UPDATE cur set cur_touched='X' | 0.333327 | 1 | 0.33332684636116 | 4.6470599978012e-05 | | Skin::doAfterContent-1 | -0.0298021 | 24 | -0.0012417521793395 | -4.154838610417e-06 | +------------------------------------------------------------------------+------------+--------+---------------------+---------------------+