묻고답하기

  2. Support
  3. 묻고답하기

db퀘리 슬립현상 어찌해결 하나요?ㅠ

2014.08.27 09:52

rtyyhh

| 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이구요  코어는 최신입니다  고수님들 답변부탁드려요
이 게시물을
좋아요
목록
글쓴이 제목 최종 글
XE 공지 글 쓰기,삭제 운영방식 변경 공지 [16] 2019.03.05 by 남기남
inknights 한줄게시글에대해서 질문요 ㅠ file  
브람쓰 외부페이지에서 불러오는 php파일의 기능  
청개굴이 게시판 새로 바꾸려면..? [1] 2010.08.10 by 이영현168
ashley1230 ssl 관련 문제  
Arp Mysql Query 에서 filter 와 pipe 의 차이점? [1] 2010.08.10 by 라르게덴
hips 질문이 있어용!~  
시고라 내용직접추가에서 첨부파일이 안됩니다.  
강함이 메인에 있는 최근게시물에 new 표시가 안되네요. ㅠㅠ  
안철호936 제목과 연동해서 링크거는 소스 부탁드려요ㅠㅠ  
워너비2000 윈도우 apm환경에서 한글이름의 미디어파일이 사라집니다.  
뽀로로돌이 페이지수정-> 내용직접입력 질문드려요!! [1] 2010.08.10 by LutZ
Lee마케터 회원가입 페이지에서요.. [1] 2010.08.10 by LutZ
월하선향 게시판EX 이미지질문요 [1] 2010.08.10 by LutZ
Fighting_For_Fun 링크중 & 가 amp; 로 바뀌어 오류나는 현상 [1] 2010.08.10 by 라르게덴
alljoy 최신게시글 위젯..... [2] file 2010.08.10 by alljoy
비밀얌 언어선택 할때 영어를 선택하면 어떤 링크로 가지는 건가요? [1] 2010.08.10 by 김해순
Akzin 자료실 버전업은 어떻게 하나요?  
유덕상633 게시판에 글쓰기  
라이트트윈스 회원가입이 되지않습니다 ㅠㅠ  
쿠드반지루엣 계정주소가 변경되어 페이지및 게시판 링크가 다깨졌습니다. [1] 2010.08.10 by Gekkou
태그 쓰기