Apache2, Logging to MySQL Request for Insight :)

[Darryl Clarke]

Hi,

I've recently setup Apache2 to log to mysql using a pipe, and it
appears to work ok.

Basically what I've done is made a LogFormat with an insert statement,
and then a CustomLog "|/usr/bin/mysql -h [server] [dbname]"

It works well, and appears to not lose log records when mysql is
stopped (i don't plan on it being stopped but I checked anyways)

My concern is with behaviour and caveats. Before I carry on and take
it all the way, I'd like to know if anybody has any insight on any
issues that may arise using this type of method.

Thanks,
--
~ Darryl  ~ smartssa at gmail.com
~ http://darrylclarke.com