[WNYLUG-Users] mysqldump question
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.
----- 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
> Users mailing list
> Users at wnylug.org
More information about the Users