Sorry, I forgot to ask the folowing as well. When considering the amount by which text can be compressed as compared to other data types, would it be better to store numerical values as text or to store them as integer/float values. If the db needs to be compressed and backed up on a bi-weekly basis.
George >>> tc lewis <[EMAIL PROTECTED]> 02/17 2:14 AM >>> would probably be very dependent on the data within the database. if it's a lot of text data, then very compressable, as text typically compresses nicely. if you store a bunch of binary data (images or something), then probably not as much... tar your mysql dir and gzip it, or gzip -9 or bzip2 if you're looking for more compression. test it out. -tcl. On Sun, 17 Feb 2002, George Labuschagne wrote: > Hi list, > > How compressible is a typical MySQL database? Is this more dependent on > the type of columns used i.e. a lot of text columns as opposed to a lot > of columns containing integer values? > > The uncompressed size of the database is in the region of about 800-MB. > Also will it suffice to only compress the specific sub-directory > pertaining to the relevant database below /mysql/ ? > > George > mysql, sql, query > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
