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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
