{"id":1405,"date":"2024-05-08T10:18:34","date_gmt":"2024-05-08T02:18:34","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1405"},"modified":"2024-05-08T10:18:34","modified_gmt":"2024-05-08T02:18:34","slug":"mysql%e6%85%a2%e6%9f%a5%e8%af%a2%e8%ae%be%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1405","title":{"rendered":"mysql\u6162\u67e5\u8be2\u8bbe\u7f6e"},"content":{"rendered":"

\u65b9\u6cd5\u4e00\uff1a\u5168\u5c40\u53d8\u91cf\u8bbe\u7f6e
\n\u5c06 slow_query_log \u5168\u5c40\u53d8\u91cf\u8bbe\u7f6e\u4e3a\u201cON\u201d\u72b6\u6001<\/p>\n

mysql> set global slow_query_log='ON';
\n\u8bbe\u7f6e\u6162\u67e5\u8be2\u65e5\u5fd7\u5b58\u653e\u7684\u4f4d\u7f6e<\/p>\n

mysql> set global slow_query_log_file='\/usr\/local\/mysql\/data\/slow.log';
\n\u67e5\u8be2\u8d85\u8fc71\u79d2\u5c31\u8bb0\u5f55<\/p>\n

mysql> set global long_query_time=1;
\n\u65b9\u6cd5\u4e8c\uff1a\u914d\u7f6e\u6587\u4ef6\u8bbe\u7f6e
\n\u4fee\u6539\u914d\u7f6e\u6587\u4ef6my.cnf\uff0c\u5728[mysqld]\u4e0b\u7684\u4e0b\u65b9\u52a0\u5165<\/p>\n

[mysqld]
\nslow_query_log = ON
\nslow_query_log_file = \/usr\/local\/mysql\/data\/slow.log
\nlong_query_time = 1
\n3.\u91cd\u542fMySQL\u670d\u52a1<\/p>\n

service mysqld restart
\n4.\u67e5\u770b\u8bbe\u7f6e\u540e\u7684\u53c2\u6570<\/p>\n

\u590d\u5236\u4ee3\u7801
\nmysql> show variables like 'slow_query%';
\n+---------------------+--------------------------------+
\n| Variable_name | Value |
\n+---------------------+--------------------------------+
\n| slow_query_log | ON |
\n| slow_query_log_file | \/usr\/local\/mysql\/data\/slow.log |
\n+---------------------+--------------------------------+<\/p>\n

mysql> show variables like 'long_query_time';
\n+-----------------+----------+
\n| Variable_name | Value |
\n+-----------------+----------+
\n| long_query_time | 1.000000 |
\n+-----------------+----------+
\n\u590d\u5236\u4ee3\u7801
\n\u56db\u3001\u6d4b\u8bd5
\n1.\u6267\u884c\u4e00\u6761\u6162\u67e5\u8be2SQL\u8bed\u53e5<\/p>\n

mysql> select sleep(2);
\n2.\u67e5\u770b\u662f\u5426\u751f\u6210\u6162\u67e5\u8be2\u65e5\u5fd7<\/p>\n

ls \/usr\/local\/mysql\/data\/slow.log<\/p>\n","protected":false},"excerpt":{"rendered":"

\u65b9\u6cd5\u4e00\uff1a\u5168\u5c40\u53d8\u91cf\u8bbe\u7f6e \u5c06 slow_query_log \u5168\u5c40\u53d8\u91cf\u8bbe\u7f6e\u4e3a\u201cON\u201d\u72b6\u6001 mysql> set global slow_query_log=’ON’; \u8bbe\u7f6e\u6162\u67e5\u8be2\u65e5\u5fd7\u5b58\u653e\u7684\u4f4d\u7f6e mysql> set global slow_query_log_file=’\/usr\/local\/mysql\/data\/slow.log’; \u67e5\u8be2\u8d85\u8fc71\u79d2\u5c31\u8bb0\u5f55 mysql> set global long_query_time=1; \u65b9\u6cd5\u4e8c\uff1a\u914d\u7f6e\u6587\u4ef6\u8bbe\u7f6e \u4fee\u6539\u914d\u7f6e\u6587\u4ef6my.cnf\uff0c\u5728[mysqld]\u4e0b\u7684\u4e0b\u65b9\u52a0\u5165 [mysqld] slow_query_log = ON slow_query_log_file = \/usr\/local\/mysql\/data\/slow.log long_query_time = 1 3.\u91cd\u542fMySQL\u670d\u52a1 service mysqld restart 4.\u67e5\u770b\u8bbe\u7f6e\u540e\u7684\u53c2\u6570 \u590d\u5236\u4ee3\u7801 mysql> show variables like ‘slow_query%’; +———————+——————————–+ | Variable_name | Value | +———————+——————————–+ | slow_query_log | ON | | slow_query_log_file | \/usr\/local\/mysql\/data\/slow.log | +———————+——————————–+ mysql> show variables like ‘long_query_time’; +—————–+———-+ | Variable_name | Value | +—————–+———-+ | long_query_time | 1.000000 | +—————–+———-+ \u590d\u5236\u4ee3\u7801 \u56db\u3001\u6d4b\u8bd5 1.\u6267\u884c\u4e00\u6761\u6162\u67e5\u8be2SQL\u8bed\u53e5 mysql> select sleep(2); 2.\u67e5\u770b\u662f\u5426\u751f\u6210\u6162\u67e5\u8be2\u65e5\u5fd7 ls \/usr\/local\/mysql\/data\/slow.log<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[83],"tags":[],"class_list":["post-1405","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1405"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1405\/revisions"}],"predecessor-version":[{"id":1406,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1405\/revisions\/1406"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}