search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu1(10083) #28

Open github-actions[bot] opened 11 months ago

github-actions[bot] commented 11 months ago
COUNT 1XX 2XX 3XX 4XX 5XX METHOD URI MIN MAX SUM AVG P90 P95 P99 STDDEV MIN(BODY) MAX(BODY) SUM(BODY) AVG(BODY)
5837 0 5833 0 4 0 GET /api/user/[a-zA-Z0-9]+/icon 0.000 0.516 173.135 0.030 0.076 0.120 0.236 0.046 40809.000 99502.000 314400146.000 53863.311
590 0 586 0 4 0 GET /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 1.004 132.301 0.224 0.468 0.560 0.708 0.171 0.000 70905.000 11596663.000 19655.361
25 0 22 0 3 0 POST /api/livestream/[a-zA-Z0-9]+/moderate 0.100 13.916 126.839 5.074 8.777 10.636 13.916 2.808 0.000 23.000 506.000 20.240
621 0 620 0 1 0 GET /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.832 121.377 0.195 0.424 0.528 0.724 0.165 0.000 66409.000 9978749.000 16068.839
654 0 649 0 5 0 POST /api/livestream/[a-zA-Z0-9]+/livecomment 0.008 0.448 82.788 0.127 0.192 0.228 0.304 0.055 0.000 2715.000 1278804.000 1955.358
297 0 294 0 2 1 POST /api/register 0.004 0.500 63.456 0.214 0.324 0.368 0.476 0.082 0.000 513.000 138004.000 464.660
108 0 105 0 3 0 POST /api/livestream/[a-zA-Z0-9]+$ 0.204 1.012 45.969 0.426 0.784 0.832 0.992 0.295 62.000 1466.000 118829.000 1100.269
66 0 65 0 1 0 GET /api/livestream/[a-zA-Z0-9]+$ 0.004 1.772 38.109 0.577 1.360 1.489 1.772 0.413 12700.000 130460.000 4653669.000 70510.136
547 0 547 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.452 35.836 0.066 0.144 0.196 0.268 0.057 1552.000 2209.000 1011026.000 1848.311
1 0 1 0 0 0 POST /api/initialize 15.420 15.420 15.420 15.420 15.420 15.420 15.420 0.000 27.000 27.000 27.000 27.000
302 0 300 0 2 0 POST /api/login 0.004 0.288 10.008 0.033 0.084 0.104 0.224 0.043 0.000 64.000 128.000 0.424
101 0 101 0 0 0 GET /api/livestream$ 0.012 0.328 9.052 0.090 0.160 0.184 0.260 0.058 3.000 22492.000 124798.000 1235.624
93 0 93 0 0 0 GET /api/tag 0.000 0.240 3.856 0.041 0.108 0.160 0.240 0.050 6089.000 6095.000 566655.000 6093.065
33 0 33 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/ngwords 0.004 0.308 3.032 0.092 0.176 0.224 0.308 0.062 5.000 140.000 432.000 13.091
11 0 11 0 0 0 GET /api/user/[a-zA-Z0-9]+/statistics 0.028 0.516 3.020 0.275 0.376 0.516 0.516 0.134 133.000 145.000 1512.000 137.455
24 0 22 0 2 0 GET /api/livestream/[a-zA-Z0-9]+/statistics 0.000 0.164 2.456 0.102 0.156 0.160 0.164 0.049 55.000 103.000 2367.000 98.625
57 0 57 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/enter 0.004 0.164 2.196 0.039 0.084 0.152 0.164 0.036 0.000 0.000 0.000 0.000
47 0 46 0 0 1 GET /api/livestream/[a-zA-Z0-9]+/report 0.004 0.228 1.660 0.035 0.112 0.124 0.228 0.049 3.000 19566.000 71947.000 1530.787
48 0 48 0 0 0 DELETE /api/livestream/[a-zA-Z0-9]+/exit 0.008 0.140 1.556 0.032 0.068 0.112 0.140 0.031 0.000 0.000 0.000 0.000
9 0 9 0 0 0 GET /api/user/[a-zA-Z0-9]+/livestream 0.048 0.268 1.336 0.148 0.268 0.268 0.268 0.067 1213.000 5136.000 22864.000 2540.444
294 0 294 0 0 0 POST /api/icon 0.004 0.020 1.041 0.004 0.008 0.008 0.016 0.003 14.000 14.000 4116.000 14.000
10 0 10 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.004 0.096 0.212 0.021 0.044 0.096 0.096 0.027 38.000 38.000 380.000 38.000
6 0 6 0 0 0 GET /api/user/[a-zA-Z0-9]+$ 0.004 0.012 0.028 0.005 0.012 0.012 0.012 0.004 235.000 247.000 1458.000 243.000
1 0 1 0 0 0 GET /api/payment 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 21.000 21.000 21.000 21.000
github-actions[bot] commented 11 months ago 
Reading from STDIN ...

# 32.3s user time, 150ms system time, 36.00M rss, 42.35M vsz
# Current date: Sat Nov 25 06:37:11 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 530.36k total, 91 unique, 3.07k QPS, 1.73x concurrency ________
# Time range: 2023-11-25T06:34:15 to 2023-11-25T06:37:08
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           300s     1us   448ms   565us     2ms     3ms    66us
# Lock time          826ms       0    36ms     1us     1us   116us       0
# Rows sent        461.57k       0   7.42k    0.89    4.96   49.50       0
# Rows examine      37.21M       0  17.92k   73.58    4.96  691.90       0
# Query size        33.45M       5   1.94M   66.13  313.99   2.84k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0xDA556F9115773A1A99AA0165670CE848 46.5302 15.5% 155480 0.0003  0.01 ADMIN PREPARE
#    2 0x42EF7D7D98FBCC9723BF896EBFC51D24 43.2519 14.4%   5868 0.0074  0.01 SELECT records
#    3 0x3D83BC87F3B3A00D571FFC8104A6E50C 26.3189  8.8%   4457 0.0059  0.01 SELECT records
#    4 0x64CC8A4E8E4B390203375597CE4D611F 24.9910  8.3%    602 0.0415  0.01 SELECT ng_words
#    5 0xFFFCA4D67EA0A788813031B8BBC3B329 18.6536  6.2%   3911 0.0048  0.01 COMMIT
#    6 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 18.6027  6.2%    918 0.0203  0.01 SELECT reservation_slots
#    7 0x38BC86A45F31C6B1EE324671506C898A 15.5048  5.2%  28913 0.0005  0.00 SELECT themes
#    8 0x4ADE2DC90689F1C4891749AF54FB8D14 13.3067  4.4%  36591 0.0004  0.00 DELETE SELECT livecomments
#    9 0xEA1E6309EEEFF9A6831AD2FB940FC23C  8.6043  2.9%  28609 0.0003  0.00 SELECT users
#   10 0x22279D81D51006139E0C76405B54C261  7.8937  2.6%   8829 0.0009  0.00 SELECT domains domainmetadata
#   11 0xF7144185D9A142A426A36DC55C1D2623  6.6315  2.2%  16508 0.0004  0.00 SELECT livestream_tags
#   12 0xDFFCC1D78939C4D781C7C58349101F50  6.1504  2.1%   1000 0.0062  0.00 INSERT users
#   13 0xD2A0864774622BA36F6557496405CF75  6.0112  2.0%   1295 0.0046  0.00 INSERT themes
#   14 0x8F7679D452333ED3C7D60D22131CEFD4  5.9460  2.0%  20824 0.0003  0.00 ADMIN RESET STMT
#   15 0x55C45664C0A27CA4AF92DD1D2D0ABDAA  5.4619  1.8%  16005 0.0003  0.00 SELECT tags
#   16 0x859BBB7E9D760686137A944406874C4D  5.2904  1.8%    295 0.0179  0.01 DELETE records
#   17 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  4.6400  1.5%    121 0.0383  0.01 SELECT livestreams
#   18 0xD6032FE08E1FE706A928B8B7CBA06B85  4.5917  1.5%  14778 0.0003  0.00 SELECT livestreams
#   19 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  4.0735  1.4%    105 0.0388  0.02 UPDATE reservation_slots
#   20 0x7F9C0C0BA9473953B723EE16C08655F1  3.8475  1.3%    106 0.0363  0.02 SELECT reservation_slots
#   21 0x9AC623FA477E73A44D191D296850A025  3.2644  1.1%    590 0.0055  0.01 SELECT records
#   22 0x3F155F5E71EFF856F0CF7B8430DE8C23  1.9827  0.7%   6157 0.0003  0.00 SELECT users
#   23 0xE4555A2709C09FD9BFF6688D80B0AA49  1.6276  0.5%     22 0.0740  0.01 SELECT livestreams reactions livecomments
#   24 0x07890000813C4CC7111FD2D3F3B3B4EB  1.6222  0.5% 155462 0.0000  0.00 ADMIN CLOSE STMT
#   25 0xFFF66E9B3D962FA319C8068B5C1997CD  1.5474  0.5%   5855 0.0003  0.00 ROLLBACK
#   26 0xEDE18C1523658A19E07525EAFCBA6BFE  1.4962  0.5%     33 0.0453  0.01 SELECT ng_words
#   27 0xB78E63D0D9C72DDDAB7A3E53517FA04C  1.4939  0.5%    533 0.0028  0.00 SELECT livecomments
#   28 0xAD0C28443E1E5CFAFF1569DBB4F7E63A  1.4228  0.5%    566 0.0025  0.00 SELECT reactions
#   29 0x9E2DA589A20EC24C34E11DDE0FBF5564  1.1021  0.4%   9479 0.0001  0.00 START
#   30 0x611999F76068C4DC4F90E0A389918E63  1.0216  0.3%     11 0.0929  0.03 SELECT users livestreams reactions livestreams livecomments
#   31 0xB08B7B7486D2DFE2F2FE9CE78689FD79  0.9295  0.3%     25 0.0372  0.01 SELECT ng_words
#   32 0x98F959E03B684A5538FD8402A0EE94AD  0.6181  0.2%    103 0.0060  0.00 INSERT tags
#   33 0x77FB9E134D073862D1E78FEEC3436291  0.5116  0.2%   1575 0.0003  0.00 INSERT records
#   34 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.5094  0.2%    601 0.0008  0.00 INSERT livecomments
#   35 0x02B6A87E51A5A1B7646675DB67C57DE3  0.4483  0.1%      1 0.4483  0.00 INSERT ng_words
#   36 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.4138  0.1%     22 0.0188  0.00 INSERT livestream_tags
#   37 0x80E10371CE74ED05E09C79C72C73F8E1  0.4057  0.1%    106 0.0038  0.28 INSERT livestreams
#   38 0x651E3772B8767A368CB47EE7389EEB33  0.2832  0.1%     19 0.0149  0.01 SELECT livestream_tags
#   39 0xF985E5835B84E84C7A721801818E98CE  0.2040  0.1%     11 0.0185  0.01 SELECT users livestreams reactions
#   40 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.2024  0.1%    592 0.0003  0.01 SET
#   41 0x5AEB6E4A781A3854CF642125E293FEE0  0.1977  0.1%    547 0.0004  0.00 INSERT reactions
#   42 0x41F805E95754958A974F41AE07BEA625  0.1796  0.1%     30 0.0060  0.00 SELECT livecomments
#   43 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.1685  0.1%     11 0.0153  0.02 SELECT users livestreams reactions
#   44 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.1603  0.1%      1 0.1603  0.00 INSERT reservation_slots
#   45 0x5D469B53C536D19CD15E40763ACC23C7  0.1592  0.1%    447 0.0004  0.01 INSERT livestream_tags
#   46 0x64052B1C32B30DF53AB3292208B783B4  0.1429  0.0%    296 0.0005  0.00 INSERT users
#   47 0xE64D50F7AFC1AD5F465809A92DF4935E  0.1346  0.0%     55 0.0024  0.00 SELECT reactions
#   48 0xEE4C51AE2BF74414C4892CBE11E894AA  0.1325  0.0%     56 0.0024  0.00 SELECT livecomments
#   49 0xE623383C5D789800DC0946925F90039F  0.0858  0.0%    296 0.0003  0.00 SELECT domains
#   50 0x4B6FA79E206C6CED71D433A2FC998D69  0.0681  0.0%    118 0.0006  0.00 SELECT
#   51 0x2B760561C10B5D133155AA306D0F407C  0.0634  0.0%     35 0.0018  0.00 SELECT livecomments
#   52 0x08A6ACD83D579DD8A808134B32AD376B  0.0602  0.0%      1 0.0602  0.00 TRUNCATE TABLE livestream_tags
#   53 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0586  0.0%      1 0.0586  0.00 TRUNCATE TABLE tags
#   54 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0558  0.0%      1 0.0558  0.00 TRUNCATE TABLE users
#   55 0x1FB70DBF74628C9F2E9F0C3478771936  0.0557  0.0%      1 0.0557  0.00 TRUNCATE TABLE ng_words
#   56 0xD2978B45C67B47B5D73AC532EB40A95E  0.0552  0.0%      1 0.0552  0.00 TRUNCATE TABLE themes
#   57 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0516  0.0%      1 0.0516  0.00 TRUNCATE TABLE icons
#   58 0x2AAED5867123C749367FD8E4BBD796D2  0.0506  0.0%      1 0.0506  0.00 TRUNCATE TABLE livecomments
#   59 0x93A42F50BF286ACA749DF5F342FAC07B  0.0479  0.0%      1 0.0479  0.00 TRUNCATE TABLE livecomment_reports
#   60 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0477  0.0%    126 0.0004  0.00 SELECT livecomments
#   61 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0458  0.0%      1 0.0458  0.00 TRUNCATE TABLE livestreams
#   62 0x07F6C3FF39ADD79FC63923A7EE938953  0.0458  0.0%      1 0.0458  0.00 INSERT livecomments
#   63 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0450  0.0%      1 0.0450  0.00 TRUNCATE TABLE reactions
#   64 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0445  0.0%      1 0.0445  0.00 TRUNCATE TABLE reservation_slots
#   65 0x9C697B3F0446BBF7602663588252F020  0.0431  0.0%      1 0.0431  0.00 TRUNCATE TABLE livestream_viewers_history
#   66 0x544239977D2094F805A7B062DE95673A  0.0424  0.0%     93 0.0005  0.00 SELECT tags
#   67 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0403  0.0%      1 0.0403  0.00 DELETE records
#   68 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0337  0.0%    296 0.0001  0.00 BEGIN
#   69 0x74232BDFFB94C567F0340DBE3285E458  0.0305  0.0%      1 0.0305  0.00 INSERT reactions
#   70 0x24C44C3518CE12293EF12410AEDA2393  0.0290  0.0%     46 0.0006  0.00 SELECT livestreams
#   71 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0228  0.0%     22 0.0010  0.00 SELECT livestreams livecomments
#   72 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0193  0.0%     48 0.0004  0.00 DELETE livestream_viewers_history
#   73 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0179  0.0%     48 0.0004  0.00 INSERT livecomment_reports
#   74 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0164  0.0%     57 0.0003  0.00 INSERT livestream_viewers_history
#   75 0x466EE4C87B17CAD4E692DE1D44EAD84D  0.0155  0.0%     47 0.0003  0.00 SELECT livecomment_reports
#   76 0x8F885091E23CB955C051B1204EE7D91D  0.0153  0.0%     22 0.0007  0.00 SELECT livestreams reactions
#   77 0x0C655718656DD9DDA39A0D11554A0C64  0.0124  0.0%     25 0.0005  0.00 INSERT ng_words
#   78 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0104  0.0%     35 0.0003  0.00 SELECT livestream_viewers_history
#   79 0xB871CC5B0472067402F5739D108B2C1C  0.0052  0.0%     25 0.0002  0.00 SELECT livestreams
#   80 0x8B2044ADAE690405979131C33185F22A  0.0031  0.0%     10 0.0003  0.00 SELECT users
#   81 0x394E66DDE2823A903078D4C0F235B948  0.0030  0.0%     22 0.0001  0.00 SELECT livestreams livecomment_reports
#   82 0x489B4CEB2F4301A7132628303F99240D  0.0028  0.0%      2 0.0014  0.00 SHOW TABLES
#   83 0xF085F31DC1964EA538732B713E4B4108  0.0025  0.0%     22 0.0001  0.00 SELECT livestreams livestream_viewers_history
#   84 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0021  0.0%     19 0.0001  0.00 SELECT tags
#   85 0x751417D45B8E80EE5CBA2034458B5BC9  0.0018  0.0%      1 0.0018  0.00 SHOW DATABASES
#   86 0xDAF488916DDDA1B36246C5FA69B60B7B  0.0012  0.0%      3 0.0004  0.00 SELECT themes icons
#   87 0xEDBC971AEC392917AA353644DE4C4CB4  0.0010  0.0%    490 0.0000  0.00 ADMIN QUIT
#   88 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0008  0.0%      9 0.0001  0.00 SELECT
#   89 0xC4625761E0CFD817F41B4802F152A489  0.0004  0.0%      1 0.0004  0.00 SELECT livecomments
#   90 0x54A1C6D0621F13ADD1B3CBA1954A3A73  0.0002  0.0%      1 0.0002  0.00 SELECT icons
#   91 0xE84E602C0D0858D5661956B70D72A215  0.0002  0.0%      1 0.0002  0.00 SELECT icons

# Query 1: 1.47k QPS, 0.44x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 13419585
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:34:15 to 2023-11-25T06:36:01
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         29  155480
# Exec time     15     47s    19us   340ms   299us     1ms     1ms    89us
# Lock time      0     3us       0     3us       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    13   4.45M      30      30      30      30       0      30
# String:
# Databases    isupipe (153697/98%), isudns (1783/1%)
# Hosts        localhost
# Users        isucon (153697/98%), isudns (1783/1%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ############################################
#   1ms  #######
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 2: 69.86 QPS, 0.51x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 85521118
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:34:15 to 2023-11-25T06:35:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    5868
# Exec time     14     43s   717us    66ms     7ms    20ms     7ms     5ms
# Lock time      3    27ms       0     3ms     4us     1us    66us     1us
# Rows sent      0   1.43k       0       1    0.25    0.99    0.43       0
# Rows examine  21   8.00M   1.25k   1.54k   1.40k   1.46k   82.56   1.39k
# Query size     2 808.55k     129     216  141.10  158.58   11.46  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='nxfjnymbxvyb85087vp0.u.isucon.dev' and domain_id=2\G

# Query 3: 53.06 QPS, 0.31x concurrency, ID 0x3D83BC87F3B3A00D571FFC8104A6E50C at byte 110268549
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:34:15 to 2023-11-25T06:35:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    4457
# Exec time      8     26s   676us    63ms     6ms    18ms     6ms     3ms
# Lock time      2    18ms       0     3ms     4us     1us    68us     1us
# Rows sent      0   2.30k       0       1    0.53    0.99    0.50    0.99
# Rows examine  16   6.07M   1.25k   1.54k   1.40k   1.46k   83.07   1.39k
# Query size     1 585.12k     126     215  134.43  151.03   10.75  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='wj6zz95gb1b4ifydq0gck28w3nsck0.u.isucon.dev'\G

# Query 4: 8.99 QPS, 0.37x concurrency, ID 0x64CC8A4E8E4B390203375597CE4D611F at byte 49991072
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:34:31 to 2023-11-25T06:35:38
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     602
# Exec time      8     25s     4ms   130ms    42ms    75ms    21ms    40ms
# Lock time      0     2ms       0     1ms     3us     1us    53us     1us
# Rows sent      0     118       0       3    0.20    0.99    0.49       0
# Rows examine  22   8.24M  14.00k  14.02k  14.01k  13.78k       0  13.78k
# Query size     0  58.20k      97      99   98.99   97.36    0.27   97.36
# 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 'ng_words'\G
#    SHOW CREATE TABLE `isupipe`.`ng_words`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT id, user_id, livestream_id, word FROM ng_words WHERE user_id = 1024 AND livestream_id = 7530\G

# Query 5: 43.46 QPS, 0.21x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 69756492
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:34:31 to 2023-11-25T06:36:01
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    3911
# Exec time      6     19s    19us    61ms     5ms    14ms     5ms     5ms
# 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  22.92k       6       6       6       6       0       6
# String:
# Databases    isupipe (3615/92%), isudns (296/7%)
# Hosts        localhost
# Users        isucon (3615/92%), isudns (296/7%)
# Query_time distribution
#   1us
#  10us  ##########################################
# 100us  ##############
#   1ms  ################################################################
#  10ms  ###################
# 100ms
#    1s
#  10s+
COMMIT\G