Announcement

Collapse
No announcement yet.

Search lock table. Forum is down

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

  • 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!

  • #2
    Did it happen after you upgraded mysql to 5.1 ?
    I need a drink...

    Comment


    • #3
      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

      Comment


      • #4
        upgrade to 3.7.4 ...
        nothing..

        please help

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X