>>The weird thing now is that the MySQL folks claim that the InnoDB table
>>type supports ACID-compliant transactions with all four isolation levels
>>and even support of the MVCC model. Well, this is off-topic here, but I
>>do find it somewhat strange.
>>
>
> Watch carefully what MySQL claims.

I do for quite some time now. ;-)


I had a long argument with Monty in

> which he claimed that the original MyISAM supported ACID transactions
> with the simple restriction that each transaction consisted of one
> statement.

Interesting definition for "transaction support". Probably they have do,
because MyISAM is the only table type which supports an often asked
feature called "full-text search". Either transaction support or
full-text search. Let the database developer decide. Pretty weird.


Cheers,
Thomas