Jump to content

Profiling/Live aggregate 20040818

From Meta, a Wikimedia project coordination wiki
+------------------------------------------------------------------------+------------+-------+---------------------+---------------------+
| name                                                                   | total      | count | each                | percent             |
+------------------------------------------------------------------------+------------+-------+---------------------+---------------------+
| -total                                                                 |     181168 |    71 |     2551.6602112676 |                 100 |
| Setup.php                                                              |    68015.7 |    70 |          971.653125 |     37.542924621708 |
| Parser::parse                                                          |    45048.7 |   105 |     429.03489583333 |     24.865702080184 |
| LinkCache::addLinkObj                                                  |    41577.4 |   643 |     64.661650709565 |     22.949676594843 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  |    41300.5 |   643 |     64.230924377916 |     22.796803448183 |
| OutputPage::output                                                     |    39069.1 |    69 |     566.21829710145 |     21.565116056034 |
| Setup.php-misc                                                         |    37399.7 |    70 |     534.28080357143 |     20.643646811003 |
| Parser::internalParse                                                  |    28962.1 |   124 |     233.56565020161 |     15.986355541787 |
| Setup.php-MessageCache                                                 |    27899.3 |    71 |       392.947265625 |     15.399670531751 |
| wfMsg                                                                  |    26318.8 |  3916 |      6.720847265226 |     14.527320525576 |
| Article::view                                                          |    25323.1 |    51 |     496.53201593137 |     13.977716972449 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |    21471.2 |    78 |     275.27150941506 |     11.851536998143 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    15940.6 |     5 |      3188.119921875 |     8.7988003443629 |
| Parser::tidy                                                           |    12340.7 |   105 |     117.53073846726 |     6.8117636965508 |
| Parser::replaceVariables                                               |    12336.4 |   320 |     38.551193237305 |     6.8093649803739 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |    10679.3 |    59 |     181.00436970339 |      5.894675208008 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |    9849.39 |    71 |     138.72379786532 |     5.4366093593787 |
| Parser::replaceInternalLinks                                           |    8698.29 |   250 |       34.7931484375 |     4.8012304109517 |
| query: COMMIT                                                          |    7605.12 |   107 |     71.075843311916 |     4.1978276967564 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     5962.5 |    10 |     596.25014648438 |     3.2911472107534 |
| Title::secureAndSplit                                                  |    4075.95 |  5251 |    0.77622268377452 |     2.2498168135493 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |    3804.01 |    77 |     49.402790812703 |     2.0997182268535 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |    3419.24 |    26 |     131.50932429387 |        1.8873337404 |
| query: BEGIN                                                           |    3214.74 |   107 |     30.044257903768 |      1.774451235189 |
| Skin::makeLink                                                         |    2368.43 |   133 |     17.807769545935 |     1.3073141966308 |
| Skin::outputPage                                                       |    2143.55 |     3 |     714.51814778646 |     1.1831868334049 |
| -overhead-total                                                        |    2062.54 | 21748 |   0.094838102929005 |     1.1384684301784 |
| Skin::doAfterContent                                                   |    2048.04 |     3 |       682.681640625 |     1.1304680379317 |
| main-misc-setup                                                        |    1983.78 |    71 |      27.94062568772 |     1.0949978984012 |
| ParserCache::get                                                       |     1892.5 |    48 |     39.427164713542 |     1.0446134041424 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |     1603.2 |    67 |     23.928357480177 |    0.88492507359369 |
| Skin::doAfterContent-3                                                 |    1550.27 |     3 |      516.7568359375 |    0.85570938435553 |
| Parser::replaceExternalLinks                                           |    1216.32 |   125 |     9.7305771484375 |    0.67137849000806 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |    1168.73 |    26 |     44.951082669772 |    0.64510783129408 |
| LinkCache::preFill                                                     |    1149.05 |    31 |     37.066197549143 |    0.63424717214541 |
| Skin::makeKnownLinkObj                                                 |     1073.6 |  2446 |    0.43892142544588 |     0.5926005405984 |
| -overhead-internal                                                     |    1041.55 | 21748 |   0.047891582792814 |    0.57490663981025 |
| Setup.php-User                                                         |    981.063 |    71 |     13.817789426992 |    0.54152153041283 |
| Setup.php-includes                                                     |     940.55 |    71 |     13.247188944212 |    0.51915959992303 |
| DifferenceEngine::showDiffPage                                         |    932.997 |     1 |     932.99664306641 |    0.51499011238411 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |    913.179 |    26 |     35.122253417969 |    0.50405105699186 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |    822.987 |    12 |     68.582209269206 |    0.45426735354183 |
| Title::newFromText                                                     |    786.824 |  3466 |    0.22701216321836 |    0.43430666596649 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |    760.538 |     2 |     380.26879882812 |     0.4197971619727 |
| Article::getContent                                                    |    682.176 |    36 |     18.949335734049 |    0.37654362641599 |
| query: SELECT cur_title FROM cur WHERE cur_namespace=N AND cur_title > |    681.723 |     2 |     340.86154174805 |    0.37629358046844 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |    523.141 |    35 |     14.946876743862 |     0.2887601822537 |
| Skin::doAfterContent-4                                                 |    496.948 |     3 |     165.64930216471 |    0.27430244268977 |
| Skin::quickBar                                                         |    496.668 |     3 |     165.55584716797 |    0.27414768843754 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |    472.822 |    12 |     39.401817321777 |    0.26098545774814 |
| Parser::doBlockLevels                                                  |    358.574 |   105 |     3.4149899437314 |    0.19792358004519 |
| Setup.php-SetupSession                                                 |    313.931 |    71 |     4.4215655259683 |    0.17328190902706 |
| PageHistory::history                                                   |    302.278 |     1 |     302.27755737305 |    0.16684942480727 |
| Setup.php-language                                                     |    261.966 |    71 |     3.6896684673471 |    0.14459873814916 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N  |    231.509 |     1 |     231.50862121582 |    0.12778679510141 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |    198.176 |     2 |     99.087837219238 |    0.10938786715828 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A |    172.351 |     2 |     86.175659179688 |   0.095133487854497 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |     149.95 |     1 |     149.94953918457 |   0.082768282834123 |
| Setup.php-extensions                                                   |    139.759 |    70 |     1.9965506417411 |   0.077143116527627 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |    137.904 |     5 |     27.580737304687 |   0.076119282474024 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ |    128.742 |     2 |         64.37109375 |   0.071062371019145 |
| Parser::doAllQuotes                                                    |    115.473 |   125 |    0.92378198242188 |   0.063737982135483 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o |    91.8434 |     1 |     91.843353271484 |   0.050695165062506 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |    88.7245 |     8 |     11.090559959412 |   0.048973627181581 |
| query: REPLACE INTO math VALUES ('X', N, NULL, NULL)                   |    88.4709 |     2 |     44.235439300537 |   0.048833645921538 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |    81.6218 |     2 |     40.810924530029 |   0.045053158050266 |
| Parser::removeHTMLtags                                                 |    81.4921 |   125 |    0.65193682861328 |   0.044981541885757 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      |    74.0561 |     2 |     37.028057098389 |    0.04087706730389 |
| Setup.php-DateFormatter                                                |    68.9864 |    71 |    0.97163885412082 |   0.038078692838108 |
| Setup.php-OutputPage                                                   |    62.6711 |    71 |    0.88269171916263 |   0.034592839409607 |
| Skin::makeBrokenLinkObj                                                |    59.7294 |   218 |    0.27398826879099 |   0.032969113644699 |
| query: UPDATE cur SET cur_text='X'                                     |    56.5672 |     2 |     28.283578872681 |    0.03122361386938 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o |     53.606 |     2 |      26.80299949646 |    0.02958913051937 |
| Skin::doBeforeContent                                                  |    51.9349 |     3 |     17.311623891195 |   0.028666711288403 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |    50.0857 |     1 |     50.085674285889 |   0.027646001966899 |
| Skin::initPage                                                         |    44.2161 |    62 |    0.71316226836174 |   0.024406126438491 |
| Parser::doHeadings                                                     |    34.5654 |   125 |    0.27652294921875 |   0.019079193070153 |
| Setup.php-memcached                                                    |    28.4953 |    71 |    0.40134158604582 |   0.015728645384428 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |    23.9767 |     1 |     23.976694107056 |   0.013234517492163 |
| Parser::replaceInternalLinks-setup                                     |    22.4281 |   250 |   0.089712501525879 |   0.012379747447758 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO |    19.5345 |     1 |     19.534511566162 |   0.010782547163045 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |    10.5815 |     1 |     10.581478118896 |  0.0058407033360062 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        |    9.95346 |     2 |      4.976731300354 |  0.0054940549480464 |
| Setup.php-database                                                     |    9.23509 |    71 |    0.13007169374278 |  0.0050975319193523 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |    8.28571 |     2 |     4.1428537368774 |   0.004573497080404 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |    7.25762 |     1 |     7.2576246261597 |  0.0040060218326012 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= |    7.13037 |     1 |     7.1303696632385 |  0.0039357803712377 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 |    2.37199 |     2 |     1.1859951019287 |  0.0013092774885489 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac |    1.63718 |     2 |     0.8185920715332 | 0.00090368347206502 |
| Setup.php-BlockCache                                                   |    0.71353 |    71 |   0.010049725082559 |  0.0003938504444354 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges          |   0.676318 |     1 |     0.6763179898262 | 0.00037331010800132 |
| Skin::doAfterContent-2                                                 |   0.148686 |     3 |   0.049561853210131 | 8.2070598681137e-05 |
| Skin::doAfterContent-1                                                 | 0.00778018 |     3 |  0.0025933948345482 | 4.2944614234972e-06 |
| Parser::replaceInternalLinks-prefixhandling                            |   -10.5683 |  1103 | -0.0095814465395667 | -0.0058334489672311 |
+------------------------------------------------------------------------+------------+-------+---------------------+---------------------+