Site slow/Not Loading up

[Scott Greczkowski]

I just got back from a meeting and SQL was acting up so i had to bounce it twice for it to behave again.

All looks good now, and I am monitoring it on another PC I have setup.

 

[rdinkel]

Still slow this morning!

Bob

 

[gadgtfreek]

I just got back from a meeting and SQL was acting up so i had to bounce it twice for it to behave again.

All looks good now, and I am monitoring it on another PC I have setup.

You are not holding your mouth right.

 

[Scott Greczkowski]

Ok I have been monitoring it and just had to reboot the server completely. From what I can see something got stuck in memory and was causing an issue.

Lets hope this reboot fixes the issue.

Keep your fingers crossed. Sorry for the issue!

 

[stevenl]

Page generated in 3.85688 seconds with 17 queries
[page compression: 116.17 k/127.68 k (9.02%)]

BEfore that it was dead (i assume the reboot


Page generated in 5.04140 seconds with 17 queries
[page compression: 117.04 k/128.55 k (8.95%)]


Its sporadic, sometimes less then .5seconds sometimes more.Dam mysql is being hammerd

 

[Scott Greczkowski]

Yup and parts of the server are still loading from the reboot as well.

It should be back to normal soon (hopefully)

 

[Scott Greczkowski]

I am and have been monitoring the server since the reboot.

Some interesting facts in monitoring the server...

Our SQL Server processes and average of (as of this writing) 261.238 Queries a Second!

On top of that we have caching enabled and that is doing 110.63 cache requests/second!

This puppy is working hard.

 

[gadgtfreek]

Sounds like many of us need to get back to work and quit playing on the site

 

[Foxbat]

Sounds like many of us need to get back to work and quit playing on the site

I needed to quit playing on the site and get to work this morning, not "get back to"...

Scott, it seems you've had to spank the DB server quite a bit lately. What's changed in the last couple of weeks?

 

[Van]

Well after running CCleaner, adaware and advanced windows care I have been watching my times on page gens and queries and Im averaging 3 - 7 seconds for page gens and 17 - 67 queries. One thing Ive noticed though is that the page gen has a flaw in that if a page starts to generate and only gets as far as the bare shell of the page and hangs for any number of seconds then it records that initial portion that hits your computer is a complete generation and not when the last item generated for viewing.

 

[Van]

Case in point,

Page generated in 0.16854 seconds with 35 queries
[page compression: 116.26 k/138.97 k (16.34%)]

 

[Foxbat]

I lost www.satelliteguys.us for about three minutes about an hour ago. I lost 19% of the pings before it came back. I hope Scott (or LER) was responsible for the reboot...

 

[stevenl]

Ya its about 12:30 midnight here and site is running sluggish. Its hit or miss on pages loading.

 

[Foxbat]

I just had a page come up with everything except for the avatars. I refreshed and the page took 50 seconds or so to appear, this time with 80% of the avatar images.

 

[gdarwin]

I have been having problems ever since the change to make the URL a title was made.

 

[Scott Greczkowski]

Ok I have made some changes. (Part of it required a server reboot)

The cache is now rebuilding. But after that we should be ok.

This however will not correct the SQL issue we have been seeing and we are working on that as well.

 

[gdarwin]

I'm getting "page not found" from links in the reply emails.

 

[Scott Greczkowski]

This will fix itself in a little bit. (It could take about a day)

I am optimizing the vbseo stuff now for server perfomance. Not done yet, but things already seem to be snaping on the screen better now.

 

[gadgtfreek]

This will fix itself in a little bit. (It could take about a day)

I am optimizing the vbseo stuff now for server perfomance. Not done yet, but things already seem to be snaping on the screen better now.

I have not had any issues this morning, seems to be moving along.

 

[Scott Greczkowski]

Ok I think we are all set.

If you got a page not found a few moments ago, just go to the hopepage and try again it is fixed now.

The speed seems better now, so I am going to stop tinkering for a bit and monitor it.