Noo, don't give up, Kristen.
Hang in there. Rob's in geek Sherlock Holmes mode, which is all for the good.
Tara: 'Your One-Stop Spot to Shop for Lots of New-Age and Occult Items.' Catchy. Giles: Think so? Tara: Uh huh. In a... hard to say sorta way.
'Sleeper'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Consuela - Aug 27, 2003 2:03:44 pm PDT #4847 of 10000
We are Buffistas. This isn't our first apocalypse. -- Pix
DXMachina - Aug 27, 2003 2:23:10 pm PDT #4848 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
I now suspect that the problem isn't so much too many connections, as too many MySQL threads running at the same time.
Just to be clear to the non-techies (and even some of us techies), Rob, you're not talking about threads in the sense of Natter, Bitches, etc. You're talking about threads of instructions to the database, or something similar, right?
Rob - Aug 27, 2003 2:31:39 pm PDT #4849 of 10000
Yes, I'm talking about threads of instructions to the database. Boy I wish I'd thought of that potential area of confusion up front.
§ ita § - Aug 27, 2003 2:33:46 pm PDT #4850 of 10000
Well not canonically, no, but this is transformative fiction.
Yeah, he mean threads as in the technical term, which is like one instance of a program running -- the details are a) not so important and b) going to be badly explained by me, so never mind.
However, the tech guy says it's connections, not threads, so we need to focus on addressing what he sees as the problem. He calls the shots.
edit: Or what Rob said.
Rob - Aug 27, 2003 2:36:55 pm PDT #4851 of 10000
Is it total number of connections over a period, or max concurrent connections that they are concerned about?
§ ita § - Aug 27, 2003 2:40:48 pm PDT #4852 of 10000
Well not canonically, no, but this is transformative fiction.
I think it's the # of connections open at that "moment", but I'll double check.
Liese S. - Aug 27, 2003 7:33:59 pm PDT #4853 of 10000
"Faded like the lilac, he thought."
Yup, as I recall it was max concurrent connections that are the deal.
Rob - Aug 27, 2003 8:28:48 pm PDT #4854 of 10000
Do we know when they changed the wait_timeout from the default to five minutes? Was that after the last time the server fell over and caught fire?
Cindy - Aug 28, 2003 3:16:30 am PDT #4855 of 10000
Nobody
This may have been reported already, as it happened on August 21, but just in case...
erikaj "Bitchy Fic: It Could Be Plot Bunnies" Aug 21, 2003 10:58:03 am PDT
juliana "Bitchy Fic: It Could Be Plot Bunnies" Aug 21, 2003 11:04:41 am PDT
These posts are not separated.
DXMachina - Aug 28, 2003 3:34:20 am PDT #4856 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
They are now. There was a problem with a link in erika's post. It's fixed.