From: Dan Nelson
Date: May 28 2007 4:31am
Subject: Re: Table compression with write (append) support
List-Archive: http://lists.mysql.com/mysql/207039
Message-Id: <20070528043138.GM98411@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 27), Yves Goergen said:
> I'm thinking about using a MySQL table to store an Apache access log
> and do statistics on it. Currently all access log files are stored as
> files and compressed by day. Older log files are compressed by month,
> with bzip2. This gives a very good compression ratio, since there's a
> lot of repetition in those files. If I store all that in a regular
> table, it would be several gigabytes large. So I'm looking for a way
> to compress the database table but still be able to append new rows.
> As the nature of a log file, it is not required to alter previous
> data. It could only be useful to delete older rows. Do you know
> something for that?

You want the ARCHIVE storage engine.

http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html

-- 
	Dan Nelson
	dnelson@stripped