From: Andrés Tello
Date: May 11 2012 7:40pm
Subject: Re: Deadlock due lockwait. How can I tell mysql to wait longer?
List-Archive: http://lists.mysql.com/mysql/227405
Message-Id: <CAErsY8uD1P3WaM7sffFeCEf1BEL1OxrC7D4tE_8mzou_HatrRw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=14dae9340f29ec6d1e04bfc7e941

--14dae9340f29ec6d1e04bfc7e941
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

humm, I see.. and if is encapusulated with it's own begin-commit inside a
bigger transacion, only that small part get rolled back...

If I get this straigth...


On Fri, May 11, 2012 at 2:32 PM, Baron Schwartz <baron@stripped> wrote:

> Andres,
>
> On Fri, May 11, 2012 at 1:48 PM, Andr=E9s Tello <mr.criptos@stripped>
> wrote:
> > Ok, so I had a deadlock...
> >
> > But then, why a deadlock doesn't rollback all the transaccion?
>
> Because it can be resolved by rolling back just one of them. Why
> destroy ALL the work people are trying to accomplish, if you could
> just throw away some of it?
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

--14dae9340f29ec6d1e04bfc7e941--