Implement COMMIT SYNC/DELAYED

Bug #590289 reported by Peter Zaitsev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Won't Fix
Wishlist
Unassigned
5.5
Won't Fix
Wishlist
Unassigned

Bug Description

Currently one can define global commit type with innodb_flush_log_at_trx_commit
In practice however in applications there are different level of durability needed for different transactions - for example money transfer may require durability while in the same system update of view counter does not need one

We could implement COMMIT SYNC and COMMIT DELAYED to force given transaction commit as values 0 (or 2) and 1 independent on global setting.

Percona (percona-team)
Changed in percona-server:
status: New → Confirmed
importance: Undecided → Wishlist
Revision history for this message
Vadim Tkachenko (vadim-tk) wrote :

Assigned to Alexey to implement for 5.5

Changed in percona-server:
assignee: nobody → Alexey Kopytov (akopytov)
importance: Wishlist → Low
milestone: none → 5.5-20beta
Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

Comment about naming.
"DELAYED" is not for "COMMIT".... for sync transaction log.
"COMMIT" ends at once at the time.

Revision history for this message
Vadim Tkachenko (vadim-tk) wrote :

It won't be ready soon. Set milestone to undefined.

Changed in percona-server:
milestone: 5.5-20beta → none
milestone: none → 5.5-20beta
Changed in percona-server:
milestone: 5.5-20beta → none
Revision history for this message
Swany (greenlion) wrote :

Isn't there already innodb_flush_log_at_trx_commit_session for this?

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Yes, looks like this functionality is already available in a different form with innodb_flush_log_at_trx_commit_session. Changing to Won't Fix, feel free to reopen if I'm missing something.

Changed in percona-server:
assignee: Alexey Kopytov (akopytov) → nobody
Changed in percona-server:
status: Triaged → Won't Fix
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2312

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.