SELECT @@GLOBAL.tx
read
only, @@tx
read
only;
SHOW ENGINE INNODB STATUS\G
- To commit:COMMIT;
- To roll back:ROLLBACK;
START TRANSACTION;
Followed by your transaction commands.
6. Verify that your client or connection library is correctly managing transactions, particularly regarding automatic transaction handling features.
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)