MySQL--行锁案例分析

系统管理员 2021-08-13 14:44 374阅读 0赞

### 行锁案例分析 ###

**建表及准备数据：**

CREATE TABLE `test_innodb_lock`(
    a INT(11),
    b VARCHAR(16)
    )ENGINE INNODB;
    
    INSERT INTO test_innodb_lock values(1, 'b2');
    INSERT INTO test_innodb_lock values(3, '3');
    INSERT INTO test_innodb_lock values(4, '4000');
    INSERT INTO test_innodb_lock values(5, '5000');
    INSERT INTO test_innodb_lock values(6, '6000');
    INSERT INTO test_innodb_lock values(7, '7000');
    INSERT INTO test_innodb_lock values(8, '8000');
    INSERT INTO test_innodb_lock values(9, '9000');
    INSERT INTO test_innodb_lock values(1, 'b1');
    
    CREATE INDEX test_innodb_a_ind on test_innodb_lock(a);
    
    CREATE INDEX test_innodb_lock_b_ind on test_innodb_lock(b);

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70 1]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70 2]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70 4]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70]: /images/20210813/daed8074358d47ebaeb3915348be65a1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70 1]: /images/20210813/d1cc4efa7a1047af82b8d8b7d6bc11ef.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70 2]: /images/20210813/d5ac8285d45f4b069ff1f5cb323153d2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70 3]: /images/20210813/a06238250fd846798a86dbe014ed97d5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NvbGRfX19wbGF5_size_16_color_FFFFFF_t_70 4]: /images/20210813/579423278e0743588a9bd38e27c9217b.png