{"id":78,"date":"2023-07-25T18:26:52","date_gmt":"2023-07-25T21:26:52","guid":{"rendered":"https:\/\/thiagoldaniel.com.br\/?p=78"},"modified":"2023-07-25T18:26:52","modified_gmt":"2023-07-25T21:26:52","slug":"habilitando-o-log-queries-no-mysql-mariadb","status":"publish","type":"post","link":"https:\/\/thiagoldaniel.com.br\/index.php\/2023\/07\/25\/habilitando-o-log-queries-no-mysql-mariadb\/","title":{"rendered":"Habilitando o LOG QUERIES no MYSQL \/ MARIADB"},"content":{"rendered":"\n<p>Dicas de como habilitar TRACERT de Queries (LOG QUERIES) no Mysql \/ MariaDB.<\/p>\n\n\n\n<p>Verificar o Status do General Log<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT @@general_log;<\/code><\/pre>\n\n\n\n<p>Para Habilitar o Log das SQL Queries:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SET GLOBAL general_log=1;<\/code><\/pre>\n\n\n\n<p>Para Desabilitar o SQL Log Queries:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>set global general_log=0;<\/code><\/pre>\n\n\n\n<p>Mudando a sa\u00edda do Log de FILE para TABLE<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Verificando o formato da sa\u00edda:\n<strong>select @@log_output<\/strong>\n@@log_output|\n------------+\nFILE        |\n\nVerificando a localiza\u00e7\u00e3o do Arquivo:\n<strong>SELECT @@general_log_file;<\/strong>\n@@general_log_file|\n------------------+\nAD3-BBAAAKKK2.log |\n\n--Mudando o formato de sa\u00edda para TABLE:\n<strong>SET GLOBAL log_output='TABLE';<\/strong><\/code><\/pre>\n\n\n\n<p>Verificando a sa\u00edda dos  SQL traces:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select * from mysql.general_log;\n<\/code><\/pre>\n\n\n\n<p>Limpando a tabela de Logs:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>truncate table mysql.general_log;\r<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dicas de como habilitar TRACERT de Queries (LOG QUERIES) no Mysql \/ MariaDB. Verificar o Status do General Log Para Habilitar o Log das SQL Queries: Para Desabilitar o SQL Log Queries: Mudando a sa\u00edda do Log de FILE para TABLE Verificando<\/p>\n<p class=\"link-more\"><a class=\"myButt three\" href=\"https:\/\/thiagoldaniel.com.br\/index.php\/2023\/07\/25\/habilitando-o-log-queries-no-mysql-mariadb\/\">Leia Mais&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,4],"tags":[13,12,11,14],"class_list":["post-78","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","category-infraestrutura-de-tecnologia-da-informacao","tag-log-queries","tag-mariadb","tag-mysql","tag-tracert"],"_links":{"self":[{"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/posts\/78","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=78"}],"version-history":[{"count":1,"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/posts\/78\/revisions"}],"predecessor-version":[{"id":79,"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/posts\/78\/revisions\/79"}],"wp:attachment":[{"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thiagoldaniel.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}