From: Yves Goergen (nospam.listunclassified.de)
Date: Thu Dec 20 2007 - 16:25:55 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On 20.12.2007 22:46 CE(S)T, Martijn Tonies wrote:
>> Okay, I got that. So a COMMIT statement after disabling autocommit mode
>> and another START TRANSACTION does not finish my transaction. (But then,
>> what does?) Interesting view, I didn't know that. But now all's clear: I
>> won't touch autocommit mode anymore and everything works as expected.
>> Thanks for your help.
>
> A COMMIT _should_ finish your transaction yes.
>
> Are you sure you're executing the COMMIT on the same connection?

Yes, I am. I open up only a single connection in my application, so it
must be that one. Most of the time, further HTTP requests even get back
the same connection again. I can see the sleeping connection on my
application database from phpMyAdmin between the requests, with
reasonable sleep time values.

--
Yves Goergen "LonelyPixel" <nospam.listunclassified.de>
Visit my web laboratory at http://beta.unclassified.de

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]