NOTE: question edited to take into account restore over LAN vs. local restore.

Are there benchmarks available for the time spent doing a database restore from a mysqldump file?

Based on my experience, a restore over LAN has a speed of 100-130 Mb/min, while if the dumpfile is on the local SSD drive we're around 1 Gb/min. We're talking about database size, not dumpfile size.
Hardware capabilities seem pretty much irrelevant once one has a fairly decent CPU and amount of RAM.
I have been wondering if that above is a reasonable time or if this can be speeded up -- especially in the case of a non-local restore (i.e. done over the network).

  • This is usually dependent on the speed of the storage layer. If your dump is on the same drive as the database, you can divide max throughput by two. In my experience, 2GB per minute on good storage is a rough estimate of what I'd expect, and then factors including transaction size, number of rows inserted, etc., can all factor into it. – Randolph West Oct 19 '16 at 23:00
  • Thanks. Your comment would apply in the case of a local restore. I've modified my question. – dr01 Oct 26 '16 at 9:18
  • This is completely dependent on the NIC and switch, as well as the network protocol you're using. I'd avoid speculation until you've measured all of that first. Here's a good start on Linux: binarytides.com/linux-commands-monitor-network. For Windows, use the Resource Monitor. – Randolph West Oct 27 '16 at 5:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.