"
When the SQL statements can't use the index will be a full table scan, this time the MySQL will add records to the whole list all of the data line locks, filtering them by the MySQL Server layer again, however, in MySQL Server layer filter, if found that don't meet the WHERE condition, can release the lock of corresponding records, in so doing, to ensure the final will only hold records meet the conditions on the lock, but each record don't omit locking operation,
"
MySQL using InnoDB engine, when the statement is not ropedancing caused by introduction of a full table scan, is directly on the table locks? Or record locks on each record? Or MySQL table lock is to use all the records of the lock?
Blog this passage is correct, if correct, according to my understanding, MySQL for the table aren't lock price than directly to the cost of each record locking small?
CodePudding user response:
Will release after it is possible, take the data table locks