Welcome! Log In Create A New Profile

Re: piped logging from Nginx to MySQL

Forum List Message List New Topic Print View

Peter Vereshagin

December 18, 2009 06:28AM

Concrete jungle, oh nginx-ru, you've got to do your best...
2009/12/18 01:29:33 -0500 vromanov <nginx-forum@nginx.us> => To nginx-ru@nginx.org :
v> Совсем циничное решение - использовать timesten для записи логов. У меня он вполне тянет 45000 инсертов в секунду. и на диск может вообще ничего не писать т.к вся база в памяти.

ну? а in-memory таблицы от mysql точно не потянут это? и сколько расход памяти на такое счастье? примерно думаю 1K строчка * 45K * 60 сек ~ 2.5GB. + на ротацию-агрегацию

73! Peter pgp: A0E26627 (4A42 6841 2871 5EA7 52AB 12F8 0CE1 4AAC A0E2 6627)
--
http://vereshagin.org

_______________________________________________
nginx-ru mailing list
nginx-ru@nginx.org
http://nginx.org/mailman/listinfo/nginx-ru

Reply Quote

RSS

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

Record Number of Users: 8 on April 13, 2023

Record Number of Guests: 500 on July 15, 2024