{"id":102536,"date":"2026-09-09T06:17:09","date_gmt":"2026-09-08T22:17:09","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/102536.html"},"modified":"2026-09-09T06:17:09","modified_gmt":"2026-09-08T22:17:09","slug":"mysql-%e5%88%86%e5%b8%83%e5%bc%8f%e9%9b%86%e7%be%a4%e7%b3%bb%e5%88%97-%c2%b7-%e7%ac%ac%e5%85%ad%e7%af%87-ndb-%e9%9b%86%e7%be%a4%e6%a0%b8%e5%bf%83%e7%9f%ad%e6%9d%bf%e4%b8%8e%e7%94%9f","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/102536.html","title":{"rendered":"MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b"},"content":{"rendered":"<h2 style=\"text-align:center\"><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">\u76ee \u00a0\u5f55<\/span><\/span><\/h2>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\">\n<p><span style=\"color:#333333\"><span style=\"color:#333333\">\u56de\u987e\u4e0e\u5bfc\u8bfb&#xff1a;\u80fd\u529b\u4e4b\u5916&#xff0c;\u66f4\u8981\u770b\u6e05\u8fb9\u754c<\/span><\/span><\/p>\n<p><span style=\"color:#333333\"><span style=\"color:#333333\">\u7b2c\u4e00\u7ae0 \u529f\u80fd\u5c40\u9650\u6027&#xff1a;NDB \u4e0d\u662f\u5b8c\u6574\u7248 MySQL<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">1.1 \u4e0d\u652f\u6301\u7684 SQL \u8bed\u6cd5\u4e0e\u5bf9\u8c61<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">1.2 \u7d22\u5f15\u9650\u5236<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">1.3 \u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u9650\u5236<\/span><\/span><\/p>\n<p><span style=\"color:#333333\"><span style=\"color:#333333\">\u7b2c\u4e8c\u7ae0 \u5185\u5b58\u4f9d\u8d56\u95ee\u9898&#xff1a;\u6700\u5bb9\u6613\u88ab\u4f4e\u4f30\u7684\u5bb9\u91cf\u98ce\u9669<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">2.1 \u5185\u5b58\u5360\u7528\u4e3a\u4f55\u5c45\u9ad8\u4e0d\u4e0b<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">2.2 \u5927\u8868\u5185\u5b58\u6ea2\u51fa<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">2.3 \u6570\u636e\u51b7\u70ed\u4e0d\u5747\u95ee\u9898<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">2.4 \u5185\u5b58\u4f9d\u8d56\u7684\u9009\u578b\u8b66\u793a<\/span><\/span><\/p>\n<p><span style=\"color:#333333\"><span style=\"color:#333333\">\u7b2c\u4e09\u7ae0 \u6269\u5bb9\u4e0e\u8fc1\u79fb\u5751&#xff1a;\u91cd\u5206\u5e03\u4e0e\u7248\u672c\u517c\u5bb9<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">3.1 \u5206\u7247\u6269\u5bb9\u7684\u6570\u636e\u91cd\u5206\u5e03\u98ce\u9669<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">3.2 \u7248\u672c\u517c\u5bb9\u95ee\u9898<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">3.3 \u8fc1\u79fb\u5230 NDB \u7684\u9690\u85cf\u6210\u672c<\/span><\/span><\/p>\n<p><span style=\"color:#333333\"><span style=\"color:#333333\">\u7b2c\u56db\u7ae0 \u6027\u80fd\u77ed\u677f&#xff1a;\u80fd\u529b\u8fb9\u754c\u4e0a\u7684\u8870\u51cf<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">4.1 \u590d\u6742\u67e5\u8be2\u4e0e\u8054\u8868\u67e5\u8be2<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">4.2 \u5927\u4e8b\u52a1\u6027\u80fd\u8870\u51cf<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">4.3 \u6027\u80fd\u77ed\u677f\u7684\u5de5\u7a0b\u542f\u793a<\/span><\/span><\/p>\n<p><span style=\"color:#333333\"><span style=\"color:#333333\">\u7b2c\u4e94\u7ae0 \u8fd0\u7ef4\u75db\u70b9&#xff1a;\u9ad8\u53ef\u7528\u80cc\u540e\u7684\u9ad8\u95e8\u69db<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">5.1 \u65e5\u5fd7\u6392\u67e5\u56f0\u96be<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">5.2 \u6545\u969c\u5b9a\u4f4d\u590d\u6742<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">5.3 \u8282\u70b9\u5f02\u5e38\u6062\u590d\u7e41\u7410<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">5.4 \u8fd0\u7ef4\u80fd\u529b\u6e05\u5355<\/span><\/span><\/p>\n<p><span style=\"color:#333333\"><span style=\"color:#333333\">\u7b2c\u516d\u7ae0 \u7ebf\u4e0a\u9ad8\u9891\u6545\u969c\u6848\u4f8b\u4e0e\u89e3\u51b3\u65b9\u6848<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">6.1 \u6848\u4f8b\u4e00&#xff1a;\u6570\u636e\u8282\u70b9\u91cd\u542f\u62a5 Illegal node ID<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">6.2 \u6848\u4f8b\u4e8c&#xff1a;\u5199\u5165\u62a5 Out of resources \/ \u5185\u5b58\u4e0d\u8db3<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">6.3 \u6848\u4f8b\u4e09&#xff1a;\u6269\u5bb9\u540e\u90e8\u5206\u8868\u672a\u91cd\u5206\u5e03<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">6.4 \u6848\u4f8b\u56db&#xff1a;\u4e1a\u52a1\u9ad8\u5cf0\u671f\u96c6\u7fa4\u6027\u80fd\u9aa4\u964d<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">6.5 \u6848\u4f8b\u4e94&#xff1a;\u8282\u70b9\u7ec4\u6574\u4f53\u5b95\u673a\u5bfc\u81f4\u5206\u533a\u4e0d\u53ef\u7528<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">6.6 \u6848\u4f8b\u516d&#xff1a;\u6eda\u52a8\u5347\u7ea7\u540e\u8282\u70b9\u65e0\u6cd5\u52a0\u5165\u96c6\u7fa4<\/span><\/span><\/p>\n<p><span style=\"color:#333333\"><span style=\"color:#333333\">\u8bfb\u8005\u6536\u83b7\u4e0e\u4e0b\u4e00\u6b65<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">7.1 \u8bfb\u5b8c\u672c\u7bc7&#xff0c;\u4f60\u5e94\u8be5\u5e26\u8d70\u4ec0\u4e48<\/span><\/span><\/p>\n<p style=\"margin-left:21pt\"><span style=\"color:#333333\"><span style=\"color:#333333\">7.2 \u4e0b\u4e00\u6b65\u5efa\u8bae<\/span><\/span><\/p>\n<\/p>\n<h2><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">\u56de\u987e\u4e0e\u5bfc\u8bfb&#xff1a;\u80fd\u529b\u4e4b\u5916&#xff0c;\u66f4\u8981\u770b\u6e05\u8fb9\u754c<\/span><\/span><\/h2>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u524d\u4e94\u7bc7\u56f4\u7ed5 NDB \u8bb2\u4e86\u8ba4\u77e5\u3001\u539f\u7406\u3001\u90e8\u7f72\u4e0e\u9009\u578b\u3002\u5ba2\u89c2\u5730\u8bf4&#xff0c;NDB \u5728&#034;\u9ad8\u53ef\u7528 &#043; \u4f4e\u5ef6\u8fdf &#043; \u591a\u4e3b &#043; \u53ef\u6269\u5c55&#034;\u8fd9\u4e9b\u7ef4\u5ea6\u4e0a\u786e\u5b9e\u5f3a\u5927\u3002\u4f46\u4efb\u4f55\u6280\u672f\u90fd\u6709\u53e6\u4e00\u9762\u2014\u2014\u8fd9\u4e00\u7bc7\u4e13\u95e8\u8bb2 NDB \u7684\u77ed\u677f\u3001\u9650\u5236\u4e0e\u751f\u4ea7\u73af\u5883\u91cc\u53cd\u590d\u51fa\u73b0\u7684&#034;\u81f4\u547d\u5751&#034;\u3002<\/span><\/span><\/p>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4e3a\u4ec0\u4e48\u5fc5\u987b\u5199\u8fd9\u4e00\u7bc7&#xff1f;\u56e0\u4e3a\u7ebf\u4e0a\u6545\u969c\u5f80\u5f80\u4e0d\u662f\u53d1\u751f\u5728&#034;\u7528\u9519\u4e86\u65b9\u6848&#034;&#xff0c;\u800c\u662f\u53d1\u751f\u5728&#034;\u7528\u5bf9\u4e86\u65b9\u6848\u5374\u8e29\u4e86\u65b9\u6848\u7684\u5751&#034;&#xff1a;\u8868\u8bbe\u8ba1\u4e0d\u7b26\u5408\u5f15\u64ce\u7ea6\u675f\u3001\u5185\u5b58\u89c4\u5212\u6ca1\u6709\u4f59\u91cf\u3001\u6269\u5bb9\u6d41\u7a0b\u5ffd\u7565\u98ce\u9669\u3001\u6392\u969c\u624b\u6bb5\u4e0d\u719f\u6089\u2026\u2026\u8fd9\u4e9b\u5751\u4e00\u65e6\u8e29\u4e2d&#xff0c;\u8f7b\u5219\u6027\u80fd\u52a3\u5316&#xff0c;\u91cd\u5219\u6570\u636e\u4e0d\u53ef\u7528\u3001\u96c6\u7fa4\u957f\u65f6\u95f4\u4e0d\u53ef\u670d\u52a1\u3002<\/span><\/span><\/p>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u672c\u7bc7\u628a NDB \u7684\u529f\u80fd\u5c40\u9650\u3001\u5185\u5b58\u4f9d\u8d56\u3001\u6269\u5bb9\u8fc1\u79fb\u3001\u6027\u80fd\u77ed\u677f\u3001\u8fd0\u7ef4\u75db\u70b9\u9010\u4e00\u62c6\u5f00&#xff0c;\u5e76\u7528\u771f\u5b9e\u7684\u9ad8\u9891\u6545\u969c\u6848\u4f8b\u7ed9\u51fa\u6392\u67e5\u4e0e\u89e3\u51b3\u65b9\u6848\u3002\u8bfb\u5b8c\u8fd9\u4e00\u7bc7&#xff0c;\u4f60\u5c06\u62e5\u6709\u4e0e&#034;NDB \u80fd\u529b\u8ba4\u77e5&#034;\u540c\u7b49\u91cd\u8981\u7684&#034;NDB \u98ce\u9669\u8ba4\u77e5&#034;\u3002<\/span><\/span><\/p>\n<h2><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">\u7b2c\u4e00\u7ae0 \u529f\u80fd\u5c40\u9650\u6027&#xff1a;NDB \u4e0d\u662f\u5b8c\u6574\u7248 MySQL<\/span><\/span><\/h2>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">1.1 \u4e0d\u652f\u6301\u7684 SQL \u8bed\u6cd5\u4e0e\u5bf9\u8c61<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u662f\u5206\u5e03\u5f0f\u5b58\u50a8\u5f15\u64ce&#xff0c;\u4e3a\u6362\u53d6\u591a\u8282\u70b9\u4e00\u81f4\u6027&#xff0c;\u727a\u7272\u4e86\u4e00\u90e8\u5206\u5355\u673a MySQL \u7684\u8bed\u6cd5\u80fd\u529b\u3002\u5b98\u65b9\u6587\u6863\u660e\u786e\u5217\u51fa\u4e86\u4e00\u6279&#034;\u4e0e NDB \u8868\u4e00\u8d77\u4f7f\u7528\u4f1a\u62a5\u9519&#034;\u7684\u529f\u80fd&#xff0c;\u6700\u5178\u578b\u7684\u5305\u62ec&#xff1a;<\/span><\/span><\/p>\n<table align=\"center\" border=\"1\" cellspacing=\"0\" style=\"width:380.0000pt\">\n<tbody>\n<tr>\n<td style=\"background-color:#1f4e79;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:center\"><span style=\"color:#333333\"><span style=\"color:#ffffff\">\u4e0d\u652f\u6301\u9879<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#1f4e79;width:250.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:center\"><span style=\"color:#333333\"><span style=\"color:#ffffff\">\u8bf4\u660e<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4e34\u65f6\u8868<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:250.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u4e0d\u652f\u6301\u4e34\u65f6\u8868&#xff08;TEMPORARY TABLE&#xff09;&#xff0c;\u76f8\u5173\u5efa\u8868\u8bed\u53e5\u76f4\u63a5\u62a5\u9519<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#eaf1f8;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u5168\u6587\u7d22\u5f15<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#eaf1f8;width:250.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u8868\u4e0d\u652f\u6301 FULLTEXT \u5168\u6587\u7d22\u5f15<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u7a7a\u95f4\u7d22\u5f15<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:250.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4e0d\u652f\u6301\u7a7a\u95f4\u6570\u636e\u7c7b\u578b\u4e0e\u7a7a\u95f4\u7d22\u5f15<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#eaf1f8;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u5916\u952e&#xff08;\u9ed8\u8ba4&#xff09;<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#eaf1f8;width:250.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4f20\u7edf\u5916\u952e\u7ea6\u675f\u652f\u6301\u53d7\u9650&#xff0c;\u9700\u5e94\u7528\u5c42\u4fdd\u8bc1\u5f15\u7528\u5b8c\u6574\u6027<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4fdd\u5b58\u70b9<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:250.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">SAVEPOINT\/ROLLBACK TO SAVEPOINT \u4e0d\u652f\u6301<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#eaf1f8;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u90e8\u5206 ALTER<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#eaf1f8;width:250.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u5728\u7ebf DDL \u80fd\u529b\u53d7\u9650&#xff0c;\u90e8\u5206\u8868\u7ed3\u6784\u53d8\u66f4\u9700\u91cd\u5efa\u5206\u533a<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u5b9e\u8df5\u63d0\u9192&#xff1a;\u4e1a\u52a1\u4ece InnoDB \u8fc1\u79fb\u5230 NDB \u524d&#xff0c;\u52a1\u5fc5\u5148\u8dd1\u4e00\u904d SQL \u517c\u5bb9\u6027\u68c0\u67e5&#xff08;\u5efa\u8868 &#043; \u5e38\u7528\u67e5\u8be2&#xff09;&#xff0c;\u628a\u4e0d\u652f\u6301\u7684\u8bed\u6cd5\u4e00\u6b21\u6027\u627e\u51fa\u6765&#xff0c;\u800c\u4e0d\u662f\u4e0a\u7ebf\u540e\u9010\u4e2a\u649e\u5899\u3002<\/span><\/span><\/p>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">1.2 \u7d22\u5f15\u9650\u5236<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u4e3b\u952e\u662f\u5206\u7247\u7684\u6839\u57fa&#xff1a;NDB \u8868\u5fc5\u987b\u6709\u4e3b\u952e&#xff0c;\u4e14\u5206\u533a\u9ed8\u8ba4\u57fa\u4e8e\u4e3b\u952e\u2014\u2014\u6ca1\u6709\u4e3b\u952e\u7684\u8868\u6839\u672c\u65e0\u6cd5\u4f7f\u7528 NDB \u5f15\u64ce\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u7d22\u5f15\u524d\u7f00\u9650\u5236&#xff1a;\u7d22\u5f15\u5217\u7684\u603b\u957f\u5ea6\u53d7\u9650\u5236&#xff0c;\u957f VARCHAR \u5efa\u7d22\u5f15\u9700\u8c28\u614e\u8bbe\u8ba1\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u7d22\u5f15\u5185\u5b58\u5360\u7528&#xff1a;\u6bcf\u4e2a\u7d22\u5f15\u90fd\u4f1a\u6d88\u8017 IndexMemory&#xff0c;\u7d22\u5f15\u8d8a\u591a\u3001\u5185\u5b58\u6d88\u8017\u8d8a\u5927&#xff0c;\u7d22\u5f15\u8bbe\u8ba1\u76f4\u63a5\u5f71\u54cd\u5bb9\u91cf\u89c4\u5212\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">1.3 \u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u9650\u5236<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u4ec5\u652f\u6301 READ COMMITTED&#xff08;\u8bfb\u5df2\u63d0\u4ea4&#xff09;&#xff0c;\u4e0d\u652f\u6301 REPEATABLE READ \/ SERIALIZABLE\u3002<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">\u5f71\u54cd&#xff1a;\u540c\u4e00\u4e8b\u52a1\u5185\u4e24\u6b21\u67e5\u8be2\u53ef\u80fd\u8bfb\u5230\u4e0d\u540c\u5feb\u7167&#xff08;\u4e0d\u53ef\u91cd\u590d\u8bfb&#xff09;&#xff1b;\u4f9d\u8d56\u53ef\u91cd\u590d\u8bfb\u7684\u4e1a\u52a1\u903b\u8f91\u9700\u8981\u5e94\u7528\u5c42\u8865\u507f\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6b63\u786e\u59ff\u52bf&#xff1a;\u5728\u8bbe\u8ba1\u9636\u6bb5\u5c31\u628a&#034;\u4e8b\u52a1\u5185\u591a\u6b21\u8bfb\u53d6\u5fc5\u987b\u4e00\u81f4&#034;\u7684\u9700\u6c42\u8bc6\u522b\u51fa\u6765&#xff0c;\u901a\u8fc7\u5e94\u7528\u5c42\u9501\u6216\u5408\u5e76\u67e5\u8be2\u89c4\u907f\u3002<\/span><\/li>\n<\/ul>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4e00\u53e5\u8bdd\u603b\u7ed3&#xff1a;NDB \u7684 SQL \u80fd\u529b\u662f&#034;\u591f\u7528\u4f46\u53d7\u9650&#034;\u2014\u2014\u4e3b\u952e\u9a71\u52a8\u3001\u7a84\u8868\u3001\u77ed\u4e8b\u52a1\u662f\u5b83\u7684\u8212\u9002\u533a&#xff0c;\u8d85\u51fa\u8212\u9002\u533a\u7684\u8bed\u6cd5\u80fd\u529b\u8981\u63d0\u524d\u6478\u5e95\u3002<\/span><\/span><\/p>\n<h2><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">\u7b2c\u4e8c\u7ae0 \u5185\u5b58\u4f9d\u8d56\u95ee\u9898&#xff1a;\u6700\u5bb9\u6613\u88ab\u4f4e\u4f30\u7684\u5bb9\u91cf\u98ce\u9669<\/span><\/span><\/h2>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">2.1 \u5185\u5b58\u5360\u7528\u4e3a\u4f55\u5c45\u9ad8\u4e0d\u4e0b<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u662f\u5185\u5b58\u4f18\u5148\u5f15\u64ce&#xff1a;\u8868\u6570\u636e &#043; \u5168\u90e8\u7d22\u5f15\u90fd\u9a7b\u7559\u5185\u5b58&#xff0c;\u4e14\u6bcf\u4e2a\u5206\u533a\u5728\u6bcf\u4e2a\u8282\u70b9\u7ec4\u5185\u90fd\u6709\u526f\u672c\u3002\u8fd9\u610f\u5473\u7740\u5185\u5b58\u5360\u7528 &#061; \u6570\u636e\u91cf \u00d7 \u526f\u672c\u6570 \u00d7&#xff08;1 &#043; \u7d22\u5f15\u5f00\u9500&#xff09;&#xff0c;\u591a\u526f\u672c\u8bbe\u8ba1\u8ba9\u5185\u5b58\u9700\u6c42\u6210\u500d\u653e\u5927\u3002<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">DataMemory&#xff1a;\u5b58\u653e\u8868\u6570\u636e&#xff0c;\u76f4\u63a5\u51b3\u5b9a\u53ef\u627f\u8f7d\u7684\u6570\u636e\u91cf\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">IndexMemory&#xff1a;\u5b58\u653e\u54c8\u5e0c\u7d22\u5f15\u3001\u6709\u5e8f\u7d22\u5f15&#xff0c;\u7d22\u5f15\u8d8a\u591a\u5f00\u9500\u8d8a\u5927\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u526f\u672c\u653e\u5927&#xff1a;NoOfReplicas&#061;2 \u65f6&#xff0c;\u4e00\u4efd\u6570\u636e\u5728\u96c6\u7fa4\u5185\u5360\u4e24\u4efd\u5185\u5b58\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">2.2 \u5927\u8868\u5185\u5b58\u6ea2\u51fa<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u5f53\u8868\u6570\u636e\u91cf\u903c\u8fd1 DataMemory \u4e0a\u9650\u65f6&#xff0c;\u5199\u5165\u4f1a\u62a5&#034;Out of resources&#034;\u6216\u7c7b\u4f3c\u7684\u5185\u5b58\u4e0d\u8db3\u9519\u8bef&#xff1b;\u7ee7\u7eed\u589e\u957f\u53ef\u80fd\u5bfc\u81f4\u8282\u70b9\u5185\u5b58\u538b\u529b\u8fc7\u9ad8&#xff0c;\u751a\u81f3\u89e6\u53d1\u8282\u70b9\u5f02\u5e38\u3002\u8fd9\u662f NDB \u751f\u4ea7\u73af\u5883\u6700\u5178\u578b\u7684\u5185\u5b58\u4e8b\u6545\u3002<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">\u75c7\u72b6&#xff1a;\u5199\u5165\u5931\u8d25\u3001\u8282\u70b9\u72b6\u6001\u5f02\u5e38\u3001\u96c6\u7fa4\u65e5\u5fd7\u51fa\u73b0\u5185\u5b58\u76f8\u5173\u62a5\u9519\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6839\u56e0&#xff1a;\u4e0a\u7ebf\u524d\u672a\u6309\u6570\u636e\u589e\u901f\u89c4\u5212 DataMemory&#xff0c;\u6216\u4e1a\u52a1\u91cf\u8d85\u51fa\u9884\u671f\u589e\u957f\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u5bf9\u7b56&#xff1a;\u76d1\u63a7 MemoryUsage&#xff08;ndb_mgm -e &#034;ALL REPORT MEMORYUSAGE&#034;&#xff09;\u3001\u6309\u5cf0\u503c\u9884\u7559 30%&#043; \u4f59\u91cf\u3001\u6570\u636e\u91cf\u903c\u8fd1\u4e0a\u9650\u524d\u53ca\u65f6\u6269\u5bb9\u8282\u70b9\u6216\u6e05\u7406\u51b7\u6570\u636e\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">2.3 \u6570\u636e\u51b7\u70ed\u4e0d\u5747\u95ee\u9898<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u6309\u4e3b\u952e\u54c8\u5e0c\u5747\u5300\u5206\u7247&#xff0c;\u4f46&#034;\u5747\u5300&#034;\u9488\u5bf9\u7684\u662f\u884c\u6570&#xff0c;\u4e0d\u662f\u8bbf\u95ee\u70ed\u5ea6\u3002\u67d0\u4e9b\u70ed\u70b9\u4e3b\u952e&#xff08;\u5982\u7206\u6b3e\u5546\u54c1\u3001\u5934\u90e8\u7528\u6237&#xff09;\u6240\u5728\u5206\u533a\u4f1a\u627f\u53d7\u8fdc\u9ad8\u4e8e\u5176\u4ed6\u5206\u533a\u7684\u8bbf\u95ee\u538b\u529b&#xff0c;\u5bfc\u81f4\u8282\u70b9\u95f4\u8d1f\u8f7d\u4e0d\u5747\u8861\u3002<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">\u73b0\u8c61&#xff1a;\u4e2a\u522b\u8282\u70b9 CPU\/\u5185\u5b58\/\u7f51\u7edc\u5360\u7528\u663e\u8457\u9ad8\u4e8e\u5176\u4ed6\u8282\u70b9&#xff0c;\u70ed\u70b9\u5206\u533a\u6210\u4e3a\u74f6\u9888\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u7f13\u89e3&#xff1a;\u70ed\u70b9\u6570\u636e\u8003\u8651\u5e94\u7528\u5c42\u7f13\u5b58&#xff08;Redis&#xff09;\u524a\u5cf0&#xff1b;\u4e1a\u52a1\u4e0a\u5408\u7406\u8bbe\u8ba1\u4e3b\u952e&#xff0c;\u907f\u514d\u5355\u70b9\u70ed\u70b9\u4e3b\u952e\u96c6\u4e2d\u8bbf\u95ee\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">2.4 \u5185\u5b58\u4f9d\u8d56\u7684\u9009\u578b\u8b66\u793a<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u56de\u5230\u7b2c\u4e94\u7bc7\u7684\u7ed3\u8bba&#xff1a;\u6570\u636e\u603b\u91cf\u5fc5\u987b\u4e0e\u8282\u70b9\u5185\u5b58\u89c4\u6a21\u5339\u914d\u3002TB \u7ea7\u6d77\u91cf\u6570\u636e\u3001\u957f\u671f\u79ef\u538b\u7684\u51b7\u6570\u636e\u3001\u4ee5\u5206\u6790\u626b\u63cf\u4e3a\u4e3b\u7684\u4e1a\u52a1\u2014\u2014\u8fd9\u4e9b\u573a\u666f\u7684\u5185\u5b58\u6210\u672c\u4f1a\u9ad8\u5230\u4e0d\u73b0\u5b9e&#xff0c;\u5e94\u679c\u65ad\u9009\u62e9\u5206\u5e93\u5206\u8868\u6216\u6570\u4ed3\u65b9\u6848&#xff0c;\u800c\u4e0d\u662f\u786c\u4e0a NDB\u3002<\/span><\/span><\/p>\n<h2><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">\u7b2c\u4e09\u7ae0 \u6269\u5bb9\u4e0e\u8fc1\u79fb\u5751&#xff1a;\u91cd\u5206\u5e03\u4e0e\u7248\u672c\u517c\u5bb9<\/span><\/span><\/h2>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">3.1 \u5206\u7247\u6269\u5bb9\u7684\u6570\u636e\u91cd\u5206\u5e03\u98ce\u9669<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u652f\u6301\u5728\u7ebf\u6dfb\u52a0\u6570\u636e\u8282\u70b9&#xff0c;\u4f46&#034;\u5728\u7ebf&#034;\u4e0d\u7b49\u4e8e&#034;\u65e0\u98ce\u9669&#034;\u3002\u65b0\u589e\u8282\u70b9\u7ec4\u540e&#xff0c;\u5df2\u6709\u8868\u9700\u8981\u901a\u8fc7 REORGANIZE PARTITION \u628a\u90e8\u5206\u5206\u533a\u8fc1\u79fb\u5230\u65b0\u8282\u70b9\u7ec4&#xff0c;\u8fd9\u4e2a\u8fc7\u7a0b\u6709\u4ee5\u4e0b\u98ce\u9669&#xff1a;<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">\u91cd\u5206\u5e03\u671f\u95f4 IO\/\u7f51\u7edc\u538b\u529b\u589e\u5927&#xff1a;\u5206\u533a\u6570\u636e\u5728\u8282\u70b9\u95f4\u642c\u8fc1&#xff0c;\u53ef\u80fd\u9020\u6210\u6027\u80fd\u6296\u52a8&#xff0c;\u4e1a\u52a1\u9ad8\u5cf0\u65f6\u6bb5\u6267\u884c\u9700\u8c28\u614e\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u9010\u8868\u64cd\u4f5c\u6613\u9057\u6f0f&#xff1a;\u96c6\u7fa4\u4e2d\u8868\u591a\u65f6&#xff0c;\u6f0f\u6267\u884c\u67d0\u5f20\u8868\u7684 REORGANIZE \u4f1a\u5bfc\u81f4\u8be5\u8868\u4ecd\u53ea\u5206\u5e03\u5728\u65e7\u8282\u70b9\u7ec4&#xff0c;\u6269\u5c55\u4e0d\u5f7b\u5e95\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u56de\u6eda\u56f0\u96be&#xff1a;\u91cd\u5206\u5e03\u4e00\u65e6\u5f00\u59cb&#xff0c;\u4e2d\u6b62\u4f1a\u7559\u4e0b\u4e0d\u4e00\u81f4\u7684\u5206\u5e03\u72b6\u6001&#xff0c;\u6062\u590d\u6d41\u7a0b\u590d\u6742\u3002<\/span><\/li>\n<\/ul>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u6b63\u786e\u59ff\u52bf&#xff1a;\u6269\u5bb9\u524d\u505a\u5b8c\u6574\u8868\u6e05\u5355\u6838\u5bf9&#xff0c;\u4e1a\u52a1\u4f4e\u5cf0\u671f\u6267\u884c&#xff0c;\u9010\u8868\u786e\u8ba4\u5206\u5e03\u72b6\u6001&#xff0c;\u6269\u5bb9\u540e\u7acb\u5373\u505a\u5168\u91cf\u53ef\u7528\u6027\u9a8c\u8bc1\u3002<\/span><\/span><\/p>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">3.2 \u7248\u672c\u517c\u5bb9\u95ee\u9898<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">NDB \u7248\u672c\u4e0e MySQL \u7248\u672c\u5f3a\u7ed1\u5b9a&#xff1a;NDB 8.0 \u5bf9\u5e94 MySQL 8.0&#xff0c;\u8de8\u5927\u7248\u672c&#xff08;\u5982 5.7 \u2192 8.0&#xff09;\u5347\u7ea7\u9700\u8d70\u5b98\u65b9\u6eda\u52a8\u5347\u7ea7\u8def\u5f84&#xff0c;\u4e0d\u80fd\u76f4\u63a5\u66ff\u6362\u4e8c\u8fdb\u5236\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6eda\u52a8\u5347\u7ea7\u987a\u5e8f\u654f\u611f&#xff1a;\u5b98\u65b9\u8981\u6c42\u6309&#034;\u7ba1\u7406\u8282\u70b9 \u2192 \u6570\u636e\u8282\u70b9 \u2192 SQL \u8282\u70b9&#034;\u7684\u987a\u5e8f\u9010\u4e2a\u6eda\u52a8\u91cd\u542f&#xff0c;\u987a\u5e8f\u9519\u8bef\u6216\u8df3\u7248\u672c\u4f1a\u5bfc\u81f4\u8282\u70b9\u65e0\u6cd5\u52a0\u5165\u96c6\u7fa4\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u914d\u7f6e\u53c2\u6570\u517c\u5bb9&#xff1a;\u4e0d\u540c\u7248\u672c\u7684 config.ini \u53c2\u6570\u6709\u589e\u5220\u6539&#xff0c;\u5347\u7ea7\u524d\u9700\u6838\u5bf9\u53c2\u6570\u517c\u5bb9\u6027&#xff0c;\u65e7\u53c2\u6570\u53ef\u80fd\u88ab\u5e9f\u5f03\u6216\u6539\u540d\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">3.3 \u8fc1\u79fb\u5230 NDB \u7684\u9690\u85cf\u6210\u672c<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u8868\u7ed3\u6784\u6539\u9020&#xff1a;\u5916\u952e\u5220\u9664\u3001TEXT \u62c6\u8868\u3001\u4e3b\u952e\u8865\u9f50\u3001\u884c\u5bbd\u7626\u8eab\u2014\u2014\u5b58\u91cf\u4e1a\u52a1\u6539\u9020\u5de5\u4f5c\u91cf\u5f80\u5f80\u8d85\u51fa\u9884\u671f\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">SQL \u6539\u5199&#xff1a;\u53bb\u6389\u4e34\u65f6\u8868\u3001\u5168\u6587\u7d22\u5f15\u3001\u590d\u6742 JOIN&#xff0c;\u67e5\u8be2\u6539\u4e3a\u4e3b\u952e\u9a71\u52a8\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u5e94\u7528\u8054\u8c03&#xff1a;\u9694\u79bb\u7ea7\u522b\u53d8\u5316&#xff08;READ COMMITTED&#xff09;\u53ef\u80fd\u5f71\u54cd\u4f9d\u8d56\u53ef\u91cd\u590d\u8bfb\u7684\u4e1a\u52a1\u903b\u8f91\u3002<\/span><\/li>\n<\/ul>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u8fc1\u79fb\u6210\u672c\u5fc5\u987b\u5728\u9009\u578b\u9636\u6bb5\u5c31\u7eb3\u5165\u8bc4\u4f30\u2014\u2014\u5f88\u591a\u56e2\u961f\u53ea\u7b97\u4e86 NDB \u7684\u80fd\u529b\u8d26&#xff0c;\u6ca1\u7b97\u6539\u9020\u8d26&#xff0c;\u4e0a\u7ebf\u540e\u53d1\u73b0\u6210\u672c\u8fdc\u8d85\u9884\u7b97\u3002<\/span><\/span><\/p>\n<h2><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">\u7b2c\u56db\u7ae0 \u6027\u80fd\u77ed\u677f&#xff1a;\u80fd\u529b\u8fb9\u754c\u4e0a\u7684\u8870\u51cf<\/span><\/span><\/h2>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">4.1 \u590d\u6742\u67e5\u8be2\u4e0e\u8054\u8868\u67e5\u8be2<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u7684\u9ad8\u6027\u80fd\u5efa\u7acb\u5728&#034;\u4e3b\u952e\u9a71\u52a8 &#043; \u5355\u5206\u533a\u5b9a\u4f4d&#034;\u4e4b\u4e0a&#xff0c;\u4e00\u65e6\u67e5\u8be2\u8131\u79bb\u8fd9\u4e2a\u6a21\u5f0f&#xff0c;\u6027\u80fd\u4f1a\u65ad\u5d16\u5f0f\u4e0b\u964d&#xff1a;<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">\u5168\u8868\/\u8303\u56f4\u626b\u63cf&#xff1a;\u65e0\u4e3b\u952e\u6761\u4ef6\u7684\u626b\u63cf\u9700\u8981\u8de8\u5168\u90e8\u5206\u533a\u5e76\u884c\u6267\u884c\u518d\u6c47\u603b&#xff0c;\u5b98\u65b9\u6587\u6863\u660e\u786e\u6307\u51fa\u8303\u56f4\u626b\u63cf\u5b58\u5728\u6027\u80fd\u95ee\u9898\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u8054\u8868\u67e5\u8be2&#xff08;JOIN&#xff09;&#xff1a;\u8de8\u5206\u533a JOIN \u9700\u8981\u5728\u6570\u636e\u8282\u70b9\u95f4\u642c\u8fd0\u4e2d\u95f4\u7ed3\u679c&#xff0c;\u4ee3\u4ef7\u8fdc\u9ad8\u4e8e InnoDB \u5355\u673a JOIN\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u5b50\u67e5\u8be2\u4e0e\u805a\u5408&#xff1a;\u590d\u6742\u5b50\u67e5\u8be2\u3001\u5927\u805a\u5408\u5728\u5206\u5e03\u5f0f\u73af\u5883\u4e0b\u540c\u6837\u9762\u4e34\u8de8\u8282\u70b9\u6570\u636e\u79fb\u52a8\u3002<\/span><\/li>\n<\/ul>\n<table align=\"center\" border=\"1\" cellspacing=\"0\" style=\"width:380.0000pt\">\n<tbody>\n<tr>\n<td style=\"background-color:#1f4e79;width:120.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:center\"><span style=\"color:#333333\"><span style=\"color:#ffffff\">\u67e5\u8be2\u7c7b\u578b<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#1f4e79;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:center\"><span style=\"color:#333333\"><span style=\"color:#ffffff\">InnoDB \u8868\u73b0<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#1f4e79;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:center\"><span style=\"color:#333333\"><span style=\"color:#ffffff\">NDB \u8868\u73b0<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align:top;width:120.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4e3b\u952e\u70b9\u67e5<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4f18\u79c0<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u6781\u5feb&#xff08;\u5185\u5b58 &#043; \u5355\u5206\u533a&#xff09;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#eaf1f8;width:120.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u552f\u4e00\u952e\u67e5\u8be2<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#eaf1f8;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4f18\u79c0<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#eaf1f8;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4f18\u79c0&#xff08;\u7d22\u5f15\u5b9a\u4f4d&#xff09;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align:top;width:120.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u8303\u56f4\u626b\u63cf<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u826f\u597d&#xff08;\u7d22\u5f15\u56de\u8868&#xff09;<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u8f83\u5dee&#xff08;\u8de8\u5206\u533a\u626b\u63cf&#xff09;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#eaf1f8;width:120.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u591a\u8868 JOIN<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#eaf1f8;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u826f\u597d&#xff08;\u4f18\u5316\u5668\u6210\u719f&#xff09;<\/span><\/span><\/p>\n<\/td>\n<td style=\"background-color:#eaf1f8;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u8f83\u5dee&#xff08;\u8de8\u8282\u70b9\u642c\u8fd0&#xff09;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align:top;width:120.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u590d\u6742\u805a\u5408<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u826f\u597d<\/span><\/span><\/p>\n<\/td>\n<td style=\"vertical-align:top;width:130.0000pt\">\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u8f83\u5dee&#xff08;\u9700\u6c47\u603b\u4e2d\u95f4\u7ed3\u679c&#xff09;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">4.2 \u5927\u4e8b\u52a1\u6027\u80fd\u8870\u51cf<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">NDB \u6bcf\u6b21\u5199\u5165\u90fd\u8981\u8de8\u526f\u672c\u540c\u6b65\u786e\u8ba4&#xff0c;\u4e8b\u52a1\u6d89\u53ca\u7684\u5206\u533a\u8d8a\u591a\u3001\u884c\u6570\u8d8a\u591a&#xff0c;\u4e24\u9636\u6bb5\u63d0\u4ea4\u7684\u534f\u8c03\u5f00\u9500\u8d8a\u5927&#xff1a;<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">\u5927\u6279\u91cf INSERT&#xff1a;\u9010\u884c\u540c\u6b65\u590d\u5236&#xff0c;\u6279\u91cf\u704c\u5165\u6548\u7387\u8fdc\u4f4e\u4e8e InnoDB&#xff0c;\u5343\u4e07\u7ea7\u6570\u636e\u5bfc\u5165\u9700\u8981\u5206\u6279 &#043; \u8c03\u6574\u4e8b\u52a1\u7c92\u5ea6\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u5927\u4e8b\u52a1 UPDATE\/DELETE&#xff1a;\u6d89\u53ca\u591a\u5206\u533a\u7684\u957f\u4e8b\u52a1\u4f1a\u62c9\u957f\u9501\u6301\u6709\u65f6\u95f4\u4e0e\u63d0\u4ea4\u8def\u5f84&#xff0c;\u663e\u8457\u964d\u4f4e\u541e\u5410\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u5bf9\u7b56&#xff1a;\u4e8b\u52a1\u62c6\u5c0f\u3001\u6279\u91cf\u64cd\u4f5c\u5206\u6279\u3001\u907f\u514d\u4e00\u4e2a\u4e8b\u52a1\u64cd\u4f5c\u8fc7\u591a\u5206\u533a&#xff1b;ETL\/\u5f52\u6863\u7c7b\u5de5\u4f5c\u4e0d\u8981\u653e\u5728 NDB \u4e0a\u505a\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">4.3 \u6027\u80fd\u77ed\u677f\u7684\u5de5\u7a0b\u542f\u793a<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u628a NDB \u7684\u8bbf\u95ee\u6a21\u5f0f\u60f3\u8c61\u6210&#034;\u5206\u5e03\u5f0f KV &#043; SQL \u5916\u58f3&#034;&#xff1a;\u4e00\u5207\u80fd\u88ab\u4e3b\u952e\/\u552f\u4e00\u952e\u5feb\u901f\u5b9a\u4f4d\u7684\u67e5\u8be2\u90fd\u5f88\u5feb&#xff0c;\u4e00\u5207\u9700\u8981&#034;\u5168\u8868\u626b\u3001\u5230\u5904\u8fde\u3001\u5927\u6279\u91cf&#034;\u7684\u64cd\u4f5c\u90fd\u5f88\u6162\u3002\u4e1a\u52a1\u67b6\u6784\u8bbe\u8ba1\u65f6\u5c31\u8981\u987a\u5e94\u8fd9\u4e2a\u6a21\u5f0f&#xff0c;\u628a\u590d\u6742\u67e5\u8be2\u524d\u7f6e\u5230\u5e94\u7528\u5c42\u6216\u4e13\u7528\u5206\u6790\u5e93\u3002<\/span><\/span><\/p>\n<h2><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">\u7b2c\u4e94\u7ae0 \u8fd0\u7ef4\u75db\u70b9&#xff1a;\u9ad8\u53ef\u7528\u80cc\u540e\u7684\u9ad8\u95e8\u69db<\/span><\/span><\/h2>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">5.1 \u65e5\u5fd7\u6392\u67e5\u56f0\u96be<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u65e5\u5fd7\u5206\u6563&#xff1a;\u7ba1\u7406\u8282\u70b9\u3001\u6bcf\u4e2a\u6570\u636e\u8282\u70b9\u3001\u6bcf\u4e2a SQL \u8282\u70b9\u5404\u81ea\u4ea7\u751f\u65e5\u5fd7&#xff0c;\u95ee\u9898\u5b9a\u4f4d\u8981\u5728\u591a\u53f0\u673a\u5668\u95f4\u7a7f\u68ad\u5bf9\u7167\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u4fe1\u606f\u91cf\u5927&#xff1a;\u96c6\u7fa4\u65e5\u5fd7&#xff08;Cluster Log&#xff09;\u4e8b\u4ef6\u7c7b\u578b\u591a\u3001\u9891\u7387\u9ad8&#xff0c;\u566a\u58f0\u5927&#xff0c;\u6709\u6548\u4fe1\u606f\u9700\u8981\u8fc7\u6ee4\u63d0\u53d6\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6392\u969c\u4f9d\u8d56\u7ecf\u9a8c&#xff1a;NDB \u7684\u9519\u8bef\u7801\u4e0e\u65e5\u5fd7\u8bed\u4e49\u7279\u6b8a&#xff0c;\u6ca1\u6709\u79ef\u7d2f\u7684\u56e2\u961f\u5bb9\u6613\u5728\u6392\u67e5\u4e0a\u8017\u8d39\u5927\u91cf\u65f6\u95f4\u3002<\/span><\/li>\n<\/ul>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u5efa\u8bae&#xff1a;\u63d0\u524d\u90e8\u7f72\u96c6\u4e2d\u5f0f\u65e5\u5fd7\u91c7\u96c6&#xff08;\u5982 ELK\/Grafana Loki&#xff09;&#xff0c;\u628a\u5404\u8282\u70b9\u65e5\u5fd7\u6c47\u603b\u7edf\u4e00\u68c0\u7d22&#xff1b;\u53c2\u8003\u5b98\u65b9 ndbinfo \u4fe1\u606f\u5e93&#xff0c;\u7528 SQL \u67e5\u8be2\u96c6\u7fa4\u5185\u90e8\u72b6\u6001\u8f85\u52a9\u5b9a\u4f4d\u3002<\/span><\/span><\/p>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">5.2 \u6545\u969c\u5b9a\u4f4d\u590d\u6742<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u5206\u5e03\u5f0f\u7cfb\u7edf\u7684\u6545\u969c\u5f80\u5f80\u5448\u73b0&#034;\u591a\u70b9\u75c7\u72b6&#034;&#xff1a;\u4e00\u4e2a\u6570\u636e\u8282\u70b9\u5f02\u5e38&#xff0c;\u53ef\u80fd\u8868\u73b0\u4e3a SQL \u8282\u70b9\u62a5\u9519\u3001\u7ba1\u7406\u8282\u70b9\u544a\u8b66\u3001\u5176\u4ed6\u6570\u636e\u8282\u70b9\u540c\u6b65\u5f02\u5e38\u3002\u5b9a\u4f4d\u6839\u56e0\u9700\u8981\u4e32\u8054\u591a\u4e2a\u7ebf\u7d22&#xff1a;<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">\u5148\u770b\u7ba1\u7406\u8282\u70b9\u96c6\u7fa4\u65e5\u5fd7&#xff08;\u8282\u70b9\u72b6\u6001\u53d8\u5316\u3001\u5fc3\u8df3\u4e22\u5931\u3001\u4ef2\u88c1\u4e8b\u4ef6&#xff09;\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u518d\u770b\u6570\u636e\u8282\u70b9\u672c\u5730\u65e5\u5fd7&#xff08;\u5185\u5b58\u3001\u78c1\u76d8\u3001\u7f51\u7edc\u5c42\u9762\u7684\u5177\u4f53\u62a5\u9519&#xff09;\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6700\u540e\u7ed3\u5408 ndbinfo \u7cfb\u7edf\u5e93\u786e\u8ba4\u5f53\u524d\u8282\u70b9\u72b6\u6001\u4e0e\u8d44\u6e90\u4f7f\u7528\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">5.3 \u8282\u70b9\u5f02\u5e38\u6062\u590d\u7e41\u7410<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u6570\u636e\u8282\u70b9\u5b95\u673a\u540e\u7684\u6062\u590d\u6d41\u7a0b\u6bd4 InnoDB \u5355\u673a\u590d\u6742&#xff1a;\u8282\u70b9\u8981\u7ecf\u5386\u91cd\u65b0\u6ce8\u518c\u3001\u6570\u636e\u5bf9\u9f50\u3001\u72b6\u6001\u6062\u590d\u7b49\u591a\u4e2a\u9636\u6bb5&#xff0c;\u671f\u95f4\u8fd8\u53ef\u80fd\u51fa\u73b0&#034;\u8282\u70b9\u53cd\u590d\u91cd\u542f\u5931\u8d25&#034;\u7684\u60c5\u51b5\u3002\u5e38\u89c1\u7684\u5751\u5305\u62ec&#xff1a;<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">Illegal node ID&#xff1a;\u91cd\u542f\u65f6\u8282\u70b9 ID \u4e0e config.ini \u4e0d\u4e00\u81f4\u6216\u914d\u7f6e\u7f13\u5b58\u6b8b\u7559&#xff0c;\u5bfc\u81f4\u65e0\u6cd5\u52a0\u5165\u96c6\u7fa4&#xff08;\u7ebf\u4e0a\u9ad8\u9891\u6545\u969c&#xff09;\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6570\u636e\u5bf9\u9f50\u8d85\u65f6&#xff1a;\u6545\u969c\u8282\u70b9\u843d\u540e\u592a\u591a&#xff0c;\u91cd\u65b0\u52a0\u5165\u65f6\u540c\u6b65\u6570\u636e\u8017\u65f6\u8fc7\u957f&#xff0c;\u9700\u8981\u8010\u5fc3\u89c2\u5bdf\u72b6\u6001\u673a\u63a8\u8fdb\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u8282\u70b9\u7ec4\u6574\u4f53\u6545\u969c&#xff1a;\u82e5\u4e00\u4e2a\u8282\u70b9\u7ec4\u5185\u6240\u6709\u8282\u70b9\u540c\u65f6\u6545\u969c&#xff0c;\u8be5\u7ec4\u5206\u533a\u6570\u636e\u4e22\u5931&#xff0c;\u6062\u590d\u9700\u4f9d\u8d56\u5907\u4efd\u2014\u2014\u8fd9\u662f\u6700\u4e25\u91cd\u7684\u573a\u666f&#xff0c;\u52a1\u5fc5\u63d0\u524d\u6f14\u7ec3\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">5.4 \u8fd0\u7ef4\u80fd\u529b\u6e05\u5355<\/span><\/span><\/h3>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u8fd0\u8425\u4e00\u4e2a\u751f\u4ea7\u7ea7 NDB \u96c6\u7fa4&#xff0c;\u56e2\u961f\u81f3\u5c11\u9700\u8981\u638c\u63e1&#xff1a;<\/span><\/span><\/p>\n<ul>\n<li><span style=\"color:#333333\">\u7ba1\u7406\u5ba2\u6237\u7aef\u5168\u5957\u547d\u4ee4&#xff08;SHOW \/ STATUS \/ RESTART \/ BACKUP \u7b49&#xff09;\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6eda\u52a8\u5347\u7ea7\u4e0e\u6eda\u52a8\u91cd\u542f\u7684\u89c4\u8303\u6d41\u7a0b\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u5185\u5b58\u76d1\u63a7\u4e0e\u5bb9\u91cf\u9884\u8b66\u673a\u5236\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u5907\u4efd\u6062\u590d\u7684\u5b9a\u671f\u6f14\u7ec3&#xff08;\u4e0d\u6b62\u914d\u7f6e\u4e86\u5907\u4efd&#xff0c;\u8fd8\u8981\u771f\u6062\u590d\u8fc7&#xff09;\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u5e38\u89c1\u6545\u969c\u7684\u6392\u67e5\u624b\u518c&#xff08;\u672c\u7bc7\u7b2c\u516d\u7ae0\u7684\u6848\u4f8b\u5c31\u662f\u8d77\u70b9&#xff09;\u3002<\/span><\/li>\n<\/ul>\n<h2><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">\u7b2c\u516d\u7ae0 \u7ebf\u4e0a\u9ad8\u9891\u6545\u969c\u6848\u4f8b\u4e0e\u89e3\u51b3\u65b9\u6848<\/span><\/span><\/h2>\n<p style=\"margin-left:.0001pt;margin-right:0;text-align:justify\"><span style=\"color:#333333\"><span style=\"color:#333333\">\u4ee5\u4e0b\u6848\u4f8b\u6765\u81ea NDB \u751f\u4ea7\u73af\u5883\u7684\u771f\u5b9e\u9ad8\u9891\u95ee\u9898&#xff0c;\u6bcf\u4e2a\u90fd\u7ed9\u51fa\u75c7\u72b6\u3001\u6839\u56e0\u4e0e\u89e3\u6cd5&#xff0c;\u53ef\u76f4\u63a5\u6c89\u6dc0\u8fdb\u56e2\u961f\u6392\u969c\u624b\u518c\u3002<\/span><\/span><\/p>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">6.1 \u6848\u4f8b\u4e00&#xff1a;\u6570\u636e\u8282\u70b9\u91cd\u542f\u62a5 Illegal node ID<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u75c7\u72b6&#xff1a;\u8282\u70b9\u5b95\u673a\u540e\u91cd\u542f&#xff0c;\u62a5\u9519 Node failed to connect with error Illegal node ID&#xff0c;\u4e00\u76f4\u65e0\u6cd5\u52a0\u5165\u96c6\u7fa4\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6839\u56e0&#xff1a;config.ini \u4e2d\u8282\u70b9 ID \u4e0e\u5b9e\u9645\u542f\u52a8\u53c2\u6570\u4e0d\u4e00\u81f4&#xff0c;\u6216\u7ba1\u7406\u8282\u70b9\u7f13\u5b58\u4e86\u65e7\u914d\u7f6e&#xff08;&#8211;configdir \u4e0b\u5b58\u5728\u5386\u53f2 config \u7f13\u5b58&#xff09;\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u89e3\u51b3&#xff1a;\u6838\u5bf9 ndbd \u542f\u52a8\u7684 &#8211;ndb-nodeid \u4e0e config.ini \u4e2d NodeId \u4e00\u81f4&#xff1b;\u82e5\u914d\u7f6e\u53d8\u66f4\u8fc7&#xff0c;\u6e05\u7406\u7ba1\u7406\u8282\u70b9\u7f13\u5b58\u540e\u91cd\u542f\u7ba1\u7406\u8282\u70b9\u518d\u62c9\u8d77\u6570\u636e\u8282\u70b9\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">6.2 \u6848\u4f8b\u4e8c&#xff1a;\u5199\u5165\u62a5 Out of resources \/ \u5185\u5b58\u4e0d\u8db3<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u75c7\u72b6&#xff1a;\u4e1a\u52a1\u5199\u5165\u5f00\u59cb\u62a5\u5185\u5b58\/\u8d44\u6e90\u4e0d\u8db3\u9519\u8bef&#xff0c;\u7ba1\u7406\u8282\u70b9 MEMORYUSAGE \u663e\u793a\u67d0\u4e2a\u6570\u636e\u8282\u70b9\u5185\u5b58\u4f7f\u7528\u7387\u903c\u8fd1 100%\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6839\u56e0&#xff1a;DataMemory \u6216 IndexMemory \u89c4\u5212\u4e0d\u8db3&#xff0c;\u6570\u636e\u91cf\u589e\u957f\u8d85\u8fc7\u9884\u671f\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u89e3\u51b3&#xff1a;\u77ed\u671f\u6e05\u7406\u51b7\u6570\u636e\u91ca\u653e\u7a7a\u95f4&#xff1b;\u4e2d\u671f\u8c03\u6574 DataMemory\/IndexMemory&#xff08;\u9700\u6eda\u52a8\u91cd\u542f&#xff09;&#xff1b;\u957f\u671f\u589e\u52a0\u6570\u636e\u8282\u70b9\u6216\u4f18\u5316\u8868\/\u7d22\u5f15\u8bbe\u8ba1\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">6.3 \u6848\u4f8b\u4e09&#xff1a;\u6269\u5bb9\u540e\u90e8\u5206\u8868\u672a\u91cd\u5206\u5e03<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u75c7\u72b6&#xff1a;\u65b0\u589e\u6570\u636e\u8282\u70b9\u540e&#xff0c;\u4e1a\u52a1\u538b\u529b\u4ecd\u96c6\u4e2d\u5728\u65e7\u8282\u70b9&#xff0c;\u65b0\u8282\u70b9\u8d1f\u8f7d\u5f88\u4f4e\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6839\u56e0&#xff1a;\u53ea\u52a0\u4e86\u6570\u636e\u8282\u70b9&#xff0c;\u4f46\u672a\u5bf9\u5b58\u91cf\u8868\u6267\u884c REORGANIZE PARTITION&#xff0c;\u8868\u4ecd\u5168\u90e8\u9a7b\u7559\u5728\u65e7\u8282\u70b9\u7ec4\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u89e3\u51b3&#xff1a;\u5bf9\u5168\u90e8 NDB \u8868\u9010\u8868\u6267\u884c ALTER TABLE &#8230; REORGANIZE PARTITION&#xff0c;\u7528 ndb_desc \u6838\u5bf9\u6bcf\u5f20\u8868\u7684\u5206\u533a\u5206\u5e03\u786e\u8ba4\u5df2\u5747\u5300\u8986\u76d6\u65b0\u8282\u70b9\u7ec4\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">6.4 \u6848\u4f8b\u56db&#xff1a;\u4e1a\u52a1\u9ad8\u5cf0\u671f\u96c6\u7fa4\u6027\u80fd\u9aa4\u964d<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u75c7\u72b6&#xff1a;\u767d\u5929\u9ad8\u5cf0\u65f6\u6bb5\u5199\u5165\u5ef6\u8fdf\u98d9\u5347&#xff0c;SQL \u8282\u70b9\u62a5\u8fde\u63a5\u8d85\u65f6&#xff0c;\u6570\u636e\u8282\u70b9 CPU \u9ad8\u4f01\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6839\u56e0&#xff1a;\u5f80\u5f80\u662f\u67e5\u8be2\u6a21\u5f0f\u9000\u5316\u2014\u2014\u67d0\u6761\u65e0\u4e3b\u952e\u6761\u4ef6\u7684\u626b\u63cf\/JOIN \u5728\u9ad8\u5cf0\u671f\u89e6\u53d1&#xff0c;\u8de8\u5206\u533a\u642c\u8fd0\u6570\u636e\u62d6\u57ae\u96c6\u7fa4\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u89e3\u51b3&#xff1a;\u5f00\u542f\u6162\u67e5\u8be2\u65e5\u5fd7\u5b9a\u4f4d\u9000\u5316 SQL&#xff1b;\u5c06\u5927\u626b\u63cf\/JOIN \u79fb\u5230\u53ea\u8bfb\u5206\u6790\u5e93&#xff1b;\u4e3a\u5173\u952e\u67e5\u8be2\u8865\u5145\u4e3b\u952e\/\u552f\u4e00\u952e\u6761\u4ef6&#xff1b;\u5fc5\u8981\u65f6\u52a0\u5e94\u7528\u5c42\u7f13\u5b58\u524a\u5cf0\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">6.5 \u6848\u4f8b\u4e94&#xff1a;\u8282\u70b9\u7ec4\u6574\u4f53\u5b95\u673a\u5bfc\u81f4\u5206\u533a\u4e0d\u53ef\u7528<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u75c7\u72b6&#xff1a;\u540c\u8282\u70b9\u7ec4\u4e24\u4e2a\u6570\u636e\u8282\u70b9\u76f8\u7ee7\u6545\u969c&#xff0c;\u96c6\u7fa4\u5bf9\u8be5\u7ec4\u5206\u533a\u6570\u636e\u8bbf\u95ee\u62a5\u9519&#xff0c;\u4e1a\u52a1\u90e8\u5206\u4e0d\u53ef\u7528\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6839\u56e0&#xff1a;\u526f\u672c\u6570&#061;2 \u7684\u96c6\u7fa4\u53ea\u80fd\u5bb9\u5fcd&#034;\u6bcf\u4e2a\u8282\u70b9\u7ec4\u6302 1 \u4e2a&#034;&#xff0c;\u7ec4\u5185\u5168\u6302\u5373\u4e22\u5931\u8be5\u7ec4\u6570\u636e\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u89e3\u51b3&#xff1a;\u8fd9\u662f\u6700\u4e25\u91cd\u7684\u573a\u666f\u2014\u2014\u7528\u6700\u8fd1\u7684\u5728\u7ebf\u5907\u4efd\u6062\u590d\u8be5\u7ec4\u6570\u636e&#xff08;ndb_restore&#xff09;&#xff0c;\u5e76\u5728\u6062\u590d\u540e\u7acb\u5373\u590d\u76d8\u6839\u56e0&#xff1b;\u66f4\u9ad8\u53ef\u7528\u8981\u6c42\u5e94\u63d0\u9ad8 NoOfReplicas \u6216\u589e\u52a0\u8282\u70b9\u7ec4\u3002<\/span><\/li>\n<\/ul>\n<h3><span style=\"color:#1f4e79\"><span style=\"color:#1f4e79\">6.6 \u6848\u4f8b\u516d&#xff1a;\u6eda\u52a8\u5347\u7ea7\u540e\u8282\u70b9\u65e0\u6cd5\u52a0\u5165\u96c6\u7fa4<\/span><\/span><\/h3>\n<ul>\n<li><span style=\"color:#333333\">\u75c7\u72b6&#xff1a;\u6309\u6d41\u7a0b\u5347\u7ea7\u6570\u636e\u8282\u70b9\u4e8c\u8fdb\u5236\u540e&#xff0c;\u8282\u70b9\u542f\u52a8\u5361\u5728 starting \u6216\u62a5\u7248\u672c\u4e0d\u517c\u5bb9\u3002<\/span><\/li>\n<li><span style=\"color:#333333\">\u6839\u56e0&#xff1a;\u7ba1\u7406\u8282\u70b9\u7248\u672c\u4e0e\u6570\u636e\u8282\u70b9\u7248\u672c\u4e0d\u5339\u914d&#xff0c;\u6216\u5347\u7ea7\u987a\u5e8f\u8fdd\u80cc\u5b98\u65b9\u8981\u6c42&#xff08;\u5fc5\u987b\u7ba1\u7406\u8282\u70b9\u5148\u5347&#xff0c;\u4e14\u5c0f\u7248\u672c\u95f4\u4fdd\u6301\u517c\u5bb9\u77e9\u9635&#xff09;\u3002<\/span><\/li>\n<\/ul>\n<p><span style=\"color:#333333\">\u89e3\u51b3&#xff1a;\u4e25\u683c\u6309\u5b98\u65b9\u5347\u7ea7\u6587\u6863\u6267\u884c&#xff1a;\u5148\u5907\u4efd\u3001\u518d\u6eda\u52a8\u5347\u7ea7\u7ba1\u7406\u8282\u70b9\u3001\u6570\u636e\u8282\u70b9\u3001SQL \u8282\u70b9&#xff1b;\u5347\u7ea7\u524d\u6838\u5bf9\u7248\u672c\u517c\u5bb9\u77e9\u9635&#xff0c;\u7981\u6b62\u8de8\u7248\u672c\u8df3\u8dc3\u3002<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u76ee \u00a0\u5f55 \u56de\u987e\u4e0e\u5bfc\u8bfb&#xff1a;\u80fd\u529b\u4e4b\u5916&#xff0c;\u66f4\u8981\u770b\u6e05\u8fb9\u754c \u7b2c\u4e00\u7ae0 \u529f\u80fd\u5c40\u9650\u6027&#xff1a;NDB \u4e0d\u662f\u5b8c\u6574\u7248 MySQL 1.1 \u4e0d\u652f\u6301\u7684 SQL \u8bed\u6cd5\u4e0e\u5bf9\u8c61 1.2 \u7d22\u5f15\u9650\u5236 1.3 \u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u9650\u5236 \u7b2c\u4e8c\u7ae0 \u5185\u5b58\u4f9d\u8d56\u95ee\u9898&#xff1a;\u6700\u5bb9\u6613\u88ab\u4f4e\u4f30\u7684\u5bb9\u91cf\u98ce\u9669 2.1 \u5185\u5b58\u5360\u7528\u4e3a\u4f55\u5c45\u9ad8\u4e0d\u4e0b 2.2 \u5927\u8868\u5185\u5b58\u6ea2\u51fa 2.3 \u6570\u636e\u51b7\u70ed\u4e0d\u5747\u95ee\u9898 2.4 \u5185\u5b58\u4f9d\u8d56\u7684\u9009\u578b\u8b66\u793a \u7b2c\u4e09\u7ae0 \u6269\u5bb9\u4e0e\u8fc1\u79fb\u5751&#xff1a;\u91cd\u5206\u5e03\u4e0e\u7248\u672c\u517c\u5bb9 3.1 \u5206\u7247\u6269\u5bb9\u7684\u6570\u636e\u91cd\u5206\u5e03\u98ce\u9669 3.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[114,664,100],"topic":[],"class_list":["post-102536","post","type-post","status-publish","format-standard","hentry","category-server","tag-mysql","tag-664","tag-100"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/102536.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u76ee \u00a0\u5f55 \u56de\u987e\u4e0e\u5bfc\u8bfb&#xff1a;\u80fd\u529b\u4e4b\u5916&#xff0c;\u66f4\u8981\u770b\u6e05\u8fb9\u754c \u7b2c\u4e00\u7ae0 \u529f\u80fd\u5c40\u9650\u6027&#xff1a;NDB \u4e0d\u662f\u5b8c\u6574\u7248 MySQL 1.1 \u4e0d\u652f\u6301\u7684 SQL \u8bed\u6cd5\u4e0e\u5bf9\u8c61 1.2 \u7d22\u5f15\u9650\u5236 1.3 \u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u9650\u5236 \u7b2c\u4e8c\u7ae0 \u5185\u5b58\u4f9d\u8d56\u95ee\u9898&#xff1a;\u6700\u5bb9\u6613\u88ab\u4f4e\u4f30\u7684\u5bb9\u91cf\u98ce\u9669 2.1 \u5185\u5b58\u5360\u7528\u4e3a\u4f55\u5c45\u9ad8\u4e0d\u4e0b 2.2 \u5927\u8868\u5185\u5b58\u6ea2\u51fa 2.3 \u6570\u636e\u51b7\u70ed\u4e0d\u5747\u95ee\u9898 2.4 \u5185\u5b58\u4f9d\u8d56\u7684\u9009\u578b\u8b66\u793a \u7b2c\u4e09\u7ae0 \u6269\u5bb9\u4e0e\u8fc1\u79fb\u5751&#xff1a;\u91cd\u5206\u5e03\u4e0e\u7248\u672c\u517c\u5bb9 3.1 \u5206\u7247\u6269\u5bb9\u7684\u6570\u636e\u91cd\u5206\u5e03\u98ce\u9669 3.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/102536.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-08T22:17:09+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/102536.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/102536.html\",\"name\":\"MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-09-08T22:17:09+00:00\",\"dateModified\":\"2026-09-08T22:17:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/102536.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/102536.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/102536.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/102536.html","og_locale":"zh_CN","og_type":"article","og_title":"MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u76ee \u00a0\u5f55 \u56de\u987e\u4e0e\u5bfc\u8bfb&#xff1a;\u80fd\u529b\u4e4b\u5916&#xff0c;\u66f4\u8981\u770b\u6e05\u8fb9\u754c \u7b2c\u4e00\u7ae0 \u529f\u80fd\u5c40\u9650\u6027&#xff1a;NDB \u4e0d\u662f\u5b8c\u6574\u7248 MySQL 1.1 \u4e0d\u652f\u6301\u7684 SQL \u8bed\u6cd5\u4e0e\u5bf9\u8c61 1.2 \u7d22\u5f15\u9650\u5236 1.3 \u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u9650\u5236 \u7b2c\u4e8c\u7ae0 \u5185\u5b58\u4f9d\u8d56\u95ee\u9898&#xff1a;\u6700\u5bb9\u6613\u88ab\u4f4e\u4f30\u7684\u5bb9\u91cf\u98ce\u9669 2.1 \u5185\u5b58\u5360\u7528\u4e3a\u4f55\u5c45\u9ad8\u4e0d\u4e0b 2.2 \u5927\u8868\u5185\u5b58\u6ea2\u51fa 2.3 \u6570\u636e\u51b7\u70ed\u4e0d\u5747\u95ee\u9898 2.4 \u5185\u5b58\u4f9d\u8d56\u7684\u9009\u578b\u8b66\u793a \u7b2c\u4e09\u7ae0 \u6269\u5bb9\u4e0e\u8fc1\u79fb\u5751&#xff1a;\u91cd\u5206\u5e03\u4e0e\u7248\u672c\u517c\u5bb9 3.1 \u5206\u7247\u6269\u5bb9\u7684\u6570\u636e\u91cd\u5206\u5e03\u98ce\u9669 3.","og_url":"https:\/\/www.wsisp.com\/helps\/102536.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-09-08T22:17:09+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/102536.html","url":"https:\/\/www.wsisp.com\/helps\/102536.html","name":"MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-09-08T22:17:09+00:00","dateModified":"2026-09-08T22:17:09+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/102536.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/102536.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/102536.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MySQL \u5206\u5e03\u5f0f\u96c6\u7fa4\u7cfb\u5217 \u00b7 \u7b2c\u516d\u7bc7\u2014\u2014NDB \u96c6\u7fa4\u6838\u5fc3\u77ed\u677f\u4e0e\u751f\u4ea7\u81f4\u547d\u5751\u6c47\u603b"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/102536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=102536"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/102536\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=102536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=102536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=102536"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=102536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}