Not the answer you need?
Register and ask your own question!

Mysqldump backup based restore taking lot time

ishan_agarwal16@yahoo.com[email protected] EntrantCurrent User Role Beginner
I have a MySQL server instance with 3 databases of total size 120 GB (65 GB, 30 GB and 25 GB). My mysqldump backup completed in just 30 mins. But the import of the same dumpfile on another host took more than 5 hours. I googled for speeding up the import dump by using
SET AUTOCOMMIT = 0; SET FOREIGN_KEY_CHECKS=0 still couldn't observe any improvement. Also I observed in parallel, the individual DB size during import for progress, it reached to 64GB and getting reduced to 50 GB again , then restoring backup to 65 GB. It might sound a very basic question to many - 1.) During import, why this increase/decrease of DB size happens? 2.) Any other way or alternative for speeding up mysql import through dump file? How much time would Xtrabackup take for the same size? My sincere thanks in advance to all MySQLearners for extending help in same.

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.