Re: Re: Buffered Logging?
| From: | Waynn Lue | Date: | Sat, 08 Aug 2009 01:25:35 +0000 |
| Subject: | Re: Re: Buffered Logging? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296448@lists.php.net to get a copy of this message | ||
>
> Hey PHPers,
>>
>> We've been doing sampled logging to the database in our application for
>> awhile, and now I'm hoping eventually to blow that out to a larger scale.
>> I'm worried about the performance implications of logging to our database
>> on
>> ...
>>
>>
> If you are using mysql and MyISAM tables, you can try using "insert DELAYED
> " method.
>
> http://dev.mysql.com/doc/refman/5.1/en/insert-delayed.html
>
> This will bulk all your inserts for writes.
>
Thanks for the suggestions! Those both look great for what I was going to
do. One other thought I had after reading those suggestions, if we're doing
web server logging, we can also parse the logs using webalizer or awstats.
I know apache provides file size and the URL that's being hit, but what if I
want to do custom referral tracking? We append ref=foo to our links to
track where people are coming from, should I look at building my own
solution for that, or do existing tools like awstats suffice for that as
well?