Rob, you rock.
My god...he's gonna do the whole speech.
Buffy ,'Chosen'
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.
Cindy - Oct 27, 2003 5:55:14 am PST #5787 of 10000
Nobody
Jesse - Oct 27, 2003 5:58:51 am PST #5788 of 10000
Sometimes I trip on how happy we could be.
Go, Rob!
God, I love Buffistas.
Nilly - Oct 27, 2003 6:00:45 am PST #5789 of 10000
Swouncing
Rob, wow. Go you!
With the continuous digging and the not despairing and the going-to-the-sources and, most of all, finding the origin of the problem!
Jon B. - Oct 27, 2003 6:01:51 am PST #5790 of 10000
A turkey in every toilet -- only in America!
Yeah Rob & Sergei!
If we can get the daemon restarted, and the problem goes away, do we still need to move?
Tom Scola - Oct 27, 2003 6:06:04 am PST #5791 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Nice call, Rob.
If we can get the daemon restarted, and the problem goes away, do we still need to move?
If the daemon is restarted the error messages will go away, probably for a couple of months. If the current version of mysql is replaced with one that has these new patches applied, the error messages will go away permanently.
Whether or not we are using mysql too heavily is a separate issue.
§ ita § - Oct 27, 2003 6:11:04 am PST #5792 of 10000
Well not canonically, no, but this is transformative fiction.
It looks like we've been sharing one connection for forever. I'm sure the traffic has lightened and we may have lost posters due to lack of patience, but I can't see, under non-race conditions, how we'd honestly use more than 100, seeing as we're getting clumsily by.
I hate writing code that hits a bug in another system -- where the hell do you start to work around that?
Tom Scola - Oct 27, 2003 6:15:27 am PST #5793 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
At some point, the code should be rewritten so that mysql connections are preallocated, and kept open between page views.
This will signifigantly improve performance, since opening and closing msyql connections is a relatively expensive operation, especially on the server side.
§ ita § - Oct 27, 2003 6:18:04 am PST #5794 of 10000
Well not canonically, no, but this is transformative fiction.
If they are open between page views, how then can we have 101 simultaneous users?
Or do mean sharing connections between sessions? Is that possible?
I understand that the opening and closing is expensive (although were were told to explicitly close after every open as part of trying to minimise this error).
My gut reaction is that they should be open for a page, and no longer.
Astarte - Oct 27, 2003 6:27:20 am PST #5795 of 10000
Not having has never been the thing I've regretted most in my life. Not trying is.
Well, hallelujah...
Bravo, Rob and Sergei!!!
Tom Scola - Oct 27, 2003 6:27:58 am PST #5796 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Or do mean sharing connections between sessions? Is that possible?
Yes, and yes, using the mysql_pconnect function.
Persistent database connections.
It comes with this warning, though:
Using persistent connections can require a bit of tuning of your Apache and MySQL configurations to ensure that you do not exceed the number of connections allowed by MySQL.