Profiling/Live 20040927 with breakdown by server
Taken between approximately 05:00 and 13:30. Sampling rate of 1/100, en only.
Basic report
[edit]+------------------------------------------------------------------------+---------------------+--------+---------------------+---------------------+ | name | total | count | each | percent | +------------------------------------------------------------------------+---------------------+--------+---------------------+---------------------+ | -total | 1622711.546875 | 3221 | 490.89560090445 | 100 | | Setup.php | 578186.725585938 | 3221 | 171.43939337151 | 35.630899817001 | | Parser::parse | 468181.455078125 | 4604 | 98.661186572955 | 28.851797842922 | | Article::view | 376805.387695312 | 2144 | 172.56933185529 | 23.220725114144 | | Parser::internalParse | 303597.254882812 | 4604 | 64.821846361157 | 18.709255842018 | | Setup.php-MessageCache | 279694.093261719 | 3221 | 82.804488346918 | 17.236217601357 | | MessageCache::initialise | 279311.885498047 | 3221 | 82.692287340586 | 17.212663953488 | | memcached::get | 254900.184326172 | 15347 | 16.213046736274 | 15.708286837365 | | Setup.php-misc | 208219.898925781 | 3221 | 62.015251939567 | 12.831602716254 | | Parser::replaceInternalLinks | 200906.889160156 | 9208 | 21.304608471103 | 12.38093668262 | | OutputPage::output | 176655.373046875 | 3099 | 56.944286959792 | 10.88643101031 | | MessageCache::load | 172708.36151123 | 3221 | 51.789536063535 | 10.643195449236 | | MessageCache::load-fromcache | 172368.598510742 | 3221 | 51.687422791995 | 10.622257470386 | | ParserOptions::initialiseFromUser | 156196.038085938 | 9787 | 15.111896180081 | 9.6256194384478 | | ParserOptions::initialiseFromUser-skin | 151457.430175781 | 9787 | 14.634034451563 | 9.3336015552152 | | Parser::tidy | 145226.111328125 | 4604 | 29.688407599766 | 8.9495949916545 | | MessageCache::initialise-parseropt | 106102.533935547 | 6442 | 15.371566969058 | 6.5385948685629 | | wfMsg | 87901.1208496094 | 159764 | 0.52181694406866 | 5.4169282901134 | | query: SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'X' | 86979.8094468117 | 16 | 2769.9310893306 | 5.3601522472874 | | LinkCache::addLinkObj | 85222.7807617188 | 28415 | 3.0625486134229 | 5.2518749204589 | | query: SELECT cur_id FROM cur WHERE cur_namespace=N AND cur_title='X' | 74842.6721191406 | 28415 | 2.6879618388087 | 4.6121981607435 | | query: SELECT cur_namespace,cur_title,cur_comment, cur_id, cur_user,cu | 72551.4192028046 | 9 | 8061.2688003116 | 4.4709991336737 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 66271.3537597656 | 171 | 408.06518950684 | 4.0839885491288 | | -overhead-total | 63180.2429199219 | 970956 | 0.064997073745542 | 3.8934980799017 | | Title::secureAndSplit | 61403.5798339844 | 195358 | 0.31107178546616 | 3.7840107782702 | | Setup.php-includes | 47013.0777587891 | 3221 | 13.585780574789 | 2.8971925324206 | | Parser::replaceVariables | 41977.5294189453 | 13206 | 3.1519969840633 | 2.5868756218433 | | ParserCache::get | 39190.8812255859 | 1969 | 19.329017942128 | 2.4151477384295 | | -overhead-internal | 31253.3278808594 | 970956 | 0.032093510856164 | 1.925994052427 | | memcached::_connect_sock | 30895.2074279785 | 14765 | 1.8595934389095 | 1.9039247910373 | | Parser::replaceExternalLinks | 28848.6114501953 | 4604 | 6.3258543077848 | 1.7778028082534 | | Skin::makeLink | 27481.129699707 | 4833 | 5.4873283827147 | 1.6935314075154 | | query: SELECT LENGTH(cur_text) AS x, cur_namespace, cur_is_redirect FR | 27112.9860076904 | 4231 | 6.3219920362371 | 1.6708444615375 | | Title::newFromText | 23778.1378173828 | 161469 | 0.14923437798994 | 1.4653336178679 | | memcached::_set | 22777.2354125977 | 4095 | 5.4794558323918 | 1.4036527598797 | | DifferenceEngine::showDiffPage | 21688.0624847412 | 30 | 712.02472894842 | 1.3365322090983 | | Skin::makeKnownLinkObj | 21240.489074707 | 82879 | 0.25694151381075 | 1.3089503871228 | | main-misc-setup | 20823.0560913086 | 3221 | 6.4293902485216 | 1.2832259763856 | | query: SHOW COLUMNS FROM cur LIKE 'X'; | 14787.2092285156 | 3046 | 4.7876822750869 | 0.91126542218749 | | query: BEGIN | 14119.5896606445 | 4371 | 3.2420850790171 | 0.87012320136847 | | PageHistory::history | 13975.1088943481 | 23 | 483.82514216105 | 0.86121953844855 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 13254.816619873 | 6 | 2934.9791641235 | 0.81683134907119 | | query: SELECT ss_total_views, ss_total_edits, ss_good_articles FROM si | 12170.4578552246 | 3222 | 3.6552876462582 | 0.75000747228689 | | Setup.php-language | 11457.7327270508 | 3221 | 3.4224750376746 | 0.70608561016996 | | query: COMMIT | 11119.546295166 | 4371 | 2.5228745328405 | 0.68524478774924 | | LinkCache::preFill | 11063.7037658691 | 1202 | 9.0795558270533 | 0.68180347808429 | | query: SELECT N FROM user_newtalk WHERE user_ip='X' | 10847.2594909668 | 2837 | 3.8116801524253 | 0.66846504616648 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 10371.2833099365 | 342 | 31.304085922871 | 0.63913289641091 | | Parser::doBlockLevels | 10196.0034790039 | 4604 | 2.2229646784572 | 0.62833123352325 | | Article::getContent | 9437.45855712891 | 1347 | 6.9378518377724 | 0.58158571529878 | | Setup.php-User | 8619.8706817627 | 3221 | 2.5964880108579 | 0.53120166047766 | | query: SELECT cur_touched,cur_is_redirect FROM cur WHERE cur_id=N | 8467.99908447266 | 3159 | 2.6983532347177 | 0.5218425357717 | | query: SELECT cur_text FROM cur WHERE cur_namespace='X' LIMIT N | 8395.73683166504 | 3227 | 2.5333893450296 | 0.51738935658857 | | query: SELECT old_id,old_user,old_comment,old_user_text,old_timestamp, | 8290.53451478481 | 23 | 260.99531549215 | 0.51090623781846 | | query: SELECT lcc_cacheobj FROM linkscc WHERE lcc_pageid = N | 7943.08609008789 | 981 | 8.1101003898356 | 0.48949464280233 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 7915.22375488281 | 3 | 3554.1798400879 | 0.48777761951136 | | Setup.php-SetupSession | 6721.89486694336 | 3221 | 1.9974672027474 | 0.41423843195596 | | Parser::removeHTMLtags | 6384.39190673828 | 5656 | 1.1276393489836 | 0.39343972864637 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_user_text,cur_commen | 6038.1812286377 | 1332 | 4.4728351643812 | 0.37210441007004 | | Setup.php-extensions | 5288.75880432129 | 3221 | 1.6208204029279 | 0.32592106801152 | | Skin::outputPage | 4663.92128753662 | 51 | 86.95726026039 | 0.28741530166087 | | Setup.php-OutputPage | 3806.25830078125 | 3221 | 1.1657501096979 | 0.23456160819902 | | query: SELECT COUNT(user_id) AS total FROM user | 2972.39697265625 | 1 | 2972.3969726562 | 0.18317469783095 | | query: SELECT cur_user,cur_user_text,cur_timestamp,cur_comment,cur_min | 2907.97978973389 | 1018 | 2.7829756667157 | 0.17920497301779 | | Skin::doAfterContent | 2605.71569633484 | 40 | 64.989675336006 | 0.16057787358159 | | query: SELECT cur_restrictions FROM cur WHERE (cur_id=N) | 2367.51244354248 | 996 | 2.3971912424887 | 0.14589853927531 | | Parser::doAllQuotes | 2036.88550567627 | 4604 | 0.44765632603898 | 0.12552357254121 | | query: UPDATE cur SET cur_text='X' | 1907.12296295166 | 32 | 111.65410131108 | 0.11752692378534 | | Setup.php-DateFormatter | 1769.12295532227 | 3221 | 0.53646912242147 | 0.10902263921947 | | query: SELECT cur_text,cur_timestamp,cur_user,cur_counter,cur_restrict | 1686.26461029053 | 631 | 2.7189301683935 | 0.10391647323506 | | Skin::makeBrokenLinkObj | 1643.85834503174 | 8335 | 0.20619776863204 | 0.10130317666115 | | Setup.php-memcached | 1565.52010345459 | 3221 | 0.48318627188694 | 0.09647556316891 | | Skin::doAfterContent-3 | 1556.45915079117 | 40 | 38.27869479106 | 0.095917179722335 | | query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 1349.29079145193 | 3 | 449.76359715064 | 0.083150378392905 | | Parser::doHeadings | 1236.51756286621 | 4604 | 0.26828639241048 | 0.076200700318395 | | query: SELECT cur_id,cur_namespace,cur_title FROM cur,links WHERE cur_ | 1129.68452638388 | 46 | 18.661994227105 | 0.069617088049901 | | query: SELECT old_namespace,old_title,old_timestamp,old_comment,old_mi | 1064.2802798152 | 5 | 212.85605596304 | 0.065586535195659 | | query: SELECT N FROM watchlist WHERE wl_user=N AND wl_namespace=N AND | 1060.91578865051 | 311 | 3.3184163724051 | 0.06537919759637 | | Skin::doAfterContent-4 | 1026.14902305603 | 40 | 26.059005502554 | 0.063236687076774 | | Skin::quickBar | 1023.49976158142 | 34 | 31.779948845888 | 0.063073425683848 | | query: SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=N | 960.837266027927 | 17 | 43.442687394442 | 0.059211833913322 | | query: SELECT bl_to FROM brokenlinks WHERE bl_from='X' | 935.374981343746 | 46 | 15.383698405491 | 0.057642714328685 | | query: SELECT old_namespace,old_title,old_text,old_timestamp,old_user, | 868.81635093689 | 12 | 85.690272104172 | 0.053541022285202 | | Skin::doBeforeContent | 850.038271903992 | 40 | 20.561382239904 | 0.052383818525294 | | query: SELECT cur_id,cur_title FROM cur USE INDEX (cur_random) WHERE c | 834.891572475433 | 43 | 16.64525453565 | 0.05145039943071 | | query: SELECT COUNT(user_id) AS total FROM user WHERE user_rights LIKE | 786.190795898438 | 1 | 786.19079589844 | 0.048449202041637 | | query: SELECT DISTINCT cur_title,cur_namespace,cl_sortkey FROM cur,cat | 767.671352386475 | 26 | 43.240277862549 | 0.047307936759608 | | Setup.php-database | 766.318347930908 | 3221 | 0.22149086703104 | 0.047224557525746 | | Parser::replaceInternalLinks-setup | 764.437412261963 | 9208 | 0.083346259209477 | 0.047108644400424 | | query: SELECT * FROM ipblocks WHERE ipb_user=N | 724.417985916138 | 391 | 1.7306822769331 | 0.044642437364251 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 558.383796691895 | 12 | 52.037086963654 | 0.03441053943119 | | Skin::initPage | 524.31721496582 | 2453 | 0.21592684794162 | 0.03231117791548 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 496.494028091431 | 12 | 45.752885909308 | 0.030596567150063 | | query: SELECT COUNT(cur_id) AS total FROM cur | 479.549926757812 | 1 | 479.54992675781 | 0.029552382718994 | | query: SELECT cur_text, cur_user_text, cur_comment FROM cur WHERE cur_ | 437.003462731838 | 22 | 17.809957907597 | 0.026930446361426 | | query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM link | 423.269980430603 | 28 | 13.564019290728 | 0.026084117121477 | | query: SELECT img_size,img_description,img_user,img_user_text,img_time | 357.313192993402 | 65 | 5.8309641538304 | 0.022019513799696 | | query: SELECT math_outputhash,math_html_conservativeness,math_html,mat | 344.243787109852 | 137 | 3.1537651892842 | 0.02121410843306 | | query: SELECT oi_size AS img_size, oi_description AS img_description,o | 339.942971229553 | 65 | 5.4034524610191 | 0.020949069591833 | | query: SELECT user_name,user_password,user_newpassword,user_email,user | 315.448284626007 | 89 | 3.6764978963959 | 0.01943957847798 | | query: SELECT cur_namespace,cur_title FROM cur WHERE cur_id='X' LIMIT | 298.017235338688 | 15 | 19.931142675025 | 0.018365385758954 | | query: INSERT INTO old (old_namespace,old_title,old_text,old_comment,o | 292.973892450333 | 32 | 5.7701217752514 | 0.018054588507399 | | query: SELECT user_id FROM user WHERE user_name='X' | 278.455575108528 | 59 | 4.6515905403392 | 0.017159893614165 | | query: SELECT N FROM user_newtalk WHERE user_id=N | 256.723882555962 | 89 | 2.5577065386178 | 0.015820672691358 | | query: SELECT * FROM ipblocks WHERE (ipb_address='X' OR ipb_user=N) | 242.140460968018 | 69 | 3.0435795256543 | 0.01492196573287 | | query: UPDATE recentchanges SET rc_this_oldid=N WHERE rc_namespace=N A | 233.893060684204 | 32 | 5.2100242529855 | 0.014413717652693 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 215.52294921875 | 1 | 215.52294921875 | 0.013281654994925 | | query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 186.376576125622 | 5 | 37.275315225124 | 0.011485502551858 | | query: SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_mi | 176.373719155788 | 3 | 58.791239718596 | 0.010869074019683 | | query: SELECT cur_namespace,cur_title FROM imagelinks,cur WHERE il_to= | 169.865407019854 | 65 | 2.387377200655 | 0.010467997676295 | | query: SELECT iw_url,iw_local FROM interwiki WHERE iw_prefix='X' | 157.267862677574 | 108 | 1.3351198086196 | 0.0096916708937235 | | query: SELECT qc_type as type, qc_namespace as namespace,qc_title as t | 151.65852355957 | 1 | 151.65852355957 | 0.0093459939846754 | | query: DELETE FROM user_newtalk WHERE user_id=N | 132.123678505421 | 9 | 18.715982160398 | 0.0081421543317334 | | query: REPLACE INTO linkscc(lcc_pageid,lcc_cacheobj) VALUES(N, 'X') | 131.469092100859 | 46 | 2.2164801110824 | 0.0081018152828234 | | query: SELECT old_namespace,old_title,old_timestamp,old_text,old_flags | 128.973555862904 | 26 | 4.7405739366062 | 0.0079480272455865 | | query: SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_ | 125.01642036438 | 5 | 23.635264714559 | 0.0077041677927994 | | Parser::replaceInternalLinks-prefixhandling | 119.2636375539 | 65066 | 0.0015143579761527 | 0.0073496511307618 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 116.270286560059 | 1 | 116.27028656006 | 0.0071651851361982 | | query: UPDATE recentchanges SET rc_cur_time='X' WHERE rc_cur_id=N | 107.964420437813 | 32 | 2.6131059045141 | 0.0066533340842819 | | query: DELETE FROM linkscc WHERE lcc_pageid='X' | 97.9122161269188 | 32 | 4.3487610612855 | 0.0060338645100219 | | query: SELECT cur_text FROM cur WHERE cur_namespace=N AND cur_title='X | 92.4318405389786 | 12 | 5.2688911642347 | 0.0056961350103771 | | query: SELECT COUNT(*) AS n FROM archive WHERE ar_namespace=N AND ar_t | 82.9733724296093 | 19 | 5.1408384035934 | 0.0051132545762307 | | query: INSERT INTO recentchanges (rc_timestamp,rc_cur_time,rc_namespac | 77.6844197511673 | 34 | 1.8405794795715 | 0.0047873215606786 | | query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO | 77.0732805728912 | 6 | 10.680660295486 | 0.0047496599578229 | | Setup.php-BlockCache | 67.6592740416527 | 3221 | 0.021361497950381 | 0.004169519479414 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 53.9821281433105 | 6 | 9.2215514183044 | 0.0033266619842121 | | query: SELECT MAX(rc_timestamp) AS lastmod FROM recentchanges | 53.2853527069092 | 11 | 3.3276492555936 | 0.0032837230257913 | | query: SELECT cur_title FROM cur WHERE cur_namespace=N AND cur_title > | 32.7238521575928 | 2 | 16.361926078796 | 0.0020166154743036 | | query: SELECT cur_namespace,cur_title,cur_id FROM brokenlinks,cur WHER | 28.2045516967773 | 2 | 14.102275848389 | 0.0017381124668209 | | query: UPDATE user SET user_name= 'X' WHERE user_id=N | 23.143497467041 | 9 | 3.0459547979491 | 0.0014262237494773 | | query: SELECT recentchanges.* FROM recentchanges WHERE rc_timestamp > | 13.2642889022827 | 4 | 3.5465744336446 | 0.00081741508081501 | | query: SELECT cur_id,cur_namespace,cur_title,cur_is_redirect FROM brok | 8.75241184234619 | 1 | 8.7524118423462 | 0.0005393695422456 | | query: SELECT DISTINCT 'X' as type, N as namespace, cl_to as title, N | 8.03912734985352 | 3 | 2.6797091166178 | 0.00049541320916433 | | query: INSERT INTO cur (cur_namespace,cur_title,cur_text,cur_comment,c | 6.05951941013336 | 2 | 3.0297597050667 | 0.00037341938077674 | | query: INSERT INTO user (user_name,user_password,user_newpassword,user | 6.02246236801147 | 1 | 6.0224623680115 | 0.00037113573140029 | | query: REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES | 5.61994901299477 | 7 | 0.87321182092031 | 0.00034633074644829 | | query: SELECT recentchanges.*,wl_user FROM recentchanges LEFT OUTER JO | 4.78285264968872 | 1 | 4.7828526496887 | 0.0002947444762379 | | query: UPDATE cur set cur_touched='X' | 4.09614241123199 | 2 | 2.048071205616 | 0.0002524257881273 | | Skin::doAfterContent-2 | 2.56273725442588 | 40 | 0.053205894172574 | 0.00015792931648026 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 2.4613356590271 | 2 | 1.2306678295135 | 0.00015168041811048 | | query: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_fro | 2.44127893447876 | 2 | 1.2206394672394 | 0.00015044441750477 | | query: SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchi | 1.07093501091003 | 2 | 0.53546750545502 | 6.5996634643565e-05 | | Skin::doAfterContent-1 | -0.0496150735998526 | 40 | -0.0017541725570575 | -3.057541169002e-06 | +------------------------------------------------------------------------+---------------------+--------+---------------------+---------------------+
Breakdown by server
[edit]| average time per request (ms) | ||||
| server | requests | total | parse | memcached get |
| dalembert.wikimedia.org | 305 | 912.663 | 146.3059 | 22.66566204 |
| avicenna.wikimedia.org | 292 | 665.8515 | 167.7046 | 27.53103911 |
| isidore.wikimedia.org | 217 | 637.0766 | 93.70463 | 16.77243281 |
| alrazi.wikimedia.org | 283 | 559.8917 | 115.7494 | 22.260118 |
| moreri.wikimedia.org | 176 | 494.137 | 72.24291 | 16.97927864 |
| harris.wikimedia.org | 249 | 493.6051 | 95.12293 | 16.11586293 |
| bart.wikimedia.org | 262 | 484.7492 | 90.24099 | 12.98728575 |
| vincent | 209 | 422.378 | 98.94985 | 19.3697839 |
| tingxi.wikimedia.org | 263 | 376.6062 | 100.1559 | 12.68490473 |
| goeje.wikimedia.org | 288 | 368.1998 | 73.87426 | 13.74310366 |
| bayle.wikimedia.org | 243 | 367.8818 | 88.13722 | 14.16714945 |
| friedrich.wikimedia.org | 277 | 330.0313 | 78.56876 | 12.56430095 |
| yongle.wikimedia.org | 157 | 268.5718 | 61.83809 | 2.928685602 |