{"id":20538,"date":"2016-10-19T07:56:30","date_gmt":"2016-10-19T12:56:30","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=20538"},"modified":"2022-06-03T03:42:35","modified_gmt":"2022-06-03T08:42:35","slug":"optimizing-and-repairing-mysql-databases-with-mysqlcheck","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/","title":{"rendered":"MySQLcheck Optimizing and Repairing All Databases"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"512\" class=\"wp-image-37857\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck-1024x512.jpg\" alt=\"optimize repairing mysql databases with mysqlcheck\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck-1024x512.jpg 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck-768x384.jpg 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"alignright size-large is-resized\"><img decoding=\"async\" class=\"wp-image-37860\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysql-optimize-all-tables.png\" alt=\"mysql optimize all tables\" width=\"176\" height=\"119\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysql-optimize-all-tables.png 176w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysql-optimize-all-tables-150x101.png 150w\" sizes=\"(max-width: 176px) 100vw, 176px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>In this tutorial, we will show you how to use MySQLcheck for optimizing and repairing all tables and <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-list-all-databases-in-mysql\/\">databases in MySQL<\/a>. We will talk about mysqlcheck which is a maintenance command-line tool that allows you to check, analyze, repair, and optimize MySQL\/MariaDB tables and databases. Repairing MySQL database is not a complicated process, just follow the steps below carefully. <\/p>\r\n\r\n\r\n\r\n<p><!--more--><\/p>\r\n\r\n\r\n\r\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69e8f6c635076\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69e8f6c635076\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#1-Check-one-table-in-the-MySQL-database\" >1. Check one table in the MySQL database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#2-Analyze-all-tables-in-a-MySQL-database\" >2. Analyze all tables in a MySQL database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#3-Optimize-all-tables-in-all-MySQL-database\" >3. Optimize all tables in all MySQL database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#4-Repair-multiple-MySQL-databases\" >4. Repair multiple MySQL databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#5-Optimize-and-repair-all-tables-in-all-MySQL-databases\" >5. Optimize and repair all tables in all MySQL databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#6-Most-used-mysqlcheck-arguments\" >6. Most used mysqlcheck arguments<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-check-one-table-in-the-mysql-database\"><span class=\"ez-toc-section\" id=\"1-Check-one-table-in-the-MySQL-database\"><\/span>1. Check one table in the MySQL database<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>The following command will check the table posts in the database blog:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">$ mysqlcheck -c blog posts\r\nblog.posts                         OK<\/pre>\r\n\r\n\r\n\r\n<p>If your database is protected by a password add <code> -u root -p<\/code> at the end of the command:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">$ mysqlcheck -c blog posts -u root -p\r\nEnter password:\r\nblog.posts                         OK<\/pre>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-2-analyze-all-tables-in-a-mysql-database\"><span class=\"ez-toc-section\" id=\"2-Analyze-all-tables-in-a-MySQL-database\"><\/span>2. Analyze all tables in a MySQL database<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>The following command will check the table posts in the database blog:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">$ mysqlcheck -a blog posts\r\nblog.posts                         OK<\/pre>\r\n\r\n\r\n\r\n<p>If the MySQL\/MariaDB server is running on a remote host, add <code> -h<\/code> at the end of the command:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">$ mysqlcheck -a blog posts -h remotehost.com\r\nblog.posts                         OK<\/pre>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-3-optimize-all-tables-in-all-mysql-database\"><span class=\"ez-toc-section\" id=\"3-Optimize-all-tables-in-all-MySQL-database\"><\/span>3. Optimize all tables in all MySQL database<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">$ mysqlcheck -o --all-databases\r\nblog.users\r\nnote     : Table does not support optimize, doing recreate + analyze instead\r\nstatus   : OK\r\nmysql.time_zone_transition_type                    Table is already up to date\r\n<\/pre>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"alignright size-large\"><img decoding=\"async\" width=\"154\" height=\"154\" class=\"wp-image-37866\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysqlcheck-optimize-all-databases.png\" alt=\"mysqlcheck optimize all databases\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysqlcheck-optimize-all-databases.png 154w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysqlcheck-optimize-all-databases-150x150.png 150w\" sizes=\"(max-width: 154px) 100vw, 154px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p><code>Table does not support optimize, doing recreate + analyze instead<\/code> means that we&#8217;re doing OPTIMIZE on an InnoDB table that doesn&#8217;t support this option. When doing OPTIMIZE on an InnoDB table it creates an empty table, copies all rows from the existing table into to the new one, deletes the old one and renames the new table, and then runs ANALYZE on the table.<br \/><code>Table is already up to date<\/code> means that the table is already up to date and there is no need to check it.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-4-repair-multiple-mysql-databases\"><span class=\"ez-toc-section\" id=\"4-Repair-multiple-MySQL-databases\"><\/span>4. Repair multiple MySQL databases<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>The following command will repair all tables in both blog and blog2 databases:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">$ mysqlcheck -r --databases blog blog2<\/pre>\r\n\r\n\r\n\r\n<p>If you see <code>note : The storage engine for the table doesn't support repair<\/code> it means that you are doing REPAIR on an InnoDB.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-5-optimize-and-repair-all-tables-in-all-mysql-databases\"><span class=\"ez-toc-section\" id=\"5-Optimize-and-repair-all-tables-in-all-MySQL-databases\"><\/span>5. Optimize and repair all tables in all MySQL databases<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"alignright size-large\"><img decoding=\"async\" width=\"150\" height=\"80\" class=\"wp-image-37869\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysqlcheck.jpg\" alt=\"mysqlcheck\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>The following command will check all tables in all databases and if some table is corrupted it will automatically fix that table:<\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">$ mysqlcheck --auto-repair -o --all-databases<\/pre>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-6-most-used-mysqlcheck-arguments\"><span class=\"ez-toc-section\" id=\"6-Most-used-mysqlcheck-arguments\"><\/span>6. Most used mysqlcheck arguments<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<figure class=\"wp-block-table\">\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td><code>-c, --check<\/code><\/td>\r\n<td>Check table for errors.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><code>-a, --analyze<\/code><\/td>\r\n<td>Analyze given tables.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><code>-o --optimize<\/code><\/td>\r\n<td>Optimize the tables.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><code>-r, --repair<\/code><\/td>\r\n<td>Perform a repair that can fix almost anything except unique keys that are not unique.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><code>--auto-repair<\/code><\/td>\r\n<td>If a checked table is corrupted, automatically fix it. Repairing will be done after all tables have been checked.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><code>-A, --all-databases<\/code><\/td>\r\n<td>Check all the databases. This is the same as &#8211;databases with all databases selected.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><code>-B, --databases<\/code><\/td>\r\n<td>Process all tables in the named databases. With this option, all name arguments are regarded as database names, not as table names.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><code>--tables<\/code><\/td>\r\n<td>Overrides the &#8211;databases or -B option such that all name arguments following the option are regarded as table names.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><code>-g, --check-upgrade<\/code><\/td>\r\n<td>Check tables for version-dependent changes. May be used with &#8211;auto-repair to correct tables requiring version-dependent updates.<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n<hr class=\"wp-block-separator\" \/>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"alignright size-large\"><img decoding=\"async\" width=\"176\" height=\"119\" class=\"wp-image-37864\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysqlcheck-optimize.png\" alt=\"mysqlcheck optimize\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysqlcheck-optimize.png 176w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/mysqlcheck-optimize-150x101.png 150w\" sizes=\"(max-width: 176px) 100vw, 176px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>Of course, if you use one of our\u00a0 <a href=\"https:\/\/www.rosehosting.com\/mysql-hosting.html\">Optimized MySQL Hosting <\/a>services, you can always contact and ask our expert Linux admins (via chat or ticket) about repairing <a href=\"https:\/\/www.rosehosting.com\/blog\/mysql-show-users\/\">MySQL database<\/a> and anything related to MySQL optimization and how to repair a corrupted database. They are available 24\u00d77 and will provide information or assistance immediately.<\/p>\r\n\r\n\r\n\r\n<p><span style=\"color: #ff0000;\">PS.<\/span> If you liked this post on how to use mysqlcheck to optimize and repair all tables and databases in MySQL, please share it with your friends on the social networks using the buttons below or simply leave a reply. Thanks.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will show you how to use MySQLcheck for optimizing and repairing all tables and databases in &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MySQLcheck Optimizing and Repairing All Databases\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#more-20538\" aria-label=\"Read more about MySQLcheck Optimizing and Repairing All Databases\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":37857,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1704,13],"tags":[39,1406],"class_list":["post-20538","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-optimization","category-tutorials","tag-mysql","tag-mysqlcheck","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>mysqlcheck Optimizing and Repairing All Databases | RoseHosting<\/title>\n<meta name=\"description\" content=\"In this tutorial, we will show you how to use MySQLcheck for optimizing and repairing all tables and databases in MySQL.\" \/>\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.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQLcheck Optimizing and Repairing All Databases\" \/>\n<meta property=\"og:description\" content=\"MySQLcheck Optimizing and Repairing All Databases | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-19T12:56:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:42:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg?v=1624361183\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"MySQLcheck Optimizing and Repairing All Databases\",\"datePublished\":\"2016-10-19T12:56:30+00:00\",\"dateModified\":\"2022-06-03T08:42:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/\"},\"wordCount\":492,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg\",\"keywords\":[\"mysql\",\"mysqlcheck\"],\"articleSection\":[\"Databases\",\"Optimization\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/\",\"name\":\"mysqlcheck Optimizing and Repairing All Databases | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg\",\"datePublished\":\"2016-10-19T12:56:30+00:00\",\"dateModified\":\"2022-06-03T08:42:35+00:00\",\"description\":\"In this tutorial, we will show you how to use MySQLcheck for optimizing and repairing all tables and databases in MySQL.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg\",\"width\":1200,\"height\":600,\"caption\":\"optimize repairing mysql databases with mysqlcheck\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQLcheck Optimizing and Repairing All Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"mysqlcheck Optimizing and Repairing All Databases | RoseHosting","description":"In this tutorial, we will show you how to use MySQLcheck for optimizing and repairing all tables and databases in MySQL.","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.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/","og_locale":"en_US","og_type":"article","og_title":"MySQLcheck Optimizing and Repairing All Databases","og_description":"MySQLcheck Optimizing and Repairing All Databases | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2016-10-19T12:56:30+00:00","article_modified_time":"2022-06-03T08:42:35+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg?v=1624361183","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"MySQLcheck Optimizing and Repairing All Databases","datePublished":"2016-10-19T12:56:30+00:00","dateModified":"2022-06-03T08:42:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/"},"wordCount":492,"commentCount":3,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg","keywords":["mysql","mysqlcheck"],"articleSection":["Databases","Optimization","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/","url":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/","name":"mysqlcheck Optimizing and Repairing All Databases | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg","datePublished":"2016-10-19T12:56:30+00:00","dateModified":"2022-06-03T08:42:35+00:00","description":"In this tutorial, we will show you how to use MySQLcheck for optimizing and repairing all tables and databases in MySQL.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/10\/optimize-repairing-mysql-databases-with-mysqlcheck.jpg","width":1200,"height":600,"caption":"optimize repairing mysql databases with mysqlcheck"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/optimizing-and-repairing-mysql-databases-with-mysqlcheck\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQLcheck Optimizing and Repairing All Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/20538","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=20538"}],"version-history":[{"count":8,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/20538\/revisions"}],"predecessor-version":[{"id":41000,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/20538\/revisions\/41000"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/37857"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=20538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=20538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=20538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}