10초이상 걸리는 쿼리 어떻게 잡아야될까요. ㅠㅠ
본문
# Query_time: 4.237551 Lock_time: 3.224482 Rows_sent: 15 Rows_examined: 416595
# Rows_affected: 0
SET timestamp=1459829277;
select distinct bo_table from g5_board_new where bn_datetime >= '2016-04-04 13:07:51' and wr_id = wr_parent;
# Query_time: 15.998333 Lock_time: 14.974187 Rows_sent: 15 Rows_examined: 416595
# Rows_affected: 0
SET timestamp=1459829277;
select distinct bo_table from g5_board_new where bn_datetime >= '2016-04-04 13:07:40' and wr_id = wr_parent;
답변을 작성하시기 전에 로그인 해주세요.