Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room

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

Im leaving forever.



*que Curly Bill
Posts: 11,428
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, 05:52 PM   #61
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2426899
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: 51,548
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, 05: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: $10739900
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: 179,847
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, 06:00 PM   #63
2112 2112 is offline
Reset
 
2112's Avatar
 

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

Donation sent.

+1
Posts: 22,055
2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.
    Reply With Quote
Old 11-06-2010, 06: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: $10739900
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: 179,847
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, 06:01 PM   #65
2112 2112 is offline
Reset
 
2112's Avatar
 

Join Date: Aug 2006
Location: Parts Unknown
Casino cash: $8646765
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: 22,055
2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.
    Reply With Quote
Old 11-06-2010, 06:03 PM   #66
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $8566872
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: 23,164
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
Old 11-06-2010, 06:04 PM   #67
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $8566872
I take that back because I rarely see a database error message when the site is having issues, lemme think a few minutes....
Posts: 23,164
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
Old 11-06-2010, 06:04 PM   #68
2112 2112 is offline
Reset
 
2112's Avatar
 

Join Date: Aug 2006
Location: Parts Unknown
Casino cash: $8646765
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: 22,055
2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.
    Reply With Quote
Old 11-06-2010, 06:06 PM   #69
Buck Buck is offline
Take a Chill Pill
 
Buck's Avatar
 

Join Date: Nov 2006
Location: South Carolina
Casino cash: $8359900
I just donated $10 with the stipulation that I'll donate more if a Donation Request thread is created for a new server...
Posts: 44,562
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, 06:07 PM   #70
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $8566872
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: 23,164
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
Old 11-06-2010, 06:10 PM   #71
R8RFAN R8RFAN is offline
Molôn Labé
 
R8RFAN's Avatar
 

Join Date: Sep 2001
Location: North Carolina
Casino cash: $8566872
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: 23,164
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
Old 11-06-2010, 06:12 PM   #72
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2426899
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: 51,548
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:14 PM   #73
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2426899
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: 51,548
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:14 PM   #74
2112 2112 is offline
Reset
 
2112's Avatar
 

Join Date: Aug 2006
Location: Parts Unknown
Casino cash: $8646765
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: 22,055
2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.2112 is obviously part of the inner Circle.
    Reply With Quote
Old 11-06-2010, 06:16 PM   #75
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2426899
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: 51,548
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 03:30 AM.


This is a test for a client's site.
Fort Worth Texas Process Servers
Covering Arlington, Fort Worth, Grand Prairie and surrounding communities.
Tarrant County, Texas and Johnson County, Texas.
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.