Hello Rich!
* Rich Prohaska <prohaska@stripped> [12/09/09 00:48]:
> The problem with inplace alter table operations isthat the rename of
> the FRM schema is not transactional. Are there any plans to address
> this?
This not only problem with in-place operations in 5.6, it is
also present in 5.1/5.5 and also exists in some form for ALTER TABLE
executed through creation and copying data to temporary table.
So the problem is not really something new and was there almost
forever.
We have already bugs reported about this and similar issues
(for example, see http://bugs.mysql.com/bug.php?id=25922).
But since this is pre-existing problem, which doesn't happen often,
and fixing it requires fairly big changes to ALTER TABLE/other DDL
it is unlikely that this will happen in 5.6 timeframe.
Best regards,
Dmitry
--
Dmitry Lenev, Software Developer
Oracle Development SPB/MySQL, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification
