Skip navigation links

MySQL Forums :: MyISAM :: Transaction Commit and Rollback Support MyISAM


Advanced Search

Re: Transaction Commit and Rollback Support MyISAM
Posted by: Ingo Strüwing ()
Date: February 10, 2006 01:53AM

By "transactional table type" I mean either InnoDB or BDB (but the latter is only included in -max versions). There are also some non-MySQL AB storage engines in the wild that might do the trick. And possibly there might be even more in the future.

MyISAM does not support transactions and probably never will.

But we are working on a feature that can rollback commands that were active when the MySQL server crashed. It will also be possible to explicitly rollback everything from the point of a LOCK TABLES as long as no UNLOCK TABLES has been done so far.

Please do not think of it as transactional. The way MyISAM stores data does not guarantee you anything when the machine (or better the operating system) crashes. You won't be able to undo nor redo MyISAM tables to a clean state.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject Views Written By Posted
Transaction Commit and Rollback Support MyISAM 33610 Rajdeep Khurana 02/08/2006 04:05AM
Re: Transaction Commit and Rollback Support MyISAM 15209 Ingo Strüwing 02/08/2006 05:02AM
Re: Transaction Commit and Rollback Support MyISAM 11361 Rajdeep Khurana 02/09/2006 05:08AM
Re: Transaction Commit and Rollback Support MyISAM 16367 Ingo Strüwing 02/10/2006 01:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.