Archive for the ‘autocommit implicit commit’ Category

Autocommit, Implicit Commit and Open Transactions

Июнь 13th, 2010
If you have any open transaction(s); and if there is any statement that causes implicit commit, especially DDL statements; then the current active transaction will be committed and transaction will be closed automatically. Here is the list of statements that causes implicit commit in MySQL. But other day; we had an issue in production as [...]
PlanetMySQL Voting: Vote UP / Vote DOWN
 

Posted in autocommit implicit commit, autocommit open transaction, database, implicit commit, mysql, MySQL active transaction error, mysql fails to truncate table

Комментарии отключены