묻고답하기
현재 계정에서 슬로쿼리가 발생하고 있습니다.
2011.12.16 14:31
현재 계정에서 슬로쿼리가 발생하고 있습니다.
# Time: 111215 22:50:21
# User@Host: ganzi[ganzi] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 5 Rows_examined: 348427
select member.*,count(*) as `count` from `xe_documents` as documents,`xe_modules` as modules,`xe_member` as member,`xe_member_group_
member` as member_group where (member_group.site_srl = 274333 and modules.site_srl = 274333 and modules.module_srl = documents.mod
ule_srl and documents.member_srl = member.member_srl and member_group.member_srl = member.member_srl) group by documents.member_srl
order by count desc limit 5;
# Time: 111215 22:50:39
# User@Host: ganzi[ganzi] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 5 Rows_examined: 348429
select member.*,count(*) as `count` from `xe_documents` as documents,`xe_modules` as modules,`xe_member` as member,`xe_m! ember_group_
member` as member_group where (member_group.site_srl = 274333 and modules.site_srl = 274333 and modules.module_srl = documents.mod
ule_srl and documents.member_srl = member.member_srl and member_group.member_srl = member.member_srl) group by documents.member_srl
order by count desc limit 5;
# Time: 111215 22:51:43
# User@Host: ganzi[ganzi] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 5 Rows_examined: 348435
select member.*,count(*) as `count` from `xe_documents` as documents,`xe_modules` as modules,`xe_member` as member,`xe_member_group_
member` as member_group where (member_group.site_srl = 274333 and modules.site_srl = 274333 and modules.module_srl = documents.mod
ule_srl and documents.member_srl = member.member_srl and member_group.member_srl = member.member_srl) group by documents.member_srl
order by coun! t desc limit 5;
# Time: 111215 23:01:43
# User@Host: ganzi[ganzi] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 5 Rows_examined: 348463
select member.*,count(*) as `count` from `xe_documents` as documents,`xe_modules` as modules,`xe_member` as member,`xe_member_group_
member` as member_group where (member_group.site_srl = 274333 and modules.site_srl = 274333 and modules.module_srl = documents.mod
ule_srl and documents.member_srl = member.member_srl and member_group.member_srl = member.member_srl) group by documents.member_srl
order by count desc limit 5;
# Time: 111215 23:14:41
# User@Host: ganzi[ganzi] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 5 Rows_examined: 348541
select member.*,count(*) as `count` from `xe_documents` as documents,`xe_modules` as modules,`xe_member` as member,`xe_member_group_
member` as member_group whe! re (member_group.site_srl = 274333 and modules.site_srl = 274333 and modules.module_srl = documents.mod
ule_srl and documents.member_srl = member.member_srl and member_group.member_srl = member.member_srl) group by documents.member_srl
order by count desc limit 5;
위 내용으로 쿼리부분 수정해주시기 바랍니다.
이렇게 호스팅쪽에서 말씀하시는데요
이걸 어떻게 수정을 해야하는건가요 ㅠㅠ