{"id":2989,"date":"2021-09-11T10:02:04","date_gmt":"2021-09-11T01:02:04","guid":{"rendered":"https:\/\/www.ish.org\/blog\/?p=2989"},"modified":"2021-09-11T10:02:04","modified_gmt":"2021-09-11T01:02:04","slug":"mariadb%e3%81%aecommit-rollback","status":"publish","type":"post","link":"https:\/\/www.ish.org\/blog\/?p=2989","title":{"rendered":"mariadb\u306ecommit\/rollback"},"content":{"rendered":"<p>mysql\u3092\u4f7f\u3063\u3066\u3044\u305f\u6642\u304b\u3089autocommit\u304c\u9b31\u9676\u3057\u304b\u3063\u305f\u306e\u3067\u3001\u81ea\u5b85\u306emariadb\u30b5\u30fc\u30d0\u3092\u8a2d\u5b9a\u5909\u66f4\u3057\u307e\u3057\u305f\u3002<!--more--><br \/>\n\/usr\/local\/etc\/mysql\/conf.d\/server.cnf\u306e[mysqld]\u30bb\u30af\u30b7\u30e7\u30f3\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3057\u3066mariadb\u30b5\u30fc\u30d0\u3092\u518d\u8d77\u52d5\u3002<\/p>\n<pre>autocommit            = off\r\ntransaction-isolation = READ-COMMITTED<\/pre>\n<p>\u3053\u308c\u3067\u3084\u3063\u3068\u9577\u5e74\u4f7f\u3063\u3066\u304d\u305foracle\u3068\u540c\u69d8\u306b\u3001\u666e\u901a\u306bcommit\/rollback\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql\u3092\u4f7f\u3063\u3066\u3044\u305f\u6642\u304b\u3089autocommit\u304c\u9b31\u9676\u3057\u304b\u3063\u305f\u306e\u3067\u3001\u81ea\u5b85\u306emariadb\u30b5\u30fc\u30d0\u3092\u8a2d\u5b9a\u5909\u66f4\u3057\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-2989","post","type-post","status-publish","format-standard","hentry","category-misc"],"_links":{"self":[{"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2989","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2989"}],"version-history":[{"count":1,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2989\/revisions"}],"predecessor-version":[{"id":2990,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2989\/revisions\/2990"}],"wp:attachment":[{"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}