{"id":331855,"date":"2021-02-09T02:50:06","date_gmt":"2021-02-08T18:50:06","guid":{"rendered":"http:\/\/4563.org\/?p=331855"},"modified":"2021-02-09T02:50:06","modified_gmt":"2021-02-08T18:50:06","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e8%a6%81%e5%ae%9e%e7%8e%b0%e4%b8%80%e4%b8%aa%e5%9b%ba%e5%ae%9a%e5%a4%a7%e5%b0%8f%e7%9a%84%e7%94%a8%e6%88%b7%e6%b6%88%e6%81%af%e9%98%9f%e5%88%97%e8%a6%81%e6%80%8e%e5%81%9a","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=331855","title":{"rendered":"\u6570\u636e\u5e93\u8981\u5b9e\u73b0\u4e00\u4e2a\u56fa\u5b9a\u5927\u5c0f\u7684\u7528\u6237\u6d88\u606f\u961f\u5217\u8981\u600e\u505a\uff1f\uff08\u672f\u8bed\u4f3c\u4e4e\u662f\u53eb\u73af\u5f62\u961f\u5217"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  \u6570\u636e\u5e93\u8981\u5b9e\u73b0\u4e00\u4e2a\u56fa\u5b9a\u5927\u5c0f\u7684\u7528\u6237\u6d88\u606f\u961f\u5217\u8981\u600e\u505a\uff1f\uff08\u672f\u8bed\u4f3c\u4e4e\u662f\u53eb\u73af\u5f62\u961f\u5217               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : love <\/span>  <span><i><\/i> 2<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u6bd4\u5982\u6709 10 \u4e07\u7528\u6237\uff0c\u6bcf\u4e2a\u7528\u6237\u6bcf\u5929\u8981\u6536 1000 \u6d88\u606f\u5230\u81ea\u5df1\u7684\u961f\u5217\uff0c\u4f46\u53ea\u8981\u4fdd\u5b58\u6700\u8fd1 10000 \u6761\u8bb0\u5f55\u5373\u53ef\u3002<\/p>\n<p>\u7c7b\u4f3c\u8868\uff1a<\/p>\n<pre><code>userlog:   id: int auto_increment   user_id: int   msg: varchar(100)   time: datetime <\/code><\/pre>\n<p>\u611f\u89c9\u6bcf\u5929\u5faa\u73af\u5904\u7406\u6bcf\u4e2a\u7528\u6237\u7136\u540e\u6279\u91cf\u5220\u9664 10000 \u6761\u540e\u7684\u8bb0\u5f55\u6027\u80fd\u4e0d\u592a\u597d\u7684\u6837\u5f0f:<\/p>\n<pre><code>DELETE FROM `userlog`  WHERE id IN (select id  FROM `userlog`  ORDER BY id DESC LIMIT 10000, 250)) <\/code><\/pre>\n<p>\u56e0\u4e3a\u672c\u8eab mysql limit \u8bed\u53e5\u8981\u5927\u504f\u79fb\u5b9a\u4f4d 10000 \u6761\u8bb0\u5f55\u540e\u7684\u8bb0\u5f55\u5c31\u6027\u80fd\u4e0d\u597d\u518d\u52a0\u4e0a\u8fd8\u8981\u6bcf\u5929\u7ed9 10w \u7528\u6237\u5206\u522b\u67e5\u8be2\u591a\u6b21\u6765\u5220\u9664\u3002<\/p>\n<p>\u4f3c\u4e4e\u6ca1\u6709\u597d\u7684\u529e\u6cd5\u554a\uff1f\u6216\u8005\u6709\u4e0d\u7528 mysql \u6570\u636e\u5e93\u7684\u529e\u6cd5\u5417\uff1f<\/p>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>0<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>\u6570\u636e\u5e93\u8981\u5b9e\u73b0\u4e00\u4e2a\u56fa\u5b9a\u5927\u5c0f\u7684\u7528\u6237\u6d88\u606f&hellip;<\/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\/331855"}],"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=331855"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/331855\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=331855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=331855"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=331855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}