Re: getting Squid logfiles into a database

From: Ian Cooper <>
Date: Tue, 12 Jan 1999 10:17:08 GMT

On Tue, 12 Jan 1999 18:23:51 +1100 (EST), Gavin Cameron wrote:

>It would be helpful, I think it would be, to be able to get your access
>logs put into a database, and I think it could be done in much the same
>way as authentication

Is there a need to have the transactions available in the database
immediately? If not you'd probably be better off syphoning them into
a database at the end of each day using your database's variant of
psql's "copy" command. This gets around the need to do a single
INSERT operation for every cache transaction - something that could,
on a busy cache, lead to the db insertions taking longer than the
logging period.


Senior Research Engineer
Mirror Image Internet
Received on Tue Jan 12 1999 - 03:18:51 MST

This archive was generated by hypermail pre-2.1.9 : Tue Dec 09 2003 - 16:43:59 MST