Yeah Rob & Sergei!
If we can get the daemon restarted, and the problem goes away, do we still need to move?
Wash: Don't fall asleep now. Sleepiness is weakness of character. Ask anyone. You're acting captain. Know what happens you fall asleep now? Zoe: Jayne slits my throat, and takes over. Wash: That's right. Zoe: And we can't stop it.
'Shindig'
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.
Jon B. - Oct 27, 2003 6:01:51 am PST #5790 of 10000
A turkey in every toilet -- only in America!
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.
§ ita § - Oct 27, 2003 6:29:17 am PST #5797 of 10000
Well not canonically, no, but this is transformative fiction.
Tom, am I misinterpreting this:
they do not give you an ability to open 'user sessions' on the same SQL link
Wouldn't that limit us to 100 sessions at any one time?
Tom Scola - Oct 27, 2003 6:33:41 am PST #5798 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
they do not give you an ability to open 'user sessions' on the same SQL link
The users they are talking about above would be Phoenix users, not mysql users.
PHP has the ability to keep mysql sessions alive between page views, but it doesn't have the ability to make sure that a user would get the same mysql connection every time he views a page.
§ ita § - Oct 27, 2003 6:37:58 am PST #5799 of 10000
Well not canonically, no, but this is transformative fiction.
So how are they defining child processes on that page? What creates one?