Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

host-bin.001 FILES!!!

Discussion in 'General Discussion' started by tsook, Jun 15, 2004.

  1. tsook

    tsook Well-Known Member

    Joined:
    Mar 21, 2003
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    156
    I just recently found, that somethin si taking up all of my space on server. There is 6GB of space an usually there wa no more than 50% taken. But now it jumped to 90% DAMN, so what i figured out... there were some pretty large files in my /var/lib/mysql dir:

    Besides myswl files for my sites there were also:
    -rw-rw---- 1 mysql mysql 19M Mar 29 12:58 host-bin.001
    -rw-rw---- 1 mysql mysql 22M Apr 6 21:03 host-bin.002
    -rw-rw---- 1 mysql mysql 62M Apr 16 18:08 host-bin.003
    -rw-rw---- 1 mysql mysql 163M Apr 21 22:56 host-bin.004
    -rw-rw---- 1 mysql mysql 221k Apr 21 23:01 host-bin.005
    -rw-rw---- 1 mysql mysql 740M May 11 11:15 host-bin.006
    -rw-rw---- 1 mysql mysql 140M May 13 15:53 host-bin.007
    -rw-rw---- 1 mysql mysql 139M May 17 15:16 host-bin.008
    -rw-rw---- 1 mysql mysql 1.8M May 17 15:41 host-bin.009
    -rw-rw---- 1 mysql mysql 68M May 18 22:30 host-bin.010
    -rw-rw---- 1 mysql mysql 835 May 18 22:31 host-bin.011
    -rw-rw---- 1 mysql mysql 79 May 18 22:31 host-bin.012
    -rw-rw---- 1 mysql mysql 5.4M May 19 00:03 host-bin.013
    -rw-rw---- 1 mysql mysql 887M Jun 8 09:23 host-bin.014
    -rw-rw---- 1 mysql mysql 392M Jun 15 19:36 host-bin.015
    -rw-rw---- 1 mysql mysql 729k Jun 15 20:14 host-bin.016
    -rw-rw---- 1 mysql mysql 240 Jun 15 19:38 host-bin.index


    WTF are this files? can i dele te them?
     
  2. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    778
    Likes Received:
    4
    Trophy Points:
    318
    Location:
    N.W. Iowa
    You can remove those unless your running a master/slave replication setup.

    Check your mysql variables SHOW VARIABLES for log_bin, make sure it's off, or disable it in your my.cnf, by commenting it out. It's not required for normal mysql operations.

    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. tsook

    tsook Well-Known Member

    Joined:
    Mar 21, 2003
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    156
    tnx, removed files and log_bin!
     
  4. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    778
    Likes Received:
    4
    Trophy Points:
    318
    Location:
    N.W. Iowa
    If you changed the log_bin variable setting besure to restart MySQL in order for it to take affect otherwise it'll keep build those files again. :)

    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. tsook

    tsook Well-Known Member

    Joined:
    Mar 21, 2003
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    156
  6. Angel78

    Angel78 Well-Known Member

    Joined:
    May 9, 2002
    Messages:
    413
    Likes Received:
    1
    Trophy Points:
    318
    what are those files? Someone told me that they are used to re-create databases after mysql crashes.
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice