Site speed

[Scott & Lai 12]

Site is crawling again.....

[Welshcookie 17]

[Captain Ewok 1,891]

It is? still?

[Scott & Lai 12]

Now it is moving fine.....earlier pages were taking forever to load.

[Captain Ewok 1,891]

Do the slow periods last a few minutes or 10 to 20 minutes or longer?

[Yodrak 7]

Captain Ewok,

I think less than 10 minutes. And the periods of slowness are occuring less frequently than they were last week.

Yodrak

Do the slow periods last a few minutes or 10 to 20 minutes or longer?

[Captain Ewok 1,891]

. That is good news. I have something I can do that should get us more speed but I am trying to get a feel for how slow things appear to people now and if it is worth it. Feedback on this issue is very welcome!

[Fuzzness 2]

it's been seriously slow today

[Captain Ewok 1,891]

I am still tracking down what is causing the intermittent problems .... on a good note, I think I may have just found the problem . Te fix may result however in the "viewed" stats for each topic only being updated every once in a while and not in real time.

[mary&tom 0]

it's super fast at the moment... earlier today it sometimes wouldn't respond at all if i clicked on something

[Captain Ewok 1,891]

Seems like the "topic views" being updated in real time was killing the site. They are now set to update every 10 minutes .

[KarenCee 3]

It's 9:24 right now and it's crawling like molasses in January.

[Captain Ewok 1,891]

yeah I found something that hung up the site a bit. I tried it on purpose a few times and it worked everytime. So the last few were all me! Problem is it is something members do sometimes each day (a forums feature)! I have changed a few things and I hope it helps!

PS thanks for the update on the speed. Everyone feel free to add in info. The mroe I have the better I can figure this out!

[PlatyPius 5]

It's always slow for me. I'm on dial-up. LOL

I've had delays recently of up to 2 minutes after hitting the reply button before it actually sends the reply and loads the updated page. (Normal for me is about 20 seconds). I've also received countless "Timed Out" messages the past 2 or 3 days. All other sites load fine, so I determined that it wasn't my connection.

I assume caching is enabled on the site?

Is logging turned off?

Does Invision let you change the "recent visitors" thing? I changed mine to every 30 minutes to speed things up (UBB)

I would consider the following (just my suggestions....not telling you how to run your board):

1) Further limiting image uploads. Some of the siggies here have images that are huge.

2) Removing the "reward" for posting space-filling #######. "Post-Booster" threads especially, but also the "I have more posts than you!" feature itself.

3) Cleaning out the member list (if you don't already). I allow an account to be dormant for 3 months, then I delete it.

That's all I can think of right now. Well, except for the fact that Invision just doesn't play well with the newer version of MySQL even on it's best day. Nothing you can do about that though, really.

[Captain Ewok 1,891]

Yeah I noticed that going to php 4.1.2 from 4.1.x slowed the site down a little.

I will post the my.cnf and httpd.conf settings if you are into it. I changed things to timeout faster recently (you may be getting those errors for that reason). I wanted to kill run away mysql processes so I set the timeout to 30 seconds. That may impact you. I can increase that if so .

The big slow down is that we periodically are getting mysql queries "stuck" because another myysql thread is running slow. THat ends up creating a backlog of sometimes hundreds of mysql queries because the table is locked.