묻고답하기

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이구요 코어는 최신입니다 고수님들 답변부탁드려요

이 게시물을

댓글 0

목록

글쓴이	제목	최종 글
XE	공지 글 쓰기,삭제 운영방식 변경 공지 [16]	2019.03.05 _by 남기남
XE모듈	이 모바일 레이아웃 스킨은 어떤건가요? [4]	2015.05.30 _by 도라에몽x몽에라도
1000g	SCM 플레이어를 적용하면 홈페이지 화면에 유튜브 영상이 떠요T_T
갈색눈	XE 1.5 닉네임 애드온 관련..
B.G.M^^	브라우저 주소창에 아이디 비번 넣고 XE 로그인 가능한가요? [4]	2015.05.29 _by B.G.M^^
리즈f1104	설치오류... 동의하고나서 세번째 단계로 안넘어가요
전재영722	html 태그를 사용해서 게시판에 영상(?)을 삽입하고 싶습니다.
김동하123	스케치 웹진 링크게시판에소 reply 이것 없애는 방법
쮸야282	메인페이지 변경은 어떻게 하나요? [2]	2015.05.29 _by 쮸야282
몽실아빠	구글캡챠 적용 문의 드립니다. [5]	2015.05.29 _by 몽실아빠
KaelXP	추천/비추천/신고 모듈 문의사항있습니다.
AUTOCOP	긴급 지원 용청드립니다.. [3]	2015.05.29 _by inJin
ㄲㅏㅊㅣ	웹사이트 이동시 오류 메시지가 나옵니다.
몽실아빠	Waiting (TTFB) 과 HDD [4]	2015.05.29 _by 몽실아빠
inJin	레이아웃 페이지에서 회원 정보를 출력하고 싶습니다 [2]	2015.05.29 _by inJin
혜찌니	로그인하면 에러가 뜨네요 [1]	2015.05.29 _by YJSoft
루달스튼	mysql 백업할 때 오류(no talloc stackframe at ...)
신성3014	[매우 초보 질문] godaddy 호스팅 사용중이시거나 네임서버 잘 아시는 분ㅠ [1]	2015.05.29 _by GG
color77	embedwhiteurl.xml 서브도메인 추가할떄 일괄적으로 못하나요?
착한동구	기본게시판에선 추천기능이 안나오는데요.. [5]	2015.05.29 _by 몽실아빠
돌아온탕자	회원삭제가 안돼요 ㅠㅠ

태그 쓰기