BestHub
Sign in
Tagged articles
45 articles
Page 1 of 1
Ops Community
Ops Community
Mar 6, 2026 · Databases

Master MySQL Index Optimization: Deep Dive into EXPLAIN Execution Plans

This article provides a hands‑on guide to MySQL index optimization, deeply exploring EXPLAIN execution plans, new features in MySQL 8/8.4, practical index design principles, step‑by‑step SQL examples, common pitfalls, advanced techniques like functional and descending indexes, and comprehensive monitoring and troubleshooting strategies.

Database PerformanceIndex OptimizationSQL Tuning
0 likes · 28 min read
Master MySQL Index Optimization: Deep Dive into EXPLAIN Execution Plans
Raymond Ops
Raymond Ops
Jan 18, 2026 · Databases

How I Cut a 20‑Second MySQL Query to 200 ms: A Step‑by‑Step Optimization Journey

When a critical e‑commerce report took over 20 seconds and triggered a flood of user complaints, a systematic investigation using EXPLAIN, slow‑query logs, and profiling revealed missing indexes, costly joins, and temporary tables, leading to a four‑stage rewrite that reduced execution time to sub‑second performance.

SQL Tuningmysqlslow-query
0 likes · 21 min read
How I Cut a 20‑Second MySQL Query to 200 ms: A Step‑by‑Step Optimization Journey
Architect's Tech Stack
Architect's Tech Stack
Dec 24, 2025 · Backend Development

10 Proven Techniques to Supercharge API Performance in Java Applications

This article presents a comprehensive, step‑by‑step guide to optimizing Java‑based API interfaces, covering batch processing, asynchronous execution, caching, pre‑processing, pooling, transaction handling, pagination, SQL tuning, lock granularity, and code restructuring, with practical code examples and diagrams.

API optimizationAsynchronousBatch Processing
0 likes · 10 min read
10 Proven Techniques to Supercharge API Performance in Java Applications
MaGe Linux Operations
MaGe Linux Operations
Nov 25, 2025 · Databases

10 Common MySQL Index Failure Scenarios and How to Fix Them

This comprehensive guide explains why MySQL indexes often become ineffective, outlines ten typical failure scenarios with concrete EXPLAIN examples, and provides practical solutions, scripts, best‑practice recommendations, and monitoring techniques to dramatically improve slow‑query performance.

Database PerformanceIndex OptimizationSQL Tuning
0 likes · 35 min read
10 Common MySQL Index Failure Scenarios and How to Fix Them
Wukong Talks Architecture
Wukong Talks Architecture
Sep 4, 2025 · Backend Development

How a ‘Broken Pipe’ Error Revealed Hidden Performance Bottlenecks in Production

An unexpected ‘Broken pipe’ error halted production, prompting a deep dive into logs, trace IDs, and monitoring tools like Kibana and SkyWalking, which uncovered Feign client timeouts, a costly SQL update, and redundant microservice calls, leading to targeted fixes that restored normal device operation.

MicroservicesSQL Tuningbackend debugging
0 likes · 10 min read
How a ‘Broken Pipe’ Error Revealed Hidden Performance Bottlenecks in Production
Laravel Tech Community
Laravel Tech Community
Aug 16, 2025 · Databases

Unlock 10× Faster Queries: The Database Performance Optimization Pyramid Explained

This article presents a comprehensive, layered approach to database performance optimization—covering SQL tuning, index design, configuration parameters, hardware choices, and architectural strategies—complete with practical code examples, benchmark results, and actionable checklists for MySQL environments.

Database OptimizationHardware TuningMySQL Performance
0 likes · 13 min read
Unlock 10× Faster Queries: The Database Performance Optimization Pyramid Explained
MaGe Linux Operations
MaGe Linux Operations
Aug 15, 2025 · Databases

Master Database Performance: From SQL Tuning to Hardware Optimization

This comprehensive guide walks you through database performance optimization—from identifying bottlenecks and tuning SQL queries, indexes, and configuration parameters, to selecting storage, memory, and CPU resources, applying architectural patterns, and using monitoring tools—to dramatically boost throughput and reduce latency.

Database OptimizationHardware TuningSQL Tuning
0 likes · 22 min read
Master Database Performance: From SQL Tuning to Hardware Optimization
Java Interview Crash Guide
Java Interview Crash Guide
Jul 3, 2025 · Backend Development

10 Proven Strategies to Supercharge API Performance in Java

This article presents a comprehensive, step‑by‑step guide to optimizing API latency by applying batch processing, asynchronous execution, caching, pre‑processing, pooling, parallelism, indexing, transaction management, code refactoring, pagination, SQL tuning, and fine‑grained locking techniques.

API optimizationBatch ProcessingSQL Tuning
0 likes · 10 min read
10 Proven Strategies to Supercharge API Performance in Java
dbaplus Community
dbaplus Community
Dec 3, 2024 · Databases

30 Real-World SQL Query Pitfalls and How to Fix Them

This guide enumerates thirty common business scenarios that cause SQL performance problems, explains the root causes, offers concrete optimization strategies, and provides detailed before‑and‑after query examples to help developers dramatically improve database efficiency.

Database PerformanceSQL Tuning
0 likes · 28 min read
30 Real-World SQL Query Pitfalls and How to Fix Them
Sanyou's Java Diary
Sanyou's Java Diary
Feb 22, 2024 · Backend Development

10 Proven Techniques to Supercharge Backend API Performance

This article presents a comprehensive guide for backend developers, covering ten practical techniques—including local and distributed caching, parallel execution, asynchronous processing, connection pooling, sharding, SQL tuning, pre‑computation, batch operations, lock granularity, and context propagation—to dramatically improve API performance.

BackendSQL Tuningcaching
0 likes · 13 min read
10 Proven Techniques to Supercharge Backend API Performance
IT Architects Alliance
IT Architects Alliance
Apr 23, 2023 · Backend Development

Common Interface Performance Optimization Strategies

This article outlines a comprehensive set of backend interface optimization techniques—including batch processing, asynchronous execution, caching, pre‑processing, pooling, parallelization, indexing, transaction sizing, code restructuring, deep pagination, SQL tuning, and lock granularity—to reduce latency and improve overall system efficiency.

API optimizationAsynchronous ExecutionBatch Processing
0 likes · 8 min read
Common Interface Performance Optimization Strategies
NetEase Yanxuan Technology Product Team
NetEase Yanxuan Technology Product Team
Feb 20, 2023 · Big Data

Data Task Optimization Techniques and Practices

The article surveys unconventional offline data‑task optimizations—such as distribution‑by, seeded random shuffling, explode‑based skew mitigation, hash bucketing, task‑parallelism tuning, and multi‑insert materialization—organized by point, line, and surface perspectives, and stresses that effective performance gains require both technical tricks and business‑driven pipeline adjustments.

SQL Tuningdata optimizationdistributed computing
0 likes · 16 min read
Data Task Optimization Techniques and Practices
JD Cloud Developers
JD Cloud Developers
Feb 6, 2023 · Databases

Master MySQL Performance: Indexing, Execution Plans, and Real-World Cases

This article explains why database performance monitoring becomes critical as data grows, outlines common optimization techniques, dives into MySQL's storage architecture and index structures, and shares three real‑world cases that illustrate how proper indexing and execution‑plan analysis can prevent severe latency and CPU spikes.

Database PerformanceIndex OptimizationSQL Tuning
0 likes · 15 min read
Master MySQL Performance: Indexing, Execution Plans, and Real-World Cases
ITPUB
ITPUB
Oct 17, 2022 · Databases

Boost Database Performance: 4 Key Optimization Dimensions Explained

This article explores database optimization from four angles—architecture, hardware, instance parameters, and SQL tuning—detailing practical techniques like distributed caching, read/write splitting, sharding, SSD upgrades, parameter tuning for Oracle, MySQL, PostgreSQL, and DaMeng, and step‑by‑step SQL rewrite with real‑world performance results.

Database OptimizationHardwareSQL Tuning
0 likes · 17 min read
Boost Database Performance: 4 Key Optimization Dimensions Explained
dbaplus Community
dbaplus Community
Jun 12, 2022 · Databases

12 Common MySQL Slow‑Query Triggers and Practical Fixes

This article enumerates twelve typical reasons why MySQL queries become slow—ranging from missing or ineffective indexes, type conversions, OR/LIKE patterns, composite‑index misuse, built‑in functions, large tables, deep pagination, join overload, oversized IN clauses, dirty‑page flushing, order‑by filesort, lock contention, delete‑in pitfalls, and group‑by temp tables—and provides concrete SQL examples, execution‑plan explanations, and optimization techniques for each case.

Database PerformanceSQL Tuningmysql
0 likes · 28 min read
12 Common MySQL Slow‑Query Triggers and Practical Fixes
ITPUB
ITPUB
Apr 11, 2022 · Databases

How to Optimize Chinese Domestic Databases: Practical DBA Tips Beyond Benchmarks

This article shares experienced DBA insights on optimizing Chinese domestic databases, highlighting why traditional Oracle benchmark tweaks often fail, the limited value of buffer‑hit metrics, the importance of OS I/O tuning, SQL plan baselines, and handling high‑concurrency bottlenecks such as spinlock contention.

OS I/OSQL TuningTPMC
0 likes · 7 min read
How to Optimize Chinese Domestic Databases: Practical DBA Tips Beyond Benchmarks
dbaplus Community
dbaplus Community
Dec 26, 2021 · Databases

Boost Database Performance: 4 Key Optimization Strategies from Architecture to SQL

From architecture tweaks like distributed caching and read‑write separation to hardware upgrades, DB instance tuning, and concrete SQL refactoring, this guide walks through four optimization layers, illustrates each with diagrams and a full‑scale MySQL case study, and shows how performance can improve up to twentyfold.

Database OptimizationHardwareSQL Tuning
0 likes · 13 min read
Boost Database Performance: 4 Key Optimization Strategies from Architecture to SQL
Architect's Tech Stack
Architect's Tech Stack
Oct 20, 2021 · Databases

MySQL Performance Optimization: Data Volume, Concurrency, Query Time, Table Design, Index and SQL Tuning

This article presents a comprehensive guide to MySQL performance, covering maximum data volume and concurrency limits, recommended query response times, practical table‑design rules, index classification and optimization techniques, as well as detailed SQL tuning patterns such as batch processing, operator, OR, IN, LIKE, JOIN and LIMIT improvements.

Database OptimizationSQL Tuningdata modeling
0 likes · 15 min read
MySQL Performance Optimization: Data Volume, Concurrency, Query Time, Table Design, Index and SQL Tuning
Java High-Performance Architecture
Java High-Performance Architecture
Oct 3, 2021 · Databases

Why Tame Slow SQL? Proven MySQL Optimization Strategies

The article explains why slow SQL queries drain I/O and CPU resources, outlines prioritization rules, details MySQL execution steps, identifies performance‑affecting factors, and provides practical solutions and best‑practice guidelines for diagnosing and optimizing slow MySQL queries in production environments.

Database PerformanceSQL Tuningindexing
0 likes · 19 min read
Why Tame Slow SQL? Proven MySQL Optimization Strategies
dbaplus Community
dbaplus Community
Apr 5, 2021 · Databases

When and How to Apply Database Sharding: Practical Guidelines and Pitfalls

This article explains why database performance bottlenecks arise, outlines criteria for deciding when to shard databases and tables, and provides detailed strategies for SQL tuning, table restructuring, horizontal and vertical splitting, single‑ versus multi‑database sharding, as well as handling cross‑database joins, distributed transactions, pagination, and ID generation.

Distributed TransactionsID generationSQL Tuning
0 likes · 12 min read
When and How to Apply Database Sharding: Practical Guidelines and Pitfalls
DataFunTalk
DataFunTalk
Nov 3, 2020 · Big Data

Xiaomi Growth Analytics System: Architecture Evolution and Doris Optimization

The article details Xiaomi's growth analytics platform evolution from a Lambda architecture using SparkSQL, Kudu, and HDFS to a streamlined MPP solution with Apache Doris, covering performance gains, real‑time data ingestion, query tuning, and operational improvements for large‑scale analytics.

Apache DorisOLAPReal-time Ingestion
0 likes · 20 min read
Xiaomi Growth Analytics System: Architecture Evolution and Doris Optimization
macrozheng
macrozheng
Aug 18, 2020 · Databases

Mastering MySQL Passive Performance Optimization: Principles & Practical Solutions

This article explains the core principles of performance optimization, distinguishes active and passive approaches, and provides detailed MySQL passive tuning techniques—including index usage, data partitioning, slow‑query logging, and read/write splitting—to prevent and resolve slow SQL queries.

Passive OptimizationSQL Tuningdatabase
0 likes · 14 min read
Mastering MySQL Passive Performance Optimization: Principles & Practical Solutions
Top Architect
Top Architect
Jun 7, 2020 · Databases

MySQL Performance Optimization: Data Volume, Concurrency, Index Design, and SQL Tuning

This article presents a comprehensive guide to MySQL performance improvement, covering maximum data volume, connection limits, query latency targets, practical implementation principles, optimal table design, index classification and tuning, as well as detailed SQL optimizations such as batch processing, operator rewriting, and pagination techniques.

Index OptimizationSQL Tuningmysql
0 likes · 16 min read
MySQL Performance Optimization: Data Volume, Concurrency, Index Design, and SQL Tuning
Aikesheng Open Source Community
Aikesheng Open Source Community
May 16, 2020 · Databases

Weekly Community Newsletter: MySQL Leads DB‑Engines May Ranking, DBLE & TXLE Updates, and MySQL Tips

This week’s community newsletter highlights the DB‑Engines May 2024 ranking where MySQL shows the highest growth, shares links to MySQL troubleshooting and performance articles, reports DBLE and TXLE development progress, bug fixes, community Q&A, and outlines upcoming plans for the open‑source middleware projects.

Community UpdatesDBLEDatabase Ranking
0 likes · 5 min read
Weekly Community Newsletter: MySQL Leads DB‑Engines May Ranking, DBLE & TXLE Updates, and MySQL Tips
Youzan Coder
Youzan Coder
Apr 29, 2020 · Databases

MySQL Slow Query Analysis: Root Causes and Optimization Strategies

The article examines why MySQL queries become slow, detailing system‑level issues such as network latency, I/O bottlenecks, and CPU settings, alongside database‑level problems like missing indexes, type conversion, poor execution plans, lock contention, skewed data, and inefficient SQL patterns, and offers optimization strategies.

Database PerformanceIndex OptimizationInnoDB
0 likes · 15 min read
MySQL Slow Query Analysis: Root Causes and Optimization Strategies
ITPUB
ITPUB
Dec 18, 2019 · Databases

Step‑by‑Step Guide to Upgrading Oracle Database 19c with Hands‑On Labs

This tutorial walks you through preparing a virtual‑machine environment, generating workload and AWR snapshots with HammerDB, capturing and exporting SQL tuning sets, performing a manual upgrade from Oracle 11.2 to 19c, and comparing performance before and after the upgrade, all with detailed commands and screenshots.

19cAWRDatabase Upgrade
0 likes · 12 min read
Step‑by‑Step Guide to Upgrading Oracle Database 19c with Hands‑On Labs
Java Captain
Java Captain
Mar 29, 2019 · Databases

MySQL Query Optimization: Indexing Strategies and Execution Plan Analysis

This article demonstrates how to dramatically improve MySQL query performance by analyzing execution plans, adding appropriate single‑column and composite indexes, converting subqueries to EXISTS or JOINs, and leveraging index coverage and ordering, with detailed examples and timing results.

Index OptimizationSQL Tuningexecution plan
0 likes · 12 min read
MySQL Query Optimization: Indexing Strategies and Execution Plan Analysis
ITPUB
ITPUB
Feb 24, 2018 · Databases

Essential Oracle Database Interview Questions and Answers: Tuning, Backup, Recovery, and Administration

This comprehensive guide covers Oracle SQL tuning techniques, execution‑plan inspection, optimizer choices, high‑resource SQL detection, session tracing, index fundamentals, backup classifications, recovery procedures, system monitoring, and performance diagnostics, providing practical knowledge for DBA interviews and daily work.

BackupDatabase AdministrationOracle
0 likes · 17 min read
Essential Oracle Database Interview Questions and Answers: Tuning, Backup, Recovery, and Administration
ITPUB
ITPUB
Jan 9, 2018 · Databases

Top 17 Oracle SQL Tuning Techniques to Boost Query Performance

This guide presents seventeen practical Oracle SQL optimization tips—including table order selection, WHERE clause ordering, avoiding SELECT *, reducing round‑trips, using DECODE, consolidating queries, eliminating duplicates, preferring TRUNCATE, leveraging COMMIT, replacing HAVING with WHERE, minimizing sub‑queries, employing internal functions, using aliases, favoring EXISTS over IN, detecting inefficient SQL, and proper index usage—to help developers write faster, more efficient database queries.

Database IndexesOracleQuery Planning
0 likes · 11 min read
Top 17 Oracle SQL Tuning Techniques to Boost Query Performance
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 22, 2017 · Databases

How Alibaba’s CloudDBA Transforms Database Optimization with AI and Automation

This article details Alibaba's CloudDBA system, explaining its business and user demands, architecture layers, SQL and space optimization techniques, data‑driven decision making, and ongoing AI‑based intelligent optimization research, illustrating how large‑scale database services are automated and self‑service for developers.

Data-drivenDatabase OptimizationIntelligent Diagnostics
0 likes · 24 min read
How Alibaba’s CloudDBA Transforms Database Optimization with AI and Automation
dbaplus Community
dbaplus Community
Jul 13, 2017 · Databases

How to Slash SQL Tuning Time: One‑Click Database Insights & Scripts

This article explains why SQL tuning often wastes hours, identifies common inefficiencies, and provides a step‑by‑step, one‑click method—including ready‑to‑run scripts—to collect full database performance data and detailed SQL information, dramatically speeding up problem resolution.

AWROracleSQL Tuning
0 likes · 13 min read
How to Slash SQL Tuning Time: One‑Click Database Insights & Scripts
Qunar Tech Salon
Qunar Tech Salon
May 24, 2017 · Databases

Common Scenarios Where SQL Fails to Use Indexes and How to Resolve Them

This article explains eight typical situations in which Oracle SQL statements cannot use indexes, illustrates each case with concrete examples and step‑by‑step rewrites, and offers practical solutions—including predicate adjustments, function indexes, and query‑transformation fixes—to improve database performance.

Database PerformanceIndex OptimizationOracle
0 likes · 12 min read
Common Scenarios Where SQL Fails to Use Indexes and How to Resolve Them
ITPUB
ITPUB
Apr 14, 2017 · Databases

Essential MySQL Optimization Techniques for High-Performance Databases

This guide outlines practical MySQL optimization strategies—including table schema design, index creation, SQL tuning, connection‑pool configuration, and historical data archiving—to help developers maintain fast, scalable databases as data volume grows.

Connection PoolDatabase OptimizationSQL Tuning
0 likes · 14 min read
Essential MySQL Optimization Techniques for High-Performance Databases
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Mar 9, 2017 · Databases

Master Greenplum Table Design & Performance Optimization: Practical Tips

This article explains what Greenplum is, its MPP shared‑nothing architecture, and provides concrete table‑design principles, distribution‑column strategies, indexing guidance, vacuum and table‑rebuilding techniques, as well as SQL, join, insert, update/delete, and resource‑queue optimizations for better performance.

Database designDistributed TablesGreenplum
0 likes · 9 min read
Master Greenplum Table Design & Performance Optimization: Practical Tips
dbaplus Community
dbaplus Community
Oct 18, 2016 · Databases

Mastering Oracle AWR: How to Decode and Optimize Database Performance

This comprehensive guide explains Oracle's Automatic Workload Repository (AWR), how snapshots are collected and retained, and provides step‑by‑step instructions for interpreting the most common AWR report sections, from cache sizes and load profiles to SQL statistics and RAC metrics, helping DBAs pinpoint bottlenecks and improve performance.

AWRDatabase PerformanceOracle
0 likes · 32 min read
Mastering Oracle AWR: How to Decode and Optimize Database Performance
ITPUB
ITPUB
Aug 12, 2016 · Databases

Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters

This article explains Oracle cursor concepts, details the key V$SQL and related views, highlights crucial columns for performance tuning, and describes important parameters such as open_cursor and cursor_sharing, helping DBAs optimize SQL execution and manage shared pool memory effectively.

CursorDatabase PerformanceOracle
0 likes · 13 min read
Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters
dbaplus Community
dbaplus Community
Aug 12, 2016 · Databases

Boost MySQL Performance: Data Types, Indexes, and SQL Optimization Techniques

This article walks through practical MySQL performance tuning from a developer's perspective, covering a real‑world example, data‑type selection, index design, and SQL query refinements, while providing concrete commands, visual illustrations, and expert Q&A for deeper understanding.

Data TypesDatabase OptimizationSQL Tuning
0 likes · 19 min read
Boost MySQL Performance: Data Types, Indexes, and SQL Optimization Techniques
ITPUB
ITPUB
Jul 28, 2016 · Databases

Oracle SQL Tuning Essentials: Joins, Execution Plans, CBO vs RBO, Backup Tips

This guide provides comprehensive Oracle database interview questions and answers covering SQL tuning techniques such as join types, execution‑plan inspection, CBO vs RBO, heavy‑SQL identification, session tracing, index structures, binding variables, plan stability, memory settings, tablespace management, backup and recovery methods including RMAN and standby, as well as system performance diagnostics.

CBODatabase BackupOracle
0 likes · 19 min read
Oracle SQL Tuning Essentials: Joins, Execution Plans, CBO vs RBO, Backup Tips
dbaplus Community
dbaplus Community
Nov 25, 2015 · Databases

Unlock Oracle SQL Monitor: Free Tool for Powerful SQL Optimization

This guide explains how to access and use Oracle SQL Monitor—a free feature in Oracle Enterprise Edition—to capture SQL execution details, analyze performance bottlenecks, compare estimated and actual rows, and apply targeted optimizations using both the EM console and command‑line scripts.

Database PerformanceOracleSQL Monitor
0 likes · 9 min read
Unlock Oracle SQL Monitor: Free Tool for Powerful SQL Optimization