Topic
RedisIntermediateOne slow command blocks every client. Find it with SLOWLOG and LATENCY DOCTOR, then replace KEYS with SCAN, split big keys, delete with UNLINK and tame fork pauses.
#caching#performance#troubleshooting
Memcached is a fast, simple, multi-threaded blob cache; Redis is a data-structure server with persistence and replication. How to choose, and the pitfalls both share.
#caching#performance
TimescaleDBIntermediateSince TimescaleDB 2.13 continuous aggregates are materialized-only by default. Refresh policies, real-time aggregation and backfilling explained.
#maintenance#performance#troubleshooting
RedisAdvancedWhat changes at scale: stampede locks, probabilistic early refresh, stale-while-revalidate, hot keys, negative caching, pipelining, timeouts, circuit breakers, warmup, clustering and alerts.
#caching#nosql#performance
TiDBAdvancedSequential keys send every insert to one Region on one TiKV node. Spot the hotspot, then fix it with AUTO_RANDOM, SHARD_ROW_ID_BITS and pre-split Regions.
#performance#scalability#schema-design
RedisIntermediateRedis and Memcached compared by mechanism: threading, slab vs allocator memory, expiry and eviction, persistence, clustering, meta commands, operations and licensing, with a recommendation.
#caching#internals#nosql
InfluxDBIntermediateEvery distinct tag value creates new series. Unbounded tags such as IDs and URLs cause slow writes, query timeouts and OOMs. Measure cardinality and fix the schema.
#performance#schema-design#troubleshooting
RedisAdvancedEach Redis cache pattern with code, guarantees and failure modes, then the stale-set race, why delete beats update, versioned writes, outbox and CDC invalidation, and what to use for which data.
#caching#concurrency#nosql
RedisBeginnerWhat to cache, string vs hash, key naming, how TTLs and expiry work, maxmemory and every eviction policy, a working cache-aside example, and the commands to measure and secure a Redis cache.
#caching#configuration#nosql
Google BigQueryBeginnerOn-demand BigQuery bills the bytes a query reads, and LIMIT doesn't reduce them. Use partitioning, clustering, dry runs and byte caps to control cost.
#cost-optimization#performance#schema-design
Throttled at 30% usage? Throughput is split across physical partitions, so one hot partition key throttles alone. Diagnose it, then fix keys, RU costs and scaling.
#data-modeling#performance#troubleshooting
