Date: 2008-04-21 12:07 Subject: OS X swap files cleanup? Security: Public

While at the MySQL Conf, I bought an Apple Time Capsule (1TB). I like it. It does appear that at least an initial time Machine backup eats significant swap space; not RAM as such, I have 4GB in my MacBook and it's not used up at all...

Anyway, OS X cleans up the (encrypted) swap files in /private/var/vm on startup. However, I tend to not reboot my machine a lot, since just closing the lid has a near-100% survival rate (one of the reasons I use a Mac). So now I have these swap files hogging my diskspace. Right now I have 20 of about 1M. Of course, the same directory also holds the 'sleepimage' which with my amount of RAM is over 4GB in itself. Anyway, I'd rather not have OS X eat up 2GB of my disk until I decide to reboot - and I really don't want to reboot!

So, anyone have an idea on how to get rid of old swap files without rebooting? I've found info online about completely disabling swap, but that is (even with 4GB RAM) probably not the best solution....

Date: 2008-04-21 14:44 Subject: Post-note on MySQL Conference 2008 - was it good? Security: Public

(I really can't be stuffed referring to the "mysql conf and expo", to me it's the mysql conf).

Jay, thanks for a great conference! It was good "being back" and catching up with so many friendly community faces, and all my ex-colleagues among them. My own photos from the event are here: http://www.flickr.com/photos/arjen-lentz/tags/mysqlconf08/, all tagged with 'mysqlconf08' to fit in with Mark Atwood's Flickr group.

I was present when Florian Haas (of LINBIT - DRBD) was asked by a conf delegate whether he thought the conference had been successful for him in a business sense. I wholeheartedly agree with his response, which was "Euh, let me think... hell yea!". I think that summarises it very well ;-)

Now to go on dealing with the joys and risks of (rapid) business expansion... Open Query is doing "alright" ;-)

Date: 2008-04-21 17:11 Subject: GRAPH engine post-conf update Security: Public

With assistance from Antony Curtis who spent some coding time with me at the conf, and a number of helpful other individuals (Monty, Sergei, Timour, Igor, patg, Stewart, Brian, Mark, Paul, and others) who answered questions and looked things up, the earlier backend demo can now be executed from a MySQL 5.1 server with the OQGRAPH Engine plugin loaded. In other words, the basic glue has been completed, and the prototype works. Thanks all!

This was later in the week, so at the BoF Tuesday night we still had to make do with paper and the backend test tool, but Thursday evening and Friday I was able to demonstrate the real thing, including at the post-conf MySQL unconference at Google HQ. I was happy to see good interest in the GRAPH engine, and also received some very useful feedback.

Much more needs to be done, of course, but at least it's real working stuff now, well beyond the vaporware stage ;-)