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.

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.

Shane

_______________________________________________
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

Reply via email to