{"id":98220,"date":"2020-05-21T03:31:54","date_gmt":"2020-05-20T19:31:54","guid":{"rendered":"http:\/\/4563.org\/?p=98220"},"modified":"2020-05-21T03:31:54","modified_gmt":"2020-05-20T19:31:54","slug":"mysql-%e5%9c%a8%e7%ba%bf%e5%a2%9e%e5%8a%a0%e8%a1%a8%e6%b3%a8%e9%87%8a%e3%80%81%e8%a1%8c%e6%b3%a8%e9%87%8a%e6%98%af%e5%90%a6%e4%bc%9a%e9%94%81%e8%a1%a8","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=98220","title":{"rendered":"MySQL \u5728\u7ebf\u589e\u52a0\u8868\u6ce8\u91ca\u3001\u884c\u6ce8\u91ca\u662f\u5426\u4f1a\u9501\u8868"},"content":{"rendered":"
\n
\n
\n

MySQL \u5728\u7ebf\u589e\u52a0\u8868\u6ce8\u91ca\u3001\u884c\u6ce8\u91ca\u662f\u5426\u4f1a\u9501\u8868 <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : 0000zjn <\/span> <\/i> 0<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

\u4eca\u5929\u7ed9\u7ebf\u4e0a\u4e00\u4e2a\u4e00\u767e\u591a\u4e07\u7684\u8868\u52a0\u6ce8\u91ca\u7684\u65f6\u5019\uff0c\u8868\u9501\u4f4f\u4e86\u534a\u5c0f\u65f6\uff0c\u6700\u540e kill \u89e3\u51b3\u4e86\u3002 \u7531\u4e8e\u7528\u7684\u662f Navicat\uff0c\u6211\u60f3\u77e5\u9053\uff0c\u5728\u547d\u4ee4\u884c\u91cc alter comment \u4f1a\u4e0d\u4f1a\u4e5f\u4f1a\u9501\u8868\uff1f \uff08\u6211\u77e5\u9053\u6539\u5b57\u6bb5\u7c7b\u578b\u7b49\u662f\u4f1a\u9501\u7684\uff0c\u4f46\u662f\u52a0\u4e2a\u6ce8\u91ca\u800c\u5df2\uff0c\u4e0d\u81f3\u4e8e\u5427\uff1f\uff09<\/p>\n<\/p><\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (7<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : snappyone <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u662f\u4e0d\u662f\u52a0\u4e86\u4e4b\u540e\u6ca1 commit\uff0c100 \u4e07\u5c31\u7b97\u6539\u5217\u4e5f\u6ca1\u8fd9\u4e48\u4e45 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : sagaxu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u54ea\u4e2a db \u80fd\u628a\u6ce8\u91ca\u5b58\u5230\u6bcf\u4e00\u884c\u91cc\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Coolha <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    alter table \u5c31\u4f1a\u7ed9\u8868\u52a0\u9501\uff0c\u548c\u5728\u54ea\u91cc\u6539\u7684\u6ca1\u5173\u7cfb\u5427 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : zhangysh1995 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    ALTER TABLE operations are processed using one of the following algorithms: <\/p>\n

    COPY: Operations are performed on a copy of the original table, and table data is copied from the original table to the new table row by row. Concurrent DML is not permitted.
    \u4e0d\u53ef\u4ee5\u5e76\u53d1<\/p>\n

    INPLACE: Operations avoid copying table data but may rebuild the table in place. An exclusive metadata lock on the table may be taken briefly during preparation and execution phases of the operation. Typically, concurrent DML is supported.
    \u53ef\u80fd\u52a0\u9501\uff0c\u4e00\u822c\u53ef\u4ee5\u5e76\u53d1<\/p>\n

    INSTANT: Operations only modify metadata in the data dictionary. No exclusive metadata locks are taken on the table during preparation and execution, and table data is unaffected, making operations instantaneous. Concurrent DML is permitted. (Introduced in MySQL 8.0.12)
    \u5141\u8bb8\u5e76\u53d1<\/p>\n

    https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/alter-table.html <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : 0000zjn <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @snappyone \u6539\u4e86\u4e4b\u540e\u5c31\u63d0\u4ea4\u4e86\uff0c\u4e0d\u7136\u540e\u9762 kill \u4ec0\u4e48\u561b\uff5e <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : 0000zjn <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @Coolha \u76ee\u524d\u770b\u662f\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : 0000zjn <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @zhangysh1995 \u8c22\u8c22\uff01\u6b63\u89e3 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    MySQL \u5728\u7ebf\u589e\u52a0\u8868\u6ce8\u91ca\u3001\u884c\u6ce8\u91ca…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/98220"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=98220"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/98220\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=98220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=98220"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=98220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}