On Tue, Feb 23, 2016 at 8:59 PM, Web Architect <[email protected]> wrote:
> Hi, > > We have an ecommerce platform based on Django. We are using uwsgi to run > the app. The issue the CPU usage is hitting the roof (sometimes going > beyond 100%) for some scenarios. I would like to debug the platform on > Production to see where the CPU consumption is happening. We have used > Cache all over the place (including templates) as well - hence, the DB > queries would be quite limited. > Have you validated that your cache is actually being used, and not just populated? I've seen that before. > I would refrain from using Django-debug toolbar as it slows down the > platform further, increases the CPU usage and also need to turn the DEBUG > on. Is there any other tool or way to debug the platform? Would appreciate > any recommendations/suggestions. > Have you looked into profiling the code or adding logging statements throughout your code to determine when/where particular segments are being run? I would definitely start with logging. I'm assuming you have suspicions on where your pain points might be: https://docs.djangoproject.com/en/1.9/topics/logging/ I would put them in places that may be part of large loops (in terms of number of objects queried or depth of relationships traversed), or sprinkled within complex views. You have to start narrowing down which page/pages are causing your angst. Also, does the Django ORM increase the CPU usage? Does it block the CPU? > Would appreciate if anyone could throw some light on this. > I'm not sure about blocking, but if deployed correctly, the ORM should have a negligible (and acceptable) hit to the CPU in most cases, if you notice one at all. I've seen spikes from bad M2M relationships where prefetch_related() was needed (>200 queries down to 3 with prefetch_related, and ~1-2s total response down to <80ms if I recall correctly). The most common case I run into is as part of nested {% for %} loops within a template that dig down through relationships. I would also consider increasing the logging levels of your cache and DB to see if you are getting repetitive queries. The ORM does cause those from time to time since it has non-intuitive behavior in some edge cases. You can try that during low activity periods to keep the extra logging from overwhelming the system. Sometimes you can still catch the issue with a single end-user for something like repetitive/multiple queries, and are actually much easier to diagnose on a low usage server. Do you have any other jobs that run against the system (session cleanup, expired inventory removal, mass mailing, etc.)? Would it be possible for those to be the culprit? Have you figured out any reproducible trigger? -James -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2Be%2BciW9v%2BK-mbu_%3DeeLT5gT59AxkNrz9Xb4uKO6iBsgoAPqsA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
