https://wiki.projetoroot.com.br/index.php?action=history&feed=atom&title=Tunning-Mysql 2026-06-04T01:09:08Z Histórico de revisões para esta página neste wiki MediaWiki 1.39.3 https://wiki.projetoroot.com.br/index.php?title=Tunning-Mysql&diff=1161&oldid=prev 2026-02-20T00:17:51Z

<p></p> <a href="https://wiki.projetoroot.com.br/index.php?title=Tunning-Mysql&amp;diff=1161&amp;oldid=286">Mostrar alterações</a>

Diegocosta https://wiki.projetoroot.com.br/index.php?title=Tunning-Mysql&diff=286&oldid=prev 2018-07-30T13:34:07Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="pt-BR"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Edição anterior</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Edição das 10h34min de 30 de julho de 2018</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l50">Linha 50:</td> <td colspan="2" class="diff-lineno">Linha 50:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   innodb_log_file_size = 16M</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   innodb_log_file_size = 16M</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   innodb_buffer_pool_instances = 1</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   innodb_buffer_pool_instances = 1</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* Reiniciar o serviço do Mysql após ajustes</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  /etc/init.d/mysql restart</ins></div></td></tr> <!-- diff cache key c2aps2-wiki_:diff::1.12:old-285:rev-286 --> </table>

Diegocosta https://wiki.projetoroot.com.br/index.php?title=Tunning-Mysql&diff=285&oldid=prev 2018-07-30T13:32:37Z

<p>Criou página com &#039;== Sobre == Olá! Visitante, reunimos aqui, informações sobre o processo de Tunning no Mysql, este procedimento tende a aumentar o desempenho de leitura e escrita em Banco,...&#039;</p> <p><b>Página nova</b></p><div>== Sobre ==<br /> Olá! Visitante, reunimos aqui, informações sobre o processo de Tunning no Mysql, este procedimento tende a aumentar o desempenho de leitura e escrita em Banco, assim aumentando a performance geral do sistema de Banco de Dados em Mysql. Estes ajustes podem auxiliar em momentos que algum sistema ou rede tenham gargalo, ou até mesmo evita um upgrade desnecessário de infra.<br /> <br /> == Otimizando Mysql ==<br /> <br /> * Baixar o Mysql tunner<br /> wget http://mysqltuner.pl/ -O mysqltuner.pl<br /> wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt<br /> <br /> * Executar Teste<br /> perl mysqltuner.pl<br /> <br /> <br /> * Ajustar arquivo my.cf conforme saída do teste<br /> nano etc/mysql/my.cf<br /> <br /> * exemplo de saída <br /> <br /> -------- Recommendations ---------------------------------------------------------------------------<br /> General recommendations:<br /> Dedicate this server to your database for highest performance.<br /> Reduce or eliminate unclosed connections and network issues<br /> Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1<br /> When making adjustments, make tmp_table_size/max_heap_table_size equal<br /> Reduce your SELECT DISTINCT queries which have no LIMIT clause<br /> Performance schema should be activated for better diagnostics<br /> Consider installing Sys schema from https://github.com/mysql/mysql-sys<br /> Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: http://bit.ly/2wgkDvS<br /> <br /> Variables to adjust:<br /> query_cache_size (=0)<br /> query_cache_type (=0)<br /> tmp_table_size (&gt; 16M)<br /> max_heap_table_size (&gt; 16M)<br /> performance_schema = ON enable PFS<br /> innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.<br /> innodb_buffer_pool_instances (=1)<br /> <br /> <br /> * Exemplo de ajustes no Arquivo<br /> <br /> query_cache_limit = 1M<br /> #query_cache_size = 16M<br /> query_cache_size = 0<br /> max_heap_table_size = 16M<br /> performance_schema = ON<br /> <br /> query_cache_size = 0<br /> query_cache_type = 0<br /> innodb_log_file_size = 16M<br /> innodb_buffer_pool_instances = 1</div>

Diegocosta