Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MySQL MyISAM table locking

Tags:

sql

mysql

myisam

locking

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

like image 672
Abhi Avatar asked Dec 23 '09 07:12

Abhi

1 Answers

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

like image 91
OMG Ponies Avatar answered Nov 15 '22 17:11

OMG Ponies
Sign in to Comment

Related questions

Why when I insert a DateTime null I have "0001-01-01" in SQL Server?
SQLite3 query optimization join vs subselect
SQL server Pivot on Multiple Columns
H2 database, insert by selecting results from CSVREAD
How to use parameters with RPostgreSQL (to insert data)
Query to List all hierarchical parents and siblings and their childrens, but not list own childrens
how to connect to PostgreSQL server to query the database names list
Weeks between two dates in Postgres
PostgreSQL Bitmap Heap Scan on index is very slow but Index Only Scan is fast
How to know affected rows in Cassandra(CQL)?
How to hide Caution: Changing any part of an object name could break scripts and stored procedures
MySQL to get previous year record
Jooq dynamically change db's schema in generated query
Two columns condition in different rows in PostgreSQL
Add Nested Key Value to JSONB in Postgres
Conditional SUM on Oracle
What happen in SQL 2005 when it run out of number for an autonumber column?
Does SQL Server CheckSum calculate a CRC? If not how can I get MS SQL to calculate a CRC on an arbitrary varchar column?
How bad is ignoring Oracle DUP_VAL_ON_INDEX exception?
Restoring a Backup to a different Server - User Permissions

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!