Re: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this

[Ananda Kumar]

is accountid a number or varchar column

On Sat, May 12, 2012 at 7:38 PM, Andrés Tello <mr.criptos@stripped> 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...
>