View Single Post
Old 11-06-2010, 06:17 PM   #76
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $20007
Quote:
Originally Posted by DaFace View Post
Eh, maybe, but I doubt it. The basic underlying condition is that we occasionally have a query that just gets "stuck." Many times, it's a completely innocuous query (like the one that grabs the posts for a thread), so it's not that the specific query is the issue. But when one gets stuck, it locks the POST table, which causes tons of others to back up behind it.

Most of the time, the stuck query eventually finishes up, and the rest then complete. That's what is happening when we have a 15-30 second lag here and there.

Other times, the query just gets stuck for an insane amount of time. They're supposed to time out after a few minutes, but often don't for some reason. When that happens, it can take the place down for a long time until MySQL eventually croaks and resets itself. By that point, the stuck query has driven our server loads through the roof, so it takes even longer for the average load to come back down far enough for vB to let people back in. That's generally the issue we've seen on gamedays.

I THINK it has something to do with our memory allocation (key_buffers and stuff like that), but my tweaks don't seem to make any difference.
If you can explain to the people I sent you the PM about, I am almost positive they can fix something like that. I just make a ticket out and the problem is fixed within a few hours and they tell you exactly what they did too.
Posts: 21,338
R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.R8RFAN is obviously part of the inner Circle.
  Reply With Quote