I'm new in db administration and I've looked for a faster import of a mysqldump.
I had a db with about 1.1 million rows and mostly InnoDB tables and wanted this to import on a managed server. Before I used the standard mysqldump command for dumping the db. At import I had a write speed of about 60.000 rows per hour which was extremly slow.
I searched for a way to speed thingsup and found a post here saying to use --single-transaction and --extended-insert on mysqldump. Now the dump is importing in under 30 seconds.
After a quick overview it seems that the data is correctly imported but I'm a little bit leery about the fast import.
Why is this soo fast after adding these two options? Are there any disadvantages on using this options?
Thank you for your help.