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.

server#-bin.### files in /var/lib/mysql/

Discussion in 'General Discussion' started by fishfreek, Oct 27, 2004.

  1. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    What are these files for and can I archive or remove them when they are old? I am starting to come into a serious space problem on my /var partion and in doing a du -h /var command I have found that of the 5.6gigs being used on that partion 5.1 of it is in /var/lib/mysql and specificly the files below.

    1.1G /var/lib/mysql/server4-bin.001
    921M /var/lib/mysql/server4-bin.002
    157M /var/lib/mysql/server4-bin.003
    384M /var/lib/mysql/server4-bin.004
    492K /var/lib/mysql/server4-bin.005
    4.0K /var/lib/mysql/server4-bin.006
    468K /var/lib/mysql/server4-bin.007
    4.0K /var/lib/mysql/server4-bin.008
    8.0K /var/lib/mysql/server4-bin.009
    1.4M /var/lib/mysql/server4-bin.010
    1.1G /var/lib/mysql/server4-bin.011
    1.1G /var/lib/mysql/server4-bin.012
    101M /var/lib/mysql/server4-bin.013
    4.0K /var/lib/mysql/server4-bin.index

    -rw-rw---- 1 mysql mysql 1073741999 Aug 13 07:44 server4-bin.001
    -rw-rw---- 1 mysql mysql 964241969 Sep 11 14:34 server4-bin.002
    -rw-rw---- 1 mysql mysql 163922468 Sep 16 10:01 server4-bin.003
    -rw-rw---- 1 mysql mysql 401534208 Sep 23 04:54 server4-bin.004
    -rw-rw---- 1 mysql mysql 498691 Sep 23 05:50 server4-bin.005
    -rw-rw---- 1 mysql mysql 2580 Sep 23 08:01 server4-bin.006
    -rw-rw---- 1 mysql mysql 473546 Sep 23 08:40 server4-bin.007
    -rw-rw---- 1 mysql mysql 1624 Sep 23 09:53 server4-bin.008
    -rw-rw---- 1 mysql mysql 7855 Sep 23 10:31 server4-bin.009
    -rw-rw---- 1 mysql mysql 1356935 Sep 23 10:42 server4-bin.010
    -rw-rw---- 1 mysql mysql 1073742076 Oct 10 14:40 server4-bin.011
    -rw-rw---- 1 mysql mysql 1073742374 Oct 26 11:32 server4-bin.012
    -rw-rw---- 1 mysql mysql 105514083 Oct 27 13:59 server4-bin.013
    -rw-rw---- 1 mysql mysql 234 Oct 26 11:32 server4-bin.index

    As you can see the dates on the files are somewhat infrequent. I would like to be able to just remove these files but I dont know what their purpose is.
     
  2. Angel78

    Angel78 Well-Known Member

    Joined:
    May 9, 2002
    Messages:
    413
    Likes Received:
    1
    Trophy Points:
    16
    you enabled mysql logging in my.cnf, do a search it has been answered before (you can delete them, at least I did, without having any issues)
     
  3. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    Further research on the mysql site turned up exactly that. The function log-bin was enabled in my.cnf. I woudl have searched but I didnt quite know what to search for.

    I made the edit to my.cnf and restarted mysql and now Im moving those files over to another partion just incase but I suspect I can safly remove them shortly.
     
  4. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    Is there a performance reason to log or not to log this way?
     
Loading...

Share This Page