Re: Freeze

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47635
interpreted = N
texte = If the problem is as I described, more RAM will not help. Every time webdna writes to disk, it requires interaction with the OS. Slower OS's and larger db's obviously take more time to write to disk than smaller db's and faster OS's ...And if you have a lot of visitors appending, replacing or deleting records in your db's, that's going to increase the disk hits tremendously -- and slow everything down. >Hmmm... > >You may be on to something. I've been noticing my 4.5.1 server has >been unbelievably slow the last couple of weeks. Seems like that's >about when I upgraded to 4.5.1 > >I wonder if another half gig or so of ram would help...? > >> >-- > >Will Starck >NovaDerm Skincare Science >http://www.novaderm.com >wjs@novaderm.com > > >On Monday, February 10, 2003, at 07:50 PM, Kenneth Grome wrote: > >>> On 2/10/03 4:35 PM, John Hill wrote: >>> >>>> Could it be flushing large databases to disk after doing the >>>>requisit number >>>> of append/updates? That could tie up the machine. >>> Yep good thought.... The problem is the regularity. >> >> I think it's the way the new version of webdna is programmed to >>prevent db file corruption ... >> >> From my understanding (and please correct me if I'm wrong) webdna >>4.5.1 is the first version to automatically write out a temporary >>copy of whatever db it's writing to -- every time it writes to a >>db. Then it deletes this temporary file after it has successfully >>written the appropriate changes to the 'real' db file. >> >> Didn't SMSI say they implemented this behavior in order to protect >>against data loss in the event of a crash? >> >> I think they made this the default behavior in 4.5.1 because some >>people had been complaining about losing data and/or getting >>corrupted db files when a crash occurred at the same time that >>webdna was writing to the file. Unfortunately what I do not know >>is if they gave us an option to turn off this new feature, or if >>we have no choice but to deal with the new problems it creates for >>us. >> >> My gut feeling is that the server may seem like it is taking a >>break (apparently refusing to respond for 5-15 seconds) every time >>a person accesses a page that writes something to a db file. >> >> Is this possibly what's going on? >> >> I have noticed a slow response from my remote server as well, but >>until now it never occurred to me that it was a problem with the >>webdna software. After all, I'm thousands of miles away from my >>server and not always on a consistent or reliable connection. >> >> But if this has nothing to do with my connection and everything to >>do with the way this version of webdna is coded, it would be very >>nice to learn that there's a preference that lets us shut off >>this unnecessary temporary file writing. >> >> Personally I've never had any problems with webdna destroying a db >>file upon a crash. And it would not create a problem for me >>anyways, because long ago I created a template-based system that >>automatically backs up all my db files every hour or every day. >> >> Personally I would prefer the server to be as fast as possible, >>and NEVER write or delete temporary db files upon every append or >>replace or delete -- as it may be doing now ... >> >> >> Sincerely, >> Kenneth Grome >> >> --------------------------------------------------- >> WebDNA Professional Training and Development Center >> 175 J. Llorente Street +63 (32) 255-6921 >> Cebu City, Cebu 6000 kengrome@webdna.net >> Philippines http://www.webdna.net >> --------------------------------------------------- >> >> ------------------------------------------------------------- >> 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://webdna.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://webdna.smithmicro.com/Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  2. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Grant Hulbert 2004)
  3. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  4. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Dylan Wood 2004)
  5. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  6. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  7. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Dylan Wood 2004)
  8. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Grant Hulbert 2004)
  9. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  10. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Alex McCombie 2004)
  11. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  12. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  13. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Alex McCombie 2004)
  14. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Dylan Wood 2004)
  15. (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  16. Re: Webcat engine freezes when [tcpconnect] can't connect (Rene van der Velde 2003)
  17. Re: Webcat engine freezes when [tcpconnect] can't connect (Alain Russell 2003)
  18. Webcat engine freezes when [tcpconnect] can't connect (Rene van der Velde 2003)
  19. Re: Freeze (Michael Davis 2003)
  20. Re: Freeze (Stuart Tremain 2003)
  21. Re: Freeze (Michael Davis 2003)
  22. Re: Freeze (Stuart Tremain 2003)
  23. Re: Freeze (Alex McCombie 2003)
  24. Re: Freeze (Michael Davis 2003)
  25. Re: Freeze (mmilists 2003)
  26. Re: Freeze (Stuart Tremain 2003)
  27. Re: Freeze (Dan Strong 2003)
  28. Re: Freeze (lb Lawrence 2003)
  29. Re: Freeze (lb Lawrence 2003)
  30. Re: Freeze (Dan Strong 2003)
  31. Re: Freeze (Jay Van Vark 2003)
  32. Re: Freeze (lb Lawrence 2003)
  33. Re: Temp DB (Was freeze) (Alain Russell 2003)
  34. Re: Temp DB (Was freeze) (Alex McCombie 2003)
  35. Re: Temp DB (Was freeze) (John Hill 2003)
  36. Re: Temp DB (Was freeze) (Alain Russell 2003)
  37. Re: Temp DB (Was freeze) (Alex McCombie 2003)
  38. Re: Temp DB (Was freeze) (Alex McCombie 2003)
  39. Re: Temp DB (Was freeze) (John Hill 2003)
  40. Re: Temp DB (Was freeze) (Kenneth Grome 2003)
  41. Temp DB (Was freeze) (Alex McCombie 2003)
  42. Re: Freeze (John Hill 2003)
  43. Re: Freeze (Kenneth Grome 2003)
  44. Re: Freeze (Scott Anderson 2003)
  45. Re: Freeze (Charles Kline 2003)
  46. Re: Freeze (Kenneth Grome 2003)
  47. Re: Freeze (Alex McCombie 2003)
  48. Re: Freeze (WJ Starck 2003)
  49. Re: Freeze (Kenneth Grome 2003)
  50. Re: Freeze (Alex McCombie 2003)
  51. Re: Freeze (Alex McCombie 2003)
  52. Re: Freeze (John Hill 2003)
  53. Re: Freeze (Alex McCombie 2003)
  54. Re: Freeze (Donovan 2003)
  55. Re: Freeze (John Hill 2003)
  56. Re: Freeze (Craig Forest 2003)
  57. Re: Freeze (Donovan 2003)
  58. Re: Freeze (Donovan 2003)
  59. Re: Freeze (Alex McCombie 2003)
  60. Re: Freeze (Don 2003)
  61. Re: Freeze (Donovan 2003)
  62. Re: Freeze (Alex McCombie 2003)
  63. Re: Freeze (lb Lawrence 2003)
  64. Re: Freeze (Brian Boegershausen 2003)
  65. Re: Freeze (Charles Kline 2003)
  66. Freeze (lb Lawrence 2003)
  67. Re: Emailer freezes under OSX (Paula E. Contini 2003)
  68. Emailer freezes under OSX (nelson 2003)
  69. Install Webcat 4.01 - Server Hard Freeze (Rupert Ravens 2000)
  70. Re: Server Freeze...not always (Grant Hulbert 1998)
  71. Re: Server Freeze (Kenneth Grome 1998)
  72. Re: Server Freeze (Peter Ostry 1998)
  73. Re: Server Freeze (Peter Ostry 1998)
  74. Re: Server Freeze (Sid Stary 1998)
  75. Re: Server Freeze (Britt T. 1998)
  76. Re: Server Freeze (Kenneth Grome 1998)
  77. Re: Server Freeze (bob 1998)
  78. Re: Server Freeze (dave spaulding 1998)
  79. Re: Server Freeze (Kenneth Grome 1998)
  80. Re: Server Freeze (Brian B. Burton 1998)
  81. Re: Server Freeze (Kenneth Grome 1998)
  82. Re: Server Freeze (Peter Ostry 1998)
  83. Re: Server Freeze (Sid Stary 1998)
  84. Re: Server Freeze (Brian B. Burton 1998)
  85. Re: Server Freeze (Brian B. Burton 1998)
  86. Re: Server Freeze (PCS Technical Support 1998)
  87. Re: Server Freeze (Kenneth Grome 1998)
  88. Server Freeze (Brian B. Burton 1998)
  89. Re: database freeze (Kenneth Grome 1997)
  90. database freeze (Dean Smith 1997)
  91. Re: WebSTAR 2.1 freezes my Mac (grichter@panavise.com (Gary Richter) 1997)
  92. Re: WebSTAR 2.1 freezes my Mac (Kenneth Grome 1997)
  93. Re: WebSTAR 2.1 freezes my Mac (grichter@panavise.com (Gary Richter) 1997)
  94. WebSTAR 2.1 freezes my Mac (Kenneth Grome 1997)
  95. Re: [format xs] freeze (Grant Hulbert 1997)
  96. Re: [format xs] freeze (Grant Hulbert 1997)
  97. Re: [format xs] freeze (Nelson Chen 1997)
  98. [format xs] freeze (Nelson Chen 1997)
If the problem is as I described, more RAM will not help. Every time webdna writes to disk, it requires interaction with the OS. Slower OS's and larger db's obviously take more time to write to disk than smaller db's and faster OS's ...And if you have a lot of visitors appending, replacing or deleting records in your db's, that's going to increase the disk hits tremendously -- and slow everything down. >Hmmm... > >You may be on to something. I've been noticing my 4.5.1 server has >been unbelievably slow the last couple of weeks. Seems like that's >about when I upgraded to 4.5.1 > >I wonder if another half gig or so of ram would help...? > >> >-- > >Will Starck >NovaDerm Skincare Science >http://www.novaderm.com >wjs@novaderm.com > > >On Monday, February 10, 2003, at 07:50 PM, Kenneth Grome wrote: > >>> On 2/10/03 4:35 PM, John Hill wrote: >>> >>>> Could it be flushing large databases to disk after doing the >>>>requisit number >>>> of append/updates? That could tie up the machine. >>> Yep good thought.... The problem is the regularity. >> >> I think it's the way the new version of webdna is programmed to >>prevent db file corruption ... >> >> From my understanding (and please correct me if I'm wrong) webdna >>4.5.1 is the first version to automatically write out a temporary >>copy of whatever db it's writing to -- every time it writes to a >>db. Then it deletes this temporary file after it has successfully >>written the appropriate changes to the 'real' db file. >> >> Didn't SMSI say they implemented this behavior in order to protect >>against data loss in the event of a crash? >> >> I think they made this the default behavior in 4.5.1 because some >>people had been complaining about losing data and/or getting >>corrupted db files when a crash occurred at the same time that >>webdna was writing to the file. Unfortunately what I do not know >>is if they gave us an option to turn off this new feature, or if >>we have no choice but to deal with the new problems it creates for >>us. >> >> My gut feeling is that the server may seem like it is taking a >>break (apparently refusing to respond for 5-15 seconds) every time >>a person accesses a page that writes something to a db file. >> >> Is this possibly what's going on? >> >> I have noticed a slow response from my remote server as well, but >>until now it never occurred to me that it was a problem with the >>webdna software. After all, I'm thousands of miles away from my >>server and not always on a consistent or reliable connection. >> >> But if this has nothing to do with my connection and everything to >>do with the way this version of webdna is coded, it would be very >>nice to learn that there's a preference that lets us shut off >>this unnecessary temporary file writing. >> >> Personally I've never had any problems with webdna destroying a db >>file upon a crash. And it would not create a problem for me >>anyways, because long ago I created a template-based system that >>automatically backs up all my db files every hour or every day. >> >> Personally I would prefer the server to be as fast as possible, >>and NEVER write or delete temporary db files upon every append or >>replace or delete -- as it may be doing now ... >> >> >> Sincerely, >> Kenneth Grome >> >> --------------------------------------------------- >> WebDNA Professional Training and Development Center >> 175 J. Llorente Street +63 (32) 255-6921 >> Cebu City, Cebu 6000 kengrome@webdna.net >> Philippines http://www.webdna.net >> --------------------------------------------------- >> >> ------------------------------------------------------------- >> 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://webdna.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://webdna.smithmicro.com/Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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://webdna.smithmicro.com/ Kenneth Grome

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:

form data submission gets truncated (1997) search function (2005) Tracking inbound links for discounts (1997) Re:redirect from the errorsMessages.db entry (1997) Using Eudora instead of Emailer, and cron facility (1998) Help formatting search results w/ table (1997) WebCat2b12plugin - [search] is broken ... not! (1997) Reading Field (2003) Maybe minor bug report (1997) [ShowIf] if the varieable exists (1998) [OT] Xserve for Web Hosting (2003) How do you hide [math]stuff[/math] (1997) Image maps/Webcat (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Error Lob.db records error message not name (1997) A little syntax help (1997) WebSite and *NO* Authentication Dialog Box!!? (1998) Change to 5.0 per website licensing (2003) WebCommerce: Folder organization ? (1997) brain teaser with an advanced search (2001)