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.

Several files over 1GB in my /var - What are they?

Discussion in 'General Discussion' started by jasgot, Mar 10, 2008.

  1. jasgot

    jasgot Well-Known Member

    Joined:
    Mar 2, 2004
    Messages:
    55
    Likes Received:
    1
    Trophy Points:
    6
    I have a bunch of files in /var/lib/mysql

    They are named like this:

    christopher-bin.000001
    christopher-bin.000002
    christopher-bin.000003
    christopher-bin.000004
    ...
    christopher-bin.000008

    They are dated about every 9 or 10 days.

    Any idea what they are? How they got there? Can I delete them?

    They are occupying 50% of my /var volume.....

    Thanks.
    Jason
     
  2. jasgot

    jasgot Well-Known Member

    Joined:
    Mar 2, 2004
    Messages:
    55
    Likes Received:
    1
    Trophy Points:
    6
    I did a "cat" to one of them. They appear to be millions of mysql insert commands from my MailScanner spam and virus system.

    Can I get rid of these? or change where they are stored?
     
  3. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    This article might help: http://servertune.com/kbase/entry/78/
     
  4. viraj

    viraj Well-Known Member

    Joined:
    Sep 28, 2006
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Hi Jason,

    These are the binary log files needed if you are using/running a MySQL database cluster, these are needed for replication from Master to Slave & vice versa. If you aren't, then you can proceed with the deletion of those files & to stop them of occurring follow these steps :

    1) Edit the MySQL configuration file : vi /etc/my.cnf
    2) Search for log-bin entry & remove or comment it.
    3) Save the config file & restart MySQL.

    You are done :)
     
  5. jasgot

    jasgot Well-Known Member

    Joined:
    Mar 2, 2004
    Messages:
    55
    Likes Received:
    1
    Trophy Points:
    6
    GREAT! Thank you! I just backed them up and deleted them.
     
Loading...

Share This Page