Running out of Disk Space (MySQL growing!)

[Feemish]

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!

 

[cPanelMichael]

Hello,

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

du -sh /var/lib/mysql/database_name/*

This should help pinpoint which tables are taking up the most space.

Thank you.

 

[Feemish]

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]

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:

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.

 

[Feemish]

ok thanks!