Welcome! Log In Create A New Profile

Advanced

Re: piped logging from Nginx to MySQL

Ihalainen Nickolay
December 16, 2009 03:32AM
Как мне казалось такие штуки делают для фильтрации логов, например для
самопальной IDS.
когда проект нагружен или идёт dos атака или просто несколько человек
пытается "скачать" сайт,
за 10 минут набегает несколько гигабайт, с другой стороны в 200
мегабайт памяти легко поместятся 10тыс самых подозрительных клиентов и
их действий.

Вариант с tail конешно хорош, но зачем эти бешенные гигабайты писать на диск?
gzip поможет с этой проблемой, однако, он будет дважды использовать
cpu: для записи на диск и для чтения с него.

2009/12/16 Alexandre Kalendarev <akalend@mail.ru>:
>
> -----Original Message-----
> From: Roman Yankovsky <roman.yankovsky@gmail.com>
> To: nginx-ru@sysoev.ru
> Date: Wed, 16 Dec 2009 04:17:25 +0300
> Subject: piped logging from Nginx to MySQL
>
>> Здравствуйте,
>> Можно ли сабжевый механизм применить в nginx?
>>
>> В апаче оно работает вот так:
>> LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\""
>> combined
>> CustomLog "|/usr/local/bin/logtomysql" combined
>> http://logtomysql.sourceforge.net/readme.html
>> _______________________________________________
>> nginx-ru mailing list
>> nginx-ru@nginx.org
>> http://nginx.org/mailman/listinfo/nginx-ru
>>
> на мой взгляд, лучше так не делать, а по крону запускать парсилку логов, которая все это кладет в БД. Делов-то часа на два.
>
> _______________________________________________
> nginx-ru mailing list
> nginx-ru@nginx.org
> http://nginx.org/mailman/listinfo/nginx-ru
>
_______________________________________________
nginx-ru mailing list
nginx-ru@nginx.org
http://nginx.org/mailman/listinfo/nginx-ru
Subject Author Posted

piped logging from Nginx to MySQL

Roman Yankovsky December 15, 2009 08:18PM

Re: piped logging from Nginx to MySQL

Peter Leonov December 15, 2009 10:26PM

Re: piped logging from Nginx to MySQL

akalend December 16, 2009 02:20AM

Re: piped logging from Nginx to MySQL

Ihalainen Nickolay December 16, 2009 03:32AM

Re: piped logging from Nginx to MySQL

Anton Yuzhaninov December 16, 2009 04:22AM

Re: piped logging from Nginx to MySQL

Ihalainen Nickolay December 16, 2009 04:40AM

Re: piped logging from Nginx to MySQL

Alex Vorona December 16, 2009 04:44AM

Re: piped logging from Nginx to MySQL

Gerasimenko Konstantin December 16, 2009 04:48AM

Re: piped logging from Nginx to MySQL

Alex Vorona December 16, 2009 04:50AM

Re: piped logging from Nginx to MySQL

Igor Sysoev December 16, 2009 05:10AM

Re: piped logging from Nginx to MySQL

Gerasimenko Konstantin December 16, 2009 05:22AM

Re: piped logging from Nginx to MySQL

Igor Sysoev December 16, 2009 05:30AM

Re: piped logging from Nginx to MySQL

Gerasimenko Konstantin December 16, 2009 06:00AM

Re: piped logging from Nginx to MySQL

Руслан Шарипов December 16, 2009 06:04AM

Re: piped logging from Nginx to MySQL

Vasiliy G Tolstov December 16, 2009 06:06AM

Re: piped logging from Nginx to MySQL

Vasiliy G Tolstov December 16, 2009 06:22AM

Re: piped logging from Nginx to MySQL

Igor Sysoev December 16, 2009 06:46AM

Re: piped logging from Nginx to MySQL

Vasiliy G Tolstov December 16, 2009 08:12AM

Re: piped logging from Nginx to MySQL

Eugene Mychlo December 17, 2009 03:22AM

Re: piped logging from Nginx to MySQL

Olexander Shtepa December 17, 2009 03:56AM

Re: piped logging from Nginx to MySQL

Vasiliy G Tolstov December 17, 2009 04:00AM

Re: piped logging from Nginx to MySQL

Eugene Mychlo December 17, 2009 04:20AM

Re: piped logging from Nginx to MySQL

Igor Sysoev December 17, 2009 04:56AM

Re: piped logging from Nginx to MySQL

Igor Sysoev December 17, 2009 05:28AM

Re: piped logging from Nginx to MySQL

Eugene Mychlo December 17, 2009 05:40AM

Re: piped logging from Nginx to MySQL

Anton Yuzhaninov December 16, 2009 06:50AM

Re: piped logging from Nginx to MySQL

Igor Sysoev December 16, 2009 06:54AM

Re[2]: piped logging from Nginx to MySQL

akalend December 16, 2009 06:14AM

Re: piped logging from Nginx to MySQL

vromanov December 18, 2009 01:29AM

Re: piped logging from Nginx to MySQL

Sergey Averyanov December 18, 2009 03:04AM

Re: piped logging from Nginx to MySQL

Peter Vereshagin December 18, 2009 06:28AM

Re: piped logging from Nginx to MySQL

Andrew Sitnikov December 18, 2009 07:00AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 283
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready