Announcement

Collapse
No announcement yet.

Table locked

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

  • Table locked

    Hi!

    Why I get so many locked processes at vbulletin when there are more then 300 guests?

    Queries like these:
    "UPDATE LOW_PRIORITY thread SET views = views + 1 WHERE threadid = '7084' "
    or
    "UPDATE user SET lastactivity = 1071504223 WHERE userid = 0 AND lastactivity < 1071504223 "


    We have seperated web- and mysql-server.
    vbulletin 2.3.2
    mysql 3.23.56

  • #2
    You can't do anything about the first unless you either wish to upgrade to vB3 Gamma or disable thread views.

    The second would appear to be a bug. Open admincp/functions.php and look for around line 2500:

    PHP Code:
    $oldsessions=$DB_site->query("SELECT userid,lastactivity FROM session WHERE lastactivity<'".(time()-$cookietimeout)."'"); 
    Replace with:

    PHP Code:
    $oldsessions $DB_site->query("SELECT userid,lastactivity FROM session WHERE userid <> 0 AND lastactivity<'" . (time() - $cookietimeout) . "'"); 

    Comment


    • #3
      thx!

      is there any use to upgrade to mysql 4.0.16 in this case?

      Comment

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