Disabling AUTOCOMMIT, UNIQUE_CHECKS, and FOREIGN_KEY_CHECKS speeds up mysql restores dramatically. My own tests of a 30MB dump were cut from 6 minutes to 11 seconds. My 2GB backups can now be imported in a reasonable 40 minutes. The following script will add one line to the top and bottom of your mysqldump file. This can take a while for large files. There’s no shortcut…
Tag: Database
Reclaim Mongodb Diskspace
Mongodb chews through disk space. Even our lightly used servers need to be cleared out every couple of months. The new usePowerOf2Sizes flag has helped but it hasn’t eliminated our need to perform a full –repair every once in a while. Unfortunately, the process requires downtime and even more free space than Mongo has consumed, but after mounting a temporary…
Matt Williamson 