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
In questa pagina del sito puoi guardare il video online SQL Locking Granularity della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Database Dive 13 luglio 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 932 volte e gli è piaciuto 14 spettatori. Buona visione!
