On Thu, Sep 4, 2014 at 1:05 AM, Magnus Manske <[email protected]> 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.
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
