可以在MySQL事务中运行整个PHP应用程序吗？

Question

Is it ok to run whole PHP application in a MySQL transaction?

Is there any side effects?

I mean something like this:

1. Client requests A.php
2. A.php -> start mysql transaction
3. A.php -> execute and process request
4. A.php -> commit mysql transaction
5. send requested data to client

Answer 1

I would not call this running the whole PHP application in one transaction, but rather a PHP script that treats each request in a separate transaction.

That is fine, as long as you are aware of transaction related concepts, such as locking, deadlocks, starvation, ... In essence, you should like in any other environment not lock database objects longer than necessary, prefer fine grained row locks over full table locks and protect your database against deadlocks.

But as those same concepts apply in a pure SQL engine based (stored procedure) solution, there is no particular reason not to do this in PHP.