[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: can apache log to MySQL ?



At 10:10 AM 5/12/00 +1000, Craig Sanders wrote:
>i don't see how. apache just sends the log data out to the pipe, it
>doesn't wait for the pipe program to commit the record to the database.
>as far as delaying apache goes, it's probably less of a delay than
>writing it to a text file.

I see what you're saying.  But a slow or messed up pipe can lead to lost log
data.  This is a situation where MySQL being faster would make it worth it.
I think it would be safer to use that perl thingy to just write the data to
a table as fast as possible and then let the database touch it only after
the log file is closed.  Hell, it might even be better to just set up a
customlog that writes in table format.  Lost data is bad. :)


+-------------------------------------------------------------------+
|        -=I T ' S  P R I N C I P L E  T H A T  C O U N T S=-       |
|=-                  -=ALAN KEYES FOR PRESIDENT=-                 -=|
| Balanced Budgets     Personal Freedoms     Morality     Lower Tax |
|=--                  http://www.Keyes2000.com.                  --=|
+???????????????????????????????????????????????????????????????????+



Reply to: