opensubscriber
   Find in this group all groups
 
Unknown more information…

c : cluster@lists.mysql.com 26 July 2012 • 7:16PM -0400

InnoDB engine to NDB using parallel ALTER TABLE
by Róbert Kohányi

REPLY TO AUTHOR
 
REPLY TO GROUP




I'm in the process of migrating my MySQL InnoDB database (~6 GB in
total) to an NDBCluster. I'm following this blog post[1] and I'm
stumbled into a problem while executing ALTER TABLE <table_name>
ENGINE=NDB commands in parallel.

I'm initiating an ALTER TABLE <table_name> ENGINE=NDB command for
every table in all of my databases in different sessions with a script
and I see this[2]. (I *dotted out* the names of my tables, but each
'...' represents a unique table name. Please notice also, that there
are two databases db_a and db_b.)

Eventually all commands reach to an end, but in sequence and not in parallel.

Now I'm not saying this is bad a thing, but the aforementioned blog
post's writer gives me the impression that these commands really
can/should execute in parallel.

So basically my question is: what I'm seeing is perfectly fine? If not
what could have gone wrong (my configuration[3] if it helps)?

Regards,
Kohányi Róbert

[1]: http://johanandersson.blogspot.se/2012/04/mysql-cluster-how-to-load-it-with-data.html
[2]: http://pastebin.com/raw.php?i=u7KZm4YF
[3]: http://pastebin.com/raw.php?i=fXVhLcS3

--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe:    http://lists.mysql.com/cluster


Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

opensubscriber is not affiliated with the authors of this message nor responsible for its content.