Witam
Mam jeden problem , otoz posiadam na swoim sereze forum IBP wraz z jego baza i wszystko dziala idealnie , natomiast inne forum ( tez IBP ) ma cos pokrecone z baza .............

kiedy forum zaczyna dzialac nagle pojawiaja sie w procesach - takie krzeaczki ( a dokladnie owiele wiecej ) :

+------+-------------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-------------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 2241 | elite_user3 | localhost | elite_baza3 | Query | 171 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=1716 |
| 2260 | elite_user3 | localhost | elite_baza3 | Query | 180 | Sending data | SELECT p.pid, p.queued, t.approved, t.forum_id
FROM _ipb_posts p
LEFT JOIN _ipb_t |
| 2262 | elite_user3 | localhost | elite_baza3 | Query | 180 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=26499 |
| 2265 | elite_user3 | localhost | elite_baza3 | Query | 180 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=31090 |
| 2268 | elite_user3 | localhost | elite_baza3 | Query | 178 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=29843 |
| 2273 | elite_user3 | localhost | elite_baza3 | Query | 178 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=30320 |
| 2274 | elite_user3 | localhost | elite_baza3 | Query | 177 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=29843 |
| 2278 | elite_user3 | localhost | elite_baza3 | Query | 175 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=31005 |
| 2322 | elite_user3 | localhost | elite_baza3 | Query | 164 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=9949 |
| 2349 | elite_user3 | localhost | elite_baza3 | Query | 161 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=30999 |
| 2369 | root | localhost | elite_baza3 | Query | 145 | Locked | REPAIR TABLE `_ipb_posts` |
| 2380 | elite_user3 | localhost | elite_baza3 | Query | 154 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=9949 |
| 2393 | elite_user3 | localhost | elite_baza3 | Query | 148 | Locked | UPDATE LOW_PRIORITY _ipb_topics SET views=views+1 WHERE tid=30982 |
| 2418 | elite_user3 | localhost | elite_baza3 | Query | 147 | Sending data | SELECT p.pid, p.queued, t.approved, t.forum_id
FROM _ipb_posts p
LEFT JOIN _ipb_t |
| 2426 | elite_user3 | localhost | elite_baza3 | Query | 144 | Locked | SELECT p.pid, p.queued, t.approved, t.forum_id
FROM _ipb_posts p
LEFT JOIN _ipb_t |
| 2427 | elite_user3 | localhost | elite_baza3 | Query | 144 | Locked | SELECT author_id, topic_id FROM _ipb_posts WHERE author_id=6724 AND topic_id IN(1063,1703,8323,11192, |
| 2428 | elite_user3 | localhost | elite_baza3 | Query | 144 | Locked | SELECT author_id, topic_id FROM _ipb_posts WHERE author_id=3915 AND topic_id IN(1726,4003,26414,26451 |
| 2429 | elite_user3 | localhost | elite_baza3 | Query | 144 | Locked | SELECT author_id, topic_id FROM _ipb_posts WHERE author_id=14765 AND topic_id IN(1779,5398,6415,12712 |
| 2445 | elite_user3 | localhost | elite_baza3 | Query | 141 | Locked | SELECT pid,topic_id FROM _ipb_posts WHERE topic_id=27225 and queued=0 ORDER BY pid asc LIMIT 0,20 |
| 2464 | elite_user3 | localhost | elite_baza3 | Query | 138 | Locked | SELECT MIN(pid) as pid FROM _ipb_posts WHERE queued=0 AND topic_id=24376 AND post_date > 1144671142 L |
| 2471 | elite_user3 | localhost | elite_baza3 | Query | 136 | Locked | SELECT author_id, topic_id FROM _ipb_posts WHERE author_id=17876 AND topic_id IN(1049,1785,3466,6707, |
| 2472 | elite_user3 | localhost | elite_baza3 | Query | 135 | Locked | UPDATE _ipb_members SET login_anonymous='0&1', last_activity=1144689879 WHERE id=24379 |
| 2474 | elite_user3 | localhost | elite_baza3 | Query | 135 | Locked | SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login |
| 2475 | elite_user3 | localhost | elite_baza3 | Query | 135 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2478 | elite_user3 | localhost | elite_baza3 | Query | 134 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2480 | elite_user3 | localhost | elite_baza3 | Query | 134 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2481 | elite_user3 | localhost | elite_baza3 | Query | 134 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2489 | elite_user3 | localhost | elite_baza3 | Query | 132 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2492 | elite_user3 | localhost | elite_baza3 | Query | 132 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2497 | elite_user3 | localhost | elite_baza3 | Query | 131 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2501 | elite_user3 | localhost | elite_baza3 | Query | 131 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2523 | elite_user3 | localhost | elite_baza3 | Query | 127 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2527 | elite_user3 | localhost | elite_baza3 | Query | 126 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2530 | elite_user3 | localhost | elite_baza3 | Query | 124 | Locked | SELECT author_id, topic_id FROM _ipb_posts WHERE author_id=24379 AND topic_id IN(179,188,964,2550,261 |
| 2537 | elite_user3 | localhost | elite_baza3 | Query | 123 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2540 | elite_user3 | localhost | elite_baza3 | Query | 123 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2544 | elite_user3 | localhost | elite_baza3 | Query | 122 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2553 | elite_user3 | localhost | elite_baza3 | Query | 120 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2557 | elite_user3 | localhost | elite_baza3 | Query | 119 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2574 | elite_user3 | localhost | elite_baza3 | Query | 114 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2575 | elite_user3 | localhost | elite_baza3 | Query | 114 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2578 | elite_user3 | localhost | elite_baza3 | Query | 113 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2601 | elite_user3 | localhost | elite_baza3 | Query | 109 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2604 | elite_user3 | localhost | elite_baza3 | Query | 107 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2613 | elite_user3 | localhost | elite_baza3 | Query | 106 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2618 | elite_user3 | localhost | elite_baza3 | Query | 105 | Locked | SELECT pid,topic_id FROM _ipb_posts WHERE topic_id=31025 and queued=0 ORDER BY pid asc LIMIT 0,20 |
| 2626 | elite_user3 | localhost | elite_baza3 | Query | 104 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2641 | elite_user3 | localhost | elite_baza3 | Query | 99 | Locked | select id, name, members_display_name, members_created_remote, email, mgroup, member_login_key, ip_a |
| 2642 | elite_user3 | localhost | elite_baza3 | Query | 98 | Locked | SELECT pid,topic_id FROM _ipb_posts WHERE topic_id=31012 and queued=0 ORDER BY pid asc LIMIT 0,20 |
| 2643 | elite_user3 | localhost | elite_baza3 | Query | 98 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2644 | elite_user3 | localhost | elite_baza3 | Query | 98 | Locked | UPDATE _ipb_members SET bday_day=24,bday_month=5,bday_year=1988 WHERE id=5258 |
| 2648 | elite_user3 | localhost | elite_baza3 | Query | 96 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2652 | elite_user3 | localhost | elite_baza3 | Query | 95 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2660 | elite_user3 | localhost | elite_baza3 | Query | 95 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2669 | elite_user3 | localhost | elite_baza3 | Query | 92 | Locked | UPDATE _ipb_members SET login_anonymous='&0', last_visit=1144689923, last_activity=1144689923 WHERE i |
| 2670 | elite_user3 | localhost | elite_baza3 | Query | 92 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2673 | elite_user3 | localhost | elite_baza3 | Query | 91 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2681 | elite_user3 | localhost | elite_baza3 | Query | 90 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2700 | elite_user3 | localhost | elite_baza3 | Query | 86 | Locked | SELECT author_id, topic_id FROM _ipb_posts WHERE author_id=17876 AND topic_id IN(1049,1785,3466,6707, |
| 2704 | elite_user3 | localhost | elite_baza3 | Query | 84 | Locked | SELECT m.*, me.*, s.location_1_id, s.location_2_id, s.location_1_type, s.location_2_type, s.running_ |
| 2708 | elite_user3 | localhost | elite_baza3 | Query | 83 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2711 | elite_user3 | localhost | elite_baza3 | Query | 83 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2717 | elite_user3 | localhost | elite_baza3 | Query | 81 | Locked | SELECT m.*,g.*,p.* FROM _ipb_members m LEFT JOIN _ipb_groups g ON ( g.g_id=m.mgroup )
LEFT JOIN ibf |
| 2718 | elite_user3 | localhost | elite_baza3 | Query | 80 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2724 | elite_user3 | localhost | elite_baza3 | Query | 79 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2726 | elite_user3 | localhost | elite_baza3 | Query | 78 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2727 | elite_user3 | localhost | elite_baza3 | Query | 76 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2730 | elite_user3 | localhost | elite_baza3 | Query | 76 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2738 | elite_user3 | localhost | elite_baza3 | Query | 72 | Locked | select id, name, members_display_name, members_created_remote, email, mgroup, member_login_key, ip_a |
| 2741 | elite_user3 | localhost | elite_baza3 | Query | 70 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2744 | elite_user3 | localhost | elite_baza3 | Query | 71 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2745 | elite_user3 | localhost | elite_baza3 | Query | 71 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2748 | elite_user3 | localhost | elite_baza3 | Query | 70 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2755 | elite_user3 | localhost | elite_baza3 | Query | 69 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2758 | elite_user3 | localhost | elite_baza3 | Query | 68 | Locked | select id, name, members_display_name, members_created_remote, email, mgroup, member_login_key, ip_a |
| 2769 | elite_user3 | localhost | elite_baza3 | Query | 65 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2772 | elite_user3 | localhost | elite_baza3 | Query | 61 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2773 | elite_user3 | localhost | elite_baza3 | Query | 64 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2787 | elite_user3 | localhost | elite_baza3 | Query | 59 | Locked | SELECT author_id, topic_id FROM _ipb_posts WHERE author_id=646 AND topic_id IN(23712,23981,24306,2437 |
| 2790 | elite_user3 | localhost | elite_baza3 | Query | 58 | Locked | SELECT pid,topic_id FROM _ipb_posts WHERE topic_id=31025 and queued=0 ORDER BY pid asc LIMIT 0,20 |
| 2805 | elite_user3 | localhost | elite_baza3 | Query | 54 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2807 | elite_user3 | localhost | elite_baza3 | Query | 54 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2814 | elite_user3 | localhost | elite_baza3 | Query | 52 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2816 | elite_user3 | localhost | elite_baza3 | Query | 51 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2830 | elite_user3 | localhost | elite_baza3 | Query | 49 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2837 | elite_user3 | localhost | elite_baza3 | Query | 46 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2842 | elite_user3 | localhost | elite_baza3 | Query | 45 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2854 | elite_user3 | localhost | elite_baza3 | Query | 44 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2876 | elite_user3 | localhost | elite_baza3 | Query | 37 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2888 | elite_user3 | localhost | elite_baza3 | Query | 34 | Locked | select id, name, members_display_name, members_created_remote, email, mgroup, member_login_key, ip_a |
| 2890 | elite_user3 | localhost | elite_baza3 | Query | 33 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2905 | elite_user3 | localhost | elite_baza3 | Query | 29 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2908 | elite_user3 | localhost | elite_baza3 | Query | 28 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2915 | elite_user3 | localhost | elite_baza3 | Query | 25 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2917 | elite_user3 | localhost | elite_baza3 | Query | 24 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2926 | elite_user3 | localhost | elite_baza3 | Query | 21 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2932 | elite_user3 | localhost | elite_baza3 | Query | 18 | Locked | SELECT m.*, me.*, s.location_1_id, s.location_2_id, s.location_1_type, s.location_2_type, s.running_ |
| 2963 | elite_user3 | localhost | elite_baza3 | Query | 10 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2966 | elite_user3 | localhost | elite_baza3 | Query | 9 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2968 | elite_user3 | localhost | elite_baza3 | Query | 8 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2969 | elite_user3 | localhost | elite_baza3 | Query | 8 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2972 | elite_user3 | localhost | elite_baza3 | Query | 6 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 2987 | root | localhost | | Query | 0 | | show processlist |


>>>>> przepraszam za tak dluga liste <<<<<<<

natomiast pierwsze forum to ktore dziala bezblednie pokazuje taka liste procesow :

| Id | User | Host | db | Command | Time | State | Info |
+------+-----------+-----------+-----------+---------+------+-------+------------------+
| 8173 | witus_001 | localhost | witus_001 | Sleep | 1 | | |
| 8175 | witus_001 | localhost | witus_001 | Sleep | 0 | | |
| 8177 | root | localhost | | Query | 0 | | show processlist |


- Jak widzimy to wszystkie procesy sie zamykaja bez blednie pomimo takiej samej liczby zapytan ( w przyblizeniu ) .

Wychodzi na to ze " uszkodzona " baza nie zamyka procesow ( polaczen ) tylko je blokuje ( LOCKED ) i nadal przytrzymuje polaczenia powodujac ich nawarstwianie sie az do zawieszenia serwera .

Co mozna zrobic w tym wypadku , jakie kroki nalez podwziaść aby ta baza funkcjonowala normalnie lub chociaz by automatycznie zamykac procesy -> cokolwiek co moze pomuc w tym wypadku ..........

Prosze o pomoc i z gory dziekuje ..................