2013/2/2 Shane Hathaway <sh...@hathawaymix.org>: > On 02/02/2013 04:13 PM, Juan A. Diaz wrote: >> >> 2013/2/2 Shane Hathaway <sh...@hathawaymix.org>: >>> >>> On 02/01/2013 09:08 PM, Juan A. Diaz wrote: >> >> Do you think that add one option in zodbpack to truncate this tables >> after the pack could be a god idea? > > > The object_ref table is intended to help the next pack run quickly, but I > suppose it might make sense to clear it anyway with an option.
Ok, I going to try implement it in the next week, and send a pull request :) >>> If your database grows by 2.2 GB per day, it's not surprising that the >>> database is 15 GB. With drive and RAM sizes today, 15 GB doesn't sound >>> like >>> a problem to me... unless it's on a Raspberry Pi. :-) >> >> >> Yes, but after the pack the size of new objects that remain in the >> database is just like 200MB. >> >> Also 15GB as you say is not a real big database for this days, but we >> are synchronizing our databases through a low bandwidth channel across >> various datacenters and in some cases recover the database from a >> failure in the sync process is real pain!. Do you think that is >> possible to don't replicate that tables could be safe? There are other >> tables that maybe we don't need replicate? > > > You never need to replicate the MyISAM tables. Only the InnoDB tables > (object_state, current_object, transaction) need to be replicated. Perfect! > Shane > Thank again for you time =) Cheers. nueces... _______________________________________________ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev