ユーザをメモリに持つ

[pinkumohikan]

refs #1

# Query 3: 1.88k QPS, 0.25x concurrency, ID 0xEA1E6309EEEFF9A6831AD2FB940FC23C at byte 113247500
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2024-06-29T07:20:47 to 2024-06-29T07:22:00
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         22  137278
# Exec time     12     18s    50us    38ms   133us   247us   456us    84us
# Lock time     10   177ms       0     9ms     1us     1us    28us     1us
# Rows sent     11 134.06k       1       1       1       1       0       1
# Rows examine   1 134.06k       1       1       1       1       0       1
# Query size     3   4.58M      32      35   34.97   34.95    0.33   34.95
# String:
# Databases    isupipe
# Hosts        ip-192-168-0-11.ap-northeast-1.compute.inter...
# 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
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM users WHERE id = 1143\G

[pinkumohikan]

https://isunarabe.org/teams/671/benchmark_jobs/10413 46766