제작 의뢰
slow Query 수정가능하신분 -.-a 의뢰합니다.
2011.01.19 11:03
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 7.670148 Lock_time: 1.519027 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355282;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54:43
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 7.775343 Lock_time: 1.524465 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355283;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# User@Ho! st: bbulsori[bbulsori] @ localhost []
# Query_time: 7.661413 Lock_time: 1.394974 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355283;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54:44
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 9.158039 Lock_time: 1.863302 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355284;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54! :45
# User@Host: bbulsori[bbulsori] @ localhost []
#! Query_t ime: 10.193045 Lock_time: 1.694183 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355285;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54:47
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 6.631137 Lock_time: 0.000051 Rows_sent: 0 Rows_examined: 0
SET timestamp=1295355287;
update `xe_counter_status` as counter_status set `pageview` = pageview+1 where (regdate = 20110118);
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 12.200232 Lock_time: 1.289961 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355287;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modu! les` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54:53
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 3.329191 Lock_time: 0.230304 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355293;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 3.117900 Lock_time: 0.000098 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355293;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as mod! ules,`xe_documents` as documents where (documents.modul! e_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 3.475760 Lock_time: 0.000069 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355293;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:57:36
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 3.010258 Lock_time: 0.000092 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355456;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,1214! 0,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# User@Host: dwu2009[dwu2009] @ localhost []
# Query_time: 4.727551 Lock_time: 0.000084 Rows_sent: 1 Rows_examined: 87969
use dwu2009;
SET timestamp=1295355456;
select * from `xe_member_message` as member_message,`xe_member` as member where (member_message.receiver_srl = 3182 and member_message.readed = ''N'' and member_message.sender_srl = member.member_srl) order by
member_message.list_order desc limit 0, 1;
제사이트가 이상하게 동접이좀만 발생해도 슬로우쿼리문제로 - -
다른서버에 지장을주게되고.. 사이트가 뻗거든요..
그래서 cafe24 쪽에서 이 소스를 수정하라는데...
전 소스에대한 개념도 잘모르고해서 의뢰한번 해봅니다.
가격이랑 연락처 댓글로 달아주시면 감사하겠습니다.
제목 | 글쓴이 | 날짜 |
---|---|---|
공지 피해 사례 공유 게시물 관련 안내 [2] | XE | 2017.07.29 |
db 데이타 마이그레이션 가능하신분 찾습니다. [1] | 디자인키 | 2011.01.19 |
디아이진 사이트 리뉴얼 제작의뢰 [1] | 한동훈641 | 2011.01.19 |
slow Query 수정가능하신분 -.-a 의뢰합니다. [1] | 서민석203 | 2011.01.19 |
cakephp 작업 가능하신분 구합니다. | 윤영준715 | 2011.01.19 |
제작의뢰 입니다 | 윈시스 | 2011.01.18 |
사이트 제작 (디자인+프로그램) 의뢰 [4] | 지눈 | 2011.01.18 |
홈페이지 제작 의뢰합니다. [10] | 최종요 | 2011.01.18 |
견적문의() [2] | 김태헌687 | 2011.01.18 |
XE를 잘 하시는 웹 디자이너를 구합니다. | 이철778 | 2011.01.18 |
제작의뢰 드립니다. [2] | droi | 2011.01.18 |
제작의뢰드립니다. [4] | 소려 | 2011.01.18 |
홈페이지 제작 지원 부탁드립니다. | yohan666 | 2011.01.17 |
프로그램 의뢰 | Software2 | 2011.01.17 |
쇼핑몰순위 제작의뢰 드립니다 . [2] | 에이제이님 | 2011.01.17 |
사이트(1페이지짜리) 다시 만들어주실분 구합니다. [1] | 지니니 | 2011.01.17 |
광고 중개 싸이트 개발 의뢰 | 김상수664 | 2011.01.16 |
Flash CMS 수정 및 BBS추가 작업 | jay-jang | 2011.01.15 |
다른사이트 게시글 자동으로 내사이트에 퍼오기 의뢰합니다. [2] | 서민석203 | 2011.01.15 |
홈페이지 관리하실 분 [2] | 열공이닷 | 2011.01.14 |
학원 홈페이지 견적 부탁합니다. [5] | 이그잼 | 2011.01.14 |