Let’s talk
INSIGHTS / KNOWLEDGE, SHARED

Ideas for
your next move.

Practical thinking for teams building software, securing systems and operating modern infrastructure. Explore our engineering field notes.

500 insights · Page 8 of 42

PostgreSQL Slots: Find the Consumer Retaining WAL — conceptual 3D-style vector showing WAL stream, Replication slot, Retained WAL, Consumer, Retention limit.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL Slots: Find the Consumer Retaining WAL

Investigate PostgreSQL replication-slot retention with consumer ownership, restart positions, retained-byte trends, and a deliberate recovery decision.

Read field note ↗
MySQL Plan Changes: Check Statistics After Data Shifts — conceptual 3D-style vector showing Data import, Statistics, Optimizer, Execution plan, Query samples.ENGINEERING JOURNAL ↗
Database Operations

MySQL Plan Changes: Check Statistics After Data Shifts

Investigate a MySQL plan regression after an import or data-distribution change by comparing estimates, stored statistics, and representative queries.

Read field note ↗
MySQL Connection Limits: Build an Application Pool Budget — conceptual 3D-style vector showing Application replicas, Pool budget, MySQL sessions, Capacity, Admin access.ENGINEERING JOURNAL ↗
Database Operations

MySQL Connection Limits: Build an Application Pool Budget

Investigate MySQL connection exhaustion by counting every application pool, separating active work from idle sessions, and preserving admin access.

Read field note ↗
MySQL Login Failures: Trace TLS and Authentication — conceptual 3D-style vector showing Connector, TLS identity, Account match, Database, Trust store.ENGINEERING JOURNAL ↗
Database Operations

MySQL Login Failures: Trace TLS and Authentication

Diagnose MySQL login changes by separating certificate trust, hostname identity, account matching, and connector authentication-plugin support.

Read field note ↗
MySQL Text Conversion: Test Encoding and Comparison Rules — conceptual 3D-style vector showing Client bytes, Connection encoding, Stored text, Comparison, Unique rule.ENGINEERING JOURNAL ↗
Database Operations

MySQL Text Conversion: Test Encoding and Comparison Rules

Review connection encoding, stored column definitions, and collation equality before changing MySQL text settings or converting existing data.

Read field note ↗
MySQL Online DDL: Check Metadata Locks Before Altering — conceptual 3D-style vector showing ALTER request, Metadata gate, Table, New schema, Open transaction.ENGINEERING JOURNAL ↗
Database Operations

MySQL Online DDL: Check Metadata Locks Before Altering

Prepare MySQL online schema work by checking operation support, metadata-lock dependencies, free space, and cancellation behavior in advance.

Read field note ↗
MySQL Binary Logs: Size Retention for Offline Consumers — conceptual 3D-style vector showing Transactions, Binary logs, Offline replica, Retention decision, Backup reader.ENGINEERING JOURNAL ↗
Database Operations

MySQL Binary Logs: Size Retention for Offline Consumers

Set a MySQL binary-log retention policy around disconnected replicas, backup recovery needs, and available disk capacity before purging files.

Read field note ↗
MySQL GTID Sets: Compare Histories Before Rejoining — conceptual 3D-style vector showing Source history, GTID comparison, Missing set, Rejoin plan, Unexpected set.ENGINEERING JOURNAL ↗
Database Operations

MySQL GTID Sets: Compare Histories Before Rejoining

Use MySQL GTID set comparisons to identify missing and unexpected transaction history before choosing a replica rejoin or rebuild path.

Read field note ↗
MySQL Promotion: Check Read-Only State and Write Fencing — conceptual 3D-style vector showing Application, Writer gate, Candidate, New writes, Old source.ENGINEERING JOURNAL ↗
Database Operations

MySQL Promotion: Check Read-Only State and Write Fencing

Prepare a self-managed MySQL promotion by checking transaction coverage, application routing, and read-only controls as one coordinated procedure.

Read field note ↗
MySQL Replica Lag: Separate Receiving from Applying — conceptual 3D-style vector showing Writer, Source, Receiver, Replica, Applier.ENGINEERING JOURNAL ↗
Database Operations

MySQL Replica Lag: Separate Receiving from Applying

Investigate self-managed MySQL replication lag by comparing transport, worker progress, and transaction age before changing replica capacity.

Read field note ↗
Windows Pagefiles: Reconcile Commit and Crash-Dump Needs — conceptual 3D-style vector showing Application commit, Commit limit, RAM capacity, Pagefile backing, Crash-dump policy, Disk headroom.ENGINEERING JOURNAL ↗
Windows Operations

Windows Pagefiles: Reconcile Commit and Crash-Dump Needs

Review Windows pagefile sizing through peak committed memory, selected crash-dump requirements and available disk capacity rather than a fixed RAM multiplier.

Read field note ↗
WinRM Outside a Domain: Verify Server Identity and Access — conceptual 3D-style vector showing Management client, HTTPS listener, Server certificate, Authentication, Session endpoint, Remote identity.ENGINEERING JOURNAL ↗
Windows Operations

WinRM Outside a Domain: Verify Server Identity and Access

Trace workgroup WinRM failures through listener, certificate identity, authentication and endpoint permissions without treating TrustedHosts as a universal repair.

Read field note ↗