ROZWIĄZANY: Ogromny load serwera wiszące zapytania.

[Łukasz]

Witam serdecznie.

Od kilku tygodni pojawił nam sie wielki load serwera około 20.00.

Zawieszają nam się zapytania na bazie oto ich skrót:

1046686 |***** | localhost | down***** | Query | 2 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1046837 |***** | localhost | down***** | Query | 2 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1046974 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1047111 |***** | localhost | down***** | Query | 2 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1047248 |***** | localhost | down***** | Query | 2 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1047370 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1047526 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1047690 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1047868 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1048008 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1048156 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1048334 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1048498 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1048635 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1048804 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1048981 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1049140 |***** | localhost | down***** | Query | 3 | Sending data | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1049304 |***** | localhost | down***** | Query | 0 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1049459 |***** | localhost | down***** | Query | 0 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1049683 |***** | localhost | down***** | Query | 0 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1049827 |***** | localhost | down***** | Query | 0 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1049992 |***** | localhost | down***** | Query | 0 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1050141 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1050303 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1050463 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1050586 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.*, f.ipseo_priority FROM ibf_topics t LEFT JOIN ibf_permission_index p ON ( (p.perm_type = |
| 1050695 | da_admin | localhost | NULL | Query | 0 | NULL | show processlist |
| 1050724 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.tid, t.title as topic_title, t.title_seo, t.start_date, t.starter_id, t.starter_name, t.mov |
| 1050726 |***** | localhost | down***** | Query | 2 | Locked | UPDATE ibf_topics SET views=views+1 WHERE tid=79625 |
| 1050727 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.tid, t.title as topic_title, t.title_seo, t.start_date, t.starter_id, t.starter_name, t.mov |
| 1050729 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.tid, t.title as topic_title, t.title_seo, t.start_date, t.starter_id, t.starter_name, t.mov |
| 1050738 |***** | localhost | down***** | Query | 2 | Locked | SELECT count(*) as count FROM ibf_topics WHERE last_post > 1321626595 AND forum_id IN (207,208,209,2 |
| 1050741 |***** | localhost | down***** | Query | 1 | Locked | SELECT count(*) as count FROM ibf_topics WHERE last_post > 1321626596 AND forum_id IN (207,208,209,2 |
| 1050742 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.*,xxx.* FROM ibf_topics t LEFT JOIN ibf_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CON |
| 1050744 |***** | localhost | down***** | Query | 1 | Locked | SELECT t.*,xxx.* FROM ibf_topics t LEFT JOIN ibf_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CON |
| 1050746 |***** | localhost | down***** | Query | 0 | Locked | SELECT t.tid as id, t.tid as topic_id, t.title, t.posts, t.views, t.last_post FROM ibf_topics t WHER

Przesilimy na najnowsza wersje ip board bo serwisanci twierdzili ze to wina skryptu, niestety nadal to samo.

Serwer deykowany i7 bardzo mocna maszyna.

MYSQL Wersja MYSQL 5.1.59

Wersja PHP 5.2.17 (litespeed)

Oprogramowanie serwera Linux ns1***.se*****l 2.6.35.4-grsec #1 SMP Mon Sep 20 20:12:11 CEST 2010 x86_64

Jakieś pomysły rady co powoduje zawieszanie sie tych zapytań??

[Łukasz]

Na ludzkie rozumowanie laika odinstalowałem ip.seo.

Zabiliśmy wiszące procesy load spadł zobaczymy czy to pomoże a wy macie jakieś sugestie?

[Pavulon]

A przypadkiem w tym czasie nie była generowana mapa strony? To dość ciężki proces w przypadku dużego forum.

[Łukasz]

Co jest najlepsze to tylko ja zaktualizowałem z poprzedniej wersji.

Odinstalowanie jej zażegnało problem.

[DawPi]

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.