Re: Lock wait timeout exceeded

On Thu, 2007-07-26 at 10:57 -0400, Gerard C wrote:
> It seems daily the cluster becomes non responsive. The error I get from the
> php application is "Query failed: Lock wait timeout exceeded; try restarting
> transaction". My setup is 2 servers running the API and the storage node on
> each, and then another server running only the management server. There is a
> Netscaler load balancer in front of the API servers balancing the
> connections.
>
> When the issue occurs it seem there are more connections then queries. I
> would say there are probably about 3 times more connections then queries. As
> far as the traffic goes each server currently does about 100 queries per
> second, but this will go up as we add more databases to the cluster.
>
> Thanks in advance for your help.

provide cluster config, table schema, queries, explain. then can start helping.

-- 
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