> -----Original Message-----
> From: Madscientist [mailto:[EMAIL PROTECTED]

> We use this mechanism, but we do our mysqldumps from a slave 
> so the time doesn't matter.

Excellent idea.

> Interesting side effect: A GZIP of the data files is _huge_. 
> A GZIP of the 
> mysqldump is _tiny_. For our data it seems there is a lot of 
> repetition.

I think the difference is probably that the mysqldump file doesn't contain
any index data.  On some of our tables the index file is bigger than the
actual data file.  And yeah, the dump files (and update logs!) do compress
really well.  The fact that they're text and contain a lot of repeated
commands means they pack down quite small.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to