yemoluo
V2EX  ›  科技

关于 MySQL ,最近被一个问题问倒了...innodb 是怎么实现行锁的

  •  
  •   yemoluo · Aug 15, 2018 · 3371 views
    This topic created in 3021 days ago, the information mentioned may be changed or developed.

    关于 MySQL,最近被一个问题问倒了

    innodb 是怎么实现行锁的

    这是我见过的最叼拽的问题了

    我直接愣在当场...

    悲剧的是,我前几天写 IndexedDB 简明教程的时候,还特意去了解了下,就是没看,反正都是锁吗? 不就直接锁数据咯

    回来一 Google ...发现我错了

    6 replies  •  2018-08-16 21:46:13 +08:00
    lolizeppelin
    lolizeppelin
    Aug 15, 2018 via Android
    1
    我记得是通过索引
    watzds
    watzds
    Aug 15, 2018 via Android❤️1
    2
    这个锁分析挺复杂的,看看这个,

    https://juejin.im/entry/5b6c5c18e51d451924736388
    还有何登成的博客
    metrxqin
    metrxqin
    Aug 15, 2018❤️1
    3
    I'm not sure how exactly it was implemented, but here's some higher concepts that you might find it useful https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
    yemoluo
    yemoluo
    OP
    Aug 15, 2018
    4
    @metrxqin Thank's a lot
    yemoluo
    yemoluo
    OP
    Aug 15, 2018
    5
    @watzds 感谢
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1650 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 16:10 · PVG 00:10 · LAX 08:10 · JFK 11:10
    ♥ Do have faith in what you're doing.