search

saza-ku / isucon13

0 stars 0 forks source link

11250212 #5

Open saza-ku opened 1 year ago

saza-ku commented 1 year ago

isucon3

alp

+-------+--------+-----+-----+-----+-----+-----+-----+
| COUNT | METHOD | URI | MIN | MAX | SUM | AVG | P99 |
+-------+--------+-----+-----+-----+-----+-----+-----+
+-------+--------+-----+-----+-----+-----+-----+-----+

slow query

explain

Reading from STDIN ...

# No events processed.

netdata

http://localhost:19993/#menu_services;after=1700878309252;before=1700878389259

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon3/pprof/11250211
saza-ku commented 1 year ago

isucon2

alp

+-------+--------+-----+-----+-----+-----+-----+-----+
| COUNT | METHOD | URI | MIN | MAX | SUM | AVG | P99 |
+-------+--------+-----+-----+-----+-----+-----+-----+
+-------+--------+-----+-----+-----+-----+-----+-----+

slow query

explain

Reading from STDIN ...

# No events processed.

netdata

http://localhost:19992/#menu_services;after=1700878309249;before=1700878389257

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon2/pprof/11250211
saza-ku commented 1 year ago

isucon1

alp

+-------+--------+--------------------------------+-------+--------+---------+--------+--------+
| COUNT | METHOD |              URI               |  MIN  |  MAX   |   SUM   |  AVG   |  P99   |
+-------+--------+--------------------------------+-------+--------+---------+--------+--------+
| 9     | GET    | /api/livestream/.+/statistics  | 0.000 | 29.981 | 176.606 | 19.623 | 29.981 |
| 4     | GET    | /api/livestream/.+/reaction    | 0.004 | 11.336 | 11.348  | 2.837  | 11.336 |
| 4     | GET    | /api/livestream/.+/livecomment | 0.004 | 0.012  | 0.020   | 0.005  | 0.012  |
| 1     | GET    | /api/livestream/.+             | 0.004 | 0.004  | 0.004   | 0.004  | 0.004  |
+-------+--------+--------------------------------+-------+--------+---------+--------+--------+

slow query

Count: 76141  Time=0.00s (22s)  Lock=0.00s (0s)  Rows=0.5 (38060), isucon[isucon]@localhost
  #

Count: 19030  Time=0.00s (18s)  Lock=0.00s (0s)  Rows=1.0 (19030), isucon[isucon]@localhost
  SELECT IFNULL(SUM(l2.tip), N) FROM livestreams l INNER JOIN livecomments l2 ON l.id = l2.livestream_id WHERE l.id = N

Count: 19027  Time=0.00s (15s)  Lock=0.00s (0s)  Rows=1.0 (19026), isucon[isucon]@localhost
  SELECT COUNT(*) FROM livestreams l INNER JOIN reactions r ON l.id = r.livestream_id WHERE l.id = N

Count: 1  Time=13.77s (13s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  TRUNCATE TABLE reactions

Count: 279  Time=0.00s (1s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  INSERT INTO users (id, name, display_name, description, password) VALUES (N, 'S', 'S', 'S', 'S')

Count: 151  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  INSERT INTO themes (user_id, dark_mode) VALUES (N, false)

Count: 128  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  INSERT INTO themes (user_id, dark_mode) VALUES (N, true)

Count: 1  Time=0.08s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  TRUNCATE TABLE icons

Count: 1  Time=0.05s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  TRUNCATE TABLE tags

Count: 1  Time=0.05s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  TRUNCATE TABLE users

explain

Reading from STDIN ...

# 8.1s user time, 90ms system time, 40.78M rss, 55.44M vsz
# Current date: Sat Nov 25 02:13:15 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 116.41k total, 40 unique, 4.48k QPS, 3.16x concurrency ________
# Time range: 2023-11-25T02:12:49 to 2023-11-25T02:13:15
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            82s     1us     14s   705us     2ms    51ms    93us
# Lock time           74ms       0     2ms       0     1us    10us       0
# Rows sent         44.50k       0   7.32k    0.39    0.99   21.94       0
# Rows examine      36.34M       0   7.32k  327.31  964.41  452.88       0
# Query size         8.85M       6   1.94M   79.71  118.34   5.58k   31.70

# Profile
# Rank Query ID                     Response time Calls R/Call  V/M   Item
# ==== ============================ ============= ===== ======= ===== ====
#    1 0xDA556F9115773A1A99AA016... 22.2774 27.1% 38073  0.0006  5.89 ADMIN PREPARE
#    2 0xFD38427AE3D09E3883A680F... 18.4450 22.5% 19030  0.0010  0.00 SELECT livestreams livecomments
#    3 0xC499D81D570D361DB61FC43... 15.6466 19.1% 19027  0.0008  0.00 SELECT livestreams reactions
#    4 0xFB296F703ACC41C3F94A9B7... 13.7675 16.8%     1 13.7675  0.00 TRUNCATE TABLE reactions
# MISC 0xMISC                       11.9514 14.6% 40282  0.0003   0.0 <36 ITEMS>

# Query 1: 1.46k QPS, 0.86x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 30058253
# This item is included in the report because it matches --limit.
# Scores: V/M = 5.89
# Time range: 2023-11-25T02:12:49 to 2023-11-25T02:13:15
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         32   38073
# Exec time     27     22s    30us     11s   585us   690us    59ms    89us
# Lock time      0    17us       0     7us       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   1.09M      30      30      30      30       0      30
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ####################################################
#   1ms  ##
#  10ms  #
# 100ms
#    1s  #
#  10s+  #
administrator command: Prepare\G

# Query 2: 1.36k QPS, 1.32x concurrency, ID 0xFD38427AE3D09E3883A680F7BAF95D3A at byte 22046535
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T02:12:49 to 2023-11-25T02:13:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         16   19030
# Exec time     22     18s   261us    14ms   969us     2ms   693us   596us
# Lock time     49    37ms       0     2ms     1us     1us    19us     1us
# Rows sent     41  18.58k       1       1       1       1       0       1
# Rows examine  49  18.17M    1001    1001    1001    1001       0    1001
# Query size    24   2.18M     120     120     120     120       0     120
# 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 = 5270\G
# *************************** 1. row ***************************
#            id: 1
#   select_type: SIMPLE
#         table: l
#    partitions: NULL
#          type: const
# possible_keys: PRIMARY
#           key: PRIMARY
#       key_len: 8
#           ref: const
#          rows: 1
#      filtered: 100.00
#         Extra: Using index
# *************************** 2. row ***************************
#            id: 1
#   select_type: SIMPLE
#         table: l2
#    partitions: NULL
#          type: ALL
# possible_keys: NULL
#           key: NULL
#       key_len: NULL
#           ref: NULL
#          rows: 1
#      filtered: 100.00
#         Extra: Using where

# Query 3: 1.36k QPS, 1.12x concurrency, ID 0xC499D81D570D361DB61FC43A94BB888A at byte 8208858
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T02:12:49 to 2023-11-25T02:13:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         16   19027
# Exec time     19     16s   135us    13ms   822us     2ms   602us   515us
# Lock time     46    35ms       0     1ms     1us     1us    17us     1us
# Rows sent     41  18.58k       0       1    1.00    0.99    0.01    0.99
# Rows examine  49  18.16M       0    1001 1000.95  964.41    6.99  964.41
# Query size    20   1.83M      98     101  101.00   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 
SELECT COUNT(*) FROM livestreams l INNER JOIN reactions r ON l.id = r.livestream_id WHERE l.id = 3820\G
# *************************** 1. row ***************************
#            id: 1
#   select_type: SIMPLE
#         table: l
#    partitions: NULL
#          type: const
# possible_keys: PRIMARY
#           key: PRIMARY
#       key_len: 8
#           ref: const
#          rows: 1
#      filtered: 100.00
#         Extra: Using index
# *************************** 2. row ***************************
#            id: 1
#   select_type: SIMPLE
#         table: r
#    partitions: NULL
#          type: ALL
# possible_keys: NULL
#           key: NULL
#       key_len: NULL
#           ref: NULL
#          rows: 1
#      filtered: 100.00
#         Extra: Using where

# Query 4: 0 QPS, 0x concurrency, ID 0xFB296F703ACC41C3F94A9B7D75044F3C at byte 30057792
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0       1
# Exec time     16     14s     14s     14s     14s     14s       0     14s
# Lock time      0     9us     9us     9us     9us     9us       0     9us
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine   0       0       0       0       0       0       0       0
# Query size     0      24      24      24      24      24       0      24
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+  ################################################################
# Tables
#    SHOW TABLE STATUS LIKE 'reactions'\G
#    SHOW CREATE TABLE `reactions`\G
TRUNCATE TABLE reactions\G

netdata

http://localhost:19991/#menu_services;after=1700878309343;before=1700878385432

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon1/pprof/11250211
saza-ku commented 1 year ago

isucon2

alp

+-------+--------+-----+-----+-----+-----+-----+-----+
| COUNT | METHOD | URI | MIN | MAX | SUM | AVG | P99 |
+-------+--------+-----+-----+-----+-----+-----+-----+
+-------+--------+-----+-----+-----+-----+-----+-----+

slow query

Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), isucon[isucon]@localhost
  SHOW VARIABLES LIKE 'S'

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), isucon[isucon]@localhost
  SELECT @@SQL_MODE

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  SET @@SQL_QUOTE_SHOW_CREATE = N/*!N, @@SQL_MODE='S'*/

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  SET SESSION wait_timeout=N

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  SET NAMES 'S'

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), isucon[isucon]@localhost
  SELECT VERSION()

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  #

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), 0users@0hosts
  administrator command: Quit

explain

Reading from STDIN ...

# 150ms user time, 0 system time, 36.12M rss, 50.49M vsz
# Current date: Sat Nov 25 02:13:35 2023
# Hostname: ip-192-168-0-12
# Files: STDIN
# Overall: 8 total, 7 unique, 0 QPS, 0x concurrency ______________________
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            9ms     2us     6ms     1ms     6ms     2ms   616us
# Lock time            5us       0     4us       0     3us     1us       0
# Rows sent              4       0       1    0.50    0.99    0.50    0.99
# Rows examine           4       0       1    0.50    0.99    0.50    0.99
# Query size           381      16     195   47.62  192.76   55.83   31.85

# Profile
# Rank Query ID                          Response time Calls R/Call V/M   
# ==== ================================= ============= ===== ====== ===== 
#    1 0xE77769C62EF669AA7DD5F6760F2D...  0.0077 84.0%     2 0.0038  0.00 SHOW VARIABLES
#    2 0xDFB7062963B5842FD3F15165B890...  0.0013 14.0%     1 0.0013  0.00 SELECT
#    3 0xEC21548748A08C1CDA69864C6215...  0.0001  0.6%     1 0.0001  0.00 SET
#    4 0x9B758E42947B8A0DAD312D56C6B3...  0.0001  0.6%     1 0.0001  0.00 SET
# MISC 0xMISC                             0.0001  0.9%     3 0.0000   0.0 <3 ITEMS>

# Query 1: 0 QPS, 0x concurrency, ID 0xE77769C62EF669AA7DD5F6760F2D2EBB at byte 0
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         25       2
# Exec time     83     8ms     1ms     6ms     4ms     6ms     4ms     4ms
# Lock time    100     5us     1us     4us     2us     4us     2us     2us
# Rows sent     50       2       1       1       1       1       0       1
# Rows examine  50       2       1       1       1       1       0       1
# Query size    20      77      35      42   38.50      42    4.95   38.50
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ################################################################
#  10ms
# 100ms
#    1s
#  10s+
SHOW VARIABLES LIKE 'wait\_timeout'\G

# Query 2: 0 QPS, 0x concurrency, ID 0xDFB7062963B5842FD3F15165B8904806 at byte 452
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time     14     1ms     1ms     1ms     1ms     1ms       0     1ms
# Lock time      0       0       0       0       0       0       0       0
# Rows sent     25       1       1       1       1       1       0       1
# Rows examine  25       1       1       1       1       1       0       1
# Query size     4      17      17      17      17      17       0      17
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ################################################################
#  10ms
# 100ms
#    1s
#  10s+
# EXPLAIN /*!50100 PARTITIONS*/
SELECT @@SQL_MODE\G
# *************************** 1. row ***************************
#            id: 1
#   select_type: SIMPLE
#         table: NULL
#    partitions: NULL
#          type: NULL
# possible_keys: NULL
#           key: NULL
#       key_len: NULL
#           ref: NULL
#          rows: NULL

# Query 3: 0 QPS, 0x concurrency, ID 0xEC21548748A08C1CDA69864C6215FEDB at byte 662
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      0    54us    54us    54us    54us    54us       0    54us
# 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    51     195     195     195     195     195       0     195
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'*/\G

# Query 4: 0 QPS, 0x concurrency, ID 0x9B758E42947B8A0DAD312D56C6B3D880 at byte 229
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      0    51us    51us    51us    51us    51us       0    51us
# 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     7      30      30      30      30      30       0      30
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
SET SESSION wait_timeout=10000\G

netdata

http://localhost:19992/#menu_services;after=1700878335718;before=1700878415725

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon2/pprof/11250212
saza-ku commented 1 year ago

isucon3

alp

+-------+--------+-----+-----+-----+-----+-----+-----+
| COUNT | METHOD | URI | MIN | MAX | SUM | AVG | P99 |
+-------+--------+-----+-----+-----+-----+-----+-----+
+-------+--------+-----+-----+-----+-----+-----+-----+

slow query

Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), isucon[isucon]@localhost
  SHOW VARIABLES LIKE 'S'

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), isucon[isucon]@localhost
  SELECT @@SQL_MODE

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  SET @@SQL_QUOTE_SHOW_CREATE = N/*!N, @@SQL_MODE='S'*/

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  SET SESSION wait_timeout=N

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  SET NAMES 'S'

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), isucon[isucon]@localhost
  SELECT VERSION()

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  #

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), 0users@0hosts
  administrator command: Quit

explain

Reading from STDIN ...

# 130ms user time, 10ms system time, 36.12M rss, 50.49M vsz
# Current date: Sat Nov 25 02:13:35 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 8 total, 7 unique, 0 QPS, 0x concurrency ______________________
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            8ms     3us     7ms     1ms     6ms     2ms   424us
# Lock time            4us       0     3us       0     2us       0       0
# Rows sent              4       0       1    0.50    0.99    0.50    0.99
# Rows examine           4       0       1    0.50    0.99    0.50    0.99
# Query size           381      16     195   47.62  192.76   55.83   31.85

# Profile
# Rank Query ID                          Response time Calls R/Call V/M   
# ==== ================================= ============= ===== ====== ===== 
#    1 0xE77769C62EF669AA7DD5F6760F2D...  0.0075 88.6%     2 0.0038  0.00 SHOW VARIABLES
#    2 0xDFB7062963B5842FD3F15165B890...  0.0008  9.4%     1 0.0008  0.00 SELECT
#    3 0xEC21548748A08C1CDA69864C6215...  0.0001  0.6%     1 0.0001  0.00 SET
#    4 0x9B758E42947B8A0DAD312D56C6B3...  0.0000  0.5%     1 0.0000  0.00 SET
# MISC 0xMISC                             0.0001  0.9%     3 0.0000   0.0 <3 ITEMS>

# Query 1: 0 QPS, 0x concurrency, ID 0xE77769C62EF669AA7DD5F6760F2D2EBB at byte 0
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         25       2
# Exec time     88     8ms     1ms     7ms     4ms     7ms     4ms     4ms
# Lock time    100     4us     1us     3us     2us     3us     1us     2us
# Rows sent     50       2       1       1       1       1       0       1
# Rows examine  50       2       1       1       1       1       0       1
# Query size    20      77      35      42   38.50      42    4.95   38.50
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ################################################################
#  10ms
# 100ms
#    1s
#  10s+
SHOW VARIABLES LIKE 'wait\_timeout'\G

# Query 2: 0 QPS, 0x concurrency, ID 0xDFB7062963B5842FD3F15165B8904806 at byte 452
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      9   800us   800us   800us   800us   800us       0   800us
# Lock time      0       0       0       0       0       0       0       0
# Rows sent     25       1       1       1       1       1       0       1
# Rows examine  25       1       1       1       1       1       0       1
# Query size     4      17      17      17      17      17       0      17
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us  ################################################################
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
# EXPLAIN /*!50100 PARTITIONS*/
SELECT @@SQL_MODE\G
# *************************** 1. row ***************************
#            id: 1
#   select_type: SIMPLE
#         table: NULL
#    partitions: NULL
#          type: NULL
# possible_keys: NULL
#           key: NULL
#       key_len: NULL
#           ref: NULL
#          rows: NULL

# Query 3: 0 QPS, 0x concurrency, ID 0xEC21548748A08C1CDA69864C6215FEDB at byte 662
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      0    52us    52us    52us    52us    52us       0    52us
# 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    51     195     195     195     195     195       0     195
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'*/\G

# Query 4: 0 QPS, 0x concurrency, ID 0x9B758E42947B8A0DAD312D56C6B3D880 at byte 229
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T02:13:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      0    43us    43us    43us    43us    43us       0    43us
# 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     7      30      30      30      30      30       0      30
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
SET SESSION wait_timeout=10000\G

netdata

http://localhost:19993/#menu_services;after=1700878335718;before=1700878415725

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon3/pprof/11250212