Server Downtime

pajoube · Nov 21, 2003

Don't you ever sleep? /forums/images/graemlins/grin.gif /forums/images/graemlins/grin.gif
PJ

Ibrahim · Nov 21, 2003

Hello,

What have I been doing?

Well, I had to make a pretty drastic change to the database to even see if it was merely a problem with our indexes. It's not, unfortunately. But there are a few things I'm still looking into.

Right now, you'll still notice the searches are slower than they used to be, but I'm unsure why that is exactly. I'll continue looking into it.

Sorry for all the downtime today, it's been hectic.

Regards,
Ibrahim

MikePA · Nov 21, 2003

but I'm unsure why that is exactly. 
Any connection to the upgrade to mySQL done on 11/7?

Ibrahim · Nov 21, 2003

Did anyone notice any slowdown in the past 2 weeks?

-Ibrahiim

JerryG · Nov 21, 2003

Did anyone notice any slowdown in the past 2 weeks? 
Yes, very much so, but I just thought that it was on my end. I am usually run in 24 hr mode. It has been so bad that when I change windows, I play Spider Solitaire for a while. /forums/images/graemlins/crazy.gif

MossRoad · Nov 21, 2003

Did anyone notice any slowdown in the past 2 weeks? 

Not me.

Ibrahim · Nov 21, 2003

Was the rest of the site ok? Except for those search pages?

-Ibrahim

JerryG · Nov 21, 2003

/forums/images/graemlins/crazy.gifI don't know, that is almost all that I use.

jwstewar · Nov 21, 2003

I don't run in the 24 hour mode. I just use the main index. I had noticed it getting slower, but not terrible until yesterday and then really bad this morning.

Gatorboy · Nov 21, 2003

( Did anyone notice any slowdown in the past 2 weeks? )

I only noticed the problem after the server came back up yesterday morning.

Golfgar4 · Nov 21, 2003

I run through the main index also. I'd noticed a slow down, but I wrote it off to unrelated problems that we've been having with our computer.

I'm going to feel REALLY bad if you get things fixed and I'm still having the same problems (which I fully expect)! /forums/images/graemlins/crazy.gif

Bird · Nov 21, 2003

For me, occasionally (infrequently) it would hang when changing screens and I could either wait a long time OR click again and it would usually go ahead and change. Like some of the other guys, I just assumed it was my ISP, my own computer, or the particular route the message went the first time. But come to think of it, it wasn't ever happening on any other sites.

5030 · Nov 22, 2003

Gatorboy:

That picture of you is much more becomming than the "stoogie" one!!

rbarker · Nov 22, 2003

( Did anyone notice any slowdown in the past 2 weeks?

-Ibrahiim )

No, not until the other day. And it effects the entire site for me, as described by Bird. Sometimes it's quick, sometimes it's delayed for up to 30 seconds.

Ibrahim · Nov 22, 2003

Being unable to narrow this down isn't helping. I'm inclined to believe it was from the time we upgraded MySQL.

The reboot would not have changed anything. The way MySQL is interpreting our searches must have changed and that would cause the "occasional" slowdown in the entire site. Basically, whenever anyone uses the "past X hours" it holds it for 10-20 seconds. And then the other requests get backed up. I'm not sure why this is, exactly.

But I'll continue to look into things until I find out.

-Ibrahim

Gatorboy · Nov 25, 2003

( I'm inclined to believe it was from the time we upgraded MySQL. )

I did not notice any problems with speed until after the server came back up on the 20th. I would have definitely brought something up on the speed issue alot sooner if this had occured on the 7th.

For what it's worth...if you choose to display posts in the past 4 hours or earlier, the list comes back quickly -- anything 6 hours and greater causes the large search time.

I know some bugs are extremely hard to track down -- good luck in your search.

Gatorboy · Dec 7, 2003

For the first time in WEEKS, the speed at which obtaining "Posts in the last 12 hours" is quick. Did you guys finally figure out the problem? /forums/images/graemlins/cool.gif