Every once in a while I need to find and delete some rouge queries in MySQL. Here is how to show the list of queries for the current users: SHOWPROCESSLIST;Once the correct query has been identified the query can be killed like this:

Samba Empty Folder I recently had an folder in one of my network shares showing up empty, despite the fact that it was not empty. After some investigation it turned out that the containg folder had a trailing space symbol, which is not allowed in the SMB protocol. Removing the trailing space (and reloading the mount) fixed the issue. I ran the following command to see if I had more folders with that issue and sure enough I found another one.

OSX Mount NFS With Proper Unicode Encoding I recently move my external storage to a NAS. After some testing I decided to use NFS instead of SMB to mount my data. One issue I ran into was that OSX was not correctly showing filenames that contained unicodes. The solution was to use the nfc (Normalization Form C) option when mounting the filesystem.

Fixing Half Network Bandwidth Issue A little while back I got a small PC to turn into a small server running True NAS. While testing the network performance with iperf3 I noticed that the network bandwidth when sending data from the server was only half of the availabe bandwidth of network. The problem was not specific to True NAS but rather an issues introduced in the underlying Linux driver for the network card .

The simplest way of removing stale homebrew dependencies is by running brew autoremove.

I recently had to upgrade an external hard drive to a higher capacity. I used rsync in the archive mode to ensure to preserve all the necessary meta data. One of the main reasons for this was to avoid having to re-read the whole drive in backup programs (due to changed timestamp). In the case of restic though it was scanning all the files nonetheless. After some digging and I figure out the issue.