Shulou(Shulou.com)05/31 Report--

How to understand mysql implicit commit transaction transaction, I believe that many inexperienced people do not know what to do. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Overview of implicitly committed transactions

A transaction is a complete operation logic whole, including a series of operation statements. There are several ways to mark a transaction:

Introduction

A netizen client asked me a question, it uses the above way to start a transaction in a transaction, why the transaction is not explicitly committed, and how to find that the sql operation in the transaction is saved to the table?

Generate some cases of implicit transaction commit

After consulting the mysql official manual, some specific statement types will cause the current transaction to commit implicitly.

Some thoughts on implicit transaction submission

Transactions should not put dml and non-dml SQL operation statements in one transaction, resulting in exceptions and data inconsistencies.

Dml put a separate transaction

Enter a separate transaction other than dml

Dml operations must be strictly controlled and standardized, especially for online databases.

Through the sql audit platform or enabling mysql audit for management, there are signs to follow.

After reading the above, have you mastered how to understand how mysql implicitly commits transaction transaction? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.