Wibble
THUNK!!!
I've tried to march in the Slayer Pride Parade ...
Joyce ,'Same Time, Same Place'
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 7:26:39 am PST #5811 of 10000
Not having has never been the thing I've regretted most in my life. Not trying is.
Tom Scola - Oct 27, 2003 7:30:42 am PST #5812 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
The more often we open and close mysql connections, the more likely we are to exercise the race condition that Rob discovered. After mysqld is restarted, the fewer connections we make, the longer it will take for the condition we are in now to reoccur.
Allyson - Oct 27, 2003 7:46:45 am PST #5813 of 10000
Wait, is this real-world child support, where the money goes to buy food for the kids, or MRA fantasyland child support where the women just buy Ferraris and cocaine? -Jessica
We're all sharing one connection? This explains the rash.
Cindy - Oct 27, 2003 7:51:53 am PST #5814 of 10000
Nobody
Can I blame someone here for eating all my Pringles?
Kristen - Oct 27, 2003 7:52:25 am PST #5815 of 10000
I've passed the information on to Steven. Since we have confirmation from the actual people at MySQL, I'm going to the mattresses on this one, if necessary.
There was a reason persistent connections wasn't recommended. I'll have to look back at my notes to remember why. Either way, I know we can't do it in our current location but it's certainly worth a shot in our new home, wherever that may be.
amych - Oct 27, 2003 7:52:52 am PST #5816 of 10000
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
Can I blame someone here for eating all my Pringles?
No. But I can apparently blame you for eating all of mine, since I don't seem to have any. Hmmph.
§ ita § - Oct 27, 2003 8:29:14 am PST #5817 of 10000
Well not canonically, no, but this is transformative fiction.
The more often we open and close mysql connections, the more likely we are to exercise the race condition that Rob discovered. After mysqld is restarted, the fewer connections we make, the longer it will take for the condition we are in now to reoccur.
I hope there's a timely patch (a girl can dream, can't she) that's implemented quickly. Who knows, though, if the bug would still be triggered with persistent connections anyway?
Tom, I'm finding that text a bit opaque. With persistent connections, then, the entire site is using just the one? Five? Fifty? When are they closed? From their description of them, it makes it sound like a line-for-line substitution should work for the code, and the labour is in the server tuning.
But I don't fully grasp it.
Tom Scola - Oct 27, 2003 8:43:15 am PST #5818 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Let's say that using non-persistent mysql connections, the site never had more than ten connections happening concurrently.
That means that properly tuned, the site would have ten persistent connections open all the time, and no more. The difference being that we wouldn't be opening and closing connections constantly, thus reducing the amount of work mysqld has to do.
§ ita § - Oct 27, 2003 8:46:52 am PST #5819 of 10000
Well not canonically, no, but this is transformative fiction.
Let's say that using non-persistent mysql connections, the site never had more than ten connections happening concurrently.
It's the "let's say" I'm asking about -- how do we control that -- code side, or in the server configuration? How do we get ten open? How do we make sure we never open more than ten?
Tom Scola - Oct 27, 2003 8:56:55 am PST #5820 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
It's the "let's say" I'm asking about -- how do we control that -- code side, or in the server configuration?
There are two main variables at work, how many people are accessing the board, and the server configuration.
How do we get ten open?
There would have to be an instance of ten people trying to view pages simultaneously. It's not very likely in practice, since the board now flakes out when two people try to view pages simultaneously, and it's still somewhat usable.
How do we make sure we never open more than ten?
You would have to tell apache to never fork more than ten httpd processes, or tell mysqld that max_user_connections is 10.