SQL Locking Granularity
In this sql tutorial we'll walk you through what sql locking granularity is and how to work with sql locks to achieve the best results. All examples in this sql tutorial video will be based on MySQL server.
The MySQL server offers 2 lock granularity levels:
1. Table-level locking
2. Row-level locking
Table-level locking only allows one SQL session to update a table at a time.
Row-level locking applies locks on rows based on SQL queries.
In MySQL server, Row-level locking has two subtypes:
1. A shared lock permits a transaction that locks the row to read it.
2. An exclusive lock permits a transaction that locked the row to update or delete the row.
In MySQL server, table-level locks are used by 3 storage engines:
1. MyISAM
2. MEMORY
3. MERGE (MRG_MyISAM)
In MySQL server, row-level locks are used by InnoDB and Percona Server XtraDB.
Music:
Hey! - Tobjan / tobjanmusic
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/3r1kvCG
Music promoted by Audio Library: • Hey! – Tobjan (No Copyright Music)
#shorts #reels #database #sql #mysql #web #webdevelopment #developer
On this page of the site you can watch the video online SQL Locking Granularity with a duration of hours minute second in good quality, which was uploaded by the user Database Dive 13 July 2023, share the link with friends and acquaintances, this video has already been watched 932 times on youtube and it was liked by 14 viewers. Enjoy your viewing!
