Re: Django SQL Query does not stop

On Tue, Feb 1, 2011 at 3:53 PM, Ivo Brodien <ib@brodien.de> wrote:
> When I am in admin and I access of a certain model, Django calls mysql with an Query which increases mysql CPU load to 99% and it never returns.
>
> If I copy the the SQL Query right into mysql the same thing happens, so it is actually kind of a mysql problem, but since Django created the query, I thought I might get help here.
>
> I did not call any select_related or something.
>
> On my dev machine I am using sqlite and the same query does not cause any trouble and returns within 4 ms.
>
> There are less not more than 5 rows in each table, so database size cannot be a problem.
>
> Any ideas? where to start debugging this?
>
>

In the mysql shell:

EXPLAIN SELECT ...

Cheers

Tom

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.