Drusilla ,'Conversations with Dead People'
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
That's what I thought. But once the page is downloaded, the connection should be closed.
That'd be my guess too.
I thought that "200 concurrent mysql connections at the same time" would mean that 200 requests for pages are being made at the same time. Which I find hard to believe.
That would also be my guess, and it does sound a bit excessive. Especially since I thought we were a little quieter than usual today.
And I suspect we are closing connections once the page is loaded. But if we use a bunch of connections to load a page, and a bunch of people post or read at the same time, I can see how we could get up there.
We really ought to (and can easily ) limit it to one connection per page load.
I was wondering the same thing as Tom, but he actually knows the stuff and explained it better.
Isn't there a know bug in certain version of PHP and MySQl where resources are not released? I wonder if there is something similar for MySql connections. Let me go the the PHP boards and check it out quickly.
It's possible that there is a bug in the code where MySQL connections aren't properly closed in all circumstances, causing them to accumulate.
Tom is so smart.
I suspect Tom is right. I can't find any well know bug where connections don't close. So we need to look at the actual code.
The simplest thing to do (and oh! look! it's a weekend!) is to run through the code and put explicit closes after every recordset is done with.
That's phase 1 of the process.
The second phase, is to actually run through the code and squeeze down the queries. This has been, she says sheepishly, on my plate for a while. Anyone want it?
ita, I'd be the first to volunteer had I any idea what's going on. I'm even working all nights all weekend and will be bored.
ita, I'd be more than happy to help out in any way I can -- I haven't a clue if my PHP/MySQL skills are up to where I'd understand the Phoenix code if I saw it, but I can certainly try.
Perhaps fangeek can turn on mysqld logging (for a short period of time) so that we can get a handle on what's happening?