Search lock table. Forum is down

[Dimoks]

I have 100% this problem - http://www.vbulletin.org/forum/showthread.php?t=119263

If search disable - all ok.

Search type - fulltext.
mysql 5.1.28 rc


Please help me!

[unp]

Did it happen after you upgraded mysql to 5.1 ?

[Dimoks]

Did it happen after you upgraded mysql to 5.1 ?

no
mysql 5.0+freebsd 6.2 or mysql 5.1+freebsd 6.3 without a difference ...



search - lock table.... and arcade (games).

| 6349 | dimoks_db1 | localhost | dimoks_db1 | Query | 93 | Locked | UPDATE session 
SET lastactivity = 1224511455, location = '/arcade.php', inforum = 0, inthread = | 
| 6371 | dimoks_db1 | localhost | dimoks_db1 | Query | 95 | Locked | UPDATE session 
SET lastactivity = 1224511456, location = '/usercp.php', loggedin = 2, inforum = | 
| 6374 | dimoks_db1 | localhost | dimoks_db1 | Query | 95 | Locked |

normal

last pid: 96402; load averages: 0.62, 0.64, 0.95 up 0+19:09:23 11:57:13 
100 processes: 1 running, 98 sleeping, 1 zombie 
CPU states: 6.7% user, 0.0% nice, 1.7% system, 0.3% interrupt, 91.4% idle 
Mem: 242M Active, 2092M Inact, 270M Wired, 121M Cache, 112M Buf, 531M Free 
Swap: 2048M Total, 40K Used, 2048M Free 
 
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND 
96363 mysql 15 20 0 467M 96572K kserel 2 0:51 1.52% mysqld 
96401 www 1 96 0 49860K 16308K select 1 0:00 1.10% httpd 
96383 www 1 4 0 52372K 24992K accept 2 0:01 0.90% httpd 
96387 www 1 96 0 51052K 20280K select 3 0:01 0.90% httpd 
95382 www 1 96 0 51552K 22324K select 2 0:01 0.83% httpd 
96397 www 1 96 0 49940K 18732K select 2 0:00 0.73% httpd 
95364 www 1 96 0 50772K 21884K select 2 0:01 0.68% httpd 
95331 www 1 4 0 49928K 23252K accept 2 0:01 0.63% httpd 
96394 www 1 4 0 50784K 18544K accept 2 0:00 0.44% httpd 
95354 www 1 4 0 50896K 22044K accept 2 0:01 0.39% httpd 
95430 www 1 96 0 50900K 23184K select 2 0:01 0.39% httpd 
95417 www 1 96 0 51056K 25852K select 1 0:01 0.34% httpd 
95294 www 1 4 0 51072K 23232K accept 2 0:01 0.24% httpd 
95347 www 1 96 0 50976K 22920K select 3 0:01 0.15% httpd

table locked

last pid: 95445; load averages: 0.01, 0.71, 1.08 up 0+19:05:41 11:53:31 
349 processes: 1 running, 348 sleeping 
CPU states: 0.0% user, 0.0% nice, 0.1% system, 0.0% interrupt, 99.9% idle 
Mem: 700M Active, 2089M Inact, 274M Wired, 121M Cache, 112M Buf, 72M Free 
Swap: 2048M Total, 40K Used, 2048M Free 
 
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND 
92263 mysql 158 20 0 543M 184M kserel 0 14:52 0.00% mysqld 
774 root 1 96 0 3552K 1920K select 0 0:05 0.00% sshd 
10701 mk 1 96 0 2208K 1624K select 0 0:04 0.00% screen 
794 root 1 96 0 3528K 2440K select 0 0:04 0.00% sendmail 
539 root 1 96 0 3008K 1412K select 0 0:02 0.00% ntpd 
95173 www 1 4 0 53260K 28732K sbwait 2 0:02 0.00% httpd 
95185 www 1 4 0 52092K 20924K sbwait 0 0:02 0.00% httpd 
95193 www 1 4 0 50708K 19716K sbwait 2 0:02 0.00% httpd 
95145 www 1 4 0 52888K 26452K sbwait 0 0:02 0.00% httpd 
92300 root 1 8 0 49572K 11368K nanslp 0 0:02 0.00% httpd 
435 root 1 96 0 1384K 832K select 0 0:01 0.00% syslogd 
95163 www 1 4 0 52156K 25884K sbwait 1 0:01 0.00% httpd 
95210 www 1 4 0 51068K 26044K sbwait 1 0:01 0.00% httpd 
95301 www 1 4 0 52736K 21768K sbwait 0 0:01 0.00% httpd 
95207 www 1 4 0 51536K 25032K sbwait 3 0:01 0.00% httpd

please help

p.s. vb 3.7.3

[Dimoks]

upgrade to 3.7.4 ...
nothing..

please help