{"id":946,"date":"2018-10-16T08:42:03","date_gmt":"2018-10-16T00:42:03","guid":{"rendered":"https:\/\/blog.jsjs.org\/?p=946"},"modified":"2018-10-16T08:42:03","modified_gmt":"2018-10-16T00:42:03","slug":"mysql%e6%9f%a5%e7%9c%8b%e8%a2%ab%e9%94%81%e4%bd%8f%e7%9a%84%e8%a1%a8%ef%bc%8c%e6%ad%a3%e5%9c%a8%e8%bf%9b%e8%a1%8c%e7%9a%84%e8%bf%9b%e7%a8%8b%ef%bc%8c%e5%b7%b2%e7%bb%8f%e6%9d%80%e6%8e%89%e8%bf%9b","status":"publish","type":"post","link":"https:\/\/blog.jsjs.org\/?p=946","title":{"rendered":"mysql\u67e5\u770b\u88ab\u9501\u4f4f\u7684\u8868\uff0c\u6b63\u5728\u8fdb\u884c\u7684\u8fdb\u7a0b\uff0c\u5df2\u7ecf\u6740\u6389\u8fdb\u7a0b\u7684\u65b9\u6cd5"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\">\/\/\u67e5\u770b\u6240\u6709\u8fdb\u7a0b<br \/>show processlist;\n<br \/>\/\/\u67e5\u8be2\u662f\u5426\u9501\u8868<br \/>show OPEN TABLES where In_use &gt;\u00a00;<br \/><br \/>\/\/\u67e5\u770b\u88ab\u9501\u4f4f\u7684\nSELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;\n\/\/\u7b49\u5f85\u9501\u5b9a\nSELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;\nkill <strong>12041<\/strong><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\/\/\u67e5\u770b\u6240\u6709\u8fdb\u7a0bshow processlist; \/\/\u67e5\u8be2\u662f\u5426\u9501\u8868show OPEN TABLES where In_use &gt;\u00a00;\/\/\u67e5\u770b\u88ab\u9501\u4f4f\u7684 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; \/\/\u7b49\u5f85\u9501\u5b9a SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; kill 12041<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-946","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/posts\/946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=946"}],"version-history":[{"count":0,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/posts\/946\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}