묻고답하기
서버 회사에서 전화가 왔는데요... ㅠㅠ
2014.12.03 23:00
어제 저희 서버회사에서 전화가 왔는데요.. 아래와 같은 메일을 보내주면서 제 홈페이지때문에 과부하가 걸려 다른 홈페이지 접속이 안되게 한다고 조치를 취하라고 합니다.
제가 이해할수 있는내용이 아니라 큰소리 칠 수 없고 제 홈페이지는 닫혀있는 상태라 질문을 우선 올려 봅니다.
혹시 아래 내용을 보고 무슨 내용인지 알수 있을까요?
l154167 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154168 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154174 | jscorpkorea | localhost | jscorpkorea | Query | 446 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 154175 | jscorpkorea | localhost | jscorpkorea | Query | 418 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154177 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154179 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154183 | jscorpkorea | localhost | jscorpkorea | Query | 446 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 154184 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154191 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` not i |
| 154193 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154196 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154198 | jscorpkorea | localhost | jscorpkorea | Query | 402 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154206 | jscorpkorea | localhost | jscorpkorea | Query | 413 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154210 | jscorpkorea | localhost | jscorpkorea | Query | 23 | Opening tables | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154212 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` not i |
| 154213 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154214 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154215 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154217 | jscorpkorea | localhost | jscorpkorea | Query | 20 | Opening tables | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154218 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154219 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154222 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE ( `documents`.`module_srl` not in (0) and `docu |
| 154223 | jscorpkorea | localhost | jscorpkorea | Query | 418 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154224 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154226 | jscorpkorea | localhost | jscorpkorea | Query | 390 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154227 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154231 | jscorpkorea | localhost | jscorpkorea | Query | 436 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` not i |
| 154233 | jscorpkorea | localhost | jscorpkorea | Query | 369 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154235 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154241 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154243 | jscorpkorea | localhost | jscorpkorea | Query | 401 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154247 | jscorpkorea | localhost | jscorpkorea | Query | 446 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 154248 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154250 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154253 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` not i |
| 154255 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154256 | jscorpkorea | localhost | jscorpkorea | Query | 418 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154263 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154265 | jscorpkorea | localhost | jscorpkorea | Query | 17 | Opening tables | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154266 | jscorpkorea | localhost | jscorpkorea | Query | 408 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154277 | jscorpkorea | localhost | jscorpkorea | Query | 446 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 154416 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154420 | jscorpkorea | localhost | jscorpkorea | Query | 436 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` not i |
| 154423 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154426 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154433 | jscorpkorea | localhost | jscorpkorea | Query | 404 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154437 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154439 | jscorpkorea | localhost | jscorpkorea | Query | 408 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` in (5237,5684,7508,209 |
| 154466 | jscorpkorea | localhost | jscorpkorea | Query | 446 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 154588 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 154679 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` not i |
| 154865 | jscorpkorea | localhost | jscorpkorea | Query | 436 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `documents`.`module_srl` not i |
| 155005 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 155169 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 155356 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | UPDATE `xe_documents` as `documents` SET `readed_count` = `readed_count` + 1 WHERE `document_srl` |
| 155361 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `documents`.`title`, `documents`.`nick_name`, `documents`.`regdate`, `documents`.`readed_coun |
| 155366 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 155448 | jscorpkorea | localhost | jscorpkorea | Query | 433 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155471 | jscorpkorea | localhost | jscorpkorea | Query | 446 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 155479 | jscorpkorea | localhost | jscorpkorea | Query | 433 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155481 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `documents`.`title`, `documents`.`nick_name`, `documents`.`regdate`, `documents`.`readed_coun |
| 155482 | jscorpkorea | localhost | jscorpkorea | Query | 436 | Waiting for table level lock | SELECT `tag`, count(*) as `count` FROM `xe_tags` as `T` , `xe_documents` as `D` WHERE `T`.`docume |
| 155483 | jscorpkorea | localhost | jscorpkorea | Query | 436 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 163720 |
| 155486 | jscorpkorea | localhost | jscorpkorea | Query | 434 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 99508 |
| 155487 | jscorpkorea | localhost | jscorpkorea | Query | 435 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155489 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `document_srl` in (8646,8649,8 |
| 155490 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155492 | jscorpkorea | localhost | jscorpkorea | Query | 432 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155493 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155494 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 155495 | jscorpkorea | localhost | jscorpkorea | Query | 436 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155496 | jscorpkorea | localhost | jscorpkorea | Query | 435 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155497 | jscorpkorea | localhost | jscorpkorea | Query | 435 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155498 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155499 | jscorpkorea | localhost | jscorpkorea | Query | 434 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155501 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155503 | jscorpkorea | localhost | jscorpkorea | Query | 435 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141401 |
| 155507 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155513 | jscorpkorea | localhost | jscorpkorea | Query | 435 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 96364 |
| 155521 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Sending data | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `module_srl` in (8485) and `st |
| 155522 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155523 | jscorpkorea | localhost | jscorpkorea | Query | 434 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141433 |
| 155534 | jscorpkorea | localhost | jscorpkorea | Query | 438 | Waiting for table level lock | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155535 | jscorpkorea | localhost | jscorpkorea | Query | 435 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141433 |
| 155538 | jscorpkorea | localhost | jscorpkorea | Query | 437 | Waiting for table level lock | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155539 | jscorpkorea | localhost | jscorpkorea | Query | 434 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 141433 |
| 155543 | jscorpkorea | localhost | jscorpkorea | Query | 435 | Waiting for table level lock | SELECT * FROM `xe_documents` as `documents` WHERE `document_srl` = 175928 |
| 155589 | jscorpkorea | localhost | jscorpkorea | Query | 18 | Opening tables | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155590 | jscorpkorea | localhost | jscorpkorea | Query | 18 | Opening tables | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155592 | jscorpkorea | localhost | jscorpkorea | Query | 23 | Opening tables | UPDATE `xe_counter_status` as `counter_status` SET `pageview` = `pageview` + 1 WHERE `regdate` in |
| 155595 | jscorpkorea | localhost | jscorpkorea | Query | 18 | Opening tables | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155596 | jscorpkorea | localhost | jscorpkorea | Query | 13 | Opening tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 7324 ORDER BY `group_ |
| 155602 | jscorpkorea | localhost | jscorpkorea | Query | 18 | Opening tables | SELECT `modules`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE `document |
| 155603 | jscorpkorea | localhost | jscorpkorea | Query | 19 | Opening tables | SELECT count(*) as `count` FROM `xe_counter_log` as `counter_log` WHERE `site_srl` = 0 and `ipadd |
| 155605 | jscorpkorea | localhost | jscorpkorea | Query | 20 | Opening tables | SELECT count(*) as `count` FROM `xe_counter_log` as `counter_log` WHERE `site_srl` = 0 and `ipadd |
| 155607 | jscorpkorea | localhost | jscorpkorea | Sleep | 21 | | NULL |
| 155609 | api | localhost | api | Query | 15 | Opening tables | SELECT *
FROM (`zip_count`)
WHERE `hostidx` = '2'