13 messages in ru.sysoev.nginxRe: accesslog into sql
FromSent OnAttachments
Zoltan HERPAIFeb 4, 2009 7:41 am 
István SzukácsFeb 4, 2009 8:49 am 
Jim OhlsteinFeb 4, 2009 9:13 am 
Zoltan HERPAIFeb 4, 2009 9:16 am 
Ask Bjørn HansenFeb 4, 2009 10:39 am 
Matt LewandowskyFeb 4, 2009 11:10 am 
István SzukácsFeb 4, 2009 12:10 pm 
István SzukácsFeb 4, 2009 12:23 pm 
Andrius SemionovasFeb 4, 2009 1:20 pm 
Dave BaileyFeb 4, 2009 2:00 pm 
Olivier BonvaletFeb 4, 2009 2:03 pm 
Nginx LovaFeb 4, 2009 2:20 pm 
Ask Bjørn HansenFeb 4, 2009 2:37 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: accesslog into sqlActions...
From:Matt Lewandowsky (ma@nepheliad.net)
Date:Feb 4, 2009 11:10:58 am
List:ru.sysoev.nginx

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

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

--Matt

-------------------------------------------------- From: "Ask Bjørn Hansen" <as@develooper.com> Date: Wednesday, February 04, 2009 10:39 AM To: <ngi@sysoev.ru> 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

-- http://develooper.com/ - http://askask.com/