BestHub
Sign in
Tagged articles
636 articles
Page 5 of 7
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 17, 2021 · Databases

Comprehensive Overview of MySQL Architecture, Logs, Indexes, Transactions, Locks, MVCC, Buffer Pool, and Optimization

This article provides an in‑depth guide to MySQL internals, covering the SQL execution process, server and storage engine layers, binlog/redo/undo logs, index structures, transaction isolation levels, lock types, MVCC implementation, buffer pool management, and practical optimization techniques.

Transactionsdatabaseindexing
0 likes · 31 min read
Comprehensive Overview of MySQL Architecture, Logs, Indexes, Transactions, Locks, MVCC, Buffer Pool, and Optimization
ITPUB
ITPUB
Jan 16, 2021 · Databases

Why a Missing Index Parameter Crashed Our Production DB—and How to Fix It

During a production outage, a high‑volume SQL query without a required leftmost index field caused full table scans that saturated CPU, prompting a temporary index fix and revealing a deeper bug involving missing @NotNull validation and improper parameter handling, highlighting MySQL’s left‑most index rule.

JavaSQL Performancebug fix
0 likes · 9 min read
Why a Missing Index Parameter Crashed Our Production DB—and How to Fix It
Java Interview Crash Guide
Java Interview Crash Guide
Jan 9, 2021 · Databases

Master Elasticsearch Performance: Practical Tuning Tips for Faster Clusters

This guide consolidates everyday Elasticsearch tuning techniques—covering configuration file tweaks, system‑level settings, and usage‑level optimizations such as memory locking, discovery settings, fault detection, queue sizing, translog handling, bulk indexing, shard management, and disk I/O—to help you build a stable, high‑throughput search cluster.

Cluster OptimizationElasticsearchScalability
0 likes · 18 min read
Master Elasticsearch Performance: Practical Tuning Tips for Faster Clusters
Code Ape Tech Column
Code Ape Tech Column
Jan 8, 2021 · Databases

Database Standards and Guidelines for Backend Development

This article presents a comprehensive set of mandatory and recommended conventions for MySQL table creation, SQL writing, and index design, aiming to improve backend development efficiency, reduce erroneous DDL and queries, and enhance overall database performance.

Backend DevelopmentDatabase designSQL Guidelines
0 likes · 11 min read
Database Standards and Guidelines for Backend Development
Architecture Digest
Architecture Digest
Jan 2, 2021 · Databases

52 SQL Query Performance Optimization Strategies

This article presents a comprehensive list of 52 practical SQL optimization techniques, covering index usage, query rewriting, avoiding full table scans, proper data types, transaction handling, backup strategies, and other best practices to improve database performance and scalability.

indexingoptimizationperformance
0 likes · 18 min read
52 SQL Query Performance Optimization Strategies
Java Architect Essentials
Java Architect Essentials
Dec 31, 2020 · Databases

MySQL Single Table Optimization, Sharding, Partitioning, and Scaling Techniques

When a MySQL table grows large, performance degrades sharply, so this guide explains single‑table tuning, proper field choices, index strategies, query best practices, engine differences, system parameters, hardware upgrades, read‑write splitting, caching layers, table partitioning, vertical and horizontal sharding, and how to choose suitable sharding solutions.

DatabaseScalingPartitioningindexing
0 likes · 25 min read
MySQL Single Table Optimization, Sharding, Partitioning, and Scaling Techniques
Architect
Architect
Dec 30, 2020 · Databases

Overview of Database System Design

This article provides a comprehensive overview of database system design, covering its historical evolution, classification of relational and NoSQL databases, key architectural patterns, consistency models, indexing techniques, storage formats, compression methods, and practical considerations for selecting the right database solution.

DesignNoSQLSQL
0 likes · 43 min read
Overview of Database System Design
JD Tech Talk
JD Tech Talk
Dec 30, 2020 · Databases

Architecture and Application Practice of JD Urban Spatio-Temporal Data Engine (JUST)

The presentation details the design, implementation, and real‑world applications of the JD Urban Spatio‑Temporal Data Engine (JUST), a distributed, scalable database that handles massive, complex spatio‑temporal data with novel storage, indexing, and query techniques, demonstrating high performance and ease of use across smart‑city scenarios.

Big DataGISUrban Computing
0 likes · 26 min read
Architecture and Application Practice of JD Urban Spatio-Temporal Data Engine (JUST)
MaGe Linux Operations
MaGe Linux Operations
Dec 28, 2020 · Backend Development

Mastering Elasticsearch: Core Concepts and Indexing Workflow Explained

This article introduces Elasticsearch’s core concepts—including clusters, node roles, documents, mappings, and shards—and walks through the complete indexing workflow from client request to replica synchronization, highlighting key settings, routing calculations, and the role of refresh and flush operations.

Backend DevelopmentClusterDistributed Systems
0 likes · 13 min read
Mastering Elasticsearch: Core Concepts and Indexing Workflow Explained
Architect
Architect
Dec 27, 2020 · Big Data

Optimizing Billion‑Scale Hive Queries: Partitioning, Indexing, Bucketing, Active‑User Segmentation, and Data Structure Refactoring

This article walks through the challenges of querying a 300‑billion‑row Hive table, analyzes why traditional partitioning, indexing, and bucketing fall short, and presents a practical solution that combines active‑user segmentation and a redesigned array‑based data model to cut query time from hours to minutes.

Big DataData PartitioningHive
0 likes · 10 min read
Optimizing Billion‑Scale Hive Queries: Partitioning, Indexing, Bucketing, Active‑User Segmentation, and Data Structure Refactoring
Liangxu Linux
Liangxu Linux
Dec 26, 2020 · Databases

Master MySQL Performance: Practical Soft and Hard Optimization Techniques

This guide explains how to boost MySQL performance through soft optimizations like query analysis, index usage, and table restructuring, as well as hard optimizations involving hardware upgrades, configuration tuning, sharding, read‑write splitting, and cache clustering.

CacheDatabase Optimizationindexing
0 likes · 8 min read
Master MySQL Performance: Practical Soft and Hard Optimization Techniques
Code Ape Tech Column
Code Ape Tech Column
Dec 23, 2020 · Databases

Master MySQL Indexes: Why B+Tree Outperforms Other Structures

This article explains how proper index creation boosts MySQL query performance, detailing the mechanics of indexes, why B+Tree is chosen over binary and balanced trees, the storage differences between MyISAM and InnoDB, and practical guidelines for designing effective single‑column, composite, and covering indexes.

B+TreeDatabase OptimizationSQL
0 likes · 19 min read
Master MySQL Indexes: Why B+Tree Outperforms Other Structures
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 13, 2020 · Big Data

Elasticsearch Write, Read, Search Processes and Performance Tuning Guide

This article explains Elasticsearch's data ingestion, retrieval, and search workflows, details the underlying indexing mechanisms, and provides comprehensive system‑level, shard‑level, and query‑level tuning recommendations—including configuration snippets and best‑practice strategies for high‑throughput and low‑latency deployments.

Cluster ConfigurationElasticsearchSearch
0 likes · 20 min read
Elasticsearch Write, Read, Search Processes and Performance Tuning Guide
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 10, 2020 · Databases

MySQL Performance Optimization, Architecture, and High‑Availability Guide

This comprehensive guide covers the factors that impact MySQL server performance, strategies for handling large tables and transactions, hardware and OS tuning, storage‑engine selection, replication modes, high‑availability architectures, indexing techniques, and practical SQL query‑optimization methods.

HighAvailabilityReplicationindexing
0 likes · 38 min read
MySQL Performance Optimization, Architecture, and High‑Availability Guide
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 3, 2020 · Databases

Essential MySQL Design & Development Standards for Reliable Databases

This guide outlines comprehensive MySQL best‑practice standards covering naming conventions, storage engine selection, charset usage, table and column comments, size limits, partitioning, hot‑cold data separation, index design, SQL coding rules, and operational safeguards to ensure performant, maintainable, and secure database systems.

Database designSQL Standardsbest practices
0 likes · 22 min read
Essential MySQL Design & Development Standards for Reliable Databases
Tencent Cloud Developer
Tencent Cloud Developer
Dec 2, 2020 · Big Data

WeChat Pay Log System at Scale: Practices with Hermes

WeChat Pay’s Hermes‑based log system ingests trillions of entries daily, storing petabytes across a 200‑node HDFS cluster with four‑nine availability, while LSM‑style writes, separate inverted indexes and hot‑cold tiering cut memory, disk and cost by up to 70 % and keep 95 % of queries under five seconds.

HDFSHermesLog Analytics
0 likes · 7 min read
WeChat Pay Log System at Scale: Practices with Hermes
JavaEdge
JavaEdge
Dec 1, 2020 · Backend Development

How Kafka’s OffsetIndex and TimeIndex Optimize Message Retrieval

This article explains Kafka’s internal index files—OffsetIndex and TimeIndex—including their file formats, how they store relative offsets and timestamps, the space‑saving optimizations, the processes for appending, truncating, and looking up entries, and best‑practice cautions for handling these indexes.

Backend DevelopmentKafkaOffsetIndex
0 likes · 8 min read
How Kafka’s OffsetIndex and TimeIndex Optimize Message Retrieval
Programmer DD
Programmer DD
Nov 26, 2020 · Databases

Unveiling Elasticsearch: Inside Nodes, Shards, and Lucene’s Inverted Index

This article explains Elasticsearch’s internal architecture, from cloud clusters and nodes to shards and Lucene’s inverted index, covering indexing, storage structures, query processing, caching, scaling, routing, and real‑world request handling, with detailed diagrams and examples.

DistributedSearchShards
0 likes · 13 min read
Unveiling Elasticsearch: Inside Nodes, Shards, and Lucene’s Inverted Index
php Courses
php Courses
Nov 20, 2020 · Databases

Technical Interview Q&A: MySQL, Indexing, Design Patterns, Algorithms, Networking, and Concurrency

This article compiles a series of technical interview questions and answers covering MySQL query best practices, index optimization, B+‑tree storage, binlog recovery, master‑slave replication, design pattern usage in Laravel, a PHP binary‑search insertion algorithm, transport‑layer protocols, TCP three‑handshake, and concurrency control strategies.

Design PatternsNetworkingdatabase
0 likes · 9 min read
Technical Interview Q&A: MySQL, Indexing, Design Patterns, Algorithms, Networking, and Concurrency
MaGe Linux Operations
MaGe Linux Operations
Nov 19, 2020 · Backend Development

Supercharging Elasticsearch: Practical Index & Search Optimizations for Billion-Row Queries

This article shares practical Elasticsearch and Lucene optimization techniques—including index structure tuning, shard routing, DocValues management, and query pagination—to achieve sub‑second search performance on datasets exceeding a billion records while supporting multi‑year historical queries.

ElasticsearchSearchindexing
0 likes · 13 min read
Supercharging Elasticsearch: Practical Index & Search Optimizations for Billion-Row Queries
DataFunTalk
DataFunTalk
Nov 8, 2020 · Backend Development

Design and Optimization of an In-Memory Search Engine

This article shares the author's exploration of in‑memory search engine design, covering system understanding, core architecture, thread and task models, intersection algorithms, lookup optimizations, and componentization, aiming to fill the scarce documentation on memory‑based retrieval engines.

Query ProcessingThread Modelin-memory search
0 likes · 48 min read
Design and Optimization of an In-Memory Search Engine
DevOps Cloud Academy
DevOps Cloud Academy
Nov 7, 2020 · Databases

How to Use Elasticsearch Search Templates for Batch Terms Queries

This article explains why a terms query with an array fails inside an Elasticsearch search template, demonstrates the correct Mustache‑based template syntax, and provides step‑by‑step code examples for defining the index, inserting data, creating the template, and executing the query.

DSLElasticsearchSearch Template
0 likes · 8 min read
How to Use Elasticsearch Search Templates for Batch Terms Queries
Fulu Network R&D Team
Fulu Network R&D Team
Nov 2, 2020 · Databases

Optimizing Large MySQL Tables on Alibaba Cloud: Design, Indexing, PolarDB Migration, X‑Engine Partitioning, and Parallel Query

This article details how to improve performance of massive MySQL tables on Alibaba Cloud by redesigning schemas and indexes, migrating to PolarDB with read‑write separation, partitioning historical data using the X‑Engine storage engine, and leveraging PolarDB's parallel query capabilities for faster analytics.

Database OptimizationParallel QueryPartitioning
0 likes · 12 min read
Optimizing Large MySQL Tables on Alibaba Cloud: Design, Indexing, PolarDB Migration, X‑Engine Partitioning, and Parallel Query
php Courses
php Courses
Oct 30, 2020 · Big Data

Introduction to Elasticsearch and Its Integration with Laravel

This article explains Elasticsearch's foundation on Lucene, compares its concepts to MySQL, describes inverted indexing, and provides a step‑by‑step guide for installing, configuring, and using the basemkhirat/elasticsearch Laravel plugin with code examples and tips for Chinese analysis.

BackendElasticsearchLaravel
0 likes · 4 min read
Introduction to Elasticsearch and Its Integration with Laravel
Open Source Linux
Open Source Linux
Oct 23, 2020 · Databases

Boost MySQL Performance: 8 Proven Query Optimization Techniques

This article explores eight common MySQL performance pitfalls—including inefficient LIMIT usage, implicit type conversion, subquery updates, mixed sorting, EXISTS clauses, condition push‑down, early result narrowing, and intermediate result push‑down—and provides rewritten SQL examples that dramatically reduce execution time.

CTESQLindexing
0 likes · 13 min read
Boost MySQL Performance: 8 Proven Query Optimization Techniques
Architect
Architect
Oct 22, 2020 · Databases

Understanding MySQL Index Types, Structures, and Best Practices

This article explains the various MySQL index implementations—including B‑Tree, B+Tree, hash, clustered, non‑clustered, and covering indexes—illustrates their internal structures with diagrams, provides SQL examples, and offers practical guidelines for selecting and using indexes efficiently.

B-Treeindexingmysql
0 likes · 13 min read
Understanding MySQL Index Types, Structures, and Best Practices
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 2, 2020 · Databases

Essential MySQL Optimization Tips: From EXPLAIN to Advanced Index Strategies

This article presents a comprehensive guide to MySQL performance tuning, covering the use of EXPLAIN, proper handling of IN clauses, selective column queries, limit usage, index best practices, avoiding costly operations, pagination techniques, full‑text search, join optimization, and advanced directives such as FORCE INDEX and STRAIGHT_JOIN.

SQLdatabaseindexing
0 likes · 12 min read
Essential MySQL Optimization Tips: From EXPLAIN to Advanced Index Strategies
Top Architect
Top Architect
Sep 19, 2020 · Databases

MySQL Performance Optimization: Design, Indexing, Partitioning, and Migration Strategies

This article analyzes a severe MySQL performance issue caused by massive user‑access logs, then presents three solution paths—optimizing the existing database, migrating to a compatible high‑performance database, and adopting big‑data technologies—detailing design best practices, indexing, partitioning, sharding, and cloud‑native options to restore query speed and scalability.

Database OptimizationPartitioningcloud database
0 likes · 18 min read
MySQL Performance Optimization: Design, Indexing, Partitioning, and Migration Strategies
Architecture Digest
Architecture Digest
Sep 18, 2020 · Databases

Optimizing MySQL RDS for Large‑Scale User Activity Logs: Design, Indexing, Partitioning, and Migration Strategies

This article analyzes the performance problems of a massive MySQL 5.6 RDS table storing billions of user‑activity records and presents three practical solutions—optimizing the existing schema and queries, migrating to a MySQL‑compatible high‑performance database, and adopting a big‑data platform—detailing design, indexing, partitioning, sharding, and cloud‑native options.

Partitioningcloud databaseindexing
0 likes · 15 min read
Optimizing MySQL RDS for Large‑Scale User Activity Logs: Design, Indexing, Partitioning, and Migration Strategies
Java Architect Essentials
Java Architect Essentials
Sep 17, 2020 · Databases

Optimizing Large-Scale SQL Queries with Stored Procedures and Indexing

The article details how a half‑hour SSRS report query on a massive MES database was transformed into a sub‑second operation by analyzing the original SQL, eliminating full table scans, adding proper indexes, using temporary tables and a well‑designed stored procedure, while also discussing common pitfalls and best‑practice tips for high‑performance database querying.

Database OptimizationSQLStored Procedure
0 likes · 20 min read
Optimizing Large-Scale SQL Queries with Stored Procedures and Indexing
Programmer DD
Programmer DD
Sep 14, 2020 · Databases

Master MySQL Performance: Practical Tips for Scaling and Optimization

This article explores MySQL performance limits, concurrency settings, query‑time best practices, table design choices, index classifications, and a comprehensive set of SQL optimizations—including batch processing, operator rewrites, and pagination tricks—to help developers eliminate slow queries and build scalable database solutions.

SQLindexingmysql
0 likes · 15 min read
Master MySQL Performance: Practical Tips for Scaling and Optimization
ITPUB
ITPUB
Sep 9, 2020 · Databases

How to Speed Up Massive MySQL User‑Log Tables: Partitioning, Indexing, and Migration Strategies

This article examines performance problems with a 20‑million‑row MySQL user‑log table on Alibaba Cloud RDS, outlines three solution paths—optimizing the existing database, migrating to a MySQL‑compatible high‑performance service, and adopting a big‑data engine—and provides detailed guidance on schema design, indexing, partitioning, and practical SQL tweaks.

Big DataDatabase OptimizationPartitioning
0 likes · 17 min read
How to Speed Up Massive MySQL User‑Log Tables: Partitioning, Indexing, and Migration Strategies
Programmer DD
Programmer DD
Sep 7, 2020 · Databases

How to Speed Up Massive MySQL Tables: Practical Optimization Strategies

This article examines why a MySQL 5.6 RDS table with tens of millions of rows becomes unbearably slow, then presents three concrete approaches—optimizing the existing database, migrating to a MySQL‑compatible service, and adopting a big‑data engine—detailing design, indexing, partitioning, sharding, and cloud options to restore performance.

Database OptimizationPartitioningindexing
0 likes · 18 min read
How to Speed Up Massive MySQL Tables: Practical Optimization Strategies
Code Ape Tech Column
Code Ape Tech Column
Sep 1, 2020 · Databases

Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices

This article presents a thorough overview of MySQL performance tuning, covering step‑by‑step SQL optimization techniques, common pitfalls, index and table‑structure improvements, cache parameter adjustments, and practical guidelines to reduce I/O and CPU bottlenecks while maintaining data integrity.

Database PerformanceQuery TuningSQL Optimization
0 likes · 28 min read
Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices
Top Architect
Top Architect
Aug 18, 2020 · Databases

Comprehensive Guide to MySQL SQL Optimization Techniques

This article explains why SQL optimization is a cost‑effective way to boost system performance, outlines fundamental principles, common pitfalls such as leading wildcards, IN/OR/NULL misuse, and provides practical tips on indexing, execution order, hints, DML batching, pagination, and table design for MySQL databases.

QueryOptimizationSQLdatabase
0 likes · 21 min read
Comprehensive Guide to MySQL SQL Optimization Techniques
Sohu Tech Products
Sohu Tech Products
Aug 12, 2020 · Big Data

Elasticsearch Basics: Concepts, Installation, and Search Operations

This article introduces Elasticsearch as a distributed open‑source search and analytics engine, explains its core concepts and architecture, compares it with relational databases, details installation steps, configuration, indexing, analyzers, query DSL, pagination, sorting, and provides practical examples for building search functionality.

AnalyzersElasticsearchInstallation
0 likes · 22 min read
Elasticsearch Basics: Concepts, Installation, and Search Operations
Selected Java Interview Questions
Selected Java Interview Questions
Aug 8, 2020 · Databases

MySQL Single‑Table Optimization, Sharding, and Scaling Strategies

This article explains why MySQL tables with massive row counts suffer performance degradation and provides practical guidance on single‑table optimization, field and index design, query tuning, engine selection, system parameters, hardware upgrades, read‑write splitting, caching layers, partitioning, vertical and horizontal sharding, as well as client‑side and proxy‑side sharding solutions.

Database Optimizationindexingmysql
0 likes · 26 min read
MySQL Single‑Table Optimization, Sharding, and Scaling Strategies
Programmer DD
Programmer DD
Aug 8, 2020 · Artificial Intelligence

How Elasticsearch Handles Write, Read, and Search: Inside the Engine

This article explains Elasticsearch's internal mechanisms for indexing, querying, and retrieving data, covering the roles of coordinating nodes, primary and replica shards, the refresh and commit cycles, near‑real‑time search, and the underlying Lucene inverted index.

Elasticsearchdata ingestionindexing
0 likes · 12 min read
How Elasticsearch Handles Write, Read, and Search: Inside the Engine
Top Architect
Top Architect
Aug 3, 2020 · Databases

Case Study: Insert‑Into‑Select Migration Failure and Resolution in MySQL

This article analyzes a real‑world MySQL incident where using INSERT INTO SELECT to migrate billions of rows caused table‑wide locking and payment failures, explains the underlying locking behavior, and presents a solution using proper indexing and FORCE INDEX to avoid full‑table scans.

INSERT INTO SELECTSQL Performanceindexing
0 likes · 7 min read
Case Study: Insert‑Into‑Select Migration Failure and Resolution in MySQL
Laravel Tech Community
Laravel Tech Community
Aug 2, 2020 · Databases

MySQL Database Design and SQL Writing Standards

This document outlines comprehensive MySQL database design standards and SQL writing guidelines, covering naming conventions, character sets, table and column specifications, index design, partitioning, data types, transaction handling, and prohibited statements to ensure stable, performant, and maintainable production databases.

PartitioningSQL Standardsindexing
0 likes · 18 min read
MySQL Database Design and SQL Writing Standards
Programmer DD
Programmer DD
Jul 27, 2020 · Databases

Boost MySQL Performance: Bulk Insert, GROUP BY, ORDER BY, and OR Query Optimizations

This article presents practical MySQL performance tricks, covering bulk data insertion with DISABLE/ENABLE KEYS, loading data in primary‑key order, multi‑value INSERTs, INSERT DELAYED, separating index and data files, GROUP BY sorting elimination, index‑driven ORDER BY, OR‑condition indexing, replacing sub‑queries with JOINs, and using SQL hints such as USE, IGNORE, and FORCE INDEX.

Bulk InsertSQL Optimizationindexing
0 likes · 14 min read
Boost MySQL Performance: Bulk Insert, GROUP BY, ORDER BY, and OR Query Optimizations
JavaEdge
JavaEdge
Jul 26, 2020 · Databases

How to Choose and Use Prefix Indexes for String Columns in MySQL

This article explains why and how to create prefix indexes for string fields in MySQL, compares full‑column and prefix indexes with concrete examples, shows how to pick an optimal prefix length using cardinality statistics, and discusses alternative solutions such as reverse storage and hash fields.

Database OptimizationPrefix IndexSQL
0 likes · 12 min read
How to Choose and Use Prefix Indexes for String Columns in MySQL
Senior Brother's Insights
Senior Brother's Insights
Jul 20, 2020 · Databases

Discover Why PostgreSQL Could Be the Underrated Database You Need

This article introduces PostgreSQL, the powerful open‑source object‑relational database, highlights its rising popularity in DB‑Engines rankings, compares its advanced features and performance advantages over MySQL, and outlines many of its unique capabilities such as rich data types, sophisticated indexing, and robust replication.

Data TypesFeature ComparisonPostgreSQL
0 likes · 6 min read
Discover Why PostgreSQL Could Be the Underrated Database You Need
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 16, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting

This article provides a thorough overview of MySQL performance tuning, covering proper table design according to the three normal forms, various index types and their creation, partitioning strategies, read/write separation, storage engine selection, and practical SQL tips for improving query efficiency.

Database OptimizationPartitioningSQL
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting
Selected Java Interview Questions
Selected Java Interview Questions
Jul 3, 2020 · Databases

Understanding MySQL Index Structures: From Simple Tables to B+ Trees

This article explains how MySQL stores data using pages, page directories, and multi‑page structures, demonstrates why MySQL silently sorts rows on insert, and shows how these mechanisms combine into the B+‑tree index that optimizes query performance and supports clustering, non‑clustering, and composite indexes.

B+TreeComposite IndexDatabase Pages
0 likes · 24 min read
Understanding MySQL Index Structures: From Simple Tables to B+ Trees
Laravel Tech Community
Laravel Tech Community
Jun 22, 2020 · Databases

MySQL Optimization Tips Frequently Asked in Interviews

This article presents a comprehensive collection of MySQL performance‑tuning techniques—including proper use of EXPLAIN, limiting IN lists, selecting explicit columns, using LIMIT 1, avoiding costly ORDER BY RAND(), choosing between IN and EXISTS, preferring UNION ALL, applying full‑text indexes, and optimizing joins, pagination, and index usage—to help developers write faster, more efficient queries.

Database TuningSQL Optimizationindexing
0 likes · 10 min read
MySQL Optimization Tips Frequently Asked in Interviews
Architecture Digest
Architecture Digest
Jun 21, 2020 · Databases

Optimizing Large-Scale MySQL Join Queries Using EXPLAIN

This article explains how to analyze and tune MySQL join queries with EXPLAIN, addressing issues like using temporary tables and filesort, and provides practical techniques—including STRAIGHT_JOIN and index strategies—to achieve sub‑second response times on tables with millions of rows.

Database PerformanceJOINexplain
0 likes · 6 min read
Optimizing Large-Scale MySQL Join Queries Using EXPLAIN
Laravel Tech Community
Laravel Tech Community
Jun 16, 2020 · Databases

Overview of MongoDB: Architecture, Features, and Storage Model

MongoDB is a versatile NoSQL database that combines relational‑like querying with a flexible BSON document model, offering high performance, easy deployment, rich indexing, replication, and cloud‑scale storage, while supporting multiple programming languages and operating systems.

BSONDatabase ArchitectureMongoDB
0 likes · 4 min read
Overview of MongoDB: Architecture, Features, and Storage Model
360 Quality & Efficiency
360 Quality & Efficiency
Jun 12, 2020 · Databases

MongoDB Pagination, Query Optimization, and Index Design Guide

This article explains various MongoDB pagination strategies—including skip/limit, range queries, and sorting—covers performance monitoring with profiling, details index creation and design principles, and describes how to interpret explain plans for efficient query optimization.

MongoDBdatabaseindexing
0 likes · 13 min read
MongoDB Pagination, Query Optimization, and Index Design Guide
Architecture Digest
Architecture Digest
Jun 10, 2020 · Databases

Comprehensive MySQL Single‑Table Optimization and Scaling Strategies

This article presents a thorough guide to improving MySQL performance for large single tables, covering field choices, indexing best practices, query tuning, engine selection, system parameters, hardware upgrades, read/write separation, caching layers, partitioning, vertical and horizontal sharding, and compatible scalable database alternatives.

Database OptimizationPartitioningindexing
0 likes · 21 min read
Comprehensive MySQL Single‑Table Optimization and Scaling Strategies
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 10, 2020 · Backend Development

Elasticsearch Index and Search Optimization Guide

This article provides a comprehensive overview of Elasticsearch architecture and presents practical index and search optimization techniques, configuration recommendations, stress‑testing methods, and monitoring tools to improve cluster performance and reliability.

Cluster ConfigurationElasticsearchindexing
0 likes · 13 min read
Elasticsearch Index and Search Optimization Guide
macrozheng
macrozheng
Jun 2, 2020 · Databases

Master MySQL Architecture: Storage Engines, Indexes, Transactions & Optimization

This comprehensive guide explains MySQL's layered architecture, storage engine plugins, index structures, transaction isolation levels, locking mechanisms, performance tuning techniques, partitioning, sharding, and replication, providing practical insights for developers and DBAs to optimize and scale MySQL deployments.

Storage Enginedatabaseindexing
0 likes · 77 min read
Master MySQL Architecture: Storage Engines, Indexes, Transactions & Optimization
MaGe Linux Operations
MaGe Linux Operations
May 29, 2020 · Databases

Search Engine Architecture: Indexing, Querying, and Elasticsearch Basics

This article explains what a search engine is, describes its core components—indexing and search modules—detailing the workflow from content acquisition to result rendering, and provides an in‑depth overview of Elasticsearch, including its architecture, clusters, shards, replicas, mappings, and basic configuration.

Elasticsearchindexingsharding
0 likes · 16 min read
Search Engine Architecture: Indexing, Querying, and Elasticsearch Basics
Alibaba Cloud Developer
Alibaba Cloud Developer
May 20, 2020 · Fundamentals

Unveiling Git’s Hidden Architecture: Objects, Packfiles, and Storage Models Explained

This article systematically explores Git’s underlying architecture, detailing the lifecycle of objects, core data structures, packfile formats, indexing mechanisms, and the algorithms used for object retrieval, while providing practical command examples and visual diagrams to demystify Git’s storage and retrieval models.

Gitgit internalsindexing
0 likes · 18 min read
Unveiling Git’s Hidden Architecture: Objects, Packfiles, and Storage Models Explained
Architect
Architect
May 15, 2020 · Databases

Understanding Elasticsearch Architecture: Segments, Translog, Refresh, Shard Allocation and Cluster Operations

This article provides a comprehensive overview of Elasticsearch's internal architecture, explaining how data flows from memory buffers to Lucene segments, the role of refresh and translog for durability, segment merging strategies, shard routing, replica consistency, allocation controls, hot‑cold data separation, and cluster discovery settings.

Cluster ManagementElasticsearchSegments
0 likes · 23 min read
Understanding Elasticsearch Architecture: Segments, Translog, Refresh, Shard Allocation and Cluster Operations
Java Captain
Java Captain
May 10, 2020 · Databases

MySQL Performance Optimization and Best Practices

This article shares practical MySQL performance optimization techniques, covering table size limits, connection settings, data type choices, index design, query rewriting, pagination, and batch processing, with code examples and actionable guidelines to improve query speed and scalability.

SQL Optimizationindexingmysql
0 likes · 13 min read
MySQL Performance Optimization and Best Practices
Laravel Tech Community
Laravel Tech Community
May 7, 2020 · Databases

MySQL Database Naming, Design, Field, Index, and Operation Standards

This guide presents comprehensive MySQL best‑practice standards covering object naming, basic schema design, field definitions, index design, common index column recommendations, covering indexes, SET usage, SQL development rules, and safe operational behaviors to improve performance, maintainability, and security.

Database designSQL Best Practicesindexing
0 likes · 19 min read
MySQL Database Naming, Design, Field, Index, and Operation Standards
Laravel Tech Community
Laravel Tech Community
May 2, 2020 · Databases

MySQL Database Naming, Design, Indexing, and Development Standards

This comprehensive guide outlines MySQL database naming conventions, basic design rules, field specifications, index design principles, common index recommendations, and best practices for SQL development and operational behavior to ensure performance, maintainability, and security.

Database designSQL Best Practicesindexing
0 likes · 18 min read
MySQL Database Naming, Design, Indexing, and Development Standards
Programmer DD
Programmer DD
Apr 23, 2020 · Databases

How INSERT INTO SELECT Nearly Crashed a MySQL DB – Lessons & Fix

An engineer’s attempt to migrate millions of orders using INSERT INTO SELECT caused massive table locking, payment failures, and system alerts, but by analyzing the locking behavior and adding an index on the timestamp column, the migration succeeded efficiently, illustrating the importance of proper indexing for large‑scale data moves.

INSERT INTO SELECTSQLdatabase migration
0 likes · 7 min read
How INSERT INTO SELECT Nearly Crashed a MySQL DB – Lessons & Fix
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 15, 2020 · Databases

Understanding MySQL Large Object Types: TEXT/BLOB and JSON

This article explains MySQL's large object data types—TEXT, BLOB, and JSON—covering their storage formats, performance implications, indexing rules, partition restrictions, relevant server parameters, and practical examples of creating tables, inserting data, and querying JSON values.

BlobDatabase designJSON
0 likes · 10 min read
Understanding MySQL Large Object Types: TEXT/BLOB and JSON
Youzan Coder
Youzan Coder
Apr 7, 2020 · Backend Development

Building Youzan's Enterprise Search Platform: Architecture, Indexing & Scaling

This article explores Youzan's enterprise search middle platform, detailing the challenges of siloed architectures, the concept of cognitive folding, comprehensive index design, write/read mechanisms, configuration-driven routing, monitoring, and practical implementations that enable scalable, reusable search capabilities across diverse business domains.

Backend ArchitectureEnterprise searchScalable Systems
0 likes · 16 min read
Building Youzan's Enterprise Search Platform: Architecture, Indexing & Scaling
Qunar Tech Salon
Qunar Tech Salon
Apr 2, 2020 · Databases

30 Practical SQL Optimization Tips with Examples

This article presents thirty actionable SQL performance recommendations—including selecting specific columns, using LIMIT, avoiding OR and functions in WHERE clauses, proper indexing, batch inserts, and query planning—each illustrated with clear examples and explanations to help developers write faster, more efficient queries.

SQLdatabaseindexing
0 likes · 19 min read
30 Practical SQL Optimization Tips with Examples
360 Quality & Efficiency
360 Quality & Efficiency
Mar 24, 2020 · Databases

Introduction to Elasticsearch: Core Concepts, Use Cases, and Practical Operations

This article introduces Elasticsearch by explaining its core concepts such as indices, types, documents, mappings, and Query DSL, demonstrates common use cases, and provides step‑by‑step instructions for creating, updating, viewing, and deleting indices and documents using RESTful APIs, curl commands, and Docker‑compose deployment.

CRUDDockerElasticsearch
0 likes · 5 min read
Introduction to Elasticsearch: Core Concepts, Use Cases, and Practical Operations
DataFunTalk
DataFunTalk
Mar 24, 2020 · Databases

ByteDance’s Enhancements to RocksDB: LazyBuffer, Adaptive Map, KV Separation, Multi‑Index, Extreme Compression, and New Hardware Support

This article describes ByteDance’s extensive improvements to the RocksDB storage engine—including LazyBuffer, Adaptive Map‑based lazy compaction, KV separation, adaptive multi‑index support, extreme compression techniques, and hardware acceleration—to reduce amplification, improve performance, and lower costs for large‑scale database workloads.

Hardware accelerationKV SeparationRocksDB
0 likes · 14 min read
ByteDance’s Enhancements to RocksDB: LazyBuffer, Adaptive Map, KV Separation, Multi‑Index, Extreme Compression, and New Hardware Support
Liangxu Linux
Liangxu Linux
Feb 10, 2020 · Databases

Master MySQL: Essential Naming, Design, and Indexing Standards

This guide presents comprehensive MySQL best‑practice rules covering object naming conventions, fundamental schema design, field type selection, index creation strategies, and SQL development habits to improve performance, maintainability, and reliability of production databases.

Database designPerformance OptimizationSQL Best Practices
0 likes · 19 min read
Master MySQL: Essential Naming, Design, and Indexing Standards
Architect's Tech Stack
Architect's Tech Stack
Dec 25, 2019 · Backend Development

Elasticsearch Optimization Practices for Large-Scale Data Platforms

This article explains the architecture of Elasticsearch and Lucene, outlines common performance bottlenecks, and provides concrete indexing and query optimization techniques—including shard routing, refresh intervals, doc values, and hardware considerations—to achieve sub‑second query responses on billions of records.

ElasticsearchSearchindexing
0 likes · 12 min read
Elasticsearch Optimization Practices for Large-Scale Data Platforms
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 14, 2019 · Databases

MySQL Logical Architecture, Query Process, and Performance Optimization

This article explains MySQL's three‑layer logical architecture, the end‑to‑end query execution flow—including client/server protocol, query cache, parsing, cost‑based optimization, execution engine, and result delivery—followed by practical performance‑tuning advice on schema design, data types, index creation, and specific query optimizations such as COUNT(), JOINs, LIMIT pagination, and UNION handling.

Database PerformanceSQLindexing
0 likes · 34 min read
MySQL Logical Architecture, Query Process, and Performance Optimization
IT Architects Alliance
IT Architects Alliance
Nov 21, 2019 · Databases

Why MySQL Subqueries Took Hours and How Indexes Fixed It

A MySQL 5.6 database with three large tables suffered a 30,000‑second query when searching for students scoring 100 in a specific subject; by analyzing the execution plan, adding indexes on filter columns, and rewriting the query as a join, execution time dropped to under a second.

JOINSQL OptimizationSubquery
0 likes · 8 min read
Why MySQL Subqueries Took Hours and How Indexes Fixed It
System Architect Go
System Architect Go
Oct 27, 2019 · Databases

Mastering InfluxDB: Data Types, Schema Design, and Index Configuration

This guide explains InfluxDB’s schemaless data types, best practices for designing tag‑and‑field schemas, and how to choose and configure its in‑memory or TSI indexes, including key parameters such as max‑series‑per‑database and max‑values‑per‑tag for optimal performance.

ConfigurationInfluxDBTime Series
0 likes · 6 min read
Mastering InfluxDB: Data Types, Schema Design, and Index Configuration
Ziru Technology
Ziru Technology
Oct 21, 2019 · Databases

Why MySQL Indexes Aren’t Always Faster: Models, Types, and Common Pitfalls

Understanding MySQL indexes—from hash tables, ordered arrays, and B+ trees—to their practical use cases, including clustered and secondary indexes, reveals why they boost query speed, when they may hinder performance, and how factors like selectivity, dirty page flushing, type mismatches, and function usage affect query efficiency.

B+TreeSQL Optimizationindexing
0 likes · 10 min read
Why MySQL Indexes Aren’t Always Faster: Models, Types, and Common Pitfalls
Java Captain
Java Captain
Oct 11, 2019 · Databases

MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning

This article introduces MySQL fundamentals, covering logical architecture, locking, transactions, storage engines, schema and data type design, as well as index types and their constraints, plus practical creation‑time and query‑time optimization techniques with code examples and best‑practice recommendations.

Database OptimizationQuery TuningTransactions
0 likes · 11 min read
MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning
ITPUB
ITPUB
Oct 9, 2019 · Databases

What’s New in PostgreSQL 12? Performance Boosts and Advanced Features

PostgreSQL 12 brings major enhancements—including up to 40% faster queries on large datasets, improved indexing, partitioning, JSON path queries, generated columns, pluggable table access methods, stronger authentication, and built‑in JIT compilation—while also adding better localization, multi‑constraint authorization, and convenient maintenance commands.

JSONPartitioningPostgreSQL
0 likes · 6 min read
What’s New in PostgreSQL 12? Performance Boosts and Advanced Features