List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 28 2007 4:31am
Subject:Re: Table compression with write (append) support
View as plain text  
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
Thread
Table compression with write (append) supportYves Goergen27 May
  • Re: Table compression with write (append) supportDan Nelson28 May
    • Re: Table compression with write (append) supportKevin Hunter28 May
      • Re: Table compression with write (append) supportYves Goergen28 May
        • Re: Table compression with write (append) supportBaron Schwartz28 May
        • Re: Table compression with write (append) supportKevin Hunter28 May
          • Re: Table compression with write (append) supportYves Goergen28 May