search

ushmz / isucon-utils

0 stars 1 forks source link

計測記録 #74

Closed ushmz closed 2 years ago

ushmz commented 2 years ago

alp\n\n\n### pt-query-digest\n```\n

A software update is available:

460ms user time, 170ms system time, 53.36M rss, 33.12G vsz

Current date: Wed Jul 20 17:10:27 2022

Hostname: kahma

Files: log/0720-170840/slow.log

Overall: 806 total, 9 unique, 0.00 QPS, 0.00x concurrency __

Time range: 2022-07-17 22:29:16 to 2022-07-20 17:04:58

Attribute total min max avg 95% stddev median

============ ======= ======= ======= ======= ======= ======= =======

Exec time 318s 100ms 1s 395ms 945ms 274ms 323ms

Lock time 179ms 0 50ms 222us 236us 2ms 125us

Rows sent 373.61k 0 19.35k 474.66 69.19 2.31k 0

Rows examine 745.89k 0 38.71k 947.64 130.47 4.62k 0

Rows affecte 12.37k 0 618 15.71 9.83 57.86 9.83

Bytes sent 64.44M 50 3.41M 81.86k 13.13k 410.41k 49.17

Query size 15.13M 50 790.36k 19.22k 1.86k 108.37k 1.53k

Profile

Rank Query ID Response time Calls R/Call V/M

==== =================================== ============== ===== ====== ===

1 0xB8B32624C3268C0925657C305C0ED778 303.7734 95.5% 727 0.4178 0.18 INSERT isu_condition

MISC 0xMISC 14.3006 4.5% 79 0.1810 0.0 <8 ITEMS>

Query 1: 0.00 QPS, 0.00x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 7926316

This item is included in the report because it matches --limit.

Scores: V/M = 0.18

Time range: 2022-07-17 22:29:50 to 2022-07-20 17:04:58

Attribute pct total min max avg 95% stddev median

============ === ======= ======= ======= ======= ======= ======= =======

Count 90 727

Exec time 95 304s 100ms 1s 418ms 1s 278ms 356ms

Lock time 68 123ms 42us 6ms 168us 236us 334us 131us

Rows sent 0 0 0 0 0 0 0 0

Rows examine 0 0 0 0 0 0 0 0

Rows affecte 57 7.07k 5 10 9.96 9.83 0.33 9.83

Bytes sent 0 36.74k 50 54 51.75 51.63 1.15 49.17

Query size 7 1.13M 912 2.05k 1.60k 1.78k 138.50 1.53k

String:

Databases isucondition

Hosts localhost

Users isucon

Query_time distribution

1us

10us

100us

1ms

10ms

100ms

1s

10s+

Tables

SHOW TABLE STATUS FROM isucondition LIKE 'isu_condition'\G

SHOW CREATE TABLE isucondition.isu_condition\G

INSERT INTO isu_condition (jia_isu_uuid, timestamp, is_sitting, condition, message) VALUES ('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:05:40', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:06:35', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:07:34', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:08:38', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:09:34', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:10:36', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:11:41', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:12:33', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:13:34', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？'),('a9ae05fb-876e-4879-84ac-257122dcc97a', '2021-08-30 14:14:34', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます？')\G \n```