묻고답하기
DB 슬로우 로그에 이거 뭐 하는 작업을 나타내는건가요?
2015.02.28 23:53
# Time: 150228 23:44:11
# User@Host: xxx[yyy] @ localhost [127.0.0.1]
# Thread_id: 141881 Schema: xxx QC_hit: No
# Query_time: 1.029736 Lock_time: 0.000036 Rows_sent: 1 Rows_examined: 165753
SET timestamp=1425134651;
SELECT count(`document_srl`) as `count` FROM `xe_documents` as `documents` WHERE `module_srl` in (107) and `status` in ('SECRET','PUBLIC') and ( `list_order` <= -2018700 );
# Time: 150228 23:44:18
# User@Host: xxx[yyy] @ localhost [127.0.0.1]
# Thread_id: 141951 Schema: xxx QC_hit: No
# Query_time: 1.053309 Lock_time: 0.000041 Rows_sent: 1 Rows_examined: 165753
SET timestamp=1425134658;
SELECT count(`document_srl`) as `count` FROM `xe_documents` as `documents` WHERE `module_srl` in (107) and `status` in ('SECRET','PUBLIC') and ( `list_order` <= -2758503 );
# Time: 150228 23:44:33
# User@Host: xxx[yyy] @ localhost [127.0.0.1]
# Thread_id: 142101 Schema: xxx QC_hit: No
# Query_time: 1.034268 Lock_time: 0.000046 Rows_sent: 1 Rows_examined: 165754
SET timestamp=1425134673;
SELECT count(`document_srl`) as `count` FROM `xe_documents` as `documents` WHERE `module_srl` in (107) and `status` in ('SECRET','PUBLIC') and ( `list_order` <= -565402 );
DB에 부하가 자꾸 걸리는거 같아서 슬로우 쿼리 로그 라는걸 써봤습니다
결과로 나온 로그의 일부인데 위와 같은 작업이 몇초간격으로 계속 발생하고 있네요
누가 어떤 작업을 제사이트에서 하고 있는건지 궁금해요...
