{kb-symptom}
We have a large number of databases:
more than 250,000 tables (660 databases, 60 Gb).
Restoring a single database was a good time to restoring.
When restoring all databases at once, the process takes too much time: 8 hours restoring and it still didn't finish.
{kb-cause}
When databases are restored individually, the process naturally takes long time. The reason is that each row must be selected and inserted.
{kb-resolution}
It is recommended to use the Files Restore function to restore large amount of databases at once. See [CDP:Restoring MySQL Instance Best Practices].
{kb-related-articles}
We have a large number of databases:
more than 250,000 tables (660 databases, 60 Gb).
Restoring a single database was a good time to restoring.
When restoring all databases at once, the process takes too much time: 8 hours restoring and it still didn't finish.
{kb-cause}
When databases are restored individually, the process naturally takes long time. The reason is that each row must be selected and inserted.
{kb-resolution}
It is recommended to use the Files Restore function to restore large amount of databases at once. See [CDP:Restoring MySQL Instance Best Practices].
{kb-related-articles}