Warning: Undefined array key "aHxDTi" in /www/wwwroot/hesiwei.cn/wp-includes/rewrite.php on line 1

Warning: Undefined array key "wOZyTK" in /www/wwwroot/hesiwei.cn/wp-includes/class-wp-block-type-registry.php on line 1
{"id":526,"date":"2010-07-22T23:58:26","date_gmt":"2010-07-22T15:58:26","guid":{"rendered":"http:\/\/www.hesiway.info\/using-wordpress-sql-database-statement-optimization.html"},"modified":"2026-04-29T15:47:07","modified_gmt":"2026-04-29T07:47:07","slug":"using-wordpress-sql-database-statement-optimization","status":"publish","type":"post","link":"https:\/\/hesiwei.cn\/?p=526","title":{"rendered":"\u5de7\u7528sql\u8bed\u53e5\u4f18\u5316WordPress\u6570\u636e\u5e93"},"content":{"rendered":"

WordPress\u535a\u5ba2\u4f7f\u7528\u7684\u4e45\u4e86\uff0c\u6570\u636e\u5e93\u4e2d\u7684\u5197\u4f59\u6570\u636e\u5fc5\u5b9a\u4f1a\u5f88\u591a\uff0c\u5b9a\u671f\u5730\u4f18\u5316\u548c\u6e05\u7406Wordpress\u7684\u6570\u636e\u5e93\uff0c\u663e\u5f97\u5c24\u5176\u91cd\u8981\uff0c\u90fd\u662f\u4e3a\u4e86\u4fdd\u8bc1Wordpress\u80fd\u591f\u5feb\u901f\u5de5\u4f5c\u3002<\/p>\n

\u4e00\uff1a\u5220\u9664\u65e5\u5fd7\u4fee\u8ba2\u7248\u672c\u548c\u81ea\u52a8\u4fdd\u5b58\u7684\u6570\u636e<\/strong><\/p>\n

\u00a0\u4e00\u822c\u6570\u636e\u5e93\u90fd\u4f1a\u63d0\u4f9b\u4f7f\u7528phpMyadmin\u8fd9\u6837\u7684\u5f62\u5f0f\u6765\u65b9\u4fbf\u7ba1\u7406\u6570\u636e\u5e93\uff0c\u6253\u5f00phpMyadmin\uff0c\u53ef\u4ee5\u901a\u8fc7SQL\u8bed\u53e5\u8fdb\u884c\u5197\u4f59\u6570\u636e\u5220\u9664\u64cd\u4f5c\u3002\u5220\u9664\u524d\u8bb0\u5f97\u5148\u5907\u4efd\u54c8\uff01<\/p>\n

\u3000\u3000DELETE FROM wp_posts WHERE post_type = ‘revision’;<\/p>\n
\u3000\u3000DELETE FROM wp_postmeta WHERE meta_key = ‘_edit_lock’;<\/p>\n
\u3000\u3000DELETE FROM wp_postmeta WHERE meta_key = ‘_edit_last’;<\/p><\/blockquote>\n