Profiling/Live 20040927 with breakdown by server

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

Taken between approximately 05:00 and 13:30. Sampling rate of 1/100, en only.

Request count vs response t.png


Basic report[edit]

+------------------------------------------------------------------------+---------------------+--------+---------------------+---------------------+
| name                                                                   | total               | count  | each                | percent             |
+------------------------------------------------------------------------+---------------------+--------+---------------------+---------------------+
| -total                                                                 |      1622711.546875 |   3221 |     490.89560090445 |                 100 |
| Setup.php                                                              |    578186.725585938 |   3221 |     171.43939337151 |     35.630899817001 |
| Parser::parse                                                          |    468181.455078125 |   4604 |     98.661186572955 |     28.851797842922 |
| Article::view                                                          |    376805.387695312 |   2144 |     172.56933185529 |     23.220725114144 |
| Parser::internalParse                                                  |    303597.254882812 |   4604 |     64.821846361157 |     18.709255842018 |
| Setup.php-MessageCache                                                 |    279694.093261719 |   3221 |     82.804488346918 |     17.236217601357 |
| MessageCache::initialise                                               |    279311.885498047 |   3221 |     82.692287340586 |     17.212663953488 |
| memcached::get                                                         |    254900.184326172 |  15347 |     16.213046736274 |     15.708286837365 |
| Setup.php-misc                                                         |    208219.898925781 |   3221 |     62.015251939567 |     12.831602716254 |
| Parser::replaceInternalLinks                                           |    200906.889160156 |   9208 |     21.304608471103 |      12.38093668262 |
| OutputPage::output                                                     |    176655.373046875 |   3099 |     56.944286959792 |      10.88643101031 |
| MessageCache::load                                                     |     172708.36151123 |   3221 |     51.789536063535 |     10.643195449236 |
| MessageCache::load-fromcache                                           |    172368.598510742 |   3221 |     51.687422791995 |     10.622257470386 |
| ParserOptions::initialiseFromUser                                      |    156196.038085938 |   9787 |     15.111896180081 |     9.6256194384478 |
| ParserOptions::initialiseFromUser-skin                                 |    151457.430175781 |   9787 |     14.634034451563 |     9.3336015552152 |
| Parser::tidy                                                           |    145226.111328125 |   4604 |     29.688407599766 |     8.9495949916545 |
| MessageCache::initialise-parseropt                                     |    106102.533935547 |   6442 |     15.371566969058 |     6.5385948685629 |
| wfMsg                                                                  |    87901.1208496094 | 159764 |    0.52181694406866 |     5.4169282901134 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X'           |    86979.8094468117 |     16 |     2769.9310893306 |     5.3601522472874 |
| LinkCache::addLinkObj                                                  |    85222.7807617188 |  28415 |     3.0625486134229 |     5.2518749204589 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  |    74842.6721191406 |  28415 |     2.6879618388087 |     4.6121981607435 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu |    72551.4192028046 |      9 |     8061.2688003116 |     4.4709991336737 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    66271.3537597656 |    171 |     408.06518950684 |     4.0839885491288 |
| -overhead-total                                                        |    63180.2429199219 | 970956 |   0.064997073745542 |     3.8934980799017 |
| Title::secureAndSplit                                                  |    61403.5798339844 | 195358 |    0.31107178546616 |     3.7840107782702 |
| Setup.php-includes                                                     |    47013.0777587891 |   3221 |     13.585780574789 |     2.8971925324206 |
| Parser::replaceVariables                                               |    41977.5294189453 |  13206 |     3.1519969840633 |     2.5868756218433 |
| ParserCache::get                                                       |    39190.8812255859 |   1969 |     19.329017942128 |     2.4151477384295 |
| -overhead-internal                                                     |    31253.3278808594 | 970956 |   0.032093510856164 |      1.925994052427 |
| memcached::_connect_sock                                               |    30895.2074279785 |  14765 |     1.8595934389095 |     1.9039247910373 |
| Parser::replaceExternalLinks                                           |    28848.6114501953 |   4604 |     6.3258543077848 |     1.7778028082534 |
| Skin::makeLink                                                         |     27481.129699707 |   4833 |     5.4873283827147 |     1.6935314075154 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR |    27112.9860076904 |   4231 |     6.3219920362371 |     1.6708444615375 |
| Title::newFromText                                                     |    23778.1378173828 | 161469 |    0.14923437798994 |     1.4653336178679 |
| memcached::_set                                                        |    22777.2354125977 |   4095 |     5.4794558323918 |     1.4036527598797 |
| DifferenceEngine::showDiffPage                                         |    21688.0624847412 |     30 |     712.02472894842 |     1.3365322090983 |
| Skin::makeKnownLinkObj                                                 |     21240.489074707 |  82879 |    0.25694151381075 |     1.3089503871228 |
| main-misc-setup                                                        |    20823.0560913086 |   3221 |     6.4293902485216 |     1.2832259763856 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |    14787.2092285156 |   3046 |     4.7876822750869 |    0.91126542218749 |
| query: BEGIN                                                           |    14119.5896606445 |   4371 |     3.2420850790171 |    0.87012320136847 |
| PageHistory::history                                                   |    13975.1088943481 |     23 |     483.82514216105 |    0.86121953844855 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     13254.816619873 |      6 |     2934.9791641235 |    0.81683134907119 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |    12170.4578552246 |   3222 |     3.6552876462582 |    0.75000747228689 |
| Setup.php-language                                                     |    11457.7327270508 |   3221 |     3.4224750376746 |    0.70608561016996 |
| query: COMMIT                                                          |     11119.546295166 |   4371 |     2.5228745328405 |    0.68524478774924 |
| LinkCache::preFill                                                     |    11063.7037658691 |   1202 |     9.0795558270533 |    0.68180347808429 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |    10847.2594909668 |   2837 |     3.8116801524253 |    0.66846504616648 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    10371.2833099365 |    342 |     31.304085922871 |    0.63913289641091 |
| Parser::doBlockLevels                                                  |    10196.0034790039 |   4604 |     2.2229646784572 |    0.62833123352325 |
| Article::getContent                                                    |    9437.45855712891 |   1347 |     6.9378518377724 |    0.58158571529878 |
| Setup.php-User                                                         |     8619.8706817627 |   3221 |     2.5964880108579 |    0.53120166047766 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |    8467.99908447266 |   3159 |     2.6983532347177 |     0.5218425357717 |
| query: SELECT cur_text FROM cur WHERE cur_namespace='X' LIMIT N        |    8395.73683166504 |   3227 |     2.5333893450296 |    0.51738935658857 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |    8290.53451478481 |     23 |     260.99531549215 |    0.51090623781846 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |    7943.08609008789 |    981 |     8.1101003898356 |    0.48949464280233 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    7915.22375488281 |      3 |     3554.1798400879 |    0.48777761951136 |
| Setup.php-SetupSession                                                 |    6721.89486694336 |   3221 |     1.9974672027474 |    0.41423843195596 |
| Parser::removeHTMLtags                                                 |    6384.39190673828 |   5656 |     1.1276393489836 |    0.39343972864637 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |     6038.1812286377 |   1332 |     4.4728351643812 |    0.37210441007004 |
| Setup.php-extensions                                                   |    5288.75880432129 |   3221 |     1.6208204029279 |    0.32592106801152 |
| Skin::outputPage                                                       |    4663.92128753662 |     51 |      86.95726026039 |    0.28741530166087 |
| Setup.php-OutputPage                                                   |    3806.25830078125 |   3221 |     1.1657501096979 |    0.23456160819902 |
| query: SELECT COUNT(user_id) AS total FROM user                        |    2972.39697265625 |      1 |     2972.3969726562 |    0.18317469783095 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |    2907.97978973389 |   1018 |     2.7829756667157 |    0.17920497301779 |
| Skin::doAfterContent                                                   |    2605.71569633484 |     40 |     64.989675336006 |    0.16057787358159 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |    2367.51244354248 |    996 |     2.3971912424887 |    0.14589853927531 |
| Parser::doAllQuotes                                                    |    2036.88550567627 |   4604 |    0.44765632603898 |    0.12552357254121 |
| query: UPDATE cur SET cur_text='X'                                     |    1907.12296295166 |     32 |     111.65410131108 |    0.11752692378534 |
| Setup.php-DateFormatter                                                |    1769.12295532227 |   3221 |    0.53646912242147 |    0.10902263921947 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |    1686.26461029053 |    631 |     2.7189301683935 |    0.10391647323506 |
| Skin::makeBrokenLinkObj                                                |    1643.85834503174 |   8335 |    0.20619776863204 |    0.10130317666115 |
| Setup.php-memcached                                                    |    1565.52010345459 |   3221 |    0.48318627188694 |    0.09647556316891 |
| Skin::doAfterContent-3                                                 |    1556.45915079117 |     40 |      38.27869479106 |   0.095917179722335 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |    1349.29079145193 |      3 |     449.76359715064 |   0.083150378392905 |
| Parser::doHeadings                                                     |    1236.51756286621 |   4604 |    0.26828639241048 |   0.076200700318395 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ |    1129.68452638388 |     46 |     18.661994227105 |   0.069617088049901 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |     1064.2802798152 |      5 |     212.85605596304 |   0.065586535195659 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |    1060.91578865051 |    311 |     3.3184163724051 |    0.06537919759637 |
| Skin::doAfterContent-4                                                 |    1026.14902305603 |     40 |     26.059005502554 |   0.063236687076774 |
| Skin::quickBar                                                         |    1023.49976158142 |     34 |     31.779948845888 |   0.063073425683848 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N             |    960.837266027927 |     17 |     43.442687394442 |   0.059211833913322 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 |    935.374981343746 |     46 |     15.383698405491 |   0.057642714328685 |
| query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user, |     868.81635093689 |     12 |     85.690272104172 |   0.053541022285202 |
| Skin::doBeforeContent                                                  |    850.038271903992 |     40 |     20.561382239904 |   0.052383818525294 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |    834.891572475433 |     43 |      16.64525453565 |    0.05145039943071 |
| query: SELECT COUNT(user_id) AS total FROM user WHERE user_rights LIKE |    786.190795898438 |      1 |     786.19079589844 |   0.048449202041637 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat |    767.671352386475 |     26 |     43.240277862549 |   0.047307936759608 |
| Setup.php-database                                                     |    766.318347930908 |   3221 |    0.22149086703104 |   0.047224557525746 |
| Parser::replaceInternalLinks-setup                                     |    764.437412261963 |   9208 |   0.083346259209477 |   0.047108644400424 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |    724.417985916138 |    391 |     1.7306822769331 |   0.044642437364251 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    558.383796691895 |     12 |     52.037086963654 |    0.03441053943119 |
| Skin::initPage                                                         |     524.31721496582 |   2453 |    0.21592684794162 |    0.03231117791548 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |    496.494028091431 |     12 |     45.752885909308 |   0.030596567150063 |
| query: SELECT COUNT(cur_id) AS total FROM cur                          |    479.549926757812 |      1 |     479.54992675781 |   0.029552382718994 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |    437.003462731838 |     22 |     17.809957907597 |   0.026930446361426 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link |    423.269980430603 |     28 |     13.564019290728 |   0.026084117121477 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |    357.313192993402 |     65 |     5.8309641538304 |   0.022019513799696 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |    344.243787109852 |    137 |     3.1537651892842 |    0.02121410843306 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o |    339.942971229553 |     65 |     5.4034524610191 |   0.020949069591833 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |    315.448284626007 |     89 |     3.6764978963959 |    0.01943957847798 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id='X' LIMIT  |    298.017235338688 |     15 |     19.931142675025 |   0.018365385758954 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o |    292.973892450333 |     32 |     5.7701217752514 |   0.018054588507399 |
| query: SELECT user_id FROM user WHERE user_name='X'                    |    278.455575108528 |     59 |     4.6515905403392 |   0.017159893614165 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |    256.723882555962 |     89 |     2.5577065386178 |   0.015820672691358 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |    242.140460968018 |     69 |     3.0435795256543 |    0.01492196573287 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A |    233.893060684204 |     32 |     5.2100242529855 |   0.014413717652693 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     215.52294921875 |      1 |     215.52294921875 |   0.013281654994925 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |    186.376576125622 |      5 |     37.275315225124 |   0.011485502551858 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |    176.373719155788 |      3 |     58.791239718596 |   0.010869074019683 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= |    169.865407019854 |     65 |      2.387377200655 |   0.010467997676295 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |    157.267862677574 |    108 |     1.3351198086196 |  0.0096916708937235 |
| query: SELECT qc_type as type, qc_namespace as namespace,qc_title as t |     151.65852355957 |      1 |     151.65852355957 |  0.0093459939846754 |
| query: DELETE FROM user_newtalk WHERE user_id=N                        |    132.123678505421 |      9 |     18.715982160398 |  0.0081421543317334 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |    131.469092100859 |     46 |     2.2164801110824 |  0.0081018152828234 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |    128.973555862904 |     26 |     4.7405739366062 |  0.0079480272455865 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ |     125.01642036438 |      5 |     23.635264714559 |  0.0077041677927994 |
| Parser::replaceInternalLinks-prefixhandling                            |      119.2636375539 |  65066 |  0.0015143579761527 |  0.0073496511307618 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    116.270286560059 |      1 |     116.27028656006 |  0.0071651851361982 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      |    107.964420437813 |     32 |     2.6131059045141 |  0.0066533340842819 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        |    97.9122161269188 |     32 |     4.3487610612855 |  0.0060338645100219 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |    92.4318405389786 |     12 |     5.2688911642347 |  0.0056961350103771 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t |    82.9733724296093 |     19 |     5.1408384035934 |  0.0051132545762307 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac |    77.6844197511673 |     34 |     1.8405794795715 |  0.0047873215606786 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO |    77.0732805728912 |      6 |     10.680660295486 |  0.0047496599578229 |
| Setup.php-BlockCache                                                   |    67.6592740416527 |   3221 |   0.021361497950381 |   0.004169519479414 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    53.9821281433105 |      6 |     9.2215514183044 |  0.0033266619842121 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges          |    53.2853527069092 |     11 |     3.3276492555936 |  0.0032837230257913 |
| query: SELECT cur_title FROM cur WHERE cur_namespace=N AND cur_title > |    32.7238521575928 |      2 |     16.361926078796 |  0.0020166154743036 |
| query: SELECT cur_namespace,cur_title,cur_id FROM brokenlinks,cur WHER |    28.2045516967773 |      2 |     14.102275848389 |  0.0017381124668209 |
| query: UPDATE user SET user_name= 'X' WHERE user_id=N                  |     23.143497467041 |      9 |     3.0459547979491 |  0.0014262237494773 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp >  |    13.2642889022827 |      4 |     3.5465744336446 | 0.00081741508081501 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM brok |    8.75241184234619 |      1 |     8.7524118423462 |  0.0005393695422456 |
| query: SELECT DISTINCT 'X' as type, N as namespace, cl_to as title, N  |    8.03912734985352 |      3 |     2.6797091166178 | 0.00049541320916433 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_text,cur_comment,c |    6.05951941013336 |      2 |     3.0297597050667 | 0.00037341938077674 |
| query: INSERT INTO user (user_name,user_password,user_newpassword,user |    6.02246236801147 |      1 |     6.0224623680115 | 0.00037113573140029 |
| query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES  |    5.61994901299477 |      7 |    0.87321182092031 | 0.00034633074644829 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO |    4.78285264968872 |      1 |     4.7828526496887 |  0.0002947444762379 |
| query: UPDATE cur set cur_touched='X'                                  |    4.09614241123199 |      2 |      2.048071205616 |  0.0002524257881273 |
| Skin::doAfterContent-2                                                 |    2.56273725442588 |     40 |   0.053205894172574 | 0.00015792931648026 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     2.4613356590271 |      2 |     1.2306678295135 | 0.00015168041811048 |
| query: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_fro |    2.44127893447876 |      2 |     1.2206394672394 | 0.00015044441750477 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    1.07093501091003 |      2 |    0.53546750545502 | 6.5996634643565e-05 |
| Skin::doAfterContent-1                                                 | -0.0496150735998526 |     40 | -0.0017541725570575 | -3.057541169002e-06 |
+------------------------------------------------------------------------+---------------------+--------+---------------------+---------------------+

Breakdown by server[edit]

    average time per request (ms)
server requests total parse memcached get
dalembert.wikimedia.org 305 912.663 146.3059 22.66566204
avicenna.wikimedia.org 292 665.8515 167.7046 27.53103911
isidore.wikimedia.org 217 637.0766 93.70463 16.77243281
alrazi.wikimedia.org 283 559.8917 115.7494 22.260118
moreri.wikimedia.org 176 494.137 72.24291 16.97927864
harris.wikimedia.org 249 493.6051 95.12293 16.11586293
bart.wikimedia.org 262 484.7492 90.24099 12.98728575
vincent 209 422.378 98.94985 19.3697839
tingxi.wikimedia.org 263 376.6062 100.1559 12.68490473
goeje.wikimedia.org 288 368.1998 73.87426 13.74310366
bayle.wikimedia.org 243 367.8818 88.13722 14.16714945
friedrich.wikimedia.org 277 330.0313 78.56876 12.56430095
yongle.wikimedia.org 157 268.5718 61.83809 2.928685602