I'm in the middle of migrating an InnoDB database to an NDBCluster. I use mysqldump to first create two dumps, the first one contains only the database schema, the second one contains only tab delimited data (via mysqldump --tab). I edit my InnoDB schema here and there (ENGINE=InnoDB to ENGINE=NDB, etc.) import it and after this I import the InnoDB data *as is* using mysqlimport.
I use it like this: mysqlimport --local --use-threads=4 db dir/*.txt (dir of course cotains the tab delimited data I dumped before.) The import starts, and I check its progress via mysqladmin, like this: mysqladmin --sleep=1 processlist this is what I see: http://pastebin.com/raw.php?i=M23fWVjc Only a single process seems to be loading my data. Is this what I *should* see, or, in my case using 4 threads, should I see four processes? I'm not asking which one will be faster, I'm just simply confused because I don't know what to expect. If I start four different mysqlimport processes, each one importing different files, then I can see four different process in the mysql processlist. If it's matters, here is my server version (I use the official binaries). Server version: 5.5.25a-ndb-7.2.7-gpl MySQL Cluster Community Server (GPL) Regards, Kohányi Róbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
