Profiling/Live aggregate 20050104

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search

Ran for a few minutes circa 20:30 UTC January 4, 2005. Suda is master. enwiki running on 1.4.

| pf_count | pf_time    | pf_name
+----------+------------+----------
|      412 |     635636 | -total
|      412 |     411516 | Setup.php
|     5472 |     388443 | LoadBalancer::getConnection
|     5828 |     387956 | LoadBalancer::openConnection
|     2391 |     385624 | LoadBalancer::getReaderIndex
|      412 |     255569 | Setup.php-User
|      412 |     244187 | main-action
|      170 |     197694 | Article::view
|     1328 |     152771 | LinkCache::addLinkObj
|    34043 |    66717.2 | wfMsgReal
|      412 |    64418.9 | Setup.php-DateFormatter
|      412 |    60823.3 | MessageCache::load-fromcache
|      412 |    60816.8 | MessageCache::load
|      174 |    56641.9 | Parser::parse
|      412 |    45961.4 | Setup.php-language1
|      174 |    26266.8 | Parser::internalParse
|      412 |    25670.6 | main-cleanup
|      174 |    23523.9 | Parser::tidy
|      314 |    23120.3 | OutputPage::output
|      208 |    23048.2 | Output-skin
|      202 |    21789.8 | SkinTemplate::outputPage
|      280 |    20204.6 | Parser::replaceInternalLinks
|    16059 |    17476.7 | Title::newFromText
|   176732 |    16472.7 | -overhead-total
|    11773 |    15980.3 | Title::secureAndSplit
|     2000 |    13908.1 | Title::getInterwikiLink
|        5 |    11642.5 | SquidUpdate::purge
|      106 |    7853.48 | Parser::replaceInternalLinks-image
|      412 |    7658.67 | Setup.php-includes
|   183004 |    6407.29 | -overhead-internal
|     2395 |    6388.41 | query: UPDATE `profiling` SET pf_count=pf_count+N, pf_time=pf_time + N.N WHERE pf_name='X'
|      202 |    6093.23 | SkinTemplate::outputPage-stuff2
|     1012 |    6051.95 | Parser::replaceVariables
|     1314 |    5485.31 | query: SELECT cur_id FROM `cur` WHERE cur_namespace='X' LIMIT N
|      159 |    5320.22 | ParserCache::get
|      202 |    4980.86 | SkinTemplate::outputPage-stuff4
|      174 |    4696.97 | Parser::replaceLinkHolders
|      202 |    4364.07 | SkinTemplate::buildNavigationUrls
|      202 |     3901.4 | SkinTemplate::buildNavigationUrls-sitesupport
|      202 |    3894.55 | SkinTemplate::buildNavigationUrls-sitesupport2
|      424 |    3374.89 | Title::userCanEdit
|      154 |    3036.28 | Parser::replaceLinkHolders-check
|      412 |    2969.07 | Setup.php-SetupSession
|      756 |    2851.52 | Parser::braceSubstitution
|      713 |    2844.84 | Parser::initialiseVariables
|     8197 |     2839.1 | Skin::makeLinkObj
|     1220 |    2832.19 | parser::variableSubstitution
|        4 |    2685.99 | DifferenceEngine::showDiffPage
|      673 |    2208.23 | query: COMMIT
|      202 |    2168.56 | SkinTemplate::buildContentActionUrls
|      412 |    2135.69 | Setup.php-extensions
|      202 |    2081.06 | SkinTemplate::outputPage-stuff3
|      588 |    2078.37 | Skin::makeLinkObj-immediate
|      230 |    2029.17 | query: SELECT cur_touched,cur_is_redirect FROM `cur` WHERE cur_id='X' LIMIT N
|    10364 |    1998.87 | Skin::makeKnownLinkObj
|      212 |    1790.87 | query: SELECT ss_total_views,ss_total_edits,ss_good_articles FROM `site_stats` WHERE ss_row_id='X' LIMIT N
|      725 |    1701.84 | query: BEGIN
|        3 |     1510.8 | PageHistory::history
|      154 |    1432.38 | Parser::replaceLinkHolders-construct
|     1660 |    1431.29 | ParserOptions::initialiseFromUser
|      254 |    1419.33 | query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_comment,cur_counter,cur_restrictions,cur_touched FROM `cur` WHERE cur_id='X' LIMIT N
|      134 |    1352.85 | Article::getContent
|      143 |       1276 | query: SELECT cur_id, cur_namespace, cur_title FROM `cur` WHERE (cur_namespace=N AND cur_title IN('X'))
|       22 |    1248.27 | query: SELECT cur_namespace,cur_title,cur_id FROM `cur`,`links` WHERE l_to=cur_id AND l_from=N and cur_namespace=N
|        6 |     1226.1 | Skin::outputPage
|      184 |    1201.97 | SkinTemplate::buildContentActionUrls-talk
|      200 |    1090.48 | Parser::replaceInternalLinks-category
|      412 |    1063.06 | Setup.php-misc2
|      202 |    1034.61 | SkinTemplate::outputPage-stuff
|      174 |    1003.73 | Parser::doBlockLevels
|     1660 |    975.712 | ParserOptions::initialiseFromUser-skin
|        5 |    924.516 | SkinStandard::doAfterContent
|     1240 |    881.386 | User::getSkin
|       80 |    875.189 | query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_minor_edit FROM `cur` WHERE cur_id='X' LIMIT N
|      119 |    866.904 | Database::masterPosWait
|    11922 |    811.919 | do_html_entity_decode
|      125 |    698.806 | Skin::recentChangesLineOld
|      412 |    650.377 | main-misc-setup
|      174 |    646.958 | Parser::doAllQuotes
|        4 |    625.793 | LinkCache::preFill
|       13 |     604.92 | SpecialSearch::showResults
|        4 |    584.491 | query: SELECT cur_id,cur_namespace,cur_title FROM `cur`,`links` WHERE cur_id=l_to AND l_from=N FOR UPDATE
|        3 |    580.635 | query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp,old_minor_edit FROM `old` USE INDEX (name_title_timestamp) WHERE old_namespace=N AND old_title='X' ORDER BY inverse_timestamp LIMIT N,N
|     7522 |    566.172 | Skin::makeLinkObj-postparse
|      412 |    554.985 | MessageCache::initialise
|      412 |    552.586 | Setup.php-MessageCache
|      412 |    539.709 | MessageCache::initialise-parseropt
|        2 |    537.497 | Skin::quickBar
|        5 |    537.357 | SkinStandard::doAfterContent-4
|      125 |    510.741 | Skin::recentChangesLineOld-rest
|     8540 |    456.447 | Parser::doBlockLevels-paragraph
|      182 |    449.453 | query: SELECT N FROM `user_newtalk` WHERE user_ip='X'
|       56 |    411.458 | query: SHOW SLAVE STATUS
|      331 |    406.087 | Parser::removeHTMLtags
|        5 |    387.908 | SkinStandard::doAfterContent-3
|      412 |    386.413 | main-updates
|      184 |    375.034 | SkinTemplate::buildContentActionUrls-edit
|      202 |    349.024 | SkinTemplate::outputPage-execute
|       74 |    347.167 | query: SELECT cur_restrictions FROM `cur` WHERE cur_id=N LIMIT N
|      202 |    341.028 | SkinTemplate::buildNavUrls
|      412 |    339.357 | Setup.php-OutputPage
|      174 |    337.427 | Parser::doTableStuff
|        4 |    320.524 | LinksUpdate::doUpdate
|       14 |     296.18 | query: SELECT cur_id FROM `cur` WHERE cur_namespace='X' LIMIT N FOR UPDATE
|      412 |     293.59 | Setup.php-memcached
|        1 |    279.542 | query: SELECT COUNT(*) AS n FROM `cur` WHERE cur_timestamp>'X'
|       58 |    278.955 | query: SELECT math_outputhash,math_html_conservativeness,math_html,math_mathml FROM `math` WHERE math_inputhash='X' LIMIT N
|       61 |     278.61 | query: SELECT * FROM `ipblocks` WHERE ipb_user=N
|        8 |    275.737 | _DiffEngine::diff
|       44 |    267.437 | Skin::makeLink
|      154 |    239.273 | Parser::replaceLinkHolders-replace
|       10 |    236.164 | query: SELECT cur_id, cur_namespace, cur_title, LENGTH(cur_text) AS cur_len, cur_is_redirect FROM `cur` WHERE (cur_namespace=N AND cur_title IN('X'))
|       26 |    235.455 | query: SELECT N FROM `user_newtalk` WHERE user_id='X'
|       70 |    230.556 | query: SHOW MASTER STATUS
|      412 |    228.143 | Setup.php-misc1
|     2687 |    213.115 | SkinTemplate-translate
|        4 |    191.487 | DiffFormatter::format
|        4 |    190.914 | DiffFormatter::_block
|      280 |     190.59 | Parser::replaceExternalLinks
|        4 |    189.431 | TableDiffFormatter::_changed
|      202 |    177.289 | SkinTemplate::buildPersonalUrls
|        5 |    174.621 | Skin::doBeforeContent
|      218 |    170.874 | Skin::formatComment
|      202 |    169.775 | SkinTemplate::outputPage-init
|        4 |    160.474 | WordLevelDiff::WordLevelDiff
|      412 |    159.776 | Setup.php-language2
|        4 |    158.945 | MappedDiff::MappedDiff
|       26 |    158.921 | query: INSERT IGNORE INTO `profiling` (pf_name,pf_count,pf_time) VALUES ('X')
|       16 |    155.654 | _DiffEngine::_shift_boundaries
|        2 |     154.44 | query: SELECT qc_type as type, qc_namespace as namespace,qc_title as title, qc_value as value FROM `querycache` WHERE qc_type='X' ORDER BY value LIMIT N,N
|       12 |    153.608 | query: SELECT cur_id,cur_title FROM `cur` USE INDEX (cur_random) WHERE cur_namespace=N AND cur_is_redirect=N AND (cur_user<>N AND cur_user<>N) AND cur_random>N.N ORDER BY cur_random LIMIT N
|      174 |    128.598 | Parser::doHeadings
|       10 |    125.266 | query: UPDATE `cur` SET cur_touched='X'
|      412 |    113.906 | User::loadDefaults2
|       73 |    112.363 | query: SELECT LENGTH(cur_text) AS x,cur_namespace,cur_is_redirect FROM `cur` WHERE cur_id='X' LIMIT N
|      202 |      110.1 | SkinTemplate::buildNavigationUrls-currentevents
|        2 |     107.68 | query: SELECT old_text,old_user,old_user_text,old_timestamp,old_flags FROM `old` USE INDEX (name_title_timestamp) WHERE old_namespace='X') LIMIT N FOR UPDATE
|      202 |    107.445 | SkinTemplate::buildNavigationUrls-currentevents2
|      412 |    103.094 | Setup.php-database
|      355 |    100.319 | User::loadDefaults3
|      259 |    97.4747 | Skin::initPage
|      412 |    95.0494 | User::loadDefaults1
|      814 |    84.2748 | Skin::makeBrokenLinkObj
|      202 |    83.0834 | SkinTemplate::buildNavigationUrls-randompage
|       10 |    82.3915 | query: SELECT img_size,img_description,img_user,img_user_text,img_timestamp,'X'
|        4 |    77.7391 | query: DELETE FROM `categorylinks` WHERE cl_from='X'
|       33 |    76.9342 | query: SELECT N FROM `watchlist` WHERE wl_user='X'
|      202 |    73.0437 | SkinTemplate::buildNavigationUrls-randompage2
|      120 |    72.7783 | Skin::recentChangesLineOld-page
|       24 |    68.9794 | _DiffEngine::_compareseq
|      736 |    68.9178 | Parser::replaceFreeExternalLinks
|        2 |     66.052 | _DiffEngine::_diag
|       16 |     65.334 | _DiffEngine::_diag-chunk
|        8 |    65.1105 | query: SELECT user_name,user_password,user_newpassword,user_email,user_real_name,user_options,user_touched,user_token FROM `user` WHERE user_id='X' LIMIT N
|        3 |    63.5909 | CategoryPage::doCategoryMagic
|        4 |    56.9829 | query: UPDATE LOW_PRIORITY `site_stats` SET ss_total_views=(ss_total_views),ss_total_edits=(ss_total_edits+N),ss_good_articles=(ss_good_articles) WHERE ss_row_id=N
|      280 |    52.5407 | Parser::replaceInternalLinks-setup
|        1 |    51.4201 | query: SELECT cur_namespace,cur_title FROM `cur` WHERE cur_id='X' LIMIT N
|        7 |    50.0162 | query: SELECT * FROM `ipblocks` WHERE (ipb_address='X' OR ipb_user=N)
|        4 |    46.6269 | query: INSERT IGNORE INTO `links` (l_from,l_to) VALUES ('X')
|        2 |    46.6112 | query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_minor_edit FROM `cur` WHERE cur_id='X'
|      202 |    45.8956 | SkinTemplate::buildNavigationUrls-portal
|      202 |    45.4959 | SkinTemplate::buildNavigationUrls-portal2
|      202 |    43.8055 | SkinTemplate::buildNavigationUrls-recentchanges
|      202 |    42.6236 | SkinTemplate::setupUserCss
|      202 |    40.0231 | SkinTemplate::buildNavigationUrls-help
|        2 |    39.8731 | query: SELECT cur_id,cur_user,cur_user_text,cur_comment FROM `cur` WHERE cur_title='X'
|      202 |    38.9117 | SkinTemplate::buildNavigationUrls-help2
|        4 |    38.7206 | query: SELECT cur_text,cur_user_text,cur_comment FROM `cur` WHERE cur_id='X' LIMIT N
|        8 |    37.7245 | query: SELECT ur_rights FROM `user_rights` WHERE ur_user='X'
|      202 |    35.4934 | SkinTemplate::buildNavigationUrls-recentchanges2
|      184 |    32.4473 | SkinTemplate::buildContentActionUrls-live
|        4 |    29.3864 | query: SELECT bl_to FROM `brokenlinks` WHERE bl_from='X' FOR UPDATE
|      174 |    27.3625 | Parser::magicISBN
|        4 |    26.7666 | query: DELETE FROM `imagelinks` WHERE il_from='X'
|        4 |    24.4145 | query: SELECT cur_id as id,cur_timestamp as timestamp,cur_user as user,cur_user_text as user_text,cur_restrictions as restrictions,cur_comment as comment,cur_text as text FROM `cur` WHERE cur_namespace=N AND cur_title='X'
|        7 |    24.2491 | query: SELECT oi_size AS img_size,oi_description AS img_description,oi_user AS img_user,oi_user_text AS img_user_text,oi_timestamp AS img_timestamp,oi_archive_name FROM `oldimage` WHERE oi_name='X' ORDER BY oi_timestamp DESC
|       31 |    23.4653 | SkinTemplate::getUserStylesheet
|      411 |    23.1384 | MessageCache::initialise-parser
|        4 |    22.9287 | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags,old_user_text,old_comment FROM `old` WHERE old_id='X' LIMIT N
|        3 |    22.9222 | query: SELECT cur_title,cur_namespace,cl_sortkey FROM `cur`,`categorylinks` WHERE (N) AND (cl_from = cur_id) AND cl_to='X' ORDER BY cl_sortkey LIMIT N
|       10 |    22.2998 | query: SELECT cur_namespace,cur_title FROM `imagelinks`,`cur` WHERE il_to='X' AND il_from=cur_id LIMIT N
|      202 |    21.6555 | SkinTemplate::buildNavigationUrls-mainpage
|        4 |    21.2229 | query: UPDATE `recentchanges` SET rc_this_oldid='X'
|        1 |    19.4918 | query: UPDATE `user` SET user_name='X'
|        2 |    18.8027 | wfSpamBlacklistFilter
|        4 |    18.5487 | WordLevelDiff::closing
|      179 |    17.4876 | _DiffEngine::_lcs_pos
|        4 |    17.2571 | query: SELECT bl_from FROM `brokenlinks` WHERE bl_to='X' FOR UPDATE
|        1 |    16.0685 | query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cur_user_text,cur_timestamp,cur_minor_edit,cur_is_new FROM `watchlist`,`cur` USE INDEX (name_title_timestamp) WHERE wl_user=N AND (wl_namespace=cur_namespace OR wl_namespace+N=cur_namespa
|      202 |     13.139 | SkinTemplate::buildNavigationUrls-mainpage2
|        1 |    12.7155 | query: REPLACE INTO `watchlist` (wl_user,wl_namespace,wl_title) VALUES ('X')
|        1 |    12.3926 | query: UPDATE `user_rights` SET ur_rights = 'X' WHERE (ur_user=N)
|        4 |    9.02837 | WordLevelDiff::orig
|        4 |    8.60869 | query: UPDATE `cur` SET cur_text='X'
|       41 |    7.02077 | Parser::replaceLinkHolders-interwiki
|        3 |    6.30556 | query: SELECT user_id FROM `user` WHERE user_name='X' LIMIT N
|        4 |     6.1525 | query: UPDATE `recentchanges` SET rc_cur_time='X'
|      202 |    5.38047 | SkinTemplate::setupUserJs
|        2 |    5.34718 | query: SELECT `recentchanges`.* FROM `recentchanges` WHERE rc_timestamp > 'X' AND rc_bot=N ORDER BY rc_timestamp DESC LIMIT N
|        4 |    5.30707 | query: INSERT INTO `old` (old_id,old_namespace,old_title,old_text,old_comment,old_user,old_user_text,old_timestamp,old_minor_edit,inverse_timestamp,old_flags) VALUES (NULL,'X')
|        2 |    4.27918 | query: SELECT MAX(rc_timestamp) FROM `recentchanges` LIMIT N
|        3 |    4.19704 | query: UPDATE `profiling` SET pf_count=pf_count+N, pf_time=pf_time + N.NEN WHERE pf_name='X'
|        2 |    3.50341 | query: INSERT IGNORE INTO `imagelinks` (il_from,il_to) VALUES ('X')
|        4 |    3.38875 | query: INSERT IGNORE INTO `categorylinks` (cl_from,cl_to,cl_sortkey) VALUES ('X')
|        6 |    2.76659 | Article::getRevisionText
|      119 |     2.0503 | LoadBalancer::waitFor
|        1 |    2.04884 | query: SELECT user_id FROM `user_newtalk` WHERE user_id='X' LIMIT N
|        4 |    1.80232 | query: INSERT INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_namespace,rc_title,rc_type,rc_minor,rc_cur_id,rc_user,rc_user_text,rc_comment,rc_this_oldid,rc_last_oldid,rc_bot,rc_moved_to_ns,rc_moved_to_title,rc_ip,rc_patrolled,rc_new) VALUES ('X')
|      412 |    1.66202 | Setup.php-BlockCache
|        1 |    1.51738 | query: SELECT COUNT(*) AS n FROM `watchlist` WHERE wl_user=N
|        8 |    1.50335 | WordLevelDiff::_split
|        8 |    1.48656 | User::loadDefaults4
|        2 |    1.27133 | query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_comment,cur_counter,cur_restrictions,cur_touched FROM `cur` WHERE cur_id='X'
|        1 |    1.21316 | query: SELECT COUNT(*) FROM `archive` WHERE ar_namespace='X' LIMIT N
|       20 |   0.912967 | SkinTemplate::getUserJs
|        2 |   0.873664 | query: SELECT cur_text FROM `cur` WHERE cur_namespace='X' LIMIT N
|        1 |   0.329662 | query: SELECT iw_url,iw_local FROM `interwiki` WHERE iw_prefix='X'
|        9 |   0.150711 | Parser::findColonNoLinks
|        5 |  0.0414549 | SkinStandard::doAfterContent-2
|        5 | -0.0896753 | SkinStandard::doAfterContent-1
|      331 |   -1.57987 | Parser::removeHTMLcomments
|      644 |   -13.2862 | Parser::maybeDoSubpageLink