{"id":101,"date":"2018-04-17T22:05:41","date_gmt":"2018-04-17T14:05:41","guid":{"rendered":"http:\/\/yanzhenhua.top\/?p=101"},"modified":"2018-04-17T22:05:41","modified_gmt":"2018-04-17T14:05:41","slug":"mysql%e9%87%8c%e9%9d%a2%e7%9a%84%e9%94%81%e7%9a%84%e5%87%a0%e7%a7%8d%e5%bd%a2%e5%bc%8f","status":"publish","type":"post","link":"http:\/\/yanzhenhua.top\/?p=101","title":{"rendered":"mysql\u91cc\u9762\u7684\u9501\u7684\u51e0\u79cd\u5f62\u5f0f"},"content":{"rendered":"<p>1\u3001\u4ec0\u4e48\u662f\u9501<br \/>\n\u5c31\u662f\u5bf9\u6570\u636e\u7684\u8bbf\u95ee\u63a7\u5236\u7684\u4e00\u79cd\u6280\u672f<br \/>\n2\u3001mysql\u91cc\u9762\u7684\u9501\u7684\u51e0\u79cd\u5f62\u5f0f<br \/>\n\u5171\u4eab\u9501\uff08\u8bfb\u9501\uff09\uff1a\u52a0\u4e86\u5171\u4eab\u9501\u7684\uff0c\u5927\u5bb6\u90fd\u53ef\u4ee5\u8bfb\u5b83\u3002<br \/>\n\u6392\u5b83\u9501\uff08\u5199\u9501\uff09\uff1a\u52a0\u4e86\u6392\u5b83\u9501\u7684\uff0c\u53ea\u6709\u52a0\u9501\u7684\u8fd9\u4e2a\u4eba\u53ef\u4ee5\u53bb\u8bfb\u5199\u5b83\u3002<\/p>\n<p>\u9501\u7684\u8303\u56f4\uff1a<br \/>\n\u8868\u9501\uff1a\u5c31\u662f\u628a\u4e00\u5f20\u9501\u7ed9\u9501\u4f4f\uff0c\u5c31\u662f\u8868\u9501\u3002myisam\u5f15\u64ce\uff0c\u5b9e\u73b0\u7684\u5c31\u662f\u8868\u9501\u3002\u8868\u9501\u7684\u9897\u7c92\u5927\uff0c\u52a0\u9501\u5feb\uff0c\u5e76\u53d1\u8bbf\u95ee\u4f4e<br \/>\n\u884c\u9501\uff1a\u5c31\u662f\u628a\u4e00\u5f20\u8868\u91cc\u9762\u7684\u4e00\u884c\u9501\u4f4f\uff0c\u5c31\u662f\u884c\u9501\u3002innodb\u5f15\u64ce\uff0c\u5b9e\u73b0\u7684\u5c31\u662f\u884c\u9501\uff0c\u9897\u7c92\u5c0f\uff0c\u52a0\u9501\u6162\uff0c\u5e76\u53d1\u8bbf\u95ee\u9ad8\u3002<\/p>\n<p>\u52a0\u9501\u7684\u65f6\u673a\uff1a<br \/>\n\u60b2\u89c2\u9501\uff1a\u5f53\u6211\u60f3\u4f7f\u7528\u6570\u636e\u7684\u65f6\u5019\uff0c\u6211\u5c31\u8ba4\u4e3a\u522b\u4eba\u6709\u53ef\u80fd\u4f1a\u4f7f\u7528\uff0c\u6211\u5c31\u8d76\u7d27\u52a0\u9501\u3002<br \/>\n\u4e50\u89c2\u9501\uff1a\u5f53\u6211\u60f3\u4f7f\u7528\u6570\u636e\u7684\u65f6\u5019\uff0c\u8ba4\u4e3a\u522b\u4eba\u4e0d\u4f1a\u4f7f\u7528\u3002\u90a3\u6211\u5c31\u4fee\u6539\u7684\u65f6\u5019\u624d\u52a0\u9501\u3002<\/p>\n<p>\u4e50\u89c2\u9501\uff1a<br \/>\n    name  age   version<br \/>\n    \u5c0f\u6210   3      1.0<br \/>\n\u5f53\u6211\u4eec\u4f7f\u7528\u4e50\u89c2\u9501\u7684\u65f6\u5019\uff0c\u60f3\u8981\u53bb\u4fee\u6539\u5b83\u3002\u8fd9\u4e2a\u65f6\u5019\uff0c\u6211\u4eec\u8981\u8bfb\u53d6\u6570\u636e\u51fa\u6765\u3002\u6539\u53d8\u8fd9\u4e9b\u6570\u636e\u3002<br \/>\n\u6539\u53d8\u4e4b\u540e\uff0c\u5c31\u8981\u66f4\u65b0\u3002\u4f46\u662f\u5728\u66f4\u65b0\u4e4b\u524d\u68c0\u67e5\u4e00\u4e0bversion\u53f7\u662f\u5426\u4e00\u81f4\u3002\u4e00\u81f4\u5c31\u66f4\u65b0\u3002\u4e0d\u4e00\u81f4\uff0c\u5c31\u5148\u91cd\u65b0\u83b7\u53d6\u4e00\u4e0b\u6570\u636e\u3002\u7136\u540e\u4fee\u6539\u6570\u636e\u5728\u66f4\u65b0\u3002<\/p>\n<p>\u9501\u51b2\u7a81\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/ff9987699c05187d5ec363bdcbcf9069.png\" alt=\"\" \/><br \/>\n\u8bf4\u660e\uff1a<br \/>\n\u5f53\u524d\u7528\u6237\u8fdb\u884c\u52a0\u9501\u7684\u65f6\u5019\uff0c\u5176\u5b83\u7528\u6237\u52a0\u9501\u4f1a\u51fa\u73b0\u9501\u7b49\u5f85\u7684\u60c5\u51b5\u3002<\/p>\n<p>\u5e76\u53d1\u8bbf\u95ee\u7684\u60c5\u51b5\uff1a<br \/>\nA \uff1a\u5bf9ID\u662f1\u7684\u52a0\u9501\uff0c\u6267\u884c\u8bbf\u95eeID\u662f2\u7684\uff0c\u51fa\u73b0\u9501\u7b49\u5f85<br \/>\nB \uff1a\u5bf9ID\u662f2\u7684\u52a0\u9501\uff0c\u6267\u884c\u8bbf\u95eeID\u662f1\u7684\uff0c\u51fa\u73b0\u9501\u7b49\u5f85<br \/>\n\u8fd9\u4e2a\u5c31\u662f\u9501\u51b2\u7a81\u3002<\/p>\n<p>3\u3001\u8868\u9501myisam\u5f15\u64ce<br \/>\n\u8bfb\u9501\uff1a<br \/>\n    \u5f00\u59cb\u52a0\u9501\uff1alock tables table_name read<br \/>\n    \u89e3\u9501\uff1aunlock tables<\/p>\n<p>\u5199\u9501\uff1a<br \/>\n    \u5f00\u59cb\u52a0\u9501\uff1alock tables table_name write<br \/>\n    \u89e3\u9501\uff1aunlock tables<\/p>\n<p>\u51c6\u5907\u597d\u4e8c\u4e2a\u4eba\uff1a<br \/>\n\u5212\u5206\u4eba\u7684\u65f6\u5019\uff0c\u4e0d\u662f\u4ee5\u7528\u6237\u540d\u6765\u5212\u5206\u7684\uff0c\u8fd8\u662f\u4ee5session\uff08\u8fdb\u7a0b\uff09\u6765\u5212\u5206\u3002<\/p>\n<p>\u5b9e\u73b0\u8bfb\u9501\uff1amyisam<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/671dc91b249d82ee2fa46fb90f645b02.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u8bfb\u64cd\u4f5c\uff1a\u53ef\u4ee5\u8bfb<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/31d5b627dfaa71444cdb61659a84fa94.png\" alt=\"\" \/><br \/>\n\u5176\u5b83\u8fdb\u7a0b\u8bfb\u64cd\u4f5c\uff1a\u53ef\u4ee5\u8bfb<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/aa190091820ead0fb3df7ee52c43fd67.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u5199\u64cd\u4f5c\uff1a\u4e0d\u53ef\u8fdb\u884c\u5199\u64cd\u4f5c<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/2bcaabd123ea53231d1bb2ca1c62b343.png\" alt=\"\" \/><br \/>\n\u5176\u5b83\u8fdb\u7a0b\u5199\u64cd\u4f5c\uff1a\u51fa\u73b0\u4e86\u9501\u7b49\u5f85\uff01<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/7e2bcb6d6bba7ed911f7499fe3ff3d48.png\" alt=\"\" \/><br \/>\n\u89e3\u9501\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/d33f6f90a606aea4edd8c9dfe90258a7.png\" alt=\"\" \/><br \/>\n\u5176\u5b83\u8fdb\u7a0b\uff1a\u89e3\u9501\u4e4b\u540e\uff0c\u5176\u5b83\u8fdb\u7a0b\u8fdb\u884c\u4e86\u64cd\u4f5c\uff01<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/92e450b29c2c897771f21aecebbdf33b.png\" alt=\"\" \/><br \/>\n\u8bfb\u9501\u7684\u65f6\u5019\uff1a\u5f53\u524d\u8fdb\u7a0b\u4e0e\u5176\u5b83\u8fdb\u7a0b\uff0c\u53ef\u4ee5\u64cd\u4f5c\u8bfb\uff1b\u5f53\u524d\u8fdb\u7a0b\u4e0e\u5176\u5b83\u8fdb\u7a0b\uff0c\u90fd\u4e0d\u53ef\u4ee5\u64cd\u4f5c\u5199\u3002<br \/>\n\u5199\u9501\u7684\u5b9e\u8df5\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/dba24d3c901ade4080dd7bb558377fa7.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u8bfb\u64cd\u4f5c\uff1a\u53ef\u4ee5\u64cd\u4f5c<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/56aa2a0cef0fbdc1737508fd96b02a9a.png\" alt=\"\" \/><br \/>\n\u5176\u5b83\u8fdb\u7a0b\u8bfb\u64cd\u4f5c\uff1a\u9501\u7b49\u5f85<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/36ade7364504e8790848d472770bc536.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u5199\u64cd\u4f5c\uff1a\u66f4\u65b0\u6210\u529f<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/1d7893aac7013eea2d244914f43a4cea.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u5199\u64cd\u4f5c\uff1a\u66f4\u65b0\u6210\u529f<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/1d7893aac7013eea2d244914f43a4cea.png\" alt=\"\" \/><br \/>\n\u5176\u5b83\u8fdb\u7a0b\u5199\u64cd\u4f5c\uff1a\u9501\u7b49\u5f85<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/59acc4508dbbc4c5ac62a23cb25bbbe3.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u64cd\u4f5c\u6ca1\u6709\u9501\u7684\u8868\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/1268860aa0ac5e98f561ddf587f2eeac.png\" alt=\"\" \/><br \/>\n\u5f53\u4f60\u6709\u9501\u7684\u65f6\u5019\uff0c\u53ea\u80fd\u64cd\u4f5c\u6709\u9501\u7684\u8868\uff01<br \/>\n\u5f53\u524d\u8fdb\u7a0b\u89e3\u9501\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/c0fb2c6c79cebb7e9de3be0170fc1ed6.png\" alt=\"\" \/><br \/>\n\u603b\u7ed3\uff1a\u5199\u9501\u7684\u65f6\u5019\uff0c\u5f53\u524d\u8fdb\u7a0b\u662f\u53ef\u8bfb\u53ef\u5199\u7684\uff1b\u5176\u5b83\u8fdb\u7a0b\u662f\u4e0d\u80fd\u5199\u4e5f\u4e0d\u80fd\u8bfb\u7684\u3002<\/p>\n<p>4\u3001\u884c\u9501innodb\u5f15\u64ce<br \/>\n\u4e8b\u52a1\uff08Transaction\uff09\u53ca\u5176ACID\u5c5e\u6027\uff1a<br \/>\n\u539f\u5b50\u6027\uff08Atomicity\uff09\uff1a\u4e8b\u52a1\u662f\u4e00\u4e2a\u539f\u5b50\u64cd\u4f5c\u5355\u5143\uff0c\u5176\u5bf9\u6570\u636e\u7684\u4fee\u6539\uff0c\u8981\u4e48\u5168\u90fd\u6267\u884c\uff0c\u8981\u4e48\u5168\u90fd\u4e0d\u6267\u884c\u3002<br \/>\n\u4e00\u81f4\u6027\uff08Consistent\uff09\uff1a\u4e8b\u52a1\u5f00\u59cb\u548c\u5b8c\u6210\uff0c\u6570\u636e\u90fd\u5fc5\u987b\u4fdd\u6301\u4e00\u81f4\u72b6\u6001\u3002\u8fd9\u610f\u5473\u7740\u6240\u6709\u76f8\u5173\u7684\u6570\u636e\u89c4\u5219\u90fd\u5fc5\u987b\u5e94\u7528\u4e8e\u4e8b\u52a1\u7684\u4fee\u6539\uff0c\u4ee5\u4fdd\u6301\u6570\u636e\u7684\u5b8c\u6574\u6027\uff1b\u4e8b\u52a1\u7ed3\u675f\u65f6\uff0c\u6240\u6709\u7684\u5185\u90e8\u6570\u636e\u7ed3\u6784\u4e5f\u90fd\u5fc5\u987b\u662f\u6b63\u786e\u7684\u3002<br \/>\n\u9694\u79bb\u6027\uff08Isolation\uff09\uff1a\u6570\u636e\u5e93\u7cfb\u7edf\u63d0\u4f9b\u4e00\u5b9a\u7684\u9694\u79bb\u673a\u5236\uff0c\u4fdd\u8bc1\u4e8b\u52a1\u5728\u4e0d\u53d7\u5916\u90e8\u5e76\u53d1\u64cd\u4f5c\u5f71\u54cd\u7684\u201c\u72ec\u7acb\u201d\u73af\u5883\u6267\u884c\u3002\u8fd9\u610f\u5473\u7740\u4e8b\u52a1\u5904\u7406\u8fc7\u7a0b\u4e2d\u7684\u4e2d\u95f4\u72b6\u6001\u5bf9\u5916\u90e8\u662f\u4e0d\u53ef\u89c1\u7684\uff0c\u53cd\u4e4b\u4ea6\u7136\u3002<br \/>\n\u6301\u4e45\u6027\uff08Durable\uff09\uff1a\u4e8b\u52a1\u5b8c\u6210\u4e4b\u540e\uff0c\u5b83\u5bf9\u4e8e\u6570\u636e\u7684\u4fee\u6539\u662f\u6c38\u4e45\u6027\u7684\uff0c\u5373\u4f7f\u51fa\u73b0\u7cfb\u7edf\u6545\u969c\u4e5f\u80fd\u591f\u4fdd\u6301\u3002<\/p>\n<p>\u4e8b\u52a1\u91cc\u9762\u64cd\u4f5c\uff1a<br \/>\n\u5f00\u59cb\u4e8b\u52a1\uff1a<br \/>\n    begin\uff1a<br \/>\n\u7ed3\u675f\u4e8b\u52a1\uff1a<br \/>\n    commit\uff1a<\/p>\n<p>\u8bfb\u9501\uff1asql + lock in share mode<\/p>\n<p>\u5199\u9501\uff1asql + for update<\/p>\n<p>\u8bfb\u9501\u7684\u5b9e\u8df5\uff1a<br \/>\n\u5f00\u59cb\u4e8b\u52a1\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/fce6079721680184ef35a320318f8f6f.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u8bfb\u9501\uff1a\u52a0\u4e86\u8bfb\u9501<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/b569f90b1d72cece4b0e4bb5a56386fd.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u5bf9id\u662f2\u7684\u52a0\u4e86\u8bfb\u9501\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/9c6c36db57b361efcfe40357e70823fb.png\" alt=\"\" \/><br \/>\n\u5176\u5b83\u8fdb\u7a0b\u5bf9id\u662f2\u7684\u52a0\u8bfb\u9501\uff1a\u53ef\u4ee5\u64cd\u4f5c\u7684\u3002<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/eb6ff073670c97651fced6e6b30f7cd4.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u5bf9id\u662f2\u7684\u8fdb\u884c\u66f4\u65b0\uff1a\u5f53\u524d\u8fdb\u7a0b\u53ef\u4ee5\u66f4\u65b0\u6210\u529f\uff01<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/ab548b17564bfbd0b718f121b2d2c07e.png\" alt=\"\" \/><br \/>\n\u5176\u5b83\u8fdb\u7a0b\u5bf9id\u662f2\u7684\u8fdb\u884c\u8bfb\u9501\u64cd\u4f5c\uff1a\u53ea\u8981\u5f53\u524d\u8fdb\u7a0b\u66f4\u65b0\uff0c\u5c31\u8f6c\u6210\u4e86\u5199\u9501\u4e86\u3002<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/77084775406ae841fe85f4db6419ad5c.png\" alt=\"\" \/><br \/>\n\u5f53\u524d\u8fdb\u7a0b\u5bf9id\u662f2\u7684\u8bfb\u64cd\u4f5c\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/ce06534ba9d3d28949e2bab863c95f23.png\" alt=\"\" \/><br \/>\n\u89e3\u9501\uff1a\u63d0\u4ea4\u4e8b\u52a1\uff01<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/0771641b50eddd364aba5eee8e26fc26.png\" alt=\"\" \/><br \/>\n\u603b\u7ed3\uff1aInnodb\u5f15\u64ce\u7684\u884c\u9501\uff0c\u5728\u8bfb\u9501\u7684\u65f6\u5019\uff0c\u662f\u5f53\u524d\u8fdb\u7a0b\u53ef\u4ee5\u8bfb\u7684\uff0c\u5176\u5b83\u8fdb\u884c\u53ef\u4ee5\u8bfb\u7684\u3002\u4f46\u662f\u5f53\u524d\u8fdb\u7a0b\u53ef\u4ee5\u8fdb\u884c\u4fee\u6539\uff0c\u4fee\u6539\u4e4b\u540e\uff0c\u5c31\u9ed8\u8ba4\u4f1a\u4fee\u6539\u6210\u5199\u9501\uff1b\u5176\u5b83\u8fdb\u7a0b\u5c31\u4e0d\u80fd\u8bfb\u5199\u4e86\u3002<\/p>\n<p>\u5f00\u59cb\u4e8b\u52a1\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/1a64392a943f9229b3abae9d83ab77fc.png\" alt=\"\" \/><br \/>\n\u6267\u884c\u4e0a\u9762\u7684\u5bf918\u52a0\u4e0a\u4e00\u4e2a\u5199\u9501\uff1a\u5f53\u524d\u8fdb\u7a0b<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/68136f8c7210370230f26ad4be31ab3f.png\" alt=\"\" \/><br \/>\n\u6267\u884c\u4e0a\u9762\u7684\u5bf9\u975e18\u52a0\u4e00\u4e2a\u8bfb\u9501\uff1a\u5176\u5b83\u8fdb\u7a0b<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/6cd3f6bd154ff52fec0c3abc29c0e373.png\" alt=\"\" \/><br \/>\n\u5176\u5b83\u8fdb\u7a0b\uff0c\u67e5\u8be2\u6210\u529f\uff0c\u5c31\u9a8c\u8bc1\u4e86innodb\u5f15\u64ce\uff0c\u52a0\u9501\u786e\u5b9a\u662f\u9700\u8981\u7d22\u5f15\u7684\uff01<br \/>\ninnodb\u603b\u7ed3\uff1aInnodb\u662f\u6709\u6761\u4ef6\u7684\u884c\u9501\uff0c\u5f53\u4f7f\u7528\u7d22\u5f15\u7684\u5b57\u6bb5\u503c\u7684\u65f6\u5019\uff0c\u624d\u80fd\u52a0\u4e0a\u884c\u9501\uff0c\u975e\u7d22\u5f15\u5b57\u6bb5\u52a0\u7684\u662f\u8868\u9501\u3002<br \/>\n\u8868\u9501\u662fmysql\u670d\u52a1\u5668\u5b9e\u73b0\u7684\uff0c\u4e0d\u662finnodb\u5f15\u64ce\u5b9e\u73b0\u7684\u3002\u6240\u6709\u5f53\u6709\u8868\u9501\u51b2\u7a81\u7684\u65f6\u5019\uff0c\u6211\u4eec\u7684innodb\u5f15\u64ce\u6ca1\u6709\u529e\u6cd5\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002<br \/>\n\u884c\u9501\u51b2\u7a81\u7684\u65f6\u5019\uff0cinnodb\u5f15\u64ce\u4f1a\u81ea\u52a8\u5e2e\u52a9\u6211\u4eec\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff01<\/p>\n<p>\u5f53\u6211\u4eec\u4f7f\u7528\u8303\u56f4\u7684\u65f6\u5019\u3002\u53ea\u8981\u8303\u56f4\u7684\u90fd\u4f1a\u88ab\u52a0\u9501\uff01<\/p>\n<p>5\u3001php\u5b9e\u73b0\u9501<br \/>\n\u9700\u6c42\uff1a\u628a\u6211\u4eec\u7684\u8bbf\u95ee\u4eba\u6570\uff0c\u7edf\u8ba1\u5230\u6211\u4eec\u8868\u91cc\u9762\uff01<br \/>\n1\uff09\u521b\u5efa\u4e00\u5f20\u8868\uff0c\u8bb0\u5f55\u4eba\u6570\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/3e155bce2d0a9f2801bd826897a0bd77.png\" alt=\"\" \/><br \/>\nnum\u5b57\u6bb5\u5c31\u662f\u628a\u6211\u4eec\u6709\u591a\u5c11\u4eba\u8bbf\u95ee\uff0c\u628a\u7edf\u8ba1\u7684\u7ed3\u679c\uff0c\u5b58\u50a8\u5728\u8fd9\u91cc\uff01<br \/>\n2\uff09\u63d0\u524d\u6570\u636e\u9884\u70ed\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/3415ea36f817e9a3a8eea99599fd63f1.png\" alt=\"\" \/><br \/>\n\u67e5\u770b\u4e00\u4e0b\u6570\u636e\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/bb05aebd2047f53da58f0c2736d1a5d1.png\" alt=\"\" \/><br \/>\n\u5f88\u591a\u65f6\u5019\uff0c\u6211\u4eec\u90fd\u9700\u8981\u628a\u6570\u636e\u63d0\u524d\u9884\u70ed\uff1b\u56e0\u4e3a\u6211\u4eec\u7684\u8bbf\u95ee\u4e00\u4f46\u6765\u4e86\uff0c\u8fd9\u4e2a\u65f6\u5019\uff0c\u6211\u4eec\u6ca1\u6709\u51c6\u5907\u597d\u6570\u636e\uff0c\u5c31\u53ea\u80fd\u8ba9mysql\u670d\u52a1\u5668\u786c\u6297\uff0c\u6297\u4e0d\u4f4f\u7684\u3002<br \/>\n3\uff09\u4ee3\u7801\u5b9e\u73b0\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/fa85754e15ba4a1ca34b7394e840f74c.png\" alt=\"\" \/><br \/>\n\u8bf4\u660e\uff1a\u6211\u4eec\u7684Mysql\u670d\u52a1\u5668\u5728\u6211\u4eec\u67e5\u8be2\u7684\u65f6\u5019\u3002\u4f1a\u81ea\u52a8\u52a0\u8bfb\u9501\uff1b\u4fee\u6539\u6570\u636e\u5e93\u7684\u6570\u636e\u64cd\u4f5c\u7684\u65f6\u5019\uff0c\u90fd\u4f1a\u81ea\u52a8\u52a0\u5199\u9501\u7684\uff01<\/p>\n<p>\u591a\u6761sql\u8bed\u53e5\u7684\u64cd\u4f5c\uff0c\u90fd\u5e94\u8be5\u81ea\u5df1\u53bb\u52a0\u9501\uff01<\/p>\n<p>4\uff09\u6a21\u62dfN\u591a\u4eba\u5e76\u53d1\u8bbf\u95ee\uff1a<br \/>\nab \u5c31\u662f\u4e00\u4e2a\u5e76\u53d1\u8f6f\u4ef6\uff0c\u53ef\u4ee5\u6a21\u62df\u5f88\u591a\u4eba\uff0c\u540c\u65f6\u5411\u4e00\u53f0\u670d\u52a1\u5668\u53d1\u8d77\u8bf7\u6c42\uff01<\/p>\n<p>ab  -n \u603b\u6570  -c \u5e76\u53d1\u6570  url\u5730\u5740<\/p>\n<pre class=\"line-numbers prism-highlight\" data-start=\"1\"><code class=\"language-null\">\/working\/httpd-2.4.29\/bin\/ab -n 500 -c 100 http:\/\/127.0.0.1\/lock.php\n<\/code><\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/b4fde503b94e21eefc8d78c145f19f91.png\" alt=\"\" \/><br \/>\n\u67e5\u770b\u6570\u636e\u5e93\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/7977e7f17d52c6e653ae282a029e196f.png\" alt=\"\" \/><br \/>\n\u518d\u6765\u5e76\u53d1\uff1a<\/p>\n<pre class=\"line-numbers prism-highlight\" data-start=\"1\"><code class=\"language-null\">\/working\/httpd-2.4.29\/bin\/ab -n 500 -c 50 http:\/\/127.0.0.1\/lock.php\n<\/code><\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/448cae9458ff2f744bb92209e8d8cf62.png\" alt=\"\" \/><br \/>\n\u67e5\u770b\u6570\u636e\u5e93\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/9bb2abc70b2bd913583059b312709b55.png\" alt=\"\" \/><br \/>\n5\uff09\u5b9e\u73b0\u52a0\u9501\u529f\u80fd\uff0c\u8ba9\u6211\u4eec\u7684\u8bf7\u6c42\u5b9e\u73b0\u6211\u4eec\u7684\u6548\u679c\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/10ea3fc1f6f622e381b6f27abf6ab163.png\" alt=\"\" \/><br \/>\nab\u538b\u529b\u6d4b\u8bd5\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/8d3ac4cfefa192b64e62db25ff05bfce.png\" alt=\"\" \/><br \/>\n\u67e5\u770b\u6570\u636e\u5e93\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/19bc9b80f8edf40f1607b015e4038f98.png\" alt=\"\" \/><br \/>\n\u7ed3\u679c\u975e\u5e38\u7684\u6ee1\u8db3\uff01<\/p>\n<p>6\u3001\u6587\u4ef6\u9501\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/7b66ba352bdd13c2479daef010ee9d6c.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/a3bc7d7db97d944d875d6bfbe82b1bbb.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/4fcbd964644d3cab84ac0b1a35b9afeb.png\" alt=\"\" \/><br \/>\nab\u6d4b\u8bd5\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/1fb8cbb5a10fdcdd363db887261d8814.png\" alt=\"\" \/><br \/>\n\u67e5\u770b\u6570\u636e\uff1a<br \/>\n<img decoding=\"async\" src=\"http:\/\/yanzhenhua.top\/wp-content\/uploads\/2018\/04\/36cc796505842ca9879505c053946bf5.png\" alt=\"\" \/><br \/>\n\u6211\u4eec\u7684\u6587\u4ef6\u9501\uff0c\u4e5f\u53ef\u4ee5\u5b9e\u73b0\u6211\u4eec\u7684\u6548\u679c\uff01\u975e\u5e38\u7684\u68d2\u7684\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u4ec0\u4e48\u662f\u9501 \u5c31\u662f\u5bf9\u6570\u636e\u7684\u8bbf\u95ee\u63a7\u5236\u7684\u4e00\u79cd\u6280\u672f 2\u3001mysql\u91cc\u9762\u7684\u9501\u7684\u51e0\u79cd\u5f62\u5f0f \u5171\u4eab\u9501\uff08\u8bfb\u9501\uff09\uff1a\u52a0\u4e86&hellip; <a href=\"http:\/\/yanzhenhua.top\/?p=101\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">mysql\u91cc\u9762\u7684\u9501\u7684\u51e0\u79cd\u5f62\u5f0f<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":{"0":"post-101","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-mysql","7":"h-entry","9":"h-as-article"},"_links":{"self":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts\/101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=101"}],"version-history":[{"count":0,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts\/101\/revisions"}],"wp:attachment":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}