To understand about innodb_rollback_on_timeout

[Thannasi P]

Hi All,
I would like to understand why the default value of innodb_rollback_on_timeout is set to OFF and from documentation understood that this rolls back only the last statement in a transaction and this may lead to data inconsistency if we don't retry that statement and sometimes we will add retry at method or transaction level so this also will not help i think but we want to retry only that statement so do we need to have try catch for every statement or maintain state of current execution and why this is not ON by default and rollback entire transaction so that we can safely retry that transaction,kindly help me in understanding this am also think to change this value to ON if so will there be any negative impact,any suggestions will be appreciated,thank you.

Documentation:
"InnoDB rolls back only the last statement on a transaction timeout by default. If --innodb-rollback-on-timeout is specified, a transaction timeout causes InnoDB to abort and roll back the entire transaction."