Running out of Disk Space (MySQL growing!)

Feemish

Active Member
Oct 26, 2005
25
0
151
Hi,

Cpanel informed me;

The account with the username 'xxxxxx' (xxxxx.co.uk), is running out of disk space.

This account has used 90.02% (675.12/750.00 MB) of its allocated disk space.

Please see the attached screenshot ot the 'disk space usage' within cPanel.

It shows the MySQL database growing.. thing is this is for a forum that is very rarely used.. so how come it is growing?

Also the values at the bottom dont seem to add up;
750.00MB quaota limit (122.02 MB used) ?

Any clues for me?
Thanks!

CPanelDiskSpace.gif
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
Hello,

You check check the database size with a command such as:

Code:
du -sh /var/lib/mysql/database_name/*
This should help pinpoint which tables are taking up the most space.

Thank you.
 

Feemish

Active Member
Oct 26, 2005
25
0
151
OK thanks,

I can see two large tables of errors.

473M /var/lib/mysql/database_name/smf_log_errors.MYD
83M /var/lib/mysql/database_name/smf_log_errors.MYI

I presume these willbe ok to delete?

How do I go about deleting them?

Thanks
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
You should review your script's documentation or consult with their support to determine if it's acceptable to empty those tables. I also suggest backing up your database before attempting to empty those tables:

Code:
mysqldump database_name > /path/to/database_backup.sql
At that point, assuming you've verified it's okay to proceed, you can empty those tables through phpMyAdmin or the MySQL command line.

Thank you.