{"id":762,"date":"2024-07-14T22:26:27","date_gmt":"2024-07-14T14:26:27","guid":{"rendered":"http:\/\/pony.xin\/?p=762"},"modified":"2024-07-16T11:26:27","modified_gmt":"2024-07-16T03:26:27","slug":"mysql-%e7%98%a6%e8%ba%ab","status":"publish","type":"post","link":"https:\/\/lnmp.ivan.xin\/?p=762","title":{"rendered":"mysql \u6570\u636e\u5e93\u7a7a\u95f4\u7626\u8eab"},"content":{"rendered":"<p>\u9996\u5148\uff0cENGINE\u7c7b\u578binnodb\u6bd4myisam\u5360\u7684\u7a7a\u95f4\u5927\uff0c\u5982\u679c\u53ea\u662f\u60f3\u8981mysql\u5360\u7684\u7a7a\u95f4\u5c0f\uff0c\u90a3\u4e48\u5c31\u91c7\u7528myisam<\/p>\n<p>1\u3001\u627e\u5230InnoDB\u7684\u8868\uff1ashow table status where Engine = 'InnoDB';<\/p>\n<p>2\u3001\u66f4\u6539ENGINE\u7c7b\u578b\u4e3aMyISAM\u7684\u547d\u4ee4\uff1a<span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">TABLE<\/span> table_name ENGINE<span class=\"hljs-operator\">=<\/span>MyISAM;<\/p>\n<p>3\u3001\u7528\u547d\u4ee4show table status where Data_free &lt;&gt;'0'; \u67e5\u770b\uff0cData_free\u4e0d\u4e3a0\u7684\uff0c\u5c31\u662f\u6709\u788e\u7247\u7a7a\u95f4\u7684\uff0c\u53ef\u4ee5\u4f18\u5316\u3002<\/p>\n<p>4\u3001\u7528\u547d\u4ee4optimize table table_name\uff0c\u6765\u4f18\u5316\uff0c\u5c31\u80fd\u7f29\u5c0f\u7a7a\u95f4\u4e86<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148\uff0cENGINE\u7c7b\u578binnodb\u6bd4myisam\u5360\u7684\u7a7a\u95f4\u5927\uff0c\u5982\u679c\u53ea\u662f\u60f3\u8981mysql\u5360\u7684\u7a7a\u95f4\u5c0f\uff0c\u90a3\u4e48\u5c31\u91c7\u7528myi...<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15330],"tags":[],"class_list":["post-762","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=762"}],"version-history":[{"count":4,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/762\/revisions"}],"predecessor-version":[{"id":766,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/762\/revisions\/766"}],"wp:attachment":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}