BestHub
Sign in
Tagged articles

Indexing

666 articles · Page 2 of 7
JD Tech
JD Tech
May 13, 2025 · Databases

Unlock ClickHouse’s Lightning‑Fast Queries: Architecture, Storage, and Index Secrets

This article examines ClickHouse’s high‑performance OLAP design, covering its MPP architecture, columnar storage, vectorized execution, pre‑sorting, table engines, extensive data‑type system, sharding and replication strategies, as well as its sparse and skip‑index mechanisms that together enable ultra‑fast analytics on massive datasets.

ClickHouseData PartitioningIndexing
0 likes · 16 min read
Unlock ClickHouse’s Lightning‑Fast Queries: Architecture, Storage, and Index Secrets
DeWu Technology
DeWu Technology
May 12, 2025 · Backend Development

How DSearch Evolved: From RCU‑Based 1.0 Indexes to Async Graph‑Powered 3.0

This article provides a detailed technical walkthrough of the DSearch search engine evolution, covering the RCU‑based 1.0 index architecture, the segment‑merge enhancements in 2.0, and the async non‑blocking graph framework introduced in 3.0, together with performance benchmarks and implementation details.

Indexingasync graphbackend
0 likes · 18 min read
How DSearch Evolved: From RCU‑Based 1.0 Indexes to Async Graph‑Powered 3.0
Architect
Architect
May 9, 2025 · Databases

How We Reduced Thousands of Slow SQL Queries to Double‑Digit Levels

This article details a real‑world case study of the activity middle‑platform system’s slow‑SQL problem, explaining the definition, causes, and harmful impacts of slow queries, then outlines step‑by‑step mitigation strategies—including data cleanup, partitioning, indexing, query refactoring, and scheduling—to dramatically reduce slow‑SQL occurrences from thousands to double‑digit counts.

IndexingOptimizationSQL
0 likes · 17 min read
How We Reduced Thousands of Slow SQL Queries to Double‑Digit Levels
Architect
Architect
Apr 29, 2025 · Databases

Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration

A real‑world MySQL data‑migration case study shows how using INSERT INTO SELECT without proper indexing caused a full table scan, OOM errors, and data loss, and explains how to avoid the pitfall by adding appropriate indexes and understanding transaction locking.

Data MigrationDatabase PerformanceINSERT INTO SELECT
0 likes · 8 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration
macrozheng
macrozheng
Apr 21, 2025 · Backend Development

Boost Your App with Meilisearch: Fast, Lightweight Search Engine Tutorial

This guide introduces Meilisearch, a lightweight, fast search engine with RESTful API, covering its features, Docker installation, index and settings management, document operations, and advanced search queries, while also showcasing a real‑world SpringBoot‑Vue e‑commerce project that integrates Meilisearch for instant, accurate results.

DockerIndexingMeilisearch
0 likes · 10 min read
Boost Your App with Meilisearch: Fast, Lightweight Search Engine Tutorial
IT Xianyu
IT Xianyu
Apr 18, 2025 · Databases

Comprehensive Guide to SQL Basics, Advanced Queries, and Performance Optimization

This article provides a thorough tutorial on SQL fundamentals, including statement order, core clause rules, templates for SELECT/INSERT/UPDATE/DELETE, practical multi‑table query cases, join and subquery techniques, common pitfalls, index optimization strategies, experimental performance data, and a structured learning path for mastering database development.

IndexingJoinsQuery Optimization
0 likes · 7 min read
Comprehensive Guide to SQL Basics, Advanced Queries, and Performance Optimization
Java Tech Enthusiast
Java Tech Enthusiast
Apr 14, 2025 · Databases

SQL Optimization Steps and Common Scenarios

To improve MySQL performance, first identify slow queries via logs, then examine their EXPLAIN plans and profiling data, understand optimizer traces, and apply fixes such as proper left‑most indexing, avoiding implicit conversions, large offsets, unsuitable IN/ORDER BY patterns, range‑blocking, NOT‑IN predicates, and consider alternative storage or pagination strategies for complex or massive datasets.

IndexingQuery OptimizationSQL
0 likes · 10 min read
SQL Optimization Steps and Common Scenarios
ITPUB
ITPUB
Apr 13, 2025 · Operations

How Cursor Scaled Its AI Code Editor: Lessons from Indexing to Object Storage

Cursor, the AI‑powered code editor, grew to handle billions of document queries and over a hundred‑million model calls daily, prompting a multi‑stage infrastructure overhaul that moved from a failing YugaByte setup to PostgreSQL RDS, then to object‑storage‑backed databases, while tackling indexing, inference scaling, and cold‑start challenges.

AIDatabasesIndexing
0 likes · 11 min read
How Cursor Scaled Its AI Code Editor: Lessons from Indexing to Object Storage
MaGe Linux Operations
MaGe Linux Operations
Apr 12, 2025 · Databases

Master MySQL Remote Connections and Query Optimization: Tips & Tricks

This article explains how to create and grant MySQL users for remote access, describes client‑server communication methods such as TCP/IP, named pipes, shared memory, and Unix sockets, and provides detailed guidance on index usage, common pitfalls, and performance‑friendly techniques for query optimization and large OFFSET LIMIT handling.

IndexingQuery OptimizationRemote Connection
0 likes · 17 min read
Master MySQL Remote Connections and Query Optimization: Tips & Tricks
Sohu Tech Products
Sohu Tech Products
Apr 9, 2025 · Databases

Six Critical MySQL Index Pitfalls and How to Fix Them

This article analyzes six common MySQL query performance traps—type conversion, function usage, left‑most prefix, implicit charset conversion, left‑most match, and optimizer mis‑selection—illustrates each with real‑world SQL examples, explains why they degrade performance, and provides concrete remediation steps and verification tools.

IndexingQuery OptimizationSQL
0 likes · 5 min read
Six Critical MySQL Index Pitfalls and How to Fix Them
vivo Internet Technology
vivo Internet Technology
Apr 2, 2025 · Databases

Case Study of Slow SQL Governance in an Activity Middleware System

The case study details how an activity‑middleware platform tackled slow SQL problems by cleaning historic data, introducing sharding and Elasticsearch off‑loading, optimizing queries with proper indexes and simplified joins, and automating nightly deletions, ultimately cutting daily slow queries from thousands to double‑digit levels and boosting system stability.

Database PerformanceIndexingSQL Optimization
0 likes · 17 min read
Case Study of Slow SQL Governance in an Activity Middleware System
Architect's Tech Stack
Architect's Tech Stack
Mar 31, 2025 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article investigates MySQL's recommendation to avoid UUIDs and non‑sequential keys by benchmarking insert performance of auto‑increment, UUID, and random (snowflake) primary keys, analyzing their index structures, drawbacks, and concluding that sequential auto‑increment keys provide the best overall efficiency.

IndexingJavaauto_increment
0 likes · 9 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
Java Backend Technology
Java Backend Technology
Mar 26, 2025 · Databases

Why UUID Primary Keys Slow Down MySQL Inserts: A Performance Deep Dive

This article investigates why MySQL discourages UUID or non‑sequential Snowflake IDs as primary keys, compares auto_increment, UUID, and random‑key tables through SpringBoot‑JdbcTemplate benchmarks, analyzes their index structures, and explains the performance trade‑offs and security considerations.

IndexingSpringBootauto_increment
0 likes · 10 min read
Why UUID Primary Keys Slow Down MySQL Inserts: A Performance Deep Dive
Java Architect Essentials
Java Architect Essentials
Mar 24, 2025 · Databases

Why MySQL Discourages UUID as Primary Key: Performance Comparison with Auto‑Increment and Random Keys

This article investigates MySQL's recommendation against using UUIDs or non‑sequential keys as primary keys by creating three tables, benchmarking insert and query speeds with Spring Boot/JdbcTemplate, analyzing index structures, and discussing the trade‑offs of auto‑increment, UUID, and random long keys.

Indexingauto_incrementdatabase-design
0 likes · 11 min read
Why MySQL Discourages UUID as Primary Key: Performance Comparison with Auto‑Increment and Random Keys
Java Tech Enthusiast
Java Tech Enthusiast
Mar 13, 2025 · Databases

Performance Comparison of UUID vs Auto-Increment IDs in MySQL

Benchmarking three MySQL tables—auto_increment, UUID, and random long keys—shows that sequential auto_increment inserts are fastest, random keys are slower, and UUIDs dramatically lag due to random I/O and fragmentation, so use auto_increment for most workloads and reserve UUIDs only for required global uniqueness.

IndexingJDBCSpringBoot
0 likes · 10 min read
Performance Comparison of UUID vs Auto-Increment IDs in MySQL
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Mar 12, 2025 · Databases

Comprehensive MySQL Core Commands Tutorial

This article provides a step‑by‑step guide to essential MySQL operations, covering connection methods, database creation and deletion, user management, password changes, data manipulation, query techniques, indexing strategies, performance tips, and backup procedures, all illustrated with complete command examples.

BackupIndexingSQL
0 likes · 7 min read
Comprehensive MySQL Core Commands Tutorial
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Feb 11, 2025 · Backend Development

10 Powerful Elasticsearch DSL Tricks to Solve Real‑World Performance Pain Points

This article presents ten practical Elasticsearch performance‑tuning techniques—including query DSL, deep pagination, mapping design, high‑cardinality aggregations, nested queries, script optimization, index templates, force‑merge, bulk writes, and profiling—each illustrated with concrete scenarios, code snippets, and step‑by‑step analysis to boost cluster speed and stability.

Bulk WriteElasticsearchIndexing
0 likes · 12 min read
10 Powerful Elasticsearch DSL Tricks to Solve Real‑World Performance Pain Points
Alibaba Cloud Developer
Alibaba Cloud Developer
Jan 14, 2025 · Databases

Mastering MySQL Indexes: From Hash Tables to B+ Trees and Optimization Tips

This article explains the concept of database indexes, compares various index structures such as hash tables, ordered arrays, binary trees, B‑trees and B+‑trees, details InnoDB primary, secondary, covering and composite indexes, discusses prefix indexes and order‑by optimization, and provides practical advice and SQL examples for improving MySQL query performance.

B+TreeIndexingSQL
0 likes · 18 min read
Mastering MySQL Indexes: From Hash Tables to B+ Trees and Optimization Tips
JD Tech
JD Tech
Dec 13, 2024 · Databases

MySQL Join Algorithms and Optimization Techniques

This article explains how multi‑table joins in MySQL can become performance bottlenecks and walks through the four join algorithms—Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop—showing their execution plans, code examples, and step‑by‑step optimizations using indexes and join buffers to dramatically improve query speed.

IndexingJoin AlgorithmsSQL Optimization
0 likes · 19 min read
MySQL Join Algorithms and Optimization Techniques
php Courses
php Courses
Dec 9, 2024 · Backend Development

Implement Real-Time Search and Automatic Index Updating with PHP and Xunsearch

This article provides a step‑by‑step guide on setting up Xunsearch with PHP to achieve real‑time full‑text search and automatic index updates, covering environment preparation, server installation, search script implementation, and index‑updating routines.

Backend DevelopmentFull-text SearchIndexing
0 likes · 4 min read
Implement Real-Time Search and Automatic Index Updating with PHP and Xunsearch
JD Tech Talk
JD Tech Talk
Dec 9, 2024 · Databases

Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins

This article explores MySQL's join processing methods—Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop joins—demonstrates how to create test tables, analyze execution plans, and apply practical optimizations such as indexing and query rewriting to dramatically improve multi‑table query performance.

Database PerformanceIndexingJoin Algorithms
0 likes · 21 min read
Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins
JD Cloud Developers
JD Cloud Developers
Dec 9, 2024 · Databases

Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins

This article explains how MySQL processes multi‑table joins, compares Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop join algorithms, and demonstrates practical optimization techniques using indexes, join buffers, and query rewrites to dramatically improve performance on large datasets.

Database PerformanceIndexingJoin Algorithms
0 likes · 20 min read
Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins
IT Services Circle
IT Services Circle
Nov 27, 2024 · Databases

15 Common MySQL Pitfalls and How to Avoid Them

This article outlines fifteen typical MySQL pitfalls—including missing WHERE clauses, lack of indexes, improper NULL handling, wrong data types, deep pagination, missing EXPLAIN analysis, charset misconfiguration, SQL injection risks, transaction misuse, collation issues, overusing SELECT *, index loss, frequent schema changes, missing backups, and unarchived historical data—and provides concrete examples and best‑practice solutions to improve performance, reliability, and security.

IndexingSQLSecurity
0 likes · 13 min read
15 Common MySQL Pitfalls and How to Avoid Them
php Courses
php Courses
Nov 27, 2024 · Backend Development

Key Performance and Architectural Drawbacks of Magento 2

The article outlines twelve major performance and architectural issues in Magento 2—including a heavy core codebase, inefficient EAV database design, slow admin UI, over‑reliance on caching, poor front‑end performance, resource‑intensive cloud requirements, indexing bottlenecks, limited scalability, third‑party extension risks, testing difficulties, slow deployment, and a steep developer learning curve.

Backend DevelopmentEAVIndexing
0 likes · 6 min read
Key Performance and Architectural Drawbacks of Magento 2
Programmer XiaoFu
Programmer XiaoFu
Nov 27, 2024 · Databases

Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes

The article explains how to troubleshoot extreme CPU usage in MySQL and Java processes, detailing step‑by‑step diagnostics with top, show processlist, jstack, and practical fixes such as adding missing indexes, disabling slow logs, using caches, and correcting busy‑loop code to bring CPU consumption back to normal levels.

CPUIndexingJava
0 likes · 11 min read
Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes
dbaplus Community
dbaplus Community
Nov 24, 2024 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

This article walks through practical MySQL performance tuning methods—including pagination, join, subquery, ORDER BY, GROUP BY, and COUNT optimizations—illustrated with real‑world data volumes, step‑by‑step SQL examples, EXPLAIN analyses, index creation, and measurable query‑time improvements.

IndexingJOINORDER BY
0 likes · 14 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
Selected Java Interview Questions
Selected Java Interview Questions
Nov 18, 2024 · Databases

RediSearch Overview: Features, Benchmarks, Installation, and Command‑Line Operations

This article introduces RediSearch—a Redis module for full‑text search—detailing its features, performance comparison with Elasticsearch, index‑building and query benchmarks, installation methods (source and Docker), and comprehensive command‑line examples for creating, querying, updating, and managing indexes.

CLIFull-text SearchIndexing
0 likes · 13 min read
RediSearch Overview: Features, Benchmarks, Installation, and Command‑Line Operations
macrozheng
macrozheng
Nov 7, 2024 · Backend Development

9 Proven Techniques to Supercharge Pagination Query Performance

This article presents nine practical strategies—including adding default filters, limiting page size, reducing joins, optimizing indexes, using straight_join, archiving data, leveraging count(*), querying ClickHouse, and implementing read‑write splitting—to dramatically improve the speed and scalability of pagination APIs in MySQL‑based back‑ends.

ClickHouseDatabase PerformanceIndexing
0 likes · 11 min read
9 Proven Techniques to Supercharge Pagination Query Performance
Open Source Tech Hub
Open Source Tech Hub
Oct 31, 2024 · Big Data

How Bilibili Scaled Its Search Index with Distributed KV Storage and Spark

Bilibili transformed its search indexing pipeline by replacing a manual, low‑throughput process with a distributed KV store (Taishan) and Spark‑based construction, achieving unified data ingestion, reduced resource consumption, faster full‑ and incremental builds, and a shift from daily to hourly indexing cycles.

IndexingKV storeProtobuf
0 likes · 25 min read
How Bilibili Scaled Its Search Index with Distributed KV Storage and Spark
Efficient Ops
Efficient Ops
Oct 13, 2024 · Databases

Why Your MySQL Queries Are Slow and How to Fix Them with Indexes, ES & HBase

This article explains why MySQL queries become slow—covering index misuse, MDL locks, flush waits, large‑table bottlenecks, and read/write splitting—then shows how ElasticSearch’s inverted index and HBase’s column‑family design can complement MySQL for faster search and scalable storage.

HBaseIndexingdatabase optimization
0 likes · 20 min read
Why Your MySQL Queries Are Slow and How to Fix Them with Indexes, ES & HBase
Top Architect
Top Architect
Oct 12, 2024 · Databases

Understanding MySQL Index Structures, Execution Plans, Transaction Isolation Levels, MVCC, and Buffer Pool Mechanisms

This article provides a comprehensive technical guide on MySQL internals, covering the underlying data structures of indexes (B‑tree, B+‑tree, hash), how execution plans are generated and interpreted, the four transaction isolation levels, MVCC implementation, and the InnoDB buffer‑pool architecture.

IndexingMVCCSQL Optimization
0 likes · 22 min read
Understanding MySQL Index Structures, Execution Plans, Transaction Isolation Levels, MVCC, and Buffer Pool Mechanisms
Su San Talks Tech
Su San Talks Tech
Oct 12, 2024 · Databases

Master MySQL: Essential Database Design and Performance Guidelines

This article compiles comprehensive MySQL best‑practice guidelines covering charset selection, storage engine choice, naming conventions, field design, index optimization, SQL development tips, and operational procedures to improve performance, maintainability, and reliability of database systems.

IndexingSQL Best Practicesdata modeling
0 likes · 23 min read
Master MySQL: Essential Database Design and Performance Guidelines
Architecture Digest
Architecture Digest
Oct 11, 2024 · Backend Development

Common Interface Performance Optimization Techniques

This article outlines a series of backend interface performance optimization strategies—including batch processing, asynchronous execution, caching, preprocessing, pooling, parallelization, indexing, transaction management, program structure refactoring, deep pagination, SQL tuning, and lock granularity—to help developers reduce latency and improve system efficiency.

AsynchronousBatch ProcessingIndexing
0 likes · 9 min read
Common Interface Performance Optimization Techniques
Programmer1970
Programmer1970
Oct 2, 2024 · Databases

A Deep Dive into MongoDB’s Technical Architecture

This article outlines MongoDB’s core features, its layered technical architecture—including storage, data model, query language, indexing, replication, sharding, and transactions—and explains the three cluster deployment modes with detailed roles and request flow for sharded clusters.

Database ArchitectureIndexingMongoDB
0 likes · 10 min read
A Deep Dive into MongoDB’s Technical Architecture
Architect
Architect
Sep 24, 2024 · Industry Insights

How Bilibili Re‑engineered Its Search Indexing Pipeline for Hour‑Level Turnaround

This article details Bilibili's transformation of its search offline indexing architecture—from a manual, low‑throughput MySQL‑centric process to a distributed, KV‑based, protobuf‑driven pipeline that leverages Taishan storage and Spark, cutting build cycles from days to hours while solving performance, consistency, and maintenance challenges.

IndexingProtobufSpark
0 likes · 24 min read
How Bilibili Re‑engineered Its Search Indexing Pipeline for Hour‑Level Turnaround
HelloTech
HelloTech
Sep 20, 2024 · Big Data

Optimizing Elasticsearch Mapping to Reduce High CPU Usage: Challenges, Solutions, and Results

By refactoring the station‑profile index to eliminate over‑indexed and mis‑typed fields—cutting complex types from 282 to 74 and keywords from 67 to 59—the team lowered CPU peaks from 60 % to 50 %, reduced average CPU to 20 %, cut query latency to 150 ms, accelerated Flink sync to 10 minutes, and decommissioned two nodes, achieving substantial performance gains and cost savings.

CPU performanceElasticsearchIndexing
0 likes · 10 min read
Optimizing Elasticsearch Mapping to Reduce High CPU Usage: Challenges, Solutions, and Results
Code Farming
Code Farming
Sep 15, 2024 · Backend Development

Understanding Elasticsearch: Core Principles and Architecture

This article explains Elasticsearch’s overall structure, the underlying Lucene index layout, the indexing and search processing flow, and how built‑in analyzers work, illustrating each concept with diagrams, token examples, and query scenarios.

AnalyzersElasticsearchFull-text Search
0 likes · 10 min read
Understanding Elasticsearch: Core Principles and Architecture
Sohu Tech Products
Sohu Tech Products
Sep 11, 2024 · Big Data

Tencent Real-time Lakehouse Intelligent Optimization Practice

Tencent’s real‑time lakehouse combines Spark, Flink, StarRocks and Presto compute layers with Iceberg‑based management and HDFS/COS storage, and its Intelligent Optimize Service—comprising Compaction, Expiration, Cleaning, Clustering, Index and Auto‑Engine modules—automatically reduces merge time, improves query performance, enables secondary indexing, and dynamically routes hot partitions, while future plans target cold/hot separation, materialized view acceleration, and AI‑driven optimizations.

ClusteringIndexingLakehouse
0 likes · 12 min read
Tencent Real-time Lakehouse Intelligent Optimization Practice
Efficient Ops
Efficient Ops
Sep 1, 2024 · Backend Development

Master Elasticsearch: From Basics to Advanced Performance Tuning

This article walks through Elasticsearch’s licensing history, version selection, installation, cluster health monitoring, shard routing, storage mechanisms, refresh and translog processes, segment merging, and practical performance optimizations such as disk choices, index settings, and JVM tuning.

ClusterElasticsearchIndexing
0 likes · 21 min read
Master Elasticsearch: From Basics to Advanced Performance Tuning
AI Large Model Application Practice
AI Large Model Application Practice
Aug 29, 2024 · Artificial Intelligence

8 Essential Indexing Strategies to Boost Enterprise RAG Performance

This article presents eight practical optimization recommendations for the indexing stage of enterprise‑level Retrieval‑Augmented Generation (RAG) applications, covering chunk creation, abbreviation handling, multimodal document processing, semantic enrichment, metadata usage, alternative index types, and embedding model selection.

ChunkingIndexingMetadata
0 likes · 15 min read
8 Essential Indexing Strategies to Boost Enterprise RAG Performance
dbaplus Community
dbaplus Community
Aug 18, 2024 · Databases

Master MySQL Performance: Key Query Optimizations, Index Tips & Config Tweaks

This guide covers practical MySQL performance improvements, including choosing proper data types, avoiding SELECT *, optimizing joins and UNION usage, batch inserts, query cache settings, configuration parameters like innodb_buffer_pool_size, and comprehensive index strategies to accelerate queries and reduce resource consumption.

IndexingSQL Optimizationdatabase configuration
0 likes · 18 min read
Master MySQL Performance: Key Query Optimizations, Index Tips & Config Tweaks
Java Architect Essentials
Java Architect Essentials
Aug 9, 2024 · Databases

Comprehensive MySQL Query and Configuration Optimization Guide

This article provides a thorough guide to MySQL performance optimization, covering general query improvements, proper data types, index usage, configuration parameter tuning, avoiding common pitfalls, and detailed EXPLAIN analysis, with concrete SQL examples and practical recommendations for developers and DBAs.

IndexingQuery Optimizationdatabase configuration
0 likes · 16 min read
Comprehensive MySQL Query and Configuration Optimization Guide
Python Programming Learning Circle
Python Programming Learning Circle
Aug 7, 2024 · Fundamentals

Python String Indexing and Manipulation Exercises

This article provides a comprehensive set of ten beginner-friendly Python string exercises covering indexing, slicing, step slicing, searching, replacing, concatenation, formatting, membership testing, length calculation, case conversion, and advanced topics like regular expressions, splitting, padding, stripping, digit checking, and practical text‑analysis examples.

IndexingPythonSlicing
0 likes · 13 min read
Python String Indexing and Manipulation Exercises
DataFunSummit
DataFunSummit
Aug 4, 2024 · Big Data

Apache Hudi from Zero to One: Comprehensive Guide to Write Indexing (Part 4)

This article explains Apache Hudi’s write‑side indexing, detailing the indexing API, various index types—including simple, Bloom, bucket, HBase, and record‑level indexes—and their mechanisms, helping readers understand how Hudi validates record existence and optimizes updates and deletions.

Apache HudiIndexingbig data
0 likes · 9 min read
Apache Hudi from Zero to One: Comprehensive Guide to Write Indexing (Part 4)
ITPUB
ITPUB
Jul 27, 2024 · Databases

How to Diagnose and Optimize Extremely Slow MySQL Queries

This article explains what constitutes a slow SQL query, how to detect and analyze it using MySQL tools, and provides practical optimization steps—including indexing, business logic review, caching, scheduling, and partitioning—to dramatically reduce execution time.

IndexingOptimizationSQL
0 likes · 7 min read
How to Diagnose and Optimize Extremely Slow MySQL Queries
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 26, 2024 · Databases

Apache Doris Architecture and Common Q&A: Read/Write Flow, Replication Consistency, Storage, and High Availability

This article provides a comprehensive overview of Apache Doris, explaining its frontend and backend nodes, storage structures such as tablets, rowsets, and segments, replication mechanisms, partitioning versus bucketing, indexing types, compaction processes, and high‑availability strategies through a detailed Q&A format.

Apache DorisDatabase ArchitectureIndexing
0 likes · 22 min read
Apache Doris Architecture and Common Q&A: Read/Write Flow, Replication Consistency, Storage, and High Availability
Java Interview Crash Guide
Java Interview Crash Guide
Jul 24, 2024 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

Learn eight practical MySQL optimization strategies—including smarter LIMIT usage, avoiding implicit type conversion, rewriting subqueries with JOINs, handling mixed sorting, eliminating costly EXISTS clauses, pushing conditions, pre‑filtering data, and leveraging intermediate result sets—to dramatically reduce query execution time from seconds to milliseconds.

IndexingLIMITQuery Optimization
0 likes · 15 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
Java Tech Enthusiast
Java Tech Enthusiast
Jul 21, 2024 · Backend Development

Interface Performance Optimization Techniques for Backend Development

The article outlines practical backend interface performance optimizations—including proper indexing, SQL tuning, parallel remote calls, batch queries, asynchronous processing, scoped transactions, fine-grained locking, pagination batching, multi-level caching, sharding, and monitoring tools—to dramatically reduce latency and improve throughput.

Distributed LockIndexingSQL Optimization
0 likes · 25 min read
Interface Performance Optimization Techniques for Backend Development
The Dominant Programmer
The Dominant Programmer
Jul 19, 2024 · Databases

Writing High‑Quality SQL: Practical MySQL Optimization Tips

To avoid common MySQL pitfalls, the article compiles practical SQL writing guidelines—selecting specific columns instead of *, using LIMIT 1, avoiding OR in WHERE, optimizing pagination, handling LIKE patterns, minimizing redundant indexes, preferring INNER JOIN, and leveraging covering indexes and EXPLAIN for efficient query execution.

IndexingSQL Optimizationbest practices
0 likes · 18 min read
Writing High‑Quality SQL: Practical MySQL Optimization Tips
AntData
AntData
Jul 12, 2024 · Databases

Recent Advances in Vector Databases Presented at SIGMOD 2024

This article reviews the latest vector database research showcased at SIGMOD 2024, covering system designs such as Starling, Vexless, RaBitQ, and ACORN, and discusses current academic hotspots including query processing, index structures, optimization techniques, and hardware acceleration for large‑scale similarity search.

AIIndexingRetrieval
0 likes · 20 min read
Recent Advances in Vector Databases Presented at SIGMOD 2024
dbaplus Community
dbaplus Community
Jul 10, 2024 · Databases

Why ClickHouse Dominates OLAP Performance: An In‑Depth Architecture Guide

This article explains ClickHouse’s columnar, MPP‑based design, block compression, LSM pre‑sorting, sparse and skip‑list indexing, and vectorized execution, while also discussing its high‑frequency write challenges, concurrency limits, and production‑grade issues such as Zookeeper load and resource management.

ClickHouseColumnar DatabaseIndexing
0 likes · 11 min read
Why ClickHouse Dominates OLAP Performance: An In‑Depth Architecture Guide
Architect's Alchemy Furnace
Architect's Alchemy Furnace
Jul 9, 2024 · Databases

Why Vector Databases Are the Future Backbone of AI Applications

This article explains how vector databases store and query high‑dimensional embeddings, compares them with standalone vector indexes, outlines common embedding types and indexing algorithms, and discusses performance, monitoring, security, and API considerations for building robust AI‑driven systems.

AIANN searchIndexing
0 likes · 22 min read
Why Vector Databases Are the Future Backbone of AI Applications
System Architect Go
System Architect Go
Jul 9, 2024 · Databases

Using Redis as a Vector Database with Go: Index Creation, Data Insertion, and Vector Search

This article explains how to leverage Redis Stack modules such as RedisJSON, RediSearch, and RedisTimeSeries to store, index, and query high‑dimensional vectors for image‑search services, providing Go code examples for index creation, bulk insertion, memory inspection, and K‑Nearest‑Neighbour vector searches with optional filtering.

Indexingft-searchgo
0 likes · 11 min read
Using Redis as a Vector Database with Go: Index Creation, Data Insertion, and Vector Search
php Courses
php Courses
Jul 1, 2024 · Backend Development

Implement Real-Time Search and Automatic Index Updating with PHP and Xunsearch

This article demonstrates how to set up Xunsearch, a C++-based full-text search engine, and integrate it with PHP to achieve real-time search capabilities and automatically update the index, covering environment preparation, installation, sample code for searching, and index maintenance.

Backend DevelopmentFull-text SearchIndexing
0 likes · 4 min read
Implement Real-Time Search and Automatic Index Updating with PHP and Xunsearch
php Courses
php Courses
Jun 20, 2024 · Backend Development

Integrating Xunsearch with PHP for Fast and Accurate Search

This article explains how to install Xunsearch, create indexes, and implement search functionality using PHP, providing step‑by‑step instructions and sample code to enhance search speed and accuracy for developers building web applications.

Backend DevelopmentFull‑text SearchIndexing
0 likes · 4 min read
Integrating Xunsearch with PHP for Fast and Accurate Search
Top Architect
Top Architect
Jun 13, 2024 · Databases

Why MySQL Discourages UUIDs and Random IDs: Performance Comparison with Auto‑Increment Primary Keys

This article analyzes MySQL's recommendation to avoid UUID or non‑sequential random primary keys by benchmarking insert performance across three tables—auto_increment, UUID, and random key—explaining the underlying index structures, observed speed differences, and the trade‑offs of each approach.

Indexingauto_incrementdatabase-design
0 likes · 12 min read
Why MySQL Discourages UUIDs and Random IDs: Performance Comparison with Auto‑Increment Primary Keys
Programmer XiaoFu
Programmer XiaoFu
Jun 4, 2024 · Operations

How to Tackle a 900% CPU Spike in MySQL and Java Processes

The article walks through real interview scenarios where MySQL or Java processes consume 900% CPU, detailing step‑by‑step diagnosis with top, processlist, jstack, and concrete remediation such as adding indexes, using caches, fixing busy loops, and tuning memory.

CPUGCIndexing
0 likes · 12 min read
How to Tackle a 900% CPU Spike in MySQL and Java Processes
Java Backend Technology
Java Backend Technology
Jun 3, 2024 · Databases

How to Efficiently Query Multi‑Business Sales Data with Row‑Comparison in MySQL

This article explores how to retrieve sales statistics for multiple business units and their associated products in MySQL, compares loop‑based, OR‑concatenated, mixed‑filter, and SQL‑92 row‑comparison techniques, and explains why the row‑comparison method was ultimately chosen for its performance and compliance with development constraints.

Dynamic SQLIndexingRow Comparison
0 likes · 8 min read
How to Efficiently Query Multi‑Business Sales Data with Row‑Comparison in MySQL
Selected Java Interview Questions
Selected Java Interview Questions
May 23, 2024 · Databases

MySQL Table Design Best Practices and Common Pitfalls

This article presents a comprehensive guide to MySQL table design, covering naming conventions, appropriate data types, primary key strategies, field length choices, logical deletion, common fields, indexing rules, normalization trade‑offs, storage engine selection, time type recommendations, and SQL optimization tips.

Data TypesIndexingSQL
0 likes · 17 min read
MySQL Table Design Best Practices and Common Pitfalls
Test Development Learning Exchange
Test Development Learning Exchange
May 20, 2024 · Fundamentals

Understanding Python List Indexing and Slicing

This article explains Python's list data structure, covering forward and negative indexing as well as slice operations, and provides multiple code examples demonstrating element access, sub‑list extraction, list copying, reversal, and stepwise selection.

IndexingPythonSlicing
0 likes · 4 min read
Understanding Python List Indexing and Slicing
FunTester
FunTester
May 19, 2024 · Databases

Essential Database Testing Checklist: From CRUD to Performance Optimization

This guide outlines comprehensive database testing practices, covering relational and non‑relational types, CRUD validation, index and view checks, empty‑database scenarios, data integrity, design principles, stress testing, and detailed SQL optimization techniques with concrete examples and code snippets.

Design GuidelinesIndexingPerformance Testing
0 likes · 12 min read
Essential Database Testing Checklist: From CRUD to Performance Optimization
Liangxu Linux
Liangxu Linux
May 19, 2024 · Databases

Master MySQL Performance: Proven SQL, Index, and Hardware Optimization Techniques

This guide presents comprehensive MySQL performance‑tuning methods, covering SQL pagination tricks, proper index creation and usage, join and UNION optimizations, slow‑query logging, schema design choices, and hardware recommendations to dramatically improve query speed and resource efficiency.

Indexingdatabase-designhardware optimization
0 likes · 16 min read
Master MySQL Performance: Proven SQL, Index, and Hardware Optimization Techniques
Architect
Architect
May 17, 2024 · Databases

Why ‘INSERT INTO SELECT’ Can Crash Your MySQL Migration and How to Fix It

A large‑scale MySQL table migration using INSERT INTO SELECT caused hidden full‑table scans and lock contention, leading to data loss and a costly OOM incident, but adding the proper index and understanding transaction isolation prevented the failure.

Data MigrationDatabase PerformanceINSERT INTO SELECT
0 likes · 8 min read
Why ‘INSERT INTO SELECT’ Can Crash Your MySQL Migration and How to Fix It
DataFunTalk
DataFunTalk
May 9, 2024 · Databases

ByteHouse Vector Search Technical Guide: Architecture, Design, and Performance Optimizations

This guide explains ByteHouse’s high‑performance vector search capabilities, covering the background of vector retrieval for LLMs, the limitations of its existing skip‑index architecture, the new vector‑index design with HNSW and IVF, query‑time optimizations, performance benchmarks against Milvus, and future development plans.

ByteHouseIndexingLLM
0 likes · 8 min read
ByteHouse Vector Search Technical Guide: Architecture, Design, and Performance Optimizations
Java Captain
Java Captain
May 8, 2024 · Databases

Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration

A real‑world MySQL case study shows how using INSERT INTO SELECT for large‑scale data migration without proper indexing caused full‑table scans, lock contention, and data loss, highlighting the need for careful query planning and performance testing.

Data MigrationINSERT INTO SELECTIndexing
0 likes · 6 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration
Lobster Programming
Lobster Programming
Apr 28, 2024 · Databases

How to Solve MySQL Deep Pagination: Causes and 6 Effective Optimization Strategies

Deep pagination in MySQL becomes a performance bottleneck when tables reach millions of rows, causing excessive row scans and costly index lookups; this article explains its root causes and presents six practical optimization techniques—including keyset pagination, delayed joins, covering indexes, data partitioning, and external search engines—to dramatically improve query speed.

Covering IndexDeep PaginationIndexing
0 likes · 7 min read
How to Solve MySQL Deep Pagination: Causes and 6 Effective Optimization Strategies
Sanyou's Java Diary
Sanyou's Java Diary
Apr 15, 2024 · Databases

30 Proven SQL Optimization Tips to Boost Query Performance

This article presents thirty practical SQL optimization techniques, ranging from avoiding SELECT * and using LIMIT 1 to proper indexing, join strategies, and query rewriting, each illustrated with code examples and clear explanations to help developers write faster, more efficient database queries.

IndexingQuery TuningSQL
0 likes · 28 min read
30 Proven SQL Optimization Tips to Boost Query Performance
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 8, 2024 · Databases

How I Rescued a MySQL Table After Massive Bad Data Insertion

When a user reported errors, I discovered a MySQL table flooded with millions of bad rows from a new group, causing slow queries and crashes; I detail the step‑by‑step investigation, failed attempts with DELETE and lock‑free changes, and the final successful rebuild using temporary tables, DROP, TRUNCATE, and index reconstruction.

DDLIndexingSQL
0 likes · 13 min read
How I Rescued a MySQL Table After Massive Bad Data Insertion
Liangxu Linux
Liangxu Linux
Apr 7, 2024 · Databases

8 Proven MySQL Query Optimizations to Slash Execution Time

This article explains common MySQL performance pitfalls such as large‑offset pagination, implicit type conversion, inefficient UPDATE/DELETE joins, mixed ordering, EXISTS subqueries, predicate push‑down, early data reduction, and intermediate result set push‑down, and provides concrete rewrites that turn multi‑second queries into millisecond‑level executions.

CTEIndexingJoins
0 likes · 13 min read
8 Proven MySQL Query Optimizations to Slash Execution Time
Su San Talks Tech
Su San Talks Tech
Apr 2, 2024 · Databases

18 Essential Tips for Designing Robust Database Tables

This article presents 18 practical guidelines for backend developers on naming conventions, field types, lengths, primary keys, indexes, storage engines, null constraints, foreign keys, character sets, collations, large fields, redundant fields, and comments to help create efficient, maintainable MySQL tables.

IndexingSQL Best Practicesdatabase-design
0 likes · 22 min read
18 Essential Tips for Designing Robust Database Tables
Architecture & Thinking
Architecture & Thinking
Mar 19, 2024 · Databases

Why MySQL Indexes Fail: 9 Common Pitfalls and How to Fix Them

This article enumerates the most frequent situations that cause MySQL indexes to become ineffective—such as violating the left‑most rule, using functions or expressions on indexed columns, type conversions, improper LIKE patterns, OR/IN/NOT IN usage, and inequality operators—and demonstrates how to reproduce and verify each case with sample data and SQL scripts.

IndexingSQLdatabase optimization
0 likes · 21 min read
Why MySQL Indexes Fail: 9 Common Pitfalls and How to Fix Them
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 4, 2024 · Big Data

Elasticsearch Deep Dive: Features, Mapping & Zero‑Downtime Reindexing

This article provides a comprehensive overview of Elasticsearch, covering its distributed architecture, key features such as JSON RESTful APIs and multi‑tenant support, core functionalities like full‑text search and aggregations, comparisons with Solr, advanced mapping techniques, various query DSLs, suggestion mechanisms, and practical zero‑downtime reindexing strategies.

AggregationElasticsearchIndexing
0 likes · 13 min read
Elasticsearch Deep Dive: Features, Mapping & Zero‑Downtime Reindexing
Java Captain
Java Captain
Feb 16, 2024 · Databases

Key MySQL Concepts and Best Practices

This article summarizes essential MySQL concepts—including basic terminology, data types, SQL commands, indexes, views, storage engines, backup methods, and performance tuning techniques—to help developers understand and effectively apply this powerful open‑source relational database in real‑world projects.

BackupIndexingStorageEngine
0 likes · 4 min read
Key MySQL Concepts and Best Practices
dbaplus Community
dbaplus Community
Feb 5, 2024 · Databases

Inside InnoDB: How MySQL Stores Data, Row Formats, Pages, and Indexes

This article explains MySQL's InnoDB storage engine, covering where data files are kept, the different row formats (compact, redundant, dynamic, compressed), the internal 16 KB page layout, record header fields, overflow handling, and how B‑Tree indexes (clustered and secondary) are built and accessed.

B+TreeData PageDatabase Storage
0 likes · 22 min read
Inside InnoDB: How MySQL Stores Data, Row Formats, Pages, and Indexes
Java Captain
Java Captain
Feb 1, 2024 · Databases

Best Practices for MySQL Table Design

This article outlines ten essential MySQL table design best practices, covering requirement analysis, data type selection, normalization, indexing, keys, character sets, storage engines, partitioning, backup, and performance monitoring to improve scalability, maintainability, and efficiency.

IndexingStorage Enginebest practices
0 likes · 5 min read
Best Practices for MySQL Table Design
JD Cloud Developers
JD Cloud Developers
Jan 17, 2024 · Databases

How to Efficiently Scan Billions of Rows in MySQL: Pagination Strategies

This article examines the challenges of querying massive follower lists stored in MySQL, compares limit‑based pagination with tag‑record and range‑limit methods, and offers practical indexing and query‑optimization recommendations for handling tables containing hundreds of millions of rows.

IndexingLarge Datapagination
0 likes · 12 min read
How to Efficiently Scan Billions of Rows in MySQL: Pagination Strategies
dbaplus Community
dbaplus Community
Dec 24, 2023 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

When a system’s data grows, MySQL queries can become slow and cause latency; this article presents practical optimization strategies—including query tuning, pagination, join improvements, subquery replacement, order‑by and group‑by enhancements, and count() efficiency—illustrated with sample tables, code snippets, and performance screenshots.

GROUP BYIndexingJOIN
0 likes · 13 min read
Boost MySQL Performance: Proven SQL Optimization Techniques