table lock
A lock that prevents any other transaction from accessing a table. InnoDB makes considerable effort to make such locks unnecessary, by using techniques such as row locks and consistent reads for processing DML statements and queries. You can create such a lock through SQL using the LOCK TABLE statement; one of the steps in migrating from other database systems or MariaDB storage engines is to remove such statements wherever practical.
See also consistent read.
See also DML.
See also lock.
See also locking.
See also query.
See also row lock.
See also table.
See also transaction.