cagefs-skeleton usage in cpanel

[hossein]

hi my server disk is running out , so i try to find what is the problem in my server .
it's not normal for me to my disk Usage is 100% and i found :

[root@fra pakanpre_s1]# du -sh /usr/share/cagefs-skeleton/var/lib/mysql/
506G    /usr/share/cagefs-skeleton/var/lib/mysql/
[root@fra pakanpre_s1]#

i see this directory use much space in my server , how i can clean it and remove these files and make sure this directory not getting full again ?

Thanks - Hossein .

 

[ffeingol]

First off, cagefs-skeliton is part of Cage File System and that's CloudLinux, not cPanel. Secondly, /var/lib/mysql is where all the MysQL databases are stored, so there is prob. not too much you can clean up.

Hopefully that gets you going in the right direction.

 

[cPRex]

Thanks, @ffeingol

@hossein - can you run this command on the server and post the output?

du -sh /var/lib/mysql

 

[hossein]

hi here is output :

[root@fra ~]# du -sh /var/lib/mysql
361G    /var/lib/mysql
[root@fra ~]#

thanks .

 

[cPRex]

That would indicate the usage is all real and inside the MySQL directory. The only other thing you could do would be to check and ensure it's not the error log file taking up a large amount of space, as that could be cleared, but there isn't a way to shrink the MySQL data itself.

 

[ffeingol]

I'll respectfully disagree with @cPRex. It really depends on the storage engine. If it's innodb, then I agree that it's difficult to clean up space. if it's MyISAM and you can clean up tables, then you can optimize tables and reclaim space. As an example, we've seen Drupal sites with huge watchdog tables (where Drupal logs errors). Depending on the storage engine those can be truncated (by the client) to free up space.