search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu1 (21,743) #37

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)
11945 0 11942 0 3 0 GET /api/user/[a-zA-Z0-9]+/icon 0.004 0.148 182.400 0.015 0.032 0.044 0.080 0.015 0.000 164797.000 722188014.000 60459.440
1283 0 1280 0 3 0 GET /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 0.464 137.540 0.107 0.204 0.252 0.372 0.076 0.000 89863.000 22807556.000 17776.739
1314 0 1314 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.460 123.568 0.094 0.188 0.228 0.336 0.073 3.000 84330.000 19645654.000 14951.030
388 0 384 0 3 1 POST /api/register 0.004 0.368 81.688 0.211 0.276 0.292 0.340 0.055 0.000 522.000 180192.000 464.412
1640 0 1630 0 10 0 POST /api/livestream/[a-zA-Z0-9]+/livecomment 0.024 0.200 77.084 0.047 0.072 0.088 0.116 0.021 0.000 2688.000 3173273.000 1934.923
908 0 907 0 1 0 GET /api/livestream/[a-zA-Z0-9]+$ 0.004 1.708 60.036 0.066 0.072 0.088 1.352 0.189 0.000 143829.000 57816358.000 63674.403
292 0 288 0 4 0 POST /api/livestream/[a-zA-Z0-9]+$ 0.040 0.388 42.276 0.145 0.224 0.252 0.332 0.067 0.000 1453.000 335260.000 1148.151
1183 0 1183 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.156 38.960 0.033 0.052 0.064 0.088 0.016 1552.000 2193.000 2193861.000 1854.489
516 0 516 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/moderate 0.012 0.380 38.376 0.074 0.140 0.164 0.268 0.050 23.000 23.000 11868.000 23.000
1192 0 1155 0 2 35 GET /api/livestream/[a-zA-Z0-9]+/report 0.004 0.200 26.648 0.022 0.040 0.052 0.096 0.017 0.000 8376.000 172746.000 144.921
680 0 680 0 0 0 GET /api/livestream$ 0.004 0.192 21.924 0.032 0.052 0.068 0.108 0.020 3.000 22370.000 1357076.000 1995.700
862 0 862 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/ngwords 0.004 0.120 16.788 0.019 0.040 0.052 0.084 0.016 5.000 1173.000 191507.000 222.166
1 0 1 0 0 0 POST /api/initialize 10.364 10.364 10.364 10.364 10.364 10.364 10.364 0.000 27.000 27.000 27.000 27.000
392 0 390 0 2 0 POST /api/login 0.004 0.104 7.028 0.018 0.032 0.044 0.080 0.014 0.000 64.000 128.000 0.327
283 0 283 0 0 0 GET /api/tag 0.004 0.124 5.264 0.019 0.036 0.044 0.084 0.016 6089.000 6095.000 1724753.000 6094.534
407 0 407 0 0 0 POST /api/icon 0.008 0.080 3.300 0.008 0.016 0.020 0.028 0.006 14.000 14.000 5698.000 14.000
115 0 115 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/enter 0.004 0.124 2.736 0.024 0.044 0.064 0.124 0.020 0.000 0.000 0.000 0.000
107 0 107 0 0 0 DELETE /api/livestream/[a-zA-Z0-9]+/exit 0.004 0.092 2.516 0.024 0.044 0.052 0.068 0.015 0.000 0.000 0.000 0.000
16 0 16 0 0 0 GET /api/user/[a-zA-Z0-9]+/statistics 0.036 0.192 1.552 0.097 0.140 0.192 0.192 0.039 133.000 156.000 2265.000 141.562
7 0 7 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/statistics 0.016 0.108 0.504 0.072 0.108 0.108 0.108 0.036 100.000 104.000 719.000 102.714
14 0 14 0 0 0 GET /api/user/[a-zA-Z0-9]+/livestream 0.016 0.048 0.460 0.033 0.048 0.048 0.048 0.011 1251.000 8805.000 58462.000 4175.857
15 0 15 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.004 0.060 0.320 0.021 0.056 0.060 0.060 0.017 38.000 38.000 570.000 38.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.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 21.000 21.000 21.000 21.000
1 0 1 0 0 0 GET / 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 396.000 396.000 396.000 396.000
github-actions[bot] commented 10 months ago 
Reading from STDIN ...

# 6.6s user time, 30ms system time, 29.12M rss, 35.15M vsz
# Current date: Sat Nov 25 08:27:31 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 105.98k total, 15 unique, 1.34k QPS, 1.64x concurrency ________
# Time range: 2023-11-25T08:25:22 to 2023-11-25T08:26:41
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           130s     1us    51ms     1ms     6ms     2ms   131us
# Lock time          503ms       0    34ms     4us     1us   231us       0
# Rows sent          9.37k       0       1    0.09    0.99    0.28       0
# Rows examine      37.03M       0   1.66k  366.36   1.53k  625.51       0
# Query size         7.90M       5     222   78.18  151.03   48.33   31.70

# Profile
# Rank Query ID                           Response time Calls R/Call V/M  
# ==== ================================== ============= ===== ====== =====
#    1 0x42EF7D7D98FBCC9723BF896EBFC51D24 58.9487 45.4% 14373 0.0041  0.00 SELECT records
#    2 0x3D83BC87F3B3A00D571FFC8104A6E50C 40.7616 31.4% 10718 0.0038  0.00 SELECT records
#    3 0x22279D81D51006139E0C76405B54C261 10.3957  8.0% 22264 0.0005  0.00 SELECT domains domainmetadata
#    4 0x8F7679D452333ED3C7D60D22131CEFD4  7.6641  5.9% 48651 0.0002  0.00 ADMIN RESET STMT
#    5 0x859BBB7E9D760686137A944406874C4D  4.1873  3.2%   386 0.0108  0.00 DELETE records
#    6 0xFFFCA4D67EA0A788813031B8BBC3B329  3.9850  3.1%   387 0.0103  0.00 COMMIT
#    7 0x9AC623FA477E73A44D191D296850A025  2.8288  2.2%   772 0.0037  0.00 SELECT records
#    8 0xDA556F9115773A1A99AA0165670CE848  0.4912  0.4%  2329 0.0002  0.00 ADMIN PREPARE
#    9 0x77FB9E134D073862D1E78FEEC3436291  0.3623  0.3%  1666 0.0002  0.00 INSERT records
#   10 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.0905  0.1%   774 0.0001  0.00 SET
#   11 0xE623383C5D789800DC0946925F90039F  0.0879  0.1%   387 0.0002  0.00 SELECT domains
#   12 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0334  0.0%   387 0.0001  0.00 BEGIN
#   13 0x07890000813C4CC7111FD2D3F3B3B4EB  0.0235  0.0%  2320 0.0000  0.00 ADMIN CLOSE STMT
#   14 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0148  0.0%     1 0.0148  0.00 DELETE records
#   15 0xEDBC971AEC392917AA353644DE4C4CB4  0.0014  0.0%   561 0.0000  0.00 ADMIN QUIT

# Query 1: 181.94 QPS, 0.75x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 18333815
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T08:25:22 to 2023-11-25T08:26:41
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         13   14373
# Exec time     45     59s   732us    34ms     4ms     9ms     3ms     3ms
# Lock time      6    32ms       0     3ms     2us     1us    41us     1us
# Rows sent     34   3.24k       0       1    0.23    0.99    0.42       0
# Rows examine  54  20.27M   1.25k   1.66k   1.44k   1.53k  108.58   1.39k
# Query size    24   1.94M     129     222  141.64  158.58   11.52  136.99
# String:
# Hosts        localhost
# Users        isudns
# Query_time distribution
#   1us
#  10us
# 100us  #
#   1ms  ################################################################
#  10ms  ###
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'records'\G
#    SHOW CREATE TABLE `records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name='simrxynxrz4jerjw9iftr0.u.isucon.dev' and domain_id=3\G

# Query 2: 135.67 QPS, 0.52x concurrency, ID 0x3D83BC87F3B3A00D571FFC8104A6E50C at byte 28640079
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T08:25:22 to 2023-11-25T08:26:41
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         10   10718
# Exec time     31     41s   692us    26ms     4ms     9ms     3ms     3ms
# Lock time      4    23ms       0     3ms     2us     1us    32us     1us
# Rows sent     57   5.37k       0       1    0.51    0.99    0.50    0.99
# Rows examine  40  15.13M   1.25k   1.66k   1.45k   1.53k  108.74   1.39k
# Query size    17   1.38M     126     221  135.14  151.03   10.89  124.25
# String:
# Hosts        localhost
# Users        isudns
# Query_time distribution
#   1us
#  10us
# 100us  #
#   1ms  ################################################################
#  10ms  ##
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'records'\G
#    SHOW CREATE TABLE `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='5d3uf01apzef0.u.isucon.dev'\G

# Query 3: 281.82 QPS, 0.13x concurrency, ID 0x22279D81D51006139E0C76405B54C261 at byte 27232206
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T08:25:22 to 2023-11-25T08:26:41
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         21   22264
# Exec time      8     10s    84us    17ms   466us     2ms   852us   167us
# Lock time     15    80ms       0    12ms     3us     1us    94us     1us
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine   0       0       0       0       0       0       0       0
# Query size    30   2.42M     114     114     114     114       0     114
# String:
# Hosts        localhost
# Users        isudns
# Query_time distribution
#   1us
#  10us  #
# 100us  ################################################################
#   1ms  #######
#  10ms  #
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'domains'\G
#    SHOW CREATE TABLE `domains`\G
#    SHOW TABLE STATUS LIKE 'domainmetadata'\G
#    SHOW CREATE TABLE `domainmetadata`\G
# EXPLAIN /*!50100 PARTITIONS*/
select kind,content from domains, domainmetadata where domainmetadata.domain_id=domains.id and name='u.isucon.dev'\G

# Query 4: 615.84 QPS, 0.10x concurrency, ID 0x8F7679D452333ED3C7D60D22131CEFD4 at byte 21919128
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T08:25:22 to 2023-11-25T08:26:41
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         45   48651
# Exec time      5      8s     9us    21ms   157us   626us   537us    42us
# 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    19   1.53M      33      33      33      33       0      33
# String:
# Hosts        localhost
# Users        isudns
# Query_time distribution
#   1us  #
#  10us  ################################################################
# 100us  ############
#   1ms  ##
#  10ms  #
# 100ms
#    1s
#  10s+
administrator command: Reset stmt\G

# Query 5: 5.59 QPS, 0.06x concurrency, ID 0x859BBB7E9D760686137A944406874C4D at byte 28662408
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T08:25:32 to 2023-11-25T08:26:41
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     386
# Exec time      3      4s     2ms    51ms    11ms    23ms     7ms    10ms
# Lock time     72   366ms       0    34ms   947us     7ms     4ms     1us
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine   1 555.05k   1.25k   1.63k   1.44k   1.53k  110.91   1.39k
# Query size     0  32.24k      78      93   85.53   88.31    3.41   84.10
# String:
# Hosts        localhost
# Users        isudns
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ###############################################################
#  10ms  ################################################################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'records'\G
#    SHOW CREATE TABLE `records`\G
delete from records where domain_id=3 and name='skimura0.u.isucon.dev' and type='A'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from  records where domain_id=3 and name='skimura0.u.isucon.dev' and type='A'\G