I'm using mysqld Ver 5.7.25-0 in Ubuntu 16.04. I dumped from AWS Relational Database Service (RDS) with mysqldump --single-transaction --quick --max_allowed_packet 1G ... and now when I tried to load the dump with the command: mysql -u <mu_user_name> -p<my_pwd> <mu_db_name> < /mnt/rds.sql I got stuck for almost 5 days. How long should it take and how can I speed up the processes? The rds.sql dump file size is 254G. btw I redirect the datadir of MySQL with symlink according to this tutorial.

migrated from superuser.com Apr 7 at 11:55

This question came from our site for computer enthusiasts and power users.

  • Which machine is your mysql running on? What is the ping time between it and the AWS machine? – Rick James Apr 22 at 1:18
  • my point is to reduce the restore time , the dumping take about 1-2 hours fom Aurora MySQL aws RDS . i am talking about loading from the memory (.sql files to mysqld), i am using AWS m4.large instance type with 2048 GiB – junior_software Apr 22 at 5:00
  • I am trying to find out if the .sql files are being copied a long distance over the network. – Rick James Apr 22 at 5:04
  • they are , but they are not my bottleneck , i copy the tables locally to my vm and the restore from them take a long time. – junior_software Apr 22 at 5:10
  • Do wc /mnt/rds.sql - That will give you a clue of how long it takes to read every byte of the file. Obviously, the loading cannot go faster than that. – Rick James Apr 22 at 13:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.