Skip navigation links

User Comments

Posted by DBA Lead on September 23 2010 2:53pm[Delete] [Edit]

I think an advisory lock should also work in this case.

Posted by Devang Modi on August 30 2011 4:52am[Delete] [Edit]

Combine queries for Insert and Select always obeys Innodb locking rules
if one of the source table is based on Innodb engine.
It is also possible that the INSERT activity applicable to TEMPORARY
table which is not InnoDB engine. It is also possible that in SELECT
section with INNODB, some other TEMPORARY Tables are used.
Devang Modi