묻고답하기
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 []
