{"id":6329,"date":"2023-02-19T15:24:11","date_gmt":"2023-02-19T09:54:11","guid":{"rendered":"https:\/\/trysiteprice.com\/blog\/?p=6329"},"modified":"2023-02-19T15:24:11","modified_gmt":"2023-02-19T09:54:11","slug":"mysql-find-out-which-table-is-consuming-resources","status":"publish","type":"post","link":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/","title":{"rendered":"MySQL: Find Out Which Table is Consuming Resources"},"content":{"rendered":"<p>To find out which table is consuming the most resources in MySQL, you can use the following SQL query:<\/p>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> table_name, engine, table_rows, data_length, index_length,<br \/>\nround(((data_length <span class=\"hljs-operator\">+<\/span> index_length) <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span> <span class=\"hljs-operator\">\/<\/span> <span class=\"hljs-number\">1024<\/span>), <span class=\"hljs-number\">2<\/span>) \"Size in MB\"<br \/>\n<span class=\"hljs-keyword\">FROM<\/span> information_schema.TABLES<br \/>\n<span class=\"hljs-keyword\">WHERE<\/span> table_schema <span class=\"hljs-operator\">=<\/span> \"your_database_name\"<br \/>\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> (data_length <span class=\"hljs-operator\">+<\/span> index_length) <span class=\"hljs-keyword\">DESC<\/span>;<br \/>\n<\/code><\/div>\n<\/div>\n<p>Replace <code>your_database_name<\/code> with the name of your database.<\/p>\n<p>This will list all the tables in the specified database, sorted by their combined data and index size. You can see which table is consuming the most resources based on the &#8220;Size in MB&#8221; column.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To find out which table is consuming the most resources in MySQL, you can use the following SQL query: SELECT table_name, engine, table_rows, data_length, index_length, round(((data_length + index_length) \/ 1024 \/ 1024), 2) &#8220;Size in MB&#8221; FROM information_schema.TABLES WHERE table_schema = &#8220;your_database_name&#8221; ORDER BY (data_length + index_length) DESC; Replace your_database_name with the name of your &#8230; <a title=\"MySQL: Find Out Which Table is Consuming Resources\" class=\"read-more\" href=\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/\" aria-label=\"Read more about MySQL: Find Out Which Table is Consuming Resources\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6329","post","type-post","status-publish","format-standard","hentry","category-best-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL: Find Out Which Table is Consuming Resources - TrySitePrice<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL: Find Out Which Table is Consuming Resources - TrySitePrice\" \/>\n<meta property=\"og:description\" content=\"To find out which table is consuming the most resources in MySQL, you can use the following SQL query: SELECT table_name, engine, table_rows, data_length, index_length, round(((data_length + index_length) \/ 1024 \/ 1024), 2) &quot;Size in MB&quot; FROM information_schema.TABLES WHERE table_schema = &quot;your_database_name&quot; ORDER BY (data_length + index_length) DESC; Replace your_database_name with the name of your ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/\" \/>\n<meta property=\"og:site_name\" content=\"TrySitePrice\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-19T09:54:11+00:00\" \/>\n<meta name=\"author\" content=\"Rahul Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/\"},\"author\":{\"name\":\"Rahul Sahu\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\"},\"headline\":\"MySQL: Find Out Which Table is Consuming Resources\",\"datePublished\":\"2023-02-19T09:54:11+00:00\",\"dateModified\":\"2023-02-19T09:54:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/\"},\"wordCount\":69,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"articleSection\":[\"Best\/Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/\",\"name\":\"MySQL: Find Out Which Table is Consuming Resources - TrySitePrice\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\"},\"datePublished\":\"2023-02-19T09:54:11+00:00\",\"dateModified\":\"2023-02-19T09:54:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/trysiteprice.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL: Find Out Which Table is Consuming Resources\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"name\":\"TrySitePrice\",\"description\":\"Free Website Value Calculator Tool\",\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\",\"name\":\"TrySitePrice\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"contentUrl\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"width\":395,\"height\":268,\"caption\":\"TrySitePrice\"},\"image\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\",\"name\":\"Rahul Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"caption\":\"Rahul Sahu\"},\"sameAs\":[\"https:\/\/trysiteprice.com\/blog\"],\"url\":\"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL: Find Out Which Table is Consuming Resources - TrySitePrice","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:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/","og_locale":"en_US","og_type":"article","og_title":"MySQL: Find Out Which Table is Consuming Resources - TrySitePrice","og_description":"To find out which table is consuming the most resources in MySQL, you can use the following SQL query: SELECT table_name, engine, table_rows, data_length, index_length, round(((data_length + index_length) \/ 1024 \/ 1024), 2) \"Size in MB\" FROM information_schema.TABLES WHERE table_schema = \"your_database_name\" ORDER BY (data_length + index_length) DESC; Replace your_database_name with the name of your ... Read more","og_url":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/","og_site_name":"TrySitePrice","article_published_time":"2023-02-19T09:54:11+00:00","author":"Rahul Sahu","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/#article","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/"},"author":{"name":"Rahul Sahu","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4"},"headline":"MySQL: Find Out Which Table is Consuming Resources","datePublished":"2023-02-19T09:54:11+00:00","dateModified":"2023-02-19T09:54:11+00:00","mainEntityOfPage":{"@id":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/"},"wordCount":69,"commentCount":0,"publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"articleSection":["Best\/Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/","url":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/","name":"MySQL: Find Out Which Table is Consuming Resources - TrySitePrice","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/#website"},"datePublished":"2023-02-19T09:54:11+00:00","dateModified":"2023-02-19T09:54:11+00:00","breadcrumb":{"@id":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/trysiteprice.com\/blog\/mysql-find-out-which-table-is-consuming-resources\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trysiteprice.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL: Find Out Which Table is Consuming Resources"}]},{"@type":"WebSite","@id":"https:\/\/trysiteprice.com\/blog\/#website","url":"https:\/\/trysiteprice.com\/blog\/","name":"TrySitePrice","description":"Free Website Value Calculator Tool","publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/trysiteprice.com\/blog\/#organization","name":"TrySitePrice","url":"https:\/\/trysiteprice.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","contentUrl":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","width":395,"height":268,"caption":"TrySitePrice"},"image":{"@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4","name":"Rahul Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","caption":"Rahul Sahu"},"sameAs":["https:\/\/trysiteprice.com\/blog"],"url":"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/"}]}},"_links":{"self":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/6329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/comments?post=6329"}],"version-history":[{"count":1,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/6329\/revisions"}],"predecessor-version":[{"id":6330,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/6329\/revisions\/6330"}],"wp:attachment":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/media?parent=6329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/categories?post=6329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/tags?post=6329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}