Profiling/Live aggregate 20040604

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

+----------------------------------------------------------------------------------+-------------------+--------+----------------------+---------------------+
| name                                                                             | total             | count  | each                 | percent             |
+----------------------------------------------------------------------------------+-------------------+--------+----------------------+---------------------+
| -total                                                                           |  310147.256851182 |    975 |       318.0997506166 |                 100 |
| Article::view                                                                    |  123814.751261835 |    607 |      203.97817341324 |     39.921278852789 |
| Setup.php                                                                        |   90553.902084944 |    975 |      92.875797010199 |     29.197066904382 |
| OutputPage::output                                                               |  53870.6641074769 |    972 |      55.422493937733 |     17.369382742381 |
| LinkCache::addLinkObj                                                            |  50227.4820002495 |   5291 |      9.4930035910507 |     16.194720698223 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'            |  48592.2743472015 |   5291 |      9.1839490355701 |     15.667484807231 |
| LinkCache::preFill                                                               |  47370.4448062788 |    606 |      78.169050835444 |     15.273533381277 |
| Parser::parse                                                                    |  45268.6145090773 |    376 |      120.39525135393 |     14.595845524695 |
| Parser::internalParse                                                            |  43724.8803325959 |    539 |      81.122226962145 |     14.098103196694 |
| Setup.php-includes                                                               |  34956.1267901093 |    972 |      35.963093405462 |      11.27081604558 |
| query: COMMIT                                                                    |  32887.8646909501 |    687 |      47.871709884935 |     10.603951498668 |
| Setup.php-MessageCache                                                           |  31561.6164272749 |    975 |      32.370888643359 |     10.176332606552 |
| Article::getContent                                                              |  24876.8293573071 |    671 |      37.074261337268 |     8.0209735239553 |
| wfMsg                                                                            |    21038.92693759 |  61402 |     0.34264237219618 |      6.783528299167 |
| PageHistory::history                                                             |  16569.4012083141 |      9 |      1841.0445787016 |     5.3424303592227 |
| Parser::replaceInternalLinks                                                     |  15934.0627091217 |   1078 |      14.781134238517 |     5.1375797648171 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_id=l_to AN |  15482.8884433814 |    280 |      55.296030154934 |     4.9921087810267 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp,old_minor_ |  13962.2935690075 |      9 |      1551.3659521119 |     4.5018272000087 |
| -overhead-total                                                                  |  13828.7672996517 | 232743 |    0.059416469237106 |     4.4587746608016 |
| Parser::replaceVariables                                                         |  13325.4571188653 |   1291 |      10.321810316704 |     4.2964936250457 |
| Title::secureAndSplit                                                            |  11671.0698799115 |  49700 |     0.23483037987749 |     3.7630737084067 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N                     |  11167.3388224245 |    479 |       23.31385975454 |     3.6006569704348 |
| Parser::tidy                                                                     |  10534.1963553148 |    376 |       28.01647966839 |     3.3965144371306 |
| Setup.php-misc                                                                   |   8784.0156620468 |    974 |      9.0184965729433 |     2.8322080779395 |
| Setup.php-language                                                               |   7489.6738168758 |    973 |      7.6975064921642 |     2.4148766920965 |
| Parser::replaceExternalLinks                                                     |  7197.42881740449 |    539 |      13.353300217819 |     2.3206488719189 |
| -overhead-internal                                                               |  6814.48960304291 | 232743 |    0.029279031391032 |     2.1971787441321 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_comment,cur_coun |  6080.56963738654 |    603 |      10.083863411918 |     1.9605427754288 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X' LIMIT N  |  5932.28761962886 |    994 |      5.9680961968097 |     1.9127325773754 |
| Title::newFromText                                                               |  5787.18558045382 |  39344 |     0.14709194744952 |     1.8659476918188 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FROM cur WHE |  5031.65122472655 |   1863 |      2.7008326488065 |     1.6223426496856 |
| Skin::makeLink                                                                   |  4519.86704130117 |    904 |      4.9998529217933 |     1.4573293625711 |
| Skin::makeKnownLinkObj                                                           |   4486.3961856735 |  20337 |     0.22060265455443 |      1.446537438771 |
| Parser::doBlockLevels                                                            |  3920.34051653975 |    376 |      10.426437543989 |     1.2640255330134 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                           |  3751.76833382596 |    280 |      13.399172620807 |     1.2096732281034 |
| main-misc-setup                                                                  |  3739.30161725088 |    975 |      3.8351811458983 |     1.2056536160322 |
| Setup.php-memcached                                                              |  3703.26051486052 |    972 |      3.8099388012968 |     1.1940329740325 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_minor_edit F |    3354.322109852 |      2 |       1677.161054926 |     1.0815256416927 |
| ParserCache::get                                                                 |   2970.4159815218 |    593 |      5.0091331897501 |    0.95774375426673 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')              |  2718.46647599659 |    279 |       9.743607440848 |    0.87650830885826 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                              |  2693.22101252473 |    894 |      3.0125514681485 |    0.86836847756387 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                           |  2518.18295808928 |    964 |      2.6122229855698 |    0.81193139789644 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM site_stats W |  2248.13370915689 |    730 |      3.0796352180231 |    0.72486009774241 |
| LinksUpdate::doUpdate                                                            |   2153.6512177616 |      5 |      430.73024355232 |    0.69439634566718 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM links,cur WHER |  1271.09619284301 |     13 |      97.776630218693 |    0.40983634862614 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cur_user_tex |     1200.62672632 |      1 |        1200.62672632 |    0.38711505576723 |
| query: BEGIN                                                                     |  1037.88531785263 |    688 |      1.5085542410649 |    0.33464275273298 |
| Skin::outputPage                                                                 |    945.7517350717 |     13 |      72.750133467054 |    0.30493635335472 |
| Parser::removeHTMLtags                                                           |  881.465549124753 |    539 |      1.6353720762982 |    0.28420872010089 |
| query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X')              |    874.3810988008 |      3 |      291.46036626693 |    0.28192449860047 |
| Setup.php-User                                                                   |  860.385662886507 |    974 |     0.88335283663912 |    0.27741198539742 |
| Setup.php-SetupSession                                                           |  798.129565093121 |    974 |     0.81943487175885 |    0.25733890836123 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags,old_user_ |     784.248798433 |      1 |        784.248798433 |    0.25286336767741 |
| query: UPDATE cur SET cur_text='X'                                               |    730.7228844787 |      5 |      146.14457689574 |    0.23560514185986 |
| Setup.php-OutputPage                                                             |  661.500698897264 |    974 |     0.67915882843662 |    0.21328600665802 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_minor_edit FR |  618.760915915394 |     81 |      7.6390236532765 |    0.19950552592258 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N                |  549.887399021453 |      5 |      109.97747980429 |    0.17729881108873 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrictions,cur_t |  531.947690054429 |    155 |      3.4319205809963 |    0.17151455584522 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_views),ss_tot |    505.7995122108 |      5 |      101.15990244216 |    0.16308366462628 |
| query: UPDATE cur SET cur_touched='X'                                            |    503.4210805152 |      5 |      100.68421610304 |    0.16231679287647 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_minor_edit,c |    488.3760553891 |      2 |      244.18802769455 |     0.1574658632636 |
| query: SELECT user_id FROM user WHERE user_name='X'                              |  466.301909244359 |     34 |      13.714762036599 |    0.15034855183907 |
| Setup.php-DateFormatter                                                          |  441.475397917662 |    974 |     0.45326016213312 |    0.14234380223118 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_minor_edit,c |   432.06689039256 |      2 |      216.03344519628 |    0.13931024081244 |
| Skin::doAfterContent                                                             |    386.7649246792 |      9 |      42.973880519911 |    0.12470364194283 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)                         |  349.428577570508 |     58 |      6.0246306477674 |    0.11266537744623 |
| Skin::makeBrokenLinkObj                                                          |  345.690548326398 |   1753 |      0.1971994000721 |    0.11146013407827 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X'                     |     331.117744611 |      1 |        331.117744611 |     0.1067614616272 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,old_user,ol |   318.39535647954 |      5 |      63.679071295908 |    0.10265941401904 |
| query: UPDATE user SET user_name= 'X' WHERE user_id=N                            |     313.624599874 |      4 |        78.4061499685 |    0.10112119096526 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE cur_namespa |  313.207957052462 |      7 |      44.743993864637 |    0.10098685386818 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_timestamp, 'X' |   302.81892334619 |     10 |      30.281892334619 |    0.09763714385889 |
| Setup.php-extensions                                                             |  276.767873481772 |    973 |     0.28444796863491 |   0.089237569370015 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND wl_title=' |  276.651452155037 |     69 |      4.0094413355802 |   0.089200031934438 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X'                           |  257.324199024267 |      5 |      51.464839804853 |    0.08296839431591 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)              |  257.157930121741 |     99 |      2.5975548497146 |   0.082914784651838 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,math_mathml F |  238.920629125313 |     29 |      8.2386423836315 |   0.077034577558735 |
| query: SELECT user_real_name FROM user WHERE (user_id=N)                         |  228.135876556415 |      2 |      114.06793827821 |   0.073557276911813 |
| Skin::doAfterContent-3                                                           |     223.647992764 |      9 |      24.849776973778 |   0.072110259827741 |
| Skin::doBeforeContent                                                            |    212.9990269283 |      9 |      23.666558547589 |   0.068676740555698 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N)                           |     193.906232609 |      1 |        193.906232609 |   0.062520698902084 |
| query: DELETE FROM imagelinks WHERE il_from='X'                                  |  174.057702366003 |      5 |      34.811540473201 |   0.056120987215283 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,oi_user AS  |    167.4582055726 |     10 |       16.74582055726 |   0.053993128062052 |
| Skin::doAfterContent-4                                                           |  160.743396435197 |      9 |      17.860377381689 |   0.051828089039758 |
| Skin::quickBar                                                                   |    160.2437830122 |      6 |        26.7072971687 |   0.051666999940319 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to='X' AND il |    156.6726258912 |     10 |       15.66726258912 |   0.050515560731326 |
| query: SELECT DISTINCT cur_title,cur_namespace FROM cur,categorylinks WHERE cl_t |   149.95867963449 |      6 |      24.993113272415 |   0.048350799925483 |
| Parser::replaceInternalLinks-setup                                               |  132.442225721718 |   1078 |     0.12285920753406 |   0.042703013744619 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'                 |  131.200260698974 |     29 |      4.5241469206543 |   0.042302570085902 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags,old_user_ |   115.98592641239 |      5 |      23.197185282478 |   0.037397050546232 |
| Skin::initPage                                                                   |  104.217429448225 |    722 |      0.1443454701499 |   0.033602563668081 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_minor_edit F |      99.673959408 |      2 |         49.836979704 |   0.032137624049929 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N)                       |     76.3692109725 |      1 |        76.3692109725 |   0.024623532623777 |
| query: INSERT INTO user (user_name,user_password,user_newpassword,user_email, us |     75.8830960407 |      1 |        75.8830960407 |   0.024466795808905 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N AND rc_titl |    73.13797885531 |      5 |      14.627595771062 |   0.023581694578844 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_title='X'   |   49.661597060412 |      9 |      5.5179552289347 |   0.016012263840283 |
| query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VALUES (N,'X' |   49.351909510638 |      2 |      24.675954755319 |    0.01591241206248 |
| Setup.php-BlockCache                                                             |  46.7329090565824 |    975 |    0.047931188775982 |   0.015067974332917 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N                       |     45.0776769384 |      1 |        45.0776769384 |   0.014534282003993 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                                  |    42.99853259679 |      5 |       8.599706519358 |   0.013863908723017 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespace,rc_title |   39.333323780283 |      5 |      7.8666647560566 |   0.012682144662384 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user_real_name |   38.784641072743 |      7 |      5.5406630103919 |    0.01250523427694 |
| query: DELETE FROM user_newtalk WHERE user_id=N                                  |   27.900436818972 |      4 |       6.975109204743 |   0.008995867673387 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                                |   24.383682057845 |      7 |      3.4833831511207 |  0.0078619692804651 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JOIN watchli |    23.40172437812 |      3 |      7.8005747927067 |  0.0075453591354344 |
| query: SELECT old.old_user, old.old_user_text, user.user_real_name, MAX(old.old_ |     20.9032409596 |      1 |        20.9032409596 |  0.0067397794105366 |
| query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user,old_user_t |     18.1060893281 |      1 |        18.1060893281 |  0.0058379008448841 |
| query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES (N,N,'X')  |   16.690287708219 |      3 |       5.563429236073 |  0.0053814074893551 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_id=N       |   14.269216811676 |      4 |       3.567304202919 |  0.0046007876892243 |
| query: DELETE FROM categorylinks WHERE cl_from='X'                               |   14.214734379015 |      5 |       2.842946875803 |  0.0045832210554858 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X'          |     9.10296363095 |      6 |      1.5171606051583 |  0.0029350456693924 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp > 'X' AND rc |     7.94511782011 |      2 |       3.972558910055 |  0.0025617243566085 |
| query: SELECT cur_title FROM cur WHERE cur_namespace=N AND cur_title >= 'X' ORDE |     4.90335538721 |      1 |        4.90335538721 |  0.0015809765454617 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N                |     3.50295135818 |      1 |        3.50295135818 |  0.0011294477964256 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges                    |    2.932115940891 |      5 |      0.5864231881782 | 0.00094539476849151 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_user_text, |     2.10648547105 |      1 |        2.10648547105 | 0.00067918881257775 |
| query: SELECT COUNT(*) AS cnt FROM old WHERE old_namespace = N AND old_title = ' |    1.238875289823 |      2 |      0.6194376449115 | 0.00039944744390161 |
| query: SELECT DISTINCT 'X' as type, N as namespace, cl_to as title, N as value F |    0.801505838952 |      1 |       0.801505838952 | 0.00025842751185015 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N            |    0.397651735013 |      1 |       0.397651735013 | 0.00012821384881821 |
| Skin::doAfterContent-2                                                           |  0.36374822660546 |      9 |    0.040416469622829 | 0.00011728242587037 |
| Skin::doAfterContent-1                                                           | 0.045221004925861 |      9 |   0.0050245561028734 | 1.4580494886518e-05 |
| Parser::replaceInternalLinks-prefixhandling                                      |  -3.8105105242303 |  15940 | -0.00023905335785636 | -0.0012286133248177 |
+----------------------------------------------------------------------------------+-------------------+--------+----------------------+---------------------+
122 rows in set (0.28 sec)