Jump to content
Wikimedia Meta-Wiki

Profiling/Live aggregate 20050104

From Meta, a Wikimedia project coordination wiki

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

AltStyle によって変換されたページ (->オリジナル) /