Introduction to the MySQL locking schema | SQL courses

OBS: download the application please visit www.mrbool.com/player

Title: Introduction to the MySQL locking schema

Duration:  14:53 min.

Summary: Nowdays the databases have to be able to support multiple concurrency users accessing and modifying the data. To control and prevent problems that arise from the concurrency access to the data, most database servers uses locking. In this video we will see how the MySQL locking schema works though the explanation of the locking and  blocking concepts followed by practical examples. The LOCK TABLES and UNLOCK  TABLES commands are showed with the goal to demonstrate how to use them when the database needs to control the access to write and read the data contained in a table.

 Technologies: MySQL, Locking, Linux.

 Examples built: How to simulate concurrency access and locking in MySQL.

 Keywords: SQL, MySQL, Locking.