Shulou(Shulou.com)06/01 Report--

Editor to share with you what are the differences between mysql table locks and row locks. I hope you will gain a lot after reading this article. Let's discuss it together.

Mysql has many of these locking mechanisms, such as row locks, table locks, read locks, write locks, and so on, which are locked before an operation is done; these locks are called Pessimistic Lock.

Lock is a mechanism by which a computer coordinates multiple processes or threads to access a resource concurrently. In the database, in addition to the contention of traditional computing resources (such as CPU, RAM, Imax O, etc.), data is also a kind of resource shared by many users. How to ensure the consistency and effectiveness of data concurrent access is a problem that must be solved in all databases, and lock conflicts are also an important factor affecting the performance of database concurrent access. From this point of view, locks are particularly important and more complex for databases.

The difference between table lock and row lock in mysql

Row lock

Features: small lock granularity, low probability of lock conflict, strong ability to deal with concurrency, high overhead, slow locking, deadlock

Locking method: automatic locking. For UPDATE, DELETE, and INSERT statements, InnoDB automatically adds exclusive locks to the dataset involved; for normal SELECT statements, InnoDB does not add any locks.

Watch lock

Features: low overhead, fast locking, no deadlock, large lock granularity, high probability of lock conflict, low performance under high concurrency

Locking method: automatic locking. Query operation (SELECT) automatically adds read locks to all tables involved, and update operations (UPDATE, DELETE, INSERT) automatically add write locks to the tables involved.

After reading this article, I believe you have a certain understanding of the differences between mysql table locks and row locks. If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.