SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jan 2009
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    errno 28 - resize /var partition?

    Today I ran into a problem on one of my self-managed servers. Got a errno 28 aka out of space.

    So on inspection of the drive (not all shown here):
    /dev/md2 59G 8.1G 48G 15% /web
    /dev/md1 9.7G 9.2G 25M 100% /var


    From above I see I have only used 15% of /web, and 100% of /var where mysql and logs are located. I removed the logs (Hardly any), and took a look in mysql's table sizes. Almost 9.G!

    I do not think I can change the partition like this; but can I resize /web and give that to /var so mysql have more space without having to do something drastic as I'm working remotely?

    If so, how?

    Thanks,
    Levi

    Ps Im on CentOS

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I assume it would depend on the filesystem you formatted these partitions with.

    The easiest solution, though, is to move the database to /web.

    All you have to do is stop MySQL, copy the data directory to a folder in /web, edit my.cnf to point there, and start MySQL again. With <10G should just take a few minutes, you can do it at night.

  3. #3
    SitePoint Member
    Join Date
    Jan 2009
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    They are all ext3


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •