Implement COMMIT SYNC/DELAYED

[Peter Zaitsev]

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.

[Vadim Tkachenko (vadim-tk)]

Assigned to Alexey to implement for 5.5

[Yasufumi Kinoshita (yasufumi-kinoshita)]

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

[Vadim Tkachenko (vadim-tk)]

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

[Swany (greenlion)]

Isn't there already innodb_flush_log_at_trx_commit_session for this?

[Alexey Kopytov (akopytov)]

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.

[Shahriyar Rzayev (rzayev-sehriyar)]

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