kpoxa
April 05, 2016 06:42AM
Отдача с базы это
ос читает с диска в буфер, буфер копируется в процесс mysql, mysql
отправляет это в сеть, т.е. копирование в ОС, потом в сеть, потом в скрипт,
который далее по сети отдает данные в nginx, т.е. копирование в буфер, в
сетевой стэк, потом опять в буфер, потом в nginx который отдаёт данные по
сети клиенту ( не буду расписывать).
Отдача с диска это
ос читает с диска в буфер и отдает по сети клиенту, т.к. используется
sendfile и копирования в память nginx не происходит.
по моему профит очевиден.
с учетом того, что видео это не мелкие картинки, то оверхед на чтение
файловой системы намного меньше в % соотношении к операциям чтения данных.

вт, 5 апр. 2016 г. в 11:50, Daniel Podolsky <onokonem@gmail.com>:

> > может я что то пропустил, но какой смысл хранить данные в реляционной БД,
> > если вы не будете использовать при этом SQL?
> ну какой-то язык/api использовать придется.
>
> а ответ на вопрос "какой смысл" прямо вытекает из ответ на "в чем разница"
> _______________________________________________
> nginx-ru mailing list
> nginx-ru@nginx.org
> http://mailman.nginx.org/mailman/listinfo/nginx-ru
_______________________________________________
nginx-ru mailing list
nginx-ru@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx-ru
Subject Author Posted

reverse proxy + mysql + video

tepkuh March 31, 2016 11:45AM

Re: reverse proxy + mysql + video

sejo412 March 31, 2016 07:12PM

Re: reverse proxy + mysql + video

Evgeniy Berdnikov April 01, 2016 05:08AM

Re: reverse proxy + mysql + video

Роман Москвитин April 01, 2016 05:56AM

Re: reverse proxy + mysql + video

tepkuh April 01, 2016 01:47PM

Re: reverse proxy + mysql + video

Роман Москвитин April 01, 2016 04:36PM

Re: reverse proxy + mysql + video

Evgeniy Berdnikov April 01, 2016 05:06PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 05:21AM

Re: reverse proxy + mysql + video

Konstantin Tokarev April 02, 2016 05:50AM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 12:52PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 05:37AM

Re: reverse proxy + mysql + video

Роман Москвитин April 02, 2016 05:52AM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 11:25AM

Re: reverse proxy + mysql + video

mva April 02, 2016 11:34AM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 12:04PM

Re: reverse proxy + mysql + video

tepkuh April 01, 2016 01:52PM

Re: reverse proxy + mysql + video

mva April 01, 2016 02:46PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 05:16AM

Re: reverse proxy + mysql + video

mva April 02, 2016 07:00AM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 11:58AM

Re: reverse proxy + mysql + video

Oleksandr V. Typlyns'kyi April 02, 2016 01:54PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 02, 2016 02:14PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 02:58PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 02, 2016 03:02PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 03:13PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 02, 2016 03:22PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 03:34PM

Re: reverse proxy + mysql + video

Lystopad Aleksandr April 02, 2016 03:38PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 03:43PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 03, 2016 01:34AM

Re: reverse proxy + mysql + video

Андрей Василишин April 06, 2016 05:18AM

Re: reverse proxy + mysql + video

kpoxa April 06, 2016 06:12AM

Re: reverse proxy + mysql + video

mva April 02, 2016 03:26PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 02, 2016 03:28PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 02, 2016 03:06PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 02:42PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 02, 2016 02:54PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 03:04PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 02, 2016 03:12PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 03:27PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 03, 2016 01:32AM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 01, 2016 03:34PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 05:20AM

Re: reverse proxy + mysql + video

Андрей Василишин April 02, 2016 04:54PM

Re: reverse proxy + mysql + video

mva April 02, 2016 05:10PM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 07:59PM

Re: reverse proxy + mysql + video

Vasiliy P. Melnik April 03, 2016 01:38AM

Re: reverse proxy + mysql + video

tepkuh April 02, 2016 07:44PM

Re: reverse proxy + mysql + video

Андрей Василишин April 03, 2016 11:24AM

Re: reverse proxy + mysql + video

Nikita Stupin April 04, 2016 05:36PM

Re: reverse proxy + mysql + video

Daniel Podolsky April 04, 2016 05:56PM

Re: reverse proxy + mysql + video

Андрей Василишин April 04, 2016 06:34PM

Re: reverse proxy + mysql + video

Daniel Podolsky April 04, 2016 07:00PM

Re: reverse proxy + mysql + video

Oleksandr V. Typlyns'kyi April 04, 2016 07:32PM

Re: reverse proxy + mysql + video

Daniel Podolsky April 04, 2016 07:52PM

Re: reverse proxy + mysql + video

Oleksandr V. Typlyns'kyi April 04, 2016 08:56PM

Re: reverse proxy + mysql + video

Daniel Podolsky April 05, 2016 02:40AM

Re: reverse proxy + mysql + video

ALex_hha April 05, 2016 03:34AM

Re: reverse proxy + mysql + video

Dmitry Morozovsky April 05, 2016 04:44AM

Re: reverse proxy + mysql + video

Daniel Podolsky April 05, 2016 04:52AM

Re: reverse proxy + mysql + video

kpoxa April 05, 2016 06:42AM

Re: reverse proxy + mysql + video

Daniel Podolsky April 05, 2016 07:22AM

Re: reverse proxy + mysql + video

Oleksandr V. Typlyns'kyi April 05, 2016 05:18AM

Re: reverse proxy + mysql + video

Daniel Podolsky April 05, 2016 05:20AM

Re: reverse proxy + mysql + video

Daniel Podolsky April 05, 2016 05:22AM

Re: reverse proxy + mysql + video

Oleksandr V. Typlyns'kyi April 05, 2016 07:30AM

Re: reverse proxy + mysql + video

Daniel Podolsky April 05, 2016 08:12AM

Re: reverse proxy + mysql + video

Oleksandr V. Typlyns'kyi April 05, 2016 04:24PM

Re: reverse proxy + mysql + video

Daniel Podolsky April 05, 2016 04:40PM

Re: reverse proxy + mysql + video

Vladimir Sopot April 05, 2016 05:46PM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 104
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 500 on July 15, 2024
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready