mysql - Why does myisAm not support row locks?
某草草
某草草 2017-06-16 09:19:35
0
1
1116

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?

某草草
某草草

reply all(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. .

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!