December 2017 Crypto Tab Sweep

Cryptocurrencies? Blockchains? I’m sure you’ve heard of them before by now, unless you’re living under a rock. I’m an open source & database guy, so for me, I look at all this with a fine toothed comb. Probably doesn’t help that I enjoy reading the FT on a daily basis. Anyway, a selection of links… You may not be able to read all the links (subscriber only), but maybe I’ll think about something new come 2018.

Percona Live Santa Clara 2018 CFP

Percona Live Santa Clara 2018 call for papers ends fairly soon — December 22 2017. It may be extended, but I suggest getting a topic in ASAP so the conference committee can view everything fairly and quickly. Remember this conference is bigger than just MySQL, so please submit topics on MongoDB, other databases like PostgreSQL, time series, etc., and of course MySQL.

What are you waiting for? Submit TODAY!
(It goes without saying that speakers get a free pass to attend the event.)

Not all cloud instances are created equal

You know how anecdotally we say, “in the cloud, bad nodes exist” so you should always get a baseline?

Today I ran a query (repeatedly) on sqlite3, and on two instances, I got time measured as:

Run Time: real 13.405 user 13.243332 sys 0.046667
Run Time: real 10.989 user 10.963332 sys 0.010000

This naturally skewed results I initially got for something related to MySQL/MariaDB benchmarking. It really was such that while I had 2 instances, in the same region/AZ, I had one “good” node and one “bad” node.

Updating the locate database on macOS

Today I uninstalled CrashPlan on my macOS laptop since on August 22 2017 they announced they were exiting the home user market. I think the party is close to being over as even Amazon CloudDrive is now limited to 1TB of storage.

I wanted to ensure I removed any traces of CrashPlan. I use the locate command a lot. Ever wondered how to run the equivalent of updatedb on macOS? Its locate.updatedb (comes with a man page too). Run sudo /usr/libexec/locate.updatedb and that updates the locate database.

Pleased to say CrashPlan went away quite cleanly.

Keybase and FUSE on macOS

I like the concept of Keybase, have had an account there for sometime (https://keybase.io/bytebot). I also installed the Keybase app on macOS which has kbfs, the FUSE-based filesystem for Keybase users to share files with encryption (read more).

However, I also tend to spend time offline, and sometimes on restricted networks where I use TripMode. I realised very quickly that a simple ls or df could take some 20 seconds to complete (timeouts at work).

After poking around I realised it was Keybase. So this is what I do now:

keybase ctl stop
pkill Keybase

I used to have to also unmount the /keybase directory but this seems to be taken care of by newer clients. A macOS annoyance. I can’t always just have it running. There is a github issue #971. I think their iOS app is quite well done and have no complaints thus far.

Writing on the Percona blog, upcoming appearances

I’ve started a column at the Percona Database Performance Blog, and some recent posts (I don’t plan to record all this; I might just upload the pre-edited Markdown to Github at some stage):

Watch that blog every Friday.

I also have some upcoming appearances and I look forward to meeting you there:


i