sankichi92 / isucon13 Goto Github PK

$ sudo mysqldumpslow /tmp/slow.log -s t -t 10

Reading mysql slow query log from /tmp/slow.log
Count: 12119  Time=0.03s (340s)  Lock=0.00s (0s)  Rows=3.6 (43432), isucon[isucon]@localhost
  SELECT * FROM livestream_tags WHERE livestream_id = N

Count: 21301  Time=0.01s (125s)  Lock=0.00s (0s)  Rows=0.7 (15704), isucon[isucon]@localhost
  SELECT image FROM icons WHERE user_id = N

Count: 12269  Time=0.01s (102s)  Lock=0.00s (0s)  Rows=0.2 (2780), isudns[isudns]@localhost
  SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=N and name='S' and domain_id=N

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

Count: 6730  Time=0.01s (58s)  Lock=0.00s (0s)  Rows=1.0 (6730), isucon[isucon]@localhost
  SELECT COUNT(*) FROM users u
  INNER JOIN livestreams l ON l.user_id = u.id
  INNER JOIN reactions r ON r.livestream_id = l.id
  WHERE u.id = N

Count: 9162  Time=0.01s (56s)  Lock=0.00s (0s)  Rows=0.5 (4733), isudns[isudns]@localhost
  SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=N and type='S' and name='S'

Count: 17837  Time=0.00s (38s)  Lock=0.00s (0s)  Rows=1.0 (17837), isucon[isucon]@localhost
  SELECT * FROM themes WHERE user_id = N

Count: 1395  Time=0.03s (35s)  Lock=0.00s (0s)  Rows=1.0 (1395), isucon[isucon]@localhost
  SELECT slot FROM reservation_slots WHERE start_at = N AND end_at = N

Count: 76120  Time=0.00s (32s)  Lock=0.00s (0s)  Rows=0.0 (0), isucon[isucon]@localhost
  DELETE FROM livecomments
  WHERE
  id = N AND
  livestream_id = N AND
  (SELECT COUNT(*)
  FROM
  (SELECT 'S' AS text) AS texts
  INNER JOIN
  (SELECT CONCAT('S', 'S', 'S')	AS pattern) AS patterns
  ON texts.text LIKE patterns.pattern) >= N

Count: 448  Time=0.05s (23s)  Lock=0.00s (0s)  Rows=0.4 (180), isucon[isucon]@localhost
  SELECT id, user_id, livestream_id, word FROM ng_words WHERE user_id = N AND livestream_id = N