I wrote this nearly a year ago, but did not publish it then. Tonight I found this query running, so I tried an explain analyse on it: That’s 10 seconds. Add an index: bacula=# create index media_lastwritten_idx on media(lastwritten); CREATE INDEX Run the query again: Forgive my math, but that’s over 10,000 times faster now.
Bacula: indexing on media.lastwritten Read More »
This just in: But I can’t fix that now. I’m off to the Oscars party.
Nagios smartmon stops working after python upgrade Read More »
How much space is used by my ZFS snapshots? That’s the question I asked. I found the answer here. Hope that helps.
How much space is used by my ZFS snapshots Read More »
Looks like I got DOS’d: I base that conclusion on the above messages and this post.
This post has it all: backups deduplication snapshots ZFS Bacula ezjail Backups are essential for proper sanity, or at least, a reasonable facsimile. I strongly believe that doing backups right is the only way to backup. Go big or go home. I’ve been converting all my servers to ZFS. I like ZFS for many reasons,
Script for listing the latest ZFS snapshot – starting place for Bacula backups Read More »
This morning, on a FreeBSD 9.2-RELEASE #0 r255898 system, I saw this in /var/log/messages: There was nothing around that entry to clue me in. I suspected a cronjob, based upon the time of day. I searched with Google and found only questions. This next command confirms my cronjob suspicion: OK, it’s got to be a
su: _secure_path: /nonexistent/.login_conf is not owned by uid 65534 Read More »
I recently watched a great video about design decisions. It features Mike Monteiro speaking at Webstock 13. I particularly liked these quotes: 28:15 – And remember every single time that you, as a designer, make it easier and more pleasant for anyone to find and use information and tools that help people live their lives,
How Designers Destroyed the World Read More »
I don’t yet have IPv6 native at home. Perhaps Verizon FiOS will provide it soon. In the meantime, I make use of Hurricane Electric, which seems to be everyone’s go-to ISP for tunnels. This post isn’t about creating an IPv6 tunnel. It’s about making sure that tunnel is rebuilt after you have an IP address
Updating your IPv6 tunnel after an IP address change Read More »