Re: Deadlock found when trying to get lock

[Mathieu Forget]

You could try to increase the value of the innodb_lock_wait_timeout variable

Too see the value :
show variables like '%innodb_lock_wait_timeout%';

To change it :
in your /etc/my.cnf file add this
set-variable = innodb_lock_wait_timeou = [NEW_VALUE]
Restart the MySql server

Matthew,
www.Bargain-Predator.com



Edited 1 time(s). Last edit at 10/01/2008 01:18PM by Mathieu Forget.