From: Ananda Kumar Date: May 14 2012 1:18pm Subject: Re: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this List-Archive: http://lists.mysql.com/mysql/227417 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf3040e36c685cbe04bffeedaa --20cf3040e36c685cbe04bffeedaa Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable is accountid a number or varchar column On Sat, May 12, 2012 at 7:38 PM, Andr=E9s Tello wrot= e: > While doning a batch process... > > show full processlist show: > > | 544 | prod | 90.0.0.51:51262 | tmz2012 | Query | 6 | > end | update `account` set `balance`=3D 0.00 + > '-4000' where accountid=3D'2583092' > > No other process, lo locking no nothing... > > so you take this same query... run it isolated, and the mu....fu... is > just...f.... fast!!!!! > > > update `account` set `balance`=3D 0.00 + '-4000' where accountid=3D'25830= 92' > Query OK, 0 rows affected (0.00 sec) > Rows matched: 1 Changed: 0 Warnings: 0 > > > ARRRG! I have seen this type of query take as long as 100+ seconds.. and= I > don't have a F*** clue... > --20cf3040e36c685cbe04bffeedaa--