{"id":57,"date":"2011-02-09T08:53:17","date_gmt":"2011-02-09T00:53:17","guid":{"rendered":"http:\/\/down.cdhaha.net\/?p=57"},"modified":"2011-02-09T08:53:17","modified_gmt":"2011-02-09T00:53:17","slug":"mysql-community-server","status":"publish","type":"post","link":"http:\/\/down.cdhaha.net\/?p=57","title":{"rendered":"MySQL Community Server 5.1.5.5"},"content":{"rendered":"

\"mysql\"<\/a>MySQL\u662f\u73b0\u5728\u6700\u6d41\u884c\u7684\u5f00\u653e\u6e90\u4ee3\u7801\u6570\u636e\u5e93.\u7edd\u5927\u591a\u6570PHP\u7f51\u7ad9\u7684\u6570\u636e\u5e93\u540e\u53f0\u90fd\u662f\u91c7\u7528\u8fd9\u4e00\u6570\u636e\u5e93.\u662f\u4e00\u4e2a\u591a\u7ebf\u7a0b\u7684,\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\uff08SQL\uff09\u6570\u636e\u5e93\u670d\u52a1\u5668.MySQL \u7684\u6267\u884c\u6027\u80fd\u975e\u5e38\u9ad8,\u8fd0\u884c\u901f\u5ea6\u975e\u5e38\u5feb,\u5e76\u975e\u5e38\u5bb9\u6613\u4f7f\u7528.\u662f\u4e00\u4e2a\u975e\u5e38\u6367\u7684\u6570\u636e\u5e93.<\/p>\n

\u8fd1\u65e5\uff0c\u5173\u4e8eOracle\u6536\u8d2dSun\u540eMySQL\u5c06\u5982\u4f55\u53d1\u5c55\u7684\u95ee\u9898\u53ef\u8c13\u662f\u70ed\u70b9\u65b0\u95fb\uff0c\u5f88\u9ad8\u5174\u80fd\u591f\u770b\u5230\u8fd9\u4e2a\u65f6\u5019mysql\u8fd8\u80fd\u51fa\u4e2a\u65b0\u7248 \u672c\uff0c\u800c\u539f\u6765\u7684 MySQL 5.4 \u5728\u5b98\u7f51\u4e0a\u5df2\u7ecf\u6ca1\u6709\u94fe\u63a5\uff0c\u770b\u6765\u662f\u5347\u7ea7\u4e3a 5.5 \u7248\u672c\u4e86\uff0c\u5b98\u7f51\u4e0a\u540c\u65f6\u8fd8\u63d0\u4f9b\u4e00\u4e2a\u4ece 5.4 \u5347\u7ea7\u5230 5.5 \u7684\u6307\u5357\u3002MySQL 5.5.0\u662f\u6240\u8c13\u7684\u91cc\u7a0b\u7891\u7248\u672c\uff0c\u8fd9\u6b21\u5e26\u6765\u4e86\u4e00\u4e9b\u6709\u8da3\u7684\u4e1c\u897f\uff0c\u6309\u7167\u91cd\u8981\u7a0b\u5ea6\uff08\u6211\u4e3b\u89c2\u4e0a\u7684\uff09\u5217\u4e00\u4e0b:
\n
\n * \u652f\u6301\u534a\u540c\u6b65\u590d\u5236\uff0c\u8fd9\u4e2a\u662f\u4ece\u65e9\u671fgoogle \u7684semi-sync patch\u8f6c\u8fc7\u6765\u7684\uff0c\u80fd\u591f\u505a\u5230master-slave\u7684\u534a\u540c\u6b65\u590d\u5236
\n * \u96c6\u6210Innodb plugin 1.0.6
\n * \u652f\u6301 SQL \u6807\u51c6 SIGNAL \u548c RESIGNAL \u8bed\u53e5
\n * \u589e\u5f3aXML\u529f\u80fd\uff0c\u652f\u6301 LOAD XML \u8bed\u53e5
\n * \u53ef\u901a\u8fc7 ALTER TABLE … TRUNCATE PARTITION \u6765\u5220\u9664\u67d0\u4e2a\u8868\u5728\u67d0\u4e2a\u5206\u533a\u4e0a\u7684\u6240\u6709\u6570\u636e
\n * \u589e\u52a0\u4e86 TO_SECONDS \u51fd\u6570
\n * \u65b0\u7684 partition\u8bed\u6cd5
\n * Key caches are now supported for indexes on partitioned MyISAM tables, using the CACHE INDEX and LOAD INDEX INTO CACHE statements<\/p>\n

\u8fd9\u4e2a\u7248\u672c\u8fd8\u4e0d\u9002\u5408\u7528\u5728\u6b63\u5f0f\u73af\u5883\u3002\u60f3\u60f3\u4ee5\u540e\u4e5f\u8bb8\u53ef\u4ee5\u7528mysql mmm + mysql 5.5\u63d0\u4f9b\u53ef\u7528\u6027\u66f4\u597d\u7684\u670d\u52a1\uff0c\u524d\u63d0\u662f\u5b83\u5df2\u7ecf\u8db3\u591f\u7a33\u5b9a\uff0c\u6216\u8005\u662fpercona\u7248\u672c\uff1f<\/p>\n

\u4e0b\u8f7d\u5730\u5740
\n5.5 \u7248
\nhttp:\/\/dev.mysql.com\/downloads\/mysql\/5.5.html<\/a><\/p>\n

5.1 \u7248\u4e0b\u8f7d\u9875\u9762
\nhttp:\/\/downloads.mysql.com\/archives.php?p=mysql-5.1&v=5.1.55<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL\u662f\u73b0\u5728\u6700\u6d41\u884c\u7684\u5f00\u653e\u6e90\u4ee3\u7801\u6570\u636e\u5e93.\u7edd\u5927\u591a\u6570PHP\u7f51\u7ad9\u7684\u6570\u636e\u5e93\u540e\u53f0\u90fd\u662f\u91c7\u7528\u8fd9\u4e00\u6570\u636e\u5e93.\u662f\u4e00\u4e2a\u591a\u7ebf\u7a0b\u7684,\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\uff08SQL\uff09\u6570\u636e\u5e93\u670d\u52a1\u5668.MySQL \u7684\u6267\u884c\u6027\u80fd\u975e\u5e38\u9ad8,\u8fd0\u884c\u901f\u5ea6\u975e\u5e38\u5feb,\u5e76\u975e\u5e38\u5bb9\u6613\u4f7f\u7528.\u662f\u4e00\u4e2a\u975e\u5e38\u6367\u7684\u6570\u636e\u5e93. \u8fd1\u65e5\uff0c\u5173\u4e8eOracle\u6536\u8d2dSun\u540eMySQL\u5c06\u5982\u4f55\u53d1\u5c55\u7684\u95ee\u9898\u53ef\u8c13\u662f\u70ed\u70b9\u65b0\u95fb\uff0c\u5f88\u9ad8\u5174\u80fd\u591f\u770b\u5230\u8fd9\u4e2a\u65f6\u5019mysql\u8fd8\u80fd\u51fa\u4e2a\u65b0\u7248 \u672c\uff0c\u800c\u539f\u6765\u7684 MySQL 5.4 \u5728\u5b98\u7f51\u4e0a\u5df2\u7ecf\u6ca1\u6709\u94fe\u63a5\uff0c\u770b\u6765\u662f\u5347\u7ea7\u4e3a 5.5 \u7248\u672c\u4e86\uff0c\u5b98\u7f51\u4e0a\u540c\u65f6\u8fd8\u63d0\u4f9b\u4e00\u4e2a\u4ece 5.4 \u5347\u7ea7\u5230 5.5 \u7684\u6307\u5357\u3002MySQL 5.5.0\u662f\u6240\u8c13\u7684\u91cc\u7a0b\u7891\u7248\u672c\uff0c\u8fd9\u6b21\u5e26\u6765\u4e86\u4e00\u4e9b\u6709\u8da3\u7684\u4e1c\u897f\uff0c\u6309\u7167\u91cd\u8981\u7a0b\u5ea6\uff08\u6211\u4e3b\u89c2\u4e0a\u7684\uff09\u5217\u4e00\u4e0b:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[140],"tags":[72,71,73],"_links":{"self":[{"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/posts\/57"}],"collection":[{"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=57"}],"version-history":[{"count":0,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/posts\/57\/revisions"}],"wp:attachment":[{"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}