Showing entries 1 to 1
Displaying posts with tag: Learningdatabasesilent failuretransactions (reset)
COMMIT and Non-Transactional Tables

database, silent failure transactions

At the July MySQL User Group Meeting, Jim Starkey wondered aloud, “What happens when I COMMIT on a memory table?” I wrote the question down, to research it later.

The obvious answer is “COMMIT on a non-transactional table does nothing.”

Tonight I was thinking about this, and I realized I do not actually COMMIT “on a table.”

The manual page at: …

[Read more]
Showing entries 1 to 1