{"id":27922,"date":"2024-03-16T09:27:50","date_gmt":"2024-03-16T09:27:50","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/"},"modified":"2024-03-22T12:12:27","modified_gmt":"2024-03-22T12:12:27","slug":"view-remaining-database-space-capacity-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/","title":{"rendered":"View remaining database space capacity in MySQL."},"content":{"rendered":"<p>You can use the following query to check the remaining space capacity in a MySQL database:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> table_schema <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-string\">'\u6570\u636e\u5e93\u540d'<\/span>,\r\n       ROUND(<span class=\"hljs-built_in\">SUM<\/span>(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>) <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-string\">'\u603b\u5927\u5c0f(MB)'<\/span>,\r\n       ROUND(<span class=\"hljs-built_in\">SUM<\/span>(data_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>) <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-string\">'\u6570\u636e\u5927\u5c0f(MB)'<\/span>,\r\n       ROUND(<span class=\"hljs-built_in\">SUM<\/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>) <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-string\">'\u7d22\u5f15\u5927\u5c0f(MB)'<\/span>,\r\n       ROUND(<span class=\"hljs-built_in\">SUM<\/span>(data_free) <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>) <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-string\">'\u53ef\u7528\u7a7a\u95f4(MB)'<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span> information_schema.tables\r\n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> table_schema;\r\n<\/code><\/pre>\n<p>This query will return the total size, data size, index size, and available space size of each database in megabytes. You can modify the query as needed to fit your environment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can use the following query to check the remaining space capacity in a MySQL database: SELECT table_schema AS &#8216;\u6570\u636e\u5e93\u540d&#8217;, ROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS &#8216;\u603b\u5927\u5c0f(MB)&#8217;, ROUND(SUM(data_length) \/ 1024 \/ 1024, 2) AS &#8216;\u6570\u636e\u5927\u5c0f(MB)&#8217;, ROUND(SUM(index_length) \/ 1024 \/ 1024, 2) AS &#8216;\u7d22\u5f15\u5927\u5c0f(MB)&#8217;, ROUND(SUM(data_free) \/ 1024 \/ 1024, 2) AS &#8216;\u53ef\u7528\u7a7a\u95f4(MB)&#8217; FROM [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-27922","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>View remaining database space capacity in MySQL. - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"View remaining database space capacity in MySQL.\" \/>\n<meta property=\"og:description\" content=\"You can use the following query to check the remaining space capacity in a MySQL database: SELECT table_schema AS &#039;\u6570\u636e\u5e93\u540d&#039;, ROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS &#039;\u603b\u5927\u5c0f(MB)&#039;, ROUND(SUM(data_length) \/ 1024 \/ 1024, 2) AS &#039;\u6570\u636e\u5927\u5c0f(MB)&#039;, ROUND(SUM(index_length) \/ 1024 \/ 1024, 2) AS &#039;\u7d22\u5f15\u5927\u5c0f(MB)&#039;, ROUND(SUM(data_free) \/ 1024 \/ 1024, 2) AS &#039;\u53ef\u7528\u7a7a\u95f4(MB)&#039; FROM [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T09:27:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T12:12:27+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"View remaining database space capacity in MySQL.\",\"datePublished\":\"2024-03-16T09:27:50+00:00\",\"dateModified\":\"2024-03-22T12:12:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/\"},\"wordCount\":54,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/\",\"name\":\"View remaining database space capacity in MySQL. - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T09:27:50+00:00\",\"dateModified\":\"2024-03-22T12:12:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"View remaining database space capacity in MySQL.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"View remaining database space capacity in MySQL. - Blog - Silicon Cloud","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.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"View remaining database space capacity in MySQL.","og_description":"You can use the following query to check the remaining space capacity in a MySQL database: SELECT table_schema AS '\u6570\u636e\u5e93\u540d', ROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS '\u603b\u5927\u5c0f(MB)', ROUND(SUM(data_length) \/ 1024 \/ 1024, 2) AS '\u6570\u636e\u5927\u5c0f(MB)', ROUND(SUM(index_length) \/ 1024 \/ 1024, 2) AS '\u7d22\u5f15\u5927\u5c0f(MB)', ROUND(SUM(data_free) \/ 1024 \/ 1024, 2) AS '\u53ef\u7528\u7a7a\u95f4(MB)' FROM [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T09:27:50+00:00","article_modified_time":"2024-03-22T12:12:27+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"View remaining database space capacity in MySQL.","datePublished":"2024-03-16T09:27:50+00:00","dateModified":"2024-03-22T12:12:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/"},"wordCount":54,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/","name":"View remaining database space capacity in MySQL. - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T09:27:50+00:00","dateModified":"2024-03-22T12:12:27+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/view-remaining-database-space-capacity-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"View remaining database space capacity in MySQL."}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=27922"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27922\/revisions"}],"predecessor-version":[{"id":62188,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27922\/revisions\/62188"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=27922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=27922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=27922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}