{"id":19592,"date":"2019-10-25T15:00:11","date_gmt":"2019-10-25T18:00:11","guid":{"rendered":"https:\/\/king.host\/wiki\/?post_type=article&#038;p=19592"},"modified":"2021-09-14T11:20:03","modified_gmt":"2021-09-14T14:20:03","slug":"otimizar-tabelas-do-mysql","status":"publish","type":"article","link":"https:\/\/king.host\/wiki\/artigo\/otimizar-tabelas-do-mysql\/","title":{"rendered":"Otimizar tabelas do MySQL no phpMyAdmin"},"content":{"rendered":"\n<p>Est\u00e1 com o banco de dados apresentando lentid\u00e3o? Veja neste artigo como otimizar tabelas do Mysql no <a href=\"https:\/\/pt.wikipedia.org\/wiki\/PhpMyAdmin\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"phpMyAdmin (abre numa nova aba)\">phpMyAdmin<\/a> e melhorar o desempenho do site! \ud83d\ude42<\/p>\n\n\n\n<p>Depois de fazer muitas inser\u00e7\u00f5es, atualiza\u00e7\u00f5es ou exclus\u00f5es em uma tabela do seu banco de dados, as linhas apagadas s\u00e3o armazenadas em uma lista encadeada e as opera\u00e7\u00f5es de inser\u00e7\u00e3o  reutilizam as posi\u00e7\u00f5es das linhas antigas, fazendo com que o banco acabe ficando lento de forma gradual.  <\/p>\n\n\n\n<p> A fun\u00e7\u00e3o de otimizar tabela basicamente desfragmenta essas linhas e espa\u00e7os inutilizados, fazendo com que melhore o desempenho das instru\u00e7\u00f5es que s\u00e3o utilizadas na tabela.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Como otimizar tabelas do MySQL no phpMyAdmin<\/h2>\n\n\n\n<p> Primeiramente iremos acessar a op\u00e7\u00e3o \u201cPHPMYADMIN\u201d que fica no fim da p\u00e1gina do painel da sua hospedagem.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-original=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/001.png\" alt=\"Otimizar tabelas do MySQL\" class=\"wp-image-19593\"\/><\/figure><\/div>\n\n\n\n<p> Ap\u00f3s clicar, voc\u00ea ser\u00e1 redirecionado para a p\u00e1gina de login do seu banco de dados, onde voc\u00ea deve colocar o usu\u00e1rio e senha do mesmo.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"498\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/002.png\" alt=\"Otimizar tabelas do MySQL\" class=\"wp-image-19594 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/002.png 582w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/002-300x257.png 300w\" data-sizes=\"(max-width: 582px) 100vw, 582px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 582px; --smush-placeholder-aspect-ratio: 582\/498;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"498\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/002.png\" alt=\"Otimizar tabelas do MySQL\" class=\"wp-image-19594\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/002.png 582w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/002-300x257.png 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/noscript><\/figure><\/div>\n\n\n\n<p>No canto superior esquerdo ir\u00e1 aparecer o banco de dados em que voc\u00ea efetuou o login, sendo assim, clique nele.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"290\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/003.png\" alt=\"\" class=\"wp-image-19595 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/003.png 400w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/003-300x218.png 300w\" data-sizes=\"(max-width: 400px) 100vw, 400px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 400px; --smush-placeholder-aspect-ratio: 400\/290;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"290\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/003.png\" alt=\"\" class=\"wp-image-19595\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/003.png 400w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/003-300x218.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/noscript><\/figure><\/div>\n\n\n\n<p> Ap\u00f3s ter clicado no seu banco de dados, ir\u00e3o aparecer todas as tabelas existentes no seu banco atualmente, assim, marque a checkbox \u201c<strong>Marcar todos<\/strong>\u201d  e no lado dessa op\u00e7\u00e3o escolha a a\u00e7\u00e3o \u201c<strong>Otimizar Tabela<\/strong>\u201d<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"400\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004-960x400.png\" alt=\"Otimizar tabelas do MySQL\" class=\"wp-image-19596 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004-960x400.png 960w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004-300x125.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004-768x320.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004.png 1348w\" data-sizes=\"(max-width: 960px) 100vw, 960px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 960px; --smush-placeholder-aspect-ratio: 960\/400;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"400\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004-960x400.png\" alt=\"Otimizar tabelas do MySQL\" class=\"wp-image-19596\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004-960x400.png 960w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004-300x125.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004-768x320.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/004.png 1348w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><\/figure><\/div>\n\n\n\n<p> Pronto! Vai gerar o resultado do comando que efetua a otimiza\u00e7\u00e3o das tabelas.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"542\" data-src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1-960x542.png\" alt=\"\" class=\"wp-image-19598 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1-960x542.png 960w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1-300x169.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1-768x433.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1.png 1329w\" data-sizes=\"(max-width: 960px) 100vw, 960px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 960px; --smush-placeholder-aspect-ratio: 960\/542;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"542\" src=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1-960x542.png\" alt=\"\" class=\"wp-image-19598\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1-960x542.png 960w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1-300x169.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1-768x433.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2019\/10\/005-1.png 1329w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/noscript><\/figure><\/div>\n","protected":false},"author":9,"featured_media":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","article-category":[176],"article-tag":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/19592"}],"collection":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/comments?post=19592"}],"version-history":[{"count":0,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/19592\/revisions"}],"wp:attachment":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/media?parent=19592"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-category?post=19592"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-tag?post=19592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}