Comments on: Experimenting with 5.6 InnoDB Online DDL (bugs included) https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included Blog by Shlomi Noach Mon, 21 Jan 2013 00:37:38 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Log Buffer #291, A Carnival of the Vanities for DBAs https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included/comment-page-1#comment-164677 Mon, 21 Jan 2013 00:37:38 +0000 https://shlomi-noach.github.io/blog/?p=5673#comment-164677 […] 5.6 offers the groundbreaking online DDL operations for InnoDB. Shlomi Noach […]

]]> By: MySQL-5.6 online DDL特性 ← hickey https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included/comment-page-1#comment-126633 Wed, 24 Oct 2012 14:36:50 +0000 https://shlomi-noach.github.io/blog/?p=5673#comment-126633 […] 2. DDL中新加的lock/algorithm选项还没研究明白性能到底如何提升，在哪些情况下如何使用。 […]

]]> By: hickey.liu@gmail.com https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included/comment-page-1#comment-126585 Wed, 24 Oct 2012 12:29:36 +0000 https://shlomi-noach.github.io/blog/?p=5673#comment-126585 I tested on my environment, “algorithm=inplace, lock=none” works for adding a column:

root@xiyu 08:28:06>ALTER TABLE sbtest1 ADD COLUMN book char(60) NOT NULL DEFAULT ”, algorithm=inplace, lock=none;

Oracle should release more notes on the advantages for the new added “algorithm” and “lock” options for DDL, puzzled me still.

]]> By: InnoDB DDL: kudos to quick responders on bugs.mysql.com | code.openark.org https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included/comment-page-1#comment-124451 Thu, 18 Oct 2012 16:55:39 +0000 https://shlomi-noach.github.io/blog/?p=5673#comment-124451 […] Experimenting with 5.6 InnoDB Online DDL (bugs included) […]

]]> By: Simon J Mudd https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included/comment-page-1#comment-124450 Thu, 18 Oct 2012 16:54:43 +0000 https://shlomi-noach.github.io/blog/?p=5673#comment-124450 For many of these commands there are too few real life, more complex examples provided.
I spent a long time trying to figure out why a table I was adding a new column to couldn’t be partitioned at the same time. No it can’t and unless you really stare (or a nice soul puts you out of your misery and confirms you can’t do this) you just don’t see this type of thing.

So I think that complex commands like ALTER TABLE should have a good long list of typical use cases (perhaps with comments) on how to achieve different actions which are possible.

Oh and yes, we are _all_ waiting for pt-online-schema equivalent behaviour inside the database and when as a DBA you’re bound to not let replication drift over a few seconds, you won’t be sweating when the next 30 GB table has to be altered..

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included/comment-page-1#comment-124420 Thu, 18 Oct 2012 14:48:42 +0000 https://shlomi-noach.github.io/blog/?p=5673#comment-124420 @Marc,
Thanks again, please see updates within text

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included/comment-page-1#comment-124407 Thu, 18 Oct 2012 14:18:08 +0000 https://shlomi-noach.github.io/blog/?p=5673#comment-124407 Marc, Savior of the day! I’m too accustomed to SQL syntax.
Will review and update text.

]]> By: Marc Alff https://shlomi-noach.github.io/blog/mysql/experimenting-with-5-6-innodb-online-ddl-bugs-included/comment-page-1#comment-124402 Thu, 18 Oct 2012 13:58:00 +0000 https://shlomi-noach.github.io/blog/?p=5673#comment-124402 The MySQL 5.6 manual, in:
http://dev.mysql.com/doc/refman/5.6/en/alter-table.html

states that the syntax is:

ALTER [IGNORE] TABLE tbl_name
[alter_specification [, alter_specification] …]
[partition_options]

That is, the list of “[alter_specification]” is separated by commas.

See comments in bug#65466.

]]>