Locked                        | update `xe_documents` as documents set `readed_count` = readed_count+1  where (document_srl = 717935 |
| 6300 | ttttt| localhost | ttttt| Query   | 2    | Locked                        | select modules.* from `xe_modules` as modules,`xe_documents` as documents   where (documents.documen |
| 6301 |ttttt| localhost | ttttt| Query   | 2    | Locked                        | select modules.* from `xe_modules` as modules,`xe_documents` as documents   where (documents.documen |
| 6302 | ttttt| localhost | ttttt| Query   | 1    | Locked                        | select files.upload_target_srl as `document_srl` from `xe_files` as files,`xe_modules` as modules,`x |
| 6303 | ttttt| localhost | ttttt| Query   | 1    | Locked                        | select files.upload_target_srl as `document_srl` from `xe_files` as files,`xe_modules` as modules,`x

안녕하세요 ...

ㅠ.ㅠ

이게 무엇때문에 락이 걸리는걸까요 ???

게시판 스킨도 바꾸어 보고 .. 락걸리는 부분을 체크중인데..도데체 어디가 문제인지 봐도 알수가 없는데

어떻게 체크를 해야 하는것인가요 ?

 mysqld cpu 점유률도 거의 80 90% 정도 됩니다 ...

싸이트를 zb4에서 xe로 이전한 상태이구요...

 | 7614 | yyyyyy | localhost | yyyyyy | Query   | 22   | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7618 | yyyyyy | localhost | yyyyyy | Query   | 20   | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7620 | yyyyyy | localhost | yyyyyy | Query   | 19   | Locked       | select modules.* from `xe_modules` as modules,`xe_documents` as documents   where (documents.documen |
| 7626 | yyyyyy | localhost | yyyyyy | Query   | 17   | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7628 | yyyyyy | localhost | yyyyyy | Query   | 17   | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7632 | yyyyyy | localhost | yyyyyy | Query   | 16   | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7634 | yyyyyy | localhost | yyyyyy | Query   | 16   | Locked       | select modules.* from `xe_modules` as modules,`xe_documents` as documents   where (documents.documen |
| 7635 | yyyyyy | localhost | yyyyyy | Query   | 15   | Locked       | select modules.* from `xe_modules` as modules,`xe_documents` as documents   where (documents.documen |
| 7637 | yyyyyy | localhost | yyyyyy | Query   | 12   | Locked       | select * from `xe_documents` as documents   where (module_srl in (176) and is_notice = 'Y')          |
| 7641 | yyyyyy | localhost | yyyyyy | Query   | 10   | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7648 | yyyyyy | localhost | yyyyyy | Query   | 7    | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7652 | yyyyyy | localhost | yyyyyy | Query   | 6    | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7653 | yyyyyy | localhost | yyyyyy | Query   | 6    | Locked       | select count(*) as count from `xe_documents` as documents   where (member_srl = 7056572)             |
| 7654 | yyyyyy | localhost | yyyyyy | Query   | 5    | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7656 | yyyyyy | localhost | yyyyyy | Query   | 4    | Locked       | select modules.* from `xe_modules` as modules,`xe_documents` as documents   where (documents.documen |
| 7659 | yyyyyy | localhost | yyyyyy | Query   | 4    | Locked       | select * from `xe_documents` as documents   where (documents.module_srl in (53)) and list_order < 21 |
| 7660 | yyyyyy | localhost | yyyyyy | Query   | 3    | Locked       | select * from `xe_documents` as documents   where (module_srl in (6807864) and is_notice = 'Y')      |
| 7661 | yyyyyy | localhost | yyyyyy | Query   | 3    | Locked       | select * from `xe_documents` as documents   where (module_srl in (142) and is_notice = 'Y')          |
| 7665 | yyyyyy | localhost | yyyyyy | Query   | 3    | Locked       | update `xe_documents` as documents set `readed_count` = readed_count+1  where (document_srl = 709823 |
 

락때문에 부하가 너무 많이 걸려 ..홈페이지 속도가 나우누리시절이에요...ㅠ.ㅠ