search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu1 #9

Open github-actions[bot] opened 10 months ago

github-actions[bot] commented 10 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)
681 0 598 0 83 0 GET /api/livestream 0.004 53.749 3451.655 5.069 23.664 35.464 40.156 11.388 102.000 37211.000 3895915.000 5720.874
456 0 445 0 11 0 POST /api/livestream 0.004 9.972 225.120 0.494 1.240 2.896 5.532 1.117 0.000 2705.000 777948.000 1706.026
1662 0 1658 0 4 0 GET /api/user/[a-zA-Z0-9]+/icon 0.004 4.404 215.464 0.130 0.252 0.460 1.916 0.348 49915.000 103167.000 85171222.000 51246.223
11 0 6 0 5 0 GET /api/user/[a-zA-Z0-9]+/statistics 3.384 39.321 193.853 17.623 22.268 39.321 39.321 10.193 0.000 157.000 901.000 81.909
55 0 54 0 1 0 GET /api/livestream/search 0.028 4.340 53.280 0.969 2.160 2.488 4.340 0.879 12640.000 126615.000 3302675.000 60048.636
139 0 136 0 2 1 POST /api/register 0.008 2.992 45.736 0.329 0.572 1.156 2.724 0.483 0.000 504.000 63634.000 457.799
79 0 75 0 4 0 POST /api/livestream/reservation 0.212 1.920 39.140 0.495 1.088 1.616 1.920 0.471 0.000 1459.000 83527.000 1057.304
135 0 135 0 0 0 POST /api/icon 0.012 3.316 35.100 0.260 0.572 1.164 2.944 0.520 14.000 16.000 2052.000 15.200
144 0 141 0 3 0 POST /api/login 0.004 3.788 23.244 0.161 0.332 0.488 2.424 0.460 0.000 64.000 128.000 0.889
73 0 73 0 0 0 GET /api/tag 0.004 3.660 14.912 0.204 0.448 0.884 3.660 0.550 6089.000 6095.000 444761.000 6092.616
1 0 1 0 0 0 POST /api/initialize 13.728 13.728 13.728 13.728 13.728 13.728 13.728 0.000 27.000 27.000 27.000 27.000
14 0 14 0 0 0 DELETE /api/livestream 0.004 2.108 3.448 0.246 0.432 2.108 2.108 0.529 0.000 0.000 0.000 0.000
5 0 5 0 0 0 GET /api/user/[a-zA-Z0-9]+/livestream 0.156 1.212 1.876 0.375 1.212 1.212 1.212 0.419 5728.000 5734.000 28646.000 5729.200
19 0 18 0 1 0 GET /api/user/me 0.004 0.404 0.864 0.045 0.100 0.404 0.404 0.090 247.000 247.000 4434.000 233.368
5 0 5 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.008 0.152 0.268 0.054 0.152 0.152 0.152 0.059 38.000 38.000 190.000 38.000
6 0 6 0 0 0 GET /api/user/[a-zA-Z0-9]+$ 0.004 0.068 0.180 0.030 0.068 0.068 0.068 0.023 235.000 247.000 1470.000 245.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
7 0 2 5 0 0 GET / 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 283.000 566.000 80.857
2 0 0 2 0 0 GET /assets/index-55457d82.js 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
1 0 0 1 0 0 GET /assets/index-5265c558.css 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
1 0 0 1 0 0 GET /assets/ISUPipe_yoko_color-fc80178e.png 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
1 0 0 1 0 0 GET /favicon.ico 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
github-actions[bot] commented 10 months ago 
Reading from STDIN ...

# 623.4s user time, 3.9s system time, 36.51M rss, 42.85M vsz
# Current date: Sat Nov 25 03:09:01 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 6.53M total, 97 unique, 2.05k QPS, 1.46x concurrency __________
# Time range: 2023-11-25T02:15:37 to 2023-11-25T03:08:43
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time          4653s     1us   428ms   712us     4ms     1ms   119us
# Lock time             7s       0    22ms     1us     1us    27us       0
# Rows sent          3.62M       0   7.39k    0.58    0.99   42.55       0
# Rows examine       2.31G       0  14.02k  379.37   1.14k  554.25       0
# Query size       379.63M       5   1.94M   60.94  118.34  907.09   31.70

# Profile
# Rank Query ID                           Response time   Calls   R/Call V
# ==== ================================== =============== ======= ====== =
#    1 0xFD38427AE3D09E3883A680F7BAF95D3A 1927.5504 41.4% 1021678 0.0019  0.00 SELECT livestreams livecomments
#    2 0xC499D81D570D361DB61FC43A94BB888A 1643.1788 35.3% 1021730 0.0016  0.00 SELECT livestreams reactions
#    3 0xDA556F9115773A1A99AA0165670CE848  706.5243 15.2% 2158967 0.0003  0.00 ADMIN PREPARE
#    4 0xF1B8EF06D6CA63B24BFF433E06CCEB22   62.7344  1.3%    8320 0.0075  0.01 SELECT users livestreams livecomments
#    5 0xDB74D52D39A7090F224C4DEEAF3028C9   59.6563  1.3%    8324 0.0072  0.01 SELECT users livestreams reactions
#    6 0x42EF7D7D98FBCC9723BF896EBFC51D24   44.5520  1.0%    7314 0.0061  0.00 SELECT records
#    7 0x84B457C910C4A79FC9EBECB8B1065C66   30.0317  0.6%    9772 0.0031  0.00 SELECT icons
#    8 0x07890000813C4CC7111FD2D3F3B3B4EB   29.7941  0.6% 2158825 0.0000  0.00 ADMIN CLOSE STMT
#    9 0x3D83BC87F3B3A00D571FFC8104A6E50C   22.7962  0.5%    5296 0.0043  0.00 SELECT records
#   10 0x4ADE2DC90689F1C4891749AF54FB8D14   19.0290  0.4%   37824 0.0005  0.00 DELETE SELECT livecomments
#   11 0x38BC86A45F31C6B1EE324671506C898A   14.5113  0.3%    8091 0.0018  0.00 SELECT themes
#   12 0x59F1B6DD8D9FEC059E55B3BFD624E8C3   11.0963  0.2%     562 0.0197  0.01 SELECT reservation_slots
#   13 0xFFFCA4D67EA0A788813031B8BBC3B329    8.2939  0.2%    1870 0.0044  0.01 COMMIT
#   14 0x64CC8A4E8E4B390203375597CE4D611F    8.1046  0.2%     194 0.0418  0.01 SELECT ng_words
#   15 0x050F7D44808F43E5D33D0B90BCF57CC9    7.7706  0.2%     222 0.0350  0.02 SELECT livestreams
#   16 0xFBC5564AE716EAE82F20BFB45F6C37E7    6.2404  0.1%   19267 0.0003  0.00 SELECT tags
#   17 0x22279D81D51006139E0C76405B54C261    5.9442  0.1%    8996 0.0007  0.00 SELECT domains domainmetadata
#   18 0xDFFCC1D78939C4D781C7C58349101F50    5.4957  0.1%    1000 0.0055  0.00 INSERT users
#   19 0xD2A0864774622BA36F6557496405CF75    5.2003  0.1%    1136 0.0046  0.00 INSERT themes
#   20 0x8F7679D452333ED3C7D60D22131CEFD4    4.6484  0.1%   22488 0.0002  0.00 ADMIN RESET STMT
#   21 0x7F9C0C0BA9473953B723EE16C08655F1    2.9397  0.1%      77 0.0382  0.02 SELECT reservation_slots
#   22 0xF7144185D9A142A426A36DC55C1D2623    2.7481  0.1%    5594 0.0005  0.00 SELECT livestream_tags
#   23 0xA3401CA3ABCC04C3AB221DB8AD5CBF26    2.7274  0.1%      75 0.0364  0.02 UPDATE reservation_slots
#   24 0xEA1E6309EEEFF9A6831AD2FB940FC23C    2.6946  0.1%    7945 0.0003  0.00 SELECT users
#   25 0x9EAD6C0CE525E3693EE27FFC9AAF05A3    2.6874  0.1%      76 0.0354  0.01 SELECT livestreams
#   26 0x859BBB7E9D760686137A944406874C4D    1.9848  0.0%     136 0.0146  0.01 DELETE records
#   27 0x3A2B0EDA41C4E3576FCA6DA29A9B91DF    1.4043  0.0%     135 0.0104  0.01 INSERT icons
#   28 0xD6032FE08E1FE706A928B8B7CBA06B85    1.3837  0.0%    4150 0.0003  0.00 SELECT livestreams
#   29 0x9AC623FA477E73A44D191D296850A025    1.2003  0.0%     272 0.0044  0.00 SELECT records
#   30 0xEDE18C1523658A19E07525EAFCBA6BFE    1.1775  0.0%      24 0.0491  0.01 SELECT ng_words
#   31 0xB08B7B7486D2DFE2F2FE9CE78689FD79    1.0856  0.0%      23 0.0472  0.01 SELECT ng_words
#   32 0xFFF66E9B3D962FA319C8068B5C1997CD    0.7466  0.0%    1703 0.0004  0.00 ROLLBACK
#   33 0x3F155F5E71EFF856F0CF7B8430DE8C23    0.7193  0.0%    1854 0.0004  0.00 SELECT users
#   34 0x9E2DA589A20EC24C34E11DDE0FBF5564    0.6917  0.0%    3584 0.0002  0.01 START
#   35 0x98F959E03B684A5538FD8402A0EE94AD    0.5418  0.0%     103 0.0053  0.00 INSERT tags
#   36 0x02B6A87E51A5A1B7646675DB67C57DE3    0.4278  0.0%       1 0.4278  0.00 INSERT ng_words
#   37 0xB78E63D0D9C72DDDAB7A3E53517FA04C    0.4089  0.0%     156 0.0026  0.00 SELECT livecomments
#   38 0xF1E5C5B0483E8BF764220BFACAE7CD16    0.3910  0.0%     135 0.0029  0.00 DELETE icons
#   39 0xAD0C28443E1E5CFAFF1569DBB4F7E63A    0.3876  0.0%     190 0.0020  0.00 SELECT reactions
#   40 0x80E10371CE74ED05E09C79C72C73F8E1    0.3740  0.0%      76 0.0049  0.25 INSERT livestreams
#   41 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC    0.3537  0.0%      22 0.0161  0.00 INSERT livestream_tags
#   42 0x41F805E95754958A974F41AE07BEA625    0.2901  0.0%      34 0.0085  0.01 SELECT livecomments
#   43 0x77FB9E134D073862D1E78FEEC3436291    0.2626  0.0%    1416 0.0002  0.00 INSERT records
#   44 0x651E3772B8767A368CB47EE7389EEB33    0.1615  0.0%      13 0.0124  0.02 SELECT livestream_tags
#   45 0xF3A502CCF34F7DA288CC1B75AD5AFA37    0.1480  0.0%     193 0.0008  0.00 INSERT livecomments
#   46 0xDF0AAE38E2AAFC85E6F50569CEF2285D    0.1424  0.0%       1 0.1424  0.00 INSERT reservation_slots
#   47 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0    0.1130  0.0%     289 0.0004  0.00 SET
#   48 0x5AEB6E4A781A3854CF642125E293FEE0    0.1121  0.0%     169 0.0007  0.00 INSERT reactions
#   49 0x5D469B53C536D19CD15E40763ACC23C7    0.0992  0.0%     297 0.0003  0.00 INSERT livestream_tags
#   50 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4    0.0988  0.0%      91 0.0011  0.00 SELECT livestreams livecomments
#   51 0x8F885091E23CB955C051B1204EE7D91D    0.0854  0.0%      91 0.0009  0.00 SELECT livestreams reactions
#   52 0x19A1F14EFC0F221D30AFCB1E1344BEBD    0.0825  0.0%      11 0.0075  0.01 SELECT users
#   53 0x64052B1C32B30DF53AB3292208B783B4    0.0794  0.0%     137 0.0006  0.00 INSERT users
#   54 0x544239977D2094F805A7B062DE95673A    0.0661  0.0%      80 0.0008  0.00 SELECT tags
#   55 0xB962B14EDA3C9149DE2F648A5F0347D5    0.0626  0.0%       2 0.0313  0.04 SELECT domains records
#   56 0x9C697B3F0446BBF7602663588252F020    0.0556  0.0%       1 0.0556  0.00 TRUNCATE TABLE livestream_viewers_history
#   57 0xEE4C51AE2BF74414C4892CBE11E894AA    0.0535  0.0%      23 0.0023  0.00 SELECT livecomments
#   58 0xE64D50F7AFC1AD5F465809A92DF4935E    0.0520  0.0%      22 0.0024  0.00 SELECT reactions
#   59 0xDFEFE5BA5D8654534DC8550C6E3DC9C0    0.0503  0.0%       1 0.0503  0.00 DELETE records
#   60 0x2B760561C10B5D133155AA306D0F407C    0.0467  0.0%      46 0.0010  0.00 SELECT livecomments
#   61 0xBB7F4DC4E67BF30E0588D296FFAF009F    0.0459  0.0%       1 0.0459  0.00 TRUNCATE TABLE tags
#   62 0xA7C2E59AEF14D03CB65B227F3E3BA469    0.0442  0.0%       1 0.0442  0.00 TRUNCATE TABLE reservation_slots
#   63 0xAFFDC331C1D4BA089978A0B8DD00BFC8    0.0441  0.0%       1 0.0441  0.00 TRUNCATE TABLE livestreams
#   64 0x93A42F50BF286ACA749DF5F342FAC07B    0.0441  0.0%       1 0.0441  0.00 TRUNCATE TABLE livecomment_reports
#   65 0x1FB70DBF74628C9F2E9F0C3478771936    0.0441  0.0%       1 0.0441  0.00 TRUNCATE TABLE ng_words
#   66 0xD2978B45C67B47B5D73AC532EB40A95E    0.0441  0.0%       1 0.0441  0.00 TRUNCATE TABLE themes
#   67 0x2AAED5867123C749367FD8E4BBD796D2    0.0425  0.0%       1 0.0425  0.00 TRUNCATE TABLE livecomments
#   68 0x08A6ACD83D579DD8A808134B32AD376B    0.0417  0.0%       1 0.0417  0.00 TRUNCATE TABLE livestream_tags
#   69 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2    0.0411  0.0%       1 0.0411  0.00 TRUNCATE TABLE users
#   70 0x07F6C3FF39ADD79FC63923A7EE938953    0.0405  0.0%       1 0.0405  0.00 INSERT livecomments
#   71 0xFB296F703ACC41C3F94A9B7D75044F3C    0.0402  0.0%       1 0.0402  0.00 TRUNCATE TABLE reactions
#   72 0x4B6FA79E206C6CED71D433A2FC998D69    0.0398  0.0%      71 0.0006  0.00 SELECT
#   73 0x24C44C3518CE12293EF12410AEDA2393    0.0377  0.0%      51 0.0007  0.00 SELECT livestreams
#   74 0x253CA101A906B3D56A95D1B8DCEE28EF    0.0375  0.0%       1 0.0375  0.00 TRUNCATE TABLE icons
#   75 0x81E419F4B58AEB9B280B03DE44DD8B94    0.0322  0.0%     102 0.0003  0.00 SELECT livecomments
#   76 0x49F80FBE1AC70F23A3DD076174FF1AA9    0.0314  0.0%       6 0.0052  0.00 SELECT users livestreams reactions
#   77 0xF985E5835B84E84C7A721801818E98CE    0.0313  0.0%       6 0.0052  0.00 SELECT users livestreams reactions
#   78 0xE623383C5D789800DC0946925F90039F    0.0263  0.0%     137 0.0002  0.00 SELECT domains
#   79 0x74232BDFFB94C567F0340DBE3285E458    0.0259  0.0%       1 0.0259  0.00 INSERT reactions
#   80 0x394E66DDE2823A903078D4C0F235B948    0.0242  0.0%      91 0.0003  0.00 SELECT livestreams livecomment_reports
#   81 0xF085F31DC1964EA538732B713E4B4108    0.0224  0.0%      91 0.0002  0.00 SELECT livestreams livestream_viewers_history
#   82 0x827F41D30F8E37F04D8BDCD46C556FB3    0.0162  0.0%      38 0.0004  0.00 INSERT livecomment_reports
#   83 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A    0.0103  0.0%     137 0.0001  0.00 BEGIN
#   84 0xBF3194A2446AC20FC99B6CC7FA476A57    0.0076  0.0%      24 0.0003  0.00 INSERT livestream_viewers_history
#   85 0x466EE4C87B17CAD4E692DE1D44EAD84D    0.0070  0.0%      31 0.0002  0.00 SELECT livecomment_reports
#   86 0xB871CC5B0472067402F5739D108B2C1C    0.0069  0.0%      23 0.0003  0.00 SELECT livestreams
#   87 0x0C655718656DD9DDA39A0D11554A0C64    0.0065  0.0%      23 0.0003  0.00 INSERT ng_words
#   88 0x2C17BCA1E1077820CDC2EC6106F4D93E    0.0054  0.0%      46 0.0001  0.00 SELECT livestream_viewers_history
#   89 0xA0D956F292B7FEA0DCE68A5DD5F529E1    0.0050  0.0%      14 0.0004  0.00 DELETE livestream_viewers_history
#   90 0x20CD15DC47AF2F861B8F3C25D195ABE9    0.0022  0.0%      13 0.0002  0.00 SELECT tags
#   91 0x751417D45B8E80EE5CBA2034458B5BC9    0.0021  0.0%       1 0.0021  0.00 SHOW DATABASES
#   92 0x489B4CEB2F4301A7132628303F99240D    0.0015  0.0%       1 0.0015  0.00 SHOW TABLES
#   93 0x0E7680C04FF2596BE3A3649C5FAC418D    0.0009  0.0%      10 0.0001  0.00 SELECT
#   94 0x8B2044ADAE690405979131C33185F22A    0.0007  0.0%       5 0.0001  0.00 SELECT users
#   95 0xEDBC971AEC392917AA353644DE4C4CB4    0.0006  0.0%     277 0.0000  0.00 ADMIN QUIT
#   96 0xC4625761E0CFD817F41B4802F152A489    0.0004  0.0%       1 0.0004  0.00 SELECT livecomments
#   97 0xE8390778DC20D4CC04FE01C5B31FD305    0.0000  0.0%       1 0.0000  0.00 ADMIN PING

# Query 1: 324.86 QPS, 0.61x concurrency, ID 0xFD38427AE3D09E3883A680F7BAF95D3A at byte 1693738549
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T02:15:54 to 2023-11-25T03:08:19
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         15 1021678
# Exec time     41   1928s   261us    47ms     2ms     5ms     2ms     1ms
# Lock time     53      4s       0     6ms     3us     1us    38us     1us
# Rows sent     26 997.73k       1       1       1       1       0       1
# Rows examine  48   1.13G    1001   1.16k   1.16k   1.14k   26.89   1.14k
# Query size    30 116.73M     117     120  119.81  118.34    0.79  118.34
# 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 '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 livestreams l INNER JOIN livecomments l2 ON l.id = l2.livestream_id WHERE l.id = 1423\G

# Query 2: 324.87 QPS, 0.52x concurrency, ID 0xC499D81D570D361DB61FC43A94BB888A at byte 1693740122
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T02:15:54 to 2023-11-25T03:08:19
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         15 1021730
# Exec time     35   1643s   227us    46ms     2ms     4ms     1ms   972us
# Lock time     39      3s       0     4ms     2us     1us    29us     1us
# Rows sent     26 997.78k       1       1       1       1       0       1
# Rows examine  48   1.11G    1001   1.14k   1.14k   1.09k   18.28   1.09k
# Query size    25  98.23M      98     101  100.81   97.36       0   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 '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 livestreams l INNER JOIN reactions r ON l.id = r.livestream_id WHERE l.id = 1422\G

# Query 3: 682.79 QPS, 0.22x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 43792757
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T02:15:37 to 2023-11-25T03:08:19
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         33 2158967
# Exec time     15    707s    22us   302ms   327us     1ms   507us   119us
# Lock time      0    95us       0    23us       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    16  61.77M      30      30      30      30       0      30
# String:
# Hosts        localhost
# Users        isucon (2158133/99%), isudns (834/0%)
# Query_time distribution
#   1us
#  10us  ####################################################
# 100us  ################################################################
#   1ms  ##########
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 4: 5.90 QPS, 0.04x concurrency, ID 0xF1B8EF06D6CA63B24BFF433E06CCEB22 at byte 90045272
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T02:15:50 to 2023-11-25T02:39:19
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    8320
# Exec time      1     63s     1ms    82ms     8ms    24ms     8ms     4ms
# Lock time      0    20ms       0     6ms     2us     1us    65us     1us
# Rows sent      0   8.12k       1       1       1       1       0       1
# Rows examine   0  17.78M   1.96k   2.32k   2.19k   2.27k  148.47   2.16k
# Query size     0   1.31M     163     166  164.92  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 = 223\G

# Query 5: 5.91 QPS, 0.04x concurrency, ID 0xDB74D52D39A7090F224C4DEEAF3028C9 at byte 102136227
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T02:15:50 to 2023-11-25T02:39:19
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    8324
# Exec time      1     60s     1ms    74ms     7ms    23ms     7ms     4ms
# Lock time      0    26ms       0     5ms     3us     1us    64us     1us
# Rows sent      0   8.13k       1       1       1       1       0       1
# Rows examine   0  17.66M   1.96k   2.29k   2.17k   2.27k  148.45   2.16k
# Query size     0   1.15M     143     146  144.92  143.84    0.74  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 = 334\G