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
