is accountid a number or varchar column On Sat, May 12, 2012 at 7:38 PM, Andrés Tello <mr.crip...@gmail.com> wrote:
> 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... >
