search

Home  >  Q&A  >  body text

mysql - Why does myisAm not support row locks?

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?

某草草某草草2708 days ago1128

reply all(1)I'll reply

  • 代言

    代言2017-06-16 09:21:35

    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. .

    reply
    0
  • Cancelreply