accesslog into sql

[Olivier Bonvalet]

You can log throught syslog : 
http://snippets.aktagon.com/snippets/247-Logging-nginx-to-remote-loghost-with-syslog-ng-
And since rsyslog (or syslog-ng) can store logs in DB, you will have 
your logs where you want.

I suppose nginx and/or rsyslog will do buffering, so there will not be 
much overhead.

Note about MySQL : on an "old" P4-Xeon in production connection time 
from a PHP mysql_connect() is about 2ms, throught a 10Mbit/s network. 
But the logger will stay connected to the DB...

Andrius Semionovas a écrit :
> connect to mysql sleep one request approximately 0.069s.
>
> On Wed, 04 Feb 2009 22:11:20 +0200, István Szukács <leccine at gmail.com> 
> wrote:
>
>> ?
>>
>> i have seen nginx serving files 50K req/s on a single node, while an sql
>> server might be able to do 200-300 query/sec or so....
>>
>>
>>
>> On Wed, Feb 4, 2009 at 6:39 PM, Ask Bjørn Hansen <ask at develooper.com> 
>> wrote:
>>
>>>
>>> On Feb 4, 2009, at 8:49, István Szukács wrote:
>>>
>>>  why would you slow down the nginx 1000 times?
>>>>
>>>
>>> Woah - nginx can do 20-30 million requests a second ?!
>>>
>>>
>>>  - ask
>>>
>>> -- 
>>> http://develooper.com/ - http://askask.com/
>>>
>>>
>>>
>>>
>>
>>
>
>
>