Benchmark result on isu3(7,776)

[github-actions[bot]]

COUNT	1XX	2XX	3XX	4XX	5XX	METHOD	URI	MIN	MAX	SUM	AVG	P90	P95	P99	STDDEV	MIN(BODY)	MAX(BODY)	SUM(BODY)	AVG(BODY)
4485	0	4482	0	3	0	GET	/api/user/[a-zA-Z0-9]+/icon	0.004	0.520	164.884	0.037	0.104	0.152	0.292	0.057	0.000	171652.000	244824621.000	54587.429
11	0	2	0	9	0	GET	/api/user/[a-zA-Z0-9]+/statistics	2.732	20.004	153.508	13.955	20.000	20.004	20.004	7.087	0.000	139.000	272.000	24.727
26	0	24	0	2	0	POST	/api/livestream/[a-zA-Z0-9]+/moderate	0.288	8.900	107.012	4.116	4.780	6.836	8.900	1.393	0.000	23.000	552.000	21.231
436	0	434	0	2	0	GET	/api/livestream/[a-zA-Z0-9]+/livecomment	0.004	0.740	80.944	0.186	0.368	0.440	0.596	0.137	0.000	66359.000	7553346.000	17324.188
469	0	469	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+/reaction	0.004	0.680	76.508	0.163	0.356	0.444	0.544	0.137	3.000	61609.000	6909958.000	14733.386
490	0	487	0	3	0	POST	/api/livestream/[a-zA-Z0-9]+/livecomment	0.008	0.552	60.824	0.124	0.196	0.256	0.352	0.064	57.000	2701.000	971823.000	1983.312
278	0	274	0	3	1	POST	/api/register	0.004	0.840	58.052	0.209	0.308	0.376	0.488	0.092	0.000	513.000	128673.000	462.853
85	0	84	0	1	0	GET	/api/livestream/[a-zA-Z0-9]+$	0.004	1.860	45.256	0.532	1.136	1.428	1.860	0.354	0.000	135491.000	5801307.000	68250.671
99	0	95	0	4	0	POST	/api/livestream/[a-zA-Z0-9]+$	0.076	1.048	43.876	0.443	0.876	0.944	1.048	0.327	0.000	1469.000	107365.000	1084.495
408	0	407	0	1	0	POST	/api/livestream/[a-zA-Z0-9]+/reaction	0.004	0.488	25.932	0.064	0.136	0.176	0.324	0.063	0.000	2212.000	752160.000	1843.529
121	0	121	0	0	0	GET	/api/livestream$	0.012	0.584	14.740	0.122	0.212	0.268	0.480	0.088	3.000	22527.000	149164.000	1232.760
282	0	280	0	2	0	POST	/api/login	0.008	0.644	11.528	0.041	0.112	0.176	0.260	0.065	0.000	64.000	128.000	0.454
1	0	1	0	0	0	POST	/api/initialize	9.800	9.800	9.800	9.800	9.800	9.800	9.800	0.000	27.000	27.000	27.000	27.000
55	0	55	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+/ngwords	0.004	0.404	6.380	0.116	0.204	0.240	0.404	0.071	5.000	271.000	1075.000	19.545
89	0	89	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+/report	0.004	0.248	4.336	0.049	0.124	0.168	0.248	0.052	3.000	11229.000	41802.000	469.685
82	0	82	0	0	0	GET	/api/tag	0.004	0.228	4.036	0.049	0.124	0.164	0.228	0.052	6089.000	6095.000	499670.000	6093.537
46	0	45	0	1	0	POST	/api/livestream/[a-zA-Z0-9]+/enter	0.004	0.448	3.396	0.074	0.196	0.248	0.448	0.092	0.000	0.000	0.000	0.000
38	0	38	0	0	0	DELETE	/api/livestream/[a-zA-Z0-9]+/exit	0.004	0.224	1.536	0.040	0.108	0.144	0.224	0.048	0.000	0.000	0.000	0.000
275	0	275	0	0	0	POST	/api/icon	0.004	0.012	0.668	0.002	0.004	0.004	0.012	0.003	14.000	14.000	3850.000	14.000
10	0	10	0	0	0	GET	/api/user/[a-zA-Z0-9]+/theme	0.004	0.020	0.084	0.008	0.016	0.020	0.020	0.006	38.000	38.000	380.000	38.000
2	0	2	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+/statistics	0.020	0.020	0.040	0.020	0.020	0.020	0.020	0.000	100.000	102.000	202.000	101.000
4	0	4	0	0	0	GET	/api/user/[a-zA-Z0-9]+$	0.000	0.004	0.004	0.001	0.004	0.004	0.004	0.002	235.000	247.000	964.000	241.000
1	0	1	0	0	0	GET	/api/payment	0.004	0.004	0.004	0.004	0.004	0.004	0.004	0.000	21.000	21.000	21.000	21.000

[github-actions[bot]]

Reading from STDIN ...

# 29s user time, 140ms system time, 35.72M rss, 42.34M vsz
# Current date: Sat Nov 25 06:13:01 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 468.83k total, 89 unique, 2.69k QPS, 2.39x concurrency ________
# Time range: 2023-11-25T06:09:45 to 2023-11-25T06:12:39
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           416s     1us   358ms   887us     3ms     4ms    76us
# Lock time          626ms       0    29ms     1us     1us    81us       0
# Rows sent        413.39k       0   7.41k    0.90    1.96   52.45       0
# Rows examine      55.29M       0  17.60k  123.66   1.20k  742.04       0
# Query size        31.87M       5   1.94M   71.28  313.99   3.02k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0x42EF7D7D98FBCC9723BF896EBFC51D24 54.0676 13.0%   6231 0.0087  0.01 SELECT records
#    2 0xDA556F9115773A1A99AA0165670CE848 52.8298 12.7% 137028 0.0004  0.01 ADMIN PREPARE
#    3 0xF1B8EF06D6CA63B24BFF433E06CCEB22 52.1180 12.5%   4939 0.0106  0.01 SELECT users livestreams livecomments
#    4 0xDB74D52D39A7090F224C4DEEAF3028C9 49.1651 11.8%   4942 0.0099  0.01 SELECT users livestreams reactions
#    5 0x3D83BC87F3B3A00D571FFC8104A6E50C 33.2936  8.0%   4872 0.0068  0.01 SELECT records
#    6 0x64CC8A4E8E4B390203375597CE4D611F 22.3436  5.4%    439 0.0509  0.01 SELECT ng_words
#    7 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 18.9371  4.6%    793 0.0239  0.01 SELECT reservation_slots
#    8 0x4ADE2DC90689F1C4891749AF54FB8D14 17.3841  4.2%  34592 0.0005  0.00 DELETE SELECT livecomments
#    9 0x38BC86A45F31C6B1EE324671506C898A 15.1135  3.6%  22034 0.0007  0.00 SELECT themes
#   10 0xFFFCA4D67EA0A788813031B8BBC3B329 11.3305  2.7%   3302 0.0034  0.00 COMMIT
#   11 0xEA1E6309EEEFF9A6831AD2FB940FC23C  7.9638  1.9%  21749 0.0004  0.00 SELECT users
#   12 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  6.9136  1.7%    123 0.0562  0.01 SELECT livestreams
#   13 0x22279D81D51006139E0C76405B54C261  6.8066  1.6%   7120 0.0010  0.00 SELECT domains domainmetadata
#   14 0xF7144185D9A142A426A36DC55C1D2623  6.3961  1.5%  13595 0.0005  0.00 SELECT livestream_tags
#   15 0x859BBB7E9D760686137A944406874C4D  5.6200  1.4%    276 0.0204  0.01 DELETE records
#   16 0x8F7679D452333ED3C7D60D22131CEFD4  5.2817  1.3%  19571 0.0003  0.00 ADMIN RESET STMT
#   17 0x55C45664C0A27CA4AF92DD1D2D0ABDAA  5.2161  1.3%  12915 0.0004  0.00 SELECT tags
#   18 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  4.9851  1.2%     95 0.0525  0.03 UPDATE reservation_slots
#   19 0x7F9C0C0BA9473953B723EE16C08655F1  4.3609  1.0%     97 0.0450  0.02 SELECT reservation_slots
#   20 0xD2A0864774622BA36F6557496405CF75  3.8879  0.9%   1276 0.0030  0.00 INSERT themes
#   21 0xDFFCC1D78939C4D781C7C58349101F50  3.8066  0.9%   1000 0.0038  0.00 INSERT users
#   22 0xD6032FE08E1FE706A928B8B7CBA06B85  3.8020  0.9%  10673 0.0004  0.00 SELECT livestreams
#   23 0x9AC623FA477E73A44D191D296850A025  3.3158  0.8%    552 0.0060  0.01 SELECT records
#   24 0xEDE18C1523658A19E07525EAFCBA6BFE  3.2309  0.8%     55 0.0587  0.01 SELECT ng_words
#   25 0xE4555A2709C09FD9BFF6688D80B0AA49  2.9415  0.7%     22 0.1337  0.02 SELECT livestreams reactions livecomments
#   26 0x3F155F5E71EFF856F0CF7B8430DE8C23  1.7597  0.4%   4786 0.0004  0.00 SELECT users
#   27 0x07890000813C4CC7111FD2D3F3B3B4EB  1.6427  0.4% 137005 0.0000  0.00 ADMIN CLOSE STMT
#   28 0xFFF66E9B3D962FA319C8068B5C1997CD  1.5295  0.4%   4504 0.0003  0.00 ROLLBACK
#   29 0xB08B7B7486D2DFE2F2FE9CE78689FD79  1.5157  0.4%     26 0.0583  0.01 SELECT ng_words
#   30 0xAD0C28443E1E5CFAFF1569DBB4F7E63A  1.3067  0.3%    426 0.0031  0.00 SELECT reactions
#   31 0xB78E63D0D9C72DDDAB7A3E53517FA04C  1.2813  0.3%    391 0.0033  0.00 SELECT livecomments
#   32 0x9E2DA589A20EC24C34E11DDE0FBF5564  1.1523  0.3%   7543 0.0002  0.00 START
#   33 0x77FB9E134D073862D1E78FEEC3436291  0.4297  0.1%   1556 0.0003  0.00 INSERT records
#   34 0x98F959E03B684A5538FD8402A0EE94AD  0.3763  0.1%    103 0.0037  0.00 INSERT tags
#   35 0x02B6A87E51A5A1B7646675DB67C57DE3  0.3358  0.1%      1 0.3358  0.00 INSERT ng_words
#   36 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.3143  0.1%    438 0.0007  0.00 INSERT livecomments
#   37 0x80E10371CE74ED05E09C79C72C73F8E1  0.2878  0.1%     96 0.0030  0.18 INSERT livestreams
#   38 0x41F805E95754958A974F41AE07BEA625  0.2789  0.1%     29 0.0096  0.00 SELECT livecomments
#   39 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.2734  0.1%     22 0.0124  0.00 INSERT livestream_tags
#   40 0x651E3772B8767A368CB47EE7389EEB33  0.2678  0.1%     18 0.0149  0.01 SELECT livestream_tags
#   41 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.2129  0.1%    554 0.0004  0.01 SET
#   42 0x5AEB6E4A781A3854CF642125E293FEE0  0.2077  0.0%    407 0.0005  0.00 INSERT reactions
#   43 0x64052B1C32B30DF53AB3292208B783B4  0.1799  0.0%    277 0.0006  0.00 INSERT users
#   44 0x5D469B53C536D19CD15E40763ACC23C7  0.1607  0.0%    397 0.0004  0.00 INSERT livestream_tags
#   45 0xE64D50F7AFC1AD5F465809A92DF4935E  0.1369  0.0%     43 0.0032  0.00 SELECT reactions
#   46 0xEE4C51AE2BF74414C4892CBE11E894AA  0.1303  0.0%     44 0.0030  0.00 SELECT livecomments
#   47 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.1241  0.0%      1 0.1241  0.00 INSERT reservation_slots
#   48 0x19A1F14EFC0F221D30AFCB1E1344BEBD  0.0982  0.0%     11 0.0089  0.01 SELECT users
#   49 0x24C44C3518CE12293EF12410AEDA2393  0.0961  0.0%     67 0.0014  0.00 SELECT livestreams
#   50 0xE623383C5D789800DC0946925F90039F  0.0648  0.0%    277 0.0002  0.00 SELECT domains
#   51 0x4B6FA79E206C6CED71D433A2FC998D69  0.0644  0.0%    140 0.0005  0.00 SELECT
#   52 0x544239977D2094F805A7B062DE95673A  0.0506  0.0%     83 0.0006  0.00 SELECT tags
#   53 0x466EE4C87B17CAD4E692DE1D44EAD84D  0.0472  0.0%     89 0.0005  0.00 SELECT livecomment_reports
#   54 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0380  0.0%    115 0.0003  0.00 SELECT livecomments
#   55 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0373  0.0%    277 0.0001  0.00 BEGIN
#   56 0x08A6ACD83D579DD8A808134B32AD376B  0.0327  0.0%      1 0.0327  0.00 TRUNCATE TABLE livestream_tags
#   57 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0324  0.0%     22 0.0015  0.00 SELECT livestreams livecomments
#   58 0x9C697B3F0446BBF7602663588252F020  0.0320  0.0%      1 0.0320  0.00 TRUNCATE TABLE livestream_viewers_history
#   59 0xD2978B45C67B47B5D73AC532EB40A95E  0.0318  0.0%      1 0.0318  0.00 TRUNCATE TABLE themes
#   60 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0294  0.0%      1 0.0294  0.00 TRUNCATE TABLE users
#   61 0x07F6C3FF39ADD79FC63923A7EE938953  0.0292  0.0%      1 0.0292  0.00 INSERT livecomments
#   62 0x1FB70DBF74628C9F2E9F0C3478771936  0.0290  0.0%      1 0.0290  0.00 TRUNCATE TABLE ng_words
#   63 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0288  0.0%      1 0.0288  0.00 TRUNCATE TABLE livestreams
#   64 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0266  0.0%      1 0.0266  0.00 TRUNCATE TABLE reservation_slots
#   65 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0262  0.0%      1 0.0262  0.00 TRUNCATE TABLE tags
#   66 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0258  0.0%      1 0.0258  0.00 TRUNCATE TABLE reactions
#   67 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0244  0.0%      1 0.0244  0.00 TRUNCATE TABLE icons
#   68 0x2AAED5867123C749367FD8E4BBD796D2  0.0240  0.0%      1 0.0240  0.00 TRUNCATE TABLE livecomments
#   69 0x93A42F50BF286ACA749DF5F342FAC07B  0.0233  0.0%      1 0.0233  0.00 TRUNCATE TABLE livecomment_reports
#   70 0x74232BDFFB94C567F0340DBE3285E458  0.0209  0.0%      1 0.0209  0.00 INSERT reactions
#   71 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0183  0.0%     38 0.0005  0.00 DELETE livestream_viewers_history
#   72 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0169  0.0%     49 0.0003  0.00 INSERT livecomment_reports
#   73 0x8F885091E23CB955C051B1204EE7D91D  0.0162  0.0%     22 0.0007  0.00 SELECT livestreams reactions
#   74 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0153  0.0%     45 0.0003  0.00 INSERT livestream_viewers_history
#   75 0xB871CC5B0472067402F5739D108B2C1C  0.0102  0.0%     26 0.0004  0.00 SELECT livestreams
#   76 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0102  0.0%      1 0.0102  0.00 DELETE records
#   77 0x0C655718656DD9DDA39A0D11554A0C64  0.0073  0.0%     26 0.0003  0.00 INSERT ng_words
#   78 0x2B760561C10B5D133155AA306D0F407C  0.0069  0.0%     18 0.0004  0.00 SELECT livecomments
#   79 0x8B2044ADAE690405979131C33185F22A  0.0059  0.0%     10 0.0006  0.00 SELECT users
#   80 0x394E66DDE2823A903078D4C0F235B948  0.0041  0.0%     22 0.0002  0.00 SELECT livestreams livecomment_reports
#   81 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0031  0.0%     18 0.0002  0.00 SELECT tags
#   82 0xF985E5835B84E84C7A721801818E98CE  0.0026  0.0%      2 0.0013  0.00 SELECT users livestreams reactions
#   83 0xF085F31DC1964EA538732B713E4B4108  0.0026  0.0%     22 0.0001  0.00 SELECT livestreams livestream_viewers_history
#   84 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.0023  0.0%      2 0.0012  0.00 SELECT users livestreams reactions
#   85 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0011  0.0%     18 0.0001  0.00 SELECT livestream_viewers_history
#   86 0xEDBC971AEC392917AA353644DE4C4CB4  0.0011  0.0%    450 0.0000  0.00 ADMIN QUIT
#   87 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0007  0.0%      9 0.0001  0.00 SELECT
#   88 0xC4625761E0CFD817F41B4802F152A489  0.0006  0.0%      1 0.0006  0.00 SELECT livecomments
#   89 0xE84E602C0D0858D5661956B70D72A215  0.0002  0.0%      1 0.0002  0.00 SELECT icons

# Query 1: 75.07 QPS, 0.65x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 111078932
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:09:45 to 2023-11-25T06:11:08
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    6231
# Exec time     12     54s   716us    70ms     9ms    23ms     7ms     7ms
# Lock time      5    37ms       0     8ms     5us     1us   148us     1us
# Rows sent      0   1.95k       0       1    0.32    0.99    0.46       0
# Rows examine  15   8.45M   1.25k   1.52k   1.39k   1.46k   79.22   1.33k
# Query size     2 852.67k     129     215  140.13  158.58   10.90  136.99
# String:
# Databases    isudns
# Hosts        localhost
# Users        isudns
# Query_time distribution
#   1us
#  10us
# 100us  #
#   1ms  ################################################################
#  10ms  ####################################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isudns` LIKE 'records'\G
#    SHOW CREATE TABLE `isudns`.`records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name='0whqkt7kwpvx4au2yoep990.u.isucon.dev' and domain_id=2\G

# Query 2: 787.52 QPS, 0.30x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 17438974
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:09:45 to 2023-11-25T06:12:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         29  137028
# Exec time     12     53s    22us   358ms   385us     2ms     2ms    98us
# Lock time      0     4us       0     4us       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    12   3.92M      30      30      30      30       0      30
# String:
# Databases    isupipe (135359/98%), isudns (1669/1%)
# Hosts        localhost
# Users        isucon (135359/98%), isudns (1669/1%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  #########################################################
#   1ms  ############
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 3: 67.66 QPS, 0.71x concurrency, ID 0xF1B8EF06D6CA63B24BFF433E06CCEB22 at byte 92920201
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:09:55 to 2023-11-25T06:11:08
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    4939
# Exec time     12     52s     1ms    70ms    11ms    34ms    12ms     5ms
# Lock time      3    23ms       0     7ms     4us     1us   110us     1us
# Rows sent      1   4.82k       1       1       1       1       0       1
# Rows examine  18  10.45M   1.96k   2.73k   2.17k   2.62k  246.66   2.06k
# Query size     2 794.68k     163     166  164.76  158.58       0  158.58
# String:
# Databases    isupipe
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ################################################################
#  10ms  ###########################################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'users'\G
#    SHOW CREATE TABLE `isupipe`.`users`\G
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'livestreams'\G
#    SHOW CREATE TABLE `isupipe`.`livestreams`\G
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'livecomments'\G
#    SHOW CREATE TABLE `isupipe`.`livecomments`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT IFNULL(SUM(l2.tip), 0) FROM users u
        INNER JOIN livestreams l ON l.user_id = u.id    
        INNER JOIN livecomments l2 ON l2.livestream_id = l.id
        WHERE u.id = 302\G

# Query 4: 67.70 QPS, 0.67x concurrency, ID 0xDB74D52D39A7090F224C4DEEAF3028C9 at byte 93884097
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:09:55 to 2023-11-25T06:11:08
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    4942
# Exec time     11     49s     1ms    76ms    10ms    33ms    11ms     5ms
# Lock time      4    25ms       0    11ms     5us     1us   158us     1us
# Rows sent      1   4.83k       1       1       1       1       0       1
# Rows examine  18  10.44M   1.96k   2.69k   2.16k   2.62k  246.81   2.06k
# Query size     2 698.64k     143     146  144.76  143.84    0.96  143.84
# String:
# Databases    isupipe
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ################################################################
#  10ms  ########################################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'users'\G
#    SHOW CREATE TABLE `isupipe`.`users`\G
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'livestreams'\G
#    SHOW CREATE TABLE `isupipe`.`livestreams`\G
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'reactions'\G
#    SHOW CREATE TABLE `isupipe`.`reactions`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM users u
        INNER JOIN livestreams l ON l.user_id = u.id
        INNER JOIN reactions r ON r.livestream_id = l.id
        WHERE u.id = 309\G

# Query 5: 58.70 QPS, 0.40x concurrency, ID 0x3D83BC87F3B3A00D571FFC8104A6E50C at byte 77449248
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:09:45 to 2023-11-25T06:11:08
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    4872
# Exec time      8     33s   674us    69ms     7ms    20ms     7ms     4ms
# Lock time      6    39ms       0    12ms     8us     1us   191us     1us
# Rows sent      0   2.50k       0       1    0.52    0.99    0.50    0.99
# Rows examine  11   6.61M   1.25k   1.52k   1.39k   1.46k   79.35   1.33k
# Query size     1 636.01k     126     214  133.68  151.03   10.07  124.25
# String:
# Databases    isudns
# Hosts        localhost
# Users        isudns
# Query_time distribution
#   1us
#  10us
# 100us  ##
#   1ms  ################################################################
#  10ms  #######################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isudns` LIKE 'records'\G
#    SHOW CREATE TABLE `isudns`.`records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='itlih2oi4pu3ycm0q0.u.isucon.dev'\G