BestHub
Sign in

Databases

Showing 100 articles max
Latest Popular
dbaplus Community
dbaplus Community
Aug 30, 2026 · Databases

Why OFFSET Pagination Slows You Down: Switch to Keyset and Cut Latency from Seconds to Milliseconds

The article recounts how an API that originally used OFFSET pagination suffered 2‑3 seconds response time, and after rewriting the query to Keyset (Seek) pagination—adding a secondary sort key for stability and exploring cursor pagination, index‑only OFFSET, and materialized views—the same endpoint now responds in under 200 ms, with detailed benchmark comparisons.

Cursor PaginationDatabase IndexingKeyset Pagination
0 likes · 7 min read
Why OFFSET Pagination Slows You Down: Switch to Keyset and Cut Latency from Seconds to Milliseconds
liandk
liandk
Aug 29, 2026 · Databases

Master MySQL Slow Query Log: Full Hands‑On Workflow to Capture, Analyze, and Fix Slow SQL

This guide explains what the MySQL slow query log records, why it is essential for production, when and how to enable it temporarily or permanently, key parameters to tune, how to simulate slow queries, interpret log fields, use mysqldumpslow for aggregation, follow a step‑by‑step optimization pipeline, and avoid common pitfalls.

Database OptimizationMySQLPerformance Tuning
0 likes · 10 min read
Master MySQL Slow Query Log: Full Hands‑On Workflow to Capture, Analyze, and Fix Slow SQL
Java Architect Handbook
Java Architect Handbook
Aug 29, 2026 · Databases

Why Use ElasticSearch over MySQL? Key Differences for Interviews

The article explains why ElasticSearch excels at full‑text search and analytics while MySQL remains the reliable storage engine, compares their underlying data structures, outlines real‑time write behavior, lists scenarios where ES should not be used, and describes a production double‑store architecture with asynchronous sync.

B+TreeData SynchronizationElasticSearch
0 likes · 14 min read
Why Use ElasticSearch over MySQL? Key Differences for Interviews
ITPUB
ITPUB
Aug 26, 2026 · Databases

Building a Digital Intelligence Foundation: GoldenDB’s Core Foundations and AI‑Driven Integration

The article outlines GoldenDB’s evolution from a secure, commercial‑grade core database to an AI‑enabled, multi‑modal data platform, detailing its architecture, dual "DB for AI" and "AI for DB" strategy, autonomous operation framework, and the broader shift toward databases as intelligent, self‑evolving infrastructure.

AI integrationAutonomous OperationsData Infrastructure
0 likes · 11 min read
Building a Digital Intelligence Foundation: GoldenDB’s Core Foundations and AI‑Driven Integration
ITPUB
ITPUB
Aug 25, 2026 · Databases

From Modeling to Systematic Theory: Tracing a Decade of Database Consistency Evolution (2020‑2025)

The article reviews a speaker’s ten‑year journey from building multi‑level consistency models and defining over twenty new data anomalies to exposing ANSI‑SQL’s isolation flaws, unveiling the “Eight Immortals” consistency diagram, proposing the CCDB architecture with zero‑time unlock, and finally codifying three concurrent‑system design principles.

CCDBconcurrencyconsistency
0 likes · 30 min read
From Modeling to Systematic Theory: Tracing a Decade of Database Consistency Evolution (2020‑2025)
liandk
liandk
Aug 25, 2026 · Databases

Final Chapter: Master SQL Server Stored Procedures – Batch Execution & Params

This concluding tutorial walks beginners through SQL Server stored procedures, highlighting their speed, reusability, and automation advantages over single statements and views, and demonstrates creating, invoking (with and without parameters), altering, and dropping procedures while sharing naming conventions and common pitfalls.

Backend DevelopmentDatabase AutomationSQL
0 likes · 6 min read
Final Chapter: Master SQL Server Stored Procedures – Batch Execution & Params
liandk
liandk
Aug 24, 2026 · Databases

One‑Line Queries: Using Database Views to Encapsulate Complex SQL

This article explains how database views act as virtual tables that store only query logic, allowing developers to replace repetitive, multi‑join SQL statements with a single, reusable query while improving consistency, hiding sensitive fields, and boosting development efficiency.

Data ModelingDatabase ViewsQuery Optimization
0 likes · 4 min read
One‑Line Queries: Using Database Views to Encapsulate Complex SQL
liandk
liandk
Aug 23, 2026 · Databases

MySQL Covering Index & Back‑Table Optimization: Hands‑On Guide to Eliminate Lookups

The article explains why MySQL back‑table lookups (回表) double I/O and degrade performance, defines covering indexes that retrieve all needed columns from a secondary index, shows how to identify back‑table cases via EXPLAIN, and provides step‑by‑step commands to create, test, and verify covering indexes for high‑frequency queries.

Covering IndexEXPLAINMySQL
0 likes · 11 min read
MySQL Covering Index & Back‑Table Optimization: Hands‑On Guide to Eliminate Lookups
samdeepthink
samdeepthink
Aug 23, 2026 · Databases

Is Splitting Data Across Machines Distributed? Understand Sharding vs Distributed Systems

The article explains that merely placing data on multiple machines constitutes sharding—a way to split data for capacity—but true distributed systems require coordinated nodes that communicate, replicate, and handle failures, illustrated with an e‑commerce warehouse analogy and guidance on choosing between sharding and distributed databases.

Distributed Systemsdatabase architectureselection criteria
0 likes · 8 min read
Is Splitting Data Across Machines Distributed? Understand Sharding vs Distributed Systems
liandk
liandk
Aug 22, 2026 · Databases

Mastering Database Transactions: Eliminate Data Chaos and Loss with ACID Basics

The article explains how database transactions ensure atomicity, consistency, isolation, and durability, showing why they are essential for preventing data inconsistency, loss, and reconciliation errors, and provides step‑by‑step SQL examples of successful and rolled‑back transactions along with practical tips for safe usage.

ACIDBackend DevelopmentData Consistency
0 likes · 6 min read
Mastering Database Transactions: Eliminate Data Chaos and Loss with ACID Basics
ITPUB
ITPUB
Aug 22, 2026 · Databases

How DBAs Can Transform with AI: Insights from DTCC 2026

The 17th China Database Technology Conference showcased DBA‑AI transformation strategies, highlighting five‑stage evolution paths, lightweight big‑data + AI architectures, and the emerging Agentic Data Stack, while warning of AI hallucination risks and emphasizing human‑AI collaboration for future data engineering.

AIAgentic AIBig Data
0 likes · 12 min read
How DBAs Can Transform with AI: Insights from DTCC 2026
liandk
liandk
Aug 22, 2026 · Databases

Master MySQL MVCC: Snapshot vs Current Reads and Isolation Level Mechanics

This article explains MySQL InnoDB's MVCC mechanism, detailing how snapshot reads and current reads work, the hidden fields that drive versioning, the Read View rules for RC and RR isolation levels, and provides hands‑on SQL demos plus common pitfalls to avoid.

Current ReadInnoDBMVCC
0 likes · 12 min read
Master MySQL MVCC: Snapshot vs Current Reads and Isolation Level Mechanics
liandk
liandk
Aug 22, 2026 · Databases

Why Your SQL Is Slow and How Indexes Can Make Queries Run in Seconds

The article explains that indexes are the key to solving most database slow‑query problems, compares full‑table scans with indexed lookups, describes the two main index types in SQL Server, and provides step‑by‑step T‑SQL commands for creating, testing, and removing indexes while warning against over‑indexing.

Database IndexesPerformance OptimizationQuery Tuning
0 likes · 5 min read
Why Your SQL Is Slow and How Indexes Can Make Queries Run in Seconds
Mike Chen Rui
Mike Chen Rui
Aug 21, 2026 · Databases

Mastering MySQL Sharding: Principles, Architecture, and Real‑World Implementation

The article explains why high‑traffic MySQL deployments hit performance limits, introduces the concepts of vertical and horizontal sharding, and provides a step‑by‑step guide—including necessity assessment, shard key selection, schema design, middleware integration, and data migration—using an e‑commerce order system as a concrete example.

Data MigrationDatabase ScalingHorizontal Sharding
0 likes · 5 min read
Mastering MySQL Sharding: Principles, Architecture, and Real‑World Implementation
Code Farming
Code Farming
Aug 21, 2026 · Databases

How to Cut Redis Cluster Failover to Under 10 Seconds

The article breaks down Redis‑Cluster failover into detection, election, failover, and client perception stages, explains the timing bottlenecks of each, and provides concrete server‑side and Lettuce client configurations that shrink end‑to‑end recovery to under ten seconds.

FailoverLettucePerformance Tuning
0 likes · 7 min read
How to Cut Redis Cluster Failover to Under 10 Seconds
Mike Chen Rui
Mike Chen Rui
Aug 20, 2026 · Databases

Complete MySQL Master‑Slave Replication: Principles, Architecture, and Setup

MySQL master‑slave replication separates writes to the master and reads to one or more replicas, using binary logs to record changes; the article explains its core concepts, typical scenarios like read‑write splitting and high‑availability, and provides a step‑by‑step configuration guide covering server IDs, binlog settings, replication accounts, data initialization, GTID options, and status verification.

Binary LogGTIDMaster‑Slave
0 likes · 5 min read
Complete MySQL Master‑Slave Replication: Principles, Architecture, and Setup