Early-ish this morning, 2-3AM EDST, I logged in, but every time I clicked on "read new" I got logged out. No posting box, and an invitation to register or log in. Also, when I logged in, the home page came up un-logged. Just FYI. Seems fine today.
I happen to be very biteable, pal. I'm moist and delicious.
Xander ,'Bring On The Night'
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.
Beverly - Nov 30, 2003 6:20:11 am PST #6168 of 10000
Days shrink and grow cold, sunlight through leaves is my song. Winter is long.
Gudanov - Dec 01, 2003 6:28:37 am PST #6169 of 10000
Coding and Sleeping
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.
§ ita § - Dec 01, 2003 6:30:27 am PST #6170 of 10000
Well not canonically, no, but this is transformative fiction.
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.
Gudanov - Dec 02, 2003 6:04:03 am PST #6171 of 10000
Coding and Sleeping
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.
DCJensen - Dec 02, 2003 1:05:50 pm PST #6172 of 10000
All is well that ends in pizza.
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.
Kristen - Dec 03, 2003 7:42:29 am PST #6173 of 10000
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.
§ ita § - Dec 03, 2003 7:46:29 am PST #6174 of 10000
Well not canonically, no, but this is transformative fiction.
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.
Kristen - Dec 03, 2003 8:04:10 am PST #6175 of 10000
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!
Kristen - Dec 03, 2003 8:20:41 am PST #6176 of 10000
DXMachina - Dec 05, 2003 10:13:17 am PST #6177 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
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.