i've a mysqldump ( 1.5G large ) of a table I need to import.
The server i bought, which is clean and not under load, takes > 2hours to import it.
I read many tweaks i can use to speed up the import process but none of them are really helping.
Particoularly I did reformat the dump as folllow:
SET autocommit=0; SET unique_checks=0; SET foreign_key_checks=0; --- Original dump content. --- COMMIT; SET unique_checks=1; SET foreign_key_checks=1;
This, as I already said, didn't help. I also enabled the following stuff in my my.cnf
innodb_additional_mem_pool_size = 20971520 innodb_buffer_pool_size = 536870912 innodb_file_per_table innodb_log_buffer_size = 8388608 join_buffer_size = 67104768 max_allowed_packet = 5241856 max_binlog_size = 1073741824 max_heap_table_size = 41943040 read_buffer_size = 20967424 sort_buffer_size = 67108856 table_cache = 256 thread_cache_size = 128 thread_stack = 327680 tmp_table_size = 41943040
You can find my hardware specs here: http://www.hetzner.de/en/hosting/produkte_rootserver/ex4
Just for completeness i'm using percona xtradb cluster server 5.5 but the mysql cluster is composed by only one node.
UPDATE. I'm using software raid 1.