MySQL MyISAM table locking

sql mysql locking myisam
Abhi picture Abhi · Dec 23, 2009 · Viewed 16.3k times · Source

Does a MySQL MyISAM table gets locked when records are deleted from it?

Answer

OMG Ponies picture OMG Ponies · Dec 23, 2009

MyISAM tables supports table level locking, and yes, a write lock is employed when deleting (or insert & updating) records.

For more info, see Internal Locking Methods

Related questions

MySQL: Transactions vs Locking Tables

I'm a bit confused with transactions vs locking tables to ensure database integrity and make sure a SELECT and UPDATE remain in sync and no other connection interferes with it. I need to: SELECT * FROM table WHERE (...) LIMIT 1 if (condition …

Read More
Optimistic locking in MySQL

I can't find any details on optimistic locking in MySQL. I read that starting a transaction keep updates on two entities synced, however - it doesn't stop two users updating the data at the same time causing a conflict. Apparently …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More