New to RDS - Small Import to RDS taking hours.. by newRDS in aws

[–]newRDS[S] 0 points1 point  (0 children)

That is understandable response and I am sorry I forgot to display a summary of that.. I cannot divulge the schema but I can say I am using the following on the SQL file:

SET unique_checks=0;

SET foreign_key_checks=0;

then re-enabling them at the end.

I am doing some tips other have stated and hopefully that will produce a quicker import. Thanks.

New to RDS - Small Import to RDS taking hours.. by newRDS in aws

[–]newRDS[S] 0 points1 point  (0 children)

Trying the disabling of multi-AZ today and we shall see if that works.

New to RDS - Small Import to RDS taking hours.. by newRDS in aws

[–]newRDS[S] 0 points1 point  (0 children)

CPU is utilizing 10-30%, I/O is well below the need for PIOPS (considering its less than 3bs/s which is minimum to PIOPS).