Problem:
While the restore of the dump data using “mysqldump” and restore becomes utterly slow in JIRA.
MySQL dump:
“mysqldump” – A command-line interface for administrators or end users to export data from the server to files.
“mysqldump -h hostname -u user -p –triggers –single-transaction –no-create-db dbname | gzip > database.sql.gz” When using this command is taking long time.
40 GB of database takes ~6 hours to complete mysql dump
For restoring:
mysql -u username -h host name -p database name < database.sql.gz
Mysql restore its took ~15 hours.
Root cause:
ZIP- A .ZIP file may contain one or more files or subdirectories that might have been compressed.
Solution:
It reduces the time consumption for this process, by following the below steps.
Use the data file contents without zip file type extension which allows the process to easily finish this job.
mysqldump -h hostname -u user -p –triggers –single-transaction –no-create-db dbname > database.sql
Its took ~1 hour to complete the mysqldump process.
mysql -u username -h host name -p database name < database.sql
mysql restore its took ~ 3 hours to complete the restore process.