Profiling/Live aggregate 20040710

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

Run taken for a couple of hours ending at 09:00, sampling rate 1/200. Unlike all previous runs, this one includes requests which end in a redirect, for example page saving.

Sorted by total time[edit]

+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
| name                                                                   | total       | count  | each                 | percent              |
+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
| -total                                                                 | 2.99557e+06 |   1199 |      2498.3880316931 |                  100 |
| LinkCache::addLinkObj                                                  |  1.1166e+06 |  10574 |      105.59817713259 |      37.274914292109 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  | 1.11246e+06 |  10574 |      105.20758464157 |      37.137039737632 |
| Article::view                                                          |      972037 |    904 |      1075.2623064159 |      32.449183873271 |
| Parser::internalParse                                                  |      872486 |   1332 |      655.01942567568 |      29.125898442106 |
| Parser::parse                                                          |      757571 |    657 |      1153.0761035008 |      25.289734356656 |
| Parser::replaceInternalLinks                                           |      567532 |   2664 |      213.03739677177 |       18.94571470562 |
| OutputPage::output                                                     |      494470 |   1200 |      412.05799479167 |      16.506709831001 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X'           |      296017 |      7 |      42288.196428571 |        9.88184708589 |
| Parser::replaceVariables                                               |      295414 |   5677 |      52.036980359345 |      9.8617027376034 |
| ParserCache::get                                                       |      256056 |    890 |      287.70284410112 |      8.5478144832168 |
| Setup.php                                                              |      219353 |   1199 |      182.94643974145 |       7.322579095829 |
| Skin::makeLink                                                         |      129121 |   2729 |      47.314475311469 |       4.310409092802 |
| LinkCache::preFill                                                     |      107168 |    595 |      180.11397058824 |      3.5775465398081 |
| wfMsg                                                                  |      106317 |  62344 |      1.7053262443058 |      3.5491394618165 |
| DifferenceEngine::showDiffPage                                         |      105623 |      6 |      17603.897135417 |      3.5259893702103 |
| Setup.php-MessageCache                                                 |      103530 |   1201 |      86.202871305162 |      3.4560949495459 |
| Article::getContent                                                    |     89139.1 |    670 |      133.04341184701 |      2.9756997088782 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |       84965 |   1054 |      80.611998932638 |      2.8363591862276 |
| LinksUpdate::doUpdate                                                  |     78978.8 |     14 |      5641.3443080357 |      2.6365230262315 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     77258.7 |     11 |      7023.5149147727 |      2.5790996367216 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     69364.5 |     22 |      3152.9332386364 |      2.3155724929894 |
| query: UPDATE cur SET cur_text='X'                                     |     68800.9 |     12 |       5733.408203125 |       2.296756931012 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |     66068.9 |    570 |       115.9102933114 |      2.2055544634326 |
| query: UPDATE cur SET cur_touched='X'                                  |     64822.1 |     21 |      3086.7648809524 |      2.1639328077178 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |     64691.2 |    719 |       89.97385148644 |       2.159564243425 |
| Setup.php-misc                                                         |     58154.2 |   1200 |      48.461861979167 |      1.9413429751911 |
| PageHistory::history                                                   |     49751.5 |     10 |        4975.15390625 |      1.6608386629444 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |     47126.9 |   1042 |      45.227394733685 |      1.5732227447907 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |     42881.9 |   1237 |      34.666055098019 |      1.4315121837525 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |     41541.9 |    406 |       102.3199565117 |      1.3867791598987 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |     39546.6 |    363 |      108.94391356749 |      1.3201720183381 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |     37599.8 |    381 |      98.687120652887 |      1.2551810669165 |
| query: COMMIT                                                          |     35022.9 |   1927 |      18.174856885703 |      1.1691591707297 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ |     34733.6 |     28 |      1240.4874441964 |      1.1595015414026 |
| Setup.php-User                                                         |     33685.1 |   1200 |      28.070950520833 |      1.1244995626454 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO |     33678.6 |      3 |      11226.184895833 |      1.1242797065397 |
| main-misc-setup                                                        |     32435.7 |   1199 |      27.052289668474 |      1.0827897558467 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |     30847.9 |   1162 |       26.54727167599 |      1.0297859174252 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     28825.2 |      2 |      14412.583984375 |     0.96226075274224 |
| Parser::tidy                                                           |     28133.9 |    657 |      42.821828624429 |     0.93918577211879 |
| Title::secureAndSplit                                                  |     26540.4 |  82223 |     0.32278588507018 |     0.88598991820748 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |     25970.3 |     10 |       2597.026953125 |       0.866956651741 |
| -overhead-total                                                        |     24469.6 | 356889 |    0.068563537306067 |     0.81685938666959 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR |       23143 |    839 |         27.583984375 |     0.77257363828587 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |     20504.2 |    552 |      37.145245980525 |     0.68448390805615 |
| Skin::outputPage                                                       |       18761 |     31 |      605.19367439516 |     0.62629219578529 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |     17602.1 |    147 |      119.74193505527 |     0.58760371522706 |
| query: SELECT 'X' as type, rc_namespace AS namespace, rc_title AS titl |     16271.8 |      1 |       16271.80859375 |     0.54319623749892 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |     15999.3 |     20 |         799.96484375 |     0.53409907172006 |
| Parser::replaceExternalLinks                                           |     14341.8 |   1332 |       10.76709277637 |      0.4787663364301 |
| Skin::doAfterContent                                                   |     13035.6 |     27 |      482.80085358796 |     0.43516375894666 |
| query: BEGIN                                                           |     12890.9 |   1927 |      6.6896249229696 |     0.43033276006614 |
| -overhead-internal                                                     |     11902.3 | 356855 |     0.03335327023581 |     0.39732979621806 |
| Skin::doAfterContent-3                                                 |     11242.8 |     27 |      416.40024594907 |     0.37531478021817 |
| Title::newFromText                                                     |     10643.3 |  67958 |     0.15661580498249 |     0.35530155014881 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |     10216.5 |     20 |         510.82578125 |     0.34105445721507 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= |     9911.83 |     16 |      619.48962402344 |     0.33088337390439 |
| Skin::makeKnownLinkObj                                                 |     8644.56 |  33972 |     0.25446127969357 |     0.28857835168781 |
| Setup.php-memcached                                                    |     7957.26 |   1201 |      6.6255309702852 |     0.26563458708238 |
| Parser::doBlockLevels                                                  |     7823.72 |    657 |      11.908247716895 |     0.26117653509531 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o |     7806.23 |     16 |      487.88925170898 |     0.26059264826532 |
| Setup.php-includes                                                     |     7776.53 |   1201 |      6.4750448031588 |     0.25960120937341 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |     6847.99 |     26 |      263.38407076322 |     0.22860397608646 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |     6574.71 |     16 |      410.91906738281 |     0.21948113760841 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |     6119.51 |    159 |      38.487510441234 |     0.20428565441675 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat |     5907.85 |     11 |      537.07737038352 |      0.1972197777973 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     5579.79 |      1 |         5579.7890625 |     0.18626819553125 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o |     5071.34 |     12 |      422.61157226562 |     0.16929477604576 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ |      4847.1 |      1 |      4847.1040039062 |      0.1618092200703 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |     4724.31 |     90 |      52.492388237847 |     0.15771019466868 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 |     4350.68 |     28 |      155.38150460379 |     0.14523733790007 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac |     4149.82 |     15 |      276.65475260417 |     0.13853206897834 |
| query: DELETE FROM brokenlinks WHERE bl_from=N AND bl_to IN('X')       |     3855.72 |      2 |      1927.8608398438 |     0.12871424200834 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A |      3827.8 |     12 |      318.98313395182 |     0.12778206222617 |
| Skin::doBeforeContent                                                  |     3497.32 |     27 |      129.53035481771 |     0.11674982693439 |
| query: SELECT user_id FROM user WHERE user_name='X'                    |     2906.89 |     23 |      126.38660198709 |    0.097039779217213 |
| Setup.php-language                                                     |     2718.93 |   1201 |      2.2638851168948 |    0.090764980335214 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |     2684.02 |      1 |          2684.015625 |    0.089599578343634 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |     2657.16 |     35 |      75.918910435268 |    0.088703128438675 |
| query: DELETE FROM imagelinks WHERE il_from='X'                        |     2546.65 |     14 |      181.90384347098 |    0.085014075667764 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X'                 |     2444.36 |     14 |      174.59720284598 |     0.08159926437451 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      |     2433.16 |     12 |      202.76302083333 |     0.08122522537259 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        |     2309.71 |     12 |      192.47583007812 |    0.077104260000756 |
| Setup.php-SetupSession                                                 |     2031.59 |   1201 |      1.6915820881687 |     0.06781987911941 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |     1941.51 |      5 |      388.30256347656 |    0.064812860314947 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie |     1855.86 |     14 |      132.56127929688 |     0.06195347175585 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N             |     1792.28 |      7 |      256.04068429129 |    0.059831231965801 |
| Skin::doAfterContent-4                                                 |     1784.17 |     27 |      66.080362955729 |    0.059560332014068 |
| Skin::quickBar                                                         |     1781.63 |     26 |      68.524362417368 |    0.059475661007162 |
| query: SELECT cur_id,cur_text,cur_timestamp FROM cur WHERE cur_namespa |     1754.72 |      2 |      877.35968017578 |    0.058577198036584 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t |     1686.23 |      4 |      421.55767822266 |    0.056290864873443 |
| Parser::doAllQuotes                                                    |     1679.67 |   1332 |      1.2610137297942 |    0.056071860449334 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |     1557.45 |     28 |      55.623182024275 |    0.051991792094792 |
| Parser::removeHTMLtags                                                 |     1530.95 |   1332 |      1.1493592591615 |     0.05110706605579 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N)             |      1463.1 |      4 |      365.77407836914 |    0.048842045307998 |
| query: DELETE FROM categorylinks WHERE cl_from='X'                     |     1394.86 |     14 |      99.633082798549 |    0.046564241186029 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu |     1325.84 |      1 |      1325.8420410156 |    0.044260132734981 |
| Setup.php-OutputPage                                                   |     1075.58 |   1201 |     0.89557042308493 |    0.035905722968663 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges          |     1049.17 |      4 |      262.29357910156 |    0.035024228429732 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link |        1048 |      3 |      349.33182779948 |    0.034984875849422 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N,N,N,N,N,N,N,N,N, |     927.007 |      1 |      927.00738525391 |    0.030945971426744 |
| Skin::makeBrokenLinkObj                                                |     884.287 |   3750 |     0.23580986328125 |    0.029519850949922 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N)       |     730.944 |      2 |      365.47186279297 |    0.024400845134955 |
| Setup.php-DateFormatter                                                |     699.087 |   1201 |     0.58208771133105 |    0.023337394321847 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_comment,cur_user,c |     687.874 |      1 |      687.87353515625 |    0.022963047655039 |
| query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VAL |     619.466 |      5 |      123.89318847656 |    0.020679420312891 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |     593.409 |     56 |      10.596580505371 |    0.019809553876675 |
| Setup.php-extensions                                                   |     574.428 |   1199 |     0.47908927402067 |     0.01917593536085 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |      554.68 |      6 |      92.446746826172 |    0.018516709346353 |
| query: UPDATE cur SET cur_timestamp='X' WHERE cur_id=N                 |     542.254 |      1 |      542.25366210938 |    0.018101869090383 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp >  |     452.382 |      1 |      452.38165283203 |    0.015101702451582 |
| Parser::doHeadings                                                     |     408.549 |   1332 |     0.30671852272194 |    0.013638454361711 |
| Parser::replaceInternalLinks-setup                                     |     263.633 |   2664 |    0.098961334686738 |   0.0088007703918338 |
| query: SELECT cur_id,cur_text FROM cur WHERE cur_namespace=N AND cur_t |     246.659 |      1 |      246.65852355957 |   0.0082341173799243 |
| Skin::initPage                                                         |      228.93 |   1039 |     0.22033725184128 |   0.0076423056321999 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N)                 |     193.893 |      1 |      193.89347839355 |   0.0064726798703503 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |     187.694 |      2 |       93.84716796875 |   0.0062657360116853 |
| Setup.php-database                                                     |     184.874 |   1201 |     0.15393354811339 |     0.00617159208441 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |     172.254 |      4 |      43.063438415527 |   0.0057502883189189 |
| query: INSERT INTO image (img_name,img_size,img_timestamp,img_descript |     167.137 |      1 |      167.13662719727 |   0.0055794650311144 |
| query: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_fro |     166.751 |      1 |      166.75134277344 |   0.0055666032125781 |
| query: DELETE FROM user_newtalk WHERE user_id=N                        |     138.236 |      2 |      69.117881774902 |   0.0046146773553425 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_text,cur_comment,c |     117.989 |      1 |      117.98926544189 |   0.0039387954131858 |
| query: SELECT cur_namespace,cur_title,cur_id FROM brokenlinks,cur WHER |     101.318 |      1 |      101.31832122803 |   0.0033822749673881 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |      58.592 |      1 |      58.591983795166 |   0.0019559562148093 |
| query: SELECT img_name,img_size,img_timestamp,img_description,img_user |     24.5928 |      1 |      24.592832565308 |  0.00082097414322138 |
| Setup.php-BlockCache                                                   |     21.9101 |   1201 |    0.018243252883644 |  0.00073141895623464 |
| query: INSERT IGNORE INTO brokenlinks (bl_from,bl_to) VALUES (N,'X')   |     20.6013 |      1 |      20.601324081421 |  0.00068772697663259 |
| query: UPDATE user SET user_name= 'X' WHERE user_id=N                  |     17.1644 |      2 |      8.5822105407715 |   0.0005729940157926 |
| query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X')    |     12.5366 |      4 |      3.1341509819031 |  0.00041850517385688 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N),(N,N) |     10.1024 |      1 |      10.102360725403 |  0.00033724366312934 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |     1.38202 |      1 |      1.3820154666901 |  4.6135351048789e-05 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N  |     1.34893 |      3 |     0.44964277744293 |  4.5030814525322e-05 |
| Skin::doAfterContent-2                                                 |     1.25356 |     27 |    0.046428313961735 |  4.1847315461432e-05 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |     1.15758 |      1 |      1.1575754880905 |  3.8642947778606e-05 |
| query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES  |    0.548606 |      1 |     0.54860645532608 |  1.8313942219995e-05 |
| Skin::doAfterContent-1                                                 |   -0.217717 |     27 |  -0.0080635762876934 | -7.2679576720477e-06 |
| Parser::replaceInternalLinks-prefixhandling                            |    -23.8646 |  26429 | -0.00090296874951503 | -0.00079666250460351 |
+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+

Sorted by time per invocation[edit]

+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
| name                                                                   | total       | count  | each                 | percent              |
+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X'           |      296017 |      7 |      42288.196428571 |        9.88184708589 |
| DifferenceEngine::showDiffPage                                         |      105623 |      6 |      17603.897135417 |      3.5259893702103 |
| query: SELECT 'X' as type, rc_namespace AS namespace, rc_title AS titl |     16271.8 |      1 |       16271.80859375 |     0.54319623749892 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     28825.2 |      2 |      14412.583984375 |     0.96226075274224 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO |     33678.6 |      3 |      11226.184895833 |      1.1242797065397 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     77258.7 |     11 |      7023.5149147727 |      2.5790996367216 |
| query: UPDATE cur SET cur_text='X'                                     |     68800.9 |     12 |       5733.408203125 |       2.296756931012 |
| LinksUpdate::doUpdate                                                  |     78978.8 |     14 |      5641.3443080357 |      2.6365230262315 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     5579.79 |      1 |         5579.7890625 |     0.18626819553125 |
| PageHistory::history                                                   |     49751.5 |     10 |        4975.15390625 |      1.6608386629444 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ |      4847.1 |      1 |      4847.1040039062 |      0.1618092200703 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |     69364.5 |     22 |      3152.9332386364 |      2.3155724929894 |
| query: UPDATE cur SET cur_touched='X'                                  |     64822.1 |     21 |      3086.7648809524 |      2.1639328077178 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |     2684.02 |      1 |          2684.015625 |    0.089599578343634 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |     25970.3 |     10 |       2597.026953125 |       0.866956651741 |
| -total                                                                 | 2.99557e+06 |   1199 |      2498.3880316931 |                  100 |
| query: DELETE FROM brokenlinks WHERE bl_from=N AND bl_to IN('X')       |     3855.72 |      2 |      1927.8608398438 |     0.12871424200834 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu |     1325.84 |      1 |      1325.8420410156 |    0.044260132734981 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ |     34733.6 |     28 |      1240.4874441964 |      1.1595015414026 |
| Parser::parse                                                          |      757571 |    657 |      1153.0761035008 |      25.289734356656 |
| Article::view                                                          |      972037 |    904 |      1075.2623064159 |      32.449183873271 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N,N,N,N,N,N,N,N,N, |     927.007 |      1 |      927.00738525391 |    0.030945971426744 |
| query: SELECT cur_id,cur_text,cur_timestamp FROM cur WHERE cur_namespa |     1754.72 |      2 |      877.35968017578 |    0.058577198036584 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |     15999.3 |     20 |         799.96484375 |     0.53409907172006 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_comment,cur_user,c |     687.874 |      1 |      687.87353515625 |    0.022963047655039 |
| Parser::internalParse                                                  |      872486 |   1332 |      655.01942567568 |      29.125898442106 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= |     9911.83 |     16 |      619.48962402344 |     0.33088337390439 |
| Skin::outputPage                                                       |       18761 |     31 |      605.19367439516 |     0.62629219578529 |
| query: UPDATE cur SET cur_timestamp='X' WHERE cur_id=N                 |     542.254 |      1 |      542.25366210938 |    0.018101869090383 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat |     5907.85 |     11 |      537.07737038352 |      0.1972197777973 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |     10216.5 |     20 |         510.82578125 |     0.34105445721507 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o |     7806.23 |     16 |      487.88925170898 |     0.26059264826532 |
| Skin::doAfterContent                                                   |     13035.6 |     27 |      482.80085358796 |     0.43516375894666 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp >  |     452.382 |      1 |      452.38165283203 |    0.015101702451582 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o |     5071.34 |     12 |      422.61157226562 |     0.16929477604576 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t |     1686.23 |      4 |      421.55767822266 |    0.056290864873443 |
| Skin::doAfterContent-3                                                 |     11242.8 |     27 |      416.40024594907 |     0.37531478021817 |
| OutputPage::output                                                     |      494470 |   1200 |      412.05799479167 |      16.506709831001 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |     6574.71 |     16 |      410.91906738281 |     0.21948113760841 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |     1941.51 |      5 |      388.30256347656 |    0.064812860314947 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N)             |      1463.1 |      4 |      365.77407836914 |    0.048842045307998 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N)       |     730.944 |      2 |      365.47186279297 |    0.024400845134955 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link |        1048 |      3 |      349.33182779948 |    0.034984875849422 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A |      3827.8 |     12 |      318.98313395182 |     0.12778206222617 |
| ParserCache::get                                                       |      256056 |    890 |      287.70284410112 |      8.5478144832168 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac |     4149.82 |     15 |      276.65475260417 |     0.13853206897834 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |     6847.99 |     26 |      263.38407076322 |     0.22860397608646 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges          |     1049.17 |      4 |      262.29357910156 |    0.035024228429732 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N             |     1792.28 |      7 |      256.04068429129 |    0.059831231965801 |
| query: SELECT cur_id,cur_text FROM cur WHERE cur_namespace=N AND cur_t |     246.659 |      1 |      246.65852355957 |   0.0082341173799243 |
| Parser::replaceInternalLinks                                           |      567532 |   2664 |      213.03739677177 |       18.94571470562 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      |     2433.16 |     12 |      202.76302083333 |     0.08122522537259 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N)                 |     193.893 |      1 |      193.89347839355 |   0.0064726798703503 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        |     2309.71 |     12 |      192.47583007812 |    0.077104260000756 |
| Setup.php                                                              |      219353 |   1199 |      182.94643974145 |       7.322579095829 |
| query: DELETE FROM imagelinks WHERE il_from='X'                        |     2546.65 |     14 |      181.90384347098 |    0.085014075667764 |
| LinkCache::preFill                                                     |      107168 |    595 |      180.11397058824 |      3.5775465398081 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X'                 |     2444.36 |     14 |      174.59720284598 |     0.08159926437451 |
| query: INSERT INTO image (img_name,img_size,img_timestamp,img_descript |     167.137 |      1 |      167.13662719727 |   0.0055794650311144 |
| query: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_fro |     166.751 |      1 |      166.75134277344 |   0.0055666032125781 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 |     4350.68 |     28 |      155.38150460379 |     0.14523733790007 |
| Article::getContent                                                    |     89139.1 |    670 |      133.04341184701 |      2.9756997088782 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie |     1855.86 |     14 |      132.56127929688 |     0.06195347175585 |
| Skin::doBeforeContent                                                  |     3497.32 |     27 |      129.53035481771 |     0.11674982693439 |
| query: SELECT user_id FROM user WHERE user_name='X'                    |     2906.89 |     23 |      126.38660198709 |    0.097039779217213 |
| query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VAL |     619.466 |      5 |      123.89318847656 |    0.020679420312891 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |     17602.1 |    147 |      119.74193505527 |     0.58760371522706 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_text,cur_comment,c |     117.989 |      1 |      117.98926544189 |   0.0039387954131858 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |     66068.9 |    570 |       115.9102933114 |      2.2055544634326 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |     39546.6 |    363 |      108.94391356749 |      1.3201720183381 |
| LinkCache::addLinkObj                                                  |  1.1166e+06 |  10574 |      105.59817713259 |      37.274914292109 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  | 1.11246e+06 |  10574 |      105.20758464157 |      37.137039737632 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |     41541.9 |    406 |       102.3199565117 |      1.3867791598987 |
| query: SELECT cur_namespace,cur_title,cur_id FROM brokenlinks,cur WHER |     101.318 |      1 |      101.31832122803 |   0.0033822749673881 |
| query: DELETE FROM categorylinks WHERE cl_from='X'                     |     1394.86 |     14 |      99.633082798549 |    0.046564241186029 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |     37599.8 |    381 |      98.687120652887 |      1.2551810669165 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |     187.694 |      2 |       93.84716796875 |   0.0062657360116853 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |      554.68 |      6 |      92.446746826172 |    0.018516709346353 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |     64691.2 |    719 |       89.97385148644 |       2.159564243425 |
| Setup.php-MessageCache                                                 |      103530 |   1201 |      86.202871305162 |      3.4560949495459 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |       84965 |   1054 |      80.611998932638 |      2.8363591862276 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |     2657.16 |     35 |      75.918910435268 |    0.088703128438675 |
| query: DELETE FROM user_newtalk WHERE user_id=N                        |     138.236 |      2 |      69.117881774902 |   0.0046146773553425 |
| Skin::quickBar                                                         |     1781.63 |     26 |      68.524362417368 |    0.059475661007162 |
| Skin::doAfterContent-4                                                 |     1784.17 |     27 |      66.080362955729 |    0.059560332014068 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |      58.592 |      1 |      58.591983795166 |   0.0019559562148093 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |     1557.45 |     28 |      55.623182024275 |    0.051991792094792 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |     4724.31 |     90 |      52.492388237847 |     0.15771019466868 |
| Parser::replaceVariables                                               |      295414 |   5677 |      52.036980359345 |      9.8617027376034 |
| Setup.php-misc                                                         |     58154.2 |   1200 |      48.461861979167 |      1.9413429751911 |
| Skin::makeLink                                                         |      129121 |   2729 |      47.314475311469 |       4.310409092802 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |     47126.9 |   1042 |      45.227394733685 |      1.5732227447907 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |     172.254 |      4 |      43.063438415527 |   0.0057502883189189 |
| Parser::tidy                                                           |     28133.9 |    657 |      42.821828624429 |     0.93918577211879 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |     6119.51 |    159 |      38.487510441234 |     0.20428565441675 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |     20504.2 |    552 |      37.145245980525 |     0.68448390805615 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |     42881.9 |   1237 |      34.666055098019 |      1.4315121837525 |
| Setup.php-User                                                         |     33685.1 |   1200 |      28.070950520833 |      1.1244995626454 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR |       23143 |    839 |         27.583984375 |     0.77257363828587 |
| main-misc-setup                                                        |     32435.7 |   1199 |      27.052289668474 |      1.0827897558467 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |     30847.9 |   1162 |       26.54727167599 |      1.0297859174252 |
| query: SELECT img_name,img_size,img_timestamp,img_description,img_user |     24.5928 |      1 |      24.592832565308 |  0.00082097414322138 |
| query: INSERT IGNORE INTO brokenlinks (bl_from,bl_to) VALUES (N,'X')   |     20.6013 |      1 |      20.601324081421 |  0.00068772697663259 |
| query: COMMIT                                                          |     35022.9 |   1927 |      18.174856885703 |      1.1691591707297 |
| Parser::doBlockLevels                                                  |     7823.72 |    657 |      11.908247716895 |     0.26117653509531 |
| Parser::replaceExternalLinks                                           |     14341.8 |   1332 |       10.76709277637 |      0.4787663364301 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |     593.409 |     56 |      10.596580505371 |    0.019809553876675 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N),(N,N) |     10.1024 |      1 |      10.102360725403 |  0.00033724366312934 |
| query: UPDATE user SET user_name= 'X' WHERE user_id=N                  |     17.1644 |      2 |      8.5822105407715 |   0.0005729940157926 |
| query: BEGIN                                                           |     12890.9 |   1927 |      6.6896249229696 |     0.43033276006614 |
| Setup.php-memcached                                                    |     7957.26 |   1201 |      6.6255309702852 |     0.26563458708238 |
| Setup.php-includes                                                     |     7776.53 |   1201 |      6.4750448031588 |     0.25960120937341 |
| query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X')    |     12.5366 |      4 |      3.1341509819031 |  0.00041850517385688 |
| Setup.php-language                                                     |     2718.93 |   1201 |      2.2638851168948 |    0.090764980335214 |
| wfMsg                                                                  |      106317 |  62344 |      1.7053262443058 |      3.5491394618165 |
| Setup.php-SetupSession                                                 |     2031.59 |   1201 |      1.6915820881687 |     0.06781987911941 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |     1.38202 |      1 |      1.3820154666901 |  4.6135351048789e-05 |
| Parser::doAllQuotes                                                    |     1679.67 |   1332 |      1.2610137297942 |    0.056071860449334 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |     1.15758 |      1 |      1.1575754880905 |  3.8642947778606e-05 |
| Parser::removeHTMLtags                                                 |     1530.95 |   1332 |      1.1493592591615 |     0.05110706605579 |
| Setup.php-OutputPage                                                   |     1075.58 |   1201 |     0.89557042308493 |    0.035905722968663 |
| Setup.php-DateFormatter                                                |     699.087 |   1201 |     0.58208771133105 |    0.023337394321847 |
| query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES  |    0.548606 |      1 |     0.54860645532608 |  1.8313942219995e-05 |
| Setup.php-extensions                                                   |     574.428 |   1199 |     0.47908927402067 |     0.01917593536085 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N  |     1.34893 |      3 |     0.44964277744293 |  4.5030814525322e-05 |
| Title::secureAndSplit                                                  |     26540.4 |  82223 |     0.32278588507018 |     0.88598991820748 |
| Parser::doHeadings                                                     |     408.549 |   1332 |     0.30671852272194 |    0.013638454361711 |
| Skin::makeKnownLinkObj                                                 |     8644.56 |  33972 |     0.25446127969357 |     0.28857835168781 |
| Skin::makeBrokenLinkObj                                                |     884.287 |   3750 |     0.23580986328125 |    0.029519850949922 |
| Skin::initPage                                                         |      228.93 |   1039 |     0.22033725184128 |   0.0076423056321999 |
| Title::newFromText                                                     |     10643.3 |  67958 |     0.15661580498249 |     0.35530155014881 |
| Setup.php-database                                                     |     184.874 |   1201 |     0.15393354811339 |     0.00617159208441 |
| Parser::replaceInternalLinks-setup                                     |     263.633 |   2664 |    0.098961334686738 |   0.0088007703918338 |
| -overhead-total                                                        |     24469.6 | 356889 |    0.068563537306067 |     0.81685938666959 |
| Skin::doAfterContent-2                                                 |     1.25356 |     27 |    0.046428313961735 |  4.1847315461432e-05 |
| -overhead-internal                                                     |     11902.3 | 356855 |     0.03335327023581 |     0.39732979621806 |
| Setup.php-BlockCache                                                   |     21.9101 |   1201 |    0.018243252883644 |  0.00073141895623464 |
| Parser::replaceInternalLinks-prefixhandling                            |    -23.8646 |  26429 | -0.00090296874951503 | -0.00079666250460351 |
| Skin::doAfterContent-1                                                 |   -0.217717 |     27 |  -0.0080635762876934 | -7.2679576720477e-06 |
+------------------------------------------------------------------------+-------------+--------+----------------------+----------------------+