{"id":2267,"date":"2020-01-20T09:21:14","date_gmt":"2020-01-20T09:21:14","guid":{"rendered":"https:\/\/example.com\/wordpress\/?p=2267"},"modified":"2020-01-20T09:21:14","modified_gmt":"2020-01-20T09:21:14","slug":"how-to-examine-or-optimize-a-database-in-directadmin","status":"publish","type":"post","link":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/","title":{"rendered":"How to examine or optimize a database in DirectAdmin?"},"content":{"rendered":"<p><span style=\"font-size: medium;\"><strong>1.<\/strong> Log in to your DirectAdmin Account.<\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>2.<\/strong> In the <strong>Account Manager<\/strong> section, click on the <strong>MySQL Management<\/strong> icon or type <strong>MySQL Management<\/strong> in the navigation filter box. The option will appear. Click on it.<\/span><br \/><span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/img\/da-mysql-management-icon.gif\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>3.<\/strong> Under <strong>database<\/strong> text, select the database. You can select multiple databases for examining or optimizing them.<\/span><br \/><span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/img\/da-mysql-checkopt.gif\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>4.<\/strong> Click on the <strong>Check<\/strong> button to examine or click on <strong>Optimize<\/strong> to optimize your database.<\/span><\/p>\n<p><span style=\"font-size: medium;\">This will display a result. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log in to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management icon or type MySQL Management in the navigation filter box. The option will appear. Click on it. 3. Under database text, select the database. You can select multiple databases for examining or optimizing them. 4. Click on [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-2267","post","type-post","status-publish","format-standard","hentry","category-databases-directadmin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to examine or optimize a database in DirectAdmin? - Reselhost<\/title>\n<meta name=\"description\" content=\"How to examine or optimize a database in DirectAdmin? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to examine or optimize a database in DirectAdmin? - Reselhost\" \/>\n<meta property=\"og:description\" content=\"How to examine or optimize a database in DirectAdmin? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Reselhost\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/reselhost\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-20T09:21:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2021\/08\/face-anuncio.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"648\" \/>\n\t<meta property=\"og:image:height\" content=\"441\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"intelhost\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@reselhost\" \/>\n<meta name=\"twitter:site\" content=\"@reselhost\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"intelhost\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/\"},\"author\":{\"name\":\"intelhost\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/cc9804f5a4bd9b28316dd9188422dd8e\"},\"headline\":\"How to examine or optimize a database in DirectAdmin?\",\"datePublished\":\"2020-01-20T09:21:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/\"},\"wordCount\":78,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#organization\"},\"articleSection\":[\"Databases DirectAdmin\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/\",\"url\":\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/\",\"name\":\"How to examine or optimize a database in DirectAdmin? - Reselhost\",\"isPartOf\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#website\"},\"datePublished\":\"2020-01-20T09:21:14+00:00\",\"description\":\"How to examine or optimize a database in DirectAdmin? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month\",\"breadcrumb\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.reselhost.eu\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to examine or optimize a database in DirectAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#website\",\"url\":\"https:\/\/www.reselhost.eu\/kb\/\",\"name\":\"Reselhost\",\"description\":\"Knowledge Base Web Hosting Reseller Hosting\",\"publisher\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.reselhost.eu\/kb\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#organization\",\"name\":\"Reselhost LLC\",\"alternateName\":\"Reselhost\",\"url\":\"https:\/\/www.reselhost.eu\/kb\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2023\/06\/logo-grande-ok.jpg\",\"contentUrl\":\"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2023\/06\/logo-grande-ok.jpg\",\"width\":500,\"height\":500,\"caption\":\"Reselhost LLC\"},\"image\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/reselhost\",\"https:\/\/x.com\/reselhost\",\"https:\/\/www.instagram.com\/reselhost\",\"https:\/\/www.linkedin.com\/in\/reselhost\",\"https:\/\/www.youtube.com\/@reselhost\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/cc9804f5a4bd9b28316dd9188422dd8e\",\"name\":\"intelhost\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g\",\"caption\":\"intelhost\"},\"sameAs\":[\"https:\/\/www.intelhost.net\/kb\"],\"url\":\"https:\/\/www.reselhost.eu\/kb\/author\/intelhost\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to examine or optimize a database in DirectAdmin? - Reselhost","description":"How to examine or optimize a database in DirectAdmin? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month","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:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/","og_locale":"en_GB","og_type":"article","og_title":"How to examine or optimize a database in DirectAdmin? - Reselhost","og_description":"How to examine or optimize a database in DirectAdmin? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month","og_url":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/","og_site_name":"Reselhost","article_publisher":"https:\/\/www.facebook.com\/reselhost","article_published_time":"2020-01-20T09:21:14+00:00","og_image":[{"width":648,"height":441,"url":"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2021\/08\/face-anuncio.jpg","type":"image\/jpeg"}],"author":"intelhost","twitter_card":"summary_large_image","twitter_creator":"@reselhost","twitter_site":"@reselhost","twitter_misc":{"Written by":"intelhost"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/#article","isPartOf":{"@id":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/"},"author":{"name":"intelhost","@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/cc9804f5a4bd9b28316dd9188422dd8e"},"headline":"How to examine or optimize a database in DirectAdmin?","datePublished":"2020-01-20T09:21:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/"},"wordCount":78,"commentCount":0,"publisher":{"@id":"https:\/\/www.reselhost.eu\/kb\/#organization"},"articleSection":["Databases DirectAdmin"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/","url":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/","name":"How to examine or optimize a database in DirectAdmin? - Reselhost","isPartOf":{"@id":"https:\/\/www.reselhost.eu\/kb\/#website"},"datePublished":"2020-01-20T09:21:14+00:00","description":"How to examine or optimize a database in DirectAdmin? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month","breadcrumb":{"@id":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.reselhost.eu\/kb\/how-to-examine-or-optimize-a-database-in-directadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.reselhost.eu\/kb\/"},{"@type":"ListItem","position":2,"name":"How to examine or optimize a database in DirectAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/www.reselhost.eu\/kb\/#website","url":"https:\/\/www.reselhost.eu\/kb\/","name":"Reselhost","description":"Knowledge Base Web Hosting Reseller Hosting","publisher":{"@id":"https:\/\/www.reselhost.eu\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.reselhost.eu\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.reselhost.eu\/kb\/#organization","name":"Reselhost LLC","alternateName":"Reselhost","url":"https:\/\/www.reselhost.eu\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2023\/06\/logo-grande-ok.jpg","contentUrl":"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2023\/06\/logo-grande-ok.jpg","width":500,"height":500,"caption":"Reselhost LLC"},"image":{"@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/reselhost","https:\/\/x.com\/reselhost","https:\/\/www.instagram.com\/reselhost","https:\/\/www.linkedin.com\/in\/reselhost","https:\/\/www.youtube.com\/@reselhost"]},{"@type":"Person","@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/cc9804f5a4bd9b28316dd9188422dd8e","name":"intelhost","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g","caption":"intelhost"},"sameAs":["https:\/\/www.intelhost.net\/kb"],"url":"https:\/\/www.reselhost.eu\/kb\/author\/intelhost\/"}]}},"_links":{"self":[{"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/posts\/2267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/comments?post=2267"}],"version-history":[{"count":0,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/posts\/2267\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/media?parent=2267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/categories?post=2267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/tags?post=2267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}