Re: Databases going to sleep
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19436
interpreted = N
texte = >However.... I recently looked at the visitor analysis page for one of our >virtual sites and it said that there had been no visitors all day. I >opened the log file with a text editor, and discovered that all of the >entries for the past 24 hours were empty-- ie the tabs and return were >there but nothing between them.We do not have a theory about this yet, but there are some things you can do to capture some more information about what's going on. Temporarily turn on the extended error logging (the last popup in your WebCat admin Preferences page). This will write to a file called WebCatalog.debug for *every* hit, before the page is processed. One of the columns contains the number of bytes of RAM available to WebCatalog at the moment of the hit.We do a lot of stuff to clean up whenever we run low on RAM, including commits of open databases, closing databases, stuff like that. Memory can get fragmented on a Mac in a way that leaves little room to work.Once you see the problem again, turn *off* the extended logging so you don't slow your server too much, and then see if there is a correlation between the slowdowns and any info in the log.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>However.... I recently looked at the visitor analysis page for one of our >virtual sites and it said that there had been no visitors all day. I >opened the log file with a text editor, and discovered that all of the >entries for the past 24 hours were empty-- ie the tabs and return were >there but nothing between them.We do not have a theory about this yet, but there are some things you can do to capture some more information about what's going on. Temporarily turn on the extended error logging (the last popup in your WebCat admin Preferences page). This will write to a file called WebCatalog.debug for *every* hit, before the page is processed. One of the columns contains the number of bytes of RAM available to WebCatalog at the moment of the hit.We do a lot of stuff to clean up whenever we run low on RAM, including commits of open databases, closing databases, stuff like that. Memory can get fragmented on a Mac in a way that leaves little room to work.Once you see the problem again, turn *off* the extended logging so you don't slow your server too much, and then see if there is a correlation between the slowdowns and any info in the log.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Time code! (2002)
suffix mapping, use of cache, etc. (1997)
unable to launch acgi in WebCat (1997)
Passing [quantity] (2000)
SetHeader (1999)
[LOOKUP] (1997)
[date format] w/in sendmail (1997)
[WebDNA] Add to cart (2014)
Me know logical no need (2002)
(long) Support (was wo search help) (1999)
REPOST: Large founditems loops (2000)
Emailer & WebStar Mail and 551 Error (2000)
nslookup (2000)
The Form authentication trick (2000)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
WebCat2: Found Items syntax, etc. (1997)
Project 2 (1998)
Calendar using WebCatalog? (1997)
EMailer - WebSTAR V - OSX - WebDNA (2003)
WebCat2 several catalogs? (1997)