Database Solutions

Improve & Optimizing Performance of the MySQL Restore with mysqldump Backup and restoration are common activity are very common activity which DBAs do on regular basis. But important fact is how we can improve and optimize the performance of backup and restore operation.  In this blog , We are going to discuss about the method with which we can improve the performance of the MySQL Database restoration via mysqldump. Below are the details of two method which can be used to improve performance: 1)  Split the dump file info multiple file for each table. And then import the multiple file with parallel sessions into database. Below script can be used to split mysqldump into multiple files: #!/bin/bash if [ $# -lt 1 ] ; then   echo "USAGE $0 DUMP_FILE [TABLE]"   exit fi if [ $# -ge 2 ] ; then   csplit -s -ftable $1 "/-- Table structure for table/" "%-- Table structure for table \`$2\`%" "/-- Table structure for table/" "%40103 SET TIME_ZONE=@O...