묻고답하기
MYSQL 과부하..
2013.04.19 21:56
아래와 같은 메시지로 자꾸 과부하 도배가 되는데
검색 내용을 보면 봇이 특정 검색을 계속하는 쿼리 같은데 맞나요..?!!
# Query_time: 7 Lock_time: 0 Rows_sent: 5 Rows_examined: 67475
select * from `ClubSoundDB_documents` as documents where (documents.module_srl in (1279315,118,135700,1574932,182775,77427,1273808,1288878,1280192,2094887,84043,31496,568905,31491,1279340,31492,109,1935417,1279329,241600,1334267,122559,124323,5086716,1279296,124331,1279292,1279306,1279288,1279305,3485888,2158345,3432866,3921750,31490,1279334,1279335,1279274,149827,147316,568496,583641,568482,145472,5086729,168523,30628,1279263,4484297,2392,31493,124320,1279316,31425,1279307,1279342,124295,4229710,1279286,627775,147195,124430,1279268,1153799,107,1273092,2095510,31497,22101,152925,3622291,3797958,182914,260986,7758,1904447,627774,128446,226218,2080,1278820,53203,3339115,202738,1219383,203035,235655,238494,31488,3452485,31495,168674,122043,122305,124313,42495,31489,122306,122357,122531,1737423,1642285,122304,124322,162163,3797345,3797242,2554659,1905537,1923970,53077,1279287,551037,3528469,1279273,1458643,145453,1925429,30626,111049,241446,1014693,111051,1485689,147315,137471,31494,147486,3527,3923286,96,124321)) and list_order < 2100000000 order by list_order asc limit 5;
# User@Host: ncm[ncm] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 5 Rows_examined: 67475
select * from `ClubSoundDB_documents` as documents where (documents.module_srl in (1279315,118,135700,1574932,182775,77427,1273808,1288878,1280192,2094887,84043,31496,568905,31491,1279340,31492,109,1935417,1279329,241600,1334267,122559,124323,5086716,1279296,124331,1279292,1279306,1279288,1279305,3485888,2158345,3432866,3921750,31490,1279334,1279335,1279274,149827,147316,568496,583641,568482,145472,5086729,168523,30628,1279263,4484297,2392,31493,124320,1279316,31425,1279307,1279342,124295,4229710,1279286,627775,147195,124430,1279268,1153799,107,1273092,2095510,31497,22101,152925,3622291,3797958,182914,260986,7758,1904447,627774,128446,226218,2080,1278820,53203,3339115,202738,1219383,203035,235655,238494,31488,3452485,31495,168674,122043,122305,124313,42495,31489,122306,122357,122531,1737423,1642285,122304,124322,162163,3797345,3797242,2554659,1905537,1923970,53077,1279287,551037,3528469,1279273,1458643,145453,1925429,30626,111049,241446,1014693,111051,1485689,147315,137471,31494,147486,3527,3923286,96,124321)) and list_order < 2100000000 order by list_order asc limit 5;
# User@Host: ncm[ncm] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 5 Rows_examined: 67475
select * from `ClubSoundDB_documents` as documents where (documents.module_srl in (1279315,118,135700,1574932,182775,77427,1273808,1288878,1280192,2094887,84043,31496,568905,31491,1279340,31492,109,1935417,1279329,241600,1334267,122559,124323,5086716,1279296,124331,1279292,1279306,1279288,1279305,3485888,2158345,3432866,3921750,31490,1279334,1279335,1279274,149827,147316,568496,583641,568482,145472,5086729,168523,30628,1279263,4484297,2392,31493,124320,1279316,31425,1279307,1279342,124295,4229710,1279286,627775,147195,124430,1279268,1153799,107,1273092,2095510,31497,22101,152925,3622291,3797958,182914,260986,7758,1904447,627774,128446,226218,2080,1278820,53203,3339115,202738,1219383,203035,235655,238494,31488,3452485,31495,168674,122043,122305,124313,42495,31489,122306,122357,122531,1737423,1642285,122304,124322,162163,3797345,3797242,2554659,1905537,1923970,53077,1279287,551037,3528469,1279273,1458643,145453,1925429,30626,111049,241446,1014693,111051,1485689,147315,137471,31494,147486,3527,3923286,96,124321)) and list_order < 2100000000 order by list_order asc limit 5;
# User@Host: ncm[ncm] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 5 Rows_examined: 67475
select * from `ClubSoundDB_documents` as documents where (documents.module_srl in (1279315,118,135700,1574932,182775,77427,1273808,1288878,1280192,2094887,84043,31496,568905,31491,1279340,31492,109,1935417,1279329,241600,1334267,122559,124323,5086716,1279296,124331,1279292,1279306,1279288,1279305,3485888,2158345,3432866,3921750,31490,1279334,1279335,1279274,149827,147316,568496,583641,568482,145472,5086729,168523,30628,1279263,4484297,2392,31493,124320,1279316,31425,1279307,1279342,124295,4229710,1279286,627775,147195,124430,1279268,1153799,107,1273092,2095510,31497,22101,152925,3622291,3797958,182914,260986,7758,1904447,627774,128446,226218,2080,1278820,53203,3339115,202738,1219383,203035,235655,238494,31488,3452485,31495,168674,122043,122305,124313,42495,31489,122306,122357,122531,1737423,1642285,122304,124322,162163,3797345,3797242,2554659,1905537,1923970,53077,1279287,551037,3528469,1279273,1458643,145453,1925429,30626,111049,241446,1014693,111051,1485689,147315,137471,31494,147486,3527,3923286,96,124321)) and list_order < 2100000000 order by list_order asc limit 5;
# User@Host: ncm[ncm] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 5 Rows_examined: 67475
select * from `ClubSoundDB_documents` as documents where (documents.module_srl in (1279315,118,135700,1574932,182775,77427,1273808,1288878,1280192,2094887,84043,31496,568905,31491,1279340,31492,109,1935417,1279329,241600,1334267,122559,124323,5086716,1279296,124331,1279292,1279306,1279288,1279305,3485888,2158345,3432866,3921750,31490,1279334,1279335,1279274,149827,147316,568496,583641,568482,145472,5086729,168523,30628,1279263,4484297,2392,31493,124320,1279316,31425,1279307,1279342,124295,4229710,1279286,627775,147195,124430,1279268,1153799,107,1273092,2095510,31497,22101,152925,3622291,3797958,182914,260986,7758,1904447,627774,128446,226218,2080,1278820,53203,3339115,202738,1219383,203035,235655,238494,31488,3452485,31495,168674,122043,122305,124313,42495,31489,122306,122357,122531,1737423,1642285,122304,124322,162163,3797345,3797242,2554659,1905537,1923970,53077,1279287,551037,3528469,1279273,1458643,145453,1925429,30626,111049,241446,1014693,111051,1485689,147315,137471,31494,147486,3527,3923286,96,124321)) and list_order < 2100000000 order by list_order asc limit 5;
# User@Host: ncm[ncm] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 5 Rows_examined: 67475
select * from `ClubSoundDB_documents` as documents where (documents.module_srl in (1279315,118,135700,1574932,182775,77427,1273808,1288878,1280192,2094887,84043,31496,568905,31491,1279340,31492,109,1935417,1279329,241600,1334267,122559,124323,5086716,1279296,124331,1279292,1279306,1279288,1279305,3485888,2158345,3432866,3921750,31490,1279334,1279335,1279274,149827,147316,568496,583641,568482,145472,5086729,168523,30628,1279263,4484297,2392,31493,124320,1279316,31425,1279307,1279342,124295,4229710,1279286,627775,147195,124430,1279268,1153799,107,1273092,2095510,31497,22101,152925,3622291,3797958,182914,260986,7758,1904447,627774,128446,226218,2080,1278820,53203,3339115,202738,1219383,203035,235655,238494,31488,3452485,31495,168674,122043,122305,124313,42495,31489,122306,122357,122531,1737423,1642285,122304,124322,162163,3797345,3797242,2554659,1905537,1923970,53077,1279287,551037,3528469,1279273,1458643,145453,1925429,30626,111049,241446,1014693,111051,1485689,147315,137471,31494,147486,3527,3923286,96,124321)) and list_order < 2100000000 order by list_order asc limit 5;
# User@Host: ncm[ncm] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 5 Rows_examined: 67475
select * from `ClubSoundDB_documents` as documents where (documents.module_srl in (1279315,118,135700,1574932,182775,77427,1273808,1288878,1280192,2094887,84043,31496,568905,31491,1279340,31492,109,1935417,1279329,241600,1334267,122559,124323,5086716,1279296,124331,1279292,1279306,1279288,1279305,3485888,2158345,3432866,3921750,31490,1279334,1279335,1279274,149827,147316,568496,583641,568482,145472,5086729,168523,30628,1279263,4484297,2392,31493,124320,1279316,31425,1279307,1279342,124295,4229710,1279286,627775,147195,124430,1279268,1153799,107,1273092,2095510,31497,22101,152925,3622291,3797958,182914,260986,7758,1904447,627774,128446,226218,2080,1278820,53203,3339115,202738,1219383,203035,235655,238494,31488,3452485,31495,168674,122043,122305,124313,42495,31489,122306,122357,122531,1737423,1642285,122304,124322,162163,3797345,3797242,2554659,1905537,1923970,53077,1279287,551037,3528469,1279273,1458643,145453,1925429,30626,111049,241446,1014693,111051,1485689,147315,137471,31494,147486,3527,3923286,96,124321)) and list_order < 2100000000 order by list_order asc limit 5;
# User@Host: ncm[ncm] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 5 Rows_examined: 67475
select * from `ClubSoundDB_documents` as documents where (documents.module_srl in (1279315,118,135700,1574932,182775,77427,1273808,1288878,1280192,2094887,84043,31496,568905,31491,1279340,31492,109,1935417,1279329,241600,1334267,122559,124323,5086716,1279296,124331,1279292,1279306,1279288,1279305,3485888,2158345,3432866,3921750,31490,1279334,1279335,1279274,149827,147316,568496,583641,568482,145472,5086729,168523,30628,1279263,4484297,2392,31493,124320,1279316,31425,1279307,1279342,124295,4229710,1279286,627775,147195,124430,1279268,1153799,107,1273092,2095510,31497,22101,152925,3622291,3797958,182914,260986,7758,1904447,627774,128446,226218,2080,1278820,53203,3339115,202738,1219383,203035,235655,238494,31488,3452485,31495,168674,122043,122305,124313,42495,31489,122306,122357,122531,1737423,1642285,122304,124322,162163,3797345,3797242,2554659,1905537,1923970,53077,1279287,551037,3528469,1279273,1458643,145453,1925429,30626,111049,241446,1014693,111051,1485689,147315,137471,31494,147486,3527,3923286,96,124321)) and list_order < 2100000000 order by list_order asc limit 5;
# User@Host: ncm[ncm] @ localhost []
댓글 0
글쓴이 | 제목 | 최종 글 |
---|---|---|
XE | 공지 글 쓰기,삭제 운영방식 변경 공지 [16] | 2019.03.05 by 남기남 |
개터리 | 그누보드 > xe 이전시 회원포인트와 등급관련 | |
ShopFree | 긴급입니다 ㅠㅠㅠㅠ 관리자 권한 취소.. [1] | 2013.04.20 by sejin7940 |
초로롱이 | xe 본문에서 이미지맵 태그 쓰기 | |
김벡희 | content위젯 에서 캐시가 뭐죠? [1] | 2013.04.20 by ㅊㅇㅋㅋ |
빛다룸 | 다른 두 모듈을 한 페이지에 표시하려면 어떻게 해야하나요? [1] | 2013.04.20 by ㅊㅇㅋㅋ |
Salome | 토렌트질문입니다..초보 | |
최민수399 |
통합검색 CSS 깨짐..
[1]
![]() | 2013.04.19 by 윈컴이 |
커피2잔 |
XE 1.7.3 버전은 서브 메뉴가 안보이네요~
[3]
![]() | 2013.04.19 by Bana |
꾸링 | MYSQL 과부하.. | |
hoyeop | 보충완료) 게시판 등록시간 질문 [1] | 2013.04.19 by 송동우 |
띵똥 | 회원정보가 도메인으로 들었을때와 도메인뒤에 xe가 붙혔을때가 다릅니다. [1] | 2013.04.19 by 띵똥 |
je313 |
게시판 취소버튼이없어요..ㅠ
![]() | |
김벡희 | 메뉴에 새글 표시(N자) 모듈 항상 표시하는법 [1] | 2013.04.19 by KANTSOFT |
hoyeop | 등록시간 문제 한번 봐주세요. [1] | 2013.04.19 by 송동우 |
아띠 | 1.7 게시판 스킨에 대해 도움을 구합니다. [6] | 2013.04.19 by 송동우 |
김벡희 |
게시판 상단에 글쓰기 질문드립니다.
[1]
![]() | 2013.04.19 by 송동우 |
빛다룸 | 텍스트 링크에 마우스 오버 시 텍스트 변경 질문합니다 [1] | 2013.04.19 by 송동우 |
미추어버리겠네 | 팝업창 부분 좀 봐주세요 ㅠㅠ | |
PEANUTSOUL | SSL 인증서 설치한거 적용하는 방법.... | |
김벡희 |
회원가입 폼 다시 질문 드립니다 ...
[1]
![]() | 2013.04.19 by 송동우 |