BestHub
Sign in
Tagged articles

offset

27 articles · Page 1 of 1
Java Tech Enthusiast
Java Tech Enthusiast
Aug 8, 2026 · Backend Development

Why Does Kafka Re‑Consume Tens of Thousands of Messages After a Successful Offset Commit?

The article explains why Kafka consumers can reprocess tens of thousands of messages after a restart despite successful offset commits, detailing the roles of automatic commit timing, rebalance triggers, GC pauses, and the limitations of manual commits, and offers practical configuration and idempotent processing solutions.

Kafkaconsumeridempotent
0 likes · 8 min read
Why Does Kafka Re‑Consume Tens of Thousands of Messages After a Successful Offset Commit?
Top Architect
Top Architect
Aug 7, 2024 · Backend Development

Kafka Consumer Deep Dive: Offset Management, Rebalance Strategies, and Thread Safety

This article explains Kafka consumer semantics such as at‑most‑once, at‑least‑once and exactly‑once delivery, shows how to configure and commit offsets, describes the rebalance process and partition‑assignment strategies, and discusses thread‑safety and task scheduling with illustrative Java code examples.

KafkaThread Safetyconsumer
0 likes · 17 min read
Kafka Consumer Deep Dive: Offset Management, Rebalance Strategies, and Thread Safety
Top Architect
Top Architect
Apr 19, 2024 · Databases

Problems with OFFSET/LIMIT Pagination and Cursor‑Based Alternatives

This article explains why using OFFSET and LIMIT for pagination becomes inefficient on large tables, illustrates the performance impact with examples, and proposes a cursor‑based pagination alternative that leverages indexed primary keys to achieve faster, scalable queries.

CursorDatabaseLIMIT
0 likes · 8 min read
Problems with OFFSET/LIMIT Pagination and Cursor‑Based Alternatives
php Courses
php Courses
Aug 23, 2023 · Backend Development

Using PHP substr_count() to Count Substring Occurrences

This article explains the PHP substr_count() function, its syntax, parameters, and demonstrates how to count substring occurrences with optional offset, length, and case‑sensitivity options through clear code examples.

COUNTcase-sensitivelength
0 likes · 4 min read
Using PHP substr_count() to Count Substring Occurrences
DataFunTalk
DataFunTalk
Mar 5, 2022 · Big Data

Designing Cross‑Period Dependencies in Data Scheduling Systems

This article explains how data scheduling systems manage task execution, ETL processes, and cross‑period dependencies by linking task versions, data partitions, and time parameters, and introduces the offset‑and‑cnt model to express dynamic dependencies in big‑data pipelines.

DAGData SchedulingETL
0 likes · 14 min read
Designing Cross‑Period Dependencies in Data Scheduling Systems
Top Architect
Top Architect
Sep 21, 2021 · Databases

Understanding MySQL LIMIT OFFSET Performance and Buffer‑Pool Impact

The article demonstrates how a large OFFSET in a MySQL LIMIT query forces MySQL to scan millions of index rows and data pages, causing severe slowdown, and shows that rewriting the query with an inner‑join sub‑select dramatically reduces I/O and buffer‑pool usage, confirming the performance difference through experiments.

InnoDBLIMITMySQL
0 likes · 8 min read
Understanding MySQL LIMIT OFFSET Performance and Buffer‑Pool Impact
NiuNiu MaTe
NiuNiu MaTe
Apr 14, 2021 · Databases

Why MySQL OFFSET Is So Slow and How to Fix It

This article examines why MySQL pagination with large OFFSET values becomes painfully slow, explains the underlying B+‑tree index mechanics, and presents two practical solutions—keyset pagination and index‑covering subqueries—to dramatically improve query performance.

B+TreeCovering IndexKeyset Pagination
0 likes · 8 min read
Why MySQL OFFSET Is So Slow and How to Fix It
Java Backend Technology
Java Backend Technology
Sep 17, 2020 · Databases

Why OFFSET/LIMIT Pagination Fails and How to Use Fast Cursor Pagination

This article explains why traditional OFFSET/LIMIT pagination becomes inefficient with large tables, illustrates its performance drawbacks with real examples, and introduces a high‑performance cursor‑based pagination method that leverages indexed primary keys to dramatically speed up data retrieval.

Cursor PaginationSQLoffset
0 likes · 6 min read
Why OFFSET/LIMIT Pagination Fails and How to Use Fast Cursor Pagination
Qunar Tech Salon
Qunar Tech Salon
Feb 27, 2018 · Big Data

Root Cause Analysis of Kafka Consumer Group Coordinator Failure and __consumer_offsets Compaction Issues

The article investigates a Kafka cluster outage where several brokers became unavailable and consumers could not join groups, explains the role of __consumer_offsets, analyzes the coordinator selection logic, identifies a stuck loadGroupsForPartition operation and compact thread failure, and documents the recovery steps taken.

Log Compactionconsumer-groupdistributed-systems
0 likes · 11 min read
Root Cause Analysis of Kafka Consumer Group Coordinator Failure and __consumer_offsets Compaction Issues
MaGe Linux Operations
MaGe Linux Operations
May 28, 2017 · Backend Development

Understanding Kafka’s Architecture: Topics, Partitions, and Reliability

This article explains Kafka’s core architecture—including brokers, topics, partitions, offsets, producer and consumer mechanics, replication, availability, consistency, persistence, performance optimizations, and Zookeeper integration—providing a comprehensive guide for building reliable distributed messaging systems.

Distributed MessagingKafkaTopic
0 likes · 15 min read
Understanding Kafka’s Architecture: Topics, Partitions, and Reliability