Jump to content

Profiling/Live aggregate 20040712

From Meta, a Wikimedia project coordination wiki

This is the first profiling run with Ariel as the master. Ran for a few hours ending at 07:38.

+------------------------------------------------------------------------+------------+--------+---------------------+---------------------+
| name                                                                   | total      | count  | each                | percent             |
+------------------------------------------------------------------------+------------+--------+---------------------+---------------------+
| -total                                                                 |     717285 |   1070 |     670.36022196262 |                 100 |
| Article::view                                                          |     265982 |    705 |     377.28014184397 |     37.081820722172 |
| Parser::parse                                                          |     235264 |    468 |     502.70072115385 |     32.799207289079 |
| Parser::internalParse                                                  |     178982 |    790 |     226.55990901899 |     24.952734123366 |
| LinkCache::addLinkObj                                                  |     159821 |   7409 |      21.57115290525 |     22.281321147692 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  |     156570 |   7409 |     21.132461364557 |      21.82818694824 |
| Setup.php                                                              |     143706 |   1070 |      134.3042786215 |     20.034643199486 |
| OutputPage::output                                                     |     137587 |   1070 |      128.5863317757 |     19.181676889962 |
| Parser::replaceInternalLinks                                           |     114789 |   1580 |     72.651137262658 |     16.003224222017 |
| Setup.php-MessageCache                                                 |      76123 |   1070 |     71.142961448598 |      10.61264662159 |
| Parser::tidy                                                           |    62980.6 |    468 |      134.5740100828 |     8.7804148008721 |
| wfMsg                                                                  |    57469.3 |  54173 |     1.0608477412641 |      8.012055129378 |
| Parser::replaceVariables                                               |    55413.8 |   4571 |     12.122902024995 |     7.7254858748265 |
| ParserCache::get                                                       |    37318.9 |    682 |     54.719843979106 |     5.2028009551985 |
| Title::secureAndSplit                                                  |    27496.8 |  72381 |     0.3798898688019 |     3.8334541810282 |
| Setup.php-misc                                                         |    24842.4 |   1070 |     23.217160119743 |     3.4633857080258 |
| -overhead-total                                                        |    23533.3 | 302774 |   0.077725478100002 |      3.280877134251 |
| query: COMMIT                                                          |    18879.4 |   1469 |     12.851860321647 |     2.6320599618335 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    18804.2 |     43 |     437.30736736919 |     2.6215807283659 |
| DifferenceEngine::showDiffPage                                         |    18412.1 |     10 |      1841.212890625 |     2.5669179860145 |
| Setup.php-memcached                                                    |    17321.7 |   1070 |     16.188482038551 |     2.4148929945688 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    13654.7 |     86 |      158.7759583939 |     1.9036678716728 |
| PageHistory::history                                                   |    13194.9 |      8 |     1649.3663330078 |     1.8395648334994 |
| Parser::replaceExternalLinks                                           |    13132.3 |    790 |     16.623108682753 |     1.8308270561223 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |    13092.3 |    905 |     14.466664148826 |     1.8252609589174 |
| query: BEGIN                                                           |    12761.2 |   1469 |     8.6869808064585 |     1.7790929715742 |
| Article::getContent                                                    |    12681.4 |    497 |     25.515909912601 |     1.7679722135112 |
| Skin::makeLink                                                         |    11799.1 |   1529 |      7.716877989086 |     1.6449666797135 |
| Setup.php-includes                                                     |    11414.8 |   1070 |     10.668013471086 |     1.5913852167203 |
| -overhead-internal                                                     |      11405 | 302774 |   0.037668479238021 |     1.5900275589817 |
| main-misc-setup                                                        |    11060.3 |   1070 |     10.336686806367 |     1.5419600488979 |
| Title::newFromText                                                     |    10789.4 |  60181 |    0.17928213106608 |     1.5041958703766 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |    10215.1 |    493 |     20.720245547033 |     1.4241305511918 |
| LinkCache::preFill                                                     |    9731.39 |    398 |     24.450740028266 |     1.3566976300491 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |    9075.49 |    911 |     9.9621166643798 |      1.265254779587 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |    9005.84 |   1033 |     8.7181459114835 |     1.2555454573219 |
| Skin::makeKnownLinkObj                                                 |    8787.49 |  28719 |    0.30598169439221 |     1.2251033998233 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |    8240.74 |    347 |     23.748533749099 |     1.1488789232442 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |    7651.97 |   1116 |     6.8566045726927 |     1.0667957695886 |
| Parser::doBlockLevels                                                  |     7131.4 |    468 |     15.238035022703 |    0.99422071295362 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |    6549.96 |      8 |     818.74499511719 |    0.91315947857055 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR |    5847.17 |    970 |     6.0280137524162 |    0.81518082399989 |
| Skin::outputPage                                                       |    4672.82 |     31 |     150.73624936996 |      0.651459445037 |
| query: SELECT 'X' as type, cur_namespace as namespace, cur_title as ti |    4554.33 |      1 |     4554.3349609375 |    0.63494039092875 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |     4212.4 |    410 |     10.274136575838 |      0.587269136646 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |    3971.12 |    426 |     9.3218787824604 |    0.55363181150992 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |    3934.74 |    383 |     10.273462360273 |     0.5485593152007 |
| Setup.php-User                                                         |    3606.23 |   1070 |      3.370307708455 |    0.50276069462889 |
| Setup.php-language                                                     |    3602.29 |   1070 |     3.3666293990946 |    0.50221198824091 |
| query: SELECT user_id FROM user WHERE user_name='X'                    |     3326.6 |     23 |     144.63482931386 |    0.46377646893448 |
| Setup.php-SetupSession                                                 |     3111.6 |   1070 |     2.9080358772634 |     0.4338019742206 |
| Skin::doAfterContent                                                   |    2895.93 |     24 |     120.66388956706 |    0.40373513781386 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |    2207.85 |    197 |     11.207349748176 |    0.30780603996169 |
| query: SELECT user_rights as type, N as namespace, user_name as title, |    1924.09 |      3 |     641.36238606771 |    0.26824567426174 |
| Skin::doAfterContent-3                                                 |    1612.43 |     24 |     67.184717814128 |     0.2247965932724 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |    1519.33 |    159 |     9.5555458308766 |    0.21181690128895 |
| Parser::doAllQuotes                                                    |    1372.84 |    790 |     1.7377745809434 |    0.19139408764943 |
| Parser::removeHTMLtags                                                 |     1356.1 |    790 |     1.7165808569027 |     0.1890598646028 |
| Skin::doAfterContent-4                                                 |     1275.8 |     24 |     53.158320109049 |    0.17786499152469 |
| Skin::quickBar                                                         |    1273.53 |     22 |     57.887584339489 |     0.1775481264345 |
| query: UPDATE cur SET cur_text='X'                                     |    1266.08 |     16 |     79.130249023438 |    0.17651048218513 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |    1226.73 |    151 |     8.1240565824193 |     0.1710243202791 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac |    1215.43 |     17 |      71.49605066636 |    0.16944898052919 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A |    1145.62 |     16 |     71.601432800293 |    0.15971646222146 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X'           |    1053.81 |      5 |     210.76127929687 |    0.14691590563406 |
| Setup.php-OutputPage                                                   |    1002.13 |   1070 |    0.93657466139749 |    0.13971214739673 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link |    898.147 |     10 |      89.81474609375 |    0.12521479093008 |
| Skin::doBeforeContent                                                  |     827.28 |     24 |     34.469983418783 |    0.11533478289119 |
| Skin::makeBrokenLinkObj                                                |    685.818 |   3902 |     0.1757606338196 |   0.095612981570403 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |    655.341 |     53 |     12.364919986365 |    0.09136401284842 |
| Setup.php-extensions                                                   |    644.339 |   1070 |    0.60218574310018 |   0.089830172401512 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |    607.751 |      6 |     101.29185994466 |   0.084729331991766 |
| Setup.php-DateFormatter                                                |    551.542 |   1070 |    0.51546003395152 |   0.076892992314252 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        |    529.734 |     16 |     33.108352661133 |   0.073852557835893 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 |    508.753 |     20 |     25.437669372559 |   0.070927605783321 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |      504.2 |     12 |     42.016682942708 |   0.070292824718402 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |    473.081 |     36 |     13.141142103407 |   0.065954373390253 |
| Parser::replaceInternalLinks-prefixhandling                            |    438.336 |  22184 |   0.019759112473992 |   0.061110421069025 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o |     425.53 |     16 |      26.59564781189 |   0.059325108630863 |
| query: SELECT user_name FROM user WHERE (user_id=N)                    |    405.664 |    262 |     1.5483350680985 |   0.056555419451381 |
| Parser::doHeadings                                                     |    327.788 |    790 |     0.4149215505093 |   0.045698407881359 |
| Setup.php-database                                                     |    312.309 |   1070 |    0.29187739006827 |   0.043540380306835 |
| Parser::replaceInternalLinks-setup                                     |    262.922 |   1580 |    0.16640644314923 |   0.036655167724046 |
| query: SELECT 'X' as type, rc_namespace AS namespace, rc_title AS titl |    254.005 |      1 |      254.0054473877 |   0.035412045764235 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |    235.025 |     22 |      10.68293207342 |   0.032765827009451 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |    231.725 |      3 |     77.241577148438 |   0.032305790600316 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |    229.068 |     20 |     11.453407287598 |   0.031935423999453 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ |    224.956 |     20 |     11.247794342041 |   0.031362115425746 |
| query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi |    205.999 |      3 |     68.666356404622 |   0.028719259926961 |
| Skin::initPage                                                         |    165.444 |    888 |    0.18631063925253 |   0.023065273461132 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat |    160.252 |      7 |      22.89321245466 |   0.022341522468539 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o |    148.607 |     12 |     12.383895874023 |   0.020717937757977 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      |    137.533 |     16 |     8.5957908630371 |   0.019174047961708 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N  |     107.34 |      3 |      35.77983601888 |   0.014964685248701 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t |     105.81 |      6 |     17.634962717692 |   0.014751418441581 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |    91.0001 |     10 |     9.1000076293945 |   0.012686731325693 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= |    88.4268 |     12 |     7.3689002990723 |   0.012327979764523 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges          |    74.9266 |      2 |     37.463314056396 |    0.01044585937419 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |    70.2976 |      2 |     35.148788452148 |  0.0098005024539895 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu |    60.3817 |      1 |     60.381732940674 |  0.0084180898961404 |
| query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user, |    52.9119 |      2 |     26.455963134766 |  0.0073766904363692 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |     52.469 |      8 |     6.5586223602295 |  0.0073149371419988 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |    50.8078 |      8 |     6.3509726524353 |  0.0070833420787917 |
| query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO |    41.8996 |      1 |     41.899608612061 |  0.0058414135324001 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N             |    41.6351 |      5 |     8.3270210266113 |    0.00580453790867 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |    36.9741 |      3 |     12.324708302816 |  0.0051547296202354 |
| Setup.php-BlockCache                                                   |    35.9496 |   1070 |   0.033597782170661 |  0.0050118997324001 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |    32.0886 |      8 |     4.0110731124878 |  0.0044736144388687 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ |    14.2162 |      1 |     14.216176986694 |  0.0019819413922919 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    12.2557 |      1 |     12.255656242371 |  0.0017086163473618 |
| query: UPDATE user SET user_name= 'X' WHERE user_id=N                  |    10.3872 |      2 |     5.1936058998108 |  0.0014481280751809 |
| query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES  |      9.742 |      2 |     4.8710007667542 |  0.0013581764001041 |
| query: INSERT INTO cur (cur_namespace,cur_title,cur_text,cur_comment,c |    9.04562 |      1 |     9.0456190109253 |  0.0012610905698089 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    8.10509 |      2 |     4.0525450706482 |   0.001129967195423 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |    5.65832 |      3 |      1.886105855306 | 0.00078885158823791 |
| query: DELETE FROM user_newtalk WHERE user_ip='X'                      |    5.30759 |      1 |     5.3075890541077 | 0.00073995494354473 |
| query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi |    4.04978 |      3 |     1.3499256769816 |  0.0005645976928041 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    3.60813 |      1 |     3.6081330776215 |   0.000503026116102 |
| query: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_fro |     3.2735 |      1 |     3.2735047340393 | 0.00045637406852266 |
| query: SELECT * FROM ipblocks ORDER BY ipb_timestamp DESC              |    3.06716 |      1 |     3.0671577453613 | 0.00042760630357302 |
| query: SELECT cur_namespace,cur_title,cur_id FROM brokenlinks,cur WHER |    2.98359 |      1 |     2.9835877418518 | 0.00041595543222663 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp >  |    2.15777 |      1 |     2.1577744483948 | 0.00030082507403404 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |    1.36111 |      2 |    0.68055295944214 | 0.00018975791891555 |
| Skin::doAfterContent-2                                                 |      1.091 |     24 |   0.045458480715752 |  0.0001521017268914 |
| query: SELECT N FROM boardvote.log WHERE log_user_key='X' LIMIT N      |   0.997052 |      1 |    0.99705213308334 | 0.00013900353763746 |
| query: SELECT max(user_id) as m FROM user LIMIT N                      |   0.971969 |      2 |    0.48598432540894 | 0.00013550653617136 |
| query: DELETE FROM user_newtalk WHERE user_id=N                        |   0.809938 |      2 |    0.40496879816055 | 0.00011291705560677 |
| query: UPDATE cur set cur_touched='X'                                  |   0.333327 |      1 |    0.33332684636116 | 4.6470599978012e-05 |
| Skin::doAfterContent-1                                                 | -0.0298021 |     24 | -0.0012417521793395 | -4.154838610417e-06 |
+------------------------------------------------------------------------+------------+--------+---------------------+---------------------+