Poop If you dont get this POS server fixed - Page 5

R8RFAN · 11-06-2010, 06:17 PM

Quote:

Originally Posted by DaFace

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.

**BossChief** · 11-06-2010, 06:18 PM

I propose a "SAVE THE AIDS TREE" fund raiser.

I have a nice Chiefs leather coat that I don't wear anymore, but is a custom made one of a kind coat I would donate for a raffle or just outright bidding with proceeds going towards the planets new server if it would help.

**Buck** · 11-06-2010, 06:29 PM

Quote:

Originally Posted by BossChief

I propose a "SAVE THE AIDS TREE" fund raiser.

I have a nice Chiefs leather coat that I don't wear anymore, but is a custom made one of a kind coat I would donate for a raffle or just outright bidding with proceeds going towards the planets new server if it would help.

I have a pair of slightly used (Like New) nuthooks that I'd donate.

**Bane** · 11-06-2010, 06:30 PM

Quote:

Originally Posted by Buck

I have a pair of slightly used (Like New) nuthooks that I'd donate.

We'll need those for Dungver week mother****er!

teedubya · 11-06-2010, 07:04 PM

Quote:

Originally Posted by Buck

I have a pair of slightly used (Like New) nuthooks that I'd donate.

if you are going to sell them on Ebay... have the auction end on a Sunday night.

JD10367 · 11-06-2010, 09:32 PM

Quote:

Originally Posted by BossChief

I propose a "SAVE THE AIDS TREE" fund raiser.

I have a nice Chiefs leather coat that I don't wear anymore, but is a custom made one of a kind coat I would donate for a raffle or just outright bidding with proceeds going towards the planets new server if it would help.

How about Official t-shirts? A flaming AIDS tree being crashed into by a guy drinking antifreeze.

Otter · 11-06-2010, 07:12 PM

How much money did you donate? It's not free to keep this site up. It's actually pretty ****ing expensive.

Don't let the door hit you in the ass you weirdo.

MTG#10 · 11-06-2010, 10:23 PM

Quote:

Originally Posted by Otter

How much money did you donate? It's not free to keep this site up. It's actually pretty ****ing expensive.

Don't let the door hit you in the ass you weirdo.

Lol go **** yourself cumstain. This thread was to be taken in jest dimwit.

CHENZ A! · 11-06-2010, 07:39 PM

Quote:

Originally Posted by MTG#10

Im leaving forever.

*que Curly Bill

piiyob

Reerun_KC · 11-06-2010, 10:01 PM

Deface or Austinchief. I have 3 sr level 6+ year php/mysql devs sitting on the bench. If you pm me some contact info. I can see on Monday if I can donate their time to fix the db issues.

**Dave Lane** · 11-07-2010, 08:28 AM

Here's a hoss of a server for $400

http://cgi.ebay.com/Dell-PowerEdge-2...0#ht_500wt_922

**BigRedChief** · 11-07-2010, 09:33 AM

I've been in our current server and I'm with Daface, hardware could improve the performance but I think the main issue is the database. It's a mySQL DB. I have a Microsoft DBA certification but I didn't have the experience to get get into the DB and see about tuning a mySQL DB. So, if its some simple setting that needs to be changes, I think we would have found it by now.

I think we would benefit from a mySQL guru looking at the schema and seeing if its a config setting thats causing the DB to hang query's.

**Buck** · 04-22-2013, 03:34 PM

MTG#10 · 04-22-2013, 03:35 PM

Reported

**bevischief** · 04-22-2013, 03:36 PM

Glad it wasn't just me.

11-06-2010, 06:18 PM	#2
BossChief SuperBowl or bust Join Date: Dec 2008 Location: BF Iowa Casino cash: $1694088	I propose a "SAVE THE AIDS TREE" fund raiser. I have a nice Chiefs leather coat that I don't wear anymore, but is a custom made one of a kind coat I would donate for a raffle or just outright bidding with proceeds going towards the planets new server if it would help. __________________ Dreams do come true... http://www.chiefsplanet.com/BB/showp...postcount=1407
Posts: 47,151

11-07-2010, 08:28 AM	#11
Dave Lane Space Cadet and Aczabel Join Date: Aug 2000 Location: Kanab, UT, USA Casino cash: $9333275 VARSITY	Here's a hoss of a server for $400 http://cgi.ebay.com/Dell-PowerEdge-2...0#ht_500wt_922 __________________ Thanks, Trump for the civics lesson. We are learning so much about RICO, espionage, sedition, impeachment, the 25th Amendment, order of succession, nepotism, separation of powers, 1st Amendment, obstruction of justice, the emoluments clause, conflicts of interest, collusion, sanctions, oligarchs, money laundering and so much more.
Posts: 40,584

11-07-2010, 09:33 AM	#12
BigRedChief Has a particular set of skills Join Date: Dec 2003 Location: On the water Casino cash: $2939627 VARSITY	I've been in our current server and I'm with Daface, hardware could improve the performance but I think the main issue is the database. It's a mySQL DB. I have a Microsoft DBA certification but I didn't have the experience to get get into the DB and see about tuning a mySQL DB. So, if its some simple setting that needs to be changes, I think we would have found it by now. I think we would benefit from a mySQL guru looking at the schema and seeing if its a config setting thats causing the DB to hang query's. __________________ Time is worth more than money.
Posts: 79,182

04-22-2013, 03:34 PM	#13
Buck Take a Chill Pill Join Date: Nov 2006 Location: South Carolina Casino cash: $8299900	Bump
Posts: 44,562

04-22-2013, 03:35 PM	#14
MTG#10 Mammoth penis Join Date: May 2006 Location: Springfield Casino cash: $7424386	Reported
Posts: 11,432

11-06-2010, 10:01 PM	#10
Reerun_KC Rock Chalk Jayhawks! KU!!! Join Date: Aug 2005 Casino cash: $8301160	Deface or Austinchief. I have 3 sr level 6+ year php/mysql devs sitting on the bench. If you pm me some contact info. I can see on Monday if I can donate their time to fix the db issues.
Posts: 934

04-22-2013, 03:36 PM	#15
bevischief .... Join Date: Apr 2009 Location: Somewhere Kansas Casino cash: $8659352 VARSITY	Glad it wasn't just me.
Posts: 27,731