WC Personal Pages Continued

Good news and Bad news

Monday, May 22, 2006 by T-Man | Discussion: WinCustomize News

Well, it appears that our database servers performed much better while the personal pages were off.  Not only was the database happier but we saw a significant increase in traffic to WinCustomize because there were less problems.  So its good that we have seen our traffic increase.   But its bad because it means there is a problem with the personal pages that is causing significant database congestion.

So here is the plan.  Later today (around 3:00) we plan on turning the personal pages back on for a short time (about an hour).  During this time we are going to be profiling database activity so we can try to find the problematic areas.  Then we will turn the Personal Pages back off until we can get the problem(s) corrected.  But since we do not know the exact cause of the problem we do not know for sure how long they will be down.  We will keep you informed.

First Previous Page 1 of 2 Next Last
kenwas
Reply #1 Monday, May 22, 2006 12:37 PM
Lets hope for the best! 3 in what time zone?
IamDean
Reply #2 Monday, May 22, 2006 1:00 PM
3 EST
catluvr2
Reply #3 Monday, May 22, 2006 1:30 PM
Hmmm... No WONDER I couldn't get to my stuff!
Fuzzy Logic
Reply #4 Monday, May 22, 2006 1:42 PM
What time is that in real money?
Jafo
Reply #5 Monday, May 22, 2006 4:00 PM
....about six inches...
Fuzzy Logic
Reply #6 Monday, May 22, 2006 5:39 PM

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

That's what I got trying to read this thread

Fuzzy Logic
Reply #7 Monday, May 22, 2006 5:40 PM
So what's the good news? Leeds Utd didn't get promotion, hehehe
Corky_O
Reply #8 Monday, May 22, 2006 6:19 PM

Glad I did not post my tutorial images on my personal pages!

Taking a break for a good bit anyway, so will check back later this summer...

Have a good summer all!

MarkSnyder61
Reply #9 Monday, May 22, 2006 6:20 PM
If using Active Directory then there needs to be a cleanup of "Garbage" data. Usually this is done by default every 12 hours of objects that are tombstoned, then defragged. You can set the tombstone process interval by editing the ADSI. This may be something that will help you out?
seldomseen
Reply #10 Monday, May 22, 2006 11:51 PM
Hmm...let's see if I've got this right:
site o.k. but needs to be better


so must open it up and fix it


before...



So we've just gotta hang
'til techs are done and
it's better than ever...?
Sventekoz
Reply #11 Tuesday, May 23, 2006 2:00 AM
This may be displaying my ignorance in these matters, but why not put the personal pages on a different server?
Dark-Star
Reply #12 Tuesday, May 23, 2006 7:19 AM

This may be displaying my ignorance in these matters, but why not put the personal pages on a different server?


This wouldn't solve our problem because each website is tied directly to the same main database. The database is the key point where all websites rely upon it to function well. When the database is unhappy, the websites are unhappy. If a website, such as the personal pages, causes the database to perform poorly, then this causes a cascading effect for all of the websites. As mentioned by Brad (frogboy), a new super database server is on the way, and this will help a little, but ultimately, fixing the cause of the problem is the best solution. This is why the personal pages must be addressed, as there is only so much hardware you can upgrade until the problem pops up again.

T-Man
Reply #13 Tuesday, May 23, 2006 7:21 AM

We have identified some problematic areas in our code and we are working on them to refine them.  I suspect that we will do another test later today to test the changes we make.

 

This may be displaying my ignorance in these matters, but why not put the personal pages on a different server?

THe problem is not with the server that the website is on, the problem is with the way the website interacts with the central database.

T-Man
Reply #14 Tuesday, May 23, 2006 1:40 PM
In just a couple minutes we will be turning the personal pages on again for a about an hour while we do some more tests.
kenwas
Reply #15 Tuesday, May 23, 2006 2:02 PM
Sure seemed much more responsive and without slowing down other section loads. Of course, I have no idea what traffic load you have at this time of day.
Fuzzy Logic
Reply #16 Tuesday, May 23, 2006 2:04 PM
Current users 62, an hour ago it was 2300...
kenwas
Reply #17 Tuesday, May 23, 2006 2:11 PM
Just went back in and the page load to my skins took a long time. Same with switching to the stats page. Then tried comments on this thread and that too was very slow. Oh well....
seldomseen
Reply #18 Tuesday, May 23, 2006 3:52 PM
Good at the moment (note time...)
PoSmedley
Reply #19 Tuesday, May 23, 2006 6:46 PM
When the database is unhappy, the websites are unhappy.

Sounds like my house. "When Momma's unhappy (the wife) everybody's unhappy"

Let me know how you fix it so I can try it here.

ZubaZ
Reply #20 Tuesday, May 23, 2006 7:11 PM
Let me know how you fix it so I can try it here


I don't know about your house Po' . . but if I brought a faster, newer "server" I don't think it would even help that she were 12 times the size of my current "server", I believe the site would crash hard. Real hard.

And as for optimizing the existing "server" . . not something I'm EVER going to try again.

Please login to comment and/or vote for this skin.

Welcome Guest! Please take the time to register with us.
There are many great features available to you once you register, including:

  • Richer content, access to many features that are disabled for guests like commenting on the forums and downloading skins.
  • Access to a great community, with a massive database of many, many areas of interest.
  • Access to contests & subscription offers like exclusive emails.
  • It's simple, and FREE!



web-wc01