Hi guys<div><br></div><div>Well thats a update at a field with a where with full primary key fields</div><div><br></div><div>Where with</div><div> (Fields)=(consts) or </div><div> field=const and field=const ...</div><div>
<br></div><div>Work the same way with same time</div><div><br></div><div>----</div><div><br></div><div>Yes thats a bigint field (with int i got same problem) </div><div> the first partition is used for negative values</div>
<div>And others partitions to positive values<br><div>I&#39;m running update only at negative values all others rows (partitions) with positive value only have insert, no updates and no delete</div><div><br></div><div>I&#39;m using the primary key at where clausule in other words i&#39;m using a unique key or a unique index. I&#39;m updating a field without indexes (a field not indexed)</div>
<div><br></div><div>I don&#39;t know why the mariadb stop 5 seconds or more, since it&#39;s a partition with less than 1000 rows and no index field was changed</div><div><br></div><div><br></div><div>Any<span></span> ideas?</div>
<div><br></div><div><br></div><div><br></div><div><br></div><div><br>Em terça-feira, 17 de junho de 2014, James Briggs &lt;<a href="mailto:james.briggs@yahoo.com">james.briggs@yahoo.com</a>&gt; escreveu:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Roberto.<br>
<br>
1) nf is a bigint, so why are you inserting a string value (&#39;-18&#39;)?<br>
2) is there some reason you aren&#39;t using indexes?<br>
3) after you resolve 1 and 2, do repair table.<br>
<br>
Thanks, James.<br>
<br>
--------------------------------------------<br>
On Tue, 6/17/14, Roberto Spadim &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;roberto@spadim.com.br&#39;)">roberto@spadim.com.br</a>&gt; wrote:<br>
<br>
 Subject: [Maria-developers] problem with update and myisam<br>
 To: &quot;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;maria-developers@lists.launchpad.net&#39;)">maria-developers@lists.launchpad.net</a>&quot; &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;maria-developers@lists.launchpad.net&#39;)">maria-developers@lists.launchpad.net</a>&gt;<br>

 Date: Tuesday, June 17, 2014, 1:31 PM<br>
<br>
 hi guys, could anyone<br>
 help me with <a href="https://mariadb.atlassian.net/browse/MDEV-6355" target="_blank">https://mariadb.atlassian.net/browse/MDEV-6355</a><br>
 thanks<br>
<br>
<br>
 --<br>
 Roberto Spadim<br>
<br>
<br>
 -----Inline Attachment Follows-----<br>
<br>
 _______________________________________________<br>
 Mailing list: <a href="https://launchpad.net/~maria-developers" target="_blank">https://launchpad.net/~maria-developers</a><br>
 Post to     : <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;maria-developers@lists.launchpad.net&#39;)">maria-developers@lists.launchpad.net</a><br>
 Unsubscribe : <a href="https://launchpad.net/~maria-developers" target="_blank">https://launchpad.net/~maria-developers</a><br>
 More help   : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
<br>
</blockquote></div></div><br><br>-- <br><div dir="ltr">Roberto Spadim<br>SPAEmpresarial<div>Eng. Automação e Controle</div></div><br>