묻고답하기

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 남기남
니는뜬데이~	소셜 로그인을 사용해도 SSL 의무 설치를 해야되나요? [7]	2015.05.31 _by 니는뜬데이~
socialskyo	포인트와 그룹연동에 대해 제가 이해를 잘 못하고 있는건지.. [3]	2015.05.30 _by socialskyo
쮸야282	도메인 변경후 메인페이지는 열리는데.. 로그인을 하게되면 이전 도메인으로... [2]	2015.05.30 _by 쮸야282
손주사랑	최근게시물글씨체좀 키우고 싶은데요 [2]	2015.05.30 _by 손주사랑
Mercedes17e86	스케치북 레이아웃 기본방식외에 변경법좀 알려주시면 감사하겠습니다. [2]	2015.05.30 _by Mercedes17e86
김동하123	포인트 알림 [1]	2015.05.30 _by 불금
Mercedes17e86	대메뉴 클릭시 게시판으로 바로 들어가지게 어떻게하나요? [2]	2015.05.30 _by Mercedes17e86
별님왕자	해외에서 홈페이지 서버를 한국에 두는 것이 잘한 것인가요? [3]	2015.05.30 _by 별님왕자
좋은데이	내용직접입력창 도구에 HTML편집기가 안보임니다,
mcgomting	비로그인 상태에서 위젯이 보이지 않는 문제가 있습니다.
얼그레이8ef56	모바일뷰만 사용가능한가요? [2]	2015.05.30 _by 불금
drslam	프로파일 사진
Mantaray™	모바일 홈화면 아이콘 적용에러
drslam	xe 코어 설치후 나오는 기본 메인화면 [3]	2015.05.30 _by Podongi
우진아빠87e9e	비밀글 메인에 나오게
drslam	게시판 스크롤 이펙트 없애고 싶어요
초보해외유저	알림센터 프로필 사진 표시가 안됩니다 [4]	2015.05.30 _by 초보해외유저
XE모듈	이 모바일 레이아웃 스킨은 어떤건가요? [4]	2015.05.30 _by 도라에몽x몽에라도
1000g	SCM 플레이어를 적용하면 홈페이지 화면에 유튜브 영상이 떠요T_T
갈색눈	XE 1.5 닉네임 애드온 관련..

태그 쓰기