The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Running out of Disk Space (MySQL growing!)

Discussion in 'General Discussion' started by Feemish, Mar 12, 2015.

  1. Feemish

    Feemish Member

    Joined:
    Oct 26, 2005
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. Feemish

    Feemish Member

    Joined:
    Oct 26, 2005
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  5. Feemish

    Feemish Member

    Joined:
    Oct 26, 2005
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    ok thanks!
     
Loading...

Share This Page