{"id":183,"date":"2023-03-10T09:01:38","date_gmt":"2023-03-10T09:01:38","guid":{"rendered":"https:\/\/chenyl.fun\/?post_type=docs&#038;p=183"},"modified":"2023-03-10T09:24:12","modified_gmt":"2023-03-10T09:24:12","slug":"mysql8-%e5%86%85%e5%ad%98%e5%8d%a0%e7%94%a8%e5%a4%a7","status":"publish","type":"docs","link":"https:\/\/chenyl.fun\/?docs=mysql8-%e5%86%85%e5%ad%98%e5%8d%a0%e7%94%a8%e5%a4%a7","title":{"rendered":"mysql8 \u5185\u5b58\u5360\u7528\u5927"},"content":{"rendered":"\n<p>\u67e5\u770b\u5360\u7528\u60c5\u51b5:<br>SELECT SUBSTRING_INDEX(event_name,&#8217;\/&#8217;,2) AS<br>code_area, FORMAT_BYTES(SUM(current_alloc))<br>AS current_alloc<br>FROM sys.x$memory_global_by_current_bytes<br>GROUP BY SUBSTRING_INDEX(event_name,&#8217;\/&#8217;,2)<br>ORDER BY SUM(current_alloc) DESC;<\/p>\n\n\n\n<p>\u5173\u95edperformance_schema,\u5728\/etc\/my.cnf\u4e2d\u6dfb\u52a0<br>performance_schema=OFF<br>\u8bbe\u7f6e\u6700\u5927\u8fde\u63a5\u6570,\u5728\/etc\/my.cnf\u4e2d\u6dfb\u52a0:<br>max_connections=20<\/p>\n\n\n\n<p>\u7136\u540esystemctl restart mysqld<\/p>\n\n\n\n<p>MySQL8.0\u4e4b\u5185\u5b58\u6d88\u8017\u5173\u952e\u56e0\u7d20<br>https:\/\/cloud.tencent.com\/developer\/article\/1800973<br>MySQL\u6027\u80fd\u8c03\u4f18\u5fc5\u77e5\uff1aPerformance Schema\u5f15\u64ce\u7684\u914d\u7f6e\u4e0e\u4f7f\u7528<br>https:\/\/www.cnblogs.com\/xiaoxi-jinchen\/p\/17137240.html<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770b\u5360\u7528\u60c5\u51b5:SELECT SUBSTRING_INDEX(event_name,&#8217;\/&#038;#8217 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[20],"doc_tag":[],"_links":{"self":[{"href":"https:\/\/chenyl.fun\/index.php?rest_route=\/wp\/v2\/docs\/183"}],"collection":[{"href":"https:\/\/chenyl.fun\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/chenyl.fun\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/chenyl.fun\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chenyl.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=183"}],"version-history":[{"count":1,"href":"https:\/\/chenyl.fun\/index.php?rest_route=\/wp\/v2\/docs\/183\/revisions"}],"predecessor-version":[{"id":184,"href":"https:\/\/chenyl.fun\/index.php?rest_route=\/wp\/v2\/docs\/183\/revisions\/184"}],"wp:attachment":[{"href":"https:\/\/chenyl.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=183"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/chenyl.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_category&post=183"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/chenyl.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}