slow-queryログの結果 やばそうなクエリ一覧 13:21

[satojin219]

Count: 3732  Time=0.03s (127s)  Lock=0.00s (0s)  Rows=2.9 (10983), isucon[isucon]@localhost
  SELECT * FROM livestream_tags WHERE livestream_id = N

Count: 3251  Time=0.01s (48s)  Lock=0.00s (0s)  Rows=0.3 (828), 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: 2192  Time=0.01s (24s)  Lock=0.00s (0s)  Rows=1.0 (2192), 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: 2192  Time=0.01s (23s)  Lock=0.00s (0s)  Rows=1.0 (2192), 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: 2452  Time=0.01s (24s)  Lock=0.00s (0s)  Rows=0.5 (1265), 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: 6154  Time=0.01s (47s)  Lock=0.00s (0s)  Rows=0.6 (3734), isucon[isucon]@localhost
  SELECT image FROM icons WHERE user_id = N

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