# 280ms user time, 20ms system time, 35.45M rss, 100.93M vsz # Current date: Thu Mar 10 22:50:38 2016 # Hostname: laptop # Files: /tmp/cn-write-local-slow.log # Overall: 330 total, 36 unique, 0 QPS, 0x concurrency ___________________ # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 34ms 1us 2ms 102us 348us 229us 35us # Lock time 8ms 0 399us 23us 93us 44us 0 # Rows sent 2.00k 0 406 6.22 9.83 43.83 0 # Rows examine 1.44k 0 418 4.46 17.65 31.40 0 # Merge passes 0 0 0 0 0 0 0 # Query size 83.68k 27 7.52k 258.11 563.87 673.65 102.22 # Boolean: # Full join 19% yes, 80% no # Full scan 100% yes, 0% no # QC hit 31% yes, 68% no # Tmp table 3% yes, 96% no # Tmp table on 2% yes, 97% no # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== ============= ===== ====== ===== =============== # 1 0x3BEC06E8C5EE2E60 0.0056 16.7% 16 0.0004 0.00 SELECT module_deps # 2 0x9617DE062D3FFA8D 0.0036 10.7% 2 0.0018 0.00 COMMIT # 3 0xC88483FE5B167171 0.0025 7.4% 12 0.0002 0.00 SELECT cn_notices cn_template_devices # 4 0xC12907541AA5D9C1 0.0023 6.8% 22 0.0001 0.00 SELECT cn_notices # 5 0x122EF9E3168F0E18 0.0023 6.7% 16 0.0001 0.00 SELECT cn_notices cn_notice_mixins cn_notice_mixin_params # 6 0x53B3FBBD50DD87AD 0.0022 6.5% 38 0.0001 0.00 SELECT cn_notices # 7 0x5D1C393D8BEFBE08 0.0021 6.2% 2 0.0011 0.00 INSERT cn_notice_log # 8 0x5A0DFDB1DF78DBB2 0.0014 4.2% 6 0.0002 0.00 UPDATE Admin # 9 0x292432918989C0B8 0.0011 3.3% 10 0.0001 0.00 SELECT revision page user # 10 0xE537093C9B8035CC 0.0010 2.9% 2 0.0005 0.00 SHOW COLUMNS # 11 0x09892531791300C6 0.0009 2.8% 12 0.0001 0.00 SELECT cn_notices # 12 0x1DB6DBBAECEAD472 0.0009 2.6% 7 0.0001 0.00 SELECT cn_notices cn_assignments cn_templates cn_notice_projects cn_notice_languages # 13 0x407FBEA83325982D 0.0008 2.4% 20 0.0000 0.00 SET # 14 0xC9AFA2C0D78AD345 0.0008 2.4% 4 0.0002 0.00 SELECT cn_template_devices cn_known_devices # 15 0x10806A876ECCC9F8 0.0007 2.1% 10 0.0001 0.00 SELECT page # 16 0x9273875715F8D8A1 0.0006 1.7% 6 0.0001 0.00 UPDATE Admin # 17 0xE4BDA3F9F78A0569 0.0005 1.6% 6 0.0001 0.00 UPDATE Admin # 18 0x425AAC533BEFEF74 0.0005 1.5% 8 0.0001 0.00 SELECT cn_notices # 19 0xE8549377A8C0C1D3 0.0004 1.3% 2 0.0002 0.00 SELECT cn_notice_countries cn_notice_languages cn_notice_projects cn_notices # 20 0xFD2F0603A3CAE705 0.0004 1.3% 8 0.0001 0.00 SELECT page revision # 21 0xD33671F9FE962A9D 0.0004 1.2% 12 0.0000 0.00 SELECT cn_notice_languages # 22 0x074589206E4C2D0C 0.0003 1.0% 2 0.0002 0.00 SELECT job # 23 0xEEFFDFD47840839B 0.0003 1.0% 12 0.0000 0.00 SELECT cn_notice_countries # 24 0xFF2878F771226A9B 0.0003 0.9% 6 0.0001 0.00 SELECT page revision # 25 0x9B8C934C449AB5B6 0.0003 0.9% 12 0.0000 0.00 SELECT cn_notice_projects # 26 0x3AE84F0689E8B71E 0.0003 0.8% 2 0.0001 0.00 SELECT module_deps # 27 0x2342554AF88317C9 0.0003 0.8% 22 0.0000 0.00 BEGIN # 28 0xF00C39C65E3E24D0 0.0002 0.7% 4 0.0001 0.00 UPDATE Admin # 29 0x9B8F20D4EDCA1899 0.0002 0.6% 4 0.0001 0.00 SELECT cn_notices cn_notice_countries # 30 0xC4EFE8926FEEC5DB 0.0002 0.6% 2 0.0001 0.00 SELECT cn_notices # 31 0x44AE35A182869033 0.0001 0.3% 19 0.0000 0.00 ADMIN INIT DB # 32 0x120266EA18C29BB8 0.0001 0.2% 2 0.0000 0.00 SELECT page # 33 0x40FB12E0241B130A 0.0000 0.1% 2 0.0000 0.00 SELECT user_newtalk # 34 0xAA353644DE4C4CB4 0.0000 0.1% 18 0.0000 0.00 ADMIN QUIT # 35 0x836A6EA883156E9D 0.0000 0.1% 2 0.0000 0.00 SET # Query 1: 0 QPS, 0x concurrency, ID 0x3BEC06E8C5EE2E60 at byte 43241 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 4 16 # Exec time 16 6ms 31us 2ms 350us 839us 527us 247us # Lock time 18 1ms 0 399us 89us 332us 113us 80us # Rows sent 3 81 0 29 5.06 28.75 9.14 0.99 # Rows examine 12 179 0 29 11.19 28.75 13.73 0 # Merge passes 0 0 0 0 0 0 0 0 # Query size 23 20.02k 157 7.52k 1.25k 7.31k 2.31k 400.73 # Boolean: # Full scan 100% yes, 0% no # QC hit 43% yes, 56% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ########################################## # 100us ################################################################ # 1ms ####### # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'module_deps'\G # SHOW CREATE TABLE `mw1`.`module_deps`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* ResourceLoader::preloadModuleInfo */ md_module,md_deps FROM `module_deps` WHERE md_module IN ('startup','site','noscript','filepage','user.groups','user','user.cssprefs','user.defaults','user.options','user.tokens','mediawiki.language.data','mediawiki.skinning.elements','mediawiki.skinning.content','mediawiki.skinning.interface','mediawiki.skinning.content.parsoid','mediawiki.skinning.content.externallinks','jquery','jquery.accessKeyLabel','jquery.appear','jquery.arrowSteps'/*... omitted 274 items ...*/) AND md_skin = 'vector|en'\G # Query 2: 0 QPS, 0x concurrency, ID 0x9617DE062D3FFA8D at byte 35608 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 10 4ms 2ms 2ms 2ms 2ms 148us 2ms # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 90 45 45 45 45 0 45 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us # 1ms ################################################################ # 10ms # 100ms # 1s # 10s+ COMMIT /* MediaWiki::preOutputCommit Admin */\G # Query 3: 0 QPS, 0x concurrency, ID 0xC88483FE5B167171 at byte 3569 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 12 # Exec time 7 2ms 13us 664us 206us 541us 196us 131us # Lock time 6 546us 0 112us 45us 89us 33us 40us # Rows sent 1 40 0 10 3.33 9.83 4.63 0 # Rows examine 4 72 0 24 6 23.65 10.24 0 # Merge passes 0 0 0 0 0 0 0 0 # Query size 8 6.75k 576 576 576 576 0 576 # Boolean: # Full join 100% yes, 0% no # Full scan 100% yes, 0% no # QC hit 25% yes, 75% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ##################### # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_template_devices'\G # SHOW CREATE TABLE `mw1`.`cn_template_devices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* Banner::getCampaignBanners Admin */ tmp_name,tmp_weight,tmp_display_anon,tmp_display_account,tmp_category,not_name,not_preferred,asn_bucket,not_buckets,not_throttle,dev_name FROM `cn_notices` `notices`,`cn_templates` `templates`,`cn_known_devices` `known_devices`,`cn_assignments` `assignments` LEFT JOIN `cn_template_devices` `template_devices` ON ((template_devices.tmp_id = assignments.tmp_id)) WHERE notices.not_id = '1' AND (notices.not_id = assignments.not_id) AND (known_devices.dev_id = template_devices.dev_id) AND (assignments.tmp_id = templates.tmp_id)\G # Query 4: 0 QPS, 0x concurrency, ID 0xC12907541AA5D9C1 at byte 84238 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 6 22 # Exec time 6 2ms 8us 312us 103us 176us 68us 103us # Lock time 10 855us 0 107us 38us 66us 25us 33us # Rows sent 1 22 1 1 1 1 0 1 # Rows examine 2 39 0 3 1.77 2.90 0.82 1.96 # Merge passes 0 0 0 0 0 0 0 0 # Query size 2 2.35k 107 111 109.18 107.34 2 107.34 # Boolean: # Full scan 100% yes, 0% no # QC hit 4% yes, 95% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ##### # 10us ########################################################## # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* DatabaseBase::selectRow Admin */ not_name FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1\G # Query 5: 0 QPS, 0x concurrency, ID 0x122EF9E3168F0E18 at byte 4476 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 4 16 # Exec time 6 2ms 9us 462us 141us 403us 128us 125us # Lock time 6 503us 0 119us 31us 63us 30us 30us # Rows sent 4 96 0 12 6 11.95 5.97 11.95 # Rows examine 12 180 0 18 11.25 17.65 8.54 17.65 # Merge passes 0 0 0 0 0 0 0 0 # Query size 9 7.99k 506 515 511.50 511.45 4.50 511.45 # Boolean: # Full join 100% yes, 0% no # Full scan 100% yes, 0% no # QC hit 37% yes, 62% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ###### # 10us ################################ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_mixins'\G # SHOW CREATE TABLE `mw1`.`cn_notice_mixins`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_mixin_params'\G # SHOW CREATE TABLE `mw1`.`cn_notice_mixin_params`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* Campaign::getCampaignMixins Admin */ notice_mixins.nmxn_mixin_name,notice_mixins.nmxn_enabled,notice_mixin_params.nmxnp_param_name,notice_mixin_params.nmxnp_param_value FROM `cn_notices` `notices` INNER JOIN `cn_notice_mixins` `notice_mixins` ON ((notices.not_id = notice_mixins.nmxn_not_id)) LEFT OUTER JOIN `cn_notice_mixin_params` `notice_mixin_params` ON ((notice_mixins.nmxn_id = notice_mixin_params.nmxnp_notice_mixin_id)) WHERE notices.not_name = 'Test1' AND notice_mixins.nmxn_enabled = '1'\G # Query 6: 0 QPS, 0x concurrency, ID 0x53B3FBBD50DD87AD at byte 94281 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 11 38 # Exec time 6 2ms 4us 206us 57us 138us 52us 47us # Lock time 10 820us 0 88us 21us 57us 21us 19us # Rows sent 1 38 1 1 1 1 0 1 # Rows examine 3 45 0 3 1.18 2.90 1.11 0.99 # Merge passes 0 0 0 0 0 0 0 0 # Query size 4 3.98k 105 109 107.29 107.34 2 107.34 # Boolean: # Full scan 100% yes, 0% no # QC hit 39% yes, 60% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ##################################### # 10us ################################################################ # 100us ########################## # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1\G # Query 7: 0 QPS, 0x concurrency, ID 0x5D1C393D8BEFBE08 at byte 97889 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 6 2ms 182us 2ms 1ms 2ms 1ms 1ms # Lock time 2 172us 55us 117us 86us 117us 43us 86us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 8 6.73k 943 5.81k 3.36k 5.81k 3.46k 3.36k # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms ################################################################ # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_log'\G # SHOW CREATE TABLE `mw1`.`cn_notice_log`\G INSERT /* DatabaseBase::insert Admin */ INTO `cn_notice_log` (notlog_timestamp,notlog_user_id,notlog_action,notlog_not_id,notlog_not_name,notlog_comment,notlog_begin_start,notlog_begin_end,notlog_begin_enabled,notlog_begin_preferred,notlog_begin_locked,notlog_begin_archived,notlog_begin_geo,notlog_begin_buckets,notlog_begin_throttle,notlog_begin_projects,notlog_begin_languages,notlog_begin_countries,notlog_begin_banners,notlog_begin_mixins,notlog_end_start,notlog_end_end,notlog_end_enabled,notlog_end_preferred,notlog_end_locked,notlog_end_archived,notlog_end_geo,notlog_end_buckets,notlog_end_throttle,notlog_end_projects,notlog_end_languages,notlog_end_countries,notlog_end_banners,notlog_end_mixins) VALUES ('20160311024202','1','modified','1','Test1','','20150302215300','20160519225300','0','1','0','0','1','4','100','mw1, mw2','aa, ab, ace, aeb, aeb-arab, aeb-latn, af, ak, aln, als, am, an, ang, anp, ar, arc, arn, arq, ary, arz, as, ast, av, avk, ay, az, azb, ba, bar, bat-smg, bbc, bbc-latn, bcc, bcl, be, be-tarask, be-x-old, bg, bgn, bh, bho, bi, bjn, bm, bn, bo, bpy, bqi, br, brh, bs, bto, bug, bxr, ca, cbk-zam, cdo, ce, ceb, ch, cho, chr, chy, ckb, co, cps, cr, crh, crh-cyrl, crh-latn, cs, csb, cu, cv, cy, da, de, de-at, de-ch, de-formal, diq, dsb, dtp, dv, dz, ee, egl, el, eml, en, en-ca, en-gb, eo, es, et, eu, ext, fa, ff, fi, fit, fiu-vro, fj, fo, fr, frc, frp, frr, fur, fy, ga, gag, gan, gan-hans, gan-hant, gd, gl, glk, gn, gom-latn, got, grc, gsw, gu, gv, ha, hak, haw, he, hi, hif, hif-latn, hil, ho, hr, hrx, hsb, ht, hu, hy, hz, ia, id, ie, ig, ii, ik, ike-cans, ike-latn, ilo, inh, io, is, it, iu, ja, jam, jbo, jut, jv, ka, kaa, kab, kbd, kbd-cyrl, kg, khw, ki, kiu, kj, kk, kk-arab, kk-cn, kk-cyrl, kk-kz, kk-latn, kk-tr, kl, km, kn, ko, ko-kp, koi, kr, krc, kri, krj, ks, ks-arab, ks-deva, ksh, ku, ku-arab, ku-latn, kv, kw, ky, la, lad, lb, lbe, lez, lfn, lg, li, lij, liv, lmo, ln, lo, loz, lrc, lt, ltg, lus, lv, lzh, lzz, mai, map-bms, mdf, mg, mh, mhr, mi, min, mk, ml, mn, mo, mr, mrj, ms, mt, mus, mwl, my, myv, mzn, na, nah, nan, nap, nb, nds, nds-nl, ne, new, ng, niu, nl, nl-informal, nn, no, nov, nrm, nso, nv, ny, oc, om, or, os, pa, pag, pam, pap, pcd, pdc, pdt, pfl, pi, pih, pl, pms, pnb, pnt, prg, ps, pt, pt-br, qu, qug, rgn, rif, rm, rmy, rn, ro, roa-rup, roa-tara, ru, rue, rup, ruq, ruq-cyrl, ruq-latn, rw, sa, sah, sat, sc, scn, sco, sd, sdc, se, sei, ses, sg, sgs, sh, shi, shi-latn, shi-tfng, si, simple, sk, sl, sli, sm, sma, sn, so, sq, sr, sr-ec, sr-el, srn, ss, st, stq, su, sv, sw, szl, ta, tcy, te, tet, tg, tg-cyrl, tg-latn, th, ti, tk, tl, tly, tn, to, tokipona, tpi, tr, tru, ts, tt, tt-cyrl, tt-latn, tum, tw, ty, tyv, tzm, udm, ug, ug-arab, ug-latn, uk, ur, uz, uz-cyrl, uz-latn, ve, vec, vep, vi, vls, vmf, vo, vot, vro, wa, war, wo, wuu, xal, xh, xmf, yi, yo, yue, za, zea, zh, zh-classical, zh-cn, zh-hans, zh-hant, zh-hk, zh-min-nan, zh-mo, zh-my, zh-sg, zh-tw, zh-yue, zu','CA, DZ, IT','{\"Banner_1\":{\"weight\":25,\"bucket\":0},\"Smallbanneree\":{\"weight\":25,\"bucket\":2},\"Banner_2\":{\"weight\":25,\"bucket\":1},\"Smallbanerieie\":{\"weight\":25,\"bucket\":3}}','{\"bannerHistoryLogger\":{\"maxEntries\":8,\"maxEntryAge\":2,\"rate\":1,\"waitLogNoSendBeacon\":300},\"legacySupport\":{\"bannersNotGuaranteedToDisplay\":true,\"setSRISampleRate\":true,\"sriSampleRate\":1}}','20150302215300','20160519225300','1','1','0','0','1','4','100','mw1, mw2','aa, ab, ace, aeb, aeb-arab, aeb-latn, af, ak, aln, als, am, an, ang, anp, ar, arc, arn, arq, ary, arz, as, ast, av, avk, ay, az, azb, ba, bar, bat-smg, bbc, bbc-latn, bcc, bcl, be, be-tarask, be-x-old, bg, bgn, bh, bho, bi, bjn, bm, bn, bo, bpy, bqi, br, brh, bs, bto, bug, bxr, ca, cbk-zam, cdo, ce, ceb, ch, cho, chr, chy, ckb, co, cps, cr, crh, crh-cyrl, crh-latn, cs, csb, cu, cv, cy, da, de, de-at, de-ch, de-formal, diq, dsb, dtp, dv, dz, ee, egl, el, eml, en, en-ca, en-gb, eo, es, et, eu, ext, fa, ff, fi, fit, fiu-vro, fj, fo, fr, frc, frp, frr, fur, fy, ga, gag, gan, gan-hans, gan-hant, gd, gl, glk, gn, gom-latn, got, grc, gsw, gu, gv, ha, hak, haw, he, hi, hif, hif-latn, hil, ho, hr, hrx, hsb, ht, hu, hy, hz, ia, id, ie, ig, ii, ik, ike-cans, ike-latn, ilo, inh, io, is, it, iu, ja, jam, jbo, jut, jv, ka, kaa, kab, kbd, kbd-cyrl, kg, khw, ki, kiu, kj, kk, kk-arab, kk-cn, kk-cyrl, kk-kz, kk-latn, kk-tr, kl, km, kn, ko, ko-kp, koi, kr, krc, kri, krj, ks, ks-arab, ks-deva, ksh, ku, ku-arab, ku-latn, kv, kw, ky, la, lad, lb, lbe, lez, lfn, lg, li, lij, liv, lmo, ln, lo, loz, lrc, lt, ltg, lus, lv, lzh, lzz, mai, map-bms, mdf, mg, mh, mhr, mi, min, mk, ml, mn, mo, mr, mrj, ms, mt, mus, mwl, my, myv, mzn, na, nah, nan, nap, nb, nds, nds-nl, ne, new, ng, niu, nl, nl-informal, nn, no, nov, nrm, nso, nv, ny, oc, om, or, os, pa, pag, pam, pap, pcd, pdc, pdt, pfl, pi, pih, pl, pms, pnb, pnt, prg, ps, pt, pt-br, qu, qug, rgn, rif, rm, rmy, rn, ro, roa-rup, roa-tara, ru, rue, rup, ruq, ruq-cyrl, ruq-latn, rw, sa, sah, sat, sc, scn, sco, sd, sdc, se, sei, ses, sg, sgs, sh, shi, shi-latn, shi-tfng, si, simple, sk, sl, sli, sm, sma, sn, so, sq, sr, sr-ec, sr-el, srn, ss, st, stq, su, sv, sw, szl, ta, tcy, te, tet, tg, tg-cyrl, tg-latn, th, ti, tk, tl, tly, tn, to, tokipona, tpi, tr, tru, ts, tt, tt-cyrl, tt-latn, tum, tw, ty, tyv, tzm, udm, ug, ug-arab, ug-latn, uk, ur, uz, uz-cyrl, uz-latn, ve, vec, vep, vi, vls, vmf, vo, vot, vro, wa, war, wo, wuu, xal, xh, xmf, yi, yo, yue, za, zea, zh, zh-classical, zh-cn, zh-hans, zh-hant, zh-hk, zh-min-nan, zh-mo, zh-my, zh-sg, zh-tw, zh-yue, zu','CA, DZ, IT','{\"Banner_1\":{\"weight\":25,\"bucket\":0},\"Smallbanneree\":{\"weight\":25,\"bucket\":2},\"Banner_2\":{\"weight\":25,\"bucket\":1},\"Smallbanerieie\":{\"weight\":25,\"bucket\":3}}','{\"bannerHistoryLogger\":{\"maxEntries\":8,\"maxEntryAge\":2,\"rate\":1,\"waitLogNoSendBeacon\":300},\"legacySupport\":{\"bannersNotGuaranteedToDisplay\":true,\"setSRISampleRate\":true,\"sriSampleRate\":1}}')\G # Query 8: 0 QPS, 0x concurrency, ID 0x5A0DFDB1DF78DBB2 at byte 83949 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 6 # Exec time 4 1ms 59us 399us 234us 384us 122us 304us # Lock time 5 409us 17us 151us 68us 144us 42us 80us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 1 18 3 3 3 3 0 3 # Query size 0 620 101 105 103.33 102.22 2 102.22 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ############ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'Admin'\G # SHOW CREATE TABLE `mw1`.`Admin`\G UPDATE /* DatabaseBase::update Admin */ `cn_notices` SET not_archived = '1' WHERE not_name = 'foot!test'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select not_archived = '1' from /* DatabaseBase::update Admin */ `cn_notices` where not_name = 'foot!test'\G # Query 9: 0 QPS, 0x concurrency, ID 0x292432918989C0B8 at byte 65122 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 10 # Exec time 3 1ms 15us 343us 111us 167us 97us 152us # Lock time 4 342us 0 121us 34us 57us 38us 49us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 5 4.96k 508 509 508.40 487.09 0.00 487.09 # Boolean: # QC hit 50% yes, 50% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'revision'\G # SHOW CREATE TABLE `mw1`.`revision`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'page'\G # SHOW CREATE TABLE `mw1`.`page`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'user'\G # SHOW CREATE TABLE `mw1`.`user`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* Revision::fetchFromConds */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user)) WHERE page_namespace = '8' AND page_title = 'Common.js' AND (rev_id=page_latest) LIMIT 1\G # Query 10: 0 QPS, 0x concurrency, ID 0xE537093C9B8035CC at byte 97472 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 2 968us 436us 532us 484us 532us 67us 484us # Lock time 7 591us 255us 336us 295us 336us 57us 295us # Rows sent 0 2 1 1 1 1 0 1 # Rows examine 0 2 1 1 1 1 0 1 # Merge passes 0 0 0 0 0 0 0 0 # Query size 0 174 87 87 87 87 0 87 # Boolean: # Full scan 100% yes, 0% no # Tmp table 100% yes, 0% no # Tmp table on 100% yes, 0% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_log'\G # SHOW CREATE TABLE `mw1`.`cn_notice_log`\G SHOW /* DatabaseBase::query Admin */ COLUMNS FROM `cn_notice_log` LIKE 'notlog_comment'\G # Query 11: 0 QPS, 0x concurrency, ID 0x09892531791300C6 at byte 92281 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 12 # Exec time 2 933us 7us 187us 77us 176us 56us 76us # Lock time 4 357us 0 69us 29us 49us 20us 33us # Rows sent 0 12 1 1 1 1 0 1 # Rows examine 1 18 0 3 1.50 2.90 1.08 1.96 # Merge passes 0 0 0 0 0 0 0 0 # Query size 3 2.63k 222 226 224.33 223.14 2 223.14 # Boolean: # Full scan 100% yes, 0% no # QC hit 25% yes, 75% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################################ # 10us ################################################################ # 100us ################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* Campaign::getCampaignSettings Admin */ not_id,not_start,not_end,not_enabled,not_preferred,not_locked,not_archived,not_geo,not_buckets,not_throttle FROM `cn_notices` `notices` WHERE not_name = 'Test1' LIMIT 1\G # Query 12: 0 QPS, 0x concurrency, ID 0x1DB6DBBAECEAD472 at byte 132180 __ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 7 # Exec time 2 880us 28us 362us 125us 348us 139us 33us # Lock time 2 203us 0 106us 29us 103us 44us 0 # Rows sent 0 16 0 4 2.29 3.89 1.92 3.89 # Rows examine 0 12 0 9 1.71 8.91 3.12 0 # Merge passes 0 0 0 0 0 0 0 0 # Query size 8 6.75k 987 987 987 987 0 987 # Boolean: # Full join 100% yes, 0% no # Full scan 100% yes, 0% no # QC hit 71% yes, 28% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ######################### # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_assignments'\G # SHOW CREATE TABLE `mw1`.`cn_assignments`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_templates'\G # SHOW CREATE TABLE `mw1`.`cn_templates`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_projects'\G # SHOW CREATE TABLE `mw1`.`cn_notice_projects`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_languages'\G # SHOW CREATE TABLE `mw1`.`cn_notice_languages`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* ChoiceDataProvider::getChoices */ notices.not_id,notices.not_name,notices.not_start,notices.not_end,notices.not_preferred,notices.not_throttle,notices.not_geo,notices.not_buckets,assignments.tmp_weight,assignments.asn_bucket,templates.tmp_id,templates.tmp_name,templates.tmp_display_anon,templates.tmp_display_account,templates.tmp_category FROM `cn_notices` `notices` INNER JOIN `cn_assignments` `assignments` ON ((notices.not_id = assignments.not_id)) INNER JOIN `cn_templates` `templates` ON ((assignments.tmp_id = templates.tmp_id)) INNER JOIN `cn_notice_projects` `notice_projects` ON ((notices.not_id = notice_projects.np_notice_id)) INNER JOIN `cn_notice_languages` `notice_languages` ON ((notices.not_id = notice_languages.nl_notice_id)) WHERE (notices.not_start <= '20160311024202') AND (notices.not_end >= '20160311024202') AND notices.not_enabled = '1' AND notices.not_archived = '0' AND notice_projects.np_project = 'mw1' AND notice_languages.nl_language = 'en'\G # Query 13: 0 QPS, 0x concurrency, ID 0x407FBEA83325982D at byte 58272 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 6 20 # Exec time 2 811us 23us 126us 40us 66us 21us 35us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 1 960 48 48 48 48 0 48 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ### # 1ms # 10ms # 100ms # 1s # 10s+ SET group_concat_max_len = 262144, sql_mode = ''\G # Query 14: 0 QPS, 0x concurrency, ID 0xC9AFA2C0D78AD345 at byte 134794 __ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 4 # Exec time 2 809us 13us 761us 202us 725us 307us 372us # Lock time 1 96us 0 96us 24us 93us 40us 0 # Rows sent 1 40 10 10 10 10 0 10 # Rows examine 0 5 0 5 1.25 4.96 2.15 0 # Merge passes 0 0 0 0 0 0 0 0 # Query size 1 1.14k 291 291 291 291 0 291 # Boolean: # Full join 100% yes, 0% no # Full scan 100% yes, 0% no # QC hit 75% yes, 25% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ##################### # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_template_devices'\G # SHOW CREATE TABLE `mw1`.`cn_template_devices`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_known_devices'\G # SHOW CREATE TABLE `mw1`.`cn_known_devices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* ChoiceDataProvider::getChoices */ template_devices.tmp_id,known_devices.dev_name FROM `cn_template_devices` `template_devices` INNER JOIN `cn_known_devices` `known_devices` ON ((template_devices.dev_id = known_devices.dev_id)) WHERE template_devices.tmp_id IN ('1','2','4','3')\G # Query 15: 0 QPS, 0x concurrency, ID 0x10806A876ECCC9F8 at byte 64757 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 10 # Exec time 2 700us 12us 202us 70us 138us 57us 80us # Lock time 2 222us 0 77us 22us 47us 25us 30us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 2 1.77k 181 182 181.40 174.84 0 174.84 # Boolean: # QC hit 50% yes, 50% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'page'\G # SHOW CREATE TABLE `mw1`.`page`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* LinkCache::addLinkObj */ page_id,page_len,page_is_redirect,page_latest,page_content_model FROM `page` WHERE page_namespace = '8' AND page_title = 'Common.js' LIMIT 1\G # Query 16: 0 QPS, 0x concurrency, ID 0x9273875715F8D8A1 at byte 86524 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 6 # Exec time 1 563us 55us 126us 93us 125us 29us 119us # Lock time 2 225us 20us 52us 37us 49us 12us 46us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 1 18 3 3 3 3 0 3 # Query size 0 608 99 103 101.33 102.22 2 97.36 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'Admin'\G # SHOW CREATE TABLE `mw1`.`Admin`\G UPDATE /* DatabaseBase::update Admin */ `cn_notices` SET not_locked = '0' WHERE not_name = 'Test1'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select not_locked = '0' from /* DatabaseBase::update Admin */ `cn_notices` where not_name = 'Test1'\G # Query 17: 0 QPS, 0x concurrency, ID 0xE4BDA3F9F78A0569 at byte 89100 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 6 # Exec time 1 530us 38us 214us 88us 204us 58us 93us # Lock time 1 146us 13us 39us 24us 38us 9us 30us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 1 18 3 3 3 3 0 3 # Query size 0 614 100 104 102.33 102.22 2 102.22 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'Admin'\G # SHOW CREATE TABLE `mw1`.`Admin`\G UPDATE /* DatabaseBase::update Admin */ `cn_notices` SET not_enabled = '1' WHERE not_name = 'foo*test'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select not_enabled = '1' from /* DatabaseBase::update Admin */ `cn_notices` where not_name = 'foo*test'\G # Query 18: 0 QPS, 0x concurrency, ID 0x425AAC533BEFEF74 at byte 85684 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 8 # Exec time 1 501us 7us 144us 62us 138us 45us 73us # Lock time 2 210us 0 78us 26us 76us 25us 21us # Rows sent 1 24 3 3 3 3 0 3 # Rows examine 1 15 0 3 1.88 2.90 1.41 2.90 # Merge passes 0 0 0 0 0 0 0 0 # Query size 0 616 77 77 77 77 0 77 # Boolean: # Full scan 100% yes, 0% no # QC hit 37% yes, 62% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ########################################## # 10us ################################################################ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* Campaign::getAllCampaignNames Admin */ not_name FROM `cn_notices`\G # Query 19: 0 QPS, 0x concurrency, ID 0xE8549377A8C0C1D3 at byte 117252 __ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 1 438us 35us 403us 219us 403us 260us 219us # Lock time 1 85us 0 85us 42us 85us 60us 42us # Rows sent 0 6 3 3 3 3 0 3 # Rows examine 28 418 0 418 209 418 295.57 209 # Merge passes 0 0 0 0 0 0 0 0 # Query size 1 1.23k 630 630 630 630 0 630 # Boolean: # Full scan 100% yes, 0% no # QC hit 50% yes, 50% no # Tmp table 100% yes, 0% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_countries'\G # SHOW CREATE TABLE `mw1`.`cn_notice_countries`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_languages'\G # SHOW CREATE TABLE `mw1`.`cn_notice_languages`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_projects'\G # SHOW CREATE TABLE `mw1`.`cn_notice_projects`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* IndexPager::buildQueryInfo (CNCampaignPager) Admin */ notices.not_id,not_name,not_start,not_end,not_enabled,not_preferred,not_throttle,not_geo,not_locked,not_archived,(SELECT GROUP_CONCAT(nc_country SEPARATOR ',') FROM `cn_notice_countries` WHERE nc_notice_id = notices.not_id ) AS countries,(SELECT GROUP_CONCAT(nl_language SEPARATOR ',') FROM `cn_notice_languages` WHERE nl_notice_id = notices.not_id ) AS languages,(SELECT GROUP_CONCAT(np_project SEPARATOR ',') FROM `cn_notice_projects` WHERE np_notice_id = notices.not_id ) AS projects FROM `cn_notices` `notices` ORDER BY not_id DESC LIMIT 5001\G # Query 20: 0 QPS, 0x concurrency, ID 0xFD2F0603A3CAE705 at byte 51273 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 8 # Exec time 1 432us 24us 220us 54us 214us 62us 25us # Lock time 0 73us 0 73us 9us 69us 23us 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 2 2.33k 270 377 298 363.48 43.99 271.23 # Boolean: # QC hit 87% yes, 12% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ######### # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'page'\G # SHOW CREATE TABLE `mw1`.`page`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'revision'\G # SHOW CREATE TABLE `mw1`.`revision`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* ResourceLoaderWikiModule::getTitleInfo */ page_namespace,page_title,rev_len,rev_sha1 FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id)) WHERE (page_namespace = '8' AND page_title IN ('Common.js','Vector.js','Common.css','Vector.css','Print.css') )\G # Query 21: 0 QPS, 0x concurrency, ID 0xD33671F9FE962A9D at byte 2694 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 12 # Exec time 1 394us 5us 167us 32us 54us 42us 11us # Lock time 0 46us 0 18us 3us 13us 6us 0 # Rows sent 79 1.59k 1 406 136 400.73 188.44 0.99 # Rows examine 27 408 0 406 34 0.99 110.71 0 # Query size 1 1.25k 107 107 107 107 0 107 # Boolean: # QC hit 75% yes, 25% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################################################################ # 10us ##################################################### # 100us ########## # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_languages'\G # SHOW CREATE TABLE `mw1`.`cn_notice_languages`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* DatabaseBase::select Admin */ nl_language FROM `cn_notice_languages` WHERE nl_notice_id = '1'\G # Query 22: 0 QPS, 0x concurrency, ID 0x074589206E4C2D0C at byte 36101 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 0 333us 36us 297us 166us 297us 184us 166us # Lock time 0 70us 0 70us 35us 70us 49us 35us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Merge passes 0 0 0 0 0 0 0 0 # Query size 0 848 424 424 424 424 0 424 # Boolean: # Full scan 100% yes, 0% no # QC hit 50% yes, 50% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'job'\G # SHOW CREATE TABLE `mw1`.`job`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* JobQueueDB::doGetSiblingQueuesWithJobs Admin */ DISTINCT job_cmd FROM `job` WHERE job_cmd IN ('refreshLinks','deleteLinks','htmlCacheUpdate','sendMail','enotifNotify','fixDoubleRedirect','uploadFromUrl','AssembleUploadChunks','PublishStashedFile','ThumbnailRender','recentChangesUpdate','refreshLinksPrioritized','refreshLinksDynamic','activityUpdateJob','categoryMembershipChange','cdnPurge','enqueue','null')\G # Query 23: 0 QPS, 0x concurrency, ID 0xEEFFDFD47840839B at byte 3279 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 12 # Exec time 0 333us 7us 111us 27us 63us 29us 14us # Lock time 0 63us 0 33us 5us 17us 9us 0 # Rows sent 0 12 0 3 1 2.90 1.37 0 # Rows examine 0 3 0 3 0.25 0 0.80 0 # Query size 1 1.24k 106 106 106 106 0 106 # Boolean: # QC hit 75% yes, 25% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ##################################################### # 10us ################################################################ # 100us ########## # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_countries'\G # SHOW CREATE TABLE `mw1`.`cn_notice_countries`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* DatabaseBase::select Admin */ nc_country FROM `cn_notice_countries` WHERE nc_notice_id = '1'\G # Query 24: 0 QPS, 0x concurrency, ID 0xFF2878F771226A9B at byte 51727 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 6 # Exec time 0 304us 9us 107us 50us 103us 36us 67us # Lock time 1 80us 0 43us 13us 42us 18us 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 1 1.29k 219 224 220.67 223.14 2.50 212.52 # Boolean: # QC hit 66% yes, 33% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################ # 10us ################################################################ # 100us ################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'page'\G # SHOW CREATE TABLE `mw1`.`page`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'revision'\G # SHOW CREATE TABLE `mw1`.`revision`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* ResourceLoaderWikiModule::getTitleInfo */ page_namespace,page_title,rev_len,rev_sha1 FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id)) WHERE (page_namespace = '8' AND page_title = 'Noscript.css')\G # Query 25: 0 QPS, 0x concurrency, ID 0x9B8C934C449AB5B6 at byte 2115 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 12 # Exec time 0 293us 5us 73us 24us 57us 22us 9us # Lock time 0 48us 0 19us 4us 14us 6us 0 # Rows sent 0 16 1 2 1.33 1.96 0.46 0.99 # Rows examine 0 4 0 2 0.33 0.99 0.61 0 # Query size 1 1.23k 105 105 105 105 0 105 # Boolean: # QC hit 75% yes, 25% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################################################################ # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_projects'\G # SHOW CREATE TABLE `mw1`.`cn_notice_projects`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* DatabaseBase::select Admin */ np_project FROM `cn_notice_projects` WHERE np_notice_id = '1'\G # Query 26: 0 QPS, 0x concurrency, ID 0x3AE84F0689E8B71E at byte 42915 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 0 276us 42us 234us 138us 234us 135us 138us # Lock time 1 111us 0 111us 55us 111us 78us 55us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 284 142 142 142 142 0 142 # Boolean: # QC hit 50% yes, 50% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'module_deps'\G # SHOW CREATE TABLE `mw1`.`module_deps`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* ResourceLoader::preloadModuleInfo */ md_module,md_deps FROM `module_deps` WHERE md_module = 'startup' AND md_skin = 'vector|en'\G # Query 27: 0 QPS, 0x concurrency, ID 0x2342554AF88317C9 at byte 145920 __ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 6 22 # Exec time 0 259us 4us 38us 11us 23us 8us 8us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 1 1.52k 68 84 70.55 76.28 4.81 65.89 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################################################################ # 10us ############################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo) */\G # Query 28: 0 QPS, 0x concurrency, ID 0xF00C39C65E3E24D0 at byte 91995 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 4 # Exec time 0 244us 36us 92us 61us 89us 24us 82us # Lock time 1 90us 12us 35us 22us 33us 9us 31us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 12 3 3 3 3 0 3 # Query size 0 414 102 105 103.50 102.22 1.50 102.22 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'Admin'\G # SHOW CREATE TABLE `mw1`.`Admin`\G UPDATE /* DatabaseBase::update Admin */ `cn_notices` SET not_preferred = '1' WHERE not_name = 'Test1'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select not_preferred = '1' from /* DatabaseBase::update Admin */ `cn_notices` where not_name = 'Test1'\G # Query 29: 0 QPS, 0x concurrency, ID 0x9B8F20D4EDCA1899 at byte 133496 __ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 4 # Exec time 0 201us 17us 120us 50us 119us 41us 82us # Lock time 0 45us 0 45us 11us 44us 19us 0 # Rows sent 0 12 3 3 3 3 0 3 # Rows examine 0 3 0 3 0.75 2.90 1.26 0 # Query size 1 1.08k 277 277 277 277 0 277 # Boolean: # QC hit 75% yes, 25% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ##################### # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notice_countries'\G # SHOW CREATE TABLE `mw1`.`cn_notice_countries`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* ChoiceDataProvider::getChoices */ notices.not_id,notice_countries.nc_country FROM `cn_notices` `notices` INNER JOIN `cn_notice_countries` `notice_countries` ON ((notices.not_id = notice_countries.nc_notice_id)) WHERE notices.not_geo = '1' AND notices.not_id = '1'\G # Query 30: 0 QPS, 0x concurrency, ID 0xC4EFE8926FEEC5DB at byte 97187 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 0 199us 75us 124us 99us 124us 34us 99us # Lock time 0 78us 29us 49us 39us 49us 14us 39us # Rows sent 0 2 1 1 1 1 0 1 # Rows examine 0 2 1 1 1 1 0 1 # Query size 0 202 101 101 101 101 0 101 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'cn_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* DatabaseBase::selectRow Admin */ not_name FROM `cn_notices` WHERE not_id = '1' LIMIT 1\G # Query 31: 0 QPS, 0x concurrency, ID 0x44AE35A182869033 at byte 58056 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 5 19 # Exec time 0 111us 2us 24us 5us 8us 4us 4us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 600 30 30 30 30 0 30 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################################################################ # 10us ### # 100us # 1ms # 10ms # 100ms # 1s # 10s+ administrator command: Init DB\G # Query 32: 0 QPS, 0x concurrency, ID 0x120266EA18C29BB8 at byte 118213 __ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 0 51us 24us 27us 25us 27us 2us 25us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 556 278 278 278 278 0 278 # Boolean: # QC hit 100% yes, 0% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'page'\G # SHOW CREATE TABLE `mw1`.`page`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) Admin */ page_id,page_namespace,page_title,page_len,page_is_redirect,page_latest,page_content_model FROM `page` WHERE (page_namespace = '2' AND page_title = 'Admin') OR (page_namespace = '3' AND page_title = 'Admin')\G # Query 33: 0 QPS, 0x concurrency, ID 0x40FB12E0241B130A at byte 118676 __ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 0 33us 11us 22us 16us 22us 7us 16us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 196 98 98 98 98 0 98 # Boolean: # QC hit 100% yes, 0% no # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mw1` LIKE 'user_newtalk'\G # SHOW CREATE TABLE `mw1`.`user_newtalk`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* User::checkNewtalk Admin */ user_id FROM `user_newtalk` WHERE user_id = '1' LIMIT 1\G # Query 34: 0 QPS, 0x concurrency, ID 0xAA353644DE4C4CB4 at byte 120390 __ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 5 18 # Exec time 0 22us 1us 4us 1us 1us 0 1us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 486 27 27 27 27 0 27 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################################################################ # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ administrator command: Quit\G # Query 35: 0 QPS, 0x concurrency, ID 0x836A6EA883156E9D at byte 37301 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-10 21:41:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 0 17us 7us 10us 8us 10us 2us 8us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 144 72 72 72 72 0 72 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################################################################ # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ SET /* DatabaseBase::query Admin */ SESSION group_concat_max_len = 10000\G