Is anyone experiencing site performance issues as of right now?

[Sean]

test post..

 

[Sean]

test post again..

 

[xfadmin]

test post

 

[Sean]

testing..

 

[Sean]

test.

 

[markbarendt]

Can see this but search isn't displaying posts, it does show the post count, all the ads, header footer...

 

[markbarendt]

It took what seemed like a minute to add that last post

 

[Sean]

Yeah, some very frustrating issues right now. Basically been sitting here for days and not making much progress. I would move us to a dedicated server at a different host but with the weekend none of them are provisioning new servers right now. Will have to try to plod through till monday. I'll see if I can make any progress for some stability until then. A real shame that things ran great for 5 months or so and now this.

 

[markbarendt]

It's a good weekend to go outside and take a few pictures.

Thanks for all your efforts.

 

[Eric Rose]

Sean who are you with right now, so I know who to avoid for my clients. PM me if that works best for you. Sorry you are having so many headaches. I feel for you.

 

[Rick A]

It has taken ALL morning to even get on site much less access any threads. I'm finally on but running s-l-o-w-w-w.

 

[Zewrak]

Its most likely a faulty HOP somewhere. I have had no problem at all. And since it only affect some people, it's either clientside or somwhere along the path there.

I suggest trying to get some traceroutes from people that have problem, identify the faulty HOP and report it to your host.

My bet is a faulty switch somewhere just outside the host.

 

[Sean]

Things seem improved after moving a few mega-threads from view. What I noticed was the site running fine, then a big slow down. After gaining access to the mysql database process log, every time the site went slow there would be a thread id in the queued processes. Each id corresponded to an extremely large thread. Threads like "your latest 35mm camera purchase" or the "deleted" thread. There were several Kodak ones as well. I'll get these threads back into view soon but locked down and we can create a "part2" for them. For now seems safest to stash them away. It's still hard to tell 100% if that was the issue.

 

[David A. Goldfarb]

APUG--brought down by the "deleted" and joke threads. Well, those would be no great loss.

 

[brucemuir]

I just successfully posted 2 separate FS posts complete with image uploads.
smooth, no issues to report

 

[Sean]

APUG--brought down by the "deleted" and joke threads. Well, those would be no great loss.

Could be. The server still seems twitchy but since removing those big threads it's been somewhat usable. If you stumble across any giant threads might be good idea to lock them for now or move them to the "compost heap" so we can keep track of them. When the dust settles we'll try moving them back in, locking them and making a "part2" for them.

 

[Sirius Glass]

Things seem improved after moving a few mega-threads from view. What I noticed was the site running fine, then a big slow down. After gaining access to the mysql database process log, every time the site went slow there would be a thread id in the queued processes. Each id corresponded to an extremely large thread. Threads like "your latest 35mm camera purchase" or the "deleted" thread. There were several Kodak ones as well. I'll get these threads back into view soon but locked down and we can create a "part2" for them. For now seems safest to stash them away. It's still hard to tell 100% if that was the issue.

Oh no! Say it ain't so! Not the DELETED thread!

 

[Sean]

one more find. this sql query is causing the remaining lag:

Copying to tmp table | SELECT DISTINCT t.threadid,t.title
FROM post AS p
LEFT JOIN thread AS t ON (p.threadid=t.threa |{/quote]

Trying to find out what component in our software is generating this. I think once we can get rid of that things will be a lot better.

 

[Sean]

The above may have been generated by the sidebar. I have disabled the sidebar for now to see how it goes.

 

[papagene]

Site performance seems spotty this morning, sometimes taking a minute or so to load a page.

 

[Sean]

Site performance seems spotty this morning, sometimes taking a minute or so to load a page.

How is it as of right now?

 

[flatulent1]

Seems okay here.

 

[Sean]

Hopefully things will run ok for now. It seems the main culprits have finally been identified. Gotta get some sleep, then the next couple days see if we can get things back to normal.

 

[zsas]

Been here for about ten mins, all is nice n fast

 

[markbarendt]

I can see things again, yea.