2 part question - Software update server and MySQL

[tlarkin]

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

[John_Wetter]

The MySQL one is probably a question for support, but I'll answer the first one:

We don't use managed preferences except for our 1-1 program, so we use Casper to enforce everything else, including software updates. I basically allow updates to go on the SUS server as we get a chance to test them a bit. Given time constraints, we usually only really test java updates (due to Infinite Campus), Safari updates (due to Webkit updates breaking NWEA testing in the past) and whole OS updates (just to make sure it doesn't break some app we use). ilife, iWork, Security Updates, etc. pretty much get approved after I read over the notes for them and haven't read in forums that it horribly breaks something. This way, a tech could do the 'check for updates' at any time and get a current set unless we're actively denying an update.

Then, in Casper I have a policy to set as server and install all updates. I have it set to 'run once per computer' and then once some updates build up, I flush the history for the policy so they get all the updates. I do this so we can let our staff know it's coming and also so we aren't interrupting staff constantly with updates. I usually flush the policy every 2-3 months being sure to avoid testing windows here in our K-12 environment.

-John
--
John Wetter
Technology Support Administrator
Technology & Information Services
Hopkins Public Schools
952-988-5373
john_wetter at hopkins.k12.mn.us

[ernstcs]

Hi Tom,

Question 1) I do as already similarly responded to. I run my own SUS. I don't enable things that require me to physically be at the machine for an update like some of the Firmware updates where you need to press and hold the Power Button, but anything else goes out that way after it's been somewhat tested, sometimes difficult to do comprehensively, but you'll figure out the common issues for your site soon enough I'm sure. It's nice because I never make updated Apple software packages because they just get patched normally, too. The way I prefer to have things setup would be to allow the Apple Software Update Service on a machine to still point to Apple's servers. If the end-user that has admin on their machine wants to do updates, all of them, they can choose to do so, including firmware. That's the case for all machines so I can go into a lab and run it manually to get firmware updates as well. I have a policy that runs over the weekend to patch labs from my server, although I'm possibly running into issues of making sure the system points to our internal SUS as I expect it to with the command options. Over time we would look at forcing patches to offices through policy so users would stay current within their version 10.4 or 10.5, and in the not so distant future 10.6.

Question 2) I found this with Google, not sure if it helps, but it seemed pretty decent. It wasn't specific to Leopard, but most things MySQL run across the board...most...

http://forums.devshed.com/mysql-help-4/big-files-in-usr-local-mysql-data-125417.html

I do not have those large files on my server, just to note.

Hope that helps.

Craig E