in /var/lib/mysql I have too many files, I can delete this files?
in /var/lib/mysql I have too many files, I can delete this files?
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).
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.
in /var/lib/mysql I have 8GByte of files, this is normal??
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)
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 ?
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.
with fuser command this is result
-bash: /sbin/fuser: Argument list too long
the directory is very full
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
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