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

Re: can apache log to MySQL ?



At 07:24 PM 5/13/00 -0500, Nathan E Norman wrote:
>So what happens when you're reading the requests database and Apache
>wants to write more data?  With MySQL, the table is locked and now you
>just lost data.  More often, you want to read data but the writer has
>locked the table.  I'd noticed this before but hadn't really thought
>about the issue.  

That's all solved by a wonderful little tool called savelog.  Your database
proggy should not be allowed to touch the log file until it is closed and
rotated out of production.  Have a cron script using SQL parse the log file
after it has been rotated.


+-------------------------------------------------------------------+
|        -=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: