Tristan Rivoallan
MySQL application developers have some problems with connection state. There is a lot of state which can be used associated with a single connection
* Transactions (autocommit, uncommitted work, when a transaction was started, isolation level)
* Temporary tables
* Session variables which affect behaviour
* Other session variables
If you can avoid all of these, then you can benefit from transparent auto-reconnection and transparent connection reuse / pooling etc.
dev mysql documentation clevermarks bestpractices
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.