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. --=| +———————————————————————————————————————————————————————————————————+
