I haven't been following this thread. But the chicken problem is too many connections to MySQL right? Maybe, the board could be modified to cache requests into a file and have a fixed record index to the posts. Then when a read request is made, the read comes from the cache rather than the database and we could drastically reduce the number of connections. (Editing would be an issue, so would deleting but that's easier, taglines would work a little different, threadsucks would be cake.)
Some other things might be able to be moved to file based as well such as member profiles and such, to reduce the database traffic.
Just some ideas, I can elaborate if there is any merit.
Gud, the problem is MySQL incorrectly totalling the connections. I'm hesitant to start rearchitecting the site because of their bugs (unless it would be to change back ends).
However, on a server we can bounce, the issue is easily, if temporarily cleared up.
Okay. I was just trying thinking of a way to maybe help without totally rewriting stuff, but if there is already a solution in the pipe then that's cool.
From reading up, it seems it is in the pipe, but yet unsmoked.
Or at least no one covered up the hole with their finger.
Ha. Totally not the right thread for this but...
ita, way back when we set up the Buffistas account, did I tell you in an email that, until the DNS resolved, you could access your account at [link] somethingIcan'tremembernow? I know I told someone.
It's making me nuts.
When I get home, I'll check through my support e-mails and see. Because I am your twin in "huh? really? And I was there?"
But I may have documentation.
hee Okay, Monique said the same thing to me. One way or the other, I'ma get this info since randomly sticking words after the IP addy ain't doing jack.
Thanks!
Never mind! Monique found it. It was all about the tilde:
[link]
So, it just occurred to me that I haven't seen the error message in a few days. Did MySQL get restarted for us? Just curious, because I don't recall seeing a mention of it.
I was wondering the same thing.