mysql - Why does myisAm not support row locks?

Question

myisAm The leaf nodes of the B-tree index store the row identifiers of the row data, which can be located to the physical location. Is there any problem with this understanding?

If there is no problem, then why does myisAm not support row locks? It should be possible to lock row identifiers, right?

Answer 1

Thank you. . Cry. . Brother, should you be so serious? . Different characteristics of engines make different engines. . Applicable to different scenarios. . It's not that it can't be done. . Is it necessary? . The cost of table-level locks and row-level locks is different. .