Well, hallelujah...
Bravo, Rob and Sergei!!!
Hey, man, where are my pants? I have my hippo dignity!
Oz ,'Bring On The Night'
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.
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.
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?
Tom Scola - Oct 27, 2003 6:45:51 am PST #5800 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
So how are they defining child processes on that page? What creates one?
They are talking about Apache httpd processes. Normally, on a web server there are multiple instances of Apache running, and that number can grow or shrink depending on server load, but never fall below some predefined threshold.
These persistent msyql connections can't be shared between httpd processes.
This is one of the reasons why we would have to be extremely careful if we decide to implement this. If there are twenty httpds running, and each has 2-3 mysql connections, we can easily exceed our allotment.
Getting this working right would involve fine-tuning Apache, PHP and Mysql server parameters, and would be difficult to do if we didn't have a dedicated connection.
§ ita § - Oct 27, 2003 6:49:56 am PST #5801 of 10000
Well not canonically, no, but this is transformative fiction.
Getting this working right would involve fine-tuning Apache, PHP and Mysql server parameters, and would be difficult to do if we didn't have a dedicated connection.
No doubt, no doubt.
But, I'm wondering -- is it that broken? Do we really have a problem with the connection/page model? MySQL bug aside, of course. It sounds like a fair amount of work.
Tom Scola - Oct 27, 2003 6:52:24 am PST #5802 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
is it that broken?
I really don't know. Steve seems to be complaining about something, though.
§ ita § - Oct 27, 2003 6:56:21 am PST #5803 of 10000
Well not canonically, no, but this is transformative fiction.
Steve seems to be complaining about something, though.
As far as I can tell, Steve is complaining about the effect of the bug Rob saw. We're all hitting up one connection right now, apparently due to that.
Sure, we could all persistently share the one connection, but I suspect that no matter how well tuned, that would make for crap performance.
Once our count is reset, however, do you see a perceivable return on investment to it?
Tom Scola - Oct 27, 2003 7:02:55 am PST #5804 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Once our count is reset, however, do you see a perceivable return on investment to it?
If the server is restared, and Steve is still complaining about server load, then this is one avenue we should explore.
We are doing multiple connections per page view now, aren't we? We should be using at most one, and that should be easy to fix.