{"id":3565,"date":"2026-02-22T09:00:00","date_gmt":"2026-02-22T12:00:00","guid":{"rendered":"https:\/\/helpsysadmin.com.br\/blog\/?p=3565"},"modified":"2026-04-12T15:58:34","modified_gmt":"2026-04-12T18:58:34","slug":"tuning-mariadb-mysql-my-cnf-innodb","status":"publish","type":"post","link":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/","title":{"rendered":"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)"},"content":{"rendered":"<div id=\"helps-883970739\" 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\">Fazer o <strong>tuning MariaDB e MySQL<\/strong> atrav\u00e9s do arquivo <code>my.cnf<\/code> (ou <code>50-server.cnf<\/code> em instala\u00e7\u00f5es modernas) \u00e9 o passo mais r\u00e1pido para transformar um banco de dados engasgado em uma m\u00e1quina de alta performance. As configura\u00e7\u00f5es padr\u00e3o geralmente s\u00e3o conservadoras, projetadas para rodar em servidores pequenos sem consumir todos os recursos.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Se voc\u00ea tem um servidor dedicado para o seu banco de dados, n\u00e3o fazer um <strong>tuning MariaDB e MySQL<\/strong> \u00e9 um verdadeiro desperd\u00edcio de hardware.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aqui est\u00e3o as 5 vari\u00e1veis fundamentais que voc\u00ea deve ajustar hoje, com um foco especial no motor InnoDB.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-innodb-buffer-pool-size-o-coracao-da-performance\">1. <code>innodb_buffer_pool_size<\/code> (O Cora\u00e7\u00e3o da Performance)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">No universo do <strong>tuning MariaDB e MySQL<\/strong>, esta \u00e9, sem d\u00favida, a vari\u00e1vel mais importante do seu servidor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">O Buffer Pool \u00e9 a \u00e1rea de mem\u00f3ria (RAM) onde o InnoDB faz o cache dos dados das tabelas e dos \u00edndices. Quando os dados est\u00e3o no Buffer Pool, o banco de dados n\u00e3o precisa ir at\u00e9 o disco r\u00edgido (que \u00e9 muito mais lento) para buscar as informa\u00e7\u00f5es.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>A Regra de Ouro:<\/strong> Se o seu servidor \u00e9 dedicado apenas ao banco de dados, voc\u00ea deve alocar de <strong>60% a 80% da mem\u00f3ria RAM total<\/strong> do servidor para esta vari\u00e1vel.<\/li>\n\n\n\n<li><strong>Aten\u00e7\u00e3o:<\/strong> Se o servidor compartilha recursos com um servidor web ou PHP, seja mais conservador (ex: 30% a 50%) para evitar o uso de mem\u00f3ria Swap.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Exemplo no \/etc\/<code>my.cnf<\/code>:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>innodb_buffer_pool_size = 12G\n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-innodb-buffer-pool-instances-para-alta-concorrencia\">2. <code>innodb_buffer_pool_instances<\/code> (Para Alta Concorr\u00eancia)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Um bom <strong>tuning MariaDB e MySQL<\/strong> n\u00e3o foca apenas em tamanho, mas na concorr\u00eancia. Ter um Buffer Pool gigante \u00e9 \u00f3timo, mas se muitas threads tentarem ler e escrever nele ao mesmo tempo, elas podem criar um &#8220;engarrafamento&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dividir o Buffer Pool em v\u00e1rias inst\u00e2ncias permite que diferentes threads operem em \u00e1reas distintas da mem\u00f3ria simultaneamente.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Como ajustar:<\/strong> Configure <strong>1 inst\u00e2ncia para cada 1GB<\/strong> de <code>innodb_buffer_pool_size<\/code> (limite \u00fatil entre 8 e 16).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Exemplo no <code>my.cnf<\/code>:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>innodb_buffer_pool_instances = 8 \n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-innodb-log-file-size-performance-de-escrita\">3. <code>innodb_log_file_size<\/code> (Performance de Escrita)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Um erro comum ao ignorar o <strong>tuning MariaDB e MySQL<\/strong> \u00e9 manter os arquivos de log (Redo Logs) muito pequenos. O InnoDB grava todas as altera\u00e7\u00f5es de dados primeiro nestes arquivos.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Se eles forem muito pequenos, o banco precisar\u00e1 gravar no disco definitivo com muita frequ\u00eancia, causando picos de lentid\u00e3o em <code>INSERT<\/code>, <code>UPDATE<\/code> e <code>DELETE<\/code>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Como ajustar:<\/strong> Um bom ponto de partida \u00e9 cerca de <strong>25% do tamanho do seu Buffer Pool<\/strong>, ou valores entre <strong>1G e 4G<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Exemplo no <code>my.cnf<\/code>:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>innodb_log_file_size = 2G\n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-4-innodb-flush-log-at-trx-commit-velocidade-vs-seguranca\">4. <code>innodb_flush_log_at_trx_commit<\/code> (Velocidade vs. Seguran\u00e7a)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Se voc\u00ea quer sentir o impacto imediato do seu <strong>tuning MariaDB e MySQL<\/strong> em opera\u00e7\u00f5es de escrita, este \u00e9 o maior &#8220;bot\u00e3o de velocidade&#8221;, mas envolve um risco calculado.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><code>1<\/code> (Seguro):<\/strong> Grava no disco a cada transa\u00e7\u00e3o. Mais lento, por\u00e9m ideal para dados financeiros.<\/li>\n\n\n\n<li><strong><code>2<\/code> (Melhor Custo-Benef\u00edcio):<\/strong> Envia a transa\u00e7\u00e3o para o cache do SO imediatamente, gravando no disco f\u00edsico 1 vez por segundo. A performance de escrita aumenta absurdamente.<\/li>\n\n\n\n<li><strong><code>0<\/code> (Mais R\u00e1pido):<\/strong> Grava no disco 1 vez por segundo. Risco ligeiramente maior de perda de dados (1 segundo) caso o servi\u00e7o trave.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Exemplo no <code>my.cnf<\/code>:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>innodb_flush_log_at_trx_commit = 2\n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-5-max-connections-estabilidade-do-servidor\">5. <code>max_connections<\/code> (Estabilidade do Servidor)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Nenhum <strong>tuning MariaDB e MySQL<\/strong> est\u00e1 completo sem garantir a estabilidade de acessos simult\u00e2neos. Esta vari\u00e1vel define o n\u00famero m\u00e1ximo de conex\u00f5es permitidas, evitando o erro fatal <code>Too many connections<\/code>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Como ajustar:<\/strong> Valores entre <strong>500 e 2000<\/strong> s\u00e3o comuns para web. Cuidado: n\u00e3o coloque valores altos se n\u00e3o tiver RAM suficiente.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Exemplo no <code>my.cnf<\/code>:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>max_connections = 1000\n<\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Dica de Ouro:<\/strong> Ap\u00f3s aplicar essas pr\u00e1ticas de <strong>tuning MariaDB e MySQL<\/strong> no seu arquivo, voc\u00ea precisar\u00e1 <strong>reiniciar o servi\u00e7o<\/strong> do banco de dados para que as configura\u00e7\u00f5es entrem em vigor.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-faq\"><strong>FAQ:<\/strong><\/h3>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1771648669266\"><strong class=\"schema-faq-question\">Qual o tamanho ideal para o <code>innodb_buffer_pool_size<\/code>?<\/strong> <p class=\"schema-faq-answer\">Para um servidor dedicado exclusivamente ao banco de dados, a recomenda\u00e7\u00e3o padr\u00e3o \u00e9 alocar entre 60% e 80% da mem\u00f3ria RAM total dispon\u00edvel para o <code>innodb_buffer_pool_size<\/code>. Se o servidor compartilha recursos com aplica\u00e7\u00f5es web (como PHP ou Apache), utilize valores mais baixos, entre 30% e 50%, para evitar o uso de mem\u00f3ria Swap.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1771648701489\"><strong class=\"schema-faq-question\">Qual a diferen\u00e7a entre <code>innodb_flush_log_at_trx_commit<\/code> 1 e 2<\/strong> <p class=\"schema-faq-answer\">O valor <code>1<\/code> (padr\u00e3o) grava os dados no disco f\u00edsico a cada transa\u00e7\u00e3o, sendo a op\u00e7\u00e3o mais segura, por\u00e9m a mais lenta. O valor <code>2<\/code> envia a transa\u00e7\u00e3o para o cache do sistema imediatamente, mas s\u00f3 grava no disco f\u00edsico uma vez por segundo. O valor <code>2<\/code> oferece um ganho gigantesco de performance com um risco baix\u00edssimo de perda de dados (m\u00e1ximo de 1 segundo em caso de queda de energia no servidor).<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1771648777335\"><strong class=\"schema-faq-question\">Preciso reiniciar o MySQL ap\u00f3s alterar o arquivo my.cnf?<\/strong> <p class=\"schema-faq-answer\">Sim. A maioria das configura\u00e7\u00f5es estruturais de mem\u00f3ria e log, como o <code>innodb_buffer_pool_size<\/code> e o <code>innodb_log_file_size<\/code>, exigem que o servi\u00e7o do MariaDB ou MySQL seja reiniciado para que as novas vari\u00e1veis entrem em vigor no sistema.<\/p> <\/div> <\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-veja-mais\"><strong>Veja Mais:<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/helpsysadmin.com.br\/blog\/otimizar-mariadb-my-cnf-producao\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Otimizar MariaDB em 5 Minutos: Guia Pr\u00e1tico do my.cnf em Produ\u00e7\u00e3o<\/strong><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/helpsysadmin.com.br\/blog\/tcp-tuning-wordpress-alta-performance\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>TCP Tuning para WordPress: Guia de Alta Performance<\/strong><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/helpsysadmin.com.br\/blog\/otimizacao-de-perfomance-do-mariadb\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Guia completo para otimiza\u00e7\u00e3o de perfomance do mariadb<\/strong><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/helpsysadmin.com.br\/blog\/testar-velocidade-da-internet-do-servidor-linux-com-speedtest-cli\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Como testar a velocidade da internet do servidor linux com speedtest-cli<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fazer o tuning MariaDB e MySQL atrav\u00e9s do arquivo my.cnf (ou 50-server.cnf em instala\u00e7\u00f5es modernas) \u00e9 o passo mais r\u00e1pido para transformar [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":3566,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4189],"tags":[3661,3665,3667,29,437,3663],"class_list":["post-3565","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-performance-e-otimizacao","tag-banco-de-dados-2","tag-devops-e-servidores","tag-innodb","tag-mariadb","tag-mysql","tag-performance-e-otimizacao"],"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 e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)<\/title>\n<meta name=\"description\" content=\"Aprenda a fazer o tuning do seu servidor MariaDB e MySQL ajustando 5 vari\u00e1veis no my.cnf, incluindo o innodb_buffer_pool. Melhore sua performance hoje!\" \/>\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-mysql-my-cnf-innodb\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)\" \/>\n<meta property=\"og:description\" content=\"Aprenda a fazer o tuning do seu servidor MariaDB e MySQL ajustando 5 vari\u00e1veis no my.cnf, incluindo o innodb_buffer_pool. Melhore sua performance hoje!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog HelpSysAdmin\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-22T12:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-12T18:58:34+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\/tuning_mariadb_mysql.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"655\" \/>\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-mysql-my-cnf-innodb\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/\"},\"author\":{\"name\":\"HelpSysAdmin\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/bdbe3d7d71a0c6a3cb474c18da574efb\"},\"headline\":\"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)\",\"datePublished\":\"2026-02-22T12:00:00+00:00\",\"dateModified\":\"2026-04-12T18:58:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/\"},\"wordCount\":834,\"publisher\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/02\\/tuning_mariadb_mysql.webp\",\"keywords\":[\"Banco de Dados\",\"DevOps e Servidores\",\"InnoDB\",\"mariadb\",\"mysql\",\"Performance e Otimiza\u00e7\u00e3o\"],\"articleSection\":[\"Performance e Otimiza\u00e7\u00e3o (Tuning)\"],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/\",\"name\":\"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/02\\/tuning_mariadb_mysql.webp\",\"datePublished\":\"2026-02-22T12:00:00+00:00\",\"dateModified\":\"2026-04-12T18:58:34+00:00\",\"description\":\"Aprenda a fazer o tuning do seu servidor MariaDB e MySQL ajustando 5 vari\u00e1veis no my.cnf, incluindo o innodb_buffer_pool. Melhore sua performance hoje!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#faq-question-1771648669266\"},{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#faq-question-1771648701489\"},{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#faq-question-1771648777335\"}],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#primaryimage\",\"url\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/02\\/tuning_mariadb_mysql.webp\",\"contentUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/02\\/tuning_mariadb_mysql.webp\",\"width\":1200,\"height\":655},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)\"}]},{\"@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-mysql-my-cnf-innodb\\\/#faq-question-1771648669266\",\"position\":1,\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#faq-question-1771648669266\",\"name\":\"Qual o tamanho ideal para o innodb_buffer_pool_size?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Para um servidor dedicado exclusivamente ao banco de dados, a recomenda\u00e7\u00e3o padr\u00e3o \u00e9 alocar entre 60% e 80% da mem\u00f3ria RAM total dispon\u00edvel para o innodb_buffer_pool_size. Se o servidor compartilha recursos com aplica\u00e7\u00f5es web (como PHP ou Apache), utilize valores mais baixos, entre 30% e 50%, para evitar o uso de mem\u00f3ria Swap.\",\"inLanguage\":\"pt-BR\"},\"inLanguage\":\"pt-BR\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#faq-question-1771648701489\",\"position\":2,\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#faq-question-1771648701489\",\"name\":\"Qual a diferen\u00e7a entre innodb_flush_log_at_trx_commit 1 e 2\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"O valor 1 (padr\u00e3o) grava os dados no disco f\u00edsico a cada transa\u00e7\u00e3o, sendo a op\u00e7\u00e3o mais segura, por\u00e9m a mais lenta. O valor 2 envia a transa\u00e7\u00e3o para o cache do sistema imediatamente, mas s\u00f3 grava no disco f\u00edsico uma vez por segundo. O valor 2 oferece um ganho gigantesco de performance com um risco baix\u00edssimo de perda de dados (m\u00e1ximo de 1 segundo em caso de queda de energia no servidor).\",\"inLanguage\":\"pt-BR\"},\"inLanguage\":\"pt-BR\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#faq-question-1771648777335\",\"position\":3,\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/tuning-mariadb-mysql-my-cnf-innodb\\\/#faq-question-1771648777335\",\"name\":\"Preciso reiniciar o MySQL ap\u00f3s alterar o arquivo my.cnf?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Sim. A maioria das configura\u00e7\u00f5es estruturais de mem\u00f3ria e log, como o innodb_buffer_pool_size e o innodb_log_file_size, exigem que o servi\u00e7o do MariaDB ou MySQL seja reiniciado para que as novas vari\u00e1veis entrem em vigor no sistema.\",\"inLanguage\":\"pt-BR\"},\"inLanguage\":\"pt-BR\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)","description":"Aprenda a fazer o tuning do seu servidor MariaDB e MySQL ajustando 5 vari\u00e1veis no my.cnf, incluindo o innodb_buffer_pool. Melhore sua performance hoje!","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-mysql-my-cnf-innodb\/","og_locale":"pt_BR","og_type":"article","og_title":"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)","og_description":"Aprenda a fazer o tuning do seu servidor MariaDB e MySQL ajustando 5 vari\u00e1veis no my.cnf, incluindo o innodb_buffer_pool. Melhore sua performance hoje!","og_url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/","og_site_name":"Blog HelpSysAdmin","article_published_time":"2026-02-22T12:00:00+00:00","article_modified_time":"2026-04-12T18:58:34+00:00","og_image":[{"width":1200,"height":655,"url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/02\/tuning_mariadb_mysql.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-mysql-my-cnf-innodb\/#article","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/"},"author":{"name":"HelpSysAdmin","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/person\/bdbe3d7d71a0c6a3cb474c18da574efb"},"headline":"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)","datePublished":"2026-02-22T12:00:00+00:00","dateModified":"2026-04-12T18:58:34+00:00","mainEntityOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/"},"wordCount":834,"publisher":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#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\/tuning_mariadb_mysql.webp","keywords":["Banco de Dados","DevOps e Servidores","InnoDB","mariadb","mysql","Performance e Otimiza\u00e7\u00e3o"],"articleSection":["Performance e Otimiza\u00e7\u00e3o (Tuning)"],"inLanguage":"pt-BR"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/","url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/","name":"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#primaryimage"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#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\/tuning_mariadb_mysql.webp","datePublished":"2026-02-22T12:00:00+00:00","dateModified":"2026-04-12T18:58:34+00:00","description":"Aprenda a fazer o tuning do seu servidor MariaDB e MySQL ajustando 5 vari\u00e1veis no my.cnf, incluindo o innodb_buffer_pool. Melhore sua performance hoje!","breadcrumb":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#faq-question-1771648669266"},{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#faq-question-1771648701489"},{"@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#faq-question-1771648777335"}],"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#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\/tuning_mariadb_mysql.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\/tuning_mariadb_mysql.webp","width":1200,"height":655},{"@type":"BreadcrumbList","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/helpsysadmin.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Tuning MariaDB e MySQL: 5 Ajustes no my.cnf (Foco InnoDB)"}]},{"@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-mysql-my-cnf-innodb\/#faq-question-1771648669266","position":1,"url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#faq-question-1771648669266","name":"Qual o tamanho ideal para o innodb_buffer_pool_size?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Para um servidor dedicado exclusivamente ao banco de dados, a recomenda\u00e7\u00e3o padr\u00e3o \u00e9 alocar entre 60% e 80% da mem\u00f3ria RAM total dispon\u00edvel para o innodb_buffer_pool_size. Se o servidor compartilha recursos com aplica\u00e7\u00f5es web (como PHP ou Apache), utilize valores mais baixos, entre 30% e 50%, para evitar o uso de mem\u00f3ria Swap.","inLanguage":"pt-BR"},"inLanguage":"pt-BR"},{"@type":"Question","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#faq-question-1771648701489","position":2,"url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#faq-question-1771648701489","name":"Qual a diferen\u00e7a entre innodb_flush_log_at_trx_commit 1 e 2","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"O valor 1 (padr\u00e3o) grava os dados no disco f\u00edsico a cada transa\u00e7\u00e3o, sendo a op\u00e7\u00e3o mais segura, por\u00e9m a mais lenta. O valor 2 envia a transa\u00e7\u00e3o para o cache do sistema imediatamente, mas s\u00f3 grava no disco f\u00edsico uma vez por segundo. O valor 2 oferece um ganho gigantesco de performance com um risco baix\u00edssimo de perda de dados (m\u00e1ximo de 1 segundo em caso de queda de energia no servidor).","inLanguage":"pt-BR"},"inLanguage":"pt-BR"},{"@type":"Question","@id":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#faq-question-1771648777335","position":3,"url":"https:\/\/helpsysadmin.com.br\/blog\/tuning-mariadb-mysql-my-cnf-innodb\/#faq-question-1771648777335","name":"Preciso reiniciar o MySQL ap\u00f3s alterar o arquivo my.cnf?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Sim. A maioria das configura\u00e7\u00f5es estruturais de mem\u00f3ria e log, como o innodb_buffer_pool_size e o innodb_log_file_size, exigem que o servi\u00e7o do MariaDB ou MySQL seja reiniciado para que as novas vari\u00e1veis entrem em vigor no sistema.","inLanguage":"pt-BR"},"inLanguage":"pt-BR"}]}},"lang":"pt","translations":{"pt":3565},"pll_sync_post":{},"_links":{"self":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/3565","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=3565"}],"version-history":[{"count":3,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/3565\/revisions"}],"predecessor-version":[{"id":5356,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/3565\/revisions\/5356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/media\/3566"}],"wp:attachment":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/media?parent=3565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/categories?post=3565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/tags?post=3565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}