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.