# 190ms user time, 40ms system time, 35.21M rss, 100.55M vsz # Current date: Wed Mar 16 20:59:35 2016 # Hostname: laptop # Files: cn-patched-write-local-slow.log # Overall: 55 total, 18 unique, 0 QPS, 0x concurrency ____________________ # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 15ms 1us 9ms 274us 403us 1ms 63us # Lock time 2ms 0 333us 39us 152us 57us 22us # Rows sent 894 0 406 16.25 11.95 74.78 0.99 # Rows examine 156 0 24 2.84 17.65 6.03 0.99 # Merge passes 0 0 0 0 0 0 0 # Query size 16.02k 27 5.81k 298.24 563.87 780.92 102.22 # Boolean: # Full join 23% yes, 76% no # Full scan 100% yes, 0% no # QC hit 27% yes, 72% no # Tmp table 7% yes, 92% no # Tmp table on 7% yes, 92% no # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== ============= ===== ====== ===== =============== # 1 0x9617DE062D3FFA8D 0.0090 59.4% 1 0.0090 0.00 COMMIT # 2 0x53B3FBBD50DD87AD 0.0014 9.3% 14 0.0001 0.00 SELECT cn_notices # 3 0x122EF9E3168F0E18 0.0010 6.5% 4 0.0002 0.00 SELECT cn_notices cn_notice_mixins cn_notice_mixin_params # 4 0xE537093C9B8035CC 0.0009 6.2% 2 0.0005 0.00 SHOW COLUMNS # 5 0xC88483FE5B167171 0.0009 5.7% 4 0.0002 0.00 SELECT cn_notices cn_template_devices # 6 0x5D1C393D8BEFBE08 0.0005 3.5% 2 0.0003 0.00 INSERT cn_notice_log # 7 0x09892531791300C6 0.0005 3.0% 4 0.0001 0.00 SELECT cn_notices # 8 0xE4BDA3F9F78A0569 0.0003 1.9% 2 0.0001 0.00 UPDATE Admin # 9 0xC4EFE8926FEEC5DB 0.0002 1.5% 2 0.0001 0.00 SELECT cn_notices # 10 0xC12907541AA5D9C1 0.0001 0.8% 2 0.0001 0.00 SELECT cn_notices # 11 0x9B8C934C449AB5B6 0.0001 0.7% 4 0.0000 0.00 SELECT cn_notice_projects # 12 0xEEFFDFD47840839B 0.0001 0.5% 4 0.0000 0.00 SELECT cn_notice_countries # 13 0x074589206E4C2D0C 0.0000 0.3% 1 0.0000 0.00 SELECT job # 14 0xD33671F9FE962A9D 0.0000 0.2% 4 0.0000 0.00 SELECT cn_notice_languages # 15 0x407FBEA83325982D 0.0000 0.2% 1 0.0000 0.00 SET # 16 0x2342554AF88317C9 0.0000 0.2% 2 0.0000 0.00 BEGIN # 17 0x44AE35A182869033 0.0000 0.0% 1 0.0000 0.00 ADMIN INIT DB # 18 0xAA353644DE4C4CB4 0.0000 0.0% 1 0.0000 0.00 ADMIN QUIT # Query 1: 0 QPS, 0x concurrency, ID 0x9617DE062D3FFA8D at byte 29039 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 59 9ms 9ms 9ms 9ms 9ms 0 9ms # 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 45 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 2: 0 QPS, 0x concurrency, ID 0x53B3FBBD50DD87AD at byte 19299 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 25 14 # Exec time 9 1ms 7us 392us 100us 214us 95us 63us # Lock time 27 602us 0 156us 43us 108us 40us 33us # Rows sent 1 14 1 1 1 1 0 1 # Rows examine 10 17 0 2 1.21 1.96 0.66 0.99 # Merge passes 0 0 0 0 0 0 0 0 # Query size 9 1.46k 105 108 106.50 107.34 1.50 107.34 # Boolean: # Full scan 100% yes, 0% no # QC hit 14% yes, 85% 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 3: 0 QPS, 0x concurrency, ID 0x122EF9E3168F0E18 at byte 8998 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 4 # Exec time 6 982us 136us 490us 245us 467us 134us 321us # Lock time 11 256us 36us 127us 64us 125us 36us 89us # Rows sent 2 24 0 12 6 11.95 5.97 11.95 # Rows examine 46 72 18 18 18 18 0 18 # Merge passes 0 0 0 0 0 0 0 0 # Query size 12 2.00k 511 514 512.50 511.45 1.50 511.45 # Boolean: # Full join 100% yes, 0% no # Full scan 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_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 = 'foo*test' AND notice_mixins.nmxn_enabled = '1'\G # Query 4: 0 QPS, 0x concurrency, ID 0xE537093C9B8035CC at byte 22490 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 6 940us 283us 657us 470us 657us 264us 470us # Lock time 23 513us 180us 333us 256us 333us 108us 256us # Rows sent 0 2 1 1 1 1 0 1 # Rows examine 1 2 1 1 1 1 0 1 # Merge passes 0 0 0 0 0 0 0 0 # Query size 1 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 5: 0 QPS, 0x concurrency, ID 0xC88483FE5B167171 at byte 20023 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 4 # Exec time 5 857us 162us 300us 214us 287us 52us 255us # Lock time 9 213us 46us 73us 53us 69us 10us 58us # Rows sent 2 20 0 10 5 9.83 4.91 9.83 # Rows examine 30 48 0 24 12 23.65 11.83 23.65 # Merge passes 0 0 0 0 0 0 0 0 # Query size 14 2.25k 576 576 576 576 0 576 # Boolean: # Full join 100% yes, 0% no # Full scan 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_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 6: 0 QPS, 0x concurrency, ID 0x5D1C393D8BEFBE08 at byte 22907 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 3 531us 125us 406us 265us 406us 198us 265us # Lock time 9 207us 50us 157us 103us 157us 75us 103us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 42 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 ('20160317002758','1','modified','1','Test1','','20150302215300','20160519225300','0','3','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','3','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 7: 0 QPS, 0x concurrency, ID 0x09892531791300C6 at byte 5504 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 4 # Exec time 3 454us 56us 181us 113us 176us 51us 160us # Lock time 7 169us 21us 63us 42us 60us 18us 58us # Rows sent 0 4 1 1 1 1 0 1 # Rows examine 3 6 1 2 1.50 1.96 0.49 1.96 # Merge passes 0 0 0 0 0 0 0 0 # Query size 5 894 222 225 223.50 223.14 1.50 223.14 # Boolean: # Full scan 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_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 = 'foo*test' LIMIT 1\G # Query 8: 0 QPS, 0x concurrency, ID 0xE4BDA3F9F78A0569 at byte 5217 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 1 294us 57us 237us 147us 237us 127us 147us # Lock time 4 95us 20us 75us 47us 75us 38us 47us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 3 6 3 3 3 3 0 3 # Query size 1 203 100 103 101.50 103 2.12 101.50 # 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 9: 0 QPS, 0x concurrency, ID 0xC4EFE8926FEEC5DB at byte 22205 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 1 220us 50us 170us 110us 170us 84us 110us # Lock time 4 90us 19us 71us 45us 71us 36us 45us # Rows sent 0 2 1 1 1 1 0 1 # Rows examine 1 2 1 1 1 1 0 1 # Query size 1 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 10: 0 QPS, 0x concurrency, ID 0xC12907541AA5D9C1 at byte 4779 ____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 0 121us 47us 74us 60us 74us 19us 60us # Lock time 1 43us 18us 25us 21us 25us 4us 21us # Rows sent 0 2 1 1 1 1 0 1 # Rows examine 1 3 1 2 1.50 2 0.71 1.50 # Merge passes 0 0 0 0 0 0 0 0 # Query size 1 217 107 110 108.50 110 2.12 108.50 # Boolean: # Full scan 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_notices'\G # SHOW CREATE TABLE `mw1`.`cn_notices`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT /* DatabaseBase::selectRow Admin */ not_name FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1\G # Query 11: 0 QPS, 0x concurrency, ID 0x9B8C934C449AB5B6 at byte 18282 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 4 # Exec time 0 111us 27us 29us 27us 28us 1us 28us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 6 1 2 1.50 1.96 0.49 1.96 # Rows examine 0 0 0 0 0 0 0 0 # Query size 2 420 105 105 105 105 0 105 # 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 '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 12: 0 QPS, 0x concurrency, ID 0xEEFFDFD47840839B at byte 19732 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 4 # Exec time 0 79us 9us 48us 19us 47us 16us 10us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 6 0 3 1.50 2.90 1.45 2.90 # Rows examine 0 0 0 0 0 0 0 0 # Query size 2 424 106 106 106 106 0 106 # 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 '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 13: 0 QPS, 0x concurrency, ID 0x074589206E4C2D0C at byte 29530 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 0 38us 38us 38us 38us 38us 0 38us # 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 2 408 408 408 408 408 0 408 # 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 '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','AssembleUploadChunks','PublishStashedFile','ThumbnailRender','recentChangesUpdate','refreshLinksPrioritized','refreshLinksDynamic','activityUpdateJob','categoryMembershipChange','cdnPurge','enqueue','null')\G # Query 14: 0 QPS, 0x concurrency, ID 0xD33671F9FE962A9D at byte 19005 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 7 4 # Exec time 0 34us 7us 10us 8us 9us 1us 9us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 91 814 1 406 203.50 400.73 199.87 400.73 # Rows examine 0 0 0 0 0 0 0 0 # Query size 2 428 107 107 107 107 0 107 # 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 '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 15: 0 QPS, 0x concurrency, ID 0x407FBEA83325982D at byte 241 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 0 32us 32us 32us 32us 32us 0 32us # 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 48 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 16: 0 QPS, 0x concurrency, ID 0x2342554AF88317C9 at byte 29268 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 0 24us 6us 18us 12us 18us 8us 12us # 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 147 69 78 73.50 78 6.36 73.50 # String: # Databases mw1 # Hosts localhost # Users root # Query_time distribution # 1us ################################################################ # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ BEGIN /* DatabaseBase::query (JobQueueDB::doGetSiblingQueuesWithJobs) Admin */\G # Query 17: 0 QPS, 0x concurrency, ID 0x44AE35A182869033 at byte 0 _______ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 0 5us 5us 5us 5us 5us 0 5us # 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 30 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 18: 0 QPS, 0x concurrency, ID 0xAA353644DE4C4CB4 at byte 30123 ___ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2016-03-16 20:27:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 0 1us 1us 1us 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 27 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