Jump to content

Profiling/Live aggregate 20040927

From Meta, a Wikimedia project coordination wiki

Taken for a short time ending 08:25 UTC. A few memcached functions are included.

+------------------------------------------------------------------------+----------+-------+---------------------+---------------------+
| name                                                                   | total    | count | each                | percent             |
+------------------------------------------------------------------------+----------+-------+---------------------+---------------------+
| -total                                                                 |  50400.1 |   131 |     384.73351025763 |                 100 |
| Setup.php                                                              |  22243.6 |   131 |     169.79842557252 |     44.134035909379 |
| Parser::parse                                                          |  20449.6 |   184 |     111.13920261549 |     40.574557197512 |
| Article::view                                                          |  15893.4 |    87 |      182.6824375898 |      31.53441217979 |
| Parser::internalParse                                                  |  13339.2 |   184 |     72.495775305707 |     26.466664439695 |
| Setup.php-MessageCache                                                 |  10042.3 |   131 |     76.658933683206 |      19.92520319633 |
| MessageCache::initialise                                               |  10032.7 |   131 |     76.585199487118 |     19.906038191431 |
| memcached::get                                                         |  9160.27 |   663 |     13.816390047606 |     18.175099746768 |
| Setup.php-misc                                                         |  9043.82 |   131 |     69.036781369275 |     17.944052059059 |
| Parser::replaceInternalLinks                                           |  8939.13 |   368 |     24.291105850883 |     17.736331385198 |
| OutputPage::output                                                     |  6543.35 |   122 |     53.634057216957 |     12.982824040105 |
| Parser::tidy                                                           |  6521.16 |   184 |     35.441061268682 |     12.938777080863 |
| MessageCache::load                                                     |  6207.49 |   131 |     47.385447727815 |     12.316433703964 |
| MessageCache::load-fromcache                                           |   6194.5 |   131 |      47.28623345062 |     12.290645912012 |
| ParserOptions::initialiseFromUser                                      |  5572.32 |   397 |     14.036071316121 |     11.056171387343 |
| ParserOptions::initialiseFromUser-skin                                 |  5348.07 |   397 |     13.471207395309 |     10.611229766688 |
| DifferenceEngine::showDiffPage                                         |  4061.65 |     2 |     2030.8245849609 |     8.0588133523447 |
| MessageCache::initialise-parseropt                                     |  3806.29 |   262 |     14.527814326396 |     7.5521439848934 |
| wfMsg                                                                  |  2852.79 |  6262 |    0.45557124071782 |     5.6602817935825 |
| LinkCache::addLinkObj                                                  |  2793.56 |  1447 |     1.9305876314681 |      5.542768497824 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |  2513.85 |     9 |     279.31689453125 |     4.9877927967483 |
| Title::secureAndSplit                                                  |  2379.89 |  7113 |    0.33458334843552 |     4.7219982440507 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  |  2369.39 |  1447 |      1.637451171875 |     4.7011659166654 |
| -overhead-total                                                        |  2104.83 | 36936 |   0.056985750584626 |     4.1762339910883 |
| Parser::replaceVariables                                               |  1625.62 |   523 |     3.1082574614603 |     3.2254280843218 |
| Setup.php-includes                                                     |  1392.44 |   131 |     10.629295756799 |     2.7627683769165 |
| memcached::_connect_sock                                               |  1370.96 |   608 |     2.2548739784642 |     2.7201605853412 |
| ParserCache::get                                                       |  1148.96 |    74 |     15.526518950591 |     2.2796832424421 |
| Parser::replaceExternalLinks                                           |  1104.84 |   184 |     6.0045776367188 |     2.1921434834372 |
| -overhead-internal                                                     |  1067.08 | 36936 |   0.028889914469877 |     2.1172142434022 |
| memcached::_set                                                        |  752.784 |   167 |     4.5076875058477 |     1.4936160149919 |
| Title::newFromText                                                     |  724.526 |  5883 |    0.12315591451932 |     1.4375495110492 |
| main-misc-setup                                                        |   566.01 |   131 |      4.320688029282 |     1.1230339739288 |
| Skin::makeKnownLinkObj                                                 |  538.828 |  2778 |    0.19396262996226 |     1.0691016379249 |
| Skin::makeLink                                                         |  484.556 |   188 |     2.5774269915642 |     0.9614194655531 |
| query: BEGIN                                                           |  480.978 |   174 |     2.7642401333513 |    0.95431929723588 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |  477.249 |   131 |     3.6431204526479 |    0.94692049315078 |
| query: COMMIT                                                          |  468.765 |   174 |     2.6940491774987 |    0.93008674853165 |
| Setup.php-extensions                                                   |  449.115 |   131 |     3.4283575392861 |    0.89109927986007 |
| Setup.php-language                                                     |  446.264 |   131 |     3.4065931480349 |    0.88544227555165 |
| Parser::doBlockLevels                                                  |  381.012 |   184 |     2.0707175213358 |    0.75597489033649 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |  353.433 |   124 |     2.8502627957252 |    0.70125388221654 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |  348.694 |   126 |     2.7674151223803 |    0.69185254728899 |
| query: SELECT cur_text FROM cur WHERE cur_namespace='X' LIMIT N        |  326.094 |   131 |     2.4892636364653 |    0.64700983150607 |
| Article::getContent                                                    |  325.158 |    51 |     6.3756498448989 |    0.64515389376864 |
| Parser::removeHTMLtags                                                 |  299.808 |   232 |     1.2922765797582 |    0.59485641282261 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |  294.739 |    18 |     16.374413384332 |    0.58479943554013 |
| LinkCache::preFill                                                     |  255.764 |    46 |      5.560080818508 |    0.50746678913527 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR |  240.401 |    93 |       2.58495929677 |    0.47698568662258 |
| Setup.php-SetupSession                                                 |  234.129 |   131 |     1.7872463546636 |    0.46454137916576 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |  228.364 |    40 |     5.7090953826904 |    0.45310200044403 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |  227.871 |   119 |       1.91488173028 |    0.45212404702008 |
| Setup.php-User                                                         |  218.504 |   131 |     1.6679686335207 |    0.43353869342022 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |  196.649 |    56 |     3.5115863255092 |    0.39017556285746 |
| Setup.php-OutputPage                                                   |  146.437 |   131 |     1.1178369886093 |    0.29054838188145 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |   126.87 |    36 |     3.5241574181451 |    0.25172508113883 |
| Setup.php-DateFormatter                                                |  93.3423 |   131 |      0.712536411431 |    0.18520258631848 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |  88.0527 |    41 |      2.147625806855 |    0.17470734348696 |
| Parser::doAllQuotes                                                    |  78.4393 |   184 |    0.42630033907683 |    0.15563317968939 |
| Skin::initPage                                                         |  68.6011 |    96 |    0.71459436416626 |    0.13611296958525 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |  57.6924 |    38 |     1.5182211022628 |     0.1144688473073 |
| Setup.php-memcached                                                    |  54.4962 |   131 |    0.41600185132209 |     0.1081272725746 |
| Parser::doHeadings                                                     |  42.9342 |   184 |    0.23333810723346 |   0.085186776182466 |
| PageHistory::history                                                   |  36.9642 |     1 |     36.964183807373 |   0.073341503798841 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |  32.5384 |     1 |     32.538421630859 |   0.064560245292687 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat |  28.6251 |     3 |     9.5417003631592 |   0.056795734250119 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |  28.3628 |    10 |     2.8362762451172 |    0.05627522200675 |
| Parser::replaceInternalLinks-setup                                     |  26.2208 |   368 |    0.07125226829363 |   0.052025372997043 |
| Skin::makeBrokenLinkObj                                                |  19.3462 |   132 |    0.14656215725523 |   0.038385258474077 |
| Setup.php-database                                                     |  15.2411 |   131 |    0.11634425534547 |   0.030240218812123 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |  10.5018 |    10 |     1.0501803398132 |   0.020836874360125 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |  9.37169 |    12 |    0.78097446759542 |   0.018594597033853 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |  7.84227 |     1 |     7.8422737121582 |   0.015560039151658 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |  6.72417 |     2 |     3.3620846271515 |   0.013341581880408 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t |  5.25237 |     1 |     5.2523674964905 |   0.010421345503101 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |  4.97444 |     2 |     2.4872212409973 |  0.0098699079652762 |
| query: SELECT user_id FROM user WHERE user_name='X'                    |  4.80891 |     2 |     2.4044544696808 |  0.0095414689820397 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |   3.7864 |     2 |     1.8932013511658 |  0.0075126903822396 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |   2.7074 |     1 |     2.7073972225189 |  0.0053718103100855 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |  2.47897 |     1 |      2.478972196579 |  0.0049185868601907 |
| Setup.php-BlockCache                                                   |  2.14262 |   131 |   0.016355898544079 |  0.0042512279559755 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp >  |  1.87272 |     1 |     1.8727209568024 |  0.0037157095604555 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ |  1.72482 |     1 |     1.7248177528381 |   0.003422251345554 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |  1.68175 |     1 |      1.681747674942 |  0.0033367949941275 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |  1.59857 |     2 |    0.79928302764893 |  0.0031717523922154 |
| Parser::replaceInternalLinks-prefixhandling                            |   1.0839 |  2202 | 0.00049223599923296 |  0.0021505986867708 |
| query: UPDATE cur SET cur_text='X'                                     |  0.65933 |     1 |    0.65933042764664 |  0.0013081929609465 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges          | 0.637713 |     1 |    0.63771265745163 |  0.0012653006362264 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 0.547512 |     1 |      0.547512114048 |   0.001086331623109 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 0.509604 |     1 |    0.50960355997086 |  0.0010111163721151 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      | 0.433548 |     1 |    0.43354803323746 | 0.00086021281823413 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id='X' LIMIT  | 0.421201 |     1 |    0.42120134830475 | 0.00083571547116395 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        | 0.414475 |     1 |    0.41447454690933 | 0.00082236866679064 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 0.407322 |     1 |    0.40732198953629 | 0.00080817710999933 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 0.398262 |     1 |    0.39826208353043 | 0.00079020113806367 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |  0.37442 |     1 |    0.37442022562027 | 0.00074289594875931 |+------------------------------------------------------------------------+----------+-------+---------------------+---------------------+
| name                                                                   | total    | count | each                | percent             |
+------------------------------------------------------------------------+----------+-------+---------------------+---------------------+
| -total                                                                 |  50400.1 |   131 |     384.73351025763 |                 100 |
| Setup.php                                                              |  22243.6 |   131 |     169.79842557252 |     44.134035909379 |
| Parser::parse                                                          |  20449.6 |   184 |     111.13920261549 |     40.574557197512 |
| Article::view                                                          |  15893.4 |    87 |      182.6824375898 |      31.53441217979 |
| Parser::internalParse                                                  |  13339.2 |   184 |     72.495775305707 |     26.466664439695 |
| Setup.php-MessageCache                                                 |  10042.3 |   131 |     76.658933683206 |      19.92520319633 |
| MessageCache::initialise                                               |  10032.7 |   131 |     76.585199487118 |     19.906038191431 |
| memcached::get                                                         |  9160.27 |   663 |     13.816390047606 |     18.175099746768 |
| Setup.php-misc                                                         |  9043.82 |   131 |     69.036781369275 |     17.944052059059 |
| Parser::replaceInternalLinks                                           |  8939.13 |   368 |     24.291105850883 |     17.736331385198 |
| OutputPage::output                                                     |  6543.35 |   122 |     53.634057216957 |     12.982824040105 |
| Parser::tidy                                                           |  6521.16 |   184 |     35.441061268682 |     12.938777080863 |
| MessageCache::load                                                     |  6207.49 |   131 |     47.385447727815 |     12.316433703964 |
| MessageCache::load-fromcache                                           |   6194.5 |   131 |      47.28623345062 |     12.290645912012 |
| ParserOptions::initialiseFromUser                                      |  5572.32 |   397 |     14.036071316121 |     11.056171387343 |
| ParserOptions::initialiseFromUser-skin                                 |  5348.07 |   397 |     13.471207395309 |     10.611229766688 |
| DifferenceEngine::showDiffPage                                         |  4061.65 |     2 |     2030.8245849609 |     8.0588133523447 |
| MessageCache::initialise-parseropt                                     |  3806.29 |   262 |     14.527814326396 |     7.5521439848934 |
| wfMsg                                                                  |  2852.79 |  6262 |    0.45557124071782 |     5.6602817935825 |
| LinkCache::addLinkObj                                                  |  2793.56 |  1447 |     1.9305876314681 |      5.542768497824 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |  2513.85 |     9 |     279.31689453125 |     4.9877927967483 |
| Title::secureAndSplit                                                  |  2379.89 |  7113 |    0.33458334843552 |     4.7219982440507 |
| query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X'  |  2369.39 |  1447 |      1.637451171875 |     4.7011659166654 |
| -overhead-total                                                        |  2104.83 | 36936 |   0.056985750584626 |     4.1762339910883 |
| Parser::replaceVariables                                               |  1625.62 |   523 |     3.1082574614603 |     3.2254280843218 |
| Setup.php-includes                                                     |  1392.44 |   131 |     10.629295756799 |     2.7627683769165 |
| memcached::_connect_sock                                               |  1370.96 |   608 |     2.2548739784642 |     2.7201605853412 |
| ParserCache::get                                                       |  1148.96 |    74 |     15.526518950591 |     2.2796832424421 |
| Parser::replaceExternalLinks                                           |  1104.84 |   184 |     6.0045776367188 |     2.1921434834372 |
| -overhead-internal                                                     |  1067.08 | 36936 |   0.028889914469877 |     2.1172142434022 |
| memcached::_set                                                        |  752.784 |   167 |     4.5076875058477 |     1.4936160149919 |
| Title::newFromText                                                     |  724.526 |  5883 |    0.12315591451932 |     1.4375495110492 |
| main-misc-setup                                                        |   566.01 |   131 |      4.320688029282 |     1.1230339739288 |
| Skin::makeKnownLinkObj                                                 |  538.828 |  2778 |    0.19396262996226 |     1.0691016379249 |
| Skin::makeLink                                                         |  484.556 |   188 |     2.5774269915642 |     0.9614194655531 |
| query: BEGIN                                                           |  480.978 |   174 |     2.7642401333513 |    0.95431929723588 |
| query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si |  477.249 |   131 |     3.6431204526479 |    0.94692049315078 |
| query: COMMIT                                                          |  468.765 |   174 |     2.6940491774987 |    0.93008674853165 |
| Setup.php-extensions                                                   |  449.115 |   131 |     3.4283575392861 |    0.89109927986007 |
| Setup.php-language                                                     |  446.264 |   131 |     3.4065931480349 |    0.88544227555165 |
| Parser::doBlockLevels                                                  |  381.012 |   184 |     2.0707175213358 |    0.75597489033649 |
| query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N      |  353.433 |   124 |     2.8502627957252 |    0.70125388221654 |
| query: SHOW COLUMNS FROM cur LIKE 'X';                                 |  348.694 |   126 |     2.7674151223803 |    0.69185254728899 |
| query: SELECT cur_text FROM cur WHERE cur_namespace='X' LIMIT N        |  326.094 |   131 |     2.4892636364653 |    0.64700983150607 |
| Article::getContent                                                    |  325.158 |    51 |     6.3756498448989 |    0.64515389376864 |
| Parser::removeHTMLtags                                                 |  299.808 |   232 |     1.2922765797582 |    0.59485641282261 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi |  294.739 |    18 |     16.374413384332 |    0.58479943554013 |
| LinkCache::preFill                                                     |  255.764 |    46 |      5.560080818508 |    0.50746678913527 |
| query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR |  240.401 |    93 |       2.58495929677 |    0.47698568662258 |
| Setup.php-SetupSession                                                 |  234.129 |   131 |     1.7872463546636 |    0.46454137916576 |
| query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N           |  228.364 |    40 |     5.7090953826904 |    0.45310200044403 |
| query: SELECT N FROM user_newtalk WHERE user_ip='X'                    |  227.871 |   119 |       1.91488173028 |    0.45212404702008 |
| Setup.php-User                                                         |  218.504 |   131 |     1.6679686335207 |    0.43353869342022 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen |  196.649 |    56 |     3.5115863255092 |    0.39017556285746 |
| Setup.php-OutputPage                                                   |  146.437 |   131 |     1.1178369886093 |    0.29054838188145 |
| query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict |   126.87 |    36 |     3.5241574181451 |    0.25172508113883 |
| Setup.php-DateFormatter                                                |  93.3423 |   131 |      0.712536411431 |    0.18520258631848 |
| query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min |  88.0527 |    41 |      2.147625806855 |    0.17470734348696 |
| Parser::doAllQuotes                                                    |  78.4393 |   184 |    0.42630033907683 |    0.15563317968939 |
| Skin::initPage                                                         |  68.6011 |    96 |    0.71459436416626 |    0.13611296958525 |
| query: SELECT cur_restrictions FROM cur WHERE (cur_id=N)               |  57.6924 |    38 |     1.5182211022628 |     0.1144688473073 |
| Setup.php-memcached                                                    |  54.4962 |   131 |    0.41600185132209 |     0.1081272725746 |
| Parser::doHeadings                                                     |  42.9342 |   184 |    0.23333810723346 |   0.085186776182466 |
| PageHistory::history                                                   |  36.9642 |     1 |     36.964183807373 |   0.073341503798841 |
| query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, |  32.5384 |     1 |     32.538421630859 |   0.064560245292687 |
| query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat |  28.6251 |     3 |     9.5417003631592 |   0.056795734250119 |
| query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND  |  28.3628 |    10 |     2.8362762451172 |    0.05627522200675 |
| Parser::replaceInternalLinks-setup                                     |  26.2208 |   368 |    0.07125226829363 |   0.052025372997043 |
| Skin::makeBrokenLinkObj                                                |  19.3462 |   132 |    0.14656215725523 |   0.038385258474077 |
| Setup.php-database                                                     |  15.2411 |   131 |    0.11634425534547 |   0.030240218812123 |
| query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X'       |  10.5018 |    10 |     1.0501803398132 |   0.020836874360125 |
| query: SELECT * FROM ipblocks WHERE ipb_user=N                         |  9.37169 |    12 |    0.78097446759542 |   0.018594597033853 |
| query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c |  7.84227 |     1 |     7.8422737121582 |   0.015560039151658 |
| query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ |  6.72417 |     2 |     3.3620846271515 |   0.013341581880408 |
| query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t |  5.25237 |     1 |     5.2523674964905 |   0.010421345503101 |
| query: SELECT user_name,user_password,user_newpassword,user_email,user |  4.97444 |     2 |     2.4872212409973 |  0.0098699079652762 |
| query: SELECT user_id FROM user WHERE user_name='X'                    |  4.80891 |     2 |     2.4044544696808 |  0.0095414689820397 |
| query: SELECT N FROM user_newtalk WHERE user_id=N                      |   3.7864 |     2 |     1.8932013511658 |  0.0075126903822396 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |   2.7074 |     1 |     2.7073972225189 |  0.0053718103100855 |
| query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags |  2.47897 |     1 |      2.478972196579 |  0.0049185868601907 |
| Setup.php-BlockCache                                                   |  2.14262 |   131 |   0.016355898544079 |  0.0042512279559755 |
| query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp >  |  1.87272 |     1 |     1.8727209568024 |  0.0037157095604555 |
| query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ |  1.72482 |     1 |     1.7248177528381 |   0.003422251345554 |
| query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X |  1.68175 |     1 |      1.681747674942 |  0.0033367949941275 |
| query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N)    |  1.59857 |     2 |    0.79928302764893 |  0.0031717523922154 |
| Parser::replaceInternalLinks-prefixhandling                            |   1.0839 |  2202 | 0.00049223599923296 |  0.0021505986867708 |
| query: UPDATE cur SET cur_text='X'                                     |  0.65933 |     1 |    0.65933042764664 |  0.0013081929609465 |
| query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges          | 0.637713 |     1 |    0.63771265745163 |  0.0012653006362264 |
| query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 0.547512 |     1 |      0.547512114048 |   0.001086331623109 |
| query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 0.509604 |     1 |    0.50960355997086 |  0.0010111163721151 |
| query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N      | 0.433548 |     1 |    0.43354803323746 | 0.00086021281823413 |
| query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id='X' LIMIT  | 0.421201 |     1 |    0.42120134830475 | 0.00083571547116395 |
| query: DELETE FROM linkscc WHERE lcc_pageid='X'                        | 0.414475 |     1 |    0.41447454690933 | 0.00082236866679064 |
| query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 0.407322 |     1 |    0.40732198953629 | 0.00080817710999933 |
| query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 0.398262 |     1 |    0.39826208353043 | 0.00079020113806367 |
| query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X')    |  0.37442 |     1 |    0.37442022562027 | 0.00074289594875931 |
| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 | 0.357493 |     1 |    0.35749250650406 | 0.00070930926435321 |
+------------------------------------------------------------------------+----------+-------+---------------------+---------------------+

| query: SELECT bl_to FROM brokenlinks WHERE bl_from='X'                 | 0.357493 |     1 |    0.35749250650406 | 0.00070930926435321 |
+------------------------------------------------------------------------+----------+-------+---------------------+---------------------+