From: Claudio Nanni
Date: October 14 2010 7:16am
Subject: Re: How to kill locked queries
List-Archive: http://lists.mysql.com/mysql/223326
Message-Id: <AANLkTim2HxjiNfScvtjjkdWYPr5tA9z1OCTQ_oxwry4q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001636426a03aafeb004928e7dd2

--001636426a03aafeb004928e7dd2
Content-Type: text/plain; charset=ISO-8859-1

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

--001636426a03aafeb004928e7dd2--