[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