I'm. . . loading. . .very. . .slowly. Just me? Or the board?
You were very nearly devoured by a giant demon snake. The words 'let that be a lesson' are a tad redundant at this juncture.
Giles ,'Selfless'
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.
Kat - Aug 04, 2003 7:10:02 pm PDT #4520 of 10000
"I keep to a strict diet of ill-advised enthusiasm and heartfelt regret." Leigh Bardugo
§ ita § - Aug 04, 2003 7:11:27 pm PDT #4521 of 10000
Well not canonically, no, but this is transformative fiction.
Incredibly slowly here too, though it's better now.
Kat - Aug 04, 2003 7:13:44 pm PDT #4522 of 10000
"I keep to a strict diet of ill-advised enthusiasm and heartfelt regret." Leigh Bardugo
Me too. I'm most often willing to blame it on dial up.
Kristen - Aug 04, 2003 7:56:03 pm PDT #4523 of 10000
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.
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.