I am aware of global configuration "innodb_flush_log_at_trx_commit" in MySQL, but that is server wide.
I am looking for some way of specify that some transactions can be ACI instead of ACID, in order to reduce commit latency in exchange of risk of transaction lost if the database dies unexpectedly.
I would like to be able to specify durability guarantees transaction per transaction or, session/connection per session/connection.
Is that possible with MySQL 8.x?
UPDATE: Postgresql has this functionality via "Asynchronous Commit". For instance: https://www.postgresql.org/docs/current/wal-async-commit.html . I need something like this for MySQL.
Asked by jcea
(113 rep)
Apr 10, 2024, 02:39 PM
Last activity: Apr 10, 2024, 06:19 PM
Last activity: Apr 10, 2024, 06:19 PM