Announcement

Collapse
No announcement yet.

Search lock table. Forum is down

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dimoks
    replied
    upgrade to 3.7.4 ...
    nothing..

    please help

    Leave a comment:


  • Dimoks
    replied
    Originally posted by unp View Post
    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).

    Code:
    | 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
    Code:
    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
    Code:
    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

    Leave a comment:


  • unp
    replied
    Did it happen after you upgraded mysql to 5.1 ?

    Leave a comment:


  • Dimoks
    started a topic Search lock table. Forum is down

    Search lock table. Forum is down

    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!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X