Shulou(Shulou.com)06/01 Report--

What this article shares with you is about how to use mysql at the line level. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

What is a row-level lock

At the row level, only the specified records are locked, and other processes can still operate on other records in the same table.

Advantages of row-level locking:

1. There are only a few lock conflicts when accessing different rows in many threads.

two。 There are only a small number of changes on rollback.

3. You can lock a single row for a long time.

Disadvantages of row-level locking:

1. Takes up more memory than page-or table-level locking.

two。 When used in most tables, locking is slower than page-or table-level locking.

3. GROUP BY operations are often performed on most data or the entire table must be scanned frequently, which is significantly slower than other locks.

4. With high-level locking, the application can be easily tuned by supporting different types of locking because the cost of locking is less than row-level locks.

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

The above is how mysql uses the line level, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please 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.