List:General Discussion« Previous MessageNext Message »
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
View as plain text  
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...
>

Thread
Mysql is toying me... why sometimes an insert or update can be slow!?I getting bald cuz thisAndrés Tello12 May
  • RE: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz thisSteven Staples14 May
  • Re: Mysql is toying me... why sometimes an insert or update can beslow!? I getting bald cuz thisAnanda Kumar14 May
    • Re: Mysql is toying me... why sometimes an insert or update can beslow!? I getting bald cuz thisAndrés Tello14 May
      • Re: Mysql is toying me... why sometimes an insert or update can beslow!? I getting bald cuz thisAnanda Kumar14 May
        • Re: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz thisJohan De Meersman14 May
          • Re: Mysql is toying me... why sometimes an insert or update can beslow!? I getting bald cuz thisAnanda Kumar14 May