Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge

Reply
 
Thread Tools Display Modes
Old 11-06-2010, 02:54 PM  
MTG#10 MTG#10 is offline
EAD
 
MTG#10's Avatar
 
Join Date: May 2006
Location: Springfield
Casino cash: $12091
If you dont get this POS server fixed

Im leaving forever.



*que Curly Bill
Posts: 6,275
MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.MTG#10 is obviously part of the inner Circle.
  Reply With Quote
Old 11-06-2010, 06:52 PM   #61
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12048
Quote:
Originally Posted by D2112 View Post
Not specifically, but I've dug all over the place. Trust me, if it was something I could figure out by digging around and trying shit, I would have. I probably wasted 40-60 hours screwing with the damn thing during a two-week period a while back.
Posts: 28,666
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Old 11-06-2010, 06:53 PM   #62
Donger Donger is offline
"Think BOOM!"
 
Donger's Avatar
 

Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $671
VARSITY
Quote:
Originally Posted by Bugeater View Post
So...what is it like?
I feel like Bill Paxton's character in True Lies.
__________________
I think the young people enjoy it when I "get down," verbally, don't you?
Posts: 78,218
Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.
  Reply With Quote
Old 11-06-2010, 07:00 PM   #63
Bill Parcells Bill Parcells is offline
The Poster That Cares
 
Bill Parcells's Avatar
 

Join Date: Aug 2006
Location: Parts Unknown
Casino cash: $5905
Quote:
Originally Posted by Donger View Post

Donation sent.

+1
Posts: 15,028
Bill Parcells has disabled reputation
  Reply With Quote
Old 11-06-2010, 07:01 PM   #64
Donger Donger is offline
"Think BOOM!"
 
Donger's Avatar
 

Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $671
VARSITY
Quote:
Originally Posted by D2112 View Post
+1
Cheap bastard.
__________________
I think the young people enjoy it when I "get down," verbally, don't you?
Posts: 78,218
Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.
  Reply With Quote
Old 11-06-2010, 07:01 PM   #65
Bill Parcells Bill Parcells is offline
The Poster That Cares
 
Bill Parcells's Avatar
 

Join Date: Aug 2006
Location: Parts Unknown
Casino cash: $5905
Quote:
Originally Posted by DaFace View Post
Not specifically, but I've dug all over the place. Trust me, if it was something I could figure out by digging around and trying shit, I would have. I probably wasted 40-60 hours screwing with the damn thing during a two-week period a while back.
Holy shit..lol..well, like it hasnt been said eleventy billion times already. thanks for everything you do! I know the pay isnt as good as it was when you were an employee of RainMan Inc LTD ™
Posts: 15,028
Bill Parcells has disabled reputation
  Reply With Quote
Old 11-06-2010, 07:03 PM   #66
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $13319
Quote:
Originally Posted by Donger View Post
Would money actually solve the issues? If so, there should be a fund raiser.
it is probably an optimization issue in MYSQL, That would be the place I would start looking first.
Posts: 19,466
R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.
  Reply With Quote
Old 11-06-2010, 07:04 PM   #67
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $13319
I take that back because I rarely see a database error message when the site is having issues, lemme think a few minutes....
Posts: 19,466
R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.
  Reply With Quote
Old 11-06-2010, 07:04 PM   #68
Bill Parcells Bill Parcells is offline
The Poster That Cares
 
Bill Parcells's Avatar
 

Join Date: Aug 2006
Location: Parts Unknown
Casino cash: $5905
Quote:
Originally Posted by R8ers View Post
it is probably an optimization issue in MYSQL, That would be the place I would start looking first.
This place has a massive ****ed up database and MYSQL is a ****ing pain in the ass. when you dont allow guests it runs like a champion.
Posts: 15,028
Bill Parcells has disabled reputation
  Reply With Quote
Old 11-06-2010, 07:06 PM   #69
Buck Buck is offline
Take a Chill Pill
 
Buck's Avatar
 

Join Date: Nov 2006
Location: San Diego
Casino cash: $4267
I just donated $10 with the stipulation that I'll donate more if a Donation Request thread is created for a new server...
Posts: 42,322
Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.Buck is obviously part of the inner Circle.
  Reply With Quote
Old 11-06-2010, 07:07 PM   #70
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $13319
I notice the site hangs, wonder if you may have a bad stick of ram or possibly a hard drive failure in the early stages?
Posts: 19,466
R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.
  Reply With Quote
Old 11-06-2010, 07:10 PM   #71
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $13319
Quote:
Originally Posted by D2112 View Post
This place has a massive ****ed up database and MYSQL is a ****ing pain in the ass. when you dont allow guests it runs like a champion.
Well, actually unless they have a very old server, it should handle a thousand or so on at once with some slowdown but not crashing... I had over 750 online at once on my server.. and it barely got over a 2 on the server load

I know at peak times, especially after a loss this place is hard to get on but during the week this should not be happening... Still think it may be a bad stick of ram or a hard drive beginning to stick and fail
Posts: 19,466
R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.R8RFAN has enough rep power to blowy ou to bits.
  Reply With Quote
Old 11-06-2010, 07:12 PM   #72
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12048
Quote:
Originally Posted by R8ers View Post
I notice the site hangs, wonder if you may have a bad stick of ram or possibly a hard drive failure in the early stages?
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.
Posts: 28,666
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Old 11-06-2010, 07:14 PM   #73
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12048
Quote:
Originally Posted by R8ers View Post
Well, actually unless they have a very old server, it should handle a thousand or so on at once with some slowdown but not crashing... I had over 750 online at once on my server.. and it barely got over a 2 on the server load

I know at peak times, especially after a loss this place is hard to get on but during the week this should not be happening... Still think it may be a bad stick of ram or a hard drive beginning to stick and fail
Our POST table is over 2 gigs in size - that's much more of a likely culprit than heavy user load. I've added a couple indexes, but that obviously hasn't helped much.
Posts: 28,666
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Old 11-06-2010, 07:14 PM   #74
Bill Parcells Bill Parcells is offline
The Poster That Cares
 
Bill Parcells's Avatar
 

Join Date: Aug 2006
Location: Parts Unknown
Casino cash: $5905
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.
You dont restart MYSQL when it lags? it's an automated reset?
Posts: 15,028
Bill Parcells has disabled reputation
  Reply With Quote
Old 11-06-2010, 07:16 PM   #75
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $12048
Quote:
Originally Posted by D2112 View Post
You dont restart MYSQL when it lags? it's an automated reset?
If I'm around, I do. If not, it hangs until mysql crashes and restarts itself.
Posts: 28,666
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
  Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump




All times are GMT -6. The time now is 05:31 PM.


This is a test for a client's site.
A new website that shows member-created construction site listings that need fill or have excess fill. Dirt Monkey @ https://DirtMonkey.net
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.