Disk space usage and mysql

[never2far]

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]

Hello

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

# /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]

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

 

[cPanelMichael]

Could you open a support ticket and post the ticket number here so we can investigate this issue?

Submit A Ticket

Thank you.

 

[never2far]

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 .