List:General Discussion« Previous MessageNext Message »
From:monloi perez Date:October 14 2010 7:19am
Subject:Re: How to kill locked queries
View as plain text  
Does this happen if your table is InnoDB?

Thanks all,
Mon



________________________________
From: Claudio Nanni <claudio.nanni@stripped>
To: monloi perez <mlp_folder@stripped>
Cc: mysql mailing list <mysql@stripped>
Sent: Thu, October 14, 2010 3:16:38 PM
Subject: Re: How to kill locked queries

Hi Mon,

Killing locked queries is not the first step in database tuning.
Queries locked for a long time usually depend on slow updates that lock other 
updates or selects,
this happen on MyISAM (or table level locking engines).
If you are really sure you want and can without problems kill the queries you 
can do a simple job to check and kill.
I would rather check why those queries are locked anyway.

Aloha

Claudio



2010/10/14 monloi perez <mlp_folder@stripped>

All,
>
>Is there a mysql configuration to kill queries that have been locked for quite
>some time. If there's none what is an alternative approach to kill these locked
>queries and what is the root cause of it?
>
>Thanks,
>Mon
>
>
>     


-- 
Claudio



      
Thread
How to kill locked queriesmonloi perez14 Oct
  • Re: How to kill locked queriesJohan De Meersman14 Oct
  • Re: How to kill locked queriesClaudio Nanni14 Oct
    • Re: How to kill locked queriesmonloi perez14 Oct
      • Re: How to kill locked queriesJohan De Meersman14 Oct
        • Re: How to kill locked queriesPerrin Harkins14 Oct