homepage Welcome to WebmasterWorld Guest from 54.227.11.45
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
mysqlhotcopy performance
yosmc




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

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?

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved