MySQL 高并发与锁机制 - 学习/实践

迷南。 2022-11-29 11:27 180阅读 0赞

1.应用场景

<table> 
 <tbody> 
  <tr> 
   <td> <p>主要用于利用MySQL的锁以及事务机制来高并发引发的问题.</p> <p>如: 库存量减少等.&nbsp;</p> </td> 
  </tr> 
 </tbody> 
</table>

2.学习/操作

<table> 
 <tbody> 
  <tr> 
   <td> <p style="text-align:center;"><img alt="" src="https://img-blog.csdnimg.cn/img_convert/c847c37216cd76b800db0e9276c4da14.png"></p> <h1>1. 文档</h1> 
    <blockquote> 
     <p><a href="https://time.geekbang.org/column/article/119044" rel="nofollow">https://time.geekbang.org/column/article/119044</a>&nbsp;//&nbsp;30丨锁：悲观锁和乐观锁是什么？</p> 
     <p><a href="https://laravelacademy.org/post/22107" rel="nofollow">https://laravelacademy.org/post/22107</a>&nbsp;//&nbsp;MySQL 中的全局锁、表锁与行锁（共享锁、排它锁、意向锁、死锁）</p> 
     <p><a href="https://laravelacademy.org/post/22112" rel="nofollow">https://laravelacademy.org/post/22112</a>&nbsp;//&nbsp;悲观锁、乐观锁和数据库事务隔离性的实现</p> 
     <p><a href="https://www.bilibili.com/video/av60556933/" rel="nofollow">https://www.bilibili.com/video/av60556933/</a>&nbsp;// 后盾人 --&nbsp;MySQL 高并发与锁机制</p> 
     <p><a href="https://blog.csdn.net/william_n/article/details/90441743" rel="nofollow">https://blog.csdn.net/william_n/article/details/90441743</a>&nbsp;//&nbsp;MySQL - 事务 - ACID的原理</p> 
    </blockquote> <h1>2. 整理输出</h1> <p>环境</p> 
    <blockquote> 
     <p>Windows 10 64位 专业版&nbsp; MySQL 8.x</p> 
     <p>或者</p> 
     <p>Mac Docker</p> 
    </blockquote> <p></p> <p></p> <p></p> <p>后续补充</p> <p>...</p> </td> 
  </tr> 
 </tbody> 
</table>

3.问题/补充

<table> 
 <tbody> 
  <tr> 
   <td> <h3>1. 日志输出"Lock wait timeout exceeded; try restarting transaction ", 原因以及解决办法?</h3> 
    <blockquote> 
     <p><img alt="" height="40" src="https://img-blog.csdnimg.cn/20210126174447240.png" width="1185"></p> 
     <p><img alt="" height="27" src="https://img-blog.csdnimg.cn/20210126174501193.png" width="1136"></p> 
     <p><img alt="" height="31" src="https://img-blog.csdnimg.cn/20210126174539676.png" width="1200"></p> 
     <p><a href="https://stackoverflow.com/search?q=Lock+wait+timeout+exceeded%3B+try+restarting+transaction+" rel="nofollow">https://stackoverflow.com/search?q=Lock+wait+timeout+exceeded%3B+try+restarting+transaction+</a></p> 
     <p><a href="https://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-even-though-im" rel="nofollow">https://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-even-though-im</a></p> 
    </blockquote> <p>2. 锁与事务之间的关系？</p> 
    <blockquote> 
     <p>TBD</p> 
    </blockquote> <p></p> <p></p> <p>...</p> </td> 
  </tr> 
 </tbody> 
</table>

4.参考

<table> 
 <tbody> 
  <tr> 
   <td> <p><a href="https://www.bilibili.com/video/av60556933/" rel="nofollow">https://www.bilibili.com/video/av60556933/</a>&nbsp;// 后盾人 --&nbsp;MySQL 高并发与锁机制</p> <p><a href="https://time.geekbang.org/column/article/119044" rel="nofollow">https://time.geekbang.org/column/article/119044</a>&nbsp;//&nbsp;30丨锁：悲观锁和乐观锁是什么？</p> <p><a href="https://laravelacademy.org/post/22107" rel="nofollow">https://laravelacademy.org/post/22107</a>&nbsp;//&nbsp;MySQL 中的全局锁、表锁与行锁（共享锁、排它锁、意向锁、死锁）</p> <p><a href="https://laravelacademy.org/post/22112" rel="nofollow">https://laravelacademy.org/post/22112</a>&nbsp;//&nbsp;悲观锁、乐观锁和数据库事务隔离性的实现</p> </td> 
  </tr> 
 </tbody> 
</table>

后续补充

...