What does mysql intention lock refer to?

This article is about what mysql intention lock refers to. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. InnoDB also implements table-level locks, that is, intentional locks, which are used within mysql without user intervention.

2. Intention lock and row lock can coexist, and the main function of intention lock is to improve the performance of updating data in the whole table.

Otherwise, when the entire table updates the data, you need to retrieve whether Fan has rows locked on some records.

Example

Trx1:1. BEGIN;2. Add an X lock to table T1 and modify the table structure. Trx2:1. BEGIN;2. Add S or X locks to a row of records in table T1 (the transaction is blocked). Thank you for reading! This is the end of the article on "what mysql intention lock refers to". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!