{"id":817,"date":"2014-08-10T20:37:31","date_gmt":"2014-08-10T11:37:31","guid":{"rendered":"http:\/\/tech.akat.info\/?p=817"},"modified":"2014-09-16T01:12:23","modified_gmt":"2014-09-15T16:12:23","slug":"mysql-%e3%83%ad%e3%83%83%e3%82%af","status":"publish","type":"post","link":"https:\/\/tech.akat.info\/?p=817","title":{"rendered":"mysql-\u30ed\u30c3\u30af-"},"content":{"rendered":"<h1>\u30ed\u30c3\u30af\u306b\u3064\u3044\u3066<\/h1>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nroot@hostname:\/home\/shimizu# mysql -uroot -ppassword\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 18756\r\nServer version: 5.5.38-MariaDB-1~wheezy-log mariadb.org binary distribution\r\n\r\nCopyright (c) 2000, 2014, Oracle, Monty Program Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB &#x5B;(none)]&gt; use information_schema;\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\n\r\nMariaDB &#x5B;information_schema]&gt; select * from INNODB_TRX order by trx_id\\G # INNODB_TRX\u306f\u73fe\u5728\u5b9f\u884c\u4e2d\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u8868\u793a\u3059\u308b\u30c6\u30fc\u30d6\u30eb\r\nEmpty set (0.02 sec)\r\n\r\nMariaDB &#x5B;information_schema]&gt; select * from INNODB_LOCKS order by lock_id\\G # \u30ed\u30c3\u30af\u7af6\u5408\u3092\u8d77\u3053\u3057\u3066\u3044\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u60c5\u5831\u3092\u8868\u793a\u3059\u308b\u30c6\u30fc\u30d6\u30eb\r\nEmpty set (0.00 sec)\r\n\r\nMariaDB &#x5B;information_schema]&gt; select * from INNODB_LOCK_WAITS\\G # \u3069\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u3069\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u5f85\u305f\u305b\u3066\u3044\u308b\u306e\u304b\u3092\u51fa\u529b\u3059\u308b\u30c6\u30fc\u30d6\u30eb\r\nEmpty set (0.00 sec)\r\n<\/pre>\n<h1>\u53c2\u8003URL<\/h1>\n<p>http:\/\/d.hatena.ne.jp\/sh2\/20090618<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30ed\u30c3\u30af\u306b\u3064\u3044\u3066 root@hostname:\/home\/shimizu# mysql -uroot -ppassword Welcome to the MariaDB monitor. Commands end with [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[25,14],"tags":[],"_links":{"self":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/817"}],"collection":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=817"}],"version-history":[{"count":1,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/817\/revisions"}],"predecessor-version":[{"id":818,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/817\/revisions\/818"}],"wp:attachment":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}