{"id":3050,"date":"2018-01-19T09:53:22","date_gmt":"2018-01-19T01:53:22","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=3050"},"modified":"2018-01-19T09:53:22","modified_gmt":"2018-01-19T01:53:22","slug":"mysql%e4%ba%8b%e4%bb%b6%e5%bc%80%e5%90%af%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/fuwuqi\/mysql%e4%ba%8b%e4%bb%b6%e5%bc%80%e5%90%af%e6%93%8d%e4%bd%9c\/","title":{"rendered":"Mysql\u4e8b\u4ef6\u5f00\u542f\u64cd\u4f5c"},"content":{"rendered":"<p>\u4e00\u7ec4SQL\u96c6\uff0c\u7528\u6765\u6267\u884c\u5b9a\u65f6\u4efb\u52a1\uff0c\u8ddf\u89e6\u53d1\u5668\u5f88\u50cf\uff0c\u90fd\u662f\u88ab\u52a8\u6267\u884c\u7684\uff0c\u4e8b\u4ef6\u662f\u56e0\u4e3a\u65f6\u95f4\u5230\u4e86\u89e6\u53d1\u6267\u884c\uff0c\u800c\u89e6\u53d1\u5668\u662f\u56e0\u4e3a\u67d0\u4ef6\u4e8b\u4ef6\uff08\u589e\u5220\u6539\uff09\u89e6\u53d1\u6267\u884c\uff1b<\/p>\n<p>\u67e5\u770b\u662f\u5426\u5f00\u542f\uff1a<\/p>\n<pre>show variables like 'event_scheduler';\r\n\u5982\u679c\u663e\u793aOFF,\u5219\u8f93\u5165\u4ee5\u4e0b\u8bed\u53e5\u5f00\u542f\uff1a<\/pre>\n<pre>set global event_scheduler = on;\r\n\r\n\u63d0\u9192\uff1a\u867d\u7136\u8fd9\u91cc\u7528set global event_scheduler = on\u8bed\u53e5\u5f00\u542f\u4e86\u4e8b\u4ef6\uff0c\u4f46\u662f\u6bcf\u6b21\u91cd\u542f\u7535\u8111\u3002\u6216\u91cd\u542fmysql\u670d\u52a1\u540e\uff0c\u4f1a\u53d1\u73b0\uff0c\u4e8b\u4ef6\u81ea\u52a8\u5173\u95ed\uff08event_scheduler=OFF\uff09\uff0c\u6240\u4ee5\u60f3\u8ba9\u4e8b\u4ef6\u4e00\u76f4\u4fdd\u6301\u5f00\u542f\uff0c\u6700\u597d\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\uff0c\u8ba9mysql\u670d\u52a1\u542f\u52a8\u7684\u65f6\u5019\u5f00\u542f\u65f6\u95f4\uff0c\u53ea\u9700\u8981\u5728<strong>my.ini<\/strong>\u914d\u7f6e\u6587\u4ef6\u7684<strong>[mysqld]\u90e8\u5206<\/strong>\u52a0\u4e0a<strong>event_scheduler=ON<\/strong> \u5373\u53ef\uff0c\u5982\u4e0b<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u7ec4SQL\u96c6\uff0c\u7528\u6765\u6267\u884c\u5b9a\u65f6\u4efb\u52a1\uff0c\u8ddf\u89e6\u53d1\u5668\u5f88\u50cf\uff0c\u90fd\u662f\u88ab\u52a8\u6267\u884c\u7684\uff0c\u4e8b\u4ef6\u662f\u56e0\u4e3a\u65f6\u95f4\u5230\u4e86\u89e6\u53d1\u6267\u884c\uff0c\u800c\u89e6\u53d1\u5668\u662f\u56e0\u4e3a\u67d0\u4ef6\u4e8b &#8230; <a title=\"Mysql\u4e8b\u4ef6\u5f00\u542f\u64cd\u4f5c\" class=\"read-more\" href=\"https:\/\/cn.hostease.com\/xueyuan\/jishu\/fuwuqi\/mysql%e4%ba%8b%e4%bb%b6%e5%bc%80%e5%90%af%e6%93%8d%e4%bd%9c\/\" aria-label=\"\u9605\u8bfb Mysql\u4e8b\u4ef6\u5f00\u542f\u64cd\u4f5c\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10,9],"tags":[],"class_list":["post-3050","post","type-post","status-publish","format-standard","hentry","category-shujuku","category-fuwuqi"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/3050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=3050"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/3050\/revisions"}],"predecessor-version":[{"id":3051,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/3050\/revisions\/3051"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=3050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=3050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=3050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}