Welcome to WebmasterWorld Guest from 23.20.223.88

Forum Moderators: open

Message Too Old, No Replies

mysqlhotcopy performance

     
6:39 pm on May 21, 2008 (gmt 0)

10+ Year Member



I'm trying to switch my backup solution from mysqldump to mysqlhotcopy, mainly because I've heard it's much faster (basically as fast as running a cp command, which is really what it is after the database was locked).

But when I tried it, I had to shoot down the script after four minutes because it still wasn't done. Later I tried the cp on the data it had copied in those four minutes (roughly 1GB), and it took like 3 seconds to duplicate. So what am I doing wrong? Is it normal that mysqlhotcopy takes so long?

 

Featured Threads

Hot Threads This Week

Hot Threads This Month