Zapytania SQL powodujące zawieszenie serwera.

[Łukasz]

Witam serdecznie.

Dostaliśmy info ze nasze forum zarzyna serwer vps.

Adres forum to warezdark.pl

Oto zapytania co powodują problem.

 

 

mazishar 11529 0.1 0.3 93688 16040 ? S 22:22 0:00 /usr/local/php5/bin/php-cgi /home/mazishar/domains/warezdark.pl/public_html/index.php
mazishar 11530 0.2 0.5 99728 22092 ? S 22:22 0:00 /usr/local/php5/bin/php-cgi /home/mazishar/domains/warezdark.pl/public_html/index.php
mazishar 11531 0.1 0.3 94184 16524 ? S 22:22 0:00 /usr/local/php5/bin/php-cgi /home/mazishar/domains/warezdark.pl/public_html/index.php
mazishar 11536 0.2 0.3 93904 16392 ? S 22:22 0:00 /usr/local/php5/bin/php-cgi /home/mazishar/domains/warezdark.pl/public_html/index.php
mazishar 11537 0.1 0.3 94056 16416 ? S 22:22 0:00 /usr/local/php5/bin/php-cgi /home/mazishar/domains/warezdark.pl/public_html/index.php
mazishar 11540 0.2 0.3 93684 16160 ? S 22:22 0:00 /usr/local/php5/bin/php-cgi /home/mazishar/domains/warezdark.pl/public_html/index.php
*********** Query 72 Sending data SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.join
ed,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_nam
e, 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,cca.*,ccb.cache_c
ontent as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ibf_posts p LEFT JOIN ibf_members m ON ( m.member_id=p.author_id ) \n LEFT JOIN ibf
_profile_portal pp ON ( m.member_id=pp.pp_member_id ) \n LEFT JOIN ibf_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) \n LEF
T JOIN ibf_pfields_content pc ON ( pc.member_id=p.author_id ) \n LEFT JOIN ibf_reputation_index rep_index ON ( rep_index.app='forums' AND \n\t\t\t\t\t\t
rep_index.type='pid' AND \n\t\t\t\t\t\t rep_index.type_id=p.pid AND \n\t\t\t\t\t\t rep_index.member_id=0 ) \n LEFT JOIN ibf_c
ontent_cache_posts cca ON ( cca.cache_content_id=p.pid ) \n LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE p.topic_id=1
9902 AND p.queued=0 ORDER BY p.pid asc LIMIT 60,20

 

 

Pomożecie w zdiagnozowaniu problemu??

Z góry dziękuje i pozdrawiam.

[DawPi]

Takie logi nic nie mówią niestety.