<div class="gmail_quote"><div class="gmail_quote"><div class="im"><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><table cellspacing="0" cellpadding="0" border="0">
<tbody><tr><td valign="top" style="font:inherit">
<blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px"><div>the linked wiki-page was updated with the information about the query-killer <br>more than 1 year ago. <br><br>Sincerly,<br>
DaB.<span style="font-size:small"> </span></div></blockquote></td></tr></tbody></table></blockquote><div> </div></div><div>On my view the query killer is indeed a very nice function to ballance between toolserver's force shared to user tools and its (toolserver's) stable operation and overall performance. I just thought once it previously worked in a less restricting way, there was a good reason for higher restrictions just introduced.</div>
<div><br></div><div>Let's take an example of killer's behaviour, which is partially could be considered helpfull and partially questionable:</div><div><br></div><div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)">> a MySQL-query of yours was killed because you didn't mark it as SLOW_OK and it have run for 3612 seconds which was longer than allowed.<br>
<br></span></div><div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)">I see this as a very helpfull part, which recommends to think of the query optimization or at least on the magic word.</span></div>
<div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)"><br></span></div><div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)">Next, </span></div>
<div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)"><br></span></div><div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)">> The replication lag at kill-time was 0s.</span></div>
<div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)"><br></span></div><div><font face="arial, sans-serif">and the query itself starts with</font></div>
<div><font face="arial, sans-serif"><br></font></div><div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)">> DELETE l</span></div>
<div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)">> FROM l,<br>> a2cr<br>> WHERE l_to=a2cr_to<br>
</span></div><div><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)"><br></span></div><div><font face="arial, sans-serif">Each table is local to a user database and used exclusively by a single (TRANSACTION ISOLATION LEVEL READ UNCOMMITTED) thread. </font>This query should not cause any other queries wating for its completion, and as far as replag is zero at the execution time it does not cause any toolserver's resource being unavailable or limited in requested capacity to other users.</div>
<div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">Previously the query killer interrupted queries just in case of replag upper some thresold, which is a bit less restrictive condition, but seems not yet the very proper one. </font>It killed all the queries worked for more then allowed and (looked like) did not undertake any smarter analysis on which queries are the most influencing or causing the replag increased.</div>
<div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">I assume once the query killer started looking for replag more regularely it could be in a position to mark queries working for long and not causing more or less stable replag increase as more or less safe and wait longer prior to kill them.</font></div>
<div><font face="arial, sans-serif"><br></font></div><font color="#888888"><div><font face="arial, sans-serif">mashiah</font></div></font></div>
</div><br>