[Casper] 2 part question - Software update server and MySQL

Thomas Larkin tlarki at kckps.org
Mon Sep 29 14:21:46 PDT 2008


First and easiest question 

I have set up a SUS and it is now currently caching downloads.  It has a static IP and FQDN.  I have it set as the default SUS in all network segments.  Now, I can go into WGM in our open directory and apply the Software Update Server to my nested groups and the clients can update that way, or I can possibly use the Casper Suite.  How do you all implement software updates?  I want to be able to push out security updates and the 5.5 client update for OS X. 

Second question 

My JSS is running out of HD space on the boot volume, which is 75gigs and all it has is a basic load of OS X server 10.5 on it.  I ran a disk usage command and go these results 

xs001-casper:/ root# du -x -h -d 1/ 
288K./.fseventsd 
 33M./.Spotlight-V100 
  0B./.Trashes 
  0B./.vol 
1.0G./Applications 
7.6M./bin 
  0B./cores 
512B./dev 
  0B./Groups 
1.0K./home 
4.5G./Library 
1.0K./net 
1.0K./Network 
 47G./private 
5.7M./sbin 
4.0K./Shared Items 
3.7G./System 
7.1G./Users 
1.4G./usr 
4.0K./Volumes 
 65G. 

if you look, /private is 47gigs in size, which should automatically tell you , hey this isn't right.  So upon further investigation it shows that /private/var/mysql is the culprit.  I looked into it and I have a ton of bin files in the mysql directory that are just eating away HD space 

Here is the du report on the mysql direcotry: 

xs001-casper:mysql root# du -x -h -d 1/                  
 13G./jamfsoftware 
756K./mysql 
  0B./test 
 41G. 

Here are the files in the directory, notice that I have a lot of these bin files about 1 gig in size 

xs001-casper:mysql root# ls -al 
total 59105792 
drwxr-xr-x   55 _mysql  admin        1870 Sep 29 15:54 . 
drwxr-xr-x   33 root    wheel        1122 Aug 14 20:30 .. 
-rw-rw----    1 _mysql  admin     5242880 Sep 29 15:54 ib_logfile0 
-rw-rw----    1 _mysql  admin     5242880 Aug 13 19:05 ib_logfile1 
-rw-rw----    1 _mysql  admin    10485760 Sep 29 15:53 ibdata1 
drwx------  295 _mysql  admin       10030 Sep 29 15:31 jamfsoftware 
drwx------   53 _mysql  admin        1802 Aug 13 19:05 mysql 
-rw-rw----    1 _mysql  admin       14701 Aug 13 19:05 mysql-bin.000001 
-rw-rw----    1 _mysql  admin      588296 Aug 13 19:05 mysql-bin.000002 
-rw-rw----    1 _mysql  admin  1074389036 Aug 13 19:25 mysql-bin.000003 
-rw-rw----    1 _mysql  admin  1074186439 Aug 13 19:27 mysql-bin.000004 
-rw-rw----    1 _mysql  admin   303974352 Aug 13 19:52 mysql-bin.000005 
-rw-rw----    1 _mysql  admin      705832 Aug 13 20:16 mysql-bin.000006 
-rw-rw----    1 _mysql  admin      233165 Aug 13 20:27 mysql-bin.000007 
-rw-rw----    1 _mysql  admin      985680 Aug 13 20:56 mysql-bin.000008 
-rw-rw----    1 _mysql  admin   127128263 Aug 15 13:03 mysql-bin.000009 
-rw-rw----    1 _mysql  admin    54635342 Aug 20 10:55 mysql-bin.000010 
-rw-rw----    1 _mysql  admin     2042997 Aug 20 13:44 mysql-bin.000011 
-rw-rw----    1 _mysql  admin  1073747635 Aug 26 09:50 mysql-bin.000012 
-rw-rw----    1 _mysql  admin  1073741874 Aug 27 19:16 mysql-bin.000013 
-rw-rw----    1 _mysql  admin  1073742069 Aug 29 12:27 mysql-bin.000014 
-rw-rw----    1 _mysql  admin  1073741954 Sep  2 11:37 mysql-bin.000015 
-rw-rw----    1 _mysql  admin  1073756134 Sep  3 11:06 mysql-bin.000016 
-rw-rw----    1 _mysql  admin  1073741890 Sep  4 11:25 mysql-bin.000017 
-rw-rw----    1 _mysql  admin  1073754600 Sep  5 09:51 mysql-bin.000018 
-rw-rw----    1 _mysql  admin  1073759270 Sep  8 07:59 mysql-bin.000019 
-rw-rw----    1 _mysql  admin  1073743668 Sep  8 23:06 mysql-bin.000020 
-rw-rw----    1 _mysql  admin  1073752134 Sep  9 13:12 mysql-bin.000021 
-rw-rw----    1 _mysql  admin  1073742881 Sep 10 10:49 mysql-bin.000022 
-rw-rw----    1 _mysql  admin  1073741896 Sep 11 10:26 mysql-bin.000023 
-rw-rw----    1 _mysql  admin  1073741974 Sep 12 08:04 mysql-bin.000024 
-rw-rw----    1 _mysql  admin  1073742013 Sep 12 12:34 mysql-bin.000025 
-rw-rw----    1 _mysql  admin  1073743302 Sep 15 09:52 mysql-bin.000026 
-rw-rw----    1 _mysql  admin  1073741978 Sep 15 16:18 mysql-bin.000027 
-rw-rw----    1 _mysql  admin  1073743164 Sep 16 11:51 mysql-bin.000028 
-rw-rw----    1 _mysql  admin   455707160 Sep 16 14:04 mysql-bin.000029 
-rw-rw----    1 _mysql  admin   146945607 Sep 16 16:25 mysql-bin.000030 
-rw-rw----    1 _mysql  admin   112651946 Sep 17 08:23 mysql-bin.000031 
-rw-rw----    1 _mysql  admin  1073742044 Sep 17 18:30 mysql-bin.000032 
-rw-rw----    1 _mysql  admin  1073741957 Sep 18 11:16 mysql-bin.000033 
-rw-rw----    1 _mysql  admin  1073744488 Sep 19 08:04 mysql-bin.000034 
-rw-rw----    1 _mysql  admin  1073741905 Sep 19 12:22 mysql-bin.000035 
-rw-rw----    1 _mysql  admin   366354291 Sep 19 14:11 mysql-bin.000036 
-rw-rw----    1 _mysql  admin   817626683 Sep 22 10:26 mysql-bin.000037 
-rw-rw----    1 _mysql  admin  1073745275 Sep 23 08:14 mysql-bin.000038 
-rw-rw----    1 _mysql  admin  1073756082 Sep 23 13:15 mysql-bin.000039 
-rw-rw----    1 _mysql  admin   343654400 Sep 24 08:06 mysql-bin.000040 
-rw-rw----    1 _mysql  admin   359678206 Sep 24 09:54 mysql-bin.000041 
-rw-rw----    1 _mysql  admin   286920704 Sep 29 08:09 mysql-bin.000042 
-rw-rw----    1 _mysql  admin    16091601 Sep 29 15:53 mysql-bin.000043 
-rw-rw----    1 _mysql  admin      414656 Sep 29 16:17 mysql-bin.000044 
-rw-rw----    1 _mysql  admin         836 Sep 29 15:54 mysql-bin.index 
srwxrwxrwx    1 _mysql  admin           0 Sep 29 15:54 mysql.sock 
drwx------    2 _mysql  admin          68 Aug 13 19:05 test 
-rw-rw----    1 _mysql  admin           5 Sep 29 15:54 xs001-casper.kckps.org.pid 


What can I delete?  What can I optimize?  I am not a mysql expert and am still learning how to use the command line and what I can get rid of and what I need to keep. 

Thanks in advance for any advice on either question 
___________________________
Thomas Larkin
TIS Department
KCKPS USD500
tlarki at kckps.org
blackberry:  913-449-7589
office:  913-627-0351






-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.jamfsoftware.com/pipermail/casper/attachments/20080929/254367c9/attachment.html 


More information about the Casper mailing list