Hosting Provided By

Re: Can anyone help me with a "Lock wait timeout exceeded" problem?

From: Stewart Smith <stewart(at)mysql.com>
Date: Thu Aug 16 2007 - 21:54:38 EDT

On Thu, 2007-07-19 at 18:15 -0700, Bond Masuda wrote:
> The cluster has been working great for a good 8 months until about 2 months
> ago, our application started seeing "Lock wait timeout exceeded" errors and
> the SQL would fail. These were nightly data imports, so lots of INSERT and
> UPDATE queries.

How long (time) are the txns running for? touching same rows? how many in parallel?

-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@sip.us.mysql.com
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

application/pgp-signature attachment: This is a digitally signed message part

Received on Thu Aug 16 21:55:02 2007

This message: [ Message body ]
Next message: Stewart Smith: "Re: Lock wait timeout exceeded"
Previous message: Stewart Smith: "Re: MySQL Cluster performance question"
In reply to: Bond Masuda: "Can anyone help me with a "Lock wait timeout exceeded" problem?"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:15:01 EDT