backup speed

[mister]

I was just wondering how the speed of a mysql dump grows as the database grows. As of right now, i have about 400 posts and 100some users, and the mysqldump takes at most a second. I was just curious as to what will happen when theres 1000's of threads/posts.

Also, what happens to any database hits while the mysqldump is going on?

Thanks,
Brandon

[John]

Yes, the time to dump the database does increase as the database size increases. For a large database, it be in excess of 5 minutes. Any updates to the table that mysqldump is working on are put on hold until mysqldump finishes with that particular table, so this can often clog up your server.

There is a utility called mysqlhotcopy that can do database copies and backups quicker.
http://www.mysql.com/doc/m/y/mysqlhotcopy.html

John

[Chris Schreiber]

I have a backup script I run through cron at off hours to automatically backup: http://161.58.84.213/forum/showthread.php?s=&threadid=4256

For my database (200MB) it takes 3-5 minutes.

[mister]

Originally posted by Chris Schreiber
I have a backup script I run through cron at off hours to automatically backup: http://161.58.84.213/forum/showthread.php?s=&threadid=4256

For my database (200MB) it takes 3-5 minutes.

Yea, thats the script I run.
Works real well, thanks :)