Re: Django/uWSGI/nginx under load

I'm unsure what you mean - do you mean "are we executing raw SQL queries and a Python db api, or using Django's ORM?" If so, usually the latter but this is definitely not a problem of poorly written queries, we've profiled them. - Andy On Saturday, 20 February 2021 at 17:44:45 UTC jmccla...@

Re: Django/uWSGI/nginx under load

Thanks for this. 27k file descriptors out of about 370k allowed. I presume that means this isn't a problem? (We run a lot of different virtual hosts on this box, each with a few Django processes) - Andy On Saturday, 20 February 2021 at 16:15:12 UTC mob...@aldian.net wrote: > Check the number

Re: Django/uWSGI/nginx under load

are you using django directly to run the queries or are you querying the db. I had a similar problem a while back with a project and the load was resolved by letting python do the work. On Sat, 20 Feb 2021 at 15:23, Andy Robinson wrote: > Hi all, > > We're maintaining an application that is hi

Re: Django/uWSGI/nginx under load

Check the number of open file descriptor when you experienced the slow response. On Sat, Feb 20, 2021 at 10:23 PM Andy Robinson wrote: > Hi all, > > We're maintaining an application that is hitting scaling problems. It > helps run grass-roots sporting events all over Europe, so Saturdays can >

Django/uWSGI/nginx under load

Hi all, We're maintaining an application that is hitting scaling problems. It helps run grass-roots sporting events all over Europe, so Saturdays can produce large and unpredictable loads, with both logged-in users and public viewers. Despite a powerful server seemingly being lightly loaded (