Jump to content

Profiling/Live aggregate 20040708

From Meta, a Wikimedia project coordination wiki

05:27, search index update script running. Whoa! What is that update cur_touched query!

+------------------------------------------------------------------------+-----------+-------+---------------------+---------------------+
| name                                                                   | total     | count | each                | percent             |
+------------------------------------------------------------------------+-----------+-------+---------------------+---------------------+
| -total                                                                 |    157172 |   168 |     935.54920014881 |                 100 |
| OutputPage::output                                                     |   54252.8 |   168 |     322.93305896577 |     34.518019887613 |
| Article::view                                                          |   37530.7 |    99 |     379.09824810606 |     23.878720850182 |
| LinksUpdate::doUpdate                                                  |   34937.3 |     4 |       8734.31640625 |     22.228645420406 |
| query: UPDATE cur SET cur_touched='X'                                  |   26016.5 |     7 |       3716.63671875 |     16.552829424323 |
| Parser::internalParse                                                  |   23122.3 |   118 |     195.95130429025 |     14.711408411849 |
| LinkCache::addLinkObj                                                  |   22596.7 |  1002 |     22.551572635978 |     14.377012185575 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  |   22225.7 |  1002 |     22.181381377869 |     14.141008944704 |
| Parser::parse                                                          |   22057.9 |    59 |     373.86245365466 |     14.034209329433 |
| Setup.php                                                              |   17741.8 |   169 |     104.98109282544 |     11.288126831378 |
| Parser::replaceInternalLinks                                           |   11478.6 |   236 |     48.637989108845 |     7.3031748852399 |
| Setup.php-MessageCache                                                 |   11265.3 |   169 |     66.658682738536 |     7.1674969741103 |
| Parser::replaceVariables                                               |   10804.4 |   644 |     16.777069281347 |     6.8742615462234 |
| ParserCache::get                                                       |   9561.51 |    96 |     99.599090576172 |     6.0834604994023 |
| PageHistory::history                                                   |   9177.81 |     4 |     2294.4521484375 |     5.8393308496599 |
| query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu |    8724.6 |     1 |     8724.5966796875 |     5.5509772318888 |
| wfMsg                                                                  |   8550.33 |  7693 |      1.111442880297 |     5.4401010535315 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |   7656.83 |     4 |     1914.2065429688 |     4.8716140480812 |
| LinkCache::preFill                                                     |   7100.56 |    51 |     139.22666781556 |     4.5176927560077 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |    4943.6 |   176 |     28.088609175249 |     3.1453355941555 |
| query: UPDATE LOW_PRIORITY site_stats SET ss_total_views=(ss_total_vie |   4365.47 |     4 |     1091.3685302734 |     2.7775091895089 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR |   3965.37 |   279 |     14.212791743672 |     2.5229444143443 |
| query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X'           |   3871.47 |     1 |     3871.4731445312 |     2.4632037523517 |
| query: COMMIT                                                          |   3869.63 |   119 |     32.517896123293 |     2.4620308317655 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |   2933.18 |     5 |        586.63671875 |     1.8662221239136 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ |   2817.65 |     5 |     563.52954101562 |     1.7927130425165 |
| Skin::outputPage                                                       |    2801.4 |    10 |     280.13952636719 |     1.7823725149803 |
| Setup.php-misc                                                         |   2775.35 |   169 |     16.422172591531 |     1.7657995556229 |
| Parser::tidy                                                           |    2654.9 |    59 |     44.998253773835 |     1.6891637733279 |
| -overhead-total                                                        |   2608.69 | 39172 |   0.066595849763942 |     1.6597665094281 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |   2542.49 |    49 |     51.887605628189 |      1.617647150196 |
| Skin::makeLink                                                         |   2237.09 |   150 |     14.913924153646 |      1.423335481073 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |    2204.8 |   128 |     17.225034713745 |     1.4027948471646 |
| query: DELETE FROM imagelinks WHERE il_from='X'                        |   2167.99 |     4 |     541.99627685547 |     1.3793687447342 |
| Title::secureAndSplit                                                  |   2070.19 |  9174 |    0.22565813648797 |     1.3171457037337 |
| query: INSERT IGNORE INTO categorylinks (cl_from,cl_to,cl_sortkey) VAL |   2036.69 |     3 |       678.896484375 |     1.2958325980898 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |   2033.77 |    67 |     30.354807383979 |     1.2939764446604 |
| query: SELECT bl_from FROM brokenlinks WHERE bl_to='X'                 |   1996.24 |     4 |     499.06118774414 |     1.2700998761063 |
| Article::getContent                                                    |   1699.33 |    67 |     25.363126384678 |     1.0811891404734 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 |   1640.41 |     5 |     328.08234863281 |     1.0437030583232 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |   1513.59 |    64 |     23.649845123291 |    0.96301346924776 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |   1458.91 |   128 |     11.397723197937 |     0.9282226501823 |
| Parser::replaceExternalLinks                                           |   1428.43 |   118 |     12.105339438228 |    0.90883086022254 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |    1336.2 |    54 |     24.744427716291 |    0.85014941495324 |
| -overhead-internal                                                     |   1320.64 | 39172 |   0.033713911912128 |    0.84025088788426 |
| query: UPDATE cur SET cur_text='X'                                     |   1212.46 |     4 |     303.11529541016 |    0.77142183884621 |
| query: INSERT IGNORE INTO imagelinks (il_from,il_to) VALUES (N,'X')    |   1201.04 |     3 |     400.34631347656 |    0.76415449993911 |
| Title::newFromText                                                     |   1183.92 |  7402 |    0.15994594999662 |    0.75326261740079 |
| Setup.php-includes                                                     |   1157.39 |   169 |     6.8484724597818 |    0.73638427307816 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |   1014.32 |    71 |     14.286217917859 |    0.64535652529693 |
| Setup.php-memcached                                                    |   962.443 |   169 |     5.6949278701692 |    0.61234900841533 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |   845.367 |    43 |     19.659692098928 |    0.53786000786607 |
| query: INSERT IGNORE INTO links (l_from,l_to) VALUES (N,N),(N,N),(N,N) |   788.434 |     1 |     788.43444824219 |    0.50163713369337 |
| main-misc-setup                                                        |   774.026 |   169 |     4.5800333418084 |    0.49246960440997 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o |   769.666 |     4 |      192.4165802002 |     0.4896960145864 |
| Skin::makeKnownLinkObj                                                 |   750.686 |  3194 |    0.23503016290921 |     0.4776201051419 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link |   731.384 |    11 |     66.489490855824 |    0.46533935011097 |
| query: DELETE FROM categorylinks WHERE cl_from='X'                     |   718.412 |     4 |     179.60307312012 |    0.45708591755911 |
| Parser::doBlockLevels                                                  |   639.105 |    59 |     10.832296080508 |    0.40662738187846 |
| Skin::doAfterContent                                                   |   588.647 |     8 |     73.580894470215 |    0.37452355440761 |
| Skin::doBeforeContent                                                  |   582.042 |     8 |     72.755187988281 |    0.37032074430673 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |   535.564 |   162 |     3.3059526608314 |    0.34074989561613 |
| query: SELECT math_outputhash,math_html_conservativeness,math_html,mat |   488.289 |    39 |     12.520226894281 |     0.3106711269544 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |   473.003 |    43 |     11.000061035156 |    0.30094534976054 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |   456.162 |    10 |      45.61618347168 |    0.29023048875885 |
| Setup.php-language                                                     |   433.478 |   169 |     2.5649578387921 |    0.27579794248821 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t |   373.976 |     3 |     124.65855916341 |    0.23793999278633 |
| Setup.php-User                                                         |   355.194 |   169 |     2.1017398269924 |    0.22599027210639 |
| Skin::doAfterContent-3                                                 |   335.401 |     8 |     41.925170898438 |    0.21339729745179 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |    307.16 |     7 |     43.879978724888 |     0.1954287862765 |
| Setup.php-SetupSession                                                 |   301.331 |   169 |     1.7830248951207 |    0.19172034332975 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      |   282.651 |     4 |      70.66276550293 |     0.1798352024053 |
| Skin::doAfterContent-4                                                 |   251.016 |     8 |     31.377052307129 |    0.15970783233216 |
| Skin::quickBar                                                         |   250.352 |     8 |     31.294055938721 |    0.15928538442468 |
| query: SELECT user_id FROM user WHERE user_name='X'                    |   210.968 |     7 |     30.138301304408 |    0.13422731312801 |
| query: BEGIN                                                           |   192.133 |   120 |      1.601110458374 |    0.12224373953055 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |   185.304 |    10 |     18.530351257324 |    0.11789835301819 |
| DifferenceEngine::showDiffPage                                         |   162.789 |     1 |     162.78889465332 |    0.10357354970101 |
| Parser::doAllQuotes                                                    |   157.698 |   118 |     1.3364253933147 |      0.100334620605 |
| Parser::removeHTMLtags                                                 |   156.647 |   118 |     1.3275172346729 |   0.099665824036127 |
| Setup.php-OutputPage                                                   |   143.939 |   169 |    0.85171102489945 |   0.091580510489958 |
| query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N             |   98.6633 |     1 |     98.663314819336 |   0.062773997961408 |
| Skin::makeBrokenLinkObj                                                |   90.2314 |   439 |    0.20553847814747 |   0.057409232823571 |
| Setup.php-extensions                                                   |   84.5515 |   169 |    0.50030458890475 |   0.053795416887758 |
| Setup.php-DateFormatter                                                |   77.4082 |   169 |      0.458036750026 |   0.049250553490833 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A |   72.5571 |     4 |     18.139274597168 |    0.04616405960692 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |   70.0395 |    41 |      1.708280795958 |   0.044562259350123 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |   52.0023 |     5 |     10.400453948975 |   0.033086161568063 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac |   46.9388 |     4 |      11.73469543457 |   0.029864544836602 |
| Setup.php-database                                                     |   43.1477 |   169 |    0.25531188693978 |   0.027452495337676 |
| Parser::doHeadings                                                     |   41.0097 |   118 |     0.3475399017334 |   0.026092204143947 |
| Parser::replaceInternalLinks-setup                                     |   29.2905 |   236 |    0.12411240399894 |   0.018635938870815 |
| Skin::initPage                                                         |   18.9498 |   124 |    0.15282135625039 |   0.012056737936362 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |   17.9547 |     3 |     5.9849122365316 |   0.011423603673458 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |   16.1835 |     3 |     5.3945083618164 |   0.010296679901568 |
| Setup.php-BlockCache                                                   |   3.02617 |   169 |   0.017906310290275 |  0.0019253819540125 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |   2.43826 |     3 |    0.81275224685669 |  0.0015513276027894 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |   1.56191 |     1 |     1.5619134902954 | 0.00099375897146002 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        |   1.47522 |     4 |    0.36880585551262 |  0.0009386028865743 |
| Parser::replaceInternalLinks-prefixhandling                            |   1.38533 |  2419 | 0.00057268689712644 | 0.00088140843337726 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |   1.24768 |     1 |     1.2476778030396 | 0.00079382822285988 |
| Skin::doAfterContent-2                                                 |  0.408226 |     8 |   0.051028233021498 | 0.00025973148796237 |
| Skin::doAfterContent-1                                                 | 0.0670489 |     8 |  0.0083811096847057 | 4.2659483981493e-05 |
+------------------------------------------------------------------------+-----------+-------+---------------------+---------------------+