never2far

Active Member
May 6, 2008
34
0
56
Hello,

In disk space usage i can see that mysql is using 11 GB...if I click Mysql Databases I can see one of databases as using 9 GB.

I did a du -sh /var/lib/mysql/cPaneluser_databaseX and i can see it as using 2.1 GB.

Can you please help me understand what I'm missing here and where is the rest of the space.

The rest of accounts space seems OK so i don't think it's a problem with quota...but to make sure I have already run /scripts/fixquotas
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello :)

Please run the following command and let us know if you see any difference with the reported disk space usage for your databases:

Code:
# /usr/local/cpanel/scripts/update_db_cache
It should be running automatically if you have "Include databases in disk usage calculations" enabled in "Tweak Settings", so post any error messages you see when running it manually.

Thank you.
 

never2far

Active Member
May 6, 2008
34
0
56
Hello,

I tried this but it does't solve. Also in Tweak Settings "Include databases in disk usage..." is enabled.

Also no errors have been returned after runing update_db_cache
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Could you open a support ticket and post the ticket number here so we can investigate this issue?

Submit A Ticket

Thank you.
 

never2far

Active Member
May 6, 2008
34
0
56
Hello,

I think it's because the database is using innodb. I'll investigate more and if I can't solve it I will send a ticket :).