> I agree with Scott that Micha's list seems to be out-dated or not explained well.
Well, I have posted the origins of Micha's list. It is from
March/April 2003. The explanation is a bit coarse indeed if you
can't read the original thread in Dutch.
[4. tablenames & case-sensitivy]
> I believe this not to be a MySQL specific problem.
In databases it pretty much is MySQL specific. Maybe SQLLite too.
[5. temporary copy when using DDL]
> What about creating a new table and dumping the "new" data in.
Won't do, while DDL isn't transactional in MySQL (which one could
consider a number on its own), what you are suggesting isn't even
atomic.
[6. temporary copy when adding index]
> Yea, but how many times are you adding a new index?
Often enough not to want it to fail.
Serious, even if MySQL handles the failure itself gracefully and
performs its equivalent of a rollback, there is a short period of
time that the disk is full. That means there is a risk that many
other write operations will fail too, not only writes to other
tables, but also to the internal catalogs (which is why I think
non-transactional DDL is a point of its own).
> A lot of these I must say you can't get anything better than MySQL for free (maybe PostgreSQL).
At least PostgreSQL and Firebird. From a data integrity point of
view I might even choose Access over MySQL (if that suits your
definition of 'free').
I forwarded your points to the guy maintaining the original list.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
