Re: URGENT! Locked DB's
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38408
interpreted = N
texte = On 9/6/01 7:50 AM, Patrick O'Brien
wrote:> 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!!!!!!!!!!!!!!!!!!!!Since its written to the list I will respond to the list. Just a few notes.I would highly recommend upgrading to WebCat4 it solved most of our problemsright out of the box. That said we also rewrote the logging routine tocompensate for 3.0's lack of volume capability, these updated routines canhelp and maybe the fastest/safest, but less complete fix.Additionally we found that any unix variety server is a much better bannerserver than MacOS classic. We also found linux to be the best priceperformer.I also run busy banner sites on dedicated servers so I don't take down siteson the same server if webcat crashes. I also run multiple servers andround-robin access to compensate for this under industrial strengthsituations. Rarely does one answer work for home, small office and BigBusiness. Sincerely,Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us!-------------------------------------------------------------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:
On 9/6/01 7:50 AM, Patrick O'Brien wrote:> 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!!!!!!!!!!!!!!!!!!!!Since its written to the list I will respond to the list. Just a few notes.I would highly recommend upgrading to WebCat4 it solved most of our problemsright out of the box. That said we also rewrote the logging routine tocompensate for 3.0's lack of volume capability, these updated routines canhelp and maybe the fastest/safest, but less complete fix.Additionally we found that any unix variety server is a much better bannerserver than MacOS classic. We also found linux to be the best priceperformer.I also run busy banner sites on dedicated servers so I don't take down siteson the same server if webcat crashes. I also run multiple servers andround-robin access to compensate for this under industrial strengthsituations. Rarely does one answer work for home, small office and BigBusiness. Sincerely,Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us!-------------------------------------------------------------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/
Bob Minor
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:
WebCat2 - [format thousands] (1997)
Help! WebCat2 bug (1997)
Replacing a Word (1999)
Three new problems, maybe a fourth (1997)
date formatting for CC card expiration date check (1998)
File Upload (1997)
Summing a field full of numbers ... (1997)
Database Updates (1997)
RE: [redirect] w/o showing args? (1999)
Searching a field and returning the highest value (1997)
Cookie woes with Mac IE4 (1998)
pc (1997)
Adding a product from another site (1997)
convertchars and case? (1998)
Location of Browser Info.txt file (1997)
[WebDNA] Mac Question (2018)
Help! WebCat2 bug (1997)
WebCatalog and directory indexing (1998)
re: Large databases in WebCat (1997)
popups, netscape vs explorer (1997)