accesslog into sql

Matt Lewandowsky matt at
Wed Feb 4 22:11:21 MSK 2009

You're doing 20-30 thousand requests per second with a MySQL-backed access 
log? ;)

While I think István exaggerated a slight bit, but I can't imagine that it 
would be a highly-performant solution. While IIS supports logging to a SQL 
server (the go-to web server if you're looking to compare server X against 
something that has every "useless" feature... ;) ), even Microsoft says that 
the sites that would probably find the capability most useful shouldn't use 

<From Microsoft KB article 245243>
Microsoft does not recommend IIS logging to a SQL Server table if the IIS 
computer is a busy server. Sending logging data to a SQL Server database for 
a busy Web site consumes system resources.


From: "Ask Bjørn Hansen" <ask at>
Date: Wednesday, February 04, 2009 10:39 AM
To: <nginx at>
Subject: Re: accesslog into sql

> 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
> -- 
> -


More information about the nginx mailing list