BestHub
Sign in
Tagged articles
640 articles
Page 2 of 7
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+TreeDatabase OptimizationSQL
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.

DatabaseJoin AlgorithmsPerformance tuning
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 SearchPHP
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 PerformanceJoin AlgorithmsSQL optimization
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 PerformanceJoin AlgorithmsSQL optimization
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.

Database OptimizationSQLTransactions
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 DevelopmentCachingEAV
0 likes · 6 min read
Key Performance and Architectural Drawbacks of Magento 2
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.

JoinOrder ByPerformance tuning
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 SearchRediSearch
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 PerformanceSQL optimization
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.

Big DataKV 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.

Database OptimizationHBaseindexing
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.

MVCCSQL optimizationbuffer pool
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.

Performance OptimizationSQL 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 ProcessingCaching
0 likes · 9 min read
Common Interface Performance Optimization Techniques
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.

Big DataDistributed SystemsProtobuf
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 performanceElasticsearchMapping Optimization
0 likes · 10 min read
Optimizing Elasticsearch Mapping to Reduce High CPU Usage: Challenges, Solutions, and Results
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.

Big DataLakehousePyIceberg
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.

ClusterElasticsearchPerformance
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.

ChunkingMultimodalRAG
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.

Database ConfigurationPerformance tuningSQL optimization
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.

Database ConfigurationPerformance tuningindexing
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.

PythonSlicingString Manipulation
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 HudiBig Datadata lake
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.

DatabaseOptimizationPerformance
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 DorisBig DataDatabase Architecture
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.

LIMITSQL performanceWITH clause
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.

CachingSQL optimizationSharding
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.

Best PracticesDatabaseSQL optimization
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.

AISIGMOD 2024Vector Database
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 DatabaseLSM
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.

GoJSONft-search
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 SearchPHP
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 SearchPHP
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.

Database DesignPerformanceauto_increment
0 likes · 12 min read
Why MySQL Discourages UUIDs and Random IDs: Performance Comparison with Auto‑Increment Primary Keys
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 SQLRow ComparisonSQL
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 TypesSQLindexing
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.

ListPythonSlicing
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 GuidelinesSQL optimizationViews
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.

Database Designhardware optimizationindexing
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.

ByteHouseLLMVector Database
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 MigrationDatabaseINSERT INTO SELECT
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.

Keyset Paginationcovering indexdeep pagination
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.

Database OptimizationPerformanceQuery Tuning
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.

DDLDatabaseSQL
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.

CTEJoinsindexing
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.

Database DesignSQL Best Practicesindexing
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.

Database OptimizationPerformanceSQL
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.

DSLElasticsearchSearch
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.

DatabasePerformanceStorageEngine
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.

Best PracticesDatabase DesignStorage Engine
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.

Large Dataindexingpagination
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 BYJoinOrder By
0 likes · 13 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
DeWu Technology
DeWu Technology
Dec 18, 2023 · Databases

Elasticsearch Best Practices: Query, Index, and Performance Optimizations

The guide outlines production‑ready Elasticsearch best practices, covering query tuning such as using shard request cache, filter context, size‑0 aggregations and composite aggregations; write strategies like auto‑generated IDs, bulk API sizing and refresh handling; optimal shard counts, explicit mappings with disabled unnecessary features, and general advice to use explicit index names and stored scripts.

CachingElasticsearchPerformance
0 likes · 22 min read
Elasticsearch Best Practices: Query, Index, and Performance Optimizations
AntTech
AntTech
Dec 15, 2023 · Databases

CStore: A Native Graph Storage Engine for Large-Scale Graph Analysis

CStore is a Rust‑implemented native graph storage engine designed for large‑scale graph analysis, supporting petabyte‑level data, offering array‑plus‑linked‑list storage, multi‑level indexing, efficient compaction, and providing detailed build instructions and future roadmap for open‑source development.

CStoreLSM‑TreeRust
0 likes · 12 min read
CStore: A Native Graph Storage Engine for Large-Scale Graph Analysis
MaGe Linux Operations
MaGe Linux Operations
Nov 28, 2023 · Databases

When to Use Synonyms in Elasticsearch: Index-Time vs Search-Time

This article explains how Elasticsearch tokenizes text, why small spelling errors or plural forms can miss matches, and how synonyms improve search recall, comparing the trade‑offs of applying synonyms during indexing versus at query time, with practical code examples and tips for managing large synonym lists.

AnalysisElasticsearchSearch
0 likes · 7 min read
When to Use Synonyms in Elasticsearch: Index-Time vs Search-Time
Architect's Guide
Architect's Guide
Nov 22, 2023 · Backend Development

Performance Optimization Techniques: Indexing, Caching, Compression, Prefetching, Throttling, and Batch Processing

This article explains how software performance can be improved by balancing time and space trade‑offs through six fundamental techniques—indexing, compression, caching, prefetching, peak‑valley smoothing, and batch processing—and then explores four advanced, parallelism‑focused methods for large‑scale systems.

batch-processingcompressionindexing
0 likes · 35 min read
Performance Optimization Techniques: Indexing, Caching, Compression, Prefetching, Throttling, and Batch Processing
Java High-Performance Architecture
Java High-Performance Architecture
Nov 13, 2023 · Databases

Master MySQL Performance: Deep Dive into Indexes, Explain Plans & Optimization

This comprehensive guide explores MySQL’s architecture, explains how queries are parsed and executed, and provides detailed techniques for optimizing SQL performance through effective indexing, understanding EXPLAIN output, and avoiding common pitfalls that cause index misuse and slow query execution.

Database PerformanceExplain PlanSQL optimization
0 likes · 37 min read
Master MySQL Performance: Deep Dive into Indexes, Explain Plans & Optimization
HomeTech
HomeTech
Nov 3, 2023 · Backend Development

Architecture and Indexing Mechanism of the Car Smart Investment Advertising System

This article details the business workflow, system architecture, logical index structures, creation, modification, and search processes of the Car Smart Investment advertising index, and evaluates its performance, demonstrating how billions of ad records are efficiently retrieved within milliseconds.

Advertisingindexingreal-time
0 likes · 11 min read
Architecture and Indexing Mechanism of the Car Smart Investment Advertising System
Laravel Tech Community
Laravel Tech Community
Nov 2, 2023 · Databases

MyISAM Related Options and Configuration Guidelines

This article explains the purpose, recommended settings, and tuning tips for MyISAM‑related MySQL variables such as key_buffer_size, read_buffer_size, read_rnd_buffer_size, bulk_insert_buffer_size, myisam_sort_buffer_size, myisam_max_sort_file_size, myisam_repair_threads, and myisam_recover, helping DBAs optimize indexing and query performance.

BuffersMyISAMPerformance
0 likes · 4 min read
MyISAM Related Options and Configuration Guidelines
ITPUB
ITPUB
Oct 30, 2023 · Databases

Why MySQL Queries Slow Down and How to Speed Them Up

This article explores common reasons MySQL queries become sluggish—beyond missing indexes—including connection limits, insufficient InnoDB buffer pool size, and query cache issues, and provides practical steps such as profiling, using FORCE INDEX, adjusting max_connections, enlarging the buffer pool, and tuning connection pools to improve performance.

Connection PoolProfilingindexing
0 likes · 16 min read
Why MySQL Queries Slow Down and How to Speed Them Up
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 25, 2023 · Databases

Understanding and Optimizing Indexes in OceanBase

This article explains the concepts of local and global indexes in OceanBase, demonstrates how to create tables and indexes, compares six practical scenarios—including no index, local index, partitioned queries, unique and global indexes—and provides performance metrics to guide database optimization.

Database OptimizationLocal IndexOceanBase
0 likes · 8 min read
Understanding and Optimizing Indexes in OceanBase
php Courses
php Courses
Oct 17, 2023 · Databases

Choosing and Optimizing Indexes in PHP and MySQL

This article explains the fundamentals and types of MySQL indexes, provides guidelines for selecting appropriate indexes based on query frequency, uniqueness and complexity, and presents PHP code examples for adding and using indexes, along with optimization strategies such as proper schema design, data types, and index maintenance.

Database OptimizationPHPbackend
0 likes · 5 min read
Choosing and Optimizing Indexes in PHP and MySQL
ITPUB
ITPUB
Oct 9, 2023 · Databases

Boost MySQL Performance on Large Tables: Proven Strategies and Tools

This article examines why MySQL can still handle massive tables and presents practical techniques—including proper primary keys, eliminating redundant indexes, choosing optimal data types, compression, archiving, partitioning, sharding, query optimization, and safe schema changes—to keep large‑table performance high.

Partitioningcompressionindexing
0 likes · 16 min read
Boost MySQL Performance on Large Tables: Proven Strategies and Tools
Big Data Technology & Architecture
Big Data Technology & Architecture
Oct 7, 2023 · Big Data

Comprehensive Guide to OLAP Optimization and ClickHouse Performance Tuning

This article explains how to optimize OLAP workloads by balancing normalization and denormalization, applying data sharding, replication, indexing, partitioning, materialized views, columnar storage, compression, and lifecycle management, and provides practical ClickHouse SQL examples for index creation, partitioning, and query plan analysis.

ClickHouseOLAPPartitioning
0 likes · 15 min read
Comprehensive Guide to OLAP Optimization and ClickHouse Performance Tuning
Liangxu Linux
Liangxu Linux
Oct 2, 2023 · Databases

Essential MySQL Optimization Tips: From EXPLAIN to Index Strategies

This guide presents a comprehensive set of MySQL performance‑tuning techniques—including proper use of EXPLAIN, limiting IN lists, selecting specific columns, avoiding costly ORDER BY RAND(), choosing UNION ALL over UNION, distinguishing IN from EXISTS, employing full‑text indexes, respecting left‑most prefix rules, and leveraging FORCE INDEX or STRAIGHT_JOIN—to help developers write faster, more efficient queries.

OptimizationSQLindexing
0 likes · 12 min read
Essential MySQL Optimization Tips: From EXPLAIN to Index Strategies
21CTO
21CTO
Sep 28, 2023 · Databases

8 Common Database Design Mistakes and How to Fix Them

This article outlines eight frequent database design pitfalls—ignoring data purpose, poor normalization, redundancy, weak referential integrity, underusing engine features, composite primary keys, bad indexing, and confusing naming conventions—and provides practical guidance on how to avoid or correct each issue.

Best Practicesindexingnormalization
0 likes · 10 min read
8 Common Database Design Mistakes and How to Fix Them
DataFunSummit
DataFunSummit
Sep 25, 2023 · Big Data

Trino in Bilibili Lakehouse: Compute Engine, Stability, and Containerization Practices

This article presents Bilibili's practical implementation of Trino within a lakehouse architecture, focusing on the compute engine placement, stability enhancements, and containerized deployment, while detailing indexing strategies, pre‑computation techniques, Iceberg metadata optimizations, and performance gains for large‑scale analytical queries.

ContainerizationIcebergLakehouse
0 likes · 14 min read
Trino in Bilibili Lakehouse: Compute Engine, Stability, and Containerization Practices
JD Retail Technology
JD Retail Technology
Sep 13, 2023 · Databases

Optimizing Pagination Queries for Billion‑Row MySQL Tables

The article analyzes the performance problems of deep pagination on massive MySQL tables storing billions of fan records and presents three progressive solutions—simple LIMIT, tag‑record (maxId) pagination, and range‑limited pagination with async and offline minId caching—along with general indexing best‑practices for high‑throughput queries.

Large Dataindexingmysql
0 likes · 10 min read
Optimizing Pagination Queries for Billion‑Row MySQL Tables
Laravel Tech Community
Laravel Tech Community
Aug 28, 2023 · Databases

Common MySQL Performance Issues and Their Optimization Techniques

This article examines frequent MySQL performance problems such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, and intermediate result handling, and provides concrete SQL rewrites and execution‑plan analyses to dramatically improve query speed.

Performance OptimizationQuery RewriteSQL
0 likes · 13 min read
Common MySQL Performance Issues and Their Optimization Techniques