11250647 - Githubissues

saza-ku / isucon13

0 stars 0 forks source link

11250647 #65

Open saza-ku opened 10 months ago

saza-ku commented 10 months ago

isucon1

alp

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

slow query

explain

Reading from STDIN ...

# No events processed.

netdata

http://localhost:19991/#menu_services;after=1700894803112;before=1700894879201

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon1/pprof/11250646

saza-ku commented 10 months 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=1700894803118;before=1700894883125

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon2/pprof/11250646

saza-ku commented 10 months 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=1700894803117;before=1700894883124

pprof

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

saza-ku commented 10 months ago

isucon1

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=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=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 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 ...

# 140ms user time, 0 system time, 36.00M rss, 50.43M vsz
# Current date: Sat Nov 25 06:48:12 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 8 total, 7 unique, 0 QPS, 0x concurrency ______________________
# Time range: all events occurred at 2023-11-25T06:47:59
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            3ms     2us     2ms   338us     2ms   533us    42us
# Lock time            3us       0     2us       0     1us       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.0025 92.6%     2 0.0013  0.00 SHOW VARIABLES
#    2 0xEC21548748A08C1CDA69864C6215...  0.0000  1.6%     1 0.0000  0.00 SET
#    3 0xDFB7062963B5842FD3F15165B890...  0.0000  1.6%     1 0.0000  0.00 SELECT
#    4 0x9B758E42947B8A0DAD312D56C6B3...  0.0000  1.6%     1 0.0000  0.00 SET
# MISC 0xMISC                             0.0001  2.6%     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-25T06:47:59
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         25       2
# Exec time     92     3ms   938us     2ms     1ms     2ms   444us     1ms
# Lock time    100     3us     1us     2us     1us     2us       0     1us
# 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 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-25T06:47:59
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    44us    44us    44us    44us    44us       0    44us
# 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 3: 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-25T06:47:59
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    43us    43us    43us    43us    43us       0    43us
# 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 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-25T06:47:59
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    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:19991/#menu_services;after=1700894816769;before=1700894892727

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon1/pprof/11250646

saza-ku commented 10 months 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 SESSION wait_timeout=N

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 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.00M rss, 50.42M vsz
# Current date: Sat Nov 25 06:48:16 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-25T06:48:03
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            3ms     3us     2ms   339us     2ms   538us    44us
# Lock time            3us       0     2us       0     1us       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.0025 92.2%     2 0.0013  0.00 SHOW VARIABLES
#    2 0xEC21548748A08C1CDA69864C6215...  0.0000  1.7%     1 0.0000  0.00 SET
#    3 0xDFB7062963B5842FD3F15165B890...  0.0000  1.7%     1 0.0000  0.00 SELECT
#    4 0x9B758E42947B8A0DAD312D56C6B3...  0.0000  1.7%     1 0.0000  0.00 SET
# MISC 0xMISC                             0.0001  2.8%     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-25T06:48:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         25       2
# Exec time     92     3ms   986us     2ms     1ms     2ms   378us     1ms
# Lock time    100     3us     1us     2us     1us     2us       0     1us
# 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 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-25T06:48:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    45us    45us    45us    45us    45us       0    45us
# 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 3: 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-25T06:48:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    45us    45us    45us    45us    45us       0    45us
# 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 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-25T06:48:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    45us    45us    45us    45us    45us       0    45us
# 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=1700894816772;before=1700894896778

pprof

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

saza-ku commented 10 months 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=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=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 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.43M vsz
# Current date: Sat Nov 25 06:48:16 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-25T06:48:03
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            3ms     2us     2ms   345us     2ms   539us    44us
# Lock time            2us       0     1us       0     1us       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.0026 92.4%     2 0.0013  0.00 SHOW VARIABLES
#    2 0xEC21548748A08C1CDA69864C6215...  0.0000  1.7%     1 0.0000  0.00 SET
#    3 0xDFB7062963B5842FD3F15165B890...  0.0000  1.6%     1 0.0000  0.00 SELECT
#    4 0x9B758E42947B8A0DAD312D56C6B3...  0.0000  1.6%     1 0.0000  0.00 SET
# MISC 0xMISC                             0.0001  2.8%     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-25T06:48:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         25       2
# Exec time     92     3ms     1ms     2ms     1ms     2ms   381us     1ms
# Lock time    100     2us     1us     1us     1us     1us       0     1us
# 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 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-25T06:48:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    46us    46us    46us    46us    46us       0    46us
# 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 3: 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-25T06:48:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    45us    45us    45us    45us    45us       0    45us
# 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 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-25T06:48:03
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         12       1
# Exec time      1    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:19992/#menu_services;after=1700894816770;before=1700894896777

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon2/pprof/11250646

saza-ku commented 10 months ago

isucon1

alp

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

slow query

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

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

Count: 2  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: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), isucon[isucon]@localhost
  SELECT @@SQL_MODE

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

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

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

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

Count: 2  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.55M vsz
# Current date: Sat Nov 25 06:48:17 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 18 total, 8 unique, 1.38 QPS, 0.00x concurrency _______________
# Time range: 2023-11-25T06:47:59 to 2023-11-25T06:48:12
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            6ms     2us     2ms   305us     2ms   510us    42us
# Lock time            5us       0     2us       0     1us       0       0
# Rows sent             10       0       1    0.56    0.99    0.49    0.99
# Rows examine           8       0       1    0.44    0.99    0.49       0
# Query size           812      16     195   45.11  192.76   53.08   26.08

# Profile
# Rank Query ID                          Response time Calls R/Call V/M   
# ==== ================================= ============= ===== ====== ===== 
#    1 0xE77769C62EF669AA7DD5F6760F2D...  0.0050 90.9%     4 0.0013  0.00 SHOW VARIABLES
#    2 0x23910029062B79B8B93065026BA2...  0.0001  1.8%     2 0.0000  0.00 SELECT
#    3 0xEC21548748A08C1CDA69864C6215...  0.0001  1.6%     2 0.0000  0.00 SET
#    4 0xDFB7062963B5842FD3F15165B890...  0.0001  1.6%     2 0.0000  0.00 SELECT
# MISC 0xMISC                             0.0002  4.1%     8 0.0000   0.0 <4 ITEMS>

# Query 1: 0.31 QPS, 0.00x concurrency, ID 0xE77769C62EF669AA7DD5F6760F2D2EBB at byte 0
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:47:59 to 2023-11-25T06:48:12
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         22       4
# Exec time     90     5ms   938us     2ms     1ms     2ms   291us     2ms
# Lock time    100     5us     1us     2us     1us     1us       0     1us
# Rows sent     40       4       1       1       1       1       0       1
# Rows examine  50       4       1       1       1       1       0       1
# Query size    18     154      35      42   38.50   40.45    2.75   40.45
# 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 0x23910029062B79B8B93065026BA2B403 at byte 3633
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T06:48:12
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1    98us    33us    65us    49us    65us    22us    49us
# Lock time      0       0       0       0       0       0       0       0
# Rows sent     20       2       1       1       1       1       0       1
# Rows examine   0       0       0       0       0       0       0       0
# Query size     6      50      25      25      25      25       0      25
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
EXPLAIN SELECT @@SQL_MODE\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT @@SQL_MODE\G

# Query 3: 0.15 QPS, 0.00x concurrency, ID 0xEC21548748A08C1CDA69864C6215FEDB at byte 2589
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:47:59 to 2023-11-25T06:48:12
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1    89us    44us    45us    44us    45us       0    44us
# 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    48     390     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.15 QPS, 0.00x concurrency, ID 0xDFB7062963B5842FD3F15165B8904806 at byte 2379
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:47:59 to 2023-11-25T06:48:12
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1    86us    43us    43us    43us    43us       0    43us
# Lock time      0       0       0       0       0       0       0       0
# Rows sent     20       2       1       1       1       1       0       1
# Rows examine  25       2       1       1       1       1       0       1
# Query size     4      34      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

netdata

http://localhost:19991/#menu_services;after=1700894821099;before=1700894897154

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon1/pprof/11250647

saza-ku commented 10 months ago

isucon3

alp

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

slow query

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

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

Count: 2  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: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), isucon[isucon]@localhost
  SELECT @@SQL_MODE

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

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

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

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

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

explain

Reading from STDIN ...

# 130ms user time, 20ms system time, 36.12M rss, 50.57M vsz
# Current date: Sat Nov 25 06:48:21 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 18 total, 8 unique, 1.38 QPS, 0.00x concurrency _______________
# Time range: 2023-11-25T06:48:03 to 2023-11-25T06:48:16
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            6ms     3us     2ms   305us     2ms   512us    44us
# Lock time            5us       0     2us       0     1us       0       0
# Rows sent             10       0       1    0.56    0.99    0.49    0.99
# Rows examine           8       0       1    0.44    0.99    0.49       0
# Query size           812      16     195   45.11  192.76   53.08   26.08

# Profile
# Rank Query ID                          Response time Calls R/Call V/M   
# ==== ================================= ============= ===== ====== ===== 
#    1 0xE77769C62EF669AA7DD5F6760F2D...  0.0050 90.4%     4 0.0012  0.00 SHOW VARIABLES
#    2 0x23910029062B79B8B93065026BA2...  0.0001  2.0%     2 0.0001  0.00 SELECT
#    3 0xEC21548748A08C1CDA69864C6215...  0.0001  1.7%     2 0.0000  0.00 SET
#    4 0xDFB7062963B5842FD3F15165B890...  0.0001  1.6%     2 0.0000  0.00 SELECT
# MISC 0xMISC                             0.0002  4.3%     8 0.0000   0.0 <4 ITEMS>

# Query 1: 0.31 QPS, 0.00x concurrency, ID 0xE77769C62EF669AA7DD5F6760F2D2EBB at byte 1927
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:48:03 to 2023-11-25T06:48:16
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         22       4
# Exec time     90     5ms   942us     2ms     1ms     2ms   280us     2ms
# Lock time    100     5us     1us     2us     1us     1us       0     1us
# Rows sent     40       4       1       1       1       1       0       1
# Rows examine  50       4       1       1       1       1       0       1
# Query size    18     154      35      42   38.50   40.45    2.75   40.45
# 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 0x23910029062B79B8B93065026BA2B403 at byte 3633
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T06:48:16
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1   110us    37us    73us    55us    73us    25us    55us
# Lock time      0       0       0       0       0       0       0       0
# Rows sent     20       2       1       1       1       1       0       1
# Rows examine   0       0       0       0       0       0       0       0
# Query size     6      50      25      25      25      25       0      25
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
EXPLAIN SELECT @@SQL_MODE\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT @@SQL_MODE\G

# Query 3: 0.15 QPS, 0.00x concurrency, ID 0xEC21548748A08C1CDA69864C6215FEDB at byte 2589
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:48:03 to 2023-11-25T06:48:16
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1    92us    45us    47us    46us    47us     1us    46us
# 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    48     390     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.15 QPS, 0.00x concurrency, ID 0xDFB7062963B5842FD3F15165B8904806 at byte 2379
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:48:03 to 2023-11-25T06:48:16
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1    90us    45us    45us    45us    45us       0    45us
# Lock time      0       0       0       0       0       0       0       0
# Rows sent     20       2       1       1       1       1       0       1
# Rows examine  25       2       1       1       1       1       0       1
# Query size     4      34      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

netdata

http://localhost:19993/#menu_services;after=1700894821105;before=1700894901111

pprof

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

saza-ku commented 10 months ago

isucon2

alp

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

slow query

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

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

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

Count: 2  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: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  SET SESSION wait_timeout=N

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

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

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

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

explain

Reading from STDIN ...

# 130ms user time, 20ms system time, 36.12M rss, 50.52M vsz
# Current date: Sat Nov 25 06:48:21 2023
# Hostname: ip-192-168-0-12
# Files: STDIN
# Overall: 18 total, 8 unique, 1.38 QPS, 0.00x concurrency _______________
# Time range: 2023-11-25T06:48:03 to 2023-11-25T06:48:16
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            6ms     2us     2ms   309us     2ms   512us    44us
# Lock time            3us       0     1us       0     1us       0       0
# Rows sent             10       0       1    0.56    0.99    0.49    0.99
# Rows examine           8       0       1    0.44    0.99    0.49       0
# Query size           812      16     195   45.11  192.76   53.08   26.08

# Profile
# Rank Query ID                          Response time Calls R/Call V/M   
# ==== ================================= ============= ===== ====== ===== 
#    1 0xE77769C62EF669AA7DD5F6760F2D...  0.0050 90.5%     4 0.0013  0.00 SHOW VARIABLES
#    2 0x23910029062B79B8B93065026BA2...  0.0001  1.9%     2 0.0001  0.00 SELECT
#    3 0xDFB7062963B5842FD3F15165B890...  0.0001  1.7%     2 0.0000  0.00 SELECT
#    4 0xEC21548748A08C1CDA69864C6215...  0.0001  1.7%     2 0.0000  0.00 SET
# MISC 0xMISC                             0.0002  4.3%     8 0.0000   0.0 <4 ITEMS>

# Query 1: 0.31 QPS, 0.00x concurrency, ID 0xE77769C62EF669AA7DD5F6760F2D2EBB at byte 0
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:48:03 to 2023-11-25T06:48:16
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         22       4
# Exec time     90     5ms   967us     2ms     1ms     2ms   280us     2ms
# Lock time    100     3us       0     1us       0     1us       0     1us
# Rows sent     40       4       1       1       1       1       0       1
# Rows examine  50       4       1       1       1       1       0       1
# Query size    18     154      35      42   38.50   40.45    2.75   40.45
# 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 0x23910029062B79B8B93065026BA2B403 at byte 3633
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2023-11-25T06:48:16
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1   103us    35us    68us    51us    68us    23us    51us
# Lock time      0       0       0       0       0       0       0       0
# Rows sent     20       2       1       1       1       1       0       1
# Rows examine   0       0       0       0       0       0       0       0
# Query size     6      50      25      25      25      25       0      25
# String:
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
EXPLAIN SELECT @@SQL_MODE\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT @@SQL_MODE\G

# Query 3: 0.15 QPS, 0.00x concurrency, ID 0xDFB7062963B5842FD3F15165B8904806 at byte 2379
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:48:03 to 2023-11-25T06:48:16
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1    96us    45us    51us    48us    51us     4us    48us
# Lock time      0       0       0       0       0       0       0       0
# Rows sent     20       2       1       1       1       1       0       1
# Rows examine  25       2       1       1       1       1       0       1
# Query size     4      34      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 4: 0.15 QPS, 0.00x concurrency, ID 0xEC21548748A08C1CDA69864C6215FEDB at byte 2589
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:48:03 to 2023-11-25T06:48:16
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11       2
# Exec time      1    93us    46us    47us    46us    47us       0    46us
# 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    48     390     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

netdata

http://localhost:19992/#menu_services;after=1700894821102;before=1700894901108

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon2/pprof/11250647