When I export data from InfiniDB, I find it a little slow. I do exporting in two usages:
1. export data to out file
Because InfiniDB has param limitation using mysqldump, so I use "SELECT ... INTO OUTFILE" and "idbmysql -e 'SELECT ... ' > outfile". Both is slow, nearly 10 million records per min.
2. export data to table internal InfiniDB
It's recommend to use "idbmysql -e 'SELECT ... ' | cpimport ... " in document of Admin Guide. But it's also too slow to do that even though the SELECT statement can be respones quickly, the whole process spends many minutes. And it's much more faster to load same size data from file using cpimort.
I guess it may caused by the data must process from PMs to UM, and then ouput from single UM node.
So, any other ways to make such exporting faster? Thank you.