[ZODB-Dev] Relstorage and over growing database.

[Shane Hathaway]

On 02/02/2013 04:13 PM, Juan A. Diaz wrote:
> 2013/2/2 Shane Hathaway <shane at 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