[Labs-l] MySQL timeout

[Sean Pringle]

On Thu, Sep 4, 2014 at 1:05 AM, Magnus Manske <magnusmanske at googlemail.com>
wrote:

> I keep getting timeout errors on MySQL:
>
> [Lock wait timeout exceeded; try restarting transaction]
>

Is there any pattern? Time of day, specific query (I know you're chasing
this), certain wikis or tables?


> I'm trying to find the exact query; in the meantime, how can I avoid this?
> As in, tell MySQL not to time out.
>

Lock timeout is storage engine dependent, hence asking about the affected
tables.

The default lock timeout for InnoDB and TokuDB tables on labsdb is 50
seconds. A client may set either innodb_lock_wait_timeout (seconds) or
tokudb_lock_timeout (milliseconds) to a custom value for the session.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20140905/343bc62c/attachment.html>