Re: [ZODB-Dev] RelStorage recommended maintenance
On 01/21/2011 03:38 PM, Chris Withers wrote: > On 21/01/2011 22:09, Laurence Rowe wrote: >> On 21 January 2011 20:57, Shane Hathaway wrote: >>> On 01/21/2011 10:46 AM, Chris Withers wrote: I'm wondering what the recommended maintenance for these two types of storage are that I use: - keep-history=true, never want to lose any revisions My guess is zodbpack with pack-gc as true, but what do I specify for the number of days in order to keep all history? >>> >>> Is 100 years enough? 365.24 * 100 = 36524 ;-) >> >> Why would you pack a database from which you don't want to lose any >> revisions. > > It's a fair point. > > I can't think of anything, but given that Shane didn't make your point, > I wonder if he can? Heh, I am obviously not paying enough attention. Don't pack that database. :-) Shane ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] RelStorage recommended maintenance
On 21/01/2011 22:09, Laurence Rowe wrote: > On 21 January 2011 20:57, Shane Hathaway wrote: >> On 01/21/2011 10:46 AM, Chris Withers wrote: >>> I'm wondering what the recommended maintenance for these two types of >>> storage are that I use: >>> >>> - keep-history=true, never want to lose any revisions >>> >>> My guess is zodbpack with pack-gc as true, but what do I specify for the >>> number of days in order to keep all history? >> >> Is 100 years enough? 365.24 * 100 = 36524 ;-) > > Why would you pack a database from which you don't want to lose any revisions. It's a fair point. I can't think of anything, but given that Shane didn't make your point, I wonder if he can? cheers, Chris -- Simplistix - Content Management, Batch Processing & Python Consulting - http://www.simplistix.co.uk ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] RelStorage recommended maintenance
On 21 January 2011 20:57, Shane Hathaway wrote: > On 01/21/2011 10:46 AM, Chris Withers wrote: >> I'm wondering what the recommended maintenance for these two types of >> storage are that I use: >> >> - keep-history=true, never want to lose any revisions >> >> My guess is zodbpack with pack-gc as true, but what do I specify for the >> number of days in order to keep all history? > > Is 100 years enough? 365.24 * 100 = 36524 ;-) Why would you pack a database from which you don't want to lose any revisions. Laurence ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] RelStorage recommended maintenance
On 01/21/2011 10:46 AM, Chris Withers wrote: > I'm wondering what the recommended maintenance for these two types of > storage are that I use: > > - keep-history=true, never want to lose any revisions > > My guess is zodbpack with pack-gc as true, but what do I specify for the > number of days in order to keep all history? Is 100 years enough? 365.24 * 100 = 36524 ;-) > - keep-history=false, never want any revisions or unreferenced objects > > My guess is zodbpack with pack-gc as true and days as 0? Sounds right. > All storages will be in MySQL, are there any duty-cycle or other > parameters I should tweak from their default values? As I recommend to everyone, there should be no need to tweak anything unless you have measurements that tell you the defaults don't fit your site. > How often do you recommend running zodbpack? Daily. Shane ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
[ZODB-Dev] RelStorage recommended maintenance
Hi Shane, I'm wondering what the recommended maintenance for these two types of storage are that I use: - keep-history=true, never want to lose any revisions My guess is zodbpack with pack-gc as true, but what do I specify for the number of days in order to keep all history? - keep-history=false, never want any revisions or unreferenced objects My guess is zodbpack with pack-gc as true and days as 0? All storages will be in MySQL, are there any duty-cycle or other parameters I should tweak from their default values? How often do you recommend running zodbpack? cheers, Chris -- Simplistix - Content Management, Batch Processing & Python Consulting - http://www.simplistix.co.uk ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev