{"id":137,"title":"\u4e8b\u52a1","good":0,"bad":0,"hit":2053,"created_at":"2014-12-23 15:51:46","content":"<p><strong>\u4e8b\u7269\uff08transaction)<\/strong><br\/><span style=\"color: rgb(255, 0, 0);\">\u6ce8\u610f\uff1a\u4e8b\u7269\u7c7b\u4f3c\u5916\u952e\u7ea6\u4e8b\uff0c\u53ea\u88abinnodb\u5f15\u64ce\u652f\u6301\uff1b<\/span><br\/>\u4e00\u7ec4sql\u7684\u96c6\u5408\uff0c\u8981\u4e48\u90fd\u6267\u884c\u6210\u529f\uff0c\u8981\u4e48\u90fd\u5931\u8d25\uff0c\u5931\u8d25\u65f6\uff0c\u751f\u6210\u7684\u5f71\u54cd\u9000\u56de\u5230\u6267\u884csql\u4e4b\u524d\u7684\u72b6\u6001\u3002<br\/>\u5f80\u5f80\u4e00\u4e2a\u4e1a\u52a1\u903b\u8f91\uff0c\u662f\u7531\u591a\u6761\u8bed\u53e5\u7ec4\u5408\u5b8c\u6210\u7684\u3002\u5982\u94f6\u884c\u6c47\u6b3e\uff0ca\u5411b\u6c47\u4e00\u5343\u5757\u94b1\uff0c\u5219a\u51cf\u4e00\u5343b\u52a0\u4e00\u5343\uff1b\u5fc5\u987b\u4fdd\u8bc1\u4e24\u8005\u90fd\u6210\u529f\u6267\u884c\u624d\u751f\u6548\u3002<br\/><br\/><strong>\u8bed\u6cd5\uff1a<\/strong><br\/>1\u5f00\u542f\u4e8b\u52a1\uff1astart transaction\u53ef\u4ee5\u7b80\u5199\u6210begin; \u4e00\u65e6\u5f00\u542f\u5c06\u4f1a\u8bb0\u5f55\u4e4b\u540e\u6240\u6267\u884c\u7684\u6240\u6709sql<br\/>2\u63d0\u4ea4\uff1acommit \u5982\u679c\u6240\u6709\u7684sql\u90fd\u6267\u884c\u6210\u529f\uff0c\u5219\u63d0\u4ea4\uff0c\u5c06sql\u7684\u6267\u884c\u7ed3\u679c\u6301\u4e45\u5316\u5230\u6570\u636e\u8868\u4e2d\uff1b<br\/>3\u56de\u6edarollback \u5982\u679c\u5b58\u5728\u5931\u8d25\u7684sql\u5219\u9700\u8981\u56de\u6eda\u3002\u5c06sql\u7684\u6267\u884c\u7ed3\u679c\u9000\u56de\u5230\u4e8b\u52a1\u5f00\u59cb\u4e4b\u524d\u3002<br\/><br\/>\u65e0\u8bba\u662f\u56de\u6eda\u8fd8\u662f\u63d0\u4ea4\uff0c\u90fd\u4f1a\u5173\u95ed\u4e8b\u52a1\u3002\u9700\u8981\u518d\u6b21\u5f00\u542f\u624d\u80fd\u4f7f\u7528\uff1b <br\/>\u63d0\u9192\uff1a\u5728\u6ca1\u6709commit\u524d\uff0c\u5728\u5f53\u524d\u547d\u4ee4\u884c\u7a97\u53e3\u67e5\u8be2\u6267\u884c\u7684sql\u8bed\u53e5\u770b\u8d77\u6765\u662f\u751f\u6548\u7684\uff0c\u4f46\u662f\u5728\u65b0\u547d\u4ee4\u884c\u5ba2\u4e32\u4e0b\u770b\u5230\u7684\u662f\u6ca1\u6709\u751f\u6548\u7684\u3002\u53ea\u6709\u5f53commit\u6210\u529f\u540e\uff0c\u6240\u6709\u547d\u4ee4\u884c\u7a97\u53e3\u4e2d\u770b\u5230\u7684\u7ed3\u679c\u624d\u662f\u4e00\u6837\u7684\u3002<br\/><br\/><br\/><strong>\u4e8b\u7269\u7684\u57fa\u672c\u539f\u7406<\/strong><br\/>commit\u5c31\u4f1a\u5c06\u7ed3\u679c\u6301\u4e45\u5316\uff0c\u4e0d\u63d0\u4ea4\u4e0d\u4f1a\u3002<br\/>\u5982\u679c\u4e0d\u5f00\u542f\u4e8b\u52a1\uff0c\u6267\u884c\u4e00\u6761sql\u9a6c\u4e0a\u5c31\u4f1a\u6301\u4e45\u5316\u6570\u636e\u3002<br\/>\u53ef\u89c1\uff0c\u666e\u901a\u7684\u6267\u884c\u5c31\u662f\u7acb\u5373\u63d0\u4ea4\u3002<br\/>\u56e0\u4e3a\u9ed8\u8ba4\u7684mysql\u5bf9sql\u8bed\u53e5\u7684\u6267\u884c\u662f\u81ea\u52a8\u63d0\u4ea4\u7684\u3002<br\/>\u5f00\u542f\u4e8b\u52a1\u5176\u5b9e\u5c31\u662f\u5173\u95ed\u4e86\u81ea\u52a8\u63d0\u4ea4\u7684\u529f\u80fd\u3002\u6539\u6210\u4e86commit\u6267\u884c\u624b\u52a8\u63d0\u4ea4\u3002<br\/>\u56e0\u6b64\uff0c\u53ef\u4ee5\u901a\u8fc7\u5bf9\u662f\u5426\u81ea\u52a8\u63d0\u4ea4\u52a0\u4ee5\u8bbe\u7f6e\uff0c\u53ef\u4ee5\u5b8c\u6210\u5f00\u542f\u4e8b\u52a1\u7684\u76ee\u7684\u3002<br\/>\u81ea\u52a8\u63d0\u4ea4\u7684\u7279\u5f81\u662f\u4fdd\u5b58\u5728\u670d\u52a1\u7684\u4e00\u4e2a\u53eb\u505aautocommit\u7684\u4e00\u4e2a\u53d8\u91cf\u5185\u7684\u3002<br\/>\u53ef\u4ee5\u4f7f\u7528set autocommit=0\u62161 \u8fdb\u884c\u5173\u95ed\u81ea\u52a8\u63d0\u4ea4\u6216\u8005\u5f00\u542f\u81ea\u52a8\u63d0\u4ea4\u3002<br\/><br\/><strong>\u4e8b\u7269\u7684\u7279\u70b9\uff0cACID<\/strong><br\/><strong>1\u3001\u539f\u5b50\u6027 atomicity<\/strong>\uff1a \u4e8b\u7269\u662f\u4e0d\u53ef\u5206\u5272\u7684\uff1b<\/p><p><br\/><strong>2\u3001\u4e00\u81f4\u6027 consistency<\/strong>\uff1a\u4fdd\u8bc1\u6570\u636e\u5728\u4e8b\u52a1\u6267\u884c\u5468\u671f\u5185\u662f\u4e00\u81f4\u7684\uff1b<br\/><span style=\"color: rgb(255, 0, 0);\">\u901a\u8fc7\u8fd9\u6837\u7684\u4f8b\u5b50\u6765\u7406\u89e3\uff1a<br\/>\u5047\u8bbe\u6709\u4e09\u4e2a\u7528\u6237\u5728\u4e0d\u540c\u7684\u7535\u8111\u4e0a\u540c\u65f6\u64cd\u4f5cstudent\u8868\u4e2d\u7684\u4e00\u6761\u8bb0\u5f55\uff0c\u5047\u8bbe\u8fd9\u6761\u8bb0\u5f55\u662f\u8fd9\u6837\u7684<br\/>id-&gt;10 money-&gt;9999;<br\/>a\u7528\u6237\u6267\u884c\u5982\u4e0b\u64cd\u4f5c\uff1a<br\/>start transaction;<br\/>update stuedent set money=10000 where id=10;<br\/>\u5728\u6572commit\u524d\uff0cb\u7528\u6237\u6267\u884c\u4e86\u8fd9\u6837\u4e00\u6761\u8bed\u53e5\uff1a<br\/>update student set money=2222 where id=10;(\u7531\u4e8ea\u7528\u6237\u5f00\u542f\u4e86transation,\u6b64\u65f6b\u7528\u6237\u6572\u56de\u8f66\u65f6\uff0c\u547d\u4ee4\u884c\u4e2d\u663e\u793a\u7684\u4e0d\u662fquery ok\u8fd9\u6837\u7684\u63d0\u793a\uff0c\u800c\u662f\u5149\u6807\u95ea\u70c1\uff0c\u5904\u4e8e\u7b49\u5f85\u72b6\u6001\uff09\uff1b<br\/>\u6b64\u65f6a\u7528\u6237\u518d\u8f93\u5165commit\u63d0\u4ea4\u540e\uff0cb\u7528\u6237\u7684\u547d\u4ee4\u884c\u7a97\u53e3\u4e2d\u624d\u4f1a\u663e\u793a\u51faquery ok; <br\/>\u6700\u540e\uff0c\u5f53c\u7528\u6237\u5728\u81ea\u5df1\u7684\u7535\u8111\u4e0a\u6572\u5165select * from student where id=10;\u4f1a\u663e\u793a10000\u8fd8\u662f2222\u5462\uff1f<br\/>\u7ed3\u679c\u662f\uff1a2222<br\/>\u56e0\u4e3a\u5bf9\u4e8b\u7269\u6765\u8bb2\uff0c\u4e00\u65e6\u5f00\u542f\uff0c\u5728\u6ca1\u6709\u63a5\u6536\u5230commit\u65f6\uff0c\u6570\u636e\u4e0d\u4f1a\u6301\u4e45\u5316\u4fdd\u5b58\uff0c\u867d\u7136a\u7528\u6237\u60f3\u5c06money\u66f4\u65b0\u4e3a10000\u4f46\u662f\u968f\u540eb\u7528\u6237\u53c8\u5c06money\u66f4\u65b0\u4e3a\u4e862222\uff1b\u867d\u7136\u4ed6\u4eec\u5728\u4e0d\u540c\u7684\u7535\u8111\u4e0a\uff0c\u4f46\u662f\u670d\u52a1\u5668\u6700\u7ec8\u63a5\u6536\u5230\u7684\u662f\u8fd9\u6837\u7684\uff1a<br\/>a\u7528\u6237\uff1astrart transaction;<br\/>a\u7528\u6237\uff1aupdate student set money=10000 where id=10;<br\/>b\u7528\u6237\uff1aupdate student set money=2222&nbsp; where id=10;<br\/>a\u7528\u6237\uff1acommit;<br\/>c\u7528\u6237: select * from student where id=10;<\/span><\/p><p><br\/><strong>3\u3001\u9694\u79bb\u6027<\/strong> isolation<br\/>\u591a\u4e2a\u4e8b\u52a1\u4e4b\u95f4\u7684\u5e72\u6270\u5173\u7cfb\uff0c\u4f53\u73b0\u5728\u9694\u79bb\u7ea7\u522b\u4e0a\uff1b<\/p><p><br\/><strong>4\u3001\u6301\u4e45\u6027<\/strong> durability<br\/>\u4e8b\u52a1\u4e00\u65e6\u88ab\u63d0\u4ea4\uff0c\u5c31\u4e0d\u53ef\u80fd\u518d\u88ab\u56de\u6eda\u3002<\/p>"}