BestHub
Sign in
Tagged articles
91 articles
Page 1 of 1
Ops Community
Ops Community
May 19, 2026 · Databases

10 Common MySQL Index Failure Scenarios – Which Ones Affect You?

This article examines ten typical situations where MySQL indexes become ineffective, explains the underlying reasons such as function usage, implicit type conversion, wildcard LIKE patterns, OR conditions, left‑most prefix violations, small tables, stale statistics, NULL handling, GROUP BY/DISTINCT, and ORDER BY, and provides concrete SQL examples and step‑by‑step remediation techniques to restore optimal query performance.

Database TuningIndex OptimizationSQL Performance
0 likes · 32 min read
10 Common MySQL Index Failure Scenarios – Which Ones Affect You?
ITPUB
ITPUB
May 1, 2026 · Databases

A DBA’s 3‑Night Deep Dive: Comprehensive Oracle I/O Performance Diagnosis and Hands‑On Tactics

The article walks through Oracle response‑time analysis, compares service and wait time, presents two real‑world cases (Statspack pre‑10g and AWR post‑10g) that show I/O waits often contribute less than 6% of total time, and then details step‑by‑step methods, parameters, and storage techniques for diagnosing and reducing I/O‑related performance problems.

ASMAWRDatabase Tuning
0 likes · 32 min read
A DBA’s 3‑Night Deep Dive: Comprehensive Oracle I/O Performance Diagnosis and Hands‑On Tactics
Architecture & Thinking
Architecture & Thinking
Apr 24, 2026 · Databases

SQL Index Failure Scenarios: Essential Pitfalls and Fixes Every Developer Must Know

This article systematically examines why MySQL indexes can become ineffective—covering function calls, implicit casts, LIKE patterns, OR conditions, composite‑index left‑most rules, data distribution, and ORDER/GROUP mismatches—while providing concrete code examples, production case studies, and actionable optimization techniques.

B+TreeDatabase TuningIndex Optimization
0 likes · 26 min read
SQL Index Failure Scenarios: Essential Pitfalls and Fixes Every Developer Must Know
dbaplus Community
dbaplus Community
Mar 26, 2026 · Databases

Six Fatal MySQL Index Traps and How to Avoid Them

A real‑world incident of soaring QPS reveals six common MySQL indexing pitfalls—type mismatches, function usage, left‑most prefix violations, implicit charset conversion, range query side effects, and optimizer mis‑selection—and provides concrete SQL fixes and verification tools to keep queries fast and reliable.

Database TuningIndex OptimizationQuery Pitfalls
0 likes · 6 min read
Six Fatal MySQL Index Traps and How to Avoid Them
MaGe Linux Operations
MaGe Linux Operations
Mar 4, 2026 · Databases

Master MySQL Performance: From Slow Query Analysis to Index Tuning

This guide walks through the full MySQL performance optimization workflow, covering slow‑query logging, pt‑query‑digest analysis, EXPLAIN interpretation, index design (including covering indexes and index‑condition pushdown), InnoDB buffer‑pool tuning, connection‑pool settings, real‑time diagnostics, monitoring metrics, and best‑practice recommendations for large‑scale production databases.

Database TuningIndex Optimizationmysql
0 likes · 22 min read
Master MySQL Performance: From Slow Query Analysis to Index Tuning
AntTech
AntTech
Jan 16, 2026 · Databases

Can Multi‑Agent Collaboration Automatically Tune Database Parameters with High Efficiency?

The paper presents CMA+DB, a hierarchical multi‑agent framework that automatically tunes database parameters across diverse workloads by combining classification‑based collaboration, layered training, and joint action selection, achieving superior performance, faster convergence, and strong generalization compared with existing tuning methods.

CMA+DBDatabase TuningPerformance Evaluation
0 likes · 9 min read
Can Multi‑Agent Collaboration Automatically Tune Database Parameters with High Efficiency?
Ray's Galactic Tech
Ray's Galactic Tech
Jan 8, 2026 · Databases

Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching

This guide presents a comprehensive, step‑by‑step roadmap for accelerating slow SQL queries without altering the original statements, covering index creation, database parameter tuning, table partitioning, caching layers, read‑write splitting, sharding, statistics updates, hardware choices, and middleware routing.

Database Tuningcachingindexes
0 likes · 8 min read
Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching
Ray's Galactic Tech
Ray's Galactic Tech
Dec 30, 2025 · Databases

Why MySQL Indexes Fail and 14 Proven Fixes for Faster Queries

This article explains how MySQL indexes work, enumerates eight common reasons they become ineffective, adds six advanced pitfalls, and provides concrete diagnostic steps and production‑grade optimization techniques to keep queries fast and reliable.

Database TuningIndex OptimizationQuery Planning
0 likes · 9 min read
Why MySQL Indexes Fail and 14 Proven Fixes for Faster Queries
Ray's Galactic Tech
Ray's Galactic Tech
Dec 9, 2025 · Databases

30 Essential MySQL Index Optimization Techniques You Must Know

This guide presents 30 practical MySQL index optimization techniques, covering creation principles, usage tips, performance enhancements, and maintenance strategies, with concrete SQL examples for each rule to help developers improve query efficiency and reduce write overhead.

Database TuningIndex OptimizationQuery Planning
0 likes · 9 min read
30 Essential MySQL Index Optimization Techniques You Must Know
Code Mala Tang
Code Mala Tang
Jul 3, 2025 · Databases

How We Achieved 50,000 TPS with PostgreSQL & Node.js: 6 Proven Optimizations

By systematically applying connection pooling, batch processing, WAL tuning, table partitioning, query refactoring, and OS-level tweaks, we transformed a PostgreSQL‑Node.js stack to sustain 50,000 transactions per second with sub‑100 ms latency, while maintaining data consistency on modest hardware.

Database TuningHigh ThroughputNode.js
0 likes · 10 min read
How We Achieved 50,000 TPS with PostgreSQL & Node.js: 6 Proven Optimizations
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 24, 2025 · Databases

Why MySQL 8.0 Table Rebuilds Slow Down and How to Fix It

MySQL 8.0 (especially versions 8.0.20+) suffers a performance regression in table‑rebuilding operations like ALTER TABLE … FORCE, running up to three times slower than 5.7 due to the default innodb_doublewrite_pages setting, but the issue can be mitigated by adjusting the parameter or upgrading to 8.4+.

ALTER TABLEDatabase TuningPerformance Regression
0 likes · 4 min read
Why MySQL 8.0 Table Rebuilds Slow Down and How to Fix It
Su San Talks Tech
Su San Talks Tech
May 27, 2025 · Databases

Why MySQL Picks the Wrong Index and How to Fix It

Learn how MySQL’s optimizer decides between indexes, why the same query can suddenly use a different index with dramatically slower performance, and practical steps—including analyzing execution plans, updating statistics, checking index coverage, and rebuilding fragmented indexes—to diagnose and resolve index selection issues.

Database TuningIndex Optimizationmysql
0 likes · 9 min read
Why MySQL Picks the Wrong Index and How to Fix It
Top Architecture Tech Stack
Top Architecture Tech Stack
May 10, 2025 · Databases

MySQL Query Optimization Guidelines and Best Practices

This article presents a comprehensive set of MySQL optimization techniques, covering the avoidance of SELECT *, proper use of specific fields, index-friendly query patterns, join strategies, handling of NULL and default values, efficient use of UNION, batch inserts, and numerous other performance‑enhancing tips for database developers.

Database TuningSQL Optimizationindexes
0 likes · 17 min read
MySQL Query Optimization Guidelines and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2025 · Databases

Using GDB to Adjust MySQL max_connections Without Restart

This article explains how to troubleshoot and resolve the MySQL "Too many connections" error by using GDB to modify the max_connections parameter on a running MySQL 5.7 instance without restarting, including step‑by‑step commands, sysbench load testing, and two practical methods.

Database TuningSysbenchgdb
0 likes · 9 min read
Using GDB to Adjust MySQL max_connections Without Restart
The Dominant Programmer
The Dominant Programmer
Mar 22, 2025 · Backend Development

Java Performance Optimization: From Basics to Mastery, Techniques to Make Your Code Fly

This article explains why Java performance matters, outlines fundamental principles, and provides concrete code, memory, concurrency, I/O, and database optimization techniques, along with profiling tools, common pitfalls, real‑world case studies, and emerging trends to help developers build faster, more stable applications.

Database TuningMemory ManagementProfiling Tools
0 likes · 8 min read
Java Performance Optimization: From Basics to Mastery, Techniques to Make Your Code Fly
Java Architecture Stack
Java Architecture Stack
Dec 23, 2024 · Databases

10 Real-World MySQL Subquery Optimizations to Boost Performance

This article explains why MySQL subqueries can hurt performance, outlines common pitfalls such as temporary tables, index loss, and optimizer complexity, and presents ten concrete examples that replace subqueries with IN, EXISTS, JOIN, indexes, temporary tables, window functions, and LIMIT to achieve faster, more maintainable queries.

Database TuningJOINSQL Performance
0 likes · 10 min read
10 Real-World MySQL Subquery Optimizations to Boost Performance
Eric Tech Circle
Eric Tech Circle
Aug 8, 2024 · Backend Development

How to Boost API Performance: Proven Strategies for Faster, Scalable Services

Facing tight schedules and diverse coding habits, many Chinese projects struggle with API latency; this guide walks through requirement analysis, acceptance standards, common pitfalls, and a comprehensive set of optimization tactics—from configuration and code tweaks to caching, async processing, and observability tools—to dramatically improve API performance.

API performanceDatabase TuningPerformance Testing
0 likes · 9 min read
How to Boost API Performance: Proven Strategies for Faster, Scalable Services
IT Services Circle
IT Services Circle
Jul 31, 2024 · Frontend Development

How to Diagnose and Fix Slow Web Page Performance

This comprehensive guide explains how to identify and resolve slow web page performance by addressing hardware resources, network configuration, and both front‑end and back‑end optimizations such as server upgrades, CDN usage, HTTP/2, image compression, code minification, caching, and efficient database queries.

CDNDatabase TuningFrontend Optimization
0 likes · 5 min read
How to Diagnose and Fix Slow Web Page Performance
Architects' Tech Alliance
Architects' Tech Alliance
Jul 13, 2024 · Operations

How to Supercharge Kunpeng CPUs: Real‑World Performance Tuning Techniques

This article provides a comprehensive guide to optimizing Kunpeng‑based servers, covering hardware characteristics, matrix multiplication benchmarks, Von Neumann architecture insights, soft and hard acceleration, compiler and JDK tweaks, NUMA tuning, Nginx and OpenSSL acceleration, disk and network optimizations, application‑level tuning, and a step‑by‑step MariaDB performance‑tuning checklist.

CPU performanceDatabase TuningHardware acceleration
0 likes · 16 min read
How to Supercharge Kunpeng CPUs: Real‑World Performance Tuning Techniques
ITPUB
ITPUB
Jul 3, 2024 · Databases

Why Skipping Secondary Indexes Can Speed Up MySQL Queries: A Real‑World Example

A client complained about a 35‑second MySQL query that ignored indexes; by analyzing column selectivity and rewriting the condition to use the auto‑increment primary key instead of a secondary index, the execution time dropped to 2.55 seconds, illustrating why primary‑key access is often faster.

Database TuningIndex OptimizationSQL Performance
0 likes · 5 min read
Why Skipping Secondary Indexes Can Speed Up MySQL Queries: A Real‑World Example
Wukong Talks Architecture
Wukong Talks Architecture
Jun 19, 2024 · Backend Development

Design and Optimization of a High‑Concurrency Lottery System

This article details how a large‑scale lottery service was architected and tuned for extreme traffic spikes by applying server‑side rate limiting, application‑level throttling, behavior‑based filtering, caching strategies, database optimizations, and hardware upgrades, resulting in a ten‑fold performance improvement.

Backend ArchitectureDatabase Tuninghigh concurrency
0 likes · 12 min read
Design and Optimization of a High‑Concurrency Lottery System
Lobster Programming
Lobster Programming
Apr 27, 2024 · Databases

Essential MySQL Optimization: SQL Tricks and Parameter Tuning

This guide covers practical MySQL performance improvements, detailing SQL-level optimizations such as limit pagination, proper LIKE usage, UNION ALL, EXISTS vs IN, TRUNCATE, batch inserts, early filtering, function placement, data type minimization, CHAR/VARCHAR choices, indexing strategies, force index, as well as server parameter tuning for buffer pool and redo log settings.

Database TuningSQL Optimizationmysql
0 likes · 10 min read
Essential MySQL Optimization: SQL Tricks and Parameter Tuning
JD Retail Technology
JD Retail Technology
Dec 12, 2023 · Databases

Common SQL Optimization Techniques for MySQL

This article reviews MySQL's execution process and presents a comprehensive list of practical SQL optimization strategies—including indexing, query rewriting, avoiding costly operators, using batch operations, and leveraging EXPLAIN—to improve database performance and maintainability.

Database TuningSQL Optimizationindexes
0 likes · 14 min read
Common SQL Optimization Techniques for MySQL
Sohu Tech Products
Sohu Tech Products
Dec 6, 2023 · Databases

GPTuner: LLM-Driven PostgreSQL Knob Tuning

GPTuner, an LLM‑driven system for PostgreSQL knob tuning developed by researchers at Sichuan University, demonstrates that knowledge processing, parameter selection, search‑range optimization, and a two‑stage Bayesian framework each significantly improve performance, while costing roughly 880 000 GPT‑4 tokens (≈ $30) with reusable knowledge.

Ablation StudyDatabase TuningGPTuner
0 likes · 9 min read
GPTuner: LLM-Driven PostgreSQL Knob Tuning
MaGe Linux Operations
MaGe Linux Operations
Nov 21, 2023 · Databases

Boost MySQL Performance: 10 Proven Optimization Techniques

This guide presents ten practical MySQL performance optimization methods—including index creation, query rewriting, limiting result sets, avoiding SELECT *, reducing joins, using proper data types, caching with Redis, and server configuration tweaks—each illustrated with concrete SQL code examples to help you speed up your database operations.

Database Tuningmysqlperformance optimization
0 likes · 11 min read
Boost MySQL Performance: 10 Proven Optimization Techniques
Laravel Tech Community
Laravel Tech Community
Nov 6, 2023 · Databases

MySQL InnoDB Configuration Parameters and Optimization Guide

This article explains how to tune MySQL's InnoDB settings—including buffer pool size, log file configuration, I/O threads, flush behavior, and timeout values—by providing detailed explanations and exact configuration snippets to improve performance and resource usage.

ConfigurationDatabase TuningInnoDB
0 likes · 7 min read
MySQL InnoDB Configuration Parameters and Optimization Guide
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 25, 2023 · Databases

Unlock GaussDB(DWS) Performance: Expert Tips for Resource Management

This announcement introduces Huawei Cloud’s DTT live session on August 29, where expert Lv Pengbo will explain GaussDB(DWS) resource control principles and demonstrate practical techniques—such as CPU usage analysis, memory tuning, and queue issue resolution—to help developers efficiently manage data‑warehouse resources and boost performance.

Database TuningGaussDBHuawei Cloud
0 likes · 3 min read
Unlock GaussDB(DWS) Performance: Expert Tips for Resource Management
Su San Talks Tech
Su San Talks Tech
Jul 8, 2023 · Databases

Master MySQL Index Optimization: 20 Proven Rules to Boost Query Performance

This comprehensive guide explains 20 practical MySQL index optimization rules—including when NOT to use indexes, how to choose the right index type, and techniques such as prefix indexes, covering indexes, and query rewriting—to dramatically improve SQL query efficiency and reduce database load.

Database TuningIndex OptimizationSQL Performance
0 likes · 19 min read
Master MySQL Index Optimization: 20 Proven Rules to Boost Query Performance
Java Backend Technology
Java Backend Technology
Jun 21, 2023 · Databases

How to Supercharge MySQL Queries: 9 Proven Optimization Techniques

This article walks through nine common MySQL performance pitfalls—such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, intermediate result push‑down, and more—showing how to rewrite each query and its execution plan to achieve dramatic speed improvements.

Database TuningSQL Optimizationmysql
0 likes · 14 min read
How to Supercharge MySQL Queries: 9 Proven Optimization Techniques
Sohu Tech Products
Sohu Tech Products
Apr 12, 2023 · Databases

MySQL Query Optimization Strategies: Pagination, Joins, Subqueries, Sorting, Group By, and Count

This article presents practical MySQL query optimization techniques—including pagination, index‑based join improvements, subquery replacement with joins, order‑by and group‑by indexing, and count() efficiency—illustrated with real‑world examples, execution‑plan analysis, and ready‑to‑run SQL code.

Database TuningSQL Optimizationindexing
0 likes · 11 min read
MySQL Query Optimization Strategies: Pagination, Joins, Subqueries, Sorting, Group By, and Count
dbaplus Community
dbaplus Community
Oct 24, 2022 · Databases

Mastering MySQL Slow Query Optimization: Practical Strategies from Ctrip

Facing a surge in MySQL slow queries, Ctrip’s senior database engineers detail a comprehensive approach—including refined SQL release processes, deep execution‑plan analysis, index tuning, query rewriting, and resource management—to systematically identify, diagnose, and eliminate performance bottlenecks in large‑scale hotel services.

Database TuningIndex OptimizationSQL Performance
0 likes · 14 min read
Mastering MySQL Slow Query Optimization: Practical Strategies from Ctrip
Efficient Ops
Efficient Ops
Jul 20, 2022 · Databases

How Indexes Can Speed Up MySQL Queries by Tens of Thousands of Times

This article walks through a MySQL scenario where a nested sub‑query runs for hours, demonstrates how adding single‑column and multi‑column indexes, rewriting the query as a join, and analyzing execution plans can reduce execution time from thousands of seconds to a few milliseconds.

Database TuningIndex Optimizationmysql
0 likes · 12 min read
How Indexes Can Speed Up MySQL Queries by Tens of Thousands of Times
Qunar Tech Salon
Qunar Tech Salon
Mar 30, 2022 · Databases

Understanding and Optimizing PostgreSQL VACUUM and AUTOVACUUM

This article explains the purpose and mechanics of PostgreSQL's VACUUM and AUTOVACUUM processes, demonstrates practical examples of table bloat, transaction ID handling, and provides step‑by‑step guidance for precise triggering and performance optimization of vacuum operations.

AUTOVACUUMDatabase TuningVacuum
0 likes · 37 min read
Understanding and Optimizing PostgreSQL VACUUM and AUTOVACUUM
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 13, 2021 · Databases

Why MySQL Performance Benchmark Shows Low TPS on High-End Hardware

This article examines why MySQL benchmark results often show low transactions per second on seemingly powerful servers, exploring hidden factors such as network bottlenecks, SSL overhead, and inappropriate sort_buffer_size settings, and provides practical troubleshooting steps and configuration tweaks to achieve optimal performance.

Database TuningNetwork BottleneckSSL
0 likes · 10 min read
Why MySQL Performance Benchmark Shows Low TPS on High-End Hardware
IT Architects Alliance
IT Architects Alliance
Dec 12, 2021 · Operations

System Performance Issue Analysis and Optimization Process for Business Applications

The article outlines a comprehensive process for diagnosing and optimizing performance problems in production business systems, covering causes such as high concurrency, data growth, hardware constraints, and detailing analysis of hardware, OS, database, middleware, JVM settings, code inefficiencies, and the role of monitoring and APM tools.

BackendDatabase TuningJVM
0 likes · 13 min read
System Performance Issue Analysis and Optimization Process for Business Applications
IT Architects Alliance
IT Architects Alliance
Nov 20, 2021 · Operations

Analysis and Optimization of Business System Performance

This article outlines a comprehensive approach to diagnosing and optimizing performance problems in production business systems, covering analysis processes, hardware, OS, database, middleware, JVM tuning, code inefficiencies, and monitoring techniques to identify root causes and improve system reliability.

Database TuningOperationsSystem optimization
0 likes · 16 min read
Analysis and Optimization of Business System Performance
Xiaolei Talks DB
Xiaolei Talks DB
Sep 4, 2021 · Databases

Mastering TiDB Performance: Layered and Scenario‑Based Optimization Strategies

This article explores TiDB performance optimization by examining layered approaches—hardware, software, and SQL—and scenario‑specific tactics such as read/write hotspot handling, OLAP challenges, and distributed transaction tuning, offering practical insights and real‑world case studies from industry experts.

Database TuningHardwareTiDB
0 likes · 7 min read
Mastering TiDB Performance: Layered and Scenario‑Based Optimization Strategies
Big Data Technology Architecture
Big Data Technology Architecture
Jun 16, 2021 · Big Data

HBase Read and Write Performance Optimization Guide

This guide details practical server‑side and client‑side techniques for improving HBase read and write throughput, covering rowkey design, BlockCache configuration, HFile management, compaction tuning, scan cache sizing, bulkload usage, WAL policies, and SSD storage options.

Database TuningHBaseread optimization
0 likes · 8 min read
HBase Read and Write Performance Optimization Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 2, 2021 · Databases

How MySQL Adjusts open_files_limit, max_connections, and table_open_cache When System Resources Are Insufficient

This article explains how MySQL, when run by a non‑root user with limited system resources, automatically adjusts the open_files_limit, max_connections, and table_open_cache parameters by calculating required file descriptors, comparing them to system limits, and correcting the configuration values accordingly.

ConfigurationDatabase Tuningmax_connections
0 likes · 6 min read
How MySQL Adjusts open_files_limit, max_connections, and table_open_cache When System Resources Are Insufficient
Code Ape Tech Column
Code Ape Tech Column
Jan 20, 2021 · Databases

Why Does MySQL Pick the Wrong Index? A Deep Dive into Query Optimization

This article examines a slow MySQL query that scans millions of rows, explains why the optimizer chose a low‑selectivity index, demonstrates how forcing the correct index dramatically improves performance, and shows how to create a covering composite index to resolve the issue permanently.

Database TuningExplain PlanIndex Optimization
0 likes · 8 min read
Why Does MySQL Pick the Wrong Index? A Deep Dive into Query Optimization
Architecture Digest
Architecture Digest
Jan 17, 2021 · Operations

System Performance Issue Analysis and Optimization Process

This article outlines a comprehensive process for diagnosing and optimizing performance problems in production business systems, covering hardware, OS, database, middleware, JVM tuning, code inefficiencies, monitoring tools, and the limitations of pre‑release testing, with practical guidelines and visual references.

APMDatabase TuningSystem optimization
0 likes · 16 min read
System Performance Issue Analysis and Optimization Process
ITPUB
ITPUB
Jan 13, 2021 · Operations

How to Diagnose and Optimize Business System Performance Issues

This article outlines a step‑by‑step approach for identifying root causes of performance bottlenecks in production business systems, covering common scenarios such as high concurrency, data growth, hardware limits, database and middleware tuning, code inefficiencies, and the role of monitoring and APM tools.

APMDatabase TuningJVM
0 likes · 15 min read
How to Diagnose and Optimize Business System Performance Issues
Java Interview Crash Guide
Java Interview Crash Guide
Jan 12, 2021 · Databases

Boost MySQL Query Speed: Index Tricks, Join vs Subquery, and Execution Plan Hacks

This article walks through a MySQL 5.6 case study where a nested sub‑query for finding students scoring 100 in a specific subject runs for hours, then demonstrates how adding single‑column and composite indexes, rewriting the query as a join, and analyzing execution plans can shrink the runtime from tens of thousands of seconds to under a second.

Database TuningIndex OptimizationQuery Planning
0 likes · 11 min read
Boost MySQL Query Speed: Index Tricks, Join vs Subquery, and Execution Plan Hacks
Big Data Technology & Architecture
Big Data Technology & Architecture
Jan 7, 2021 · Databases

Comprehensive HBase Optimization Guide: Table Design, RowKey, JVM Tuning, Cache Settings, and Read/Write Performance

This article provides a detailed, practical guide to optimizing HBase in production, covering table pre‑splitting, RowKey design, JVM memory and GC settings, MSLAB and BucketCache configuration, read‑side client and server tuning, write‑side strategies, and additional tips such as compression and scan caching.

CacheDatabase TuningHBase
0 likes · 29 min read
Comprehensive HBase Optimization Guide: Table Design, RowKey, JVM Tuning, Cache Settings, and Read/Write Performance
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
Top Architect
Top Architect
May 21, 2020 · Backend Development

Comprehensive Guide to Java Application Performance Optimization and Diagnosis

This article provides an in‑depth overview of Java application performance optimization, covering a four‑layer model (application, database, framework, JVM), on‑site and post‑mortem analysis methods, OS and JVM diagnostic tools, common code and GC issues, database deadlock handling, and practical tuning recommendations.

Database TuningJVMdiagnostics
0 likes · 23 min read
Comprehensive Guide to Java Application Performance Optimization and Diagnosis
Top Architect
Top Architect
May 7, 2020 · Backend Development

Comprehensive Guide to Java Application Performance Optimization and Diagnosis

This article presents a thorough overview of Java application performance optimization, covering a four‑layer model (application, database, framework, JVM), practical OS and Java diagnostic tools, JVM and GC tuning, application‑level code improvements, and database deadlock mitigation strategies.

Database TuningJVMdiagnostics
0 likes · 21 min read
Comprehensive Guide to Java Application Performance Optimization and Diagnosis
Senior Brother's Insights
Senior Brother's Insights
Mar 31, 2020 · Databases

Boost Redis Performance: 13 Proven Optimization Techniques

Learn how to dramatically improve Redis performance by shortening key-value sizes, enabling lazy free, setting expirations, disabling costly commands, using slowlog, leveraging pipeline, preventing mass expirations, optimizing client connections, limiting memory, running on physical servers, configuring persistence, disabling THP, and adopting distributed architectures.

Database TuningLazy FreeMemory Management
0 likes · 18 min read
Boost Redis Performance: 13 Proven Optimization Techniques
Java Captain
Java Captain
Mar 31, 2020 · Databases

Optimizing Large MySQL Tables: Indexes, Partitioning, Sharding, and System Tuning

When a MySQL table grows to millions of rows, query, insert, update and delete performance degrades sharply, but by applying proper field design, index strategies, SQL best practices, engine selection, system parameters, caching, partitioning, vertical and horizontal sharding, and choosing suitable client‑side or proxy‑side architectures, the database can efficiently handle tens of millions of records.

Database TuningPartitioningmysql
0 likes · 24 min read
Optimizing Large MySQL Tables: Indexes, Partitioning, Sharding, and System Tuning
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 10, 2020 · Backend Development

Comprehensive Strategies for Designing High‑Concurrency Systems

The article outlines five key layers—front‑end optimization, middle‑layer load distribution, gateway control, service‑layer improvements, and database tuning—detailing practical techniques such as static resource caching, Nginx load‑balancing methods, request rate limiting, message‑queue buffering, and extensive MySQL best‑practice guidelines to build robust high‑concurrency architectures.

Database TuningSystem Designbackend optimization
0 likes · 7 min read
Comprehensive Strategies for Designing High‑Concurrency Systems
Architecture Digest
Architecture Digest
Dec 15, 2019 · Databases

MongoDB High‑Throughput Cluster Optimization: Software, Configuration, and Storage Engine Tuning

This article details how a high‑traffic MongoDB sharded cluster exceeding one million TPS was optimized through software‑level tweaks, configuration changes, WiredTiger storage‑engine tuning, and hardware upgrades, resulting in latency reductions from hundreds of milliseconds to a few milliseconds and significantly improved stability.

Database TuningIO optimizationMongoDB
0 likes · 33 min read
MongoDB High‑Throughput Cluster Optimization: Software, Configuration, and Storage Engine Tuning
360 Tech Engineering
360 Tech Engineering
Aug 19, 2019 · Backend Development

PHP Interface Performance Optimization: Diagnosis Methods and Practical Solutions

This article shares practical experiences on diagnosing PHP interface performance bottlenecks using ThinkPHP's G function and profiling tools like Xhprof, then presents concrete code‑level, database‑level, and hardware‑level optimization techniques to improve execution speed and reduce resource consumption.

Code OptimizationDatabase TuningPHP
0 likes · 9 min read
PHP Interface Performance Optimization: Diagnosis Methods and Practical Solutions
Tencent Database Technology
Tencent Database Technology
Jul 8, 2019 · Databases

SIGMOD 2019 Highlights: Blockchain Keynote, CDBTune Paper on Cloud Database Tuning, and Emerging Database Research

The report summarizes SIGMOD/PODS 2019 in Amsterdam, covering a blockchain-focused keynote, the CDBTune paper on end‑to‑end automatic cloud database tuning using deep reinforcement learning, modern hardware research, award‑winning systems, and related industry activities, providing a comprehensive academic overview.

Database TuningResearch HighlightsSIGMOD
0 likes · 7 min read
SIGMOD 2019 Highlights: Blockchain Keynote, CDBTune Paper on Cloud Database Tuning, and Emerging Database Research
ITPUB
ITPUB
Jul 8, 2019 · Databases

How to Supercharge MySQL Queries with Index Optimization: A Step‑by‑Step Guide

This article walks through a real‑world MySQL scenario, showing how a slow sub‑query can be accelerated by adding single‑column indexes, converting the query to a join, and finally creating a composite index, with performance numbers and execution‑plan analysis to illustrate each optimization step.

Database TuningIndex OptimizationSQL Performance
0 likes · 11 min read
How to Supercharge MySQL Queries with Index Optimization: A Step‑by‑Step Guide
360 Tech Engineering
360 Tech Engineering
Feb 20, 2019 · Databases

Pika Best Practices: 30 Tips for Optimizing the RocksDB‑Based Redis‑Compatible Storage

This article presents thirty practical recommendations for deploying, configuring, and maintaining Pika—a high‑capacity, RocksDB‑backed Redis‑compatible storage system—covering version selection, thread settings, hardware choices, key design, memory management, replication, backup, compaction, security, and monitoring to achieve reliable and high‑performance operation.

Database TuningOperationsPika
0 likes · 16 min read
Pika Best Practices: 30 Tips for Optimizing the RocksDB‑Based Redis‑Compatible Storage
dbaplus Community
dbaplus Community
Jan 21, 2019 · Databases

52 Proven SQL Performance Optimization Tips to Supercharge Your Queries

This article compiles 52 practical SQL performance optimization strategies—including indexing best practices, query rewriting, use of temporary tables, storage engine selection, data type choices, backup procedures, and diagnostic tools—to help developers write faster, more efficient database queries.

Database Tuningindexingmysql
0 likes · 23 min read
52 Proven SQL Performance Optimization Tips to Supercharge Your Queries
ITPUB
ITPUB
Nov 27, 2018 · Databases

Boost MySQL Performance: Field Types, JOIN vs Subqueries, UNION, and Transactions

This guide presents four practical MySQL performance‑boosting techniques—selecting optimal column types, replacing sub‑queries with JOINs, using UNION instead of temporary tables, and employing transactions with BEGIN/COMMIT/ROLLBACK—to make queries faster and ensure data integrity.

Database TuningJOINTransactions
0 likes · 6 min read
Boost MySQL Performance: Field Types, JOIN vs Subqueries, UNION, and Transactions
21CTO
21CTO
Nov 9, 2018 · Backend Development

How Meituan Optimized High‑Traffic Backend Performance: Real‑World Strategies and Case Studies

This article shares Meituan's practical performance‑optimization techniques—including code analysis, database tuning, caching strategies, asynchronous processing, JVM adjustments, multithreading, and monitoring—illustrated with real case studies that reduced job runtimes from over 40 minutes to under 15 minutes.

Database Tuningasynchronous processingcaching
0 likes · 25 min read
How Meituan Optimized High‑Traffic Backend Performance: Real‑World Strategies and Case Studies
dbaplus Community
dbaplus Community
Sep 24, 2018 · Databases

Master MySQL Performance: Practical Optimizations for Large Tables

This guide explains why MySQL performance drops when a single table grows huge and provides a comprehensive set of optimization steps—including field type choices, index design, query tuning, engine selection, system parameters, hardware scaling, read/write splitting, caching, partitioning, vertical and horizontal sharding, and architecture recommendations—to keep MySQL fast and reliable at scale.

Database TuningSystem Parameterscaching
0 likes · 24 min read
Master MySQL Performance: Practical Optimizations for Large Tables
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Aug 15, 2018 · Backend Development

Comprehensive Performance Optimization Guide: Web, Database, Caching, Asynchronous Processing, and JVM Tuning

This guide outlines a complete performance optimization strategy covering web front‑end tuning (reducing HTTP requests, compressing assets, avoiding redirects), database optimization (SQL, architecture, connection pools), caching solutions, asynchronous processing, and JVM tuning with monitoring tools to improve overall system efficiency.

Database TuningJVMWeb Development
0 likes · 9 min read
Comprehensive Performance Optimization Guide: Web, Database, Caching, Asynchronous Processing, and JVM Tuning
ITPUB
ITPUB
Jul 5, 2018 · Databases

Mastering Oracle Cursors: Views, Parameters, and Performance Tuning

This article explains Oracle cursor concepts, the key V$SQL and V$SQLAREA views with their most important columns for tuning, how open‑cursor limits and the CURSOR_SHARING parameter affect execution plan sharing, and provides practical guidance for DBA performance optimization.

CursorDatabase TuningOpen Cursor
0 likes · 14 min read
Mastering Oracle Cursors: Views, Parameters, and Performance Tuning
ITFLY8 Architecture Home
ITFLY8 Architecture Home
May 8, 2018 · Databases

21 Essential MySQL Performance Tips Every Developer Should Know

This article presents a comprehensive set of MySQL optimization techniques—including query‑cache tuning, proper use of EXPLAIN, indexing strategies, avoiding costly functions, and leveraging prepared statements—to help developers eliminate database bottlenecks and boost web‑application performance.

Database Tuningindexesmysql
0 likes · 21 min read
21 Essential MySQL Performance Tips Every Developer Should Know
ITPUB
ITPUB
Feb 26, 2018 · Databases

15 Common SQL Performance Pitfalls and Proven Fixes

This article outlines the most frequent SQL performance mistakes—such as misusing UPDATE, over‑selecting columns, unnecessary double queries, and improper use of GUIDs—and provides concrete, actionable techniques like CASE expressions, temporary tables, batch operations, and table‑valued functions to dramatically improve query speed and concurrency.

Database TuningSQL Serverbest practices
0 likes · 14 min read
15 Common SQL Performance Pitfalls and Proven Fixes
ITPUB
ITPUB
Oct 13, 2017 · Databases

Boost MySQL Performance: Hardware, OS, and Configuration Tweaks

This guide details practical MySQL performance enhancements across hardware BIOS settings, disk I/O choices, filesystem and kernel tuning, and MySQL configuration—including version selection, key innodb parameters, schema design rules, and operational best‑practices—to achieve substantial IOPS and query speed gains.

Database Tuningmysqloptimization
0 likes · 14 min read
Boost MySQL Performance: Hardware, OS, and Configuration Tweaks
21CTO
21CTO
Mar 5, 2017 · Backend Development

How to Optimize LNMP Architecture for High‑Performance Web Services

This article outlines practical strategies for optimizing the LNMP stack—including load balancing, server tuning, caching, and database improvements—to enhance performance, scalability, and reliability of web applications across various programming languages.

BackendDatabase TuningLNMP
0 likes · 4 min read
How to Optimize LNMP Architecture for High‑Performance Web Services
ITPUB
ITPUB
Feb 19, 2017 · Databases

Turning an 89ms Query into 0ms: Real‑World SQL Server Index Optimization

The article recounts a performance bottleneck in a Windows service that processed only about 12 records per second, analyzes why a simple SELECT TOP 1 query without proper indexes caused 89 ms latency, and demonstrates step‑by‑step how adding appropriate clustered and non‑clustered indexes reduced the execution time to virtually zero, while also discussing broader indexing strategies and common LEFT JOIN pitfalls.

Clustered IndexDatabase TuningIndex Optimization
0 likes · 9 min read
Turning an 89ms Query into 0ms: Real‑World SQL Server Index Optimization
ITPUB
ITPUB
Feb 13, 2017 · Databases

Master Oracle Database Performance: 10 Proven Tuning Strategies

This guide presents comprehensive Oracle database performance optimization techniques—including data structure design, application architecture, SQL tuning, memory and CPU adjustments, I/O balancing, and essential tools—providing actionable steps and example queries for DBAs to improve system responsiveness and efficiency.

CPUDatabase TuningOracle
0 likes · 13 min read
Master Oracle Database Performance: 10 Proven Tuning Strategies
ITPUB
ITPUB
Jan 25, 2017 · Databases

Master Oracle Hit Ratios and Memory Tuning with Practical SQL Queries

This guide explains how to calculate and interpret key Oracle hit ratios—including library cache, shared pool, buffer cache, data buffer, sort memory, and PGA—provides exact SQL statements for each metric, and offers tuning thresholds and actions to improve database performance.

Database TuningHit RatioMemory Management
0 likes · 7 min read
Master Oracle Hit Ratios and Memory Tuning with Practical SQL Queries
Practical DevOps Architecture
Practical DevOps Architecture
Dec 8, 2016 · Databases

SQL Query Optimization Tips and Best Practices

This article presents a comprehensive collection of practical SQL performance tuning guidelines, covering index usage, query rewriting, avoiding costly operators, proper data types, efficient joins, and view creation to help developers write faster, more resource‑efficient database queries.

Database Tuningindexesperformance
0 likes · 11 min read
SQL Query Optimization Tips and Best Practices
ITPUB
ITPUB
Jun 17, 2016 · Databases

Why Do Oracle Buffer Busy Waits Occur and How to Resolve Them?

The article explains the internal steps Oracle follows to acquire buffers, identifies the conditions that trigger buffer busy waits such as hot blocks and freelist limits, and provides practical tuning methods and diagnostic SQL queries to mitigate these performance issues.

Database TuningOraclebuffer busy waits
0 likes · 10 min read
Why Do Oracle Buffer Busy Waits Occur and How to Resolve Them?
dbaplus Community
dbaplus Community
May 4, 2016 · Databases

Choosing Percona, MariaDB or MySQL and Proven MySQL Tuning & HA Strategies

This guide compares Percona Server, MariaDB, and MySQL, outlines practical MySQL performance tuning steps across hardware, storage, filesystem, and server parameters, and presents several high‑availability architectures such as master‑slave replication, MMM/MHA, Heartbeat/SAN, and Heartbeat/DRBD with real‑world deployment examples.

Database TuningMariaDBPercona
0 likes · 9 min read
Choosing Percona, MariaDB or MySQL and Proven MySQL Tuning & HA Strategies
dbaplus Community
dbaplus Community
Dec 8, 2015 · Databases

Can PCIe Flash Cut Oracle Redo Log Sync Waits? 4K Log Test Results

This article examines Oracle's guidance on placing redo logs on SSDs, explains sector size and 4K redo log support, describes a controlled experiment comparing PCIe flash cards with SAS disks using TPCC workloads, and presents performance data showing reduced log‑file‑sync waits and higher throughput on flash storage.

4K BlocksizeDatabase TuningOracle
0 likes · 12 min read
Can PCIe Flash Cut Oracle Redo Log Sync Waits? 4K Log Test Results
Java High-Performance Architecture
Java High-Performance Architecture
Oct 15, 2015 · Databases

Master MySQL Cache Settings: Key Buffers, Table Cache, and More

This guide explains the essential MySQL cache parameters—including key_buffer_size, table_cache, sort_buffer_size, read_buffer_size, join_buffer_size, thread_cache_size, query_cache_size, and tmp_table_size—detailing their impact on performance and providing recommended values based on server memory to help DBAs optimize MyISAM and InnoDB workloads.

CacheConfigurationDatabase Tuning
0 likes · 4 min read
Master MySQL Cache Settings: Key Buffers, Table Cache, and More
dbaplus Community
dbaplus Community
Sep 30, 2015 · Databases

Essential Oracle Database Parameter Tuning: Hidden Risks and Performance Boosts

Expert DBAs discuss critical Oracle 11.2.0.4 parameters to watch before production, covering generic, performance, deprecated, and OS‑level settings for AIX and Linux, with concrete examples such as shared pool sub‑pools, mutex tuning, cursor thresholds, and real‑world incidents like streams_pool_size misconfiguration.

AIXDatabase TuningLinux
0 likes · 13 min read
Essential Oracle Database Parameter Tuning: Hidden Risks and Performance Boosts
21CTO
21CTO
Sep 12, 2015 · Databases

Master MySQL Optimization: Practical Tips for Performance, Hardware, and Schema

This comprehensive guide explores MySQL's unique characteristics, hardware and OS tuning, configuration tweaks, schema and SQL optimization techniques, and provides actionable recommendations and tools to identify and resolve common performance bottlenecks.

Database TuningHardware Configurationmysql
0 likes · 13 min read
Master MySQL Optimization: Practical Tips for Performance, Hardware, and Schema
Efficient Ops
Efficient Ops
Jul 14, 2015 · Databases

Master MySQL Performance: Practical Optimization Strategies & FAQs

This article compiles expert insights from a high‑efficiency operations forum, covering MySQL performance optimization techniques such as read‑write separation, sharding, schema and parameter tuning, hardware and SSD enhancements, as well as a detailed FAQ addressing replication lag, Aurora challenges, and backup tools.

Database TuningHardware OptimizationRead-Write Separation
0 likes · 12 min read
Master MySQL Performance: Practical Optimization Strategies & FAQs