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!

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:
    56
    Likes Received:
    1
    Trophy Points:
    158
    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:
    56
    Likes Received:
    1
    Trophy Points:
    158
    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:
    4
    Trophy Points:
    193
    Location:
    Minneapolis, MN
    This article might help: http://servertune.com/kbase/entry/78/
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. viraj

    viraj Well-Known Member

    Joined:
    Sep 28, 2006
    Messages:
    209
    Likes Received:
    1
    Trophy Points:
    166
    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 :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. jasgot

    jasgot Well-Known Member

    Joined:
    Mar 2, 2004
    Messages:
    56
    Likes Received:
    1
    Trophy Points:
    158
    GREAT! Thank you! I just backed them up and deleted them.
     
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