Re: URGENT! Locked DB's

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38417
interpreted = N
texte = Thanks for the comments.I upgraded to WC 3.0.7 immediately and saw a slight performance increase. Not enough though to help matters.Following that I've upgraded to WC 4.0.1 and saw an immediate performance increase. The Finder is still sluggish on the G4 400mhz machine but at least it is workable.Here's the bad part, after about 2,000 hits the server starts to puke again. Quitting Web* and restarting the application clears things up again and then the server runs zippy as ever. So, it looks like after a few thousand hits its bogging down.The only apps running on the machine are Web*, WC, Rumpus and Emailer. Any other comments are appreciated. I am a little concerned about having to throw more hardware at this situation. Thanks. -- Sincerely, Patrick O'Brien Systems Adminstrator and Web Manager Sandusky Register http://www.sanduskyregister.com Top Interactive http://www.topinteractive.com 419-625-5500 ext. 333On Thursday, September 6, 2001 10:08 AM, dale@gmr.dresdner.net wrote: >Come on folks, 18,000 banners per day is nothing for WebCat 3.x >on Mac OS. > >I am doing 5 times that amount with no problems, that is no problems after >upgrading to v3.0.7. and previously I was doing 50,000 pages (all with >banners) on a processor upgraded PM 7100. It was around that time that I >encountered these threads as well. Trying the newer beta's that Grant sent >me, then sticking with the final version of 3.0.7 solved all of >them. > >3.0.4 does have problems with threads, this was improved over the next >couple of versions. an Upgrade to 4.x can be very expensive and possibly not >cost effective. > >I have to suggest once again to simply upgrade to the 3.0.7 plugin. Takes a >couple of minutes to download, swap out the plugins and restart WebStar. >After you do that, *if* you continue to have problems then I would suggest >possibly considering upgrading to WC4.x > >What is the speed/processor of the computer? If you are using an older and >slower machine, then that could also be contributing to the problem. And >that will not necessarily be solved by upgrading to 4.x. > >Are you running anything else on the machine that could be taking processor >time? e.g. FileMaker Pro > >> From: Paul Uttermohlen >> Reply-To: (WebCatalog Talk) >> Date: Thu, 6 Sep 2001 09:32:06 >> To: (WebCatalog Talk) >> Subject: Re: URGENT! Locked DB's >> >> Patrick, >> >> You are hitting the limitations of Webcat 3.x. >> >> Upgrading to Webcat 4.x will solve your thread problems which handles >> more threads better - that section of the code was rewritten, fairly >> well too. >> >> We upgraded last year to solve the problem you are encountering now. >> >> Paul >> >>> Our G4 is running OS 9.0.4, Web* 4.2 and WebCat Plugin v3.0.4. 700mb. of RAM. >>> >>> We are getting several hundred, close to 1,000 thread.debug files >>> generated daily. The server bogs down to incredibly slow speed and >>> even the Finder runs extrememly slow. The following is a snippet of >>> what the thread.debugs tell us: >>> >>> 09/06/01 05:49:48 deadlocked >>> :BannerSleuth:Banner_Dbs:logs.db, 36856393 times waiting for read >>> 09/06/01 05:50:10 deadlocked >>> :BannerSleuth:Banner_Dbs:logs.db, 11391157 times waiting for write >>> 09/06/01 05:50:30 deadlocked >>> :BannerSleuth:Banner_Dbs:logs.db, 11506693 times waiting for write >>> 09/06/01 05:50:52 deadlocked >>> :BannerSleuth:Banner_Dbs:logs.db, 11527617 times waiting for write >>> >>> Does anybody have any idea on how to combat this problem without >>> having to throw away Bannersleuth? When I take the BannerSleuth >>> directory out of the Web* root so that BannerSleuth won't be >>> accessed, the server runs just fine, of course none of our banner >>> ads appear on our sites which doesn't make our advertisers happy >>> either. We're averaging about 18,000 page views per day which >>> translates into about 18,000 banner views per day. When we used >>> BannerSleuth initially on one site we only had about 2,000 >>> page/banner views per day and had no problems. I have no idea if >>> WebCat freaks after a certain amount of traffic. >>> >>> Any help is greatly appreciated!!!!!!!!!!!!!!!!!!!! >>> -- >>> Sincerely, >>> >>> Patrick O'Brien Systems Adminstrator and Web Manager >>> Sandusky Register http://www.sanduskyregister.com >>> Top Interactive http://www.topinteractive.com >>> 419-625-5500 ext. 333 > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://search.smithmicro.com/ >------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: URGENT! Locked DB's (Patrick O'Brien 2001)
  2. Re: URGENT! Locked DB's (Dale LaFountain 2001)
  3. Re: URGENT! Locked DB's (Patrick O'Brien 2001)
  4. Re: URGENT! Locked DB's (Scott Anderson 2001)
  5. Re: URGENT! Locked DB's (Christer Olsson 2001)
  6. Re: URGENT! Locked DB's (Paolo Coppo 2001)
  7. Re: URGENT! Locked DB's (Patrick O'Brien 2001)
  8. Re: URGENT! Locked DB's (dale 2001)
  9. Re: URGENT! Locked DB's (Paul Uttermohlen 2001)
  10. Re: URGENT! Locked DB's (Bob Minor 2001)
  11. Re: URGENT! Locked DB's (dale 2001)
  12. URGENT! Locked DB's (Patrick O'Brien 2001)
Thanks for the comments.I upgraded to WC 3.0.7 immediately and saw a slight performance increase. Not enough though to help matters.Following that I've upgraded to WC 4.0.1 and saw an immediate performance increase. The Finder is still sluggish on the G4 400mhz machine but at least it is workable.Here's the bad part, after about 2,000 hits the server starts to puke again. Quitting Web* and restarting the application clears things up again and then the server runs zippy as ever. So, it looks like after a few thousand hits its bogging down.The only apps running on the machine are Web*, WC, Rumpus and Emailer. Any other comments are appreciated. I am a little concerned about having to throw more hardware at this situation. Thanks. -- Sincerely, Patrick O'Brien Systems Adminstrator and Web Manager Sandusky Register http://www.sanduskyregister.com Top Interactive http://www.topinteractive.com 419-625-5500 ext. 333On Thursday, September 6, 2001 10:08 AM, dale@gmr.dresdner.net wrote: >Come on folks, 18,000 banners per day is nothing for WebCat 3.x >on Mac OS. > >I am doing 5 times that amount with no problems, that is no problems after >upgrading to v3.0.7. and previously I was doing 50,000 pages (all with >banners) on a processor upgraded PM 7100. It was around that time that I >encountered these threads as well. Trying the newer beta's that Grant sent >me, then sticking with the final version of 3.0.7 solved all of >them. > >3.0.4 does have problems with threads, this was improved over the next >couple of versions. an Upgrade to 4.x can be very expensive and possibly not >cost effective. > >I have to suggest once again to simply upgrade to the 3.0.7 plugin. Takes a >couple of minutes to download, swap out the plugins and restart WebStar. >After you do that, *if* you continue to have problems then I would suggest >possibly considering upgrading to WC4.x > >What is the speed/processor of the computer? If you are using an older and >slower machine, then that could also be contributing to the problem. And >that will not necessarily be solved by upgrading to 4.x. > >Are you running anything else on the machine that could be taking processor >time? e.g. FileMaker Pro > >> From: Paul Uttermohlen >> Reply-To: (WebCatalog Talk) >> Date: Thu, 6 Sep 2001 09:32:06 >> To: (WebCatalog Talk) >> Subject: Re: URGENT! Locked DB's >> >> Patrick, >> >> You are hitting the limitations of Webcat 3.x. >> >> Upgrading to Webcat 4.x will solve your thread problems which handles >> more threads better - that section of the code was rewritten, fairly >> well too. >> >> We upgraded last year to solve the problem you are encountering now. >> >> Paul >> >>> Our G4 is running OS 9.0.4, Web* 4.2 and WebCat Plugin v3.0.4. 700mb. of RAM. >>> >>> We are getting several hundred, close to 1,000 thread.debug files >>> generated daily. The server bogs down to incredibly slow speed and >>> even the Finder runs extrememly slow. The following is a snippet of >>> what the thread.debugs tell us: >>> >>> 09/06/01 05:49:48 deadlocked >>> :BannerSleuth:Banner_Dbs:logs.db, 36856393 times waiting for read >>> 09/06/01 05:50:10 deadlocked >>> :BannerSleuth:Banner_Dbs:logs.db, 11391157 times waiting for write >>> 09/06/01 05:50:30 deadlocked >>> :BannerSleuth:Banner_Dbs:logs.db, 11506693 times waiting for write >>> 09/06/01 05:50:52 deadlocked >>> :BannerSleuth:Banner_Dbs:logs.db, 11527617 times waiting for write >>> >>> Does anybody have any idea on how to combat this problem without >>> having to throw away Bannersleuth? When I take the BannerSleuth >>> directory out of the Web* root so that BannerSleuth won't be >>> accessed, the server runs just fine, of course none of our banner >>> ads appear on our sites which doesn't make our advertisers happy >>> either. We're averaging about 18,000 page views per day which >>> translates into about 18,000 banner views per day. When we used >>> BannerSleuth initially on one site we only had about 2,000 >>> page/banner views per day and had no problems. I have no idea if >>> WebCat freaks after a certain amount of traffic. >>> >>> Any help is greatly appreciated!!!!!!!!!!!!!!!!!!!! >>> -- >>> Sincerely, >>> >>> Patrick O'Brien Systems Adminstrator and Web Manager >>> Sandusky Register http://www.sanduskyregister.com >>> Top Interactive http://www.topinteractive.com >>> 419-625-5500 ext. 333 > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://search.smithmicro.com/ >------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Patrick O'Brien

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Problem with ShoppingCart.tpl refresh (2000) Test! (2003) 'RequiredField' Question (1998) lineitems context in sendmail context (1998) Dates - Search and Sorting (1999) 2.0 Info (1997) Wanted how to (1-2-3) (1999) Did you hear about this? (1997) Item counting? (1998) [username][password] not showing up! HELP! (1999) Limitations on fields? Server is crashing (1997) [WebDNA] High-profile WebDNA sites? (2008) Setting up a lightbox (2002) Extended [ConvertChars] (1997) [WebDNA] anyone successfully using webdna with paypal's (2008) Unix DB Permission Error (2002) Document Contains No Data! (1997) No Data Results (1997) Menu Syntax on Edit/Add templates (1998) Need help with emailer- 2 issues (1997)