aging method

And on the topic of aging, what are some strategies for this?

When storing 'combined' to a file with CustomLog, I run a script that
(daily, weekly or monthly depending on site traffic) renames the log
file using standard syslog naming and compresses it with bzip2.  With
this much compression, I don't have a problem storing scads of old data
(in case the user decides to switch log analysis programs), but I will
obviously not be able to bzip2 mysql table records.

Is the solution simply to buy a bigger hard disk, or have folks
developed strategies for moving less-frequently-used to elsewhere?

(I could always just take old data, save it to a file in 'combined'
format and bzip2 it, but ... well, maybe that's the solution.)

-- 
  Paul Chvostek                                             <[email protected]>
  Operations / Abuse / Whatever
  it.canada, hosting and development                   http://www.it.ca/

__________________________________________________________________
Reminder: to unsubscribe, send email to <[email protected]>
with the words "unsubscribe mod_log_sql" in the body (w/o quotes).
The module homepage is http://www.grubbybaby.com/mod_log_sql/