List:General Discussion« Previous MessageNext Message »
From:Zakai Kinan Date:October 13 2010 8:38pm
Subject:Table locking generally
View as plain text  
I have a problem that I can't understand readily.  I have a database that has a couple of
tables that lock for a recognizable period of time.  The reason I know is because during
the lock the application stops responding totally.  The storage engine is MyIsam.  I have
reread everything about locks in both InnoDB and MyIsam.  I know that I can change to
InnoDB and that would alleviate the problem, but I am curious as to what the problem is. 
This is a new problem for the application has been running for 4 years.  The server is a
64bit server with 16GB of memory, raid 10, and a quad core CPU.  The size of the database
is 600MB.  The lock occurred while two users were accessing the same table.

Thanks for any insight,


Table locking generallyZakai Kinan13 Oct