From: Ben Clewett
Date: December 11 2006 2:15pm
Subject: MySql locking during BLOB upload
List-Archive: http://lists.mysql.com/mysql/203858
Message-Id: <457D680A.5070000@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear MySql,

I am finding my version 5.1.6 and 4.1.9 sometimes locking up during the 
passing of BLOB data.  Size between 25 and 250 KB.

If I repeat the transaction it will pass.

Statistically it occurs about 1 in 30 INSERTs or UPDATEs or a blob.

Non-Blob data to the same table will never lock.

mysqladmin will show an entry 'Sleep'.

The only ever solution is to kill my connection and try again.

There is no one table, no one server and no one version of MySql which 
does this, and the problem is not repeatable.

Has anybody experienced this and maybe knows what I can do?

Regards,

Ben