{"id":162,"date":"2011-12-08T09:00:25","date_gmt":"2011-12-08T09:00:25","guid":{"rendered":"http:\/\/blog.zhukunqian.com\/?p=162"},"modified":"2011-12-11T15:03:35","modified_gmt":"2011-12-11T15:03:35","slug":"hibernate-mysql-autocommit","status":"publish","type":"post","link":"https:\/\/blog.zhukunqian.com\/?p=162","title":{"rendered":"hibernate mysql autocommit"},"content":{"rendered":"<p>http:\/\/forum.springsource.org\/showthread.php?12639-MySQL-set-autocommit-0-set-autocommit-1<\/p>\n<p>\u4ee5\u4e0b\u8bbe\u7f6e\u907f\u514d\u6bcf\u6b21\u4e8b\u52a1\u90fd\u5411db\u53d1\u9001\u65e0\u7528\u7684commit\u8bf7\u6c42<\/p>\n<pre>&lt;bean id=\"dataSourceTarget\"&gt;\r\n  &lt;property name=\"driverClassName\"&gt;&lt;value&gt;com.mysql.jdbc.Driver&lt;\/value&gt;&lt;\/property&gt;\r\n  &lt;property name=\"url\"&gt;&lt;value&gt;jdbc&amp;#58;mysql&amp;#58;\/\/localhost&amp;#58;3306\/imagedb&lt;\/value&gt;&lt;\/property&gt;\r\n  &lt;property name=\"username\"&gt;&lt;value&gt;admin&lt;\/value&gt;&lt;\/property&gt;\r\n  &lt;property name=\"password\"&gt;&lt;value&gt;&lt;\/value&gt;&lt;\/property&gt;\r\n&lt;\/bean&gt;\r\n\r\n&lt;bean id=\"dataSource\"&gt;\r\n  &lt;property name=\"targetDataSource\"&gt;&lt;ref local=\"dataSource\"\/&gt;&lt;\/property&gt;\r\n&lt;\/bean&gt;<\/pre>\n<p>\u8bbe\u7f6e\u4e4b\u524d:<\/p>\n<p>__ Questions ___________________________________________________________<br \/>\nTotal\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.88M\u00a0\u00a0\u00a0\u00a0 5.3\/s<br \/>\nCom_\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.32M\u00a0\u00a0\u00a0\u00a0 3.7\/s\u00a0 %Total:\u00a0 69.98<br \/>\nDMS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 512.62k\u00a0\u00a0\u00a0\u00a0 1.5\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 27.28<br \/>\nQC Hits\u00a0\u00a0\u00a0\u00a0\u00a0 51.53k\u00a0\u00a0\u00a0\u00a0 0.1\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.74<br \/>\nCOM_QUIT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 36\u00a0\u00a0\u00a0\u00a0 0.0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00<br \/>\n-Unknown\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0\u00a0\u00a0 0.0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00<br \/>\nSlow 2 s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0 0.0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0 %DMS:\u00a0\u00a0 0.00\u00a0 Log:\u00a0 ON<br \/>\nDMS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 512.62k\u00a0\u00a0\u00a0\u00a0 1.5\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 27.28<br \/>\nSELECT\u00a0\u00a0\u00a0\u00a0\u00a0 373.42k\u00a0\u00a0\u00a0\u00a0 1.1\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 19.87\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 72.85<br \/>\nINSERT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 68.29k\u00a0\u00a0\u00a0\u00a0 0.2\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.63\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13.32<br \/>\nUPDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 61.07k\u00a0\u00a0\u00a0\u00a0 0.2\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.25\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11.91<br \/>\nDELETE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9.84k\u00a0\u00a0\u00a0\u00a0 0.0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.52\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.92<br \/>\nREPLACE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00<br \/>\nCom_\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.32M\u00a0\u00a0\u00a0\u00a0 3.7\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 69.98<br \/>\nset_option\u00a0 875.44k\u00a0\u00a0\u00a0\u00a0 2.5\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 46.59<br \/>\ncommit\u00a0\u00a0\u00a0\u00a0\u00a0 436.17k\u00a0\u00a0\u00a0\u00a0 1.2\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 23.21<br \/>\nchange_db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 544\u00a0\u00a0\u00a0\u00a0 0.0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.03<\/p>\n<p>&nbsp;<\/p>\n<p>\u8bbe\u7f6e\u4e4b\u540e:<\/p>\n<p>__ Questions ___________________________________________________________<br \/>\nTotal\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50.41M\u00a0\u00a0 197.8\/s<br \/>\nDMS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32.99M\u00a0\u00a0 129.5\/s\u00a0 %Total:\u00a0 65.45<br \/>\nCom_\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16.53M\u00a0\u00a0\u00a0 64.9\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32.78<br \/>\nQC Hits\u00a0\u00a0\u00a0\u00a0 855.49k\u00a0\u00a0\u00a0\u00a0 3.4\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.70<br \/>\nCOM_QUIT\u00a0\u00a0\u00a0\u00a0 34.27k\u00a0\u00a0\u00a0\u00a0 0.1\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.07<br \/>\n-Unknown\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 29\u00a0\u00a0\u00a0\u00a0 0.0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00<br \/>\nSlow 2 s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0 0.0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0 %DMS:\u00a0\u00a0 0.00\u00a0 Log:\u00a0 ON<br \/>\nDMS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32.99M\u00a0\u00a0 129.5\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 65.45<br \/>\nSELECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17.61M\u00a0\u00a0\u00a0 69.1\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 34.94\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 53.38<br \/>\nUPDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11.46M\u00a0\u00a0\u00a0 45.0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 22.74\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 34.74<br \/>\nINSERT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.38M\u00a0\u00a0\u00a0 13.3\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6.70\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10.24<br \/>\nDELETE\u00a0\u00a0\u00a0\u00a0\u00a0 544.37k\u00a0\u00a0\u00a0\u00a0 2.1\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.08\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.65<br \/>\nREPLACE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00<br \/>\nCom_\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16.53M\u00a0\u00a0\u00a0 64.9\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32.78<br \/>\nset_option\u00a0\u00a0 10.99M\u00a0\u00a0\u00a0 43.1\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 21.81<br \/>\ncommit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.43M\u00a0\u00a0\u00a0 21.3\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10.76<br \/>\nchange_db\u00a0\u00a0\u00a0 34.37k\u00a0\u00a0\u00a0\u00a0 0.1\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.07<br \/>\n\u53ef\u4ee5\u770b\u5230\u5728\u8bbe\u7f6e\u4e4b\u540e<\/p>\n<p>DMS\u8bed\u53e5\u4ece\u6bd4\u4f8b27%\u63d0\u5347\u81f365%.\u6027\u80fd\u63d0\u5347\u975e\u5e38\u5927.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/forum.springsource.org\/showthread &hellip;<\/p>\n<p class=\"read-more\"><a href=\"https:\/\/blog.zhukunqian.com\/?p=162\">\u7ee7\u7eed\u9605\u8bfb &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/162"}],"collection":[{"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=162"}],"version-history":[{"count":2,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/162\/revisions"}],"predecessor-version":[{"id":168,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/162\/revisions\/168"}],"wp:attachment":[{"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}