SQLite -> MySQL

[pinkumohikan]

refs #1

[pinkumohikan]

07:01:37.000724 PASSED: true 07:01:37.000727 SCORE: 7748 (+8070 -322(4%))

[pinkumohikan]

# Profile
# Rank Query ID                            Response time Calls  R/Call V/M
# ==== =================================== ============= ====== ====== ===
#    1 0x6C031465492924F55AC3B50503CE9D8F  35.1486 34.1% 398659 0.0001  0.00 SELECT player
#    2 0xDA556F9115773A1A99AA0165670CE848  30.3428 29.5% 471755 0.0001  0.00 ADMIN PREPARE
#    3 0x1E38C55BDC29660276F2C9EDAA43402B   5.7375  5.6%   2409 0.0024  0.03 SELECT player_score
#    4 0x9DCF68A8489C142D0DEFBB162BDE2E1D   4.7223  4.6%   2134 0.0022  0.00 SELECT competition
#    5 0x676347F321DB8BC7FCB05D4948FC2248   4.6673  4.5%   6768 0.0007  0.01 SELECT visit_history
#    6 0x6A54FF26051F9FBA789289554B08491A   3.8558  3.7%   6768 0.0006  0.01 SELECT player_score
#    7 0x631712F98167F3C90DB5561E4CE88F43   3.7416  3.6%  16852 0.0002  0.00 SELECT player_score
#    8 0x55E8AA5B1E4F6D4FD6793F4A922CC139   3.5114  3.4%     63 0.0557  0.00 SELECT player
#    9 0x2812F710FEF71C4E0827D5A14DD47F0A   2.1440  2.1%    941 0.0023  0.00 SELECT competition
#   10 0xC3D0F08E483D54FFAE9DCF007DAE1045   2.0984  2.0%     86 0.0244  0.03 INSERT player_score
#   11 0x84836EC5D21D6C2B3ADEB61102CCFE5E   2.0578  2.0%  22440 0.0001  0.00 SELECT competition
# MISC 0xMISC                               4.9191  4.8% 486746 0.0000   0.0 <19 ITEMS>

# Query 1: 6.04k QPS, 0.53x concurrency, ID 0x6C031465492924F55AC3B50503CE9D8F at byte 154050588
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-23T07:00:32 to 2023-11-23T07:01:38
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         28  398659
# Exec time     34     35s    37us    13ms    88us   103us   113us    76us
# Lock time     83   585ms       0     3ms     1us     1us     9us     1us
# Rows sent     11 389.31k       0       1    1.00    0.99    0.00    0.99
# Rows examine   4 389.31k       0       1    1.00    0.99    0.00    0.99
# Query size    35  20.74M      38      60   54.55   59.77    8.16   59.77
# String:
# Databases    isuports
# Hosts        172.31.32.100
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  #####
#   1ms  #
#  10ms  #
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isuports` LIKE 'player'\G
#    SHOW CREATE TABLE `isuports`.`player`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM player WHERE id = '01HFXFP3DJGAVAA0Y4A763A26H'\G

# Query 2: 7.15k QPS, 0.46x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 231624754
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-23T07:00:32 to 2023-11-23T07:01:38
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         33  471755
# Exec time     29     30s    24us    37ms    64us    80us   150us    52us
# Lock time      0    18us       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    22  13.50M      30      30      30      30       0      30
# String:
# Databases    isuports
# Hosts        172.31.32.100
# Users        isucon
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  #
#   1ms  #
#  10ms  #
# 100ms
#    1s
#  10s+
administrator command: Prepare\G