I was wondering the same thing as Tom, but he actually knows the stuff and explained it better.
Cordelia: I get it now. You're all spies. Probably all Russian. And you've brainwashed me, and want me to believe we're friends so I'll spill the beans about some nano-technology thingy that you want. Gunn: So I look Russian to you? Cordelia: Black Russian. Angel: That's a drink.
'Hell Bound'
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.
amych - Aug 01, 2003 10:26:53 am PDT #4450 of 10000
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
Typo Boy - Aug 01, 2003 10:27:22 am PDT #4451 of 10000
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.
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.
Jessica - Aug 01, 2003 10:27:48 am PDT #4452 of 10000
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
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.
Typo Boy - Aug 01, 2003 10:35:10 am PDT #4453 of 10000
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.
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.
§ ita § - Aug 01, 2003 10:42:50 am PDT #4454 of 10000
Well not canonically, no, but this is transformative fiction.
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?
Elena - Aug 01, 2003 10:44:05 am PDT #4455 of 10000
Thanks for all the fish.
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.
Jessica - Aug 01, 2003 10:46:21 am PDT #4456 of 10000
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
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.
Tom Scola - Aug 01, 2003 10:47:33 am PDT #4457 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Perhaps fangeek can turn on mysqld logging (for a short period of time) so that we can get a handle on what's happening?
DXMachina - Aug 01, 2003 10:48:14 am PDT #4458 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
IH informs me that, while they did not anticipate any problems with the site, they simply weren't expecting "over 200 concurrent mysql connections at the same time". They had no way of predicting that. They informed us that we are the reason the server has been so slow of late. They also suggested that we modify our code, as they believe the script we're using is the problem.
IH mentions that they think if we "optimize the database queries" that will help a lot. It isn't our bandwidth usage that is the issue, it's our resource usage.
I gotta say that IH actually giving us a clue as to what's happening is much better than the way HR just kept telling us "You should have fixed your code."
Liese S. - Aug 01, 2003 10:59:41 am PDT #4459 of 10000
"Faded like the lilac, he thought."
Hey, I'm where Jess is. I've been out of the programming loop for a while so I dunno if I'd be any help, but sql used to be my baby, so I'd be happy to at least look it over. I'm limited as to my online time, but if I could look at the code offline I'd have a fair whack of time this weekend to do it up. Let me know how to do whatever I gotta do. Like I said, I dunno if I'm up to scratch but I'd be glad to be extra eyes and hands.