will create temprory tables from select acquire lock

hello grp !

while running one application sometime i got these errors

Status : Failure - Deadlock found when trying to get lock;
try restarting transaction
Info : CREATE TEMPORARY TABLE TBL_XXXXX_TEMP AS SELECT
... some stuff


select statement contains INNODB tables . what does it mean ?
parwal.sandeep [ Do, 13 Juli 2006 17:51 ] [ ID #1390036 ]
Datenbanken » mailing.database.mysql » will create temprory tables from select acquire lock

Vorheriges Thema: How to size a MySQL server
Nächstes Thema: Insert copied records using MS Access