Jump to content

Profiling/Live aggregate 20040606

From Meta, a Wikimedia project coordination wiki
+------------------------------------------------------------------------+------------------+--------+--------------------+---------------------+
| name                                                                   | total            | count  | each               | percent             |
+------------------------------------------------------------------------+------------------+--------+--------------------+---------------------+
| -total                                                                 | 153914.532899876 |    455 |    338.27369868105 |                 100 |
| Setup.php                                                              | 37718.2647026078 |    455 |    82.897285060676 |     24.505980034481 |
| Article::view                                                          | 32083.8423771857 |    323 |    99.330781353516 |     20.845232592855 |
| OutputPage::output                                                     |  26036.386381723 |    454 |    57.348868682209 |     16.916132538738 |
| Parser::parse                                                          |  24658.791061921 |    151 |     163.3032520657 |     16.021093393411 |
| Parser::internalParse                                                  | 19239.5178952636 |    187 |    102.88512243456 |     12.500130775681 |
| Skin::makeLink                                                         | 16532.9234892218 |   5597 |    2.9538902071148 |     10.741626003554 |
| Setup.php-includes                                                     | 16454.8572338009 |    455 |    36.164521392969 |     10.690905480969 |
| LinkCache::addLinkObj                                                  | 12739.0668339002 |   3427 |    3.7172649063029 |     8.2767147415424 |
| Parser::replaceInternalLinks                                           | 11855.9724646544 |    374 |     31.70046113544 |     7.7029584154778 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  | 11726.8168873033 |   3427 |     3.421889958361 |     7.6190445868629 |
| PageHistory::history                                                   | 11532.8745602584 |      9 |    1281.4305066954 |      7.493038079621 |
| Setup.php-MessageCache                                                 | 11346.7129505111 |    455 |    24.937830660464 |     7.3720867917602 |
| wfMsg                                                                  | 10015.1609862746 |  44826 |     0.223423035432 |     6.5069625314652 |
| -overhead-total                                                        | 9585.64019203235 | 177219 |  0.054089235307909 |     6.2278980492817 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 8866.59810533308 |      9 |    985.17756725923 |     5.7607283329775 |
| Title::secureAndSplit                                                  | 7222.66003514673 |  39703 |   0.18191723635863 |     4.6926433125358 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu |    7156.26574009 |      1 |      7156.26574009 |     4.6495061936388 |
| ParserCache::get                                                       | 6623.95288747402 |    315 |    21.028421864997 |     4.3036565570991 |
| Parser::tidy                                                           |  5470.2064958113 |    151 |    36.226533084843 |     3.5540545735014 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 5003.36143982873 |   3622 |    1.3813808503116 |     3.2507400994314 |
| Skin::makeKnownLinkObj                                                 | 4918.46818257307 |  22288 |   0.22067786174502 |     3.1955839971087 |
| Parser::replaceVariables                                               |  4787.5895591012 |    601 |    7.9660391998356 |     3.1105506860847 |
| -overhead-internal                                                     | 4632.70068168239 | 177219 |   0.02614110609857 |      3.009917643512 |
| Setup.php-memcached                                                    | 4622.21873167711 |    455 |    10.158722487202 |     3.0031074029143 |
| Title::newFromText                                                     | 4438.23934024867 |  31885 |   0.13919521217653 |     2.8835739267947 |
| LinkCache::preFill                                                     | 3048.62646289077 |    117 |    26.056636434964 |     1.9807268394038 |
| Setup.php-misc                                                         | 2547.27518920137 |    455 |    5.5984070092338 |     1.6549932882936 |
| Parser::replaceExternalLinks                                           | 2310.62575964794 |    187 |    12.356287484748 |     1.5012394970857 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           | 1979.28568691788 |    109 |     18.15858428365 |     1.2859641319286 |
| LinksUpdate::doUpdate                                                  |  1833.3497018634 |      5 |    366.66994037268 |     1.1911478840377 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 1668.94830098715 |      3 |    556.31610032905 |      1.084334448179 |
| query: COMMIT                                                          | 1637.92750239433 |    368 |    4.4508899521585 |     1.0641798870675 |
| Skin::outputPage                                                       |   1634.546219073 |     17 |    96.149777592529 |     1.0619830293325 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      | 1285.24994562691 |      5 |    257.04998912538 |    0.83504131897862 |
| Article::getContent                                                    | 1244.29223754316 |    148 |    8.4073799833998 |    0.80843063621068 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      | 1239.94956234074 |    237 |    5.2318546934209 |    0.80560915137712 |
| Parser::doBlockLevels                                                  |  1214.1776051971 |    151 |     8.040911292696 |    0.78886482148306 |
| main-misc-setup                                                        | 1160.56287650258 |    455 |     2.550687640665 |    0.75403073032587 |
| Skin::doAfterContent                                                   |  1097.8477481363 |     14 |     78.41769629545 |    0.71328400733313 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 930.715025793785 |    396 |    2.3502904691762 |    0.60469600125365 |
| Setup.php-language                                                     |  922.37770918973 |    455 |    2.0272037564609 |    0.59927915305422 |
| Skin::doAfterContent-3                                                 |   800.2214911937 |     14 |    57.158677942407 |      0.519912886793 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ |   768.6621624831 |     11 |    69.878378407555 |    0.49940843661796 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 726.090232929373 |    156 |    4.6544245700601 |    0.47174897603835 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |  568.84777325463 |    434 |    1.3107091549646 |    0.36958678465059 |
| Setup.php-User                                                         | 530.434731284554 |    455 |    1.1657906182078 |    0.34462940002528 |
| query: UPDATE cur SET cur_touched='X'                                  |   522.7615545933 |      7 |    74.680222084757 |    0.33964405098339 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 518.040200275416 |    469 |    1.1045633268133 |    0.33657653407714 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    | 486.077098595108 |    374 |    1.2996713866179 |    0.31580974807058 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |  464.79343598858 |      9 |    51.643715109842 |    0.30198151352669 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 453.797469060113 |    251 |    1.8079580440642 |    0.29483731036322 |
| query: BEGIN                                                           |  422.54564166031 |    368 |    1.1482218523378 |    0.27453264724208 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 420.839437156543 |      3 |    140.27981238551 |    0.27342410702068 |
| query: DELETE FROM categorylinks WHERE cl_from='X'                     | 380.756852131941 |      5 |    76.151370426388 |    0.24738200152914 |
| Setup.php-SetupSession                                                 | 330.228213111188 |    455 |   0.72577629255206 |    0.21455297748005 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X'           |   329.0776090947 |      5 |     65.81552181894 |    0.21380541713288 |
| Parser::doAllQuotes                                                    |   324.8123803595 |    187 |    1.7369646008529 |    0.21103425013855 |
| Parser::removeHTMLtags                                                 | 320.657698200262 |    187 |    1.7147470491993 |    0.20833490649571 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |  296.46182832345 |    242 |    1.2250488773696 |    0.19261457819341 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie |   296.3108987628 |      5 |     59.26217975256 |    0.19251651756339 |
| Skin::doAfterContent-4                                                 | 293.928432798471 |     14 |    20.994888057034 |    0.19096860267878 |
| Skin::quickBar                                                         |    292.871926619 |     13 |    22.528609739923 |    0.19028217875275 |
| Setup.php-OutputPage                                                   | 288.586500922614 |    455 |   0.63425604598377 |    0.18749788956599 |
| Skin::makeBrokenLinkObj                                                | 260.567485604553 |   1274 |   0.20452706876339 |    0.16929362074864 |
| query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VAL |   257.4182366072 |      3 |    85.806078869067 |    0.16724751831892 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link |    253.146080044 |      1 |      253.146080044 |    0.16447185023696 |
| Skin::doBeforeContent                                                  |  240.37461314205 |     14 |    17.169615224432 |    0.15617408480745 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N)                 |   212.1957064138 |      2 |     106.0978532069 |    0.13786593274583 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    | 206.892529858109 |     96 |    2.1551305193553 |    0.13442039939964 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |   202.3343235185 |     15 |    13.488954901233 |    0.13145888156651 |
| Setup.php-DateFormatter                                                | 202.155236045298 |    455 |   0.44429722207758 |    0.13134252642459 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N)       |   194.5842028124 |      2 |      97.2921014062 |    0.12642354113434 |
| query: SELECT user_id FROM user WHERE user_name='X'                    | 188.131948117125 |     10 |    18.813194811712 |    0.12223143882034 |
| query: UPDATE user SET user_name= 'X' WHERE user_id=N                  |   178.8529712512 |      4 |      44.7132428128 |    0.11620278337689 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO |  174.86040420632 |      2 |     87.43020210316 |    0.11360876774389 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  | 163.643528794865 |     70 |    2.3377646970695 |    0.10632103785893 |
| Setup.php-extensions                                                   | 143.022183219374 |    455 |   0.31433446861401 |   0.092923118125832 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 | 137.757249535131 |     11 |    12.523386321376 |   0.089502431602573 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o |  121.47079989691 |      7 |    17.352971413844 |   0.078920942427138 |
| query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X')    |   118.8970112801 |      2 |     59.44850564005 |   0.077248723067265 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       | 104.905276907297 |     24 |    4.3710532044707 |   0.068158136162191 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 100.247293274325 |     33 |    3.0377967658886 |   0.065131791901378 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |   96.24301478659 |      7 |     13.74900211237 |   0.062530167212474 |
| query: DELETE FROM imagelinks WHERE il_from='X'                        |  95.876690846405 |      5 |    19.175338169281 |   0.062292162435872 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |  80.393500984796 |     11 |    7.3085000895269 |   0.052232560155378 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |    79.1337708947 |      3 |    26.377923631567 |   0.051414099373045 |
| query: UPDATE cur SET cur_text='X'                                     |   68.61972520908 |      5 |    13.723945041816 |   0.044583005851513 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o |   67.84891794292 |      5 |    13.569783588584 |   0.044082203716953 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM brok |   64.54137659376 |      2 |     32.27068829688 |   0.041933256969142 |
| Parser::doHeadings                                                     | 63.9078298071483 |    187 |   0.34175310057299 |   0.041521634509148 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A |   63.03405473801 |      5 |    12.606810947602 |   0.040953933036989 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= |  62.862029526527 |      7 |     8.980289932361 |   0.040842166325788 |
| Skin::initPage                                                         | 55.7963294084674 |    391 |   0.14270160974033 |   0.036251501633549 |
| query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES  |  48.813994581905 |      4 |    12.203498645476 |   0.031715000307125 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X'                 |  39.733407002396 |      5 |    7.9466814004792 |   0.025815240610348 |
| Parser::replaceInternalLinks-setup                                     | 38.0229311902217 |    374 |   0.10166559141771 |   0.024703925271928 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N             |  32.710440668191 |      5 |    6.5420881336382 |   0.021252340537245 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac |  29.883143406766 |      5 |    5.9766286813532 |   0.019415413764862 |
| Parser::replaceInternalLinks-prefixhandling                            | 27.6968458105026 |   6322 | 0.0043810259111836 |   0.017994951671341 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges          |  21.964849670864 |      3 |    7.3216165569547 |   0.014270809427172 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N  |  21.648018729497 |      6 |    3.6080031215828 |   0.014064960807554 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        |  15.357014637906 |      5 |    3.0714029275812 |  0.0099776248211051 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO |    11.9856748648 |      1 |      11.9856748648 |  0.0077872275210015 |
| Setup.php-BlockCache                                                   | 9.76622466225148 |    455 |  0.021464230026926 |  0.0063452258069773 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t |   7.914674873347 |      2 |    3.9573374366735 |  0.0051422531220594 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |    6.90800114483 |      3 |    2.3026670482767 |  0.0044882058988697 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |   4.447539638567 |      7 |   0.63536280550957 |  0.0028896164350251 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |  1.9088586082958 |      7 |    0.2726940868994 |  0.0012402068682738 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |    1.75287528009 |      3 |      0.58429176003 |  0.0011388627487375 |
| query: DELETE FROM user_newtalk WHERE user_id=N                        |   1.487668211647 |      4 |   0.37191705291175 | 0.00096655473893083 |
| query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user, |   1.364807465208 |      2 |     0.682403732604 | 0.00088673073263058 |
| Skin::doAfterContent-2                                                 |  0.5646232128324 |     14 |  0.040330229488029 | 0.00036684204031578 |
| Skin::doAfterContent-1                                                 | 0.05416903497609 |     14 | 0.0038692167840064 | 3.5194230171447e-05 |
+------------------------------------------------------------------------+------------------+--------+--------------------+---------------------+