BestHub
Sign in
Tagged articles
986 articles
Page 5 of 10
Aikesheng Open Source Community
Aikesheng Open Source Community
May 15, 2023 · Databases

Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques

The article investigates why pure‑read QPS drops significantly after bulk updates in OceanBase, reproduces the issue with a sysbench workload, analyses flame‑graph and SQL audit data, explains the LSM‑Tree read‑amplification mechanism, and proposes practical mitigation steps such as major freeze, plan binding, index creation, and the queuing‑table feature.

LSM‑TreeMajor FreezeOceanBase
0 likes · 16 min read
Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques
MaGe Linux Operations
MaGe Linux Operations
May 5, 2023 · Operations

Boost Your NGINX Performance: 8 Proven Tuning Tips

This guide explains how to optimize NGINX on Linux by adjusting worker processes, connection limits, GZIP compression, timeout values, buffer sizes, log handling, static content caching, and open file caching, providing step‑by‑step commands and configuration snippets for maximum server efficiency.

LinuxOptimizationPerformance tuning
0 likes · 8 min read
Boost Your NGINX Performance: 8 Proven Tuning Tips
dbaplus Community
dbaplus Community
May 2, 2023 · Databases

How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained

This article explains why MySQL slave lag is a critical issue, compares the official parallel replication schemes—including Commit‑Parent‑Based, Lock‑Based, and WRITESET—details their internal mechanisms, presents benchmark results, and provides the exact configuration parameters needed to enable high‑performance parallel replication.

Group CommitMySQLPerformance tuning
0 likes · 17 min read
How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained
Liangxu Linux
Liangxu Linux
Apr 26, 2023 · Operations

Essential Linux Ops Practices to Prevent Disasters

Drawing from years of sysadmin experience, this guide lists concrete Linux operational habits—such as rigorous backups, cautious use of rm‑rf, single‑person changes, SSH hardening, firewall rules, monitoring, and disciplined performance tuning—to help teams avoid costly production failures.

LinuxPerformance tuningSecurity
0 likes · 12 min read
Essential Linux Ops Practices to Prevent Disasters
ITPUB
ITPUB
Apr 24, 2023 · Databases

Master PostgreSQL Performance: From Hardware to Query Tuning

Effective PostgreSQL performance tuning requires a holistic approach, covering hardware sizing, OS sysctl tweaks, filesystem choices, query and schema design, key PostgreSQL parameters, concurrency settings, cache management, and careful scheduling of automated maintenance tasks to avoid resource conflicts.

OS ConfigurationPerformance tuningPostgreSQL
0 likes · 10 min read
Master PostgreSQL Performance: From Hardware to Query Tuning
Architecture Digest
Architecture Digest
Apr 23, 2023 · Backend Development

Kafka Core Concepts, Architecture, Performance Optimizations, and Production Deployment Guide

This article provides a comprehensive technical overview of Kafka, covering its core message‑queue value, architecture components such as producers, consumers, topics, partitions and replication, high‑performance mechanisms like zero‑copy and OS cache, resource planning for disks, memory, CPU and network, operational tools and commands, consumer‑group management, rebalance strategies, and internal scheduling mechanisms such as the time‑wheel.

Backend ArchitectureDistributed SystemsKafka
0 likes · 30 min read
Kafka Core Concepts, Architecture, Performance Optimizations, and Production Deployment Guide
JD Tech
JD Tech
Apr 18, 2023 · Backend Development

Case Study: Long GC Times Caused by Database Connection Pool Issues and Mitigation Strategies

This article analyzes a production incident where excessive Full GC pauses during a high‑traffic promotion were traced to stale database connections in the DBCP pool, explains the investigation steps, root cause, and presents several JVM and connection‑pool configuration solutions to prevent similar performance degradations.

Database Connection PoolJVMPerformance tuning
0 likes · 8 min read
Case Study: Long GC Times Caused by Database Connection Pool Issues and Mitigation Strategies
Liangxu Linux
Liangxu Linux
Apr 11, 2023 · Operations

Master Linux Performance Tuning: Practical Steps for Faster Systems

This guide explains why Linux performance depends on both hardware and software, outlines key factors such as CPU, memory, disk I/O, network, OS installation, kernel parameters, file systems, and application design, and provides a step‑by‑step process for administrators, architects, and developers to diagnose and optimize system speed.

HardwareLinuxOptimization
0 likes · 16 min read
Master Linux Performance Tuning: Practical Steps for Faster Systems
Selected Java Interview Questions
Selected Java Interview Questions
Mar 29, 2023 · Backend Development

JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Node

This article presents a comprehensive, step‑by‑step guide on estimating capacity, selecting and configuring garbage collectors, sizing heap, young and survivor spaces, tuning thread stacks, and adding diagnostic options for a Java service that must handle one million login requests per day on a server with 8 GB of memory.

CMSG1Garbage Collection
0 likes · 26 min read
JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Node
Top Architect
Top Architect
Mar 27, 2023 · Big Data

Kafka Architecture, Performance Optimization, and Production Deployment Guide

This article provides a comprehensive overview of Kafka’s core concepts, high‑performance design, cluster planning, resource evaluation, deployment steps, producer and consumer configurations, fault‑tolerance mechanisms, and operational tools, offering practical guidance for building and managing a high‑throughput Kafka production environment.

Cluster DeploymentConsumerDistributed Systems
0 likes · 31 min read
Kafka Architecture, Performance Optimization, and Production Deployment Guide
Java Backend Technology
Java Backend Technology
Mar 24, 2023 · Backend Development

Optimizing JVM Settings for 1M Daily Logins on an 8GB Server

This article walks through a step‑by‑step approach to sizing JVM heap, young generation, GC selection, and related parameters for a platform handling one million login requests per day on a node with 8 GB memory, providing practical formulas, example configurations, and tuning tips.

Garbage CollectionJVMJava
0 likes · 24 min read
Optimizing JVM Settings for 1M Daily Logins on an 8GB Server
Architect
Architect
Mar 18, 2023 · Backend Development

How to Configure JVM Parameters for a Platform Handling 1 Million Daily Login Requests on an 8 GB Server

This article explains a step‑by‑step methodology for estimating capacity, selecting appropriate garbage collectors, sizing JVM memory regions, and tuning advanced parameters such as survivor ratio, tenuring threshold, and Metaspace to reliably support a login service that processes one million requests per day on a machine with 8 GB of RAM.

Garbage CollectionJVMJava
0 likes · 25 min read
How to Configure JVM Parameters for a Platform Handling 1 Million Daily Login Requests on an 8 GB Server
Code Ape Tech Column
Code Ape Tech Column
Mar 13, 2023 · Backend Development

Diagnosing and Resolving 900% CPU Spikes in MySQL and Java Processes

This article explains common scenarios that cause CPU usage to soar above 200% in production, outlines step‑by‑step diagnosis and remediation for MySQL and Java processes, and shares real‑world case studies with command‑line tools, indexing, caching, and code adjustments to bring CPU load back to normal levels.

CPUCachingDebugging
0 likes · 11 min read
Diagnosing and Resolving 900% CPU Spikes in MySQL and Java Processes
ITPUB
ITPUB
Mar 12, 2023 · Databases

Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost

This article walks through a practical SQL optimization workflow, showing how to detect problematic queries via system metrics and execution plans, analyze table structures and indexes, apply concrete ALTER statements and index changes, and iteratively verify performance improvements, illustrated with a detailed MySQL case study that achieved a twenty‑fold speed increase.

Index OptimizationMySQLPerformance tuning
0 likes · 10 min read
Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost
Top Architect
Top Architect
Mar 8, 2023 · Backend Development

JVM Parameter Tuning for a Service Handling 10 Million Daily Login Requests on an 8 GB Node

This article walks through a systematic approach to sizing and configuring JVM parameters—including heap, young generation, GC algorithm, Metaspace, and safety‑point settings—for a high‑traffic login service that receives one million requests per day on a server with 8 GB of memory, providing both practical code examples and interview‑style explanations.

Garbage CollectionJVMJava
0 likes · 25 min read
JVM Parameter Tuning for a Service Handling 10 Million Daily Login Requests on an 8 GB Node
Selected Java Interview Questions
Selected Java Interview Questions
Mar 5, 2023 · Backend Development

JVM Parameter Tuning for a Platform with 1 Million Daily Login Requests on an 8 GB Node

This article walks through a systematic approach to sizing and configuring JVM memory and garbage‑collector parameters for a service handling one million login requests per day on an 8 GB server, covering capacity planning, GC selection, heap region sizing, thread‑stack settings, dynamic age thresholds, large‑object handling, and diagnostic options such as heap dumps and GC logging.

Garbage CollectionJVMJava
0 likes · 23 min read
JVM Parameter Tuning for a Platform with 1 Million Daily Login Requests on an 8 GB Node
IT Services Circle
IT Services Circle
Mar 4, 2023 · Databases

Practical Guide to SQL Optimization: Identifying and Improving Slow Queries

This article walks through a hands‑on process for detecting problematic SQL statements, interpreting execution plans, and applying concrete optimizations such as index adjustments and data‑type fixes to dramatically improve query performance, illustrated with a real MySQL case study.

DatabaseExplain PlanIndex Optimization
0 likes · 11 min read
Practical Guide to SQL Optimization: Identifying and Improving Slow Queries
Architect's Guide
Architect's Guide
Feb 25, 2023 · Big Data

Elasticsearch Optimization and Performance Tuning for Billion‑Scale Data

This article documents the evolution of a data platform, explains Elasticsearch and Lucene fundamentals, and presents practical index and search performance optimizations—including bulk writes, refresh control, memory allocation, doc‑values tuning, and pagination strategies—that enable cross‑month queries and sub‑second responses on billions of records.

ElasticsearchPerformance tuninglucene
0 likes · 11 min read
Elasticsearch Optimization and Performance Tuning for Billion‑Scale Data
dbaplus Community
dbaplus Community
Feb 19, 2023 · Databases

Essential MySQL Optimization Checklist: 46 Proven Practices to Boost Performance

This comprehensive guide outlines 46 practical MySQL optimization rules—from understanding the query execution flow and naming conventions to index design, join strategies, pagination techniques, and safe use of data types—providing concrete examples and code snippets that help developers dramatically improve database performance and reliability.

Best PracticesMySQLPerformance tuning
0 likes · 26 min read
Essential MySQL Optimization Checklist: 46 Proven Practices to Boost Performance
dbaplus Community
dbaplus Community
Feb 14, 2023 · Databases

10 Common PostgreSQL Mistakes and How to Avoid Them

This article outlines the ten most frequent PostgreSQL pitfalls—from default configurations and poor schema design to inadequate backups and mismanaged extensions—providing concrete SQL queries, tuning tools, and best‑practice recommendations to help DBAs detect, diagnose, and prevent each issue before it harms production workloads.

Connection PoolingDatabase AdministrationPerformance tuning
0 likes · 16 min read
10 Common PostgreSQL Mistakes and How to Avoid Them
Efficient Ops
Efficient Ops
Jan 29, 2023 · Operations

How Linux Kernel Handles TCP Connections: Deep Dive into sock_common and Lookup

This article explores Linux kernel TCP connection handling by examining socket data structures, port range and file descriptor tuning, core functions like tcp_v4_rcv, and lookup mechanisms, while offering practical tips to boost client-side concurrent connections beyond traditional limits.

Linux kernelOperationsPerformance tuning
0 likes · 9 min read
How Linux Kernel Handles TCP Connections: Deep Dive into sock_common and Lookup
Liangxu Linux
Liangxu Linux
Jan 15, 2023 · Operations

Boost Your NGINX Performance: 8 Proven Configuration Tweaks

This guide walks you through eight essential NGINX configuration adjustments—including worker processes, connection limits, GZIP compression, timeout values, buffer sizes, logging, static content caching, and open file caching—to maximize web server performance on Linux systems.

LinuxPerformance tuningWeb server
0 likes · 8 min read
Boost Your NGINX Performance: 8 Proven Configuration Tweaks
MaGe Linux Operations
MaGe Linux Operations
Jan 15, 2023 · Backend Development

Cut Nginx HTTPS Latency by 30%: Practical TLS Tuning Guide

This article explains why low‑latency Nginx HTTPS is crucial for instant search, breaks down TLS handshake round‑trips, and provides step‑by‑step configuration changes—such as enabling HTTP/2, adjusting ciphers, activating OCSP stapling, tweaking buffer sizes and session cache—to achieve roughly a 30% reduction in request latency.

HTTP/2HTTPS latencyOCSP stapling
0 likes · 12 min read
Cut Nginx HTTPS Latency by 30%: Practical TLS Tuning Guide
Baidu Geek Talk
Baidu Geek Talk
Jan 5, 2023 · Artificial Intelligence

How Baidu’s AIAK‑Inference Supercharges AI Model Inference on GPUs

This article provides an end‑to‑end analysis of AI inference bottlenecks, reviews common industry acceleration techniques, and details Baidu Intelligent Cloud’s AIAK‑Inference suite—including its architecture, optimization strategies such as model pruning, operator fusion, and single‑operator tuning—followed by a demo showing significant latency reductions on ResNet‑50 and other models.

AI inferenceAIAK-InferenceBaidu Cloud
0 likes · 16 min read
How Baidu’s AIAK‑Inference Supercharges AI Model Inference on GPUs
Architect's Tech Stack
Architect's Tech Stack
Dec 30, 2022 · Big Data

Distributed Computing Is Not a Panacea for Big Data: Prioritize Single‑Node Performance First

While distributed clusters are popular for big‑data processing, they are not a universal solution; tasks that are hard to partition or involve heavy cross‑node communication often perform better on a well‑optimized single machine, making a careful analysis of workload characteristics essential before scaling out.

Algorithm OptimizationBig DataDistributed computing
0 likes · 14 min read
Distributed Computing Is Not a Panacea for Big Data: Prioritize Single‑Node Performance First
dbaplus Community
dbaplus Community
Dec 13, 2022 · Big Data

How ClickHouse Powers Real-Time Self-Service Analytics at Scale

Facing massive daily data volumes and complex, ad‑hoc analytical needs, Zhaozhuan’s engineering team evaluated multiple OLAP engines and chose ClickHouse, then built a four‑layer self‑service analytics platform, detailing architecture, use‑cases, performance tuning, large‑scale joins, and future roadmap challenges.

Big DataClickHouseData Architecture
0 likes · 14 min read
How ClickHouse Powers Real-Time Self-Service Analytics at Scale
Open Source Linux
Open Source Linux
Dec 13, 2022 · Databases

Boost MySQL Performance: 20 Proven SQL Optimization Techniques

This article presents a comprehensive collection of MySQL optimization tips, covering everything from avoiding SELECT * and OR conditions to proper use of indexes, joins, UNION, batch operations, and query planning, each illustrated with clear examples and practical reasons for better performance.

MySQLPerformance tuningquery best practices
0 likes · 19 min read
Boost MySQL Performance: 20 Proven SQL Optimization Techniques
ITPUB
ITPUB
Dec 10, 2022 · Big Data

How ClickHouse Powers Real-Time Self-Service Analytics at Scale

This article examines why ClickHouse was chosen as the OLAP engine for a massive self‑service analytics platform, describes the system architecture, shares concrete memory and performance tuning parameters, and outlines current challenges and future roadmap for large‑scale real‑time data analysis.

Big DataClickHouseData Architecture
0 likes · 14 min read
How ClickHouse Powers Real-Time Self-Service Analytics at Scale
Full-Stack DevOps & Kubernetes
Full-Stack DevOps & Kubernetes
Dec 7, 2022 · Cloud Native

How to Scale Kubernetes to 5,000 Nodes: Master, API Server, and Component Tuning

This guide explains how to push a Kubernetes cluster toward its theoretical limit of 5,000 nodes by detailing official limits, master node sizing for GCE and AWS, kube‑apiserver high‑availability and connection‑count tuning, scheduler and controller‑manager leader election settings, kubelet optimizations, and DNS anti‑affinity configuration.

Cloud NativeKubernetesOperations
0 likes · 6 min read
How to Scale Kubernetes to 5,000 Nodes: Master, API Server, and Component Tuning
Youzan Coder
Youzan Coder
Nov 28, 2022 · Backend Development

How Switching from CMS to G1 Boosted Java Service Stability and Cut Costs

The article details how a Java team diagnosed frequent Full GC pauses caused by CMS, migrated to G1GC, adjusted JVM flags, scaled container specs, and achieved dramatically lower pause times, reduced instance counts, and significant cost savings while improving overall service stability.

CMSJVMJava
0 likes · 13 min read
How Switching from CMS to G1 Boosted Java Service Stability and Cut Costs
Tencent Cloud Developer
Tencent Cloud Developer
Nov 24, 2022 · Backend Development

Kafka Stability Best Practices: Prevention, Monitoring, and Fault Resolution

This guide outlines Kafka stability best practices across three phases—pre‑prevention with tuning, producer/consumer guidelines, and cluster configuration; runtime monitoring using white‑box and black‑box metrics and alerts; and fault resolution strategies for backlogs, consumption blocks, and message loss, plus cost control and idempotence techniques.

Backend DevelopmentDistributed MessagingKafka
0 likes · 29 min read
Kafka Stability Best Practices: Prevention, Monitoring, and Fault Resolution
Data Thinking Notes
Data Thinking Notes
Nov 22, 2022 · Big Data

Why Sqoop Sync from RDS to Hive Stalls Over 8 Hours and How to Fix It

A Sqoop job that normally finishes within 2.5 hours occasionally takes more than 8 hours due to data skew caused by an unsuitable split column, and the article details the investigation, root‑cause analysis, and a practical solution using a better split column and adjusted parallelism.

Big DataData SkewHive
0 likes · 5 min read
Why Sqoop Sync from RDS to Hive Stalls Over 8 Hours and How to Fix It
DataFunTalk
DataFunTalk
Nov 14, 2022 · Databases

Performance Optimization and Tuning of Apache Doris Vectorized Version for Xiaomi's A/B Experiment Platform

Xiaomi upgraded its Apache Doris from version 0.13 to the vectorized 1.1.2 release for its A/B experiment platform, conducting extensive single‑SQL and concurrent tests, identifying CPU, memory, and fragment timeout issues, and applying tuning such as memory decommit settings, string matching improvements, and patches to achieve up to 5× query speed gains and enhanced stability.

Apache DorisDatabase OptimizationPerformance tuning
0 likes · 20 min read
Performance Optimization and Tuning of Apache Doris Vectorized Version for Xiaomi's A/B Experiment Platform
Selected Java Interview Questions
Selected Java Interview Questions
Nov 12, 2022 · Databases

MySQL Large‑Table Index Optimization and Maintenance Strategies

This article analyzes performance problems of a massive MySQL table, demonstrates how to use pt‑query‑digest and EXPLAIN to identify inefficient composite indexes, proposes index redesign, compares online DDL with pt‑osc for index rebuilding, and presents batch‑delete techniques to reduce SLA‑impacting latency.

Batch DeleteDDLIndex Optimization
0 likes · 14 min read
MySQL Large‑Table Index Optimization and Maintenance Strategies
Meituan Technology Team
Meituan Technology Team
Nov 10, 2022 · Big Data

Optimizing Spark mapPartitions: Memory Management and Best Practices

The article details how Meituan’s Turing machine‑learning platform cut offline resource use by 80% and task time by 63% through memory‑level techniques such as column pruning, adaptive caching, and a deep dive into Spark’s mapPartitions operator, including source‑code analysis, GC behavior, and a low‑memory batch‑iterator best practice.

Big DataMemory OptimizationPerformance tuning
0 likes · 19 min read
Optimizing Spark mapPartitions: Memory Management and Best Practices
Data Thinking Notes
Data Thinking Notes
Oct 27, 2022 · Big Data

Boost Spark Performance: Proven Code Optimizations & Tuning Tips

This article outlines practical Spark job optimization techniques—from code-level improvements and resource tuning to data skew handling, persistence strategies, shuffle reduction, broadcast variables, Kryo serialization, and efficient data structures—demonstrating how each can dramatically cut execution time.

Big DataKryo SerializationPerformance tuning
0 likes · 19 min read
Boost Spark Performance: Proven Code Optimizations & Tuning Tips
Tuanzi Tech Team
Tuanzi Tech Team
Oct 26, 2022 · Backend Development

Master JVM Performance: Memory Structures, Tuning Parameters, and Monitoring Tips

Explore comprehensive JVM performance optimization, covering memory architecture, key tuning flags, garbage collector selection, common OOM scenarios, and essential monitoring tools such as jstack, jstat, JConsole, and VisualVM, with practical examples and code snippets to help you diagnose and resolve memory issues.

Garbage CollectionJVMJava
0 likes · 20 min read
Master JVM Performance: Memory Structures, Tuning Parameters, and Monitoring Tips
Top Architect
Top Architect
Oct 25, 2022 · Databases

Understanding Database Indexes: Storage Principles, Binary Search, and Optimization Techniques

This article explains how databases store data on various storage media, why indexes dramatically speed up queries through sorted structures and binary search, discusses different index types such as clustered indexes, and outlines common SQL optimization practices while warning against excessive indexing and typical pitfalls.

Binary SearchClustered IndexDatabase Index
0 likes · 12 min read
Understanding Database Indexes: Storage Principles, Binary Search, and Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 18, 2022 · Databases

Why MySQL Remains Popular and Its Logical Architecture

The article explains MySQL's continued dominance in the database market, presents recent developer survey statistics, describes its three‑layer logical architecture, and introduces the new edition of the "High Performance MySQL" book as a guide for modern database professionals.

Database ArchitectureMySQLOpen Source
0 likes · 7 min read
Why MySQL Remains Popular and Its Logical Architecture
Liangxu Linux
Liangxu Linux
Oct 10, 2022 · Operations

Essential Linux Ops: 10 Hard‑Earned Rules for Safe Server Management

This article shares practical Linux operations guidelines—including thorough testing, cautious use of destructive commands, strict backup policies, security hardening, continuous monitoring, performance tuning, and a disciplined mindset—to help avoid costly incidents and maintain stable production environments.

LinuxPerformance tuningSecurity
0 likes · 11 min read
Essential Linux Ops: 10 Hard‑Earned Rules for Safe Server Management
Java High-Performance Architecture
Java High-Performance Architecture
Oct 5, 2022 · Databases

How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion Strategies

This article analyzes a large MySQL table with frequent SLA alerts, demonstrates how to identify slow queries using pt‑query‑digest, proposes index redesign and online DDL versus pt‑osc methods, and shows testing, implementation, and batch‑delete techniques to dramatically reduce query time and maintenance overhead.

Batch DeletionDatabase MaintenanceIndex Optimization
0 likes · 17 min read
How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion Strategies
Java Backend Technology
Java Backend Technology
Sep 27, 2022 · Databases

Optimizing Massive MySQL Tables: Index Tuning, Online DDL & Batch Deletion

Facing SLA alerts due to slow queries on a billion‑row MySQL table, the article analyzes slow‑query logs, reveals index misuse, and demonstrates how removing a poor composite index, adding targeted indexes, employing online DDL or pt‑osc, and using batch deletions dramatically reduce query times and maintenance overhead.

Batch DeletionLarge TablesMySQL
0 likes · 16 min read
Optimizing Massive MySQL Tables: Index Tuning, Online DDL & Batch Deletion
Cloud Native Technology Community
Cloud Native Technology Community
Sep 23, 2022 · Cloud Native

What Cloud‑Native Networking Trends Kube‑OVN Reveals and How DeepFlow Enables Full‑Stack Observability

In this technical session, experts from Lingque Cloud and Yunshan Network discuss emerging cloud‑native networking trends through Kube‑OVN, demonstrate DeepFlow's full‑stack observability in Kube‑OVN environments, and answer a wide range of practical Q&A covering IP stability, underlay challenges, CNI support, and performance tuning.

CNICloud Native NetworkingDeepFlow
0 likes · 14 min read
What Cloud‑Native Networking Trends Kube‑OVN Reveals and How DeepFlow Enables Full‑Stack Observability
dbaplus Community
dbaplus Community
Sep 22, 2022 · Databases

Why MySQL IN Subqueries Turn Into Slow Full Scans—and How to Fix Them

A large‑scale user‑push system suffers from minutes‑long MySQL queries because the IN subquery materializes a temporary table and triggers a semi‑join that forces full table scans, but disabling the semi‑join optimizer or rewriting the query restores sub‑second performance.

MySQLPerformance tuningSQL optimization
0 likes · 8 min read
Why MySQL IN Subqueries Turn Into Slow Full Scans—and How to Fix Them
Code Ape Tech Column
Code Ape Tech Column
Sep 21, 2022 · Backend Development

Investigating Excessive Native Memory Usage in a Spring Boot Application Migrated to MDP Framework

After migrating a project to the MDP framework based on Spring Boot, the system repeatedly reported high swap usage despite a 4 GB heap configuration, leading to an investigation that uncovered native memory consumption caused by unchecked JAR scanning and allocator behavior, which was resolved by limiting scan paths and updating Spring Boot's inflater implementation.

JVMNative MemoryPerformance tuning
0 likes · 12 min read
Investigating Excessive Native Memory Usage in a Spring Boot Application Migrated to MDP Framework
ITPUB
ITPUB
Sep 18, 2022 · Databases

Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM

This article explains how Redis stores key‑value pairs, details the internal data structures such as dict, dictEntry and redisObject, and provides practical memory‑saving tricks—including key shortening, encoding choices, object sharing, bitmap usage, hash consolidation, fragmentation handling, and 32‑bit deployment—to dramatically reduce RAM consumption while maintaining performance.

CacheData StructuresDatabase
0 likes · 19 min read
Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM
IT Architects Alliance
IT Architects Alliance
Sep 12, 2022 · Backend Development

Elasticsearch Optimization: Lucene Architecture, Index Design, and Performance Tuning

This article presents a comprehensive guide to optimizing Elasticsearch for massive datasets, covering Lucene fundamentals, index and shard architecture, practical performance‑tuning techniques, and real‑world case studies that achieve sub‑second query responses on billions of records.

ElasticsearchIndex OptimizationPerformance tuning
0 likes · 11 min read
Elasticsearch Optimization: Lucene Architecture, Index Design, and Performance Tuning
ITPUB
ITPUB
Sep 8, 2022 · Databases

Master MySQL Performance: 5 Key Optimization Strategies You Must Know

This guide explores five essential dimensions of MySQL performance tuning—including connection configuration, architectural choices such as caching and read‑write splitting, optimizer settings, storage engine selection, and schema design—providing concrete commands, formulas, and best‑practice recommendations to accelerate query execution and reduce load.

Database ArchitectureMySQLPerformance tuning
0 likes · 20 min read
Master MySQL Performance: 5 Key Optimization Strategies You Must Know
Code Ape Tech Column
Code Ape Tech Column
Sep 8, 2022 · Backend Development

Tomcat Performance Tuning: Core Components and Key Parameters

This article explains Tomcat's component architecture, describes the request‑processing flow, and provides practical guidance on tuning the three critical parameters—maxThreads, maxConnections, and acceptCount—along with additional settings to improve backend service performance without additional hardware.

JavaPerformance tuningServer Configuration
0 likes · 11 min read
Tomcat Performance Tuning: Core Components and Key Parameters
JD Tech
JD Tech
Sep 6, 2022 · Big Data

Flink Streaming Job Tuning Guide: Memory Model, Network Stack, RocksDB, and More

This article presents a detailed guide for optimizing large‑scale Apache Flink streaming jobs on the JD Real‑Time Computing platform, covering TaskManager memory model tuning, network stack configuration, RocksDB state management, checkpoint strategies, and additional performance tips with practical examples and calculations.

Apache FlinkCheckpointNetwork Stack
0 likes · 22 min read
Flink Streaming Job Tuning Guide: Memory Model, Network Stack, RocksDB, and More
Cloud Native Technology Community
Cloud Native Technology Community
Sep 1, 2022 · Cloud Native

How to Supercharge Kube-OVN Performance: Benchmarks and Tuning Guide

This guide presents Kube-OVN performance benchmarks, explains the testing environment and qperf commands, and provides step‑by‑step data‑plane optimization techniques—including CPU mode, NIC queue tuning, tuned profiles, interrupt binding, OVN LB disabling, FastPath module, OVS kernel compilation, and STT tunnel activation—to help administrators achieve lower latency and higher throughput in Kubernetes clusters.

Kube-OVNKubernetesOVN
0 likes · 12 min read
How to Supercharge Kube-OVN Performance: Benchmarks and Tuning Guide
Programmer DD
Programmer DD
Aug 27, 2022 · Databases

Top 10 PostgreSQL Bulk Import Optimizations for Faster Data Loading

When loading massive amounts of data into PostgreSQL, disabling autocommit, postponing index and foreign‑key creation, adjusting memory settings, using COPY or pg_bulkload, and fine‑tuning WAL and trigger settings can dramatically improve import speed and overall performance.

Bulk ImportPerformance tuningPostgreSQL
0 likes · 7 min read
Top 10 PostgreSQL Bulk Import Optimizations for Faster Data Loading
Sohu Tech Products
Sohu Tech Products
Aug 24, 2022 · Fundamentals

JVM JIT and CodeCache Parameter Configuration Guide

This article explains the JVM's Just‑In‑Time compilation mechanism and CodeCache memory area, detailing the purpose and default values of key JIT parameters such as TieredCompilation, CompileThreshold, OnStackReplacePercentage, CICompilerCount, as well as CodeCache settings like InitialCodeCacheSize, ReservedCodeCacheSize, Xmaxjitcodesize, CodeCacheMinimumFreeSpace and UseCodeCacheFlushing, and provides practical tuning advice for high‑traffic Java services.

CodeCacheHotSpotJIT
0 likes · 15 min read
JVM JIT and CodeCache Parameter Configuration Guide
Architects' Tech Alliance
Architects' Tech Alliance
Aug 22, 2022 · Fundamentals

DPDK Performance Tuning: Influencing Factors and Optimization Techniques

This article explains how hardware architecture, Linux OS version, kernel configuration, OVS integration, memory management, NUMA awareness, and CPU micro‑architecture affect DPDK application performance and provides concrete tuning steps such as CPU isolation, service disabling, huge‑page setup, and optimized memory allocation.

CPU optimizationDPDKLinux
0 likes · 11 min read
DPDK Performance Tuning: Influencing Factors and Optimization Techniques
Ops Development Stories
Ops Development Stories
Aug 19, 2022 · Big Data

Master Kafka: From Core Concepts to Advanced Operations and Performance Tuning

This comprehensive guide explains Kafka’s origins, core architecture, data structures, write and read workflows, operational commands for topic and consumer‑group management, and practical performance‑tuning tips such as disk layout, JVM settings, flush policies, and log retention, providing a complete reference for engineers working with distributed streaming platforms.

Data StreamingDistributed MessagingKafka
0 likes · 32 min read
Master Kafka: From Core Concepts to Advanced Operations and Performance Tuning
Ctrip Technology
Ctrip Technology
Aug 18, 2022 · Databases

Nebula Graph Architecture, Deployment Strategies, and Performance Optimization at Ctrip

This article describes Ctrip's adoption of Nebula Graph, covering the reasons for choosing the open‑source distributed graph database, its modular architecture, multi‑data‑center and blue‑green deployment patterns, middleware integration, client session management, query language extensions, and a series of performance‑tuning practices that solved stability and CPU issues in production.

Graph DatabaseKubernetesNebula Graph
0 likes · 21 min read
Nebula Graph Architecture, Deployment Strategies, and Performance Optimization at Ctrip
dbaplus Community
dbaplus Community
Aug 7, 2022 · Databases

Mastering MySQL Performance: Practical Strategies for Slow‑SQL Optimization

This comprehensive guide examines why slow SQL queries degrade system performance, outlines key factors such as data volume, access patterns, and processing methods, and provides concrete optimization techniques, case studies, index design principles, and advanced features like MRR and index push‑down for MySQL‑InnoDB.

InnoDBMySQLPerformance tuning
0 likes · 14 min read
Mastering MySQL Performance: Practical Strategies for Slow‑SQL Optimization
Su San Talks Tech
Su San Talks Tech
Aug 1, 2022 · Backend Development

Master Tomcat Performance: Key Components and Tuning Tips for Max Throughput

This article explains Tomcat’s internal component architecture, walks through the request‑processing flow, and details three crucial configuration parameters—maxThreads, maxConnections, and acceptCount—offering practical formulas and tuning guidelines to improve throughput without adding hardware.

ConnectorJavaPerformance tuning
0 likes · 12 min read
Master Tomcat Performance: Key Components and Tuning Tips for Max Throughput
Top Architect
Top Architect
Jul 28, 2022 · Databases

SQL Optimization Steps and Common Scenarios: Index Usage, EXPLAIN, Profiling, and Trace

This article explains how to identify and resolve performance bottlenecks in MySQL by locating slow queries, analyzing execution plans with EXPLAIN, focusing on type, rows and extra information, using profiling and trace tools, and applying practical optimization techniques illustrated through multiple real‑world cases.

Database OptimizationMySQLPerformance tuning
0 likes · 11 min read
SQL Optimization Steps and Common Scenarios: Index Usage, EXPLAIN, Profiling, and Trace
Tencent Cloud Middleware
Tencent Cloud Middleware
Jul 25, 2022 · Operations

How Tencent Scaled Apache Pulsar to Process Billions of Messages Daily – Ops Lessons & Tuning Guide

This article details the design, deployment, and performance‑tuning techniques used by Tencent's TEG Data Platform to operate a massive Apache Pulsar cluster handling trillions of messages per day, covering server‑side parameters, client‑side configurations, common bottlenecks, and step‑by‑step troubleshooting advice.

Apache PulsarGo SDKLarge Scale Messaging
0 likes · 22 min read
How Tencent Scaled Apache Pulsar to Process Billions of Messages Daily – Ops Lessons & Tuning Guide
MaGe Linux Operations
MaGe Linux Operations
Jul 20, 2022 · Operations

What a Typical Ops Day Looks Like—and How to Make It More Productive

The author recounts a chaotic typical day for Chinese operations engineers, then proposes a balanced schedule that prioritizes urgent firefighting tasks while dedicating most time to proactive monitoring, performance tuning, tool development, and continuous learning for long‑term system stability.

DevOpsOperationsPerformance tuning
0 likes · 4 min read
What a Typical Ops Day Looks Like—and How to Make It More Productive
Programmer DD
Programmer DD
Jul 15, 2022 · Databases

Boost MySQL Performance: 8 Common SQL Pitfalls and How to Fix Them

This article examines frequent MySQL performance problems—such as inefficient LIMIT usage, implicit type conversion, suboptimal joins, mixed ordering, EXISTS subqueries, condition pushdown limitations, early range reduction, and intermediate result handling—and provides concrete rewrites and execution‑plan analyses that dramatically improve query speed.

MySQLPerformance tuningQuery Rewriting
0 likes · 16 min read
Boost MySQL Performance: 8 Common SQL Pitfalls and How to Fix Them
Top Architect
Top Architect
Jul 14, 2022 · Big Data

A Comprehensive Introduction to Elasticsearch: Architecture, Core Concepts, and Practical Usage

This article provides a detailed overview of Elasticsearch, covering its data model, Lucene foundation, cluster architecture, shard and replica mechanisms, index mapping, installation steps, health monitoring, write and storage processes, segment management, and performance tuning techniques for large‑scale search applications.

Big DataElasticsearchPerformance tuning
0 likes · 35 min read
A Comprehensive Introduction to Elasticsearch: Architecture, Core Concepts, and Practical Usage
Liangxu Linux
Liangxu Linux
Jul 9, 2022 · Databases

How Indexes Transform MySQL Subquery Performance: A Deep Dive

This article walks through a MySQL 5.6 scenario where a subquery that originally took over eight hours is accelerated by orders of magnitude through strategic index creation, query rewriting, and join optimization, illustrating the impact of single‑column, composite, and covering indexes on execution plans.

Index OptimizationJoinMySQL
0 likes · 13 min read
How Indexes Transform MySQL Subquery Performance: A Deep Dive
Youzan Coder
Youzan Coder
Jul 7, 2022 · Big Data

Optimizing Apache Doris Performance: A Case Study in Query Processing

Youzan replaced ClickHouse and Druid with Apache Doris, refined its vectorized engine by eliminating deserialization overhead in the merge‑aggregation phase, achieving roughly a 30 % query‑time boost, and validated compatibility through SQL rewriting and traffic replay, while planning further SIMD‑based optimizations and broader adoption.

Apache DorisClickHouseDruid
0 likes · 8 min read
Optimizing Apache Doris Performance: A Case Study in Query Processing
HelloTech
HelloTech
Jul 6, 2022 · Big Data

Investigation and Resolution of Elasticsearch Write Timeout Issues in a Real-Time Flink Data Sync Pipeline

The team diagnosed intermittent Elasticsearch write‑timeout failures in their real‑time Flink‑to‑Elasticsearch pipeline as lock contention from frequent duplicate updates to the same document IDs, and eliminated the issue by aggregating binlog events in a 5‑second sliding window to deduplicate writes, adjusting refresh intervals, using async translog durability, and disabling non‑essential fields.

Big DataElasticsearchFlink
0 likes · 7 min read
Investigation and Resolution of Elasticsearch Write Timeout Issues in a Real-Time Flink Data Sync Pipeline
Su San Talks Tech
Su San Talks Tech
Jul 6, 2022 · Databases

Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM

This article explains Redis's internal storage mechanisms and presents seven practical optimization techniques—including key‑value compression, small‑collection encoding, object sharing, bitmap usage, hash structuring, memory‑fragment defragmentation, and 32‑bit deployment—to dramatically reduce memory consumption while increasing data capacity.

CacheData StructuresDatabase
0 likes · 21 min read
Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM
macrozheng
macrozheng
Jul 1, 2022 · Operations

How to Optimize Server Performance: Config, Load Analysis, and Kernel Tuning

Learn practical methods to boost server performance by selecting appropriate hardware configurations, analyzing CPU, memory, disk I/O and network loads, and fine‑tuning kernel parameters such as file limits and TCP settings, with step‑by‑step commands and monitoring tools like htop, iostat, and nload.

Kernel ParametersLinuxPerformance tuning
0 likes · 14 min read
How to Optimize Server Performance: Config, Load Analysis, and Kernel Tuning
Open Source Linux
Open Source Linux
Jun 28, 2022 · Operations

Essential Ops Lessons: 22 Hard‑Earned Rules to Prevent Disasters

Drawing from three and a half years of DevOps experience, this guide compiles critical operational practices—ranging from cautious command execution and strict change control to robust backup, security hardening, continuous monitoring, performance tuning, and a disciplined mindset—to help engineers avoid costly outages and data loss.

DevOpsOperational Best PracticesPerformance tuning
0 likes · 12 min read
Essential Ops Lessons: 22 Hard‑Earned Rules to Prevent Disasters
Su San Talks Tech
Su San Talks Tech
Jun 25, 2022 · Backend Development

How Kafka Broker Handles High‑Throughput Requests: Deep Dive into Its Network Architecture

This article thoroughly examines Kafka Broker's network architecture and request‑handling pipeline, exploring sequential, multi‑threaded, and Reactor‑based designs, detailing Acceptor and Processor threads, NIO mechanisms, and offering practical tuning tips to achieve high concurrency and performance.

KafkaPerformance tuningReactor Pattern
0 likes · 21 min read
How Kafka Broker Handles High‑Throughput Requests: Deep Dive into Its Network Architecture
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 22, 2022 · Databases

Diagnosing Excessive data_free Values in MySQL and Managing ibtmp1 Temporary Tablespace Bloat

This article walks through a real‑world case where a MySQL instance showed an abnormal 13 GB data_free value, explains how the ibtmp1 temporary tablespace caused the growth, demonstrates verification steps with sysbench and SQL queries, and provides configuration and operational solutions to prevent and resolve the issue.

MySQLPerformance tuningdata_free
0 likes · 9 min read
Diagnosing Excessive data_free Values in MySQL and Managing ibtmp1 Temporary Tablespace Bloat
Java Architect Essentials
Java Architect Essentials
Jun 21, 2022 · Backend Development

Master Nginx: Core Concepts, Configuration, and Performance Tuning

This comprehensive guide explains what Nginx is, its advantages, typical use cases, request handling, high‑concurrency model, forward and reverse proxy concepts, directory layout, key configuration directives, load‑balancing algorithms, rate limiting, health checks, gzip compression, and practical examples for virtual hosts and module management.

Performance tuningWeb serverconfiguration
0 likes · 33 min read
Master Nginx: Core Concepts, Configuration, and Performance Tuning
dbaplus Community
dbaplus Community
Jun 21, 2022 · Databases

Essential Tips for Optimizing Chinese Domestic Databases: What Oracle DBAs Should Know

This article outlines practical guidance for DBAs transitioning to Chinese domestic databases, highlighting why standard Oracle benchmark tweaks often fail, the limited relevance of buffer‑hit ratios, the importance of SQL execution efficiency, and specific strategies for handling high‑concurrency workloads.

DBADatabase OptimizationDomestic Databases
0 likes · 7 min read
Essential Tips for Optimizing Chinese Domestic Databases: What Oracle DBAs Should Know
Top Architect
Top Architect
Jun 14, 2022 · Databases

Understanding MySQL Execution Process: Connectors, Cache, Parser, Optimizer, and Executor

This article explains MySQL's internal execution process—including the connector, cache, parser, optimizer, and executor—describes privilege tables and verification, discusses query caching removal, outlines logical SQL execution order, and provides practical tips for ordering WHERE conditions to improve performance.

DatabaseDatabase InternalsMySQL
0 likes · 12 min read
Understanding MySQL Execution Process: Connectors, Cache, Parser, Optimizer, and Executor
Top Architect
Top Architect
Jun 13, 2022 · Databases

Comprehensive MySQL Performance Optimization Guide

This article provides a detailed guide on optimizing MySQL performance, covering SQL statement tuning, index usage, table design normalization, system configuration, hardware choices, and the internal architecture of MySQL to help developers write faster and more efficient queries.

DatabaseMySQLPerformance tuning
0 likes · 19 min read
Comprehensive MySQL Performance Optimization Guide
Su San Talks Tech
Su San Talks Tech
Jun 6, 2022 · Databases

Why Is MySQL Query Slow? Hidden Factors Beyond Indexes and How to Fix Them

This article explores the various reasons MySQL queries become slow—including index misuse, insufficient connection pools, small InnoDB buffer pools, and query cache limitations—while providing practical solutions such as optimizing indexes, adjusting max_connections, enlarging buffer pools, and configuring connection pools for better performance.

Connection PoolIndex OptimizationInnoDB
0 likes · 16 min read
Why Is MySQL Query Slow? Hidden Factors Beyond Indexes and How to Fix Them
NetEase Cloud Music Tech Team
NetEase Cloud Music Tech Team
May 26, 2022 · Backend Development

Investigation and Warm‑up Mitigation of JVM C2 CompilerThread CPU Spikes During Service Startup

The article details a real‑world case where JVM C2 CompilerThread CPU spikes during service startup caused request timeouts and GC pressure, explains how profiling identified the JIT compilation as the root cause, and describes a warm‑up replay strategy that pre‑compiles hotspot code to eliminate the spikes and stabilize deployments.

C2 CompilerThreadJITJVM
0 likes · 13 min read
Investigation and Warm‑up Mitigation of JVM C2 CompilerThread CPU Spikes During Service Startup
Selected Java Interview Questions
Selected Java Interview Questions
May 6, 2022 · Databases

Eight Database Optimization Strategies for Performance Improvement

This article presents a systematic overview of eight practical database optimization techniques—including data reduction, serialization, archiving, intermediate tables, sharding, distributed caching, master‑slave replication, and appropriate storage selection—to help backend engineers diagnose and resolve the majority of performance bottlenecks caused by data volume, high load, and search complexity.

CQRSCachingNoSQL
0 likes · 19 min read
Eight Database Optimization Strategies for Performance Improvement
DataFunSummit
DataFunSummit
May 4, 2022 · Big Data

NetEase Big Data Platform: HDFS Optimization and Practices

NetEase’s senior big‑data engineer shares how the company’s large‑scale data platform leverages Hadoop, HDFS, YARN and related technologies, detailing multi‑layer architecture, cross‑cloud deployment, storage optimizations, NameNode performance enhancements, RPC prioritization, and practical lessons from operating petabyte‑scale clusters.

Cluster OptimizationHDFSPerformance tuning
0 likes · 23 min read
NetEase Big Data Platform: HDFS Optimization and Practices
Java Backend Technology
Java Backend Technology
May 1, 2022 · Databases

Mastering Database Performance: 8 Proven Optimization Strategies

This article explains why databases become slow, introduces a four‑layer thinking model, and presents eight practical solutions—including reducing data volume, leveraging space for performance, and selecting the right storage system—to help backend engineers resolve 80‑90% of common performance problems.

CQRSDatabase OptimizationNoSQL
0 likes · 19 min read
Mastering Database Performance: 8 Proven Optimization Strategies
Top Architect
Top Architect
Apr 24, 2022 · Databases

Optimizing MySQL Batch Insert Performance: Determining the Ideal Batch Size

This article analyzes MySQL batch insertion performance, explains how row size, max_allowed_packet, buffer pool, transaction handling, and index design affect throughput, and presents empirical tests that suggest using roughly half of the max_allowed_packet size as the optimal batch size for large data loads.

InnoDBMySQLPerformance tuning
0 likes · 16 min read
Optimizing MySQL Batch Insert Performance: Determining the Ideal Batch Size
Alibaba Cloud Native
Alibaba Cloud Native
Apr 22, 2022 · Operations

How to Design and Execute Performance Tests for Mini‑Programs with PTS

This guide explains why mini‑programs need load testing, outlines three common testing scenarios, describes four test‑type designs, and provides step‑by‑step instructions for using Alibaba Cloud PTS to obtain platform tokens, configure APIs, and run stable, long‑duration pressure tests.

Mini ProgramPTSPerformance tuning
0 likes · 9 min read
How to Design and Execute Performance Tests for Mini‑Programs with PTS
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 16, 2022 · Databases

ClickHouse Practical Guide: Engine Selection, Cluster Architecture, and Operational Best Practices

This article provides a comprehensive overview of ClickHouse, covering its core use cases, detailed explanations of the various table engines, recommended schema and deployment patterns, performance‑tuning parameters, tooling choices, and operational guidelines for building and maintaining high‑availability OLAP clusters.

ClickHouseCluster ArchitectureOLAP
0 likes · 24 min read
ClickHouse Practical Guide: Engine Selection, Cluster Architecture, and Operational Best Practices
ITPUB
ITPUB
Apr 14, 2022 · Databases

Eight Proven Strategies to Supercharge Database Performance

This article explains why databases become slow, introduces a four‑layer thinking model, and presents eight practical optimization techniques—including data reduction, caching, sharding, master‑slave replication, and CQRS—along with their benefits, drawbacks, and suitable scenarios.

CQRSCachingDatabase Optimization
0 likes · 22 min read
Eight Proven Strategies to Supercharge Database Performance
Programmer DD
Programmer DD
Apr 14, 2022 · Databases

How to Speed Up MySQL LIMIT Pagination from 16 s to 0.3 s with Subquery Optimization

This article demonstrates how a MySQL pagination query on a 9.5‑million‑row table that originally took over 16 seconds can be accelerated to under 0.4 seconds by moving the LIMIT condition into a subquery that selects only primary‑key IDs and then joining to retrieve the remaining columns, with detailed code and experimental verification.

InnoDBLimit OptimizationMySQL
0 likes · 10 min read
How to Speed Up MySQL LIMIT Pagination from 16 s to 0.3 s with Subquery Optimization