The major problem you have is the /backup directory
You should move this to /export/home/
You can also save more space by moving /swap to /export/home/swap
For this, do the following commands as root
mkfile /export/home/swap 2g
(verify it is created by doing du -k /export/home/swap - This should
show 2mb)
swap -d /swap
swap -a /export/home/swap
rm /swap
Later you should also see that /opt does not grow too big due to
downloading of
packages from blastwave
---------------------------------------------------------------------------------------------------------------------------------------
there is some still problem with server.
some file is growing in size and blocking the mysql to work properly.
can you pls tell us the command to find out the big files in the
solaris file system.
If you want to find all files larger than 1Mb, use
find / -size +2048
(It take param after size as number of 512 byte blocks. The + says list
everything bigger than
that. If you miss the +, it will list only those which are exactly equal
to 1 MB)
For size 100 MB, use
find / -size +204800
ababeel: AS-Salaamu-Alaikum! is Hasan Bhai there?
me: yes there
ababeel: ask him if the .47 server can be send down for a reboot
me: inikah is down
ababeel: ?
me: yes
hasan bhai renooted
ababeel : then login as root and give init 6
do again
me: mysql is not started
ababeel : then login as root and give init 6
me: asak abrar bhai,
this is hasasn
ababeel: give an init 6
me: we restarted the server calling vsnl
ababeel : hav changed permission to /tmp as stick directory.
me: i tried init 6. but the server never came down. so i had to call
vsnl to do a physical reboot.
shall i try now with init 6
ababeel: yes pl.
if that does not work then th command reboot ; though not s good as
init 6, better than physicalk
me: i ve issued init 6. let me wait and see.
are you at home abrar bhai?
how much time it takes for init 6 to respond.
ababeel : saw ur mesg now.
atmost 3-4 minutes, keep ping active until connction is lost
me : you are at home or office?
ababeel: tail /var/svc/log/network-cswmysql5\:default.log
c if output helps.
me: ok
this is the output
[ Oct 31 20:33:45 Executing start method
("/opt/csw/lib/svc/method/svc-mysql5 start") ]
Starting mysqld: [ OK ]
[ Oct 31 20:33:45 Method "start" exited with status 0 ]
Starting mysqld daemon with databases from /opt/csw/mysql5/var
[ Oct 31 20:43:45 Stopping because service disabled. ]
[ Oct 31 20:43:45 Executing stop method (:kill) ]
8:53 PM
can i try reboot?
ababeel : yes, pl.
me: init 6 does not seem to respond.
ababeel: u r root?
me: yes i'm root
ababeel: ok, try reboot
hope this did.
me: abrar bhai, server rebooted.
but still getting the same problem
ababeel: ok, Mashallah.
me: cswmysql5 is NOT listed in svcs
ababeel: is it.
me: but when i gave ps -ef | grep mysql, it showing the mysql process
running
when i tried to invoke mysql client it is giving...
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
now it is telling maintenance mode.
online* 20:56:51 svc:/network/cswmysql5:default
ababeel: svcs -l cswmysql5
me: 'll try
this is the output
fmri svc:/network/cswmysql5:default
enabled true
state online
next_state disabled
state_time Wed Oct 31 20:56:51 2007
logfile /var/svc/log/network-cswmysql5:default.log
restarter svc:/system/svc/restarter:default
contract_id 36
dependency require_all/none svc:/system/filesystem/local (online)
dependency require_all/none svc:/network/loopback (online)
9:06 PM
ababeel: it shows online here; can't figure out the prob.
me: yes.
ababeel: can happen if v have 2 instances of ysql running like 4 and
5, but svcs -a | grep mysql shoes just one.
me: can we go for a re-installation of mysql
ababeel: can try, get from blastwave.
me: what is the command?
i'm root
ababeel: pkg-get -i mysql5
me : 'll try
it is telling command not found
ababeel: /opt/csw/bib/pkg-get ??
/opt/csw/bin/pkg-get ??
me: no, sir
even this not working
9:10 PM
ababeel: download pkg-get from blastwave main page to local system,
then scp to server, then pkgadd -d /path/to/pkg-get
me: ok
ababeel: getting?
me: WARNING: unable to write temp contents file
(errno 28: No space left on device)
Installation of
partially installed.
we are getting this problem
ababeel: df -h shows / is full!! pl see if something can b deleted
under /var
me: how to find which is the biggest file?
ababeel: Hasan bhai, /var/log id more than 800 MB, pl. delete
syslog.[1-7]
me: can we delete all these log files?
ababeel: if u really need atleasr gzip then, i feel deleteing is
safe, but u decide.
me: i think we can delete.
ababeel : then pl., this might resolv mysql
me: sure,
we'll see
ababeel: /backup directory is under /, later c if something there is
outdated and delete if possible.
working, Alhamdullilah, i feel alteast.
me: we have deleted. alhamdulillah. i got the prompt
ababeel: is it resolved?
me: how to monitor these things. is there a tool?
ababeel: just df -h every week, that's it.
me: sure,
ababeel: avaind storing under /.
me: but df -h is just showing all 1%
ok, jazakallah for the help abrar bhai.
tomorrow, just get the pkg-get right.
it is not installed properly.
ababeel: .47 has 2 filesystems: / and /export/home, huge data is
better under /export/home.
anytime any unix is installed; / and /var /tmp/ should b in separate
partitions.
anyway Hasan Bhai, i'll take leave.
me: ok
jazakalah
very soon we'll do a complete re-installation as adviced by sherif sb.
inform me whenever you are free, so that we can go to vsnl
ababeel: mon -fri during day.
ok then, AS-Salaamu-Alaikum.
-------------------------------------------------------------------------------------------------
On .47 bkupopr user's cronjob runs daily
doing the mysqldump under /export/home/bkupopr/dbbkup47/
compresses the .sql file,
copies the compressed file over the network to .40, under /export/home/bkupusr/47-dbbk/
cleans up files older than 40 days, on .47
notifies hasan@simplenikah.com and abrar@simplenikah.com of backup completion via email.
On .40, bkupusr user's cronjob runs on the 2nd of every month at 5:45 AM , cleaning backups older than 30 days.
notifies hasan@simplenikah.com & abrar@simplenikah.com of cleanup completion via email.
--------------------------------------------------------------------------------------------------------------------------------------
ababeel: Wa-Alaikum-As-Salaam!
Ibrahim Bhai,
Please login into .47 as root, then
cd /var/
then,
me: i logid in as root
ababeel: ls -lh | less
3:07 PM me: it listing destop,documents, ..
ababeel: i see 1 file here named
no u might b in /root; please give the command:
cd /var
3:08 PM & let me know
3:09 PM me: i am in /var folder
3:10 PM ababeel: now type:
ls -lh export*
me: it showing like export.home.47_2006.11.22
3:11 PM ababeel: & its more than 1GB; this was created in november, do u still need it?
3:12 PM me: we are not created i will ask to hasan bhai
ababeel: ok, i am waiting.
3:13 PM porbably i've kept that, but not sure, it's a backup of /export/home on .47 as was on nov '06.
me: where is this file abrar bhai?
ababeel: ls -lh /var/export*
me: pl delete it
3:14 PM ababeel: pl. wait.
done, now type the command:
df -h
3:15 PM see the size of /var , u hav 1.6GB free now.
me: fine
can we do further clean up
3:16 PM how to avoid such things happening in the future
ababeel: yes, cd /var/log
3:17 PM me: alhamdulillah, it is working now.
ababeel: simply delete very old backups.
me: in future. how to avoid such things happening.
3:18 PM how to delete the tmp files? is there any script to do that every month.
3:20 PM ababeel: it's safer to do iy manually; /tmp/ is used by many programs, onlt delete file that u hav kept.
me: ok, that's fine.
jazakallah for your help.
ababeel: can i close this session now?
me: sure,
3:21 PM thanks
ababeel: As-Salaamu-Alaikum!
3:24 PM As-Salaamu-Alaikum, ur root account as 5000+ mails, see if u really need them.
------------------------------------------------------------------------------------------------
What URL do u use to acces squirrel-mail?
www.inikah.com:8080
ababeel: does mail.inikah.com:8080 work?
6:39 PM me: i dont know.
-------------------------------------------------------------------------------------------------
