On 01.03.2018 16:30, Satyanarayana Narlapuram wrote:
> Given transaction aborts are expensive, is there any impact on the crash
> recovery?
In InnoDB/XtraDB, which has used the "move old row versions to UNDO log"
since the very beginning, rollbacks are indeed costly, and especially
so on recovery when the UNDO log pages are not yet cached in RAM.
There's is a cost trade of between this kind of "optimistic MVCC" and
rollback/recovery that one has to be aware of.
We get support issues about this at MariaDB every once in a while, but
it is not happening that often.
I can dig up some more info on this from the InnoDB side if you are
interested ...
--
hartmut