Slow query

[jasny]

Hej,

Przeglądam właśnie slow query i trafiłem na takie query

# Time: 120902 10:42:54
# User@Host: root[root] @ localhost []
# Query_time: 15.439002 Lock_time: 0.000215 Rows_sent: 10 Rows_examined: 42533288
SET timestamp=1346575374;
SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache FROM mpc_posts p LEFT JOIN mpc_members m ON ( m.member_id=p.author_id )
LEFT JOIN mpc_profile_portal pp ON ( m.member_id=pp.pp_member_id )
LEFT JOIN mpc_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid )
LEFT JOIN mpc_pfields_content pc ON ( pc.member_id=p.author_id )
LEFT JOIN mpc_reputation_index rep_index ON ( rep_index.app='forums' AND
														 rep_index.type='pid' AND
														 rep_index.type_id=p.pid AND
														 rep_index.member_id=720337 )
LEFT JOIN mpc_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) WHERE p.topic_id=377763 AND p.queued=0 ORDER BY p.pid asc LIMIT 2310,10;

Czy może ktoś powiedzieć skąd to query? Albo jeszcze lepiej jak się dowiedzieć co wywołuje to querry ?

Edytowane 2 Września 2012 przez jasny

[jasny]

Przy okazji bardziej krytyczne :

2

# Time: 120902 10:57:49
# User@Host: root[root] @ localhost []
# Query_time: 17.939682 Lock_time: 11.948590 Rows_sent: 9 Rows_examined: 8419229
SET timestamp=1346576269;
SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache FROM mpc_posts p LEFT JOIN mpc_members m ON ( m.member_id=p.author_id )
LEFT JOIN mpc_profile_portal pp ON ( m.member_id=pp.pp_member_id )
LEFT JOIN mpc_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid )
LEFT JOIN mpc_pfields_content pc ON ( pc.member_id=p.author_id )
LEFT JOIN mpc_reputation_index rep_index ON ( rep_index.app='forums' AND
														 rep_index.type='pid' AND
														 rep_index.type_id=p.pid AND
														 rep_index.member_id=420003 )
LEFT JOIN mpc_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) WHERE p.topic_id=684636 AND p.queued=0 ORDER BY p.pid asc LIMIT 450,10;

3

# User@Host: root[root] @ localhost []
# Query_time: 22.638749 Lock_time: 16.553819 Rows_sent: 9 Rows_examined: 8419229
SET timestamp=1346576269;
SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache FROM mpc_posts p LEFT JOIN mpc_members m ON ( m.member_id=p.author_id )
LEFT JOIN mpc_profile_portal pp ON ( m.member_id=pp.pp_member_id )
LEFT JOIN mpc_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid )
LEFT JOIN mpc_pfields_content pc ON ( pc.member_id=p.author_id )
LEFT JOIN mpc_reputation_index rep_index ON ( rep_index.app='forums' AND
														 rep_index.type='pid' AND
														 rep_index.type_id=p.pid AND
														 rep_index.member_id=420003 )
LEFT JOIN mpc_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) WHERE p.topic_id=684636 AND p.queued=0 ORDER BY p.pid asc LIMIT 450,10;

Edytowane 2 Września 2012 przez jasny