MySQL死锁检查处理的正常方法(3)--系统吧

MySQL死锁检查处理的正常方法(3): 作者：孙紫潇分类：win10 发布时间：2021-07-25 09:32:00

where In_use > 0; + ----------+-------+--------+-------------+ | Database | Table | In_use | Name_locked | + ----------+-------+--------+-------------+ | test | bb | 1 | 0 | + ----------+-----...

where In_use > 0;+----------+-------+--------+-------------+| Database | Table | In_use | Name_locked |+----------+-------+--------+-------------+| test | bb | 1 | 0 |+----------+-------+--------+-------------+

#step 4：窗口三#是否自动提交mysql> show variables like 'autocommit';+---------------+-------+| Variable_name | Value |+---------------+-------+| autocommit | ON |+---------------+-------+ #查看当前连接mysql> show processlist;mysql> show full processlist;mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;+----+------+-----------+------+---------+------+-------+------------------+| Id | User | Host  | db | Command | Time | State | Info    |+----+------+-----------+------+---------+------+-------+------------------+| 4 | root | localhost | test | Sleep | 244 |  | NULL    || 5 | root | localhost | test | Sleep | 111 |  | NULL    || 6 | root | localhost | NULL | Query | 0 | init | show processlist |+----+------+-----------+------+---------+------+-------+------------------+  #查看当前正在被锁的事务（锁请求超时后则查不到）mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;+------------------+-------------+-----------+-----------+-------------+-----------------+------------+-----------+----------+----------------+| lock_id   | lock_trx_id | lock_mode | lock_type | lock_table | lock_index  | lock_space | lock_page | lock_rec | lock_data  |+------------------+-------------+-----------+-----------+-------------+-----------------+------------+-----------+----------+----------------+| 130718495:65:3:4 | 130718495 | X   | RECORD | `test`.`bb` | GEN_CLUST_INDEX |   65 |   3 |  4 | 0x000000000300 || 130718496:65:3:4 | 130718496 | X   | RECORD | `test`.`bb` | GEN_CLUST_INDEX |   65 |   3 |  4 | 0x000000000300 |+------------------+-------------+-----------+-----------+-------------+-----------------+------------+-----------+----------+----------------+ #查看当前等待锁的事务（锁请求超时后则查不到）mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; +-------------------+-------------------+-----------------+------------------+| requesting_trx_id | requested_lock_id | blocking_trx_id | blocking_lock_id |+-------------------+-------------------+-----------------+------------------+| 130718499   | 130718499:65:3:4 | 130718500  | 130718500:65:3:4 |+-------------------+-------------------+-----------------+------------------+  #查看当前未提交的事务（如果死锁等待超时,事务可能还没有关闭）mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;+--------------------------------------------------------------------------------------------------------+| trx_id | trx_state | trx_started   | trx_requested_lock_id | trx_wait_started | trx_weight |+-----------+-----------+---------------------+-----------------------+---------------------+------------+| 130718500 | RUNNING | 2018-03-12 09:28:10 | NULL     | NULL    |   3 || 130718499 | LOCK WAIT | 2018-03-12 09:27:59 | 130718499:65:3:4  | 2018-03-12 09:32:48 |   5 |==========================================================================================================| trx_mysql_thread_id | trx_query        | trx_operation_state | trx_tables_in_use |+---------------------+---------------------------------------+---------------------+-------------------+|     4 | NULL         | NULL    |     0 ||     5 | update bb set name='bbb'    | starting index read |     1 |=========================================================================================================| trx_tables_locked | trx_lock_structs | trx_lock_memory_bytes | trx_rows_locked | trx_rows_modified |+-------------------+------------------+-----------------------+-----------------+-------------------+|     0 |    2 |     360 |    3 |     1 ||     1 |    4 |     1184 |    4 |     1 |===========================================================================================================================| trx_concurrency_tickets | trx_isolation_level | trx_unique_checks | trx_foreign_key_checks | trx_last_foreign_key_error |+-------------------------+---------------------+-------------------+------------------------+----------------------------+|      0 | REPEATABLE READ  |     1 |      1 | NULL      ||      0 | REPEATABLE READ  |     1 |      1 | NULL      |===========================================================================================================================| trx_adaptive_hash_latched | trx_adaptive_hash_timeout | trx_is_read_only | trx_autocommit_non_locking |+---------------------------+---------------------------+------------------+----------------------------+|       0 |      10000 |    0 |       0 ||       0 |      10000 |    0 |       0 |+---------------------------+---------------------------+------------------+----------------------------+  #查看正在被访问的表mysql> show OPEN TABLES where In_use > 0;+----------+-------+--------+-------------+| Database | Table | In_use | Name_locked |+----------+-------+--------+-------------+| test  | bb |  1 |   0 |+----------+-------+--------+-------------+
           
      <div class="clear"></div>
        <div class="page"> <li><a>共7页: </a></li><li><a href='73702_2.html'>上一页</a></li><li><a href='73702.html'>1</a></li><li><a href='73702_2.html'>2</a></li><li class="thisclass"><a href='#'>3</a></li><li><a href='73702_4.html'>4</a></li><li><a href='73702_5.html'>5</a></li><li><a href='73702_6.html'>6</a></li><li><a href='73702_7.html'>7</a></li><li><a href='73702_4.html'>下一页</a></li></div>
        
      </div>
      <div class="art_next"> <span class="next">上一篇：<a href='/win10jc/73700.html'>win10升级后搜索功能很卡怎么办 win10搜索栏卡顿怎么办</a> </span> <span class="pre">下一篇：<a href='/win10jc/73704.html'>win10错误代码0x8007007e修复图文教程</a> </span> </div>
      <div class="art_like">
        <div class="like_l">
          <h3>猜您喜欢</h3>
          <ul>
		    <li><a href="/win10jc/178920.html">轻松掌握win10看配置技巧，如何检查你..</a><span>2024-03-26</span></li>
<li><a href="/win10jc/178517.html">揭秘！如何检查Windows 10是否已成功激..</a><span>2024-03-24</span></li>
<li><a href="/win10jc/177583.html">Win10提示无法连接打印机？检查打印机..</a><span>2024-03-12</span></li>
<li><a href="/win10jc/175724.html">Win10磁盘检查卡住？进不去系统？只需..</a><span>2024-02-25</span></li>
<li><a href="/win10jc/175246.html">轻松一招：如何检查Win10是否激活，让..</a><span>2024-02-24</span></li>
<li><a href="/win10jc/172621.html">Win10小技巧：轻松关闭磁盘修复检查..</a><span>2024-02-02</span></li>

</ul>
        </div>
        <div class="like_r">
          <h3>相关推荐</h3>
          <ul>
                <div id='tag76487956b33bafac4eafa2fcf039632d'>
<li><a href="/win10jc/47243.html">win10 cmd跳到指定目录怎么操作_win10系统..</a><span>2021-03-18</span></li>
<li><a href="/win10jc/82532.html">win10 recovery恢复系统的教程 win10 recov..</a><span>2022-02-28</span></li>
<li><a href="/win10jc/15444.html">图文讲解Win10桌面动态磁贴是Win7/Win8..</a><span>2017-09-19</span></li>
<li><a href="/win10jc/139137.html">n卡录制怎么开 win11n卡录制怎么开..</a><span>2023-09-12</span></li>
<li><a href="/win10jc/141801.html">如何压缩jpg图片的大小 美图秀秀如何..</a><span>2023-09-28</span></li>
<li><a href="/win10jc/93202.html">win10系统更新失败错误代码0x800F0805的解..</a><span>2022-07-18</span></li>
    </div>

</ul>
        </div>
      </div>
      <div class="artItemList pcHide">
	    <div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/178920.html">轻松掌握win10看配置技巧，如何检查你的</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/178920.html"><img src="/uploads/allimg/240326/19295V2G-0-lp.png"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=178920&mid=1" type='text/javascript' language="javascript"></script></span> <span>2024-03-26</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/178517.html">揭秘！如何检查Windows 10是否已成功激活</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/178517.html"><img src="/images/defaultpic.gif"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=178517&mid=1" type='text/javascript' language="javascript"></script></span> <span>2024-03-24</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/177583.html">Win10提示无法连接打印机？检查打印机名</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/177583.html"><img src="/uploads/allimg/240312/23250121E-0-lp.jpg"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=177583&mid=1" type='text/javascript' language="javascript"></script></span> <span>2024-03-12</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/175724.html">Win10磁盘检查卡住？进不去系统？只需这</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/175724.html"><img src="/uploads/allimg/240225/1I9596193-0-lp.png"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=175724&mid=1" type='text/javascript' language="javascript"></script></span> <span>2024-02-25</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/175246.html">轻松一招：如何检查Win10是否激活，让你</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/175246.html"><img src="/uploads/allimg/240224/06245a5E-0-lp.png"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=175246&mid=1" type='text/javascript' language="javascript"></script></span> <span>2024-02-24</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/172621.html">Win10小技巧：轻松关闭磁盘修复检查</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/172621.html"><img src="/uploads/allimg/240202/1236004T8-0-lp.jpg"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=172621&mid=1" type='text/javascript' language="javascript"></script></span> <span>2024-02-02</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/169443.html">联想笔记本频繁出现检查介质警告？手把</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/169443.html"><img src="/uploads/allimg/240113/1F0004b9-0-lp.jpg"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=169443&mid=1" type='text/javascript' language="javascript"></script></span> <span>2024-01-13</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/168949.html">MySQL连接问题：数据库10038错误，快速解决</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/168949.html"><img src="/uploads/allimg/240110/1P55915c-0-lp.jpg"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=168949&mid=1" type='text/javascript' language="javascript"></script></span> <span>2024-01-10</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/160865.html">Win10蓝屏机器检查异常，简单几步轻松解</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/160865.html"><img src="/uploads/allimg/231215/154K922M-0-lp.jpg"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=160865&mid=1" type='text/javascript' language="javascript"></script></span> <span>2023-12-15</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/160109.html">蓝屏代码泄露！一招搞定安全检查失败完</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/160109.html"><img src="/uploads/allimg/231213/1114592238-0-lp.jpg"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=160109&mid=1" type='text/javascript' language="javascript"></script></span> <span>2023-12-13</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/158417.html">联想电脑检查媒体无法启动？看这里，一</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/158417.html"><img src="/uploads/allimg/231209/1Q4591209-0-lp.jpg"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=158417&mid=1" type='text/javascript' language="javascript"></script></span> <span>2023-12-09</span> </div>
        </div>
<div class="artItem s1">
          <div class="itemTit">
            <h4><a href="/win10jc/143749.html">win10qq登陆超时检查网络或防火墙怎么处理</a></h4>
          </div>
          <div class="itemPic">
            <div class="titPic"> <a href="/win10jc/143749.html"><img src="/uploads/allimg/231012/1523593E1-0-lp.png"></a> </div>
          </div>
          <div class="wapInfo"><span>栏目：<a href="/win10jc/">win10</a></span> <span>阅读:<script src="/plus/count.php?view=yes&aid=143749&mid=1" type='text/javascript' language="javascript"></script></span> <span>2023-10-12</span> </div>
        </div>

</div>
    </div>
  </div>
<div class="side_r">
  <div class="listArt">
    <dl>
      <dt><strong class="fl">xp</strong> <span class="fr"><a href="/xpjc/">更多>></a></span></dt>
      <dd>
        <ul>
	     <li><i></i><a href="/xpjc/181185.html">Win11系统0xc0000142错误代码修复大揭秘：一招告别</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/xpjc/181183.html">Win11新建TXT文本文档消失？别担心，轻松解决！</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/xpjc/181180.html">探索新视界：如何为Win11电脑任务栏打造梦幻透明</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/xpjc/181176.html">如何让Win11电脑合盖不休眠？简单设置技巧</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/xpjc/181174.html">电脑没声音了？恢复win11电脑声音的秘诀！</a> <span>2024-05-03</span> </li>

</ul>
      </dd>
    </dl>
    <dl>
    <dl>
      <dt><strong class="fl">win7</strong> <span class="fr"><a href="/win7jc/">更多>></a></span></dt>
      <dd>
        <ul>
	     <li><i></i><a href="/win7jc/181111.html">Win7笔记本小技巧：如何关闭触摸板，轻松告别误</a> <span>2024-04-30</span> </li>
<li><i></i><a href="/win7jc/181102.html">win7安全证书过期，如何轻松解决？快来看看！</a> <span>2024-04-30</span> </li>
<li><i></i><a href="/win7jc/181099.html">Win7本本无线网络不显示？这5招轻松解决！</a> <span>2024-04-29</span> </li>
<li><i></i><a href="/win7jc/181093.html">windows7开机密码遗忘？别急，教你轻松找回win7电</a> <span>2024-04-29</span> </li>
<li><i></i><a href="/win7jc/181088.html">【秘籍】轻松关闭Windows7开机启动项，告别慢速启</a> <span>2024-04-29</span> </li>

</ul>
      </dd>
    </dl>
	    <dl>
      <dt><strong class="fl">win8</strong> <span class="fr"><a href="/win8jc/">更多>></a></span></dt>
      <dd>
        <ul>
	     <li><i></i><a href="/win8jc/180971.html">轻松解锁Windows家长控制：教你如何摆脱控制模式</a> <span>2024-04-25</span> </li>
<li><i></i><a href="/win8jc/180964.html">腾讯会议如何添置外置摄像头？简单几步让你轻</a> <span>2024-04-25</span> </li>
<li><i></i><a href="/win8jc/180958.html">揭秘！耕升显卡出厂日期查询方法，让你轻松了</a> <span>2024-04-25</span> </li>
<li><i></i><a href="/win8jc/180956.html">轻松掌握：电脑删除多余键盘布局的秘密技巧</a> <span>2024-04-24</span> </li>
<li><i></i><a href="/win8jc/180952.html">HMCL启动器联机新玩法：如何与好友共享游戏世界</a> <span>2024-04-24</span> </li>

</ul>
      </dd>
    </dl>
	    <dl>
      <dt><strong class="fl">win10</strong> <span class="fr"><a href="/win10jc/">更多>></a></span></dt>
      <dd>
        <ul>
	     <li><i></i><a href="/win10jc/181182.html">Win10谷歌浏览器无法自动更新？看这里，轻松解决</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/win10jc/181181.html">Win10轻松解压7z文件：新手入门技巧</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/win10jc/181178.html">Win10电脑突然失语？无法打字的原因及解决方法</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/win10jc/181177.html">解锁屏幕，轻松截取Win10系统美妙瞬间</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/win10jc/181173.html">Win10开始菜单打不开？这五大原因让你轻松修复！</a> <span>2024-05-03</span> </li>

</ul>
      </dd>
    </dl>
	    <dl>
      <dt><strong class="fl">U盘</strong> <span class="fr"><a href="/upanjc/">更多>></a></span></dt>
      <dd>
        <ul>
	     <li><i></i><a href="/upanjc/181184.html">Win11电脑DNS异常？简单几步教你如何修复！</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/upanjc/181179.html">Win11电脑C盘空间告急？如何安全转移到D盘！</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/upanjc/181175.html">Win11驱动无数字签名，这些方法帮你轻松解决！</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/upanjc/181170.html">Win11连接隐藏WiFi，提示无法连接？这个解决方法</a> <span>2024-05-03</span> </li>
<li><i></i><a href="/upanjc/181165.html">Win11安装显卡驱动遇未知错误？一招轻松解决！</a> <span>2024-05-02</span> </li>

</ul>
      </dd>
    </dl>
	    <dl>
      <dt><strong class="fl">电脑技术</strong> <span class="fr"><a href="/dnjs/">更多>></a></span></dt>
      <dd>
        <ul>
	     <li><i></i><a href="/dnjs/180965.html">如何通过代理IP加强您的密码安全防护</a> <span>2024-04-25</span> </li>
<li><i></i><a href="/dnjs/117654.html">Win10注册表真实文件放在哪里 win10注册表保存在哪</a> <span>2024-04-15</span> </li>
<li><i></i><a href="/dnjs/180188.html">夸克浏览器被限制访问？这几种方法帮你轻松解</a> <span>2024-04-07</span> </li>
<li><i></i><a href="/dnjs/180180.html">我的世界hmcl启动器游戏非正常退出？解决方法来</a> <span>2024-04-07</span> </li>
<li><i></i><a href="/dnjs/180172.html">如何解决笔记本小键盘失灵，简单一招让你告别</a> <span>2024-04-07</span> </li>

</ul>
      </dd>
    </dl>
  </div>
</div>
</div>
<div class="w100 ft">
  <div class="container">
    <div class="ft_nav"><a href="http://www.caeworld.cn/sitemap.xml">网站地图</a> |  <a href="https://beian.miit.gov.cn/">豫ICP备2021035069号-4</a> | 友情链接qq：191064436</div>
    <div class="ft_info"> <span class="pcHide"><a href="/">系统吧</a></span>
      <p> 版权所有 <b style="font-family:Arial">©</b> <span class="wapHide">2012-2023</span> <a href="/#">系统吧</a> <span class="wapHide">免责声明：本站资源均收集于互联网，其著作权归原作者所有，如果有侵犯您权利的资源，请来信告知，我们将及时删除相应资源。</span> </p>
    </div>
<script charset="UTF-8" id="LA_COLLECT" src="//sdk.51.la/js-sdk-pro.min.js"></script>
<script>LA.init({id: "JjhF1qWpvtoBdwdi",ck: "JjhF1qWpvtoBdwdi"})</script>
<script>
var _hmt = _hmt || [];
(function() {
  var hm = document.createElement("script");
  hm.src = "https://hm.baidu.com/hm.js?1fa3aab03ed68caf191a549b61a04777";
  var s = document.getElementsByTagName("script")[0]; 
  s.parentNode.insertBefore(hm, s);
})();
</script>
  </div>
</div>
</body>
</html>