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.

Big Build up /var/lib/mysql - need help fast

Discussion in 'General Discussion' started by cbelz99, Aug 31, 2003.

  1. cbelz99

    cbelz99 Registered

    Joined:
    Jul 22, 2003
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New Lenox, IL
    My server is running very bad, lots of load and continues to go down at peak times. I'm trying to track down all the problems, the latest im finding is my var/lib directory is 6.8GB total. What can I delete and what can I do to help myswlf out?


    root@webman [/var/lib/mysql]# du -h -s /var/*
    1.6M /var/cache
    55M /var/cpanel
    4.0k /var/db
    6.8G /var/lib
    4.0k /var/local
    8.0k /var/lock
    491M /var/log
    0 /var/mail
    420k /var/named
    4.0k /var/nis
    4.0k /var/opt
    12k /var/portsentry
    4.0k /var/preserve
    28k /var/proftpd
    4.0k /var/proftpd.pid
    96k /var/run
    du: `/var/spool/exim/input/19tLvP-00008y-V9-D': No such file or directory
    du: `/var/spool/exim/input/19tLvO-00008w-Rx-H': No such file or directory
    du: `/var/spool/exim/input/19tLuh-0008WE-Lv-J': No such file or directory
    du: `/var/spool/exim/input/19tLvO-00008w-Rx-J': No such file or directory
    du: `/var/spool/exim/input/19tLvO-00008w-Rx-D': No such file or directory
    du: `/var/spool/exim/input/19tLvP-00008y-V9-H': No such file or directory
    du: `/var/spool/exim/input/19tLvP-00008y-V9-J': No such file or directory
    du: `/var/spool/exim/input/19tLuh-0008WE-Lv-H': No such file or directory
    du: `/var/spool/exim/input/19tLvQ-000092-FJ-D': No such file or directory
    du: `/var/spool/exim/input/19tLvQ-00009F-SN-D': No such file or directory
    du: `/var/spool/exim/input/19tLvQ-000092-FJ-H': No such file or directory
    du: `/var/spool/exim/input/19tLuh-0008WE-Lv-D': No such file or directory
    du: `/var/spool/exim/msglog/19tLvT-00009P-Uy': No such file or directory
    du: `/var/spool/exim/msglog/19tLvY-00009e-9L': No such file or directory
    du: `/var/spool/exim/msglog/19tLvZ-00009i-QI': No such file or directory
    du: `/var/spool/exim/msglog/19tLur-00006x-CZ': No such file or directory
    454M /var/spool
    24k /var/state
    4.0k /var/tmp
    4.0k /var/tux
    1.8M /var/www
    28k /var/yp



    -----------------------------------------------

    var/lib.mysql



    -rw-rw---- 1 mysql mysql 12841654 Aug 4 05:02 webman-bin.001
    -rw-rw---- 1 mysql mysql 661861962 Aug 7 06:03 webman-bin.002
    -rw-rw---- 1 mysql mysql 493081 Aug 7 06:11 webman-bin.003
    -rw-rw---- 1 mysql mysql 429604141 Aug 9 10:44 webman-bin.004
    -rw-rw---- 1 mysql mysql 102773834 Aug 9 23:16 webman-bin.005
    -rw-rw---- 1 mysql mysql 73460074 Aug 10 08:31 webman-bin.006
    -rw-rw---- 1 mysql mysql 131597 Aug 10 08:35 webman-bin.007
    -rw-rw---- 1 mysql mysql 372770 Aug 10 08:40 webman-bin.008
    -rw-rw---- 1 mysql mysql 310993547 Aug 11 09:41 webman-bin.009
    -rw-rw---- 1 mysql mysql 561717320 Aug 14 00:35 webman-bin.010
    -rw-rw---- 1 mysql root 79 Aug 14 00:32 webman-bin.011
    -rw-rw---- 1 mysql mysql 133758 Aug 14 03:51 webman-bin.012
    -rw-rw---- 1 mysql mysql 504301 Aug 14 03:59 webman-bin.013
    -rw-rw---- 1 mysql mysql 105769550 Aug 14 14:26 webman-bin.014
    -rw-rw---- 1 mysql mysql 503831460 Aug 16 19:10 webman-bin.015
    -rw-rw---- 1 mysql mysql 1073741913 Aug 21 05:20 webman-bin.016
    -rw-rw---- 1 mysql mysql 1073741884 Aug 25 11:16 webman-bin.017
    -rw-rw---- 1 mysql mysql 1073741976 Aug 29 07:21 webman-bin.018
    -rw-rw---- 1 mysql mysql 89882855 Aug 29 13:54 webman-bin.019
    -rw-rw---- 1 mysql mysql 79 Aug 29 13:54 webman-bin.020
    -rw-rw---- 1 mysql mysql 356660308 Aug 31 01:20 webman-bin.021

    cPanel.net Support Ticket Number:
     
  2. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,125
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    New York
    These files "webman-bin.001" are mysql logs, most of them can just be deleted. Do the first 5 or 10 if you really need space.

    But thats not whats slowing you down, the fact they are so huge means that something is really working the mysql database engine so you should see if someone has some kind of runaway program or someone is banging the hell out of a web page that has some kind of mysql-based tracking.

    Thats a hell of alot of mysql in just a day for each bin.

    cPanel.net Support Ticket Number:
     
  3. bmcpanel

    bmcpanel Well-Known Member

    Joined:
    Jun 1, 2002
    Messages:
    546
    Likes Received:
    0
    Trophy Points:
    16
    Check /var/cpanel/exim

    and do a du -h. On my server, exim frozen messages were taking up 3.2 gb of space, and exim was not removing them like it was supposed to. Imagine that.

    Also, check /var/log

    Exim reject logs could be taking up a lot of your space, since exim is such a crappy program, and all.
     
Loading...

Share This Page