Those bugs don't cause any extra resource usage. They just cause the count of open connections to be incorrect.
I don't know of any bugs in MySQL that cause the board to consume extra resources.
Now, I can hold a note for a long time...actually I can hold a note forever. But eventually that's just noise. It's the change we're listening for. The note coming after, and the one after that. That's what makes it music.
Host ,'Why We Fight'
Bureaucracy 3: Oh, so now you want to be part of the SOLUTION?
A thread to discuss naming threads, board policy, new thread suggestions, and anything else that has to do with board administration and maintenance. Guaranteed to include lively debate and polls. Natter discouraged, but not deleted.
Current Stompy Feet: ita, Jon B, DXMachina, P.M. Marcontell, Liese S., amych
Rob - Jul 07, 2004 3:45:25 pm PDT #1527 of 10001
DavidS - Jul 07, 2004 3:55:09 pm PDT #1528 of 10001
"Look, son, if it's good enough for Shirley Bassey, it's good enough for you."
Those bugs don't cause any extra resource usage. They just cause the count of open connections to be incorrect.
Well, money is a resource, and all of our shared servers charged us for the miscounts.
Allyson - Jul 07, 2004 4:10:19 pm PDT #1529 of 10001
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
Rob, were you the one working on MARCIE?
§ ita § - Jul 07, 2004 4:18:20 pm PDT #1530 of 10001
Well not canonically, no, but this is transformative fiction.
I don't know of any bugs in MySQL that cause the board to consume extra resources.
Hmm. Odd. The previous host correlated the incidences of us eating every connection with the CPU usage spiking and bringing server performance to its knees.
You're saying there's something else we should be looking at in our code? Did you notice anything while you were working on the filter?
Kristen - Jul 07, 2004 5:00:36 pm PDT #1531 of 10001
As a webhost, I can say, without question, that a connection is considered a resource.
§ ita § - Jul 07, 2004 5:02:43 pm PDT #1532 of 10001
Well not canonically, no, but this is transformative fiction.
We were spiking the CPU, weren't we, Kristen? At the same time as eating all the connections, which is why we were capped and the code rapidly became useless and we left?
Kristen - Jul 07, 2004 5:13:17 pm PDT #1533 of 10001
Yes, you were. I need an analogy. Gimme a minute.
Kristen - Jul 07, 2004 5:28:01 pm PDT #1534 of 10001
I've gone to the analogy well and the well is dry.
Basically, yes, connecting to the database uses server resources. Querying the database also uses server resources but not nearly as much. Which is why connections and MySQL usage are so closely monitored and can get you TOSed out on your ass.
Rob - Jul 08, 2004 9:13:39 am PDT #1535 of 10001
Rob, were you the one working on MARCIE?
I was, but I'm not anymore. Where I left it was pretty much working, but with one bug that I couldn't figure out. ita has the details of what's happened since then.
Rob - Jul 08, 2004 9:17:12 am PDT #1536 of 10001
You're saying there's something else we should be looking at in our code? Did you notice anything while you were working on the filter?
I don't know how to optimize PHP/MySQL applications, but if there's someone who does, they should have an easy time modifying the code to be more efficient. It's well structured and well documented, which makes modification much easier.