content_image/701839.jpg content_image/701840.jpg content_image/701843.jpg
<img src='content_image/701839.jpg'>

The transaction completion type. This variable can take the values shown in the following table. The variable can be assigned using either the name values or corresponding integer values. 

<img src='content_image/701840.jpg'>

completion_type  affects transactions that begin with START TRANSACTION  or BEGIN  and end with COMMIT  or ROLLBACK . It does not apply to implicit commits resulting from execution of the statements listed in Section 13.3.3, “Statements That Cause an Implicit Commit” . It also does not apply for XA COMMIT , XA ROLLBACK , or when autocommit=1 . 

• concurrent_insert 

<img src='content_image/701843.jpg'>

