slow query log

[chore1110]

root@ip-192-168-0-11:/etc/mysql# mysqldumpslow -s t /tmp/mysql-slow.log

Reading mysql slow query log from /tmp/mysql-slow.log
Count: 1811 Time=0.12s (220s) Lock=0.00s (0s) Rows_sent=1.0 (1756), Rows_examined=37682.4 (68242852), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp DESC LIMIT N

Count: 3591 Time=0.05s (163s) Lock=0.00s (0s) Rows_sent=199.4 (716106), Rows_examined=14406.9 (51735050), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp DESC

Count: 499 Time=0.10s (48s) Lock=0.00s (0s) Rows_sent=231.9 (115732), Rows_examined=24499.5 (12225259), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' AND timestamp < 'S' ORDER BY timestamp DESC

Count: 7631 Time=0.00s (38s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), isucon[isucon]@localhost
COMMIT

Count: 181510 Time=0.00s (17s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), 2users@localhost

Count: 164 Time=0.09s (14s) Lock=0.00s (0s) Rows_sent=465.4 (76322), Rows_examined=23649.3 (3878493), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp ASC

Count: 70919 Time=0.00s (11s) Lock=0.00s (2s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=1.0 (70919), isucon[isucon]@localhost
INSERT INTO isu_condition (jia_isu_uuid, timestamp, is_sitting, condition, message) VALUES ('S', 'S', N, 'S', 'S')

Count: 47 Time=0.04s (1s) Lock=0.00s (0s) Rows_sent=1.4 (67), Rows_examined=10827.9 (508909), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' AND timestamp < 'S' AND 'S' <= timestamp ORDER BY timestamp DESC

Count: 7125 Time=0.00s (1s) Lock=0.00s (0s) Rows_sent=1.0 (7125), Rows_examined=0.0 (120), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT COUNT(*) FROM isu WHERE jia_isu_uuid = 'S'

Count: 1275 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=2.8 (3591), Rows_examined=7.2 (9207), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu WHERE character = 'S'

Count: 1046 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (998), Rows_examined=0.2 (190), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT image FROM isu WHERE jia_user_id = 'S' AND jia_isu_uuid = 'S'

Count: 2611 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (2611), Rows_examined=0.0 (15), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT COUNT(*) FROM user WHERE jia_user_id = 'S'

Count: 297 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=6.1 (1811), Rows_examined=7.2 (2152), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu WHERE jia_user_id = 'S' ORDER BY id DESC

[chore1110]

root@ip-192-168-0-11:/etc/mysql# mysqldumpslow -s c /tmp/mysql-slow.log

Reading mysql slow query log from /tmp/mysql-slow.log
Count: 357344 Time=0.00s (33s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), 2users@localhost

Count: 178615 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), 0users@0hosts
administrator command: Prepare

Count: 178615 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), 0users@0hosts
administrator command: Close stmt

Count: 140662 Time=0.00s (22s) Lock=0.00s (4s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=1.0 (140662), isucon[isucon]@localhost
INSERT INTO isu_condition (jia_isu_uuid, timestamp, is_sitting, condition, message) VALUES ('S', 'S', N, 'S', 'S')

Count: 15194 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), isucon[isucon]@localhost
START TRANSACTION

Count: 15110 Time=0.00s (73s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), isucon[isucon]@localhost
COMMIT

Count: 14127 Time=0.00s (2s) Lock=0.00s (0s) Rows_sent=1.0 (14127), Rows_examined=0.0 (244), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT COUNT(*) FROM isu WHERE jia_isu_uuid = 'S'

Count: 7213 Time=0.05s (367s) Lock=0.00s (0s) Rows_sent=245.5 (1770836), Rows_examined=15083.3 (108795958), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp DESC

Count: 4375 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (4375), Rows_examined=0.0 (35), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT COUNT(*) FROM user WHERE jia_user_id = 'S'

Count: 4183 Time=0.13s (532s) Lock=0.00s (0s) Rows_sent=1.0 (4086), Rows_examined=38545.6 (161236447), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp DESC LIMIT N

Count: 2550 Time=0.00s (1s) Lock=0.00s (0s) Rows_sent=2.8 (7213), Rows_examined=7.2 (18362), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu WHERE character = 'S'

Count: 1850 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (1778), Rows_examined=0.2 (353), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT image FROM isu WHERE jia_user_id = 'S' AND jia_isu_uuid = 'S'

Count: 778 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.9 (718), Rows_examined=0.1 (90), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT name FROM isu WHERE jia_isu_uuid = 'S' AND jia_user_id = 'S'

Count: 660 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=6.3 (4183), Rows_examined=5.9 (3870), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu WHERE jia_user_id = 'S' ORDER BY id DESC

Count: 639 Time=0.08s (53s) Lock=0.00s (0s) Rows_sent=212.0 (135464), Rows_examined=21240.8 (13572860), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' AND timestamp < 'S' ORDER BY timestamp DESC

Count: 481 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.9 (410), Rows_examined=0.6 (293), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu WHERE jia_user_id = 'S' AND jia_isu_uuid = 'S'

Count: 299 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=3.9 (1165), Rows_examined=0.2 (70), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT COUNT(*) FROM isu WHERE jia_user_id = 'S' AND jia_isu_uuid = 'S'

Count: 231 Time=0.08s (17s) Lock=0.00s (0s) Rows_sent=376.3 (86926), Rows_examined=19350.2 (4469897), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp ASC

Count: 172 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.1 (16), isucon[isucon]@localhost
INSERT IGNORE INTO user (jia_user_id) VALUES ('S')

Count: 114 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), 0users@0hosts
administrator command: Quit

Count: 108 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=1.0 (104), isucon[isucon]@localhost
INSERT INTO isu (jia_isu_uuid, name, image, jia_user_id) VALUES ('S', 'S', 'S', 'S')

Count: 104 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (104), Rows_examined=0.0 (2), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT * FROM isu_association_config WHERE name = 'S'

Count: 102 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=1.0 (102), Rows_affected=1.0 (102), isucon[isucon]@localhost
UPDATE isu SET character = 'S' WHERE jia_isu_uuid = 'S'

Count: 102 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=25.0 (2550), Rows_examined=19.0 (1939), Rows_affected=0.0 (0), isucon[isucon]@localhost
SELECT character FROM isu GROUP BY character

Count: 84 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), isucon[isucon]@localhost
ROLLBACK

[chore1110]

Reading mysql slow query log from /tmp/mysql-slow.log
Count: 7612 Time=0.01s (73s) Lock=0.00s (0s) Rows_sent=172.3 (1311488), Rows_examined=12395.2 (94352380), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp DESC

Count: 1461 Time=0.03s (37s) Lock=0.00s (0s) Rows_sent=431.1 (629836), Rows_examined=30726.6 (44891543), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' AND timestamp < 'S' ORDER BY timestamp DESC

Count: 1659 Time=0.02s (24s) Lock=0.00s (0s) Rows_sent=1.0 (1604), Rows_examined=20731.9 (34394152), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp DESC LIMIT N

Count: 454 Time=0.03s (11s) Lock=0.00s (0s) Rows_sent=709.8 (322249), Rows_examined=32029.0 (14541183), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' ORDER BY timestamp ASC

Count: 191608 Time=0.00s (5s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), 2users@3hosts

Count: 64731 Time=0.00s (2s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=1.0 (64731), isucon[isucon]@2hosts
INSERT INTO isu_condition (jia_isu_uuid, timestamp, is_sitting, condition, message) VALUES ('S', 'S', N, 'S', 'S')

Count: 87 Time=0.02s (1s) Lock=0.00s (0s) Rows_sent=2.2 (195), Rows_examined=19611.4 (1706189), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT * FROM isu_condition WHERE jia_isu_uuid = 'S' AND timestamp < 'S' AND 'S' <= timestamp ORDER BY timestamp DESC

Count: 7284 Time=0.00s (1s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), isucon[isucon]@2hosts
COMMIT

Count: 2775 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=2.7 (7612), Rows_examined=4.3 (12054), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT * FROM isu WHERE character = 'S'

Count: 6496 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (6496), Rows_examined=0.0 (74), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT COUNT(*) FROM isu WHERE jia_isu_uuid = 'S'

Count: 5209 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (5209), Rows_examined=0.0 (21), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT COUNT(*) FROM user WHERE jia_user_id = 'S'

Count: 2013 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (1935), Rows_examined=0.1 (119), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT image FROM isu WHERE jia_user_id = 'S' AND jia_isu_uuid = 'S'

Count: 7369 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), isucon[isucon]@2hosts
START TRANSACTION

Count: 1 Time=0.07s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=28.0 (28), isucon[isucon]@isucondition-3.t.isucon.dev
INSERT INTO isu VALUES (N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S'),(N,'S','S','S','S','S','S','S')

Count: 1626 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (1548), Rows_examined=0.0 (49), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT name FROM isu WHERE jia_isu_uuid = 'S' AND jia_user_id = 'S'

Count: 410 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.8 (332), Rows_examined=0.3 (136), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT * FROM isu WHERE jia_user_id = 'S' AND jia_isu_uuid = 'S'

Count: 294 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=5.6 (1659), Rows_examined=4.3 (1274), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT * FROM isu WHERE jia_user_id = 'S' ORDER BY id DESC

Count: 169 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (7), isucon[isucon]@2hosts
INSERT IGNORE INTO user (jia_user_id) VALUES ('S')

Count: 47 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=1.0 (45), isucon[isucon]@2hosts
INSERT INTO isu (jia_isu_uuid, name, image, jia_user_id) VALUES ('S', 'S', 'S', 'S')

Count: 532 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=5.7 (3044), Rows_examined=0.1 (47), Rows_affected=0.0 (0), isucon[isucon]@2hosts
SELECT COUNT(*) FROM isu WHERE jia_user_id = 'S' AND jia_isu_uuid = 'S'

Count: 85 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), isucon[isucon]@2hosts
ROLLBACK

Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=618.0 (618), isucon[isucon]@isucondition-3.t.isucon.dev
INSERT INTO isu_condition VALUES (N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S'),(N,'S','S',N,'S','S','S')

Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), isucon[isucon]@isucondition-3.t.isucon.dev
CREATE TABLE isu_association_config (
name VARCHAR(N) PRIMARY KEY,
url VARCHAR(N) NOT NULL UNIQUE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4

[ShuzoN]

�MariaDB [isucondition]> explain SELECT * FROM isu_condition WHERE jia_isu_uuid = 'f4d0895d-8728-42ac-a0c9-521a76c554ad' ORDER BY timestamp DESC LIMIT 1;
+------+-------------+---------------+------+----------------------------------+----------------------------------+---------+-------+------+----------------------------------------------------+
| id   | select_type | table         | type | possible_keys                    | key                              | key_len | ref   | rows | Extra                                              |
+------+-------------+---------------+------+----------------------------------+----------------------------------+---------+-------+------+----------------------------------------------------+
|    1 | SIMPLE      | isu_condition | ref  | index_isu_condition_jia_isu_uuid | index_isu_condition_jia_isu_uuid | 144     | const | 1470 | Using index condition; Using where; Using filesort |
+------+-------------+---------------+------+----------------------------------+----------------------------------+---------+-------+------+----------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [isucondition]> alter table isu_condition add index  index_isu_cond_timestamp(timestamp);
Query OK, 0 rows affected (0.058 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [isucondition]> explain SELECT * FROM isu_condition WHERE jia_isu_uuid = 'f4d0895d-8728-42ac-a0c9-521a76c554ad' ORDER BY timestamp DESC LIMIT 1;
+------+-------------+---------------+-------+----------------------------------+--------------------------+---------+------+------+-------------+
| id   | select_type | table         | type  | possible_keys                    | key                      | key_len | ref  | rows | Extra       |
+------+-------------+---------------+-------+----------------------------------+--------------------------+---------+------+------+-------------+
|    1 | SIMPLE      | isu_condition | index | index_isu_condition_jia_isu_uuid | index_isu_cond_timestamp | 5       | NULL |   50 | Using where |
+------+-------------+---------------+-------+----------------------------------+--------------------------+---------+------+------+-------------+
1 row in set (0.000 sec)