InfluxDB Tips #1

Changing a tag value in InfluxDB 2

InfluxDB is designed to to enable fast reading and writing of data, at the expense of not allowing for updating.

If you only need to change or add field values and not the measurment name or tags then you can overwrite existing data by ensuring the same timestamp, tags, and tag values are used (You can think of the combination of the timestamp and tags forming a primary key or unique row).

If you need to change the measurment name, or change tags in any way, then it’s quite an involved process that requires some thought to avoid making mistakes.

[Read More]

Grafana and InfluxDB #1

Downsampling and dynamic queries

Over the past year I’ve had the opportunity to use Telegraf, InfluxDB, and Grafana as part of my day job. During this time I’ve stumbled into many problems which I’ve had to work out solutions to, so I thought I would share them since real world examples using InfluxDB, expecially version 2 and Flux, are few and far between.

[Read More]

Prevent Accidentally Activating Hot Corners in MacOS

I find Hot Corners an essential MacOS feature, especially when using apps in full-screen mode or screen sharing.  One downside of the feature is that it’s easy to accidentally activate. A way to prevent this, which isn’t at all obvious, is to require a modifier key as well as moving your mouse into the corner.

[Read More]

Connection Timeout When Trying to SSH From a Mac to Linux

Recently I had to SSH from Mac OS X on my MacBook Pro running Yosemite (I also confirmed the same behaviour on Mavericks) to a host running Oracle Enterprise Linux 5.7. The ssh command would simply freeze, then time out with the following error a short while later.

[Read More]