{"id":616,"date":"2022-11-28T22:14:13","date_gmt":"2022-11-28T14:14:13","guid":{"rendered":"https:\/\/china-abc.leohe.net.cn\/?p=616"},"modified":"2022-11-28T22:14:13","modified_gmt":"2022-11-28T14:14:13","slug":"mysql-%e7%bc%93%e5%ad%98%e4%b8%8d%e4%b8%80%e8%87%b4-%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/china-abc.leohe.net.cn\/?p=616","title":{"rendered":"mysql \u7f13\u5b58\u4e0d\u4e00\u81f4 \u95ee\u9898"},"content":{"rendered":"<p>\u64cd\u4f5c\u987a\u5e8f:<\/p>\n<p>1.\u64cd\u4f5cdb<\/p>\n<p>2.\u64cd\u4f5ccache<\/p>\n<p>3.\u628amysql\u64cd\u4f5c\u8bb0\u5f55\u6295\u9012\u7ed9mq,\u518d\u505a\u4e00\u6b21\u8865\u507f\u66f4\u65b0<\/p>\n<p>&nbsp;<\/p>\n<p>\u65b9\u68481:\u5ef6\u8fdf\u53cc\u5220 + \u8ba2\u5355mysql binlog \u65e5\u5fd7<\/p>\n<p>\u65b9\u68482:\u5c06key\u7684\u751f\u547d\u5468\u671f\u53d8\u77ed,\u5e76\u589e\u52a0\u6807\u8bc6,\u6807\u8bc6\u4e3a\u810f\u6570\u636e,\u7531\u5404\u81ea\u7684\u4e1a\u52a1\u5904\u6765\u51b3\u5b9a\u662f\u5426\u9700\u8981\u4f7f\u7528\u6b64\u810f\u6570\u636e,\u00a0 \u00a0get key \u65f6\u540c\u65f6\u8fd4\u56de\u4e00\u4e2a\u7248\u672c\u53f7, set key \u65f6\u68c0\u6d4b \u7248\u672c\u53f7\u4e0d\u4e00\u81f4(db update \u4e4b\u540e\u66f4\u65b0\u4e3a\u65b0\u7684\u7248\u672c\u53f7)\u5219\u5ffd\u7565\u6b64\u6b21set, \u4e00\u81f4\u5219\u8fdb\u884cset \u64cd\u4f5c<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u64cd\u4f5c\u987a\u5e8f: 1.\u64cd\u4f5cdb 2.\u64cd\u4f5ccache 3.\u628amysql\u64cd\u4f5c\u8bb0\u5f55\u6295\u9012\u7ed9mq,\u518d\u505a\u4e00\u6b21\u8865\u507f\u66f4\u65b0 &#038;nbsp [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/616"}],"collection":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=616"}],"version-history":[{"count":2,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/616\/revisions"}],"predecessor-version":[{"id":618,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/616\/revisions\/618"}],"wp:attachment":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}