I actually got a "Page Suspended" from fangeek the first time I tried today. I just finished registering at Peoplesforum.
Spike: Heard what happened up top, offing your dad and all. Don't know if you know this, but, uh…I killed my mum. Actually, I'd already killed her, and then she tried to shag me, so I had to-- Wesley: Thank you. I'm…very comforted.
'Lineage'
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.
Noumenon - Aug 01, 2003 9:10:41 am PDT #4434 of 10000
No other candidate is asking the hard questions, like "Did geophysicists assassinate Jim Henson?" or "Why is there hydrogen in America's water supply?" --defective yeti
DXMachina - Aug 01, 2003 9:11:26 am PDT #4435 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
Yeah, do we know what was the up?
Laura - Aug 01, 2003 9:11:51 am PDT #4436 of 10000
Our wings are not tired.
I have had no trouble getting in, but at times it has been very slow.
Jessica - Aug 01, 2003 9:12:05 am PDT #4437 of 10000
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Since that blip where we were offline completely, it's been running quite speedily for me. Faster than it's been all day.
Monique - Aug 01, 2003 9:36:52 am PDT #4438 of 10000
Yeah, do we know what was the up?
We're looking into what the deal was with the suspended page right now. Kristen or I will provide a report once we've learned more. I apologize for the difficulties you guys may have experienced today, and I thank you for not hunting one or both of us down. ... Unless you've already sent out the lynching parties, in which case, I should probably be hunting for a hidey-space?
Kristen - Aug 01, 2003 10:07:23 am PDT #4439 of 10000
As I'm sure you noticed, we had a bit of an outage this morning. Some of you may have even seen a suspended page. The short version is that y'all talk too much. The long version is...well, a little longer.
This morning, Monique and I received an email from IH in which they informed us that this site was starting to outgrow a shared hosting environment and that it was bogging down the server. There's a possibility that on the newer, faster server, it won't be such an issue but we were urged to consider dedicated hosting.
As I'm reading the email, the site goes down.
I respond, a little pissed and very perplexed, given the number of conversations we had with them prior to moving in. I ask for some clarification.
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.
My response to this is that, while I will discuss it with you [Buffistas], I'm a little confused as to why I'm just hearing about this now. Both Monique and I have had conversations with them in the past few weeks about the slowness and other issues and, at no time, did they tell us it was due to our usage. Yadda yadda yadda. More stuff that really is irrelevant to the issue at hand.
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.
So here's the issue. As I have already recommended to ita, we should try and optimize the queries, if possible. Finding other ways to use fewer resources would also be good. The new server may also buy us some time.
But the bottom line is that if we are truly using "200 concurrent mysql connections at the same time" on a Friday morning in August, I don't think there's a shared hosting environment in all the world that's going to be able to host us for very long come the fall. I really am starting to believe that this board needs a dedicated server to exist peacefully on the net.
Jon B. - Aug 01, 2003 10:14:18 am PDT #4440 of 10000
A turkey in every toilet -- only in America!
"200 concurrent mysql connections at the same time"
I find it hard to believe that there are 200 users on at the same time, but maybe I underestimate the number of lurkers. Also, I don't know anything about what constitutes a mysql connection. Is the code opening multiple connections for one user before closing any of them? Can anyone explain the concept in English?
Jessica - Aug 01, 2003 10:19:01 am PDT #4441 of 10000
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
I would guess that every pageview constitutes at least one MySQL connection, but ita would know for sure.
Typo Boy - Aug 01, 2003 10:20:21 am PDT #4442 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.
We have around 1000 registered users total. twenty percent of our users on line simulataneiously would be a lot.
And yeah we should be able not only limit it to one connection per user logged on, but actually open (say) fifty connection permanently and then share them among users queuing requests.
Kristen - Aug 01, 2003 10:20:25 am PDT #4443 of 10000
No, it's not users. I had a definition around somewhere, I think, from before we moved in. I'm not sure if it was at WX or PF.
Is the code opening multiple connections for one user before closing any of them?
It sounds like it is, to me. Then again, I've never looked at the code and probably wouldn't be able to tell even if I had.