{"id":335,"date":"2010-07-07T23:03:26","date_gmt":"2010-07-08T05:03:26","guid":{"rendered":"http:\/\/blog.supportpro.com\/?p=335"},"modified":"2026-03-26T23:41:50","modified_gmt":"2026-03-27T05:41:50","slug":"mysql-database-showing-0mb-disk-usage-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/mysql-database-showing-0mb-disk-usage-in-cpanel\/","title":{"rendered":"Mysql Database showing 0MB disk usage in Cpanel"},"content":{"rendered":"\n<p>Sometimes administrators may notice that MySQL databases display <strong>0MB disk usage<\/strong> in cPanel even though the databases contain data. This usually happens due to incorrect disk usage calculation settings in the cPanel configuration.<\/p>\n\n\n\n<p>This issue can be easily resolved by updating the cPanel configuration and rebuilding the database cache.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Why Does MySQL Show 0MB Disk Usage?<\/strong><\/h3>\n\n\n\n<p>cPanel calculates account disk usage based on specific configuration parameters.<br>If MySQL database disk usage tracking is disabled, cPanel will not include database size in the disk usage report, resulting in databases appearing as <strong>0MB<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Steps to Fix the Issue<\/strong><\/h3>\n\n\n\n<p>Follow the steps below to correct the database disk usage display:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>1. Edit the cPanel Configuration File<\/strong><\/h4>\n\n\n\n<p>Access your server via SSH and open the configuration file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>vi \/var\/cpanel\/cpanel.config<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>2. Locate the Required Parameter<\/strong><\/h4>\n\n\n\n<p>Search for the following entry:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>disk_usage_include_sqldbs<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>3. Update the Value<\/strong><\/h4>\n\n\n\n<p>Change the value from:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>0<\/code><\/pre>\n\n\n\n<p>to:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>1<\/code><\/pre>\n\n\n\n<p>This enables MySQL database disk usage calculation.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>4. Update the Database Cache<\/strong><\/h4>\n\n\n\n<p>Run the following command to rebuild the database usage cache:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/scripts\/update_db_cache<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Final Result<\/strong><\/h3>\n\n\n\n<p>Once the cache update completes, cPanel will recalculate disk usage, and MySQL databases will correctly display their actual storage size instead of 0MB.<\/p>\n\n\n\n<p>If you require help, <a href=\"https:\/\/www.supportpro.com\/requestquote.php\">contact SupportPRO Server Admin<\/a><span id=\"hs-cta-wrapper-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-node hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\"><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/2725694\/9d590242-d641-4383-94b4-8cfd62f0af6b\"><\/a><\/span><\/span><\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right is-stacked-on-mobile is-vertically-aligned-center has-white-background-color has-background\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-large-font-size\">Facing issues? <\/p>\n\n\n\n<p class=\"has-large-font-size\">Our technical support<br>engineers can solve it. <\/p>\n\n\n\n<!--HubSpot Call-to-Action Code --><span class=\"hs-cta-wrapper\" id=\"hs-cta-wrapper-3350a795-db50-482f-9911-301930d1b1be\"><span class=\"hs-cta-node hs-cta-3350a795-db50-482f-9911-301930d1b1be\" id=\"hs-cta-3350a795-db50-482f-9911-301930d1b1be\"><!--[if lte IE 8]><div id=\"hs-cta-ie-element\"><\/div><![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/2725694\/3350a795-db50-482f-9911-301930d1b1be\" ><img decoding=\"async\" class=\"hs-cta-img\" id=\"hs-cta-img-3350a795-db50-482f-9911-301930d1b1be\" style=\"border-width:0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/2725694\/3350a795-db50-482f-9911-301930d1b1be.png\"  alt=\"Contact Us today!\"\/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(2725694, '3350a795-db50-482f-9911-301930d1b1be', {\"useNewLoader\":\"true\",\"region\":\"na1\"}); <\/script><\/span><!-- end HubSpot Call-to-Action Code -->\n<\/div><figure class=\"wp-block-media-text__media\"><img fetchpriority=\"high\" decoding=\"async\" width=\"904\" height=\"931\" src=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup.png\" alt=\"guy server checkup\" class=\"wp-image-12943 size-full\" srcset=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup.png 904w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup-291x300.png 291w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup-768x791.png 768w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup-585x602.png 585w\" sizes=\"(max-width: 904px) 100vw, 904px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes administrators may notice that MySQL databases display 0MB disk usage in cPanel even though the databases contain data. This usually happens due to incorrect disk usage calculation settings in&hellip;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-335","post","type-post","status-publish","format-standard","hentry","category-miscellaneous"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":5,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"predecessor-version":[{"id":16730,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/335\/revisions\/16730"}],"wp:attachment":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}