[WNYLUG-Users] mysqldump question

Chris Hawkins chawkins at bplinux.com
Fri Aug 12 08:56:30 EDT 2011


One possibility is that the database table(s) are using the ARCHIVE storage engine. This can compress the (usually text) data up to 10 to 1 in the tables. 

Chris


----- Original Message -----
> I know this is a bit off topic but I'm hoping someone might have some
> insight on this.
> 
> I'm performing a mysqldump of a database which on disk is about 2G,
> nothing special. When I perform a mysqldump of this same database the
> dump file swells to over 23G is size! I know there are triggers and
> stored proc's associated with this db, and what they do is anyone's
> guess, and I'm thinking they are what's causing this but I really
> don't know. I've never encountered this before.
> 
> Any thoughts
> 
> Thanks!
> 
> --
> Later,
> Darin
> 
> _______________________________________________
> Users mailing list
> Users at wnylug.org
> http://wnylug.org/mailman/listinfo/users_wnylug.org



More information about the Users mailing list