{"id":2917,"date":"2026-02-03T19:55:21","date_gmt":"2026-02-03T22:55:21","guid":{"rendered":"https:\/\/helpsysadmin.com.br\/blog\/?p=2917"},"modified":"2026-02-03T19:59:16","modified_gmt":"2026-02-03T22:59:16","slug":"tuning-mariadb-slow-query-linux","status":"publish","type":"post","link":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/","title":{"rendered":"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux"},"content":{"rendered":"<div id=\"helps-412625540\" class=\"helps-before-content-2 helps-entity-placement\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-3661896953164277\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- 2anuncios display quadrado -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-3661896953164277\"\r\n     data-ad-slot=\"5051229894\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div>\n<p class=\"wp-block-paragraph\">Tuning MariaDB Slow Query. Para acabar com as <strong>Slow Queries<\/strong>, n\u00e3o basta apenas aumentar a mem\u00f3ria do servidor; \u00e9 preciso identificar se o gargalo est\u00e1 na estrutura da consulta, na falta de \u00edndices ou na configura\u00e7\u00e3o do motor de banco de dados.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-o-ponto-de-partida-slow-query-log\">1. O Ponto de Partida: Slow Query Log<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de usar ferramentas externas, voc\u00ea precisa habilitar o diagn\u00f3stico nativo do MariaDB. Isso registrar\u00e1 qualquer consulta que demore mais do que um tempo X para ser executada.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Edite o arquivo <code>\/etc\/my.cnf<\/code> (ou o arquivo correspondente em <code>\/etc\/my.cnf.d\/<\/code>):<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ini, TOML<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>slow_query_log = 1\nslow_query_log_file = \/var\/lib\/mysql\/slow-queries.log\nlong_query_time = 2\nlog_queries_not_using_indexes = 1\n<\/pre><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>long_query_time<\/strong>: Define o limite (em segundos). Para um ajuste fino, voc\u00ea pode baixar para <code>1<\/code> ou at\u00e9 <code>0.5<\/code>.<\/li>\n\n\n\n<li><strong>log_queries_not_using_indexes<\/strong>: Crucial para identificar tabelas que est\u00e3o for\u00e7ando um &#8220;Full Table Scan&#8221;.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-ferramentas-de-diagnostico-essenciais\">2. Ferramentas de Diagn\u00f3stico Essenciais<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-mysqldumpslow\">A. mysqldumpslow<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ferramenta nativa que resume o log de consultas lentas. Como os logs podem ficar gigantescos, ela agrupa consultas similares.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Comando \u00fatil:<\/strong> <code>mysqldumpslow -s at -t 10 \/var\/lib\/mysql\/slow-queries.log<\/code> <em>(Exibe as 10 consultas com a maior m\u00e9dia de tempo de execu\u00e7\u00e3o).<\/em><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-b-mysqltuner-diagnostico-de-configuracao\">B. MySQLTuner (Diagn\u00f3stico de Configura\u00e7\u00e3o)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Focada em par\u00e2metros do <code>my.cnf<\/code>. Ela analisa o uptime do servidor e sugere ajustes no <code>innodb_buffer_pool_size<\/code>, <code>query_cache<\/code>, entre outros.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Como usar:<\/strong>Bash<code>wget http:\/\/mysqltuner.pl\/ -O mysqltuner.pl perl mysqltuner.pl <\/code><strong>Dica de Admin:<\/strong> No CloudLinux, preste aten\u00e7\u00e3o especial \u00e0s recomenda\u00e7\u00f5es de <strong>InnoDB Buffer Pool<\/strong>. Ele deve ser grande o suficiente para manter seus \u00edndices em RAM.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-c-percona-toolkit-pt-query-digest\">C. Percona Toolkit (pt-query-digest)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A ferramenta mais avan\u00e7ada para an\u00e1lise. O <code>pt-query-digest<\/code> gera um relat\u00f3rio detalhado com o impacto de cada query no sistema.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Instala\u00e7\u00e3o (AlmaLinux\/CentOS):<\/strong> <code>yum install percona-toolkit<\/code><\/li>\n\n\n\n<li><strong>An\u00e1lise:<\/strong> <code>pt-query-digest \/var\/lib\/mysql\/slow-queries.log<\/code><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-analisando-a-query-individualmente-explain\">3. Analisando a Query Individualmente: EXPLAIN<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ao identificar uma query lenta, voc\u00ea deve rod\u00e1-la manualmente no terminal do MariaDB prefixada pelo comando <code>EXPLAIN<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>EXPLAIN SELECT * FROM wp_posts WHERE post_status = 'publish' ORDER BY post_date DESC;\n<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>O que observar no resultado:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>type:<\/strong> Se aparecer <code>ALL<\/code>, significa que o banco leu a tabela inteira. Procure por <code>ref<\/code> ou <code>range<\/code>.<\/li>\n\n\n\n<li><strong>rows:<\/strong> Quantidade de linhas que o MariaDB precisou escanear.<\/li>\n\n\n\n<li><strong>key:<\/strong> Indica qual \u00edndice foi usado. Se estiver <code>NULL<\/code>, voc\u00ea tem um problema de indexa\u00e7\u00e3o.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-monitoramento-em-tempo-real\">4. Monitoramento em Tempo Real<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Se o servidor est\u00e1 travando <strong>agora<\/strong>, utilize o comando:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SHOW FULL PROCESSLIST;\n<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Ou, para uma interface visual no terminal (estilo <code>htop<\/code>):<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bash<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>mytop\n# ou\nhtop (pressionando F6 e escolhendo IO_READ\/WRITE para ver o impacto do mysql)\n<\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-resumo-de-boas-praticas\">Resumo de Boas Pr\u00e1ticas<\/h2>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Indexa\u00e7\u00e3o:<\/strong> Nunca fa\u00e7a buscas por colunas que n\u00e3o possuem \u00edndices (especialmente em tabelas grandes de WordPress como <code>wp_options<\/code> ou <code>wp_postmeta<\/code>).<\/li>\n\n\n\n<li><strong>Limite o Resultado:<\/strong> Use <code>LIMIT<\/code> sempre que poss\u00edvel.<\/li>\n\n\n\n<li><strong>Mem\u00f3ria:<\/strong> Garanta que o <code>innodb_buffer_pool_size<\/code> ocupe cerca de 50-70% da RAM dispon\u00edvel se o servidor for dedicado a banco de dados.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-faq\">FAQ<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1770158709317\"><strong class=\"schema-faq-question\">O que causa Slow Queries no MariaDB?<\/strong> <p class=\"schema-faq-answer\">Geralmente s\u00e3o causadas pela falta de \u00edndices em tabelas grandes, consultas mal estruturadas (JOINs ineficientes) ou falta de mem\u00f3ria no <code>innodb_buffer_pool_size<\/code>.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1770158760535\"><strong class=\"schema-faq-question\">Como habilitar o log de consultas lentas?<\/strong> <p class=\"schema-faq-answer\">Edite o arquivo <code>my.cnf<\/code>, defina <code>slow_query_log = 1<\/code> e configure o <code>long_query_time<\/code> para o limite de segundos desejado.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1770158777695\"><strong class=\"schema-faq-question\">Qual a melhor ferramenta para diagn\u00f3stico de MySQL?<\/strong> <p class=\"schema-faq-answer\">As ferramentas mais recomendadas s\u00e3o o <strong>MySQLTuner<\/strong> para configura\u00e7\u00f5es do sistema e o <strong>pt-query-digest<\/strong> (Percona Toolkit) para an\u00e1lise profunda dos logs.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Tuning MariaDB Slow Query. Para acabar com as Slow Queries, n\u00e3o basta apenas aumentar a mem\u00f3ria do servidor; \u00e9 preciso identificar se [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":2920,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,1279],"tags":[2696,13,29,2698,2694],"class_list":["post-2917","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gerenciamento-servidor","category-linux","tag-administracao-de-sistemas-2","tag-linux","tag-mariadb","tag-otimizacao-de-banco-de-dados","tag-performance-de-servidor"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.9 (Yoast SEO v27.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux<\/title>\n<meta name=\"description\" content=\"Aprenda a eliminar gargalos no banco de dados. Guia pr\u00e1tico de Tuning MariaDB com Slow Query Log, MySQLTuner e EXPLAIN para administradores de servidores.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux\" \/>\n<meta property=\"og:description\" content=\"Aprenda a eliminar gargalos no banco de dados. Guia pr\u00e1tico de Tuning MariaDB com Slow Query Log, MySQLTuner e EXPLAIN para administradores de servidores.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog HelpSysAdmin\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-03T22:55:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-03T22:59:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/02\/db_performance.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"HelpSysAdmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brhelpsysad\" \/>\n<meta name=\"twitter:site\" content=\"@brhelpsysad\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/\"},\"author\":{\"name\":\"HelpSysAdmin\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/bdbe3d7d71a0c6a3cb474c18da574efb\"},\"headline\":\"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux\",\"datePublished\":\"2026-02-03T22:55:21+00:00\",\"dateModified\":\"2026-02-03T22:59:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/\"},\"wordCount\":491,\"publisher\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/02\\/db_performance.webp\",\"keywords\":[\"Administra\u00e7\u00e3o de Sistemas\",\"linux\",\"mariadb\",\"Otimiza\u00e7\u00e3o de Banco de Dados\",\"Performance de Servidor\"],\"articleSection\":[\"Gerenciamento de Servidor\",\"Linux\"],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/\",\"name\":\"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/02\\/db_performance.webp\",\"datePublished\":\"2026-02-03T22:55:21+00:00\",\"dateModified\":\"2026-02-03T22:59:16+00:00\",\"description\":\"Aprenda a eliminar gargalos no banco de dados. Guia pr\u00e1tico de Tuning MariaDB com Slow Query Log, MySQLTuner e EXPLAIN para administradores de servidores.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158709317\"},{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158760535\"},{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158777695\"}],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#primaryimage\",\"url\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/02\\/db_performance.webp\",\"contentUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/02\\/db_performance.webp\",\"width\":1024,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\",\"name\":\"Blog HelpSysAdmin\",\"description\":\"Webserver linux blog\",\"publisher\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\"},\"alternateName\":\"HelpSysAdmin Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\",\"name\":\"HelpSysAdmin Gerenciamento de Servidores\",\"alternateName\":\"HelpSysAdmin\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\/\\/mlkpd8g42nae.i.optimole.com\\/w:512\\/h:512\\/q:mauto\\/f:best\\/https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2020\\/12\\/favicon.png\",\"contentUrl\":\"https:\\/\\/mlkpd8g42nae.i.optimole.com\\/w:512\\/h:512\\/q:mauto\\/f:best\\/https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2020\\/12\\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"HelpSysAdmin Gerenciamento de Servidores\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/brhelpsysad\",\"https:\\\/\\\/mastodon.social\\\/@helpsysadmin\"],\"description\":\"Oferecemos o gerenciamento de servidores dedicados, vps ou cloud. Apresentamos a melhor experi\u00eancia em atendimento e servi\u00e7o. Nosso time cuidar\u00e1 do seu servidor com backups, an\u00e1lises constantes, ajustes de seguran\u00e7a, realiza\u00e7\u00e3o de manuten\u00e7\u00e3o preventiva e corretiva, otimiza\u00e7\u00e3o de performance al\u00e9m de monitoramento 24\u00d77 com suporte Pr\u00f3 Ativo.\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1\",\"maxValue\":\"10\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/bdbe3d7d71a0c6a3cb474c18da574efb\",\"name\":\"HelpSysAdmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g\",\"caption\":\"HelpSysAdmin\"},\"sameAs\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\"]},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158709317\",\"position\":1,\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158709317\",\"name\":\"O que causa Slow Queries no MariaDB?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Geralmente s\u00e3o causadas pela falta de \u00edndices em tabelas grandes, consultas mal estruturadas (JOINs ineficientes) ou falta de mem\u00f3ria no innodb_buffer_pool_size.\",\"inLanguage\":\"pt-BR\"},\"inLanguage\":\"pt-BR\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158760535\",\"position\":2,\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158760535\",\"name\":\"Como habilitar o log de consultas lentas?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Edite o arquivo my.cnf, defina slow_query_log = 1 e configure o long_query_time para o limite de segundos desejado.\",\"inLanguage\":\"pt-BR\"},\"inLanguage\":\"pt-BR\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158777695\",\"position\":3,\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-slow-query-linux\\\/#faq-question-1770158777695\",\"name\":\"Qual a melhor ferramenta para diagn\u00f3stico de MySQL?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"As ferramentas mais recomendadas s\u00e3o o <strong>MySQLTuner<\\\/strong> para configura\u00e7\u00f5es do sistema e o <strong>pt-query-digest<\\\/strong> (Percona Toolkit) para an\u00e1lise profunda dos logs.\",\"inLanguage\":\"pt-BR\"},\"inLanguage\":\"pt-BR\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux","description":"Aprenda a eliminar gargalos no banco de dados. Guia pr\u00e1tico de Tuning MariaDB com Slow Query Log, MySQLTuner e EXPLAIN para administradores de servidores.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/","og_locale":"pt_BR","og_type":"article","og_title":"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux","og_description":"Aprenda a eliminar gargalos no banco de dados. Guia pr\u00e1tico de Tuning MariaDB com Slow Query Log, MySQLTuner e EXPLAIN para administradores de servidores.","og_url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/","og_site_name":"Blog HelpSysAdmin","article_published_time":"2026-02-03T22:55:21+00:00","article_modified_time":"2026-02-03T22:59:16+00:00","og_image":[{"width":1024,"height":768,"url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/02\/db_performance.webp","type":"image\/webp"}],"author":"HelpSysAdmin","twitter_card":"summary_large_image","twitter_creator":"@brhelpsysad","twitter_site":"@brhelpsysad","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#article","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/"},"author":{"name":"HelpSysAdmin","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/person\/bdbe3d7d71a0c6a3cb474c18da574efb"},"headline":"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux","datePublished":"2026-02-03T22:55:21+00:00","dateModified":"2026-02-03T22:59:16+00:00","mainEntityOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/"},"wordCount":491,"publisher":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/02\/db_performance.webp","keywords":["Administra\u00e7\u00e3o de Sistemas","linux","mariadb","Otimiza\u00e7\u00e3o de Banco de Dados","Performance de Servidor"],"articleSection":["Gerenciamento de Servidor","Linux"],"inLanguage":"pt-BR"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/","url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/","name":"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#primaryimage"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/02\/db_performance.webp","datePublished":"2026-02-03T22:55:21+00:00","dateModified":"2026-02-03T22:59:16+00:00","description":"Aprenda a eliminar gargalos no banco de dados. Guia pr\u00e1tico de Tuning MariaDB com Slow Query Log, MySQLTuner e EXPLAIN para administradores de servidores.","breadcrumb":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158709317"},{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158760535"},{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158777695"}],"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#primaryimage","url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/02\/db_performance.webp","contentUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/02\/db_performance.webp","width":1024,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/helpsysadmin.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Tuning MariaDB: Como Identificar e Corrigir Slow Queries no Linux"}]},{"@type":"WebSite","@id":"https:\/\/helpsysadmin.com.br\/blog\/#website","url":"https:\/\/helpsysadmin.com.br\/blog\/","name":"Blog HelpSysAdmin","description":"Webserver linux blog","publisher":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization"},"alternateName":"HelpSysAdmin Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/helpsysadmin.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization","name":"HelpSysAdmin Gerenciamento de Servidores","alternateName":"HelpSysAdmin","url":"https:\/\/helpsysadmin.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:512\/h:512\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2020\/12\/favicon.png","contentUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:512\/h:512\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2020\/12\/favicon.png","width":512,"height":512,"caption":"HelpSysAdmin Gerenciamento de Servidores"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/brhelpsysad","https:\/\/mastodon.social\/@helpsysadmin"],"description":"Oferecemos o gerenciamento de servidores dedicados, vps ou cloud. Apresentamos a melhor experi\u00eancia em atendimento e servi\u00e7o. Nosso time cuidar\u00e1 do seu servidor com backups, an\u00e1lises constantes, ajustes de seguran\u00e7a, realiza\u00e7\u00e3o de manuten\u00e7\u00e3o preventiva e corretiva, otimiza\u00e7\u00e3o de performance al\u00e9m de monitoramento 24\u00d77 com suporte Pr\u00f3 Ativo.","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1","maxValue":"10"}},{"@type":"Person","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/person\/bdbe3d7d71a0c6a3cb474c18da574efb","name":"HelpSysAdmin","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g","caption":"HelpSysAdmin"},"sameAs":["https:\/\/helpsysadmin.com.br\/blog\/"]},{"@type":"Question","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158709317","position":1,"url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158709317","name":"O que causa Slow Queries no MariaDB?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Geralmente s\u00e3o causadas pela falta de \u00edndices em tabelas grandes, consultas mal estruturadas (JOINs ineficientes) ou falta de mem\u00f3ria no innodb_buffer_pool_size.","inLanguage":"pt-BR"},"inLanguage":"pt-BR"},{"@type":"Question","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158760535","position":2,"url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158760535","name":"Como habilitar o log de consultas lentas?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Edite o arquivo my.cnf, defina slow_query_log = 1 e configure o long_query_time para o limite de segundos desejado.","inLanguage":"pt-BR"},"inLanguage":"pt-BR"},{"@type":"Question","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158777695","position":3,"url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-slow-query-linux\/#faq-question-1770158777695","name":"Qual a melhor ferramenta para diagn\u00f3stico de MySQL?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"As ferramentas mais recomendadas s\u00e3o o <strong>MySQLTuner<\/strong> para configura\u00e7\u00f5es do sistema e o <strong>pt-query-digest<\/strong> (Percona Toolkit) para an\u00e1lise profunda dos logs.","inLanguage":"pt-BR"},"inLanguage":"pt-BR"}]}},"lang":"pt","translations":{"pt":2917},"pll_sync_post":{},"_links":{"self":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/2917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/comments?post=2917"}],"version-history":[{"count":1,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/2917\/revisions"}],"predecessor-version":[{"id":2919,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/2917\/revisions\/2919"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/media\/2920"}],"wp:attachment":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/media?parent=2917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/categories?post=2917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/tags?post=2917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}