List:Internals« Previous MessageNext Message »
From:Dmitry Lenev Date:September 12 2012 7:41am
Subject:Re: Schema inconsistency after inplace alter table in MySQL 5.6.6-m9
View as plain text  
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
Thread
Schema inconsistency after inplace alter table in MySQL 5.6.6-m9Rich Prohaska31 Aug
  • Re: Schema inconsistency after inplace alter table in MySQL 5.6.6-m9Dmitry Lenev12 Sep
    • Re: Schema inconsistency after inplace alter table in MySQL 5.6.6-m9Rich Prohaska12 Sep
      • Re: Schema inconsistency after inplace alter table in MySQL 5.6.6-m9Dmitry Lenev12 Sep