Re: InnoDB table locking error
Posted by:
Rick James
Date: March 09, 2013 09:21AM
Instead of tackling the symptom, let's tackle the cause.
What value of autocommit are you using? Do you use BEGIN...COMMIT?
SHOW VARIABLES LIKE 'innodb%';
SHOW GLOBAL STATUS LIKE 'Innodb%';
Let's see the queries that are involved in the lock situation.
Please include SHOW CREATE TABLE and EXPLAIN for any SELECTs.
Subject
Views
Written By
Posted
4465
March 08, 2013 11:14AM
Re: InnoDB table locking error
1694
March 09, 2013 09:21AM
1362
March 11, 2013 12:11PM
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.