BestHub
Sign in
Tagged articles

Indexing

666 articles · Page 1 of 7
YiSu Grain
YiSu Grain
Aug 19, 2026 · Databases

Optimizing Slow Queries, Sharding and Cache Consistency for Appointment System

This article walks through a comprehensive case study of a provincial medical appointment platform, diagnosing slow‑query bottlenecks, proposing patient‑id + create_time composite indexes, designing read‑write separation with replication, selecting patient_id for horizontal sharding, and implementing cache‑aside strategies to ensure consistency while handling cache avalanche, penetration and thundering‑herd scenarios.

Cache ConsistencyIndexingMySQL
0 likes · 30 min read
Optimizing Slow Queries, Sharding and Cache Consistency for Appointment System
liandk
liandk
Aug 14, 2026 · Databases

Hands‑On MySQL Slow Query: Enable Logs, Analyze SQL, and Optimize Performance

The article explains what MySQL slow queries are, why they must be detected, when to enable slow‑query logging, step‑by‑step commands to configure the log, how to simulate and analyze problematic SQL with EXPLAIN, and practical optimization techniques—including index creation and Spring Boot integration—to eliminate performance bottlenecks.

IndexingMySQLSQL
0 likes · 10 min read
Hands‑On MySQL Slow Query: Enable Logs, Analyze SQL, and Optimize Performance
dbaplus Community
dbaplus Community
Jul 28, 2026 · Operations

PostgreSQL Ops Checklist: 13 Pitfalls to Avoid (2026 Edition)

The article provides a comprehensive PostgreSQL operational self‑checklist covering CPU, memory, generic plans, idle connections, autovacuum, checkpoint and bgwriter tuning, AI workload handling, index building, replication, migration, partition management, and observability, with concrete examples, benchmarks, and practical commands.

IndexingMemoryPostgreSQL
0 likes · 39 min read
PostgreSQL Ops Checklist: 13 Pitfalls to Avoid (2026 Edition)
Cloud Architecture
Cloud Architecture
Jul 17, 2026 · Backend Development

Elasticsearch Cluster: Inverted Index, Mechanics, Architecture for 100M+ Queries

This article provides a comprehensive, production‑grade guide to Elasticsearch clusters, covering the fundamentals of inverted indexes and Lucene segments, near‑real‑time write mechanics, shard routing, indexing pipelines, query execution flow, scaling strategies, and practical tips to avoid common pitfalls in high‑traffic search systems.

ElasticsearchIndexingJava
0 likes · 37 min read
Elasticsearch Cluster: Inverted Index, Mechanics, Architecture for 100M+ Queries
Linyb Geek Road
Linyb Geek Road
Jul 17, 2026 · Databases

8 Common SQL Mistakes That Are Destroying Your Database

The article identifies eight easy-to-overlook SQL habits—such as using SELECT *, applying functions on indexed columns, careless LIKE patterns, improper IN/OR logic, deep offset pagination, unconditional UPDATE/DELETE, excessive indexing, and ignoring execution plans—that can cause slow queries, lock tables, index failures, and even data loss, and provides concrete examples and safer alternatives.

DatabaseIndexingMySQL
0 likes · 12 min read
8 Common SQL Mistakes That Are Destroying Your Database
Linyb Geek Road
Linyb Geek Road
Jul 17, 2026 · Databases

Why 90% of Slow SQL Queries Aren’t Caused by Large Data Volumes

Most slow SQL statements stem from poor query writing—such as index‑breaking functions, implicit type casts, leading wildcards, unnecessary column selection, improper joins, sorting, grouping, and pagination—rather than merely the size of the data, and the article shows how to diagnose and fix each issue.

DatabaseIndexingQuery Optimization
0 likes · 11 min read
Why 90% of Slow SQL Queries Aren’t Caused by Large Data Volumes
dbaplus Community
dbaplus Community
Jul 12, 2026 · Databases

Stop Blaming Data Size: 90% of Slow SQLs Are Due to Poor Queries

This article reveals that most slow SQL queries aren't caused by large data volumes but by poor query writing, such as index‑killing functions, implicit type casts, leading wildcards, SELECT *, missing LIMIT, and inefficient JOINs, and offers a five‑step method to diagnose and fix them.

DatabasesIndexingQuery Optimization
0 likes · 11 min read
Stop Blaming Data Size: 90% of Slow SQLs Are Due to Poor Queries
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Jul 11, 2026 · Backend Development

Elasticsearch Introduces True Columnar Mode: What It Means for Storage and Analytics

Elasticsearch adds a new Columnar Mode in the 9.5 tech preview and 9.6 GA, storing data once in a columnar layout with on‑demand indexing, which cuts storage costs, speeds analytical queries, keeps the existing document mode intact, and offers a migration path for append‑only log and security workloads.

Analytics QueriesColumnar ModeElasticsearch
0 likes · 6 min read
Elasticsearch Introduces True Columnar Mode: What It Means for Storage and Analytics
Architect Chen
Architect Chen
Jul 9, 2026 · Databases

Essential Elasticsearch Commands (2026 Edition)

This guide walks through the most important Elasticsearch commands, covering cluster health checks, index listing, creation with mappings, deletion, mapping inspection, document insertion (with and without IDs), various query types, updates, deletions, pagination, sorting, and bulk operations, each illustrated with concrete examples and usage notes.

ElasticsearchIndexingbulk
0 likes · 5 min read
Essential Elasticsearch Commands (2026 Edition)
Architect Chen
Architect Chen
Jun 26, 2026 · Databases

Comprehensive MongoDB Command Reference (2026 Edition)

This article provides a complete, step‑by‑step guide to MongoDB shell commands—including show dbs, use, db, collection operations, indexing, aggregation and statistics—complete with syntax, example outputs and practical usage notes for developers and administrators.

AggregationData InsertionDatabase Administration
0 likes · 6 min read
Comprehensive MongoDB Command Reference (2026 Edition)
Ops Community
Ops Community
Jun 23, 2026 · Artificial Intelligence

Advanced LlamaIndex Indexing, Routing, and Multimodal RAG: A Practical Guide

This article walks through a real‑world contract‑review RAG project, diagnosing low recall, redesigning the system with multiple indexes, a RouterQueryEngine, re‑ranking, knowledge‑graph integration, multimodal support, incremental updates, and a rigorous evaluation framework that boosted recall from 60 % to 92 %.

IndexingKnowledge GraphMultimodal
0 likes · 22 min read
Advanced LlamaIndex Indexing, Routing, and Multimodal RAG: A Practical Guide
MaGe Linux Operations
MaGe Linux Operations
Jun 21, 2026 · Artificial Intelligence

Advanced LlamaIndex Indexing, Routing, and Multimodal RAG Strategies

The article walks through a real‑world legal‑contract RAG project that stalled at 60% recall, diagnoses five root causes, and demonstrates how combining multiple LlamaIndex indexes, a Router, fusion retrieval, re‑ranking, knowledge‑graph and multimodal support raises recall to 92% while outlining evaluation metrics, latency trade‑offs, and practical deployment checklists.

IndexingKnowledgeGraphMultimodal
0 likes · 23 min read
Advanced LlamaIndex Indexing, Routing, and Multimodal RAG Strategies
Architect Chen
Architect Chen
Jun 13, 2026 · Databases

Essential ElasticSearch Commands (2026 Edition)

This guide walks through the most common ElasticSearch commands, covering cluster health checks, index management, document CRUD operations, mapping inspection, full‑text and filtered searches, aggregations, and bulk inserts, while explaining each step with concrete examples and performance tips.

ElasticsearchIndexingbulk
0 likes · 6 min read
Essential ElasticSearch Commands (2026 Edition)
Java Tech Enthusiast
Java Tech Enthusiast
Jun 4, 2026 · Databases

Why PostgreSQL Beats MySQL in the AI Era

The article explains why developers should move beyond MySQL to PostgreSQL, illustrating the productivity gains of native window functions, MVCC concurrency, rich indexing, JSONB support, and extensive extensions through detailed examples, installation guides, performance comparisons, and real‑world use cases.

Database MigrationIndexingJSONB
0 likes · 24 min read
Why PostgreSQL Beats MySQL in the AI Era
MaGe Linux Operations
MaGe Linux Operations
May 30, 2026 · Databases

How Ops Engineers Fix MySQL Slow Queries: A Step‑by‑Step Guide

This article walks through the entire MySQL performance troubleshooting workflow from an operations perspective, covering architecture basics, slow‑query‑log configuration, analysis with mysqldumpslow and pt‑query‑digest, EXPLAIN interpretation, index design and optimization, configuration tuning, replication monitoring, real‑time diagnostic commands, risk mitigation, rollback procedures, and backup strategies.

ConfigurationIndexingMySQL
0 likes · 40 min read
How Ops Engineers Fix MySQL Slow Queries: A Step‑by‑Step Guide
Su San Talks Tech
Su San Talks Tech
May 30, 2026 · Databases

Why PostgreSQL Beats MySQL for AI‑Driven Applications

The article explains why many developers stuck with MySQL should consider PostgreSQL, highlighting its superior SQL standards support, MVCC concurrency, rich indexing, JSONB performance, full‑text search, extensive extensions, and practical installation and Java integration steps, while also comparing pros, cons, and ideal use cases.

DatabaseFull-text SearchIndexing
0 likes · 24 min read
Why PostgreSQL Beats MySQL for AI‑Driven Applications
Architect's Guide
Architect's Guide
May 23, 2026 · Databases

SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s

This article walks through a MySQL 5.6 case study where a sub‑query that originally took over eight hours is accelerated to a few milliseconds by analyzing the execution plan, adding single‑column and composite indexes, rewriting the query as EXISTS or JOIN, and applying best‑practice indexing techniques.

IndexingJOINMySQL
0 likes · 13 min read
SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s
MaGe Linux Operations
MaGe Linux Operations
May 19, 2026 · Databases

How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds

This article walks through a real‑world MySQL slow‑query case, showing how to identify the bottleneck with EXPLAIN, design covering and composite indexes, rewrite the SQL, tune InnoDB parameters, and safely deploy the changes, ultimately shrinking execution time from seconds to a few milliseconds.

EXPLAINIndexingMySQL
0 likes · 32 min read
How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds
IT Services Circle
IT Services Circle
May 12, 2026 · Databases

How to Diagnose and Resolve Online Slow SQL That Causes CPU Spikes

When a MySQL‑driven application shows sudden CPU spikes, this guide walks through a step‑by‑step process—using top/htop, SHOW PROCESSLIST, enabling slow‑query logs, analyzing EXPLAIN output, killing offending queries, adding appropriate indexes, rewriting joins, and establishing preventive monitoring—to quickly identify and fix the root cause.

CPU spikeIndexingMySQL
0 likes · 12 min read
How to Diagnose and Resolve Online Slow SQL That Causes CPU Spikes
Cloud Architecture
Cloud Architecture
May 10, 2026 · Databases

Building an Automated End-to-End Loop for Full-Stack SQL Performance Optimization

The article walks through a real-world e-commerce incident, explains why a seemingly simple slow order-query SQL can cripple an entire high-traffic system, and presents a complete automated workflow—from detection and analysis to optimization, deployment, verification, and regression monitoring—to achieve sustainable full-stack SQL performance.

IndexingMySQLObservability
0 likes · 28 min read
Building an Automated End-to-End Loop for Full-Stack SQL Performance Optimization
Su San Talks Tech
Su San Talks Tech
May 5, 2026 · Databases

Alibaba Interview: Key Considerations for Indexing Tens‑Millions‑Row Tables

The article explains how to safely add indexes to a tens‑of‑millions‑row MySQL table, covering lock duration, disk‑space impact, write‑performance degradation, and six practical principles—selective columns, proper order, covering indexes, avoiding redundancy, short‑lock tools, and ongoing monitoring—plus pros, cons, and suitable use cases.

IndexingLarge TablesMySQL
0 likes · 10 min read
Alibaba Interview: Key Considerations for Indexing Tens‑Millions‑Row Tables
Su San Talks Tech
Su San Talks Tech
May 3, 2026 · Databases

How to Speed Up a 10‑Table JOIN Query in MySQL (JD Interview Scenario)

When a production MySQL query joins ten tables and exceeds 30 seconds, a systematic approach—starting with EXPLAIN analysis, profiling, and configuration checks—combined with layered optimizations such as indexing, join order adjustment, query splitting, temporary tables, materialized views, OLAP engines, and vertical partitioning—can dramatically improve performance.

IndexingJOINMySQL
0 likes · 17 min read
How to Speed Up a 10‑Table JOIN Query in MySQL (JD Interview Scenario)
AI Architect Hub
AI Architect Hub
Apr 27, 2026 · Artificial Intelligence

Why HNSW Can Speed Up Search 50× Compared to Brute‑Force? A Hands‑On Guide to Building Vector Indexes

The article explains why brute‑force vector search is painfully slow, introduces Flat, IVF, and HNSW index structures, compares their speed, memory and accuracy, shows common pitfalls, provides production‑grade Python code, and presents benchmark results that demonstrate HNSW’s superior speed‑accuracy trade‑off.

FAISSHNSWIVF
0 likes · 12 min read
Why HNSW Can Speed Up Search 50× Compared to Brute‑Force? A Hands‑On Guide to Building Vector Indexes
James' Growth Diary
James' Growth Diary
Apr 26, 2026 · Databases

Vector Database Fundamentals: Embedding, Similarity Search, and Index Structures Explained in One Go

This article walks through the complete workflow of turning split text into high‑dimensional vectors, choosing the right embedding model, selecting an appropriate similarity metric, comparing index structures such as Flat, IVF, HNSW and PQ, and finally picking a vector database and integrating it with LangChain.js for production‑grade RAG pipelines.

IndexingLangChainRAG
0 likes · 25 min read
Vector Database Fundamentals: Embedding, Similarity Search, and Index Structures Explained in One Go
James' Growth Diary
James' Growth Diary
Apr 19, 2026 · Artificial Intelligence

Vector Database Basics: Embeddings, Similarity Search, and Index Structures

This article explains how embeddings turn text into high‑dimensional vectors, compares commercial and open‑source embedding models, details cosine, Euclidean and inner‑product similarity metrics, reviews common index structures such as Flat, IVF, HNSW and PQ, and shows how to choose and use a vector database with LangChain.js while avoiding typical pitfalls.

IndexingLangChainRAG
0 likes · 25 min read
Vector Database Basics: Embeddings, Similarity Search, and Index Structures
Big Data and Microservices
Big Data and Microservices
Apr 17, 2026 · Industry Insights

What Is a Vector Database? Features, Indexing, and Top Open‑Source Options

This article explains what a vector database is, how it stores and retrieves high‑dimensional vector data, outlines its key characteristics and indexing mechanisms, compares it with traditional databases, and reviews common open‑source vector database solutions such as Milvus, Faiss, Weaviate, PgVector, Chroma, LanceDB, Elasticsearch and Qdrant.

EmbeddingIndexingOpen Source
0 likes · 14 min read
What Is a Vector Database? Features, Indexing, and Top Open‑Source Options
Code Wrench
Code Wrench
Apr 12, 2026 · Databases

How to Safely Build a Primary Key Index on a 10‑Billion‑Row Table

When a table exceeds a billion rows, creating a primary key clustered index can turn a routine operation into a disaster, but by using OFFLINE mode, MAXDOP, SORT_IN_TEMPDB, proper tempdb sizing, and a detailed runbook, you can safely rebuild the table with minimal impact.

IndexingLarge TablesOffline Index
0 likes · 7 min read
How to Safely Build a Primary Key Index on a 10‑Billion‑Row Table
Lisa Notes
Lisa Notes
Mar 30, 2026 · Fundamentals

Python Basics: Common Strings and an Introduction to Lists

This tutorial note walks through Python variables, demonstrates how lists can store multiple heterogeneous items, explains list declaration, indexing, modification, and shows two ways to iterate over a list with concrete code examples and their output.

IndexingListsPython
0 likes · 3 min read
Python Basics: Common Strings and an Introduction to Lists
Code Wrench
Code Wrench
Mar 23, 2026 · Databases

Why Your MySQL Queries Slow Down in Production and How to Fix Them

The article explains why locally fast MySQL queries can become painfully slow in production, identifies three common pitfalls such as ineffective indexes, oversized Go connection pools, and hidden type conversions, and provides concrete optimization techniques spanning index design, query planning, Go‑MySQL integration, and systematic self‑checks.

GoIndexingMySQL
0 likes · 9 min read
Why Your MySQL Queries Slow Down in Production and How to Fix Them
LuTiao Programming
LuTiao Programming
Mar 14, 2026 · Backend Development

Why Your Spring Boot App Freezes at One Million Records – 5 Proven Techniques to Double Performance

When a Spring Boot application reaches millions of rows, it often suffers from OutOfMemoryErrors, slow queries, and high CPU, but by applying five proven strategies—pagination, streaming, batch processing, indexing, and asynchronous execution—you can halve memory usage and achieve up to ten‑fold speed gains.

Asynchronous ExecutionBatch ProcessingIndexing
0 likes · 11 min read
Why Your Spring Boot App Freezes at One Million Records – 5 Proven Techniques to Double Performance
Architecture & Thinking
Architecture & Thinking
Mar 13, 2026 · Databases

Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It

The article explains how deep pagination on massive MySQL tables causes full‑table scans, massive I/O, and memory pressure, then presents six concrete optimization techniques—including delayed join, cursor pagination, covering indexes, ID‑range pagination, caching, and partitioning—backed by a real‑world e‑commerce case study and detailed execution‑plan analysis.

Deep PaginationIndexingMySQL
0 likes · 18 min read
Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It
SpringMeng
SpringMeng
Mar 9, 2026 · Databases

10 Advanced MySQL Techniques to Supercharge Query Performance

This article walks through ten high‑level MySQL tricks—including EXPLAIN analysis, advanced indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user‑defined variables, online DDL, and generated columns—showing concrete examples, performance trade‑offs, and step‑by‑step guidance for turning slow queries into lightning‑fast operations.

CTEIndexingMySQL
0 likes · 15 min read
10 Advanced MySQL Techniques to Supercharge Query Performance
dbaplus Community
dbaplus Community
Mar 4, 2026 · Databases

Master PostgreSQL Execution Plans to Supercharge Your SQL Performance

This guide explains what PostgreSQL execution plans are, how they are generated, and how to interpret them using EXPLAIN and EXPLAIN ANALYZE, then demonstrates three real‑world case studies that show step‑by‑step optimizations with indexes, configuration tweaks, and query rewrites to dramatically improve query speed.

Database PerformanceIndexingPostgreSQL
0 likes · 16 min read
Master PostgreSQL Execution Plans to Supercharge Your SQL Performance
Shuge Unlimited
Shuge Unlimited
Feb 27, 2026 · Databases

Why Is Milvus, the 43K‑Star Vector Database, So Powerful?

This article analyzes Milvus—its open‑source origins, three deployment modes, four‑layer architecture, eight‑plus indexing algorithms, real‑world case studies, and a detailed comparison with competitors—highlighting its strengths, weaknesses, common pitfalls, and when it’s the right choice for large‑scale AI workloads.

AI workloadsCloud NativeIndexing
0 likes · 15 min read
Why Is Milvus, the 43K‑Star Vector Database, So Powerful?
Java Tech Enthusiast
Java Tech Enthusiast
Feb 16, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents eleven practical MySQL advanced techniques—including execution‑plan analysis, sophisticated indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user variables, online DDL, and generated columns—each explained with real‑world examples, code snippets, and performance caveats to help developers move from basic usage to mastery.

IndexingMySQLOptimization
0 likes · 20 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
IT Learning Made Simple
IT Learning Made Simple
Feb 13, 2026 · Databases

Designing Databases as Intelligent Warehouses: A Supermarket Analogy

This article explains core database design concepts—from relational vs. NoSQL choices and normalization rules to indexing strategies, ACID transactions, SQL optimization, and sharding—using supermarket‑style analogies and concrete exam‑style examples to help readers build fast, safe, and scalable data stores.

IndexingSQL OptimizationSharding
0 likes · 38 min read
Designing Databases as Intelligent Warehouses: A Supermarket Analogy
Tech Musings
Tech Musings
Feb 12, 2026 · Databases

From MySQL to Apache Doris: Key Design Shifts for OLAP Migration

This article explains how backend engineers should rethink table design, indexing, partitioning, and key strategies when migrating attendance data from MySQL's OLTP model to Apache Doris 2.1.7's OLAP architecture, providing concrete DDL examples and practical tips.

Apache DorisDatabase MigrationIndexing
0 likes · 12 min read
From MySQL to Apache Doris: Key Design Shifts for OLAP Migration
Su San Talks Tech
Su San Talks Tech
Feb 10, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents eleven practical MySQL advanced techniques—including EXPLAIN analysis, sophisticated indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user variables, online DDL, and generated columns—to help developers dramatically improve query performance and scalability in high‑load environments.

Advanced QueriesIndexingMySQL
0 likes · 18 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
Raymond Ops
Raymond Ops
Feb 3, 2026 · Databases

Master MySQL Performance: From Slow Queries to Billion‑Row Scaling

This guide walks you through diagnosing MySQL bottlenecks, enabling slow‑query logging, using pt‑query‑digest, optimizing indexes, tuning parameters, handling pagination, sharding, and troubleshooting deadlocks, providing concrete commands, scripts, and real‑world examples to boost query speed from seconds to fractions of a second on massive datasets.

IndexingMySQLmonitoring
0 likes · 24 min read
Master MySQL Performance: From Slow Queries to Billion‑Row Scaling
DevOps Coach
DevOps Coach
Jan 31, 2026 · Databases

7 Overlooked PostgreSQL Architecture Mistakes That Kill Performance

The article reveals seven common PostgreSQL architectural oversights—such as neglecting vacuum, misusing UUID primary keys, treating the database as a queue, missing indexes, over‑relying on ORMs, ignoring write‑side scaling, and failing to partition large tables—that silently degrade performance and reliability, and provides concrete fixes and best‑practice configurations.

IndexingORMPartitioning
0 likes · 7 min read
7 Overlooked PostgreSQL Architecture Mistakes That Kill Performance
Tech Musings
Tech Musings
Jan 29, 2026 · Databases

Mastering Redis 8 Vector Search: Indexing, Hybrid Retrieval, and Re‑ranking Techniques

This article explains how to use Redis 8.4.0 for vector recall and keyword filtering, covering index selection (FLAT vs HNSW), schema creation with redisvl, full‑text BM25 search, pure KNN vector queries, hybrid text‑plus‑vector retrieval, query cleaning, score fusion, and optional in‑Redis Lua re‑ranking or TAG‑based filtering extensions.

IndexingPythonvector-search
0 likes · 15 min read
Mastering Redis 8 Vector Search: Indexing, Hybrid Retrieval, and Re‑ranking Techniques
Ray's Galactic Tech
Ray's Galactic Tech
Jan 23, 2026 · Backend Development

How to Build a Kafka‑Level High‑Performance Message Queue from Scratch

This article presents a step‑by‑step guide to designing and implementing a Kafka‑class distributed log‑based message queue kernel, covering architecture, sequential writes, sparse indexing, zero‑copy I/O, partitioning, replication, consumer‑group metadata, batch pipelines, crash recovery, and performance benchmarks.

IndexingMessage QueueReplication
0 likes · 7 min read
How to Build a Kafka‑Level High‑Performance Message Queue from Scratch
Su San Talks Tech
Su San Talks Tech
Jan 7, 2026 · Databases

Why MySQL NULL Values Can Cause P0 Outages and How to Avoid Them

This article explains how improper use of NULL in MySQL columns can lead to serious production incidents, outlines official recommendations against NULL, demonstrates its impact on queries, indexes, and storage, and provides practical guidelines for when to use or avoid NULL values.

IndexingMySQLNULL
0 likes · 13 min read
Why MySQL NULL Values Can Cause P0 Outages and How to Avoid Them
JD Tech Talk
JD Tech Talk
Dec 12, 2025 · Big Data

Understanding Hudi Core Concepts: Timeline, Indexes, and Table Types Explained

This article explains Apache Hudi’s core concepts, including its timeline architecture, file layout, indexing mechanisms, and the two primary table types—Copy on Write and Merge on Read—along with their trade‑offs and the various query modes such as snapshot, time‑travel, and incremental queries.

Apache HudiBig DataIndexing
0 likes · 9 min read
Understanding Hudi Core Concepts: Timeline, Indexes, and Table Types Explained
DevOps Coach
DevOps Coach
Dec 8, 2025 · Databases

Why UUID Primary Keys Halve Your Database Throughput (And How to Fix It)

Using random UUID primary keys forces PostgreSQL to write to unpredictable index pages, causing heavy CPU usage, large index size, and dramatically higher insert latency, while switching to a sequential bigint key restores performance and reduces write amplification.

Database PerformanceIndexingPostgreSQL
0 likes · 7 min read
Why UUID Primary Keys Halve Your Database Throughput (And How to Fix It)
Ray's Galactic Tech
Ray's Galactic Tech
Dec 7, 2025 · Databases

Mastering MySQL Large-Scale Pagination: Ultimate Optimized Techniques

This article examines why traditional MySQL LIMIT offset pagination degrades performance on massive tables and presents five database‑level solutions plus engineering best practices—including delayed joins, covering indexes, cursor pagination, window functions, and partitioning—to achieve fast, scalable paging.

CursorIndexingMySQL
0 likes · 8 min read
Mastering MySQL Large-Scale Pagination: Ultimate Optimized Techniques
Java Tech Enthusiast
Java Tech Enthusiast
Dec 5, 2025 · Backend Development

Deploy and Master Meilisearch for Lightning‑Fast Full‑Text Search

This guide explains why Meilisearch is a lightweight alternative to Elasticsearch, walks through Docker‑based installation, demonstrates index creation, settings configuration, document CRUD operations, and various search queries, all with concrete curl commands and code examples.

DockerFull-text SearchIndexing
0 likes · 8 min read
Deploy and Master Meilisearch for Lightning‑Fast Full‑Text Search
Su San Talks Tech
Su San Talks Tech
Nov 26, 2025 · Databases

Master Database Indexes: 10 Essential Questions and Best Practices

This guide explores the fundamentals of database indexing, answering ten common questions about index design, performance pitfalls, composite indexes, covering indexes, NULL handling, and maintenance, while providing practical SQL examples, B+‑tree concepts, and best‑practice recommendations for MySQL and PostgreSQL.

B+TreeIndexingMySQL
0 likes · 13 min read
Master Database Indexes: 10 Essential Questions and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Nov 21, 2025 · Databases

How to Diagnose and Fix MySQL CPU Spikes to 100% in Production

This guide walks you through a complete, step‑by‑step process for identifying why MySQL CPU usage jumps to 100%, from initial symptom verification and data‑flow analysis to locating slow queries, killing them, optimizing SQL, adding indexes, and setting up monitoring and alerts to prevent recurrence.

CPUIndexingMySQL
0 likes · 44 min read
How to Diagnose and Fix MySQL CPU Spikes to 100% in Production
Java Companion
Java Companion
Nov 21, 2025 · Databases

How to Query Phone Number Suffix in Milliseconds on 50 Million Records

When faced with 50 million user rows, using LIKE '%1234' triggers a full table scan, but adding a suffix column, reversing the phone number, leveraging function indexes, or integrating Elasticsearch can reduce query time from minutes to a few milliseconds, each with its own trade‑offs.

ElasticsearchIndexingMySQL
0 likes · 12 min read
How to Query Phone Number Suffix in Milliseconds on 50 Million Records
Ray's Galactic Tech
Ray's Galactic Tech
Nov 19, 2025 · Databases

Master InnoDB: Architecture, Indexes, Transactions & Performance Tuning

This comprehensive guide walks you through MySQL InnoDB's core architecture, storage structures, indexing mechanisms, transaction and concurrency control, crash recovery, backup options, and practical performance‑tuning techniques, providing clear explanations and real‑world SQL examples.

Database ArchitectureIndexingInnoDB
0 likes · 8 min read
Master InnoDB: Architecture, Indexes, Transactions & Performance Tuning
Java Tech Enthusiast
Java Tech Enthusiast
Nov 9, 2025 · Databases

Why Setting MySQL Columns to NOT NULL Boosts Performance and Saves Space

This article explains how defining MySQL table columns as NOT NULL—rather than allowing NULL—can improve query speed, reduce storage consumption, simplify indexing and aggregation, make application code cleaner, and enhance data consistency, while also noting scenarios where NULL is appropriate.

AggregationIndexingMySQL
0 likes · 9 min read
Why Setting MySQL Columns to NOT NULL Boosts Performance and Saves Space
dbaplus Community
dbaplus Community
Nov 5, 2025 · Databases

Why KEYS Is Dangerous in Redis and How SCAN or Indexing Solves It

The article explains why using the KEYS command in Redis is a blocking operation that can cripple production systems, demonstrates the safe, incremental SCAN approach, and proposes an index‑based architecture or replica scans for high‑frequency or offline key‑lookup scenarios.

DatabaseIndexingKEYS
0 likes · 8 min read
Why KEYS Is Dangerous in Redis and How SCAN or Indexing Solves It
Senior Brother's Insights
Senior Brother's Insights
Oct 27, 2025 · Databases

How Does MySQL Power High‑Performance OLTP Workloads?

This article explains what OLTP (Online Transaction Processing) is, outlines its key characteristics, and details how MySQL—through ACID‑compliant transactions, the InnoDB storage engine, various indexing strategies, fast locking mechanisms, query optimization, and high‑availability features—effectively supports high‑concurrency, low‑latency transactional workloads.

Database TransactionsHigh AvailabilityIndexing
0 likes · 9 min read
How Does MySQL Power High‑Performance OLTP Workloads?
dbaplus Community
dbaplus Community
Oct 19, 2025 · Databases

How PostgreSQL 18 Made My Redis Cache Redundant (And What You Can Learn)

After disabling Redis in production and carefully testing on PostgreSQL 18, the author reduced p95 latency, simplified the system, and lowered operational overhead by replacing the cache with a covering index, a generated column, and a materialized view, while providing detailed query examples, configuration tweaks, and performance measurements.

IndexingPostgreSQLRedis
0 likes · 10 min read
How PostgreSQL 18 Made My Redis Cache Redundant (And What You Can Learn)
macrozheng
macrozheng
Oct 15, 2025 · Databases

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article examines why PostgreSQL is often a better choice than MySQL for high‑performance workloads, covering architectural differences, indexing capabilities, query optimization, data types, concurrency control, benchmark results, and migration considerations, and provides code examples to illustrate each point.

IndexingMySQLPostgreSQL
0 likes · 13 min read
Why PostgreSQL Beats MySQL in High‑Performance Scenarios
IT Services Circle
IT Services Circle
Oct 11, 2025 · Databases

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article compares PostgreSQL and MySQL across architecture, indexing, query optimization, data types, concurrency control, and real‑world benchmarks, showing why PostgreSQL generally outperforms MySQL in high‑throughput, complex‑query, and data‑intensive applications.

Data TypesDatabase PerformanceIndexing
0 likes · 12 min read
Why PostgreSQL Beats MySQL in High‑Performance Scenarios
Su San Talks Tech
Su San Talks Tech
Oct 9, 2025 · Databases

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article compares PostgreSQL and MySQL across architecture, indexing, complex query optimization, data‑type support, transaction handling, and real‑world benchmark results, showing why PostgreSQL is generally the better choice for high‑concurrency, data‑intensive applications.

Database PerformanceIndexingMySQL
0 likes · 13 min read
Why PostgreSQL Beats MySQL in High‑Performance Scenarios
Senior Brother's Insights
Senior Brother's Insights
Sep 29, 2025 · Databases

Why MySQL Uses B+ Trees: From BSTs to Efficient Indexing

This article walks through the evolution from binary search trees to balanced trees, B‑trees and finally B+ trees, explaining how MySQL's InnoDB and MyISAM storage engines implement these structures to reduce disk I/O and boost query performance.

B+TreeData StructuresDatabase Performance
0 likes · 12 min read
Why MySQL Uses B+ Trees: From BSTs to Efficient Indexing
Su San Talks Tech
Su San Talks Tech
Sep 25, 2025 · Databases

Boost MySQL Query Speed: Indexing, Subqueries vs Joins Explained

This article walks through a MySQL 5.6 scenario where a sub‑query to find students scoring 100 runs for hours, demonstrates how adding single‑column indexes cuts execution time dramatically, explores join‑based rewrites, composite indexes, left‑most prefix rules, covering indexes and sorting optimizations, and provides practical performance‑tuning tips.

IndexingJOINMySQL
0 likes · 12 min read
Boost MySQL Query Speed: Indexing, Subqueries vs Joins Explained
Architect
Architect
Sep 24, 2025 · Databases

How Indexes Can Speed Up MySQL Queries by 30,000×: A Practical Guide

This article walks through a MySQL 5.6 scenario with three tables, demonstrates why a sub‑query that scans millions of rows runs for hours, and shows step‑by‑step how adding single‑column, composite, and covering indexes, as well as rewriting the query as a join, reduces execution time from over eight hours to a few milliseconds.

DatabaseIndexingMySQL
0 likes · 12 min read
How Indexes Can Speed Up MySQL Queries by 30,000×: A Practical Guide
dbaplus Community
dbaplus Community
Sep 22, 2025 · Databases

Why MySQL Tables Shouldn’t Exceed 10 Million Rows – A Deep Dive into InnoDB Pages & B+Tree Limits

This article explains why the industry advises keeping MySQL single‑table row counts below ten million by examining InnoDB’s 16KB page structure, B+‑tree indexing mechanics, fan‑out calculations, and how page size and row size together determine the practical limits and performance cliffs of large tables.

B+TreeDatabaseDesignIndexing
0 likes · 20 min read
Why MySQL Tables Shouldn’t Exceed 10 Million Rows – A Deep Dive into InnoDB Pages & B+Tree Limits
MaGe Linux Operations
MaGe Linux Operations
Sep 7, 2025 · Databases

Master MySQL Slow Query Analysis: Proven SQL Optimization Techniques to Boost Performance

This comprehensive guide walks you through diagnosing MySQL slow queries, from identifying root causes and configuring slow‑query logs to applying advanced indexing, query‑rewriting, and monitoring techniques—complete with real‑world case studies that demonstrate how to cut query times from seconds to milliseconds.

IndexingMySQLSQL Optimization
0 likes · 28 min read
Master MySQL Slow Query Analysis: Proven SQL Optimization Techniques to Boost Performance
Su San Talks Tech
Su San Talks Tech
Sep 3, 2025 · Databases

Why Does MySQL GROUP BY Slow Down and How to Fix It

This article explains why a MySQL GROUP BY query can degrade from seconds to minutes as data grows, shows how to locate the bottlenecks with EXPLAIN and profiling tools, and provides practical indexing, query rewriting, temporary‑table tuning, batch aggregation, and distributed‑database strategies to restore performance.

GROUP BYIndexingMySQL
0 likes · 13 min read
Why Does MySQL GROUP BY Slow Down and How to Fix It
MaGe Linux Operations
MaGe Linux Operations
Aug 26, 2025 · Databases

How I Cut MySQL Query Time from 20 Seconds to 200 Milliseconds

In this detailed case study, the author walks through a real‑world MySQL slow‑query incident, analyzes execution plans, logs, and profiling data, and applies a four‑step optimization strategy—including index creation, query rewriting, covering indexes, and materialized views—to reduce execution time from 20 seconds to 200 milliseconds, achieving over 100× speedup.

IndexingMySQLSQL
0 likes · 23 min read
How I Cut MySQL Query Time from 20 Seconds to 200 Milliseconds
dbaplus Community
dbaplus Community
Aug 21, 2025 · Databases

Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques

When a massive e‑commerce order table suffers from MySQL’s deep pagination slowdown, this article dissects the root causes and presents six battle‑tested solutions—including cursor pagination, deferred joins, covering indexes, partitioning, precomputed pages, and Elasticsearch integration—to dramatically improve query performance.

IndexingMySQLdatabase optimization
0 likes · 9 min read
Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques
DeWu Technology
DeWu Technology
Jul 30, 2025 · Databases

Why Milvus Outperforms Traditional Databases: Deep Dive into Vector DB Architecture

This article explores the evolution, architecture, and operational challenges of vector databases like Milvus and Zilliz, comparing them with traditional databases, detailing indexing strategies such as HNSW and DiskANN, migration plans, performance benchmarks, and future directions for large‑scale AI‑driven search systems.

IndexingMilvusVector Database
0 likes · 26 min read
Why Milvus Outperforms Traditional Databases: Deep Dive into Vector DB Architecture
Java Tech Enthusiast
Java Tech Enthusiast
Jul 2, 2025 · Databases

Why MySQL GROUP BY Can Be Slow and How to Optimize It

This article explains why MySQL GROUP BY queries may run slowly, analyzes the execution plan showing temporary tables and filesort, and provides practical optimization techniques such as removing unnecessary sorting, adding indexes, adjusting buffer settings, and considering application‑level or materialized view solutions.

DatabasesGROUP BYIndexing
0 likes · 4 min read
Why MySQL GROUP BY Can Be Slow and How to Optimize It
php Courses
php Courses
Jul 2, 2025 · Databases

8 Proven PHP Database Query Optimization Techniques to Boost Performance

This article presents eight practical, proven techniques—such as prepared statements, proper indexing, selective column retrieval, pagination, efficient joins, query caching, batch operations, and EXPLAIN analysis—to dramatically improve the performance of database queries in PHP web applications, reducing load times and server strain.

IndexingPHPPrepared Statements
0 likes · 6 min read
8 Proven PHP Database Query Optimization Techniques to Boost Performance
Code Ape Tech Column
Code Ape Tech Column
Jun 30, 2025 · Backend Development

Mastering Software Performance: 6 Time‑Space Trade‑offs and 4 Advanced Parallel Techniques

This article explores practical performance‑optimization techniques, covering six fundamental time‑for‑space trade‑offs such as indexing, compression, caching, prefetching, peak‑shaving, and batch processing, followed by four advanced methods that boost parallelism like resource draining, horizontal scaling, sharding, and lock‑free programming.

Batch ProcessingIndexingbackend
0 likes · 22 min read
Mastering Software Performance: 6 Time‑Space Trade‑offs and 4 Advanced Parallel Techniques
IT Services Circle
IT Services Circle
Jun 20, 2025 · Databases

Why MySQL GROUP BY Can Be Slow and How to Optimize It

This article explains why MySQL GROUP BY queries may run slowly due to missing indexes, temporary tables, and filesort, and provides practical optimization techniques such as removing unnecessary sorting, adding indexes, tuning buffers, and using application‑level or materialized view solutions.

GROUP BYIndexingMySQL
0 likes · 6 min read
Why MySQL GROUP BY Can Be Slow and How to Optimize It
Architect's Must-Have
Architect's Must-Have
Jun 9, 2025 · Databases

Master MySQL Indexes: From Basics to B+Tree Optimization

This article explains what MySQL indexes are, how they work, their types—including primary, ordinary, composite, and full‑text indexes—covers B‑Tree and B+Tree structures, page organization, clustering versus non‑clustering indexes, and practical considerations for index design and performance.

B+TreeDatabaseIndexing
0 likes · 12 min read
Master MySQL Indexes: From Basics to B+Tree Optimization
Tencent Cloud Middleware
Tencent Cloud Middleware
May 28, 2025 · Backend Development

Inside RocketMQ ConsumeQueue: Design, File-Based Indexing, and RocksDB Optimization

This article provides an in‑depth technical exploration of RocketMQ 5.0's ConsumeQueue component, explaining why it is needed, its design principles, the traditional file‑based implementation, and a performance‑focused RocksDB‑based redesign, complete with code excerpts and implementation details.

ConsumeQueueDistributedSystemsIndexing
0 likes · 25 min read
Inside RocketMQ ConsumeQueue: Design, File-Based Indexing, and RocksDB Optimization
MaGe Linux Operations
MaGe Linux Operations
May 17, 2025 · Databases

Master MySQL: Full Guide to Theory, Commands & Real-World Practices

This comprehensive MySQL tutorial covers everything from core concepts and architecture to practical CRUD operations, advanced queries, indexing, transaction control, stored procedures, triggers, replication, performance tuning, backup strategies, and real-world use cases, providing a complete roadmap for developers and DBAs.

BackupDatabaseIndexing
0 likes · 25 min read
Master MySQL: Full Guide to Theory, Commands & Real-World Practices
Cognitive Technology Team
Cognitive Technology Team
May 15, 2025 · Databases

How to Solve MySQL Deep Pagination Performance Issues

This article analyzes why large OFFSET values cause severe MySQL performance degradation and presents multiple optimization techniques—including range queries, subqueries, delayed joins, covering indexes, sharding, caching, and search engine integration—along with their advantages, limitations, and practical recommendations.

IndexingMySQLSharding
0 likes · 11 min read
How to Solve MySQL Deep Pagination Performance Issues