{"id":722,"date":"2019-01-11T11:59:57","date_gmt":"2019-01-11T13:59:57","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=722"},"modified":"2019-01-11T11:59:57","modified_gmt":"2019-01-11T13:59:57","slug":"habilitar-log-de-consultas-lentas-do-mysql","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2019\/01\/11\/habilitar-log-de-consultas-lentas-do-mysql\/","title":{"rendered":"Habilitar log de consultas lentas do MySQL"},"content":{"rendered":"<p>Edite o my.cnf<\/p>\n<pre class=\"lang:sh decode:true\">shell&gt; vi \/etc\/my.cnf<\/pre>\n<p>Adicionar os par\u00e2metros.<\/p>\n<p>long_query_time = Tempo gasto por uma consulta<\/p>\n<p><strong>MySQL 5.6<\/strong> ou anterior<\/p>\n<pre class=\"lang:sh decode:true\">slow_query_log = 1\nlog-slow-queries = \/var\/log\/mysql-slow.log\nlong_query_time = 2<\/pre>\n<p class=\"note notranslate\"><strong>Note:<\/strong>\u00a0In MySQL 5.7, the\u00a0variable\u00a0<em>log-slow-queries\u00a0<\/em>is deprecated. Use\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/server-system-variables.html#sysvar_slow_query_log_file\" target=\"_blank\" rel=\"noopener\">slow_query_log_file<\/a>\u00a0instead.<\/p>\n<p><strong>MySQL 5.7<\/strong><\/p>\n<pre class=\"lang:sh decode:true\">slow_query_log = 1\nslow_query_log_file=\/var\/log\/mysql-slow.log\nlong_query_time = 2<\/pre>\n<p>Crie o arquivo mysql-show.log<\/p>\n<pre class=\"lang:sh decode:true \">shell&gt; touch \/var\/log\/mysql-slow.log<\/pre>\n<p>Ajustar permiss\u00e3o.<\/p>\n<pre class=\"lang:default decode:true \"> shell&gt; chown mysql:mysql \/var\/log\/mysql-slow.log<\/pre>\n<p>Iniciar o monitoramento de consultas lentas.<\/p>\n<pre class=\"lang:default decode:true\">shell&gt; mysqldumpslow -a \/var\/log\/mysql-slow.log\n\n Reading mysql slow query log from \/var\/log\/mysql-slow.log<\/pre>\n<p><a href=\"https:\/\/support.plesk.com\/hc\/en-us\/articles\/115002888409-How-to-enable-the-MySQL-slow-query-log-and-analyze-it\" target=\"_blank\" rel=\"noopener\">Fonte Plesk<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Edite o my.cnf shell&gt; vi \/etc\/my.cnf Adicionar os par\u00e2metros. long_query_time = Tempo gasto por uma consulta MySQL 5.6 ou anterior slow_query_log = 1 log-slow-queries = \/var\/log\/mysql-slow.log long_query_time = 2 Note:\u00a0In MySQL 5.7, the\u00a0variable\u00a0log-slow-queries\u00a0is deprecated. Use\u00a0slow_query_log_file\u00a0instead. MySQL 5.7 slow_query_log = 1 slow_query_log_file=\/var\/log\/mysql-slow.log long_query_time = 2 Crie o arquivo mysql-show.log shell&gt; touch \/var\/log\/mysql-slow.log Ajustar permiss\u00e3o. shell&gt; chown&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"class_list":["post-722","post","type-post","status-publish","format-standard","hentry","category-linux","category-mysql"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=722"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/722\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}