Planet MySQL

Displaying posts with tag: implicit commit (reset)

Jun

2010

Autocommit, Implicit Commit and Open Transactions

Posted by Venu Anuganti on Sun 13 Jun 2010 07:11 UTC
Tags:

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

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[...]

Mar

2010

Log Buffer #182, a Carnival of the Vanities for DBAs

Posted by The Pythian Group on Fri 12 Mar 2010 17:01 UTC
Tags:

Oracle, convention, Security, Fun, scaling, Log Buffer, humor, scalability, drizzle, SQL Server, DB2, ETL, Migration, patch, io, column store, best practice, scale, slides, survey, alias, twitter, top, date, column, dw, Batch, NoSQL, cassandra, vertical, capacity planning, infinidb, Technical Blog, confoo, relational, Migrate, column-oriented, e-book, ebook, implicit commit, internship, iptables, mainframes, patching, STATISTICS IO, string, table alias, TSQL, MySQL

This is the 182nd edition of Log Buffer, the weekly review of database blogs. Make sure to read the whole edition so you do not miss where to submit your SQL limerick!

This week started out with me posting about International Women’s Day, and has me personally attending Confoo (Montreal) which is an excellent conference I hope to return to next year. I learned a lot from confoo, especially the blending nosql and sql session I attended.

This week was also the Hotsos Symposium. …

[Read more]

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links