Posts on bx2@blog

Records missing the routing field poisoned the S3 output.

A skill that extracts learnings from coding sessions into your journal.

This post builds upon another post of mine about named collections - check references for deets.

My personal framework for debugging and issue investigation.

Tracing 100% CPU to exhausted ephemeral ports from Redis connections.

Re-trigger S3 events without re-uploading using --metadata-directive REPLACE.

Clickhouse ships with hidden web tools on port 8123.

How to diagnose high parts count warnings and identify ingestion pipeline problems.

Checklist for investigating unexpected server reboots.

A collection of diagnostic and monitoring queries I use regularly.

A timezone bug where filtering works but display shows UTC data.

Local OpenResty development with Docker for testing Lua code.

Using WITH FILL to generate complete date ranges for period-over-period comparisons.

A mental model for programmatic advertising metrics: think supply (publishers/SSPs) and demand (advertisers/DSPs).

Export Route53 zones to BIND format with aws cli and jq.

Using smartmontools to check SSD health via SMART.

List running queries across all nodes in a Clickhouse cluster using clusterAllReplicas.

Why readonly=1 prevents changing query settings and how readonly=2 solves it.

Commands for gathering hardware details: manufacturer, model, serial numbers.

Getting started with Go's built-in pprof profiling tools.

Explaining lightweight deletes: marks rows as deleted without immediate physical removal.

Using mkcert to create locally-trusted SSL certificates.

A query to get table sizes, row counts, and active parts.

Store and reuse credentials for remote Clickhouse connections.

Using reptyr to move running processes to a new terminal or tmux.

Configuring AWS CLI to work with Wasabi storage.

Using lsof to check what process runs on a specific port.

Using ssh-copy-id to install your public key on remote servers.