묻고답하기
db퀘리 슬립현상 어찌해결 하나요?ㅠ
2014.08.27 09:52
| 2303567 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303568 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303569 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303570 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303571 | 3dmusic | localhost | 3dmusic | Sleep | 4 | | |
| 2303572 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303573 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303574 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303575 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303576 | 3dmusic | localhost | 3dmusic | Sleep | 3 | | |
| 2303577 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303578 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `status` in ('PUBLIC') |
| 2303579 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303580 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303582 | 3dmusic | localhost | 3dmusic | Query | 9 | closing tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303584 | 3dmusic | localhost | 3dmusic | Query | 6 | closing tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303585 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303587 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303588 | 3dmusic | localhost | 3dmusic | Query | 1 | closing tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303589 | 3dmusic | localhost | 3dmusic | Query | 5 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303590 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303591 | 3dmusic | localhost | 3dmusic | Query | 8 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303592 | 3dmusic | localhost | 3dmusic | Query | 8 | Opening tables | SELECT `member_srl` FROM `xe_site_admin` as `site_admin` WHERE `site_srl` = 0 and `member_srl` = |
| 2303593 | 3dmusic | localhost | 3dmusic | Query | 1 | Opening tables | select count(*) as "count" FROM `xe_documents` as `documents` WHERE `status` in ('PUBLIC') |
| 2303594 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303595 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303596 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303597 | 3dmusic | localhost | 3dmusic | Query | 2 | Opening tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303598 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303599 | 3dmusic | localhost | 3dmusic | Sleep | 3 | | |
| 2303600 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303601 | 3dmusic | localhost | 3dmusic | Sleep | 0 | | |
| 2303602 | 3dmusic | localhost | 3dmusic | Query | 1 | Opening tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303603 | 3dmusic | localhost | 3dmusic | Sleep | 3 | | |
| 2303604 | 3dmusic | localhost | 3dmusic | Query | 2 | Opening tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303605 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303606 | 3dmusic | localhost | 3dmusic | Query | 9 | closing tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303607 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303608 | 3dmusic | localhost | 3dmusic | Sleep | 4 | | |
| 2303609 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303610 | 3dmusic | localhost | 3dmusic | Query | 2 | Opening tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303611 | 3dmusic | localhost | 3dmusic | Query | 6 | Sorting result | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303612 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303613 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303614 | 3dmusic | localhost | 3dmusic | Query | 1 | closing tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303615 | 3dmusic | localhost | 3dmusic | Query | 6 | Opening tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303616 | 3dmusic | localhost | 3dmusic | Query | 5 | Opening tables | SELECT `member_srl` FROM `xe_site_admin` as `site_admin` WHERE `site_srl` = 0 and `member_srl` = |
| 2303617 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303618 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303619 | 3dmusic | localhost | 3dmusic | Query | 1 | Opening tables | SELECT * FROM `xe_documents` as `documents` WHERE ( `status` in ('PUBLIC') ) and `list_order` <= |
| 2303620 | 3dmusic | localhost | 3dmusic | Query | 7 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303621 | 3dmusic | localhost | 3dmusic | Sleep | 3 | | |
| 2303622 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303623 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303624 | 3dmusic | localhost | 3dmusic | Query | 8 | Opening tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303626 | 3dmusic | localhost | 3dmusic | Sleep | 5 | | |
| 2303627 | 3dmusic | localhost | 3dmusic | Sleep | 1 | | |
| 2303628 | 3dmusic | localhost | 3dmusic | Query | 6 | closing tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303629 | 3dmusic | localhost | 3dmusic | Query | 6 | Opening tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303630 | 3dmusic | localhost | 3dmusic | Query | 8 | closing tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303631 | 3dmusic | localhost | 3dmusic | Query | 9 | closing tables | SELECT * FROM `xe_module_admins` as `module_admins` WHERE `module_srl` = 1010133 and `member_srl` |
| 2303632 | 3dmusic | localhost | 3dmusic | Query | 6 | closing tables | SELECT * FROM `xe_member_message` as `member_message` , `xe_member` as `member` WHERE `member_mes |
| 2303633 | 3dmusic | localhost | 3dmusic | Query | 2 | Opening tables | SELECT * FROM `xe_module_grants` as `module_grants` WHERE `module_srl` = 1010133 ORDER BY `gro |
| 2303634 | 3dmusic | localhost | 3dmusic | Sleep | 1 | | |
| 2303635 | 3d
업체에서 부하발생시 문제가되는부분 설명해줬는데
이부분을 찾아서 삭제 해야 하는건지요? 슬립현상이 현재 지속적으로 계속되네요
xe 셰션 부분도 퀘리 부화가 걸리구요
php버전은 5.217이구요 코어는 최신입니다 고수님들 답변부탁드려요
