Profiling/Live aggregate 20040617

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

The backup running on en at the time is thought to have contributed to the very slow query times.

+------------------------------------------------------------------------+------------+-------+--------------------+---------------------+
| name                                                                   | total      | count | each               | percent             |
+------------------------------------------------------------------------+------------+-------+--------------------+---------------------+
| -total                                                                 |     486293 |   172 |    2827.2843386628 |                 100 |
| Parser::internalParse                                                  |     219051 |   108 |    2028.2526041667 |     45.045131943049 |
| Article::view                                                          |     200254 |   101 |     1982.713490099 |     41.179721095304 |
| LinkCache::addLinkObj                                                  |     187501 |  1236 |    151.70017951052 |     38.557301466908 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  |     186961 |  1236 |    151.26291970065 |      38.44616410133 |
| Parser::parse                                                          |     159643 |    73 |    2186.8953339041 |     32.828642434058 |
| wfMsg                                                                  |     154019 |  9192 |    16.755731886423 |     31.671999636536 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |     129263 |  4928 |    26.230303875812 |     26.581292023525 |
| Parser::replaceInternalLinks                                           |     106818 |   216 |    494.52564380787 |     21.965679056726 |
| OutputPage::output                                                     |     103251 |   174 |    593.39646192529 |     21.232262088956 |
| Parser::replaceVariables                                               |    86072.2 |   698 |    123.31260073424 |     17.699660884679 |
| PageHistory::history                                                   |      68797 |    11 |    6254.2698863636 |     14.147228525401 |
| Setup.php                                                              |      50057 |   175 |    286.04011160714 |     10.293594434116 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |    34306.8 |    11 |    3118.7972301136 |     7.0547542623649 |
| ParserCache::get                                                       |    28478.3 |    98 |    290.59462691327 |     5.8561975861642 |
| Skin::makeLink                                                         |    26896.6 |   251 |    107.15787630727 |      5.530951944279 |
| Setup.php-MessageCache                                                 |    26164.7 |   175 |    149.51237723214 |     5.3804334135555 |
| Article::getContent                                                    |    14395.4 |    76 |    189.41375411184 |     2.9602416830443 |
| Setup.php-misc                                                         |    13893.9 |   175 |    79.393900669643 |     2.8571119254708 |
| LinkCache::preFill                                                     |    12720.3 |    63 |    201.90969122024 |     2.6157713557795 |
| Parser::tidy                                                           |    9350.59 |    73 |     128.0903119649 |     1.9228314156469 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |    8848.02 |    85 |    104.09438189338 |     1.8194841724442 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |     8765.8 |   144 |    60.873582628038 |     1.8025753174222 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |    7921.39 |   139 |    56.988428788219 |     1.6289342286828 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |    7145.62 |    59 |     121.1121805482 |     1.4694063105807 |
| -overhead-total                                                        |    6407.09 | 53632 |   0.11946386369145 |     1.3175363767709 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |    5486.18 |    60 |    91.436385091146 |      1.128164329555 |
| query: COMMIT                                                          |    5182.51 |   128 |    40.488342285156 |     1.0657173374098 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |    4614.34 |    63 |    73.243489583333 |    0.94888076392745 |
| Title::secureAndSplit                                                  |     4405.8 | 12536 |   0.35145192003281 |    0.90599743753331 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |    4233.14 |    44 |    96.207652698864 |    0.87049115139133 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X'           |       4227 |     1 |    4226.9956054688 |    0.86922830893521 |
| Skin::outputPage                                                       |    4225.52 |     6 |    704.25358072917 |    0.86892517453312 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ |    4055.13 |     7 |    579.30472237723 |    0.83388694437502 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |     3712.8 |    31 |    119.76759387601 |    0.76348952708093 |
| Skin::doAfterContent                                                   |    3635.17 |     6 |    605.86218261719 |    0.74752747757219 |
| Parser::replaceExternalLinks                                           |    3299.89 |   108 |    30.554581253617 |    0.67858172162893 |
| Skin::doAfterContent-3                                                 |    3232.92 |     7 |    461.84594726562 |    0.66480953954063 |
| -overhead-internal                                                     |    3163.46 | 53632 |  0.058984592592517 |    0.65052597503768 |
| Setup.php-includes                                                     |    3115.22 |   175 |    17.801234654018 |    0.64060487504862 |
| main-misc-setup                                                        |    3063.77 |   175 |    17.507248883929 |    0.63002534384337 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |    2848.75 |    13 |    219.13433368389 |    0.58580873816533 |
| Setup.php-OutputPage                                                   |    2270.39 |   175 |    12.973681640625 |    0.46687793671869 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu |     2118.7 |     1 |    2118.6987304688 |    0.43568365962952 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |    2022.97 |   161 |    12.565019500922 |     0.4159978715808 |
| Title::newFromText                                                     |    1871.15 | 10752 |   0.17402764729091 |    0.38477741287674 |
| Parser::doBlockLevels                                                  |    1797.53 |    73 |    24.623740836366 |    0.36963999637918 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |    1704.86 |    24 |    71.035842895508 |    0.35058299382548 |
| Skin::makeKnownLinkObj                                                 |    1697.61 |  5520 |    0.3075372889422 |    0.34909121912797 |
| LinksUpdate::doUpdate                                                  |    1664.83 |     1 |    1664.8330078125 |    0.34235190076094 |
| Setup.php-memcached                                                    |     1624.6 |   174 |    9.3368046201509 |    0.33407931372765 |
| Setup.php-User                                                         |    1524.09 |   175 |    8.7091078404018 |    0.31341067337856 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR |    1367.08 |    33 |    41.426694927794 |    0.28112294361012 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 |     1169.6 |     7 |    167.08621651786 |    0.24051420462706 |
| query: BEGIN                                                           |    861.789 |   128 |     6.732723236084 |    0.17721594601582 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |    854.135 |     4 |    213.53372192383 |    0.17564206195848 |
| Skin::doBeforeContent                                                  |    812.477 |     8 |    101.55965423584 |    0.16707569109985 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |    729.451 |     2 |    364.72546386719 |    0.15000237888713 |
| query: DELETE FROM brokenlinks WHERE bl_from=N AND bl_to IN('X')       |     623.89 |     1 |    623.88970947266 |    0.12829504635051 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie |    619.124 |     1 |    619.12371826172 |    0.12731498039649 |
| query: DELETE FROM links WHERE l_from=N AND l_to IN(N,N,N,N)           |     600.62 |     1 |    600.61981201172 |    0.12350988556328 |
| Setup.php-language                                                     |    512.535 |   175 |    2.9287723214286 |    0.10539638758097 |
| Setup.php-SetupSession                                                 |    499.402 |   174 |    2.8701250799771 |    0.10269567116804 |
| Skin::doAfterContent-4                                                 |    463.133 |     6 |    77.188898722331 |   0.095237538195939 |
| Skin::quickBar                                                         |    462.531 |     6 |    77.088521321615 |   0.095113690120724 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |    423.212 |    31 |    13.651988367881 |   0.087028133449005 |
| Parser::removeHTMLtags                                                 |     403.39 |   108 |    3.7350918805158 |   0.082952047605713 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N             |    353.971 |     1 |    353.97061157227 |   0.072789589776638 |
| query: SELECT user_id FROM user WHERE user_name='X'                    |    323.591 |     2 |    161.79566955566 |   0.066542475728604 |
| Parser::doAllQuotes                                                    |    305.958 |   108 |    2.8329467773438 |   0.062916453853397 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |     283.53 |     7 |    40.504250662667 |    0.05830431638929 |
| query: INSERT INTO links (l_from,l_to) VALUES (N,N)                    |    259.844 |     1 |    259.84381103516 |   0.053433600962621 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat |    231.173 |     1 |    231.17333984375 |   0.047537880333567 |
| Skin::makeBrokenLinkObj                                                |     226.89 |   358 |   0.63377158735051 |   0.046657112484146 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |    138.763 |     3 |    46.254282633464 |   0.028534828725026 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |    107.963 |     2 |    53.981548309326 |   0.022201248513206 |
| query: SELECT img_size,img_description,img_user,img_user_text,img_time |    98.8172 |     1 |    98.817222595215 |   0.020320514925302 |
| Setup.php-DateFormatter                                                |    94.0433 |   175 |   0.53739031110491 |   0.019338818895913 |
| Setup.php-database                                                     |    82.2654 |   175 |   0.47008823939732 |   0.016916850078878 |
| Setup.php-extensions                                                   |    82.0105 |   175 |   0.46863159179688 |    0.01686443036911 |
| query: UPDATE cur SET cur_text='X'                                     |    77.0099 |     1 |    77.009910583496 |   0.015836116380424 |
| query: DELETE FROM imagelinks WHERE il_from='X'                        |     62.989 |     1 |    62.988994598389 |    0.01295289192765 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X'                 |    58.8288 |     1 |    58.828826904297 |   0.012097405935437 |
| query: DELETE FROM categorylinks WHERE cl_from='X'                     |     56.874 |     1 |    56.874034881592 |   0.011695427622042 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o |     55.208 |     1 |     55.20796585083 |   0.011352821548758 |
| Parser::doHeadings                                                     |    43.2138 |   108 |   0.40012758749503 |  0.0088863684610787 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        |    42.6197 |     1 |    42.619701385498 |  0.0087642038034558 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac |     39.593 |     1 |    39.592979431152 |   0.008141796625509 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A |    32.8438 |     1 |    32.843826293945 |  0.0067539184454113 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id=N LIMIT N  |    27.5314 |     1 |    27.531368255615 |  0.0056614784838053 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |    27.5185 |     2 |    13.759243965149 |  0.0056588298074311 |
| Skin::initPage                                                         |    25.9103 |   138 |   0.18775552943133 |  0.0053281186561671 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      |    22.5778 |     1 |    22.577758789062 |  0.0046428312029408 |
| Parser::replaceInternalLinks-setup                                     |    20.5768 |   216 |  0.095263004302979 |  0.0042313611128156 |
| query: SELECT oi_size AS img_size, oi_description AS img_description,o |    18.5701 |     1 |    18.570056915283 |  0.0038186978828222 |
| query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= |    17.6002 |     1 |    17.600170135498 |  0.0036192529048429 |
| Setup.php-BlockCache                                                   |     2.0142 |   175 |  0.011509700502668 |  0.0004141943182966 |
| Skin::doAfterContent-2                                                 |   0.316657 |     7 |   0.04523669396128 | 6.5116487133408e-05 |
| Skin::doAfterContent-1                                                 | 0.00992367 |     8 | 0.0012404582230374 | 2.0406766491464e-06 |
| Parser::replaceInternalLinks-prefixhandling                            |    -85.029 |  4192 | -0.020283628056068 |  -0.017485134518356 |
+------------------------------------------------------------------------+------------+-------+--------------------+---------------------+