search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu3 (Failed) icon #11

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)
34 0 11 0 23 0 GET /api/livestream 0.008 32.404 207.532 6.104 32.292 32.396 32.404 11.717 5734.000 5734.000 9424.000 277.176
4 0 4 0 0 0 GET /api/user/[a-zA-Z0-9]+/statistics 0.708 13.136 19.236 4.809 13.136 13.136 13.136 4.876 133.000 157.000 562.000 140.500
1 0 1 0 0 0 POST /api/initialize 11.240 11.240 11.240 11.240 11.240 11.240 11.240 0.000 27.000 27.000 27.000 27.000
13 0 13 0 0 0 GET /api/livestream/search 0.024 0.212 1.672 0.129 0.208 0.212 0.212 0.067 3.000 129220.000 1091410.000 83954.615
22 0 22 0 0 0 POST /api/livestream/reservation 0.020 0.032 0.460 0.021 0.024 0.024 0.032 0.003 910.000 1477.000 21984.000 999.273
2 0 2 0 0 0 POST /api/register 0.040 0.040 0.080 0.040 0.040 0.040 0.040 0.000 235.000 480.000 715.000 357.500
9 0 9 0 0 0 POST /api/livestream 0.004 0.012 0.080 0.009 0.012 0.012 0.012 0.003 0.000 2372.000 12666.000 1407.333
6 0 6 0 0 0 GET /api/tag 0.004 0.004 0.012 0.002 0.004 0.004 0.004 0.002 17.000 6095.000 24408.000 4068.000
5 0 5 0 0 0 POST /api/login 0.004 0.004 0.012 0.002 0.004 0.004 0.004 0.002 0.000 0.000 0.000 0.000
5 0 5 0 0 0 GET /api/user/me 0.000 0.004 0.012 0.002 0.004 0.004 0.004 0.002 235.000 247.000 1223.000 244.600
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
2 0 2 0 0 0 GET /api/user/[a-zA-Z0-9]+$ 0.000 0.004 0.004 0.002 0.004 0.004 0.004 0.002 235.000 247.000 482.000 241.000
1 0 1 0 0 0 GET /api/user/[a-zA-Z0-9]+/livestream 0.004 0.004 0.004 0.004 0.004 0.004 0.004 0.000 3.000 3.000 3.000 3.000
1 0 1 0 0 0 DELETE /api/livestream 0.004 0.004 0.004 0.004 0.004 0.004 0.004 0.000 0.000 0.000 0.000 0.000
1 0 1 0 0 0 POST /api/icon 0.004 0.004 0.004 0.004 0.004 0.004 0.004 0.000 14.000 14.000 14.000 14.000
1 0 1 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 38.000 38.000 38.000 38.000
1 0 1 0 0 0 GET /api/user/[a-zA-Z0-9]+/icon 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 6969.000 6969.000 6969.000 6969.000
github-actions[bot] commented 10 months ago 
Reading from STDIN ...

# 22.3s user time, 90ms system time, 36.21M rss, 42.61M vsz
# Current date: Sat Nov 25 04:14:08 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 370.23k total, 79 unique, 3.16k QPS, 0.91x concurrency ________
# Time range: 2023-11-25T04:09:49 to 2023-11-25T04:11:46
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           106s     1us   355ms   286us     1ms   930us    63us
# Lock time          204ms       0     2ms       0     1us     9us       0
# Rows sent        165.50k       0   7.34k    0.46    0.99   28.61       0
# Rows examine     114.77M       0  14.00k  325.05  964.41  494.24       0
# Query size        23.94M       5   1.94M   67.79  118.34   3.39k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0xFD38427AE3D09E3883A680F7BAF95D3A 38.6940 36.5%  54665 0.0007  0.00 SELECT livestreams livecomments
#    2 0xC499D81D570D361DB61FC43A94BB888A 33.1298 31.3%  54664 0.0006  0.00 SELECT livestreams reactions
#    3 0xDA556F9115773A1A99AA0165670CE848 15.6049 14.7% 121717 0.0001  0.00 ADMIN PREPARE
#    4 0xDFFCC1D78939C4D781C7C58349101F50  4.3292  4.1%   1000 0.0043  0.00 INSERT users
#    5 0xD2A0864774622BA36F6557496405CF75  4.2633  4.0%   1002 0.0043  0.00 INSERT themes
#    6 0xF1B8EF06D6CA63B24BFF433E06CCEB22  2.8711  2.7%   3007 0.0010  0.00 SELECT users livestreams livecomments
#    7 0xDB74D52D39A7090F224C4DEEAF3028C9  2.7871  2.6%   3007 0.0009  0.00 SELECT users livestreams reactions
#    8 0x07890000813C4CC7111FD2D3F3B3B4EB  0.7335  0.7% 121713 0.0000  0.00 ADMIN CLOSE STMT
#    9 0x98F959E03B684A5538FD8402A0EE94AD  0.4030  0.4%    103 0.0039  0.00 INSERT tags
#   10 0x02B6A87E51A5A1B7646675DB67C57DE3  0.3547  0.3%      1 0.3547  0.00 INSERT ng_words
#   11 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.2951  0.3%     22 0.0134  0.00 INSERT livestream_tags
#   12 0x38BC86A45F31C6B1EE324671506C898A  0.2938  0.3%   1106 0.0003  0.00 SELECT themes
#   13 0x80E10371CE74ED05E09C79C72C73F8E1  0.2542  0.2%     23 0.0111  0.22 INSERT livestreams
#   14 0xFFFCA4D67EA0A788813031B8BBC3B329  0.1493  0.1%     82 0.0018  0.00 COMMIT
#   15 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.1290  0.1%      1 0.1290  0.00 INSERT reservation_slots
#   16 0x050F7D44808F43E5D33D0B90BCF57CC9  0.1226  0.1%      6 0.0204  0.01 SELECT livestreams
#   17 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  0.1186  0.1%     22 0.0054  0.00 UPDATE reservation_slots
#   18 0x7F9C0C0BA9473953B723EE16C08655F1  0.1147  0.1%     22 0.0052  0.00 SELECT reservation_slots
#   19 0x77FB9E134D073862D1E78FEEC3436291  0.1007  0.1%   1282 0.0001  0.00 INSERT records
#   20 0xFBC5564AE716EAE82F20BFB45F6C37E7  0.1000  0.1%   1787 0.0001  0.00 SELECT tags
#   21 0xF7144185D9A142A426A36DC55C1D2623  0.0932  0.1%   1087 0.0001  0.00 SELECT livestream_tags
#   22 0xEA1E6309EEEFF9A6831AD2FB940FC23C  0.0704  0.1%   1101 0.0001  0.00 SELECT users
#   23 0xD6032FE08E1FE706A928B8B7CBA06B85  0.0628  0.1%    976 0.0001  0.00 SELECT livestreams
#   24 0x42EF7D7D98FBCC9723BF896EBFC51D24  0.0606  0.1%     67 0.0009  0.00 SELECT records
#   25 0x3D83BC87F3B3A00D571FFC8104A6E50C  0.0538  0.1%     65 0.0008  0.00 SELECT records
#   26 0x59F1B6DD8D9FEC059E55B3BFD624E8C3  0.0538  0.1%     28 0.0019  0.00 SELECT reservation_slots
#   27 0x1FB70DBF74628C9F2E9F0C3478771936  0.0439  0.0%      1 0.0439  0.00 TRUNCATE TABLE ng_words
#   28 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0435  0.0%      1 0.0435  0.00 DELETE records
#   29 0x93A42F50BF286ACA749DF5F342FAC07B  0.0397  0.0%      1 0.0397  0.00 TRUNCATE TABLE livecomment_reports
#   30 0x08A6ACD83D579DD8A808134B32AD376B  0.0372  0.0%      1 0.0372  0.00 TRUNCATE TABLE livestream_tags
#   31 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0354  0.0%      1 0.0354  0.00 TRUNCATE TABLE tags
#   32 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0345  0.0%      1 0.0345  0.00 TRUNCATE TABLE reservation_slots
#   33 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0345  0.0%      1 0.0345  0.00 TRUNCATE TABLE livestreams
#   34 0x07F6C3FF39ADD79FC63923A7EE938953  0.0342  0.0%      1 0.0342  0.00 INSERT livecomments
#   35 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0335  0.0%      1 0.0335  0.00 TRUNCATE TABLE users
#   36 0xD2978B45C67B47B5D73AC532EB40A95E  0.0311  0.0%      1 0.0311  0.00 TRUNCATE TABLE themes
#   37 0x9C697B3F0446BBF7602663588252F020  0.0293  0.0%      1 0.0293  0.00 TRUNCATE TABLE livestream_viewers_history
#   38 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0293  0.0%      1 0.0293  0.00 TRUNCATE TABLE icons
#   39 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0281  0.0%      1 0.0281  0.00 TRUNCATE TABLE reactions
#   40 0x2AAED5867123C749367FD8E4BBD796D2  0.0277  0.0%      1 0.0277  0.00 TRUNCATE TABLE livecomments
#   41 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  0.0253  0.0%      6 0.0042  0.00 SELECT livestreams
#   42 0x74232BDFFB94C567F0340DBE3285E458  0.0217  0.0%      1 0.0217  0.00 INSERT reactions
#   43 0x651E3772B8767A368CB47EE7389EEB33  0.0211  0.0%      9 0.0023  0.00 SELECT livestream_tags
#   44 0x2B760561C10B5D133155AA306D0F407C  0.0180  0.0%     25 0.0007  0.00 SELECT livecomments
#   45 0x8F7679D452333ED3C7D60D22131CEFD4  0.0177  0.0%   1205 0.0000  0.00 ADMIN RESET STMT
#   46 0x22279D81D51006139E0C76405B54C261  0.0084  0.0%     68 0.0001  0.00 SELECT domains domainmetadata
#   47 0x64CC8A4E8E4B390203375597CE4D611F  0.0079  0.0%      2 0.0039  0.00 SELECT ng_words
#   48 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0065  0.0%      9 0.0007  0.00 SELECT livestreams livecomments
#   49 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.0050  0.0%      4 0.0013  0.00 SELECT users livestreams reactions
#   50 0xF985E5835B84E84C7A721801818E98CE  0.0050  0.0%      4 0.0013  0.00 SELECT users livestreams reactions
#   51 0x19A1F14EFC0F221D30AFCB1E1344BEBD  0.0050  0.0%      3 0.0017  0.00 SELECT users
#   52 0x9E2DA589A20EC24C34E11DDE0FBF5564  0.0046  0.0%    100 0.0000  0.00 START
#   53 0x8F885091E23CB955C051B1204EE7D91D  0.0045  0.0%      9 0.0005  0.00 SELECT livestreams reactions
#   54 0x5D469B53C536D19CD15E40763ACC23C7  0.0036  0.0%     52 0.0001  0.00 INSERT livestream_tags
#   55 0x859BBB7E9D760686137A944406874C4D  0.0034  0.0%      2 0.0017  0.00 DELETE records
#   56 0x9AC623FA477E73A44D191D296850A025  0.0030  0.0%      4 0.0008  0.00 SELECT records
#   57 0xFFF66E9B3D962FA319C8068B5C1997CD  0.0027  0.0%     22 0.0001  0.00 ROLLBACK
#   58 0x394E66DDE2823A903078D4C0F235B948  0.0017  0.0%      9 0.0002  0.00 SELECT livestreams livecomment_reports
#   59 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0016  0.0%     25 0.0001  0.00 SELECT livestream_viewers_history
#   60 0x3F155F5E71EFF856F0CF7B8430DE8C23  0.0011  0.0%     12 0.0001  0.00 SELECT users
#   61 0x544239977D2094F805A7B062DE95673A  0.0011  0.0%      6 0.0002  0.00 SELECT tags
#   62 0xF085F31DC1964EA538732B713E4B4108  0.0010  0.0%      9 0.0001  0.00 SELECT livestreams livestream_viewers_history
#   63 0xC4625761E0CFD817F41B4802F152A489  0.0007  0.0%      1 0.0007  0.00 SELECT livecomments
#   64 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0007  0.0%      9 0.0001  0.00 SELECT
#   65 0x24C44C3518CE12293EF12410AEDA2393  0.0007  0.0%      4 0.0002  0.00 SELECT livestreams
#   66 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0007  0.0%      9 0.0001  0.00 SELECT tags
#   67 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0003  0.0%      4 0.0001  0.00 SELECT livecomments
#   68 0xE623383C5D789800DC0946925F90039F  0.0003  0.0%      3 0.0001  0.00 SELECT domains
#   69 0x64052B1C32B30DF53AB3292208B783B4  0.0003  0.0%      2 0.0001  0.00 INSERT users
#   70 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.0002  0.0%      6 0.0000  0.00 SET
#   71 0x5AEB6E4A781A3854CF642125E293FEE0  0.0002  0.0%      3 0.0001  0.00 INSERT reactions
#   72 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0002  0.0%      2 0.0001  0.00 INSERT livecomment_reports
#   73 0xE84E602C0D0858D5661956B70D72A215  0.0002  0.0%      1 0.0002  0.00 SELECT icons
#   74 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.0002  0.0%      2 0.0001  0.00 INSERT livecomments
#   75 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0002  0.0%      2 0.0001  0.00 INSERT livestream_viewers_history
#   76 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0001  0.0%      1 0.0001  0.00 DELETE livestream_viewers_history
#   77 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0001  0.0%      3 0.0000  0.00 BEGIN
#   78 0x8B2044ADAE690405979131C33185F22A  0.0001  0.0%      1 0.0001  0.00 SELECT users
#   79 0xEDBC971AEC392917AA353644DE4C4CB4  0.0000  0.0%     20 0.0000  0.00 ADMIN QUIT

# Query 1: 475.35 QPS, 0.34x concurrency, ID 0xFD38427AE3D09E3883A680F7BAF95D3A at byte 3223272
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:09:49 to 2023-11-25T04:11:44
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         14   54665
# Exec time     36     39s   259us    11ms   707us     2ms   600us   467us
# Lock time     45    93ms       0     2ms     1us     1us    17us     1us
# Rows sent     32  53.38k       1       1       1       1       0       1
# Rows examine  45  52.27M    1001    1003 1002.73  964.41    0.00  964.41
# Query size    26   6.25M     117     120  119.92  118.34    0.48  118.34
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us  ################################################################
#   1ms  #################
#  10ms  #
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'livestreams'\G
#    SHOW CREATE TABLE `livestreams`\G
#    SHOW TABLE STATUS LIKE 'livecomments'\G
#    SHOW CREATE TABLE `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 = 2971\G

# Query 2: 475.34 QPS, 0.29x concurrency, ID 0xC499D81D570D361DB61FC43A94BB888A at byte 3223837
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:09:49 to 2023-11-25T04:11:44
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         14   54664
# Exec time     31     33s   219us    10ms   606us     2ms   522us   403us
# Lock time     46    95ms       0     2ms     1us     1us    18us     1us
# Rows sent     32  53.38k       1       1       1       1       0       1
# Rows examine  45  52.32M    1001    1004 1003.59  964.41       0  964.41
# Query size    21   5.26M      98     101  100.92   97.36       0   97.36
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us  ################################################################
#   1ms  ###############
#  10ms  #
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'livestreams'\G
#    SHOW CREATE TABLE `livestreams`\G
#    SHOW TABLE STATUS LIKE 'reactions'\G
#    SHOW CREATE TABLE `reactions`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM livestreams l INNER JOIN reactions r ON l.id = r.livestream_id WHERE l.id = 2963\G

# Query 3: 1.04k QPS, 0.13x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 3234000
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:09:49 to 2023-11-25T04:11:46
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         32  121717
# Exec time     14     16s    30us    11ms   128us   445us   205us    63us
# Lock time      0     2us       0     2us       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    14   3.48M      30      30      30      30       0      30
# String:
# Hosts        localhost
# Users        isucon (121692/99%), isudns (25/0%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ####################
#   1ms  #
#  10ms  #
# 100ms
#    1s
#  10s+
administrator command: Prepare\G

# Query 4: 111.11 QPS, 0.48x concurrency, ID 0xDFFCC1D78939C4D781C7C58349101F50 at byte 63458216
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:11:14 to 2023-11-25T04:11:23
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    1000
# Exec time      4      4s     2ms    12ms     4ms     6ms   712us     4ms
# Lock time      0     1ms       0    19us     1us     1us       0     1us
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine   0       0       0       0       0       0       0       0
# Query size     1 401.18k     192     463  410.81  420.77   16.87  400.73
# String:
# 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
INSERT INTO users (id, name, display_name, description, password) VALUES (646, 'hiroshiendo0', '感慨', '普段営業をしています。\nよろしくおねがいします！\n\n連絡は以下からお願いします。\n\nウェブサイト: http://hiroshiendo.example.com/\nメールアドレス: hiroshiendo@example.com\n', '$2a$04$UwZb6IFm4tgS1pLvujdaV.sK3Gq9zN2IJyIuGjqtMyuSL/dZXfqjK')\G

# Query 5: 31.31 QPS, 0.13x concurrency, ID 0xD2A0864774622BA36F6557496405CF75 at byte 63254210
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:11:14 to 2023-11-25T04:11:46
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    1002
# Exec time      4      4s    64us     9ms     4ms     6ms   696us     4ms
# Lock time      0     1ms       0    11us     1us     1us       0     1us
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine   0       0       0       0       0       0       0       0
# Query size     0  57.12k      55      60   58.38   56.92    0.21   56.92
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  #
# 100us
#   1ms  ################################################################
#  10ms
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'themes'\G
#    SHOW CREATE TABLE `isupipe`.`themes`\G
INSERT INTO themes (user_id, dark_mode) VALUES (429, true)\G