Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 14 of 14
  1. #1
    Member
    Join Date
    Jul 2005
    Posts
    209

    Default too many files in /var partition

    in /var/lib/mysql I have too many files, I can delete this files?

  2. #2
    cPanel Partner NOC cPanel Partner NOC Badge
    Join Date
    Jul 2005
    Posts
    609

    Default

    rm -rf /var/spool/exim/input/*

  3. #3
    Member
    Join Date
    Nov 2003
    Posts
    19

    Default

    Quote Originally Posted by upsforum View Post
    in /var/lib/mysql I have too many files, I can delete this files?
    why you think you have to many files and what do you mean by 'too many files' ? are you short of free inodes or space left on device ?
    Last edited by makersky; 02-16-2007 at 04:23 PM.

  4. #4
    Member
    Join Date
    Jul 2005
    Posts
    209

    Default

    I have this status HD space used

    partition /usr 92%
    partition /var 65%



    what I can make?

  5. #5
    Member
    Join Date
    Nov 2003
    Posts
    19

    Default

    Quote Originally Posted by upsforum View Post
    I have this status HD space used

    partition /usr 92%
    partition /var 65%

    what I can make?
    So you have 35% of space free in /var and only 8% in /usr. If you want to find directories that takes most space do this:

    du -sk * | sort -n

    Still I dont understand why you want to remove files ? /usr is rather still partition (except log files of programs installed in /usr/local/ - ie: apache - /usr/local/apache/{logs,domlogs}). /var is not full in your case.

    /var/lib/mysql contains mysql databases, so it's not a good idea to delete it. also removing /var/spool/exim/input/ is not a good idea (you will loose all emails that are in queue and are waiting for delivery).

  6. #6
    Member
    Join Date
    Jul 2005
    Posts
    209

    Default

    OK,

    for /usr/local/apache/domlogs i created a simbolic link to /home/domlogs, in this partition i have 135Gbyte free


    for /var from 2 days ago the space status is 62% used, I can remove /var/spool/exim/input/* but for long period? what I can do?
    Last edited by upsforum; 02-17-2007 at 06:18 AM.

  7. #7
    Member
    Join Date
    Jul 2005
    Posts
    209

    Default

    in /var/lib/mysql I have 8GByte of files, this is normal??

  8. #8
    Member
    Join Date
    Jul 2005
    Posts
    209

    Default

    I have this files in /var/lib/mysql


    -rw-rw---- 1 mysql mysql 104360290 May 31 2006 server3-bin.000018
    -rw-rw---- 1 mysql mysql 79 May 31 2006 server3-bin.000019
    -rw-rw---- 1 mysql mysql 370840 May 31 2006 server3-bin.000020
    -rw-rw---- 1 mysql mysql 569 May 31 2006 server3-bin.000021
    -rw-rw---- 1 mysql mysql 9953 May 31 2006 server3-bin.000022
    -rw-rw---- 1 mysql mysql 272952203 Jun 18 2006 server3-bin.000023
    -rw-rw---- 1 mysql mysql 394416789 Jul 13 2006 server3-bin.000024
    -rw-rw---- 1 mysql mysql 345098614 Jul 27 2006 server3-bin.000025
    -rw-rw---- 1 mysql mysql 20439751 Jul 28 2006 server3-bin.000026
    -rw-rw---- 1 mysql mysql 2696582 Jul 28 2006 server3-bin.000027
    -rw-rw---- 1 mysql mysql 34663 Jul 29 2006 server3-bin.000028
    -rw-rw---- 1 mysql mysql 153501308 Aug 2 2006 server3-bin.000029

    This is very very large, to what to used?

  9. #9
    Member
    Join Date
    Nov 2003
    Posts
    19

    Default

    Quote Originally Posted by upsforum View Post
    I have this files in /var/lib/mysql


    -rw-rw---- 1 mysql mysql 104360290 May 31 2006 server3-bin.000018
    -rw-rw---- 1 mysql mysql 79 May 31 2006 server3-bin.000019
    -rw-rw---- 1 mysql mysql 370840 May 31 2006 server3-bin.000020
    -rw-rw---- 1 mysql mysql 569 May 31 2006 server3-bin.000021
    -rw-rw---- 1 mysql mysql 9953 May 31 2006 server3-bin.000022
    -rw-rw---- 1 mysql mysql 272952203 Jun 18 2006 server3-bin.000023
    -rw-rw---- 1 mysql mysql 394416789 Jul 13 2006 server3-bin.000024
    -rw-rw---- 1 mysql mysql 345098614 Jul 27 2006 server3-bin.000025
    -rw-rw---- 1 mysql mysql 20439751 Jul 28 2006 server3-bin.000026
    -rw-rw---- 1 mysql mysql 2696582 Jul 28 2006 server3-bin.000027
    -rw-rw---- 1 mysql mysql 34663 Jul 29 2006 server3-bin.000028
    -rw-rw---- 1 mysql mysql 153501308 Aug 2 2006 server3-bin.000029

    This is very very large, to what to used?
    it seems that you had bin log turned on few months ago. check if those files are in use
    # fuser -v server3-bin*
    and if not delete all.
    also you can check if you have other mysql log files, rotated or not. (log directive in /etc/my.cnf)

    Quote Originally Posted by upsforum View Post
    in /var/lib/mysql I have 8GByte of files, this is normal??
    go to /var/lib/mysql and submit
    df -sk * | sort -n
    you will see who has biggest databases. maybe you would like to charge your clients for extra large db or you have databases which belongs to deleted accounts ?

  10. #10
    Member
    Join Date
    Oct 2006
    Posts
    312

    Default

    This is what we normally remove without any problems.

    1. /var/cpanel/logs/*
    2. /tmp/sess*
    3. /usr/local/apache/logs/*_log
    .
    RTG (Asia) Network
    Unmetered ®cPanel VPS from $28.00
    Shared & Reseller Accounts from $2.00
    Unmetered Dedicated Servers from $58.00
    Your account will be setup AUTOMAGICALLY upon payment.

  11. #11
    Member
    Join Date
    Jul 2005
    Posts
    209

    Default

    with fuser command this is result

    -bash: /sbin/fuser: Argument list too long

    the directory is very full

  12. #12
    Member
    Join Date
    Nov 2003
    Posts
    19

    Default

    Quote Originally Posted by upsforum View Post
    with fuser command this is result

    -bash: /sbin/fuser: Argument list too long

    the directory is very full
    if you use bash shell then try:

    for f in server3-bin*; do fuser -v $f; done

    If there is a lot of server3-bin files then you still have bin logging turned on. Consider if you need this and if you need previous logs.

  13. #13
    Member
    Join Date
    Jul 2005
    Posts
    209

    Default

    this is correct result?

    No process references; use -v for the complete list
    server3-bin.000021:
    No process references; use -v for the complete list
    server3-bin.000022:
    No process references; use -v for the complete list
    server3-bin.000023:
    No process references; use -v for the complete list
    server3-bin.000024:
    No process references; use -v for the complete list
    server3-bin.000025:
    No process references; use -v for the complete list
    server3-bin.000026:
    No process references; use -v for the complete list
    server3-bin.000027:
    No process references; use -v for the complete list
    server3-bin.000028:
    No process references; use -v for the complete list
    server3-bin.000029:
    No process references; use -v for the complete list

  14. #14
    Super Moderator This forum account has been confirmed by cPanel staff to represent a vendor. chirpy's Avatar
    Join Date
    Jun 2002
    Location
    Go on, have a guess
    Posts
    13,495

    Default

    Quote Originally Posted by BianchiDude View Post
    rm -rf /var/spool/exim/input/*
    Don't make stupid recommendations like that again or you'll find yourself banned. Recommending someone delete all their email files is reckless, especially when it has nothing to do with the OP.
    Jonathan Michaelson

    Need your cPanel servers secured and tuned?
    cPanel Server Configuration, Security, Recovery and Antivirus/AntiSpam Services
    Developers of the most effective (and free) Firewall & Security Solution for cPanel Servers - csf
    http://www.configserver.com

Similar Threads & Tags
Similar threads

  1. /var partition set to read only
    By chapsrulez in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 03-17-2010, 02:26 PM
  2. Need a /var/ partition bigger, how to?
    By alucato in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 01-05-2009, 10:58 AM
  3. /var partition, how to get rid of it?
    By jols in forum cPanel and WHM Discussions
    Replies: 4
    Last Post: 10-10-2008, 03:26 PM
  4. Help putting /var in /home partition
    By cretu in forum cPanel and WHM Discussions
    Replies: 5
    Last Post: 07-16-2007, 08:38 AM
  5. /var partition problems
    By Wallaby in forum cPanel and WHM Discussions
    Replies: 8
    Last Post: 11-27-2003, 08:43 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube