Re: [squid-users] access.log redirection to mysql

On Fri, 17 Sep 2004, Muthukumar wrote:

> what will happen if u make squid to enter the access logs directly in a my-sql
> database instead of writting it in a flat file. Will it decrease the
> performance ??

Probably, but as usual it depends...

> How can we directly write the access logs on my-sql database there.?

There has been patches floating around. Try searching for it.

But the preferred method by the Squid developers is to have Squid log to a
flat file and then dump this file in real time into mysql. This gives you
the best of both worlds as Squid is not encoumbered with the mysql
logging, mysql gets the log data immediately and you do not need to save
the logs for very long.

Regards
Henrik
Received on Fri Sep 17 2004 - 15:16:06 MDT