Lock record

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

Lock record

Post by cybsistemas » Fri 15 Jul 2011 14:52

If I try to block a record that already has been blocked the error message takes long.

How do we decrease that time?

AndreyZ

Post by AndreyZ » Mon 18 Jul 2011 11:09

Hello,

You can decrease the value of the innodb_lock_wait_timeout server variable. For more information, please take a look at this article: http://dev.mysql.com/doc/refman/5.1/en/ ... it_timeout

cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

Post by cybsistemas » Mon 18 Jul 2011 13:28

Thanks

Post Reply