Shulou(Shulou.com)05/31 Report--

This article mainly introduces the mysql table-level lock mode of what the relevant knowledge, the content is detailed and easy to understand, the operation is simple and fast, has a certain reference value, I believe you will have something to gain after reading this mysql table-level lock mode, let's take a look.

1. Table shared read lock. Adding a table with shared read lock will not block other session's reading requests, but will block other session's writing requests.

CREATE TABLE `user` (`id` int (11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar (255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

2. table exclusive write lock, exclusive write lock is a well-known exclusive lock, which will hinder other processes from reading and writing to the same table.

Read and write operations of other procedures are performed only when the current lock is released.

This is the end of lock table test_lock WRITE; 's article on "what are the patterns of mysql table-level locks?" Thank you for reading! I believe you all have a certain understanding of "what are the modes of mysql table-level locks". If you want to learn more, you are welcome to follow the industry information channel.

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.