[Bucardo-general] This doesn't look right...
Michelle Sullivan
michelle at sorbs.net
Sun Jul 4 18:24:34 UTC 2010
Joshua Tolley wrote:
> On Wed, Jun 30, 2010 at 10:58:27PM +0200, Michelle Sullivan wrote:
>
>> Greg Sabino Mullane wrote:
>>
>>>> Type: pushdelta
>>>> Source herd/database: sorbs2slave / usmaster
>>>> Target database: backup_server
>>>> Tables in sync: 58
>>>> Last good: 10m 45s (time to run: 20m 18s)
>>>> Last good time: Jun 27, 2010 17:37:29 Target: backup_server
>>>> Ins/Upd/Del: 568676 / 0 / 2262
>>>>
>>>>
>>> ...
>>>
>>>
>>>> Type: swap
>>>> Source herd/database: sorbs2master / aumaster
>>>> Target database: usmaster
>>>> Tables in sync: 58
>>>> Last good: 1h 15m 43s (time to run: 29m 17s)
>>>> Last good time: Jun 27, 2010 16:32:39 Target: usmaster
>>>> Ins/Upd/Del: 33183 / 171 / 0
>>>>
>>>>
>>> ...
>>>
>>>
>>>> Note the insert counts... how can the delta be more than the swap for
>>>> inserts... it's all supposed to be in sync....
>>>>
>>>>
>>> Hard to say from just this data. What is more disconcerting to me is
>>> the amount of time the syncs are taking - 20 minutes for half a
>>> million rows in a pushdelta sync indicates something wrong is
>>> going on. Do the logs indicate why things are taking so long?
>>>
>>>
>> Nothing - though I do see extended query times some times.. I have
>> auto-explain on so lets see:
>>
>
> Could it be that bucardo_track and/or bucardo_delta are getting bloated?
> It's often not a bad idea to vacuum them pretty aggresively.
>
>
I have VACUUM ANALYSE'd the tables, but there wasn't any noticable
difference.
Michelle
More information about the Bucardo-general
mailing list