1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Please help - Mysql database taking loads of space.

Discussion in 'Web Hosting' started by andreaog, Oct 30, 2016.

  1. andreaog

    andreaog Junior Member

    Joined:
    Nov 30, 2015
    Messages:
    139
    Likes Received:
    15
    Hi all,

    First of all apologise if this isn't the right section.

    I've around 20 wordpress websites which feed twitter taking pics from tumblr and posting them on twitter using SNAP - Social network Autoposter.

    Lately I've been contacted by the support team to delete stuff as my websites were taking much of space. (space should be unlimited but it's another story - out of curiosity, is there any hosting company which doesn't bother you once you go over certain amount of space?)

    So I went and deleted the pics in wpcontent-->upload, since they were already on twitter so I didnt care.

    Afterwards I've noticed loads of space is taken by MySQL database and I was wondering if it's safe to empty the tables via MYphp admin page. (screenshot below).

    Again I don't care deleting post and pictures as they're already on twitter.

    I was also searching for a plugin that deletes post and pix after X days but I could only find AUTO PRUNE POST plgin which didnt work, are you ware of any other plugin?

    Thanks all in advance.

    upload_2016-10-30_18-45-54.png
     
  2. HudsonWebServices

    HudsonWebServices Jr. VIP Jr. VIP

    Joined:
    Nov 28, 2015
    Messages:
    744
    Likes Received:
    108
    Location:
    Texas, US
    Home Page:
    This brings another interesting point. Hosting providers that offer unlimited isn't truly unlimited. Check into their TOS send see how they define unlimited. It's a marketing gimmick.
     
  3. RomeoTHCServers

    RomeoTHCServers Newbie

    Joined:
    Oct 24, 2016
    Messages:
    3
    Likes Received:
    0
    Gender:
    Male
    Home Page:
    Yes, you can drop the tables from phpMyAdmin. This will empty your table.
    Out of curiosity, how much disk space does your database occupy?
     
  4. andreaog

    andreaog Junior Member

    Joined:
    Nov 30, 2015
    Messages:
    139
    Likes Received:
    15
    Around 3gb
     
  5. RomeoTHCServers

    RomeoTHCServers Newbie

    Joined:
    Oct 24, 2016
    Messages:
    3
    Likes Received:
    0
    Gender:
    Male
    Home Page:
    That's a hell of a database. Anyway, you should not have any problem if you're hosted on a plan with unlimited disk space. As long as the disk space is used for the functionality of your website (in this case it's the database) there should be no problems.
     
  6. andreaog

    andreaog Junior Member

    Joined:
    Nov 30, 2015
    Messages:
    139
    Likes Received:
    15
    They're mean, As soon as you get around 10 - 15gb they will say its against TOS and will suspend the account.
    I had to delete all media files uploaded, before was around 50 gb LOL

     
  7. CenTex Hosting

    CenTex Hosting Jr. VIP Jr. VIP

    Joined:
    Nov 8, 2009
    Messages:
    1,909
    Likes Received:
    720
    Gender:
    Male
    Occupation:
    Founder/CEO
    Location:
    Austin, TX
    Home Page:
    I dont know of any host that really offers unlimited. All will be limited to some amount that is listed in TOS. The unlimited is just a marketing trick. I would recommend finding you a plan that will give you the amount of space you need.
     
  8. Ionovnat

    Ionovnat Newbie

    Joined:
    Nov 3, 2016
    Messages:
    35
    Likes Received:
    0
    Everything has limits. Read TOS and SLA carefully before signing up with a company.
     
  9. I know SEO

    I know SEO Marketplace Mod Moderator

    Joined:
    Nov 29, 2012
    Messages:
    15,901
    Likes Received:
    6,144
    You could write a cron job to empty all tables once a month/week/whatever