Forum .LRN Q&A: Re: can .LRN support MYSQL database?

Collapse
10: Re: can .LRN support MYSQL database? (response to 8)
Posted by Dirk Gomez on 09/30/04 10:05 AM
Don, do I understand this correctly? If a MySQL process crashes while a SQL DML statement is being executed, some pieces of data remain changed while others don't? Now that is some surprising news that would rule out MySQL for almost any application...
Collapse
11: Re: can .LRN support MYSQL database? (response to 10)
Posted by Roberto Mello on 09/30/04 05:30 PM
As Don said: "With the original MySQL backend, atomicity at the statement level was not guaranteed."

The original (and default) MySQL backend is the MyISAM table type. With MyISAM there is no atomicity guarantee whatsoever. There's a utility that tries to repair broken databases with MyISAM.

You only have some atomicity with the InnoDB and BDB table types.

-Roberto