Running out of Disk Space (MySQL growing!)

Feemish

• March 12, 2015 07:20

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! 27252

• 

  cPanelMichael

  • March 12, 2015 12:50

  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.

  0
• 

  Feemish

  • March 12, 2015 14:40

  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

  0
• 

  cPanelMichael

  • March 12, 2015 14:43

  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.

  0
• 

  Feemish

  • March 12, 2015 14:48

  ok thanks!

  0

Please sign in to leave a comment.