If there is an uncommitted transaction in MySQL, then the AUTOCOMMIT automatic submission parameter should be 0 at this time. However, if you operate through MySQL drivers in other languages, these drivers generally have the function of automatically recovering AUTOCOMMIT. After the request processing is completed, unprocessed transactions will be automatically ROLLBACKed.
When the database connection is disconnected or the request ends, it will usually rollback automatically
This is the answer everyone will give, but is it actually the rollback of the server, the startup environment (FPM), or the connection library operation of the code? ? ? Not sure, but my guess is that the tool class connected to the database automatically rollbacks, or the startup environment (FPM) automatically rollbacks directly when the server is ready to return data to the client
There are also official documents on the Internet, for example, PHP-mysql is a rollback automatically called by PDO (database driver library). But it didn’t say when exactly it would be disconnected. . .
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
If there is an uncommitted transaction in MySQL, then the AUTOCOMMIT automatic submission parameter should be 0 at this time.
However, if you operate through MySQL drivers in other languages, these drivers generally have the function of automatically recovering AUTOCOMMIT. After the request processing is completed, unprocessed transactions will be automatically ROLLBACKed.
When the connection times out, transactions that have not been committed on that connection will be rolled back
1. When the link is disconnected, it will automatically rollback
2. When there is a deadlock or the lock times out, it will also rollback
When the database connection is disconnected or the request ends, it will usually rollback automatically
This is the answer everyone will give, but is it actually the rollback of the server, the startup environment (FPM), or the connection library operation of the code? ? ? Not sure, but my guess is that the tool class connected to the database automatically rollbacks, or the startup environment (FPM) automatically rollbacks directly when the server is ready to return data to the client
There are also official documents on the Internet, for example, PHP-mysql is a rollback automatically called by PDO (database driver library). But it didn’t say when exactly it would be disconnected. . .