From: Andrés Tello Date: May 12 2012 2:08pm Subject: 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/227406 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=14dae934093516f60f04bfd7639f --14dae934093516f60f04bfd7639f Content-Type: text/plain; charset=ISO-8859-1 While doning a batch process... show full processlist show: | 544 | prod | 90.0.0.51:51262 | tmz2012 | Query | 6 | end | update `account` set `balance`= 0.00 + '-4000' where accountid='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`= 0.00 + '-4000' where accountid='2583092' 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... --14dae934093516f60f04bfd7639f--