MySQL Forums
Forum List  »  InnoDB

Re: Exclusive lock
Posted by: Peter Brawley
Date: November 11, 2016 04:59AM

> I have a lot of transaction in the same time. These based on an innodb table,
> that has a few triggers. These triggers read and write other innodb
> and myisam tables.

What about the table on which the problem lock occurred? Is it MyISAM or InnoDB? And let's see the transaction.

You'll need to review https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html#innodb-shared-exclusive-locks

Options: ReplyQuote


Subject
Views
Written By
Posted
774
November 11, 2016 02:39AM
Re: Exclusive lock
360
November 11, 2016 04:59AM
348
December 01, 2016 07:56AM
321
December 01, 2016 10:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.