SHOW FULL PROCESSLIST; EXPLAIN <query that is taking forever>; On Thu, Oct 14, 2010 at 6:02 PM, Nick Arnett <nick.arn...@gmail.com> wrote: > I am having a problem with locking on MySQL and can't quite figure out > what's causing it. Although I have some scripts that do raw SQL, none of > them are running, I see no other transactions in the process list, yet when > I call save() on one of my objects, the transaction locks, seemingly > forever. Although most of my database tables are InnoDB, the one that I'm > seeing this happen on is MyISAM (because I'm using full-text indexing on > it). So the table is getting locked somehow, but I sure can't see how, when > there is nothing else in the processlist. > mysql> show processlist; > +---------+---------+-----------------+---------------+---------+------+--------+------------------------------------------------------------------------------------------------------+ > | Id | User | Host | db | Command | Time > | State | Info > | > +---------+---------+-----------------+---------------+---------+------+--------+------------------------------------------------------------------------------------------------------+ > | 2755442 | narnett | localhost | narnett_clar2 | Query | 0 | > NULL | show processlist > | > | 2764186 | narnett | localhost:54940 | narnett_clar2 | Query | 547 | > Locked | UPDATE `fm_posting` SET `author_id` = 5860, `posted` = '2009-09-28 > 00:00:00', `body` = 'This is the | > +---------+---------+-----------------+---------------+---------+------+--------+------------------------------------------------------------------------------------------------------+ > Anybody have suggestions for tracking this down? > Nick > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-us...@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. >
-- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
