BestHub
Sign in
Tagged articles
15 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 26, 2025 · Databases

Why INSERT…SELECT Slows Down on OceanBase and How to Fix It

During an Oracle‑to‑OceanBase migration, a client encountered extremely slow INSERT…SELECT batch jobs due to a global unique non‑partitioned index, and the article walks through extracting logical and physical plans, pinpointing the bottleneck operators, and demonstrates converting the index to a partitioned one to cut execution time from over 30 minutes to 14 minutes.

INSERT SELECTIndex TuningOceanBase
0 likes · 16 min read
Why INSERT…SELECT Slows Down on OceanBase and How to Fix It
Su San Talks Tech
Su San Talks Tech
Mar 30, 2025 · Databases

How to Supercharge Large Database Tables: Proven Optimization Techniques

This article explains why massive tables become slow, identifies common bottlenecks such as disk I/O, missing indexes, deep pagination and lock contention, and provides a step‑by‑step guide covering table design, indexing, SQL tuning, sharding, caching and a real‑world case study to dramatically improve performance.

Index TuningLarge TablesSQL Performance
0 likes · 13 min read
How to Supercharge Large Database Tables: Proven Optimization Techniques
Architecture Digest
Architecture Digest
Mar 1, 2024 · Databases

SQL Performance Optimization and Index Tuning in MySQL

This article walks through a MySQL 5.6 scenario with course, student, and score tables, demonstrates why a naïve sub‑query is extremely slow, and shows step‑by‑step how adding single‑column, composite, and covering indexes, as well as rewriting the query to joins, can reduce execution time from hours to milliseconds.

Index TuningSQL Optimizationdatabase
0 likes · 10 min read
SQL Performance Optimization and Index Tuning in MySQL
Meituan Technology Team
Meituan Technology Team
Jul 6, 2023 · Databases

Meituan Database Attack‑Defense Practice: Kernel Observability, Full SQL, and Index Optimization

The article details how Meituan built a MySQL autonomous platform by constructing kernel observability to split OnCPU/OffCPU wait time, capturing full SQL directly from the kernel with compression, designing a safe exception‑handling workflow, and generating cost‑based index‑tuning suggestions—including what‑if analysis and workload‑driven recommendations—to enable comprehensive SQL governance.

Exception HandlingFull‑SQLIndex Tuning
0 likes · 34 min read
Meituan Database Attack‑Defense Practice: Kernel Observability, Full SQL, and Index Optimization
政采云技术
政采云技术
Jul 14, 2022 · Operations

Diagnosing and Optimizing Elasticsearch IO Bottlenecks for Billion-Scale Product Catalogs

Facing severe IO-wait and read bottlenecks as product data grew from tens of millions to billions, this article analyzes root causes in Elasticsearch clusters and presents a comprehensive solution involving index parameter tuning, merge settings, translog async writes, query optimizations, and hardware upgrades to restore performance and stability.

ElasticsearchIO optimizationIndex Tuning
0 likes · 14 min read
Diagnosing and Optimizing Elasticsearch IO Bottlenecks for Billion-Scale Product Catalogs
Programmer DD
Programmer DD
Mar 31, 2022 · Databases

Mastering MySQL: Proven Steps to Diagnose and Optimize Slow Queries

This guide walks through systematic MySQL query optimization—from identifying slow statements via logs and EXPLAIN analysis, to profiling, tracing, and applying targeted fixes such as index tuning, query rewrites, and handling special cases like left‑most matching, implicit conversion, large pagination, and IN‑order‑by pitfalls.

Index TuningQuery ProfilingSQL Optimization
0 likes · 13 min read
Mastering MySQL: Proven Steps to Diagnose and Optimize Slow Queries
Java Interview Crash Guide
Java Interview Crash Guide
Mar 25, 2022 · Databases

Master MySQL Performance: Proven Steps to Optimize Slow Queries

Learn how to identify and fix slow MySQL queries by analyzing slow‑query logs, using EXPLAIN, profiling, and optimizer trace, understanding index types and extra flags, and applying practical case‑by‑case optimizations such as index tuning, query rewriting, pagination strategies, and handling large data sets.

Index Tuningdatabasemysql
0 likes · 11 min read
Master MySQL Performance: Proven Steps to Optimize Slow Queries
Java Backend Technology
Java Backend Technology
Mar 23, 2022 · Databases

Master MySQL Performance: 10 Proven SQL Optimization Techniques

This article walks through why SQL queries become bottlenecks as data grows and presents a step‑by‑step guide—including slow‑query analysis, EXPLAIN interpretation, profiling, optimizer tracing, index tuning, and scenario‑specific tricks—to dramatically improve MySQL performance.

Explain PlanIndex TuningSQL Optimization
0 likes · 12 min read
Master MySQL Performance: 10 Proven SQL Optimization Techniques
dbaplus Community
dbaplus Community
Mar 20, 2022 · Databases

Master MySQL Performance: Step-by-Step SQL Optimization Techniques

This guide walks through essential MySQL performance tuning methods, from identifying slow queries via logs and EXPLAIN analysis to interpreting Extra information, using profiling and optimizer trace, and applying concrete index, query, and schema adjustments for common scenarios such as left‑most matching, implicit conversion, large pagination, IN‑order‑by, and complex queries.

Index TuningSQL Optimizationexplain
0 likes · 12 min read
Master MySQL Performance: Step-by-Step SQL Optimization Techniques
Programmer DD
Programmer DD
Apr 25, 2021 · Databases

Mastering MySQL: Proven Steps to Optimize Slow Queries

This article outlines a systematic approach to identifying and fixing inefficient MySQL queries, covering slow‑query detection, EXPLAIN analysis, profiling, optimizer tracing, and practical case studies that demonstrate index tuning, query rewriting, and handling large‑scale pagination and complex conditions.

Index TuningOptimizer_traceProfiling
0 likes · 10 min read
Mastering MySQL: Proven Steps to Optimize Slow Queries
vivo Internet Technology
vivo Internet Technology
Nov 17, 2017 · Big Data

Elasticsearch Search Tuning Guide: Part 2 - Index Optimization, Mapping, Scripts, and Segment Merging

The second part of the Elasticsearch search‑tuning series explains how to pre‑index data, choose appropriate keyword or text mappings, minimize script use by preferring Painless or Lucene expressions, and efficiently force‑merge read‑only indices into single segments for better performance.

Data MappingElasticsearchForce Merge
0 likes · 8 min read
Elasticsearch Search Tuning Guide: Part 2 - Index Optimization, Mapping, Scripts, and Segment Merging
ITPUB
ITPUB
Sep 20, 2016 · Databases

Mastering Billion-Row Time-Series Data in SQL Server: Bulk Insert, Partitioning, Index Tuning

To meet a demanding monitoring project that required storing up to 400 million records per day in SQL Server 2012, the author details a step‑by‑step journey involving bulk‑copy insertion, removing indexes during load, hourly partitioned tables, strategic index creation, and query optimizations to achieve sub‑second query times.

Bulk InsertIndex TuningLarge Data
0 likes · 17 min read
Mastering Billion-Row Time-Series Data in SQL Server: Bulk Insert, Partitioning, Index Tuning