FYI - Steven and I are going to have an IM convo tomorrow about the persistent connection thing. I'll also bring up the logging thing.
You guys had a riot? On account of me? A real riot?
Jayne ,'Jaynestown'
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.
Kristen - Aug 04, 2003 7:56:03 pm PDT #4523 of 10000
Jessica - Aug 05, 2003 5:46:28 am PDT #4524 of 10000
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Board was nonresponsive for 5-10 minutes, around 7:40 AM, board time.
Michele T. - Aug 05, 2003 7:20:00 am PDT #4525 of 10000
with a gleam in my eye, and an almost airtight alibi
I've tossed the "too many connections" problems to a bunch of geek friends, who have been on it like a pack of red meat. They're a little concerned about the persistent connection thing themselves. Here are some of the questions they asked me about it:
What kind of machine is this running on? How many queries a second are you getting, and what's the read/write proportion?
Is it possible more than one MySQL connection gets made for each page request? If every place in your PHP code that you need to get data from the database a new connection is opened, you could see 10, 20, or even more MySQL connections per page request.
Could someone who knows the stats pass on the answers? They're all quite willing to advise, and I'd hate to not use the resource if we have it.
§ ita § - Aug 05, 2003 7:26:47 am PDT #4526 of 10000
Well not canonically, no, but this is transformative fiction.
Michele, your profile e-address is hidden, so I sent it to what I have most recently on file.
If every place in your PHP code that you need to get data from the database a new connection is opened
This contradicts my interpretation of this part of the manual:
If a second call is made to mysql_connect() with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned
We don't use the new_link parameter at all -- which implies that you get one connection opened with the first call, and closed with the end of each page.
However, that was then. Now it's opened and closed every call, which just screams wrong to me. But quick fix, I guess.
Kristen - Aug 05, 2003 7:35:02 am PDT #4527 of 10000
There are probably going to be board outages for another few days. Nothing I can do about it at this point. I just have to ask people to please be patient and hope that it gets better in our new home. Which we should be relocating to on Thursday.
What kind of machine is this running on?
As of right now, we're on a P3. I don't have the RAM or hard drive info in front me. It's on the PC at home. Starting later this week, we'll be on a dual xeon server with 2gb ram and two 120gb hard drives.
amych - Aug 05, 2003 7:59:58 am PDT #4528 of 10000
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
it seems like this might be a good opportunity to start and/or crank up the dev list that never really got moving when we were at HR, no?
§ ita § - Aug 05, 2003 8:11:54 am PDT #4529 of 10000
Well not canonically, no, but this is transformative fiction.
Good point, amych.
Any comments or questions on the ERD I just sent out should go to dev(at)buffistas.org.
DXMachina - Aug 05, 2003 4:45:14 pm PDT #4530 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
As I noted in Bureaucracy, the perl script that John wrote to threadsuck WX threads doesn't seem to work anymore. It reads the first page of posts, then can't find the next page, so it stops. The end of sucked thread indicates that the link used for the next page is incorrect. I suspect WX may have changed the way it references the next page, but I don't have the perl knowledge to do anything about it even if I could figure out what's going on. Does anyone want to have a go at seeing if they can get it to work? A copy of the script is here.
Karl - Aug 05, 2003 10:43:21 pm PDT #4531 of 10000
I adore all you motherfuckers so much -- PMM.
DX, up at the top of the script, $SITE is defined as "http://www.worldcrossing.com"
If you change that line to
$SITE = "http://wc1.worldcrossing.com"
... that should fix things, I hope.
ETA: ita, insent re: CVS.
DXMachina - Aug 06, 2003 2:27:40 am PDT #4532 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
D'oh! I looked right at that, and it didn't occur to me it was wrong. Thanks, Karl. That did the trick.