checkpointing works not as expected

Bug #686576 reported by Erkan Yanar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PBXT
New
Undecided
Unassigned

Bug Description

Hi,
Paul already mentioned that checkpointing had a bug an was fixed in 1.1.
#v+
You checkpoint frequency is 128M, xtstat says to-chkpt = 1049M. This
means the checkpoint has not occurred as often as he should.

This problem should be fixed in 1.1.
#v-
Playing with PBXT 1.5 it looks like the bug returns for non-default-setting. It looks like it correlates to pbxt_flush_log_at_trx_commit
I was - as in a former post inserting a lot of rows (57.000.000 this time). Dependiing on the settings of pbxt_flush_log_at_trx_commit checkpointing worked or did not. (see graph and attached xtstat-output).

I used all possible values for pbxt_flush_log_at_trx_commit
pbxt_flush_log_at_trx_commit=c(0,1,2)

checkpointing was set to
pbxt_checkpoint_frequency=64M

Regards
Erkan

Revision history for this message
Erkan Yanar (erkan-yanar) wrote :
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.