{"id":635,"date":"2019-03-04T05:10:25","date_gmt":"2019-03-04T05:10:25","guid":{"rendered":"https:\/\/monyog.jp\/?p=635"},"modified":"2019-03-07T02:13:57","modified_gmt":"2019-03-07T02:13:57","slug":"innodb%e3%83%87%e3%83%83%e3%83%89%e3%83%ad%e3%83%83%e3%82%af%e3%81%ae%e7%9b%a3%e8%a6%96","status":"publish","type":"post","link":"https:\/\/smart-style.main.jp\/monyogjp\/static\/document\/635\/index.html","title":{"rendered":"InnoDB\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306e\u76e3\u8996"},"content":{"rendered":"<p>\u2018InnoDB\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u2019\u30e2\u30cb\u30bf\u30fc\u306f\u4ed6\u306e\u30e2\u30cb\u30bf\u30fc\u3068\u306f\u591a\u5c11\u7570\u306a\u308b\u305f\u3081\u3001\u591a\u5c11\u306e\u8aac\u660e\u304c\u5fc5\u8981\u3067\u3059\u3002\u4ed6\u306e\u30e2\u30cb\u30bf\u30fc\u3067\u306f\u3044\u305a\u308c\u3082SHOW GLOBAL STATUS\u3001SHOW GLOBAL VARIABLES\u3001SHOW SLAVE STATUS\u304b\u3089\u306e\u623b\u308a\u5024\u304c\u57fa\u6e96\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u306b\u5bfe\u3057\u3001\u2018InnoDB\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u2019\u30e2\u30cb\u30bf\u30fc\u3067\u306f\u3001SHOW ENGINE INNODB STATUS\u304b\u3089\u306e\u51fa\u529b\u304c\u57fa\u6e96\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306f\u3001\u5148\u306b\u6319\u3052\u305f\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3068\u306f\u3001\u5358\u72ec\u306e\u96e2\u6563\u5024\uff08\u5358\u72ec\u306e\u756a\u53f7\u306a\u3069\uff09\u3092\u8fd4\u3055\u305a\u3001\u4ee3\u308f\u308a\u306b\u591a\u304f\u306e\u60c5\u5831\u3092\u8fbc\u3081\u305f\u9577\u3044\u30b9\u30c8\u30ea\u30f3\u30b0\u3092\u8fd4\u3057\u307e\u3059\u3002\u3053\u306e\u9577\u3044\u30b9\u30c8\u30ea\u30f3\u30b0\u304b\u3089\u3001\u4f55\u304c\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306b\u95a2\u308f\u3063\u3066\u3044\u308b\u306e\u304b\u3068\u3044\u3046\u60c5\u5831\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30e2\u30cb\u30bf\u30fc\u3067\u3001\u2018Current\uff08\u73fe\u5728\uff09\u2019\u6642\u9593\u30d5\u30ec\u30fc\u30e0\u3068\u2018Delta\uff08\u30c7\u30eb\u30bf\uff09\u2019\u6642\u9593\u30d5\u30ec\u30fc\u30e0\u3092\u533a\u5225\u3057\u3088\u3046\u3068\u3057\u3066\u3082\u610f\u5473\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u4ee5\u4e0b\u306e\u3088\u3046\u306b SQL Diagnostic Manager\u3067\u306f\u540c\u3058\u3088\u3046\u306b\u8868\u793a\u3055\u308c\u308b\u304b\u3089\u3067\u3059\u3002<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-636\" src=\"https:\/\/monyog.jp\/wp-content\/uploads\/2019\/03\/32-1.jpg\" alt=\"\" width=\"1915\" height=\"900\" srcset=\"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-content\/uploads\/2019\/03\/32-1.jpg 1915w, https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-content\/uploads\/2019\/03\/32-1-300x141.jpg 300w, https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-content\/uploads\/2019\/03\/32-1-768x361.jpg 768w\" sizes=\"(max-width: 1915px) 100vw, 1915px\" \/><\/p>\n<p><strong>\u2018New Deadlock Detected\uff08\u65b0\u3057\u3044\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u3092\u691c\u51fa\u3057\u307e\u3057\u305f\uff09\u2019<\/strong>\u306f\u3001\u524d\u56de\u306e2\u3064\u306e\u30c7\u30fc\u30bf\u691c\u7d22\u306e\u9593\u306b\u3001INNODB STATUS\u306b\u3088\u3063\u3066\u65b0\u3057\u3044\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u304c\u5831\u544a\u3055\u308c\u305f\u3053\u3068\u3092\u8868\u3057\u307e\u3059\u3002<strong>\u2018Latest Deadlock Detected\uff08\u524d\u56de\u691c\u51fa\u3057\u305f\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\uff09<\/strong>\u2019\u306b\u306f\u3001\u691c\u51fa\u3057\u305f\u524d\u56de\u306e\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306b\u95a2\u3059\u308b\u60c5\u5831\u304c\uff08\u3042\u308c\u3070\uff09\u8868\u793a\u3055\u308c\u307e\u3059\u3002SQL Diagnostic Manager\u306b\u60c5\u5831\u304c\u3042\u308b\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u72b6\u6cc1\u3092\u3059\u3079\u3066\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u2018History\uff08\u5c65\u6b74\uff09\u2019\u6642\u9593\u30d5\u30ec\u30fc\u30e0\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<p>\u306a\u304a\u3001SHOW ENGINE INNODB STATUS\u304b\u3089\u8fd4\u308b\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u60c5\u5831\u306b\u306f\u3001SQL Diagnostic Manager\u306b\u3082\u95a2\u4fc2\u3059\u308b\u5236\u7d04\u304c\u8ab2\u305b\u3089\u308c\u3066\u3044\u307e\u3059\u3002\u305d\u308c\u306f\u3001SHOW ENGINE INNODB STATUS\u304c\u8fd4\u3059\u60c5\u5831\u306f\u3001\u524d\u56de\u306e\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306b\u95a2\u3059\u308b\u60c5\u5831\u3060\u3051\u306a\u306e\u3067\u30012\u56de\u306e\u30c7\u30fc\u30bf\u53ce\u96c6\u9593\u9694\u306e\u9593\u306b\u8907\u6570\u306e\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u304c\u767a\u751f\u3057\u3066\u3082\u3001SQL Diagnostic Manager\u304c\u5831\u544a\u3059\u308b\u306e\u306f\u524d\u56de\u306e\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306b\u95a2\u3059\u308b\u60c5\u5831\u3060\u3051\u3060\u3068\u3044\u3046\u5236\u7d04\u3067\u3059\u3002<\/p>\n<h4>\u6ce8\u610f\uff1aMonyog\u3092\u3054\u5229\u7528\u306e\u65b9<\/h4>\n<p>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3001\u904e\u5270\u6a29\u9650\u3001InnDB\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u5404\u30ab\u30a6\u30f3\u30bf\u30fc\u3092\u5229\u7528\u3067\u304d\u308b\u306e\u306f\u3001Monyog Ultimate\u306e\u307f\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u2018InnoDB\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u2019\u30e2\u30cb\u30bf\u30fc\u306f\u4ed6\u306e\u30e2\u30cb\u30bf\u30fc\u3068\u306f\u591a\u5c11\u7570\u306a\u308b\u305f\u3081&#8230; <\/p>\n<div class=\"readmore\"><a href=\"https:\/\/smart-style.main.jp\/monyogjp\/static\/document\/635\/index.html\">Read more<\/a><\/div>\n","protected":false},"author":2,"featured_media":893,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,8,11],"tags":[],"_links":{"self":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts\/635"}],"collection":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/comments?post=635"}],"version-history":[{"count":0,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts\/635\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/media\/893"}],"wp:attachment":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/media?parent=635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/categories?post=635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/tags?post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}