From: Dan Nelson
Date: October 30 2001 6:18pm
Subject: Re: "ROW_FORMAT=compressed" has no effect on db file sizes
List-Archive: http://lists.mysql.com/mysql/89441
Message-Id: <20011030121827.B55278@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 30), Bennett Haselton said:
> I created one table with the command:
> 
> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT NULL);
> 
> and another one with the command:
> 
> CREATE TABLE pet2 (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT NULL) ROW_FORMAT=compressed;

From the manual:

:    `ROW_FORMAT'  Defines how the rows should be stored. Currently
:                  this option only works with MyISAM tables, which
:                  supports the `DYNAMIC' and `FIXED' row formats.
:                  *Note MyISAM table formats::.

:    When you `CREATE' or `ALTER' a table you can for tables that
:    doesn't have `BLOB''s force the table format to `DYNAMIC' or
:    `FIXED' with the `ROW_FORMAT=#' table option.  In the future you
:    will be able to compress/decompress tables by specifying
:    `ROW_FORMAT=compressed | default' to `ALTER TABLE'.  *Note CREATE
:    TABLE::.


-- 
	Dan Nelson
	dnelson@stripped