BestHub
Sign in
Tagged articles

Performance Tuning

1016 articles · Page 6 of 11
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.

DevOpsMonitoringOperations
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.

Performance TuningQuery Rewritingdatabase indexing
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 DataElasticsearchIndexing
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 OptimizationJOINPerformance Tuning
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 DataData synchronizationElasticsearch
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 StructuresMemory optimization
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.

LinuxMonitoringPerformance 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.

KafkaNetwork ArchitecturePerformance Tuning
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.

Performance Tuningdata_freeibtmp1
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.

ConfigurationHigh concurrencyNGINX
0 likes · 33 min read
Master Nginx: Core Concepts, Configuration, and Performance Tuning
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.

Database InternalsPerformance TuningQuery Optimizer
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.

IndexingPerformance Tuningdatabase
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 CompilerThreadGCJIT
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.

CQRSCachingData Archiving
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.

CQRSData ArchivingNoSQL
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.

InnoDBPerformance Tuningmax_allowed_packet
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.

CQRSCachingNoSQL
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 OptimizationPerformance Tuning
0 likes · 10 min read
How to Speed Up MySQL LIMIT Pagination from 16 s to 0.3 s with Subquery Optimization
Liangxu Linux
Liangxu Linux
Apr 7, 2022 · Databases

Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More

This comprehensive guide covers MySQL fundamentals including the three normal forms, permission tables, ACID properties, index design principles, SQL statement categories, sharding, deadlock resolution, isolation anomalies, view characteristics, SQL lifecycle, primary key choices, performance troubleshooting, replication, GTID, backup tools, and backup planning.

Database DesignPerformance TuningSQL
0 likes · 13 min read
Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More
Xiaolei Talks DB
Xiaolei Talks DB
Apr 7, 2022 · Databases

Why Did One Aerospike Node’s XDR Lag So High? Diagnosis and Fix

A single Aerospike node experienced extreme XDR replication lag due to a misconfigured forward setting, and the article walks through terminology, monitoring data, root‑cause analysis, and step‑by‑step commands to resolve the issue and improve cluster performance.

AerospikeDatabase LagNoSQL
0 likes · 11 min read
Why Did One Aerospike Node’s XDR Lag So High? Diagnosis and Fix
Open Source Linux
Open Source Linux
Apr 1, 2022 · Databases

Master MySQL Performance: Deep Dive into Indexes, Explain Plans, and Optimization Techniques

This comprehensive guide explores MySQL's architecture, explains how indexes work, details the use of EXPLAIN to analyze query execution, and provides practical optimization strategies—including index creation, avoiding common pitfalls, and improving single- and multi-table queries—to dramatically boost database performance.

IndexesPerformance Tuningmysql
0 likes · 33 min read
Master MySQL Performance: Deep Dive into Indexes, Explain Plans, and Optimization Techniques
Laravel Tech Community
Laravel Tech Community
Mar 31, 2022 · Databases

SQL Optimization Steps and Common Cases for Improving Query Performance

This article outlines a systematic approach to identifying and fixing slow MySQL queries, explains how to interpret EXPLAIN output and profiling information, and presents multiple real‑world cases illustrating index usage, implicit conversion, large pagination, IN queries, and other optimization techniques.

Explain PlanIndexingPerformance Tuning
0 likes · 10 min read
SQL Optimization Steps and Common Cases for Improving Query Performance
Efficient Ops
Efficient Ops
Mar 29, 2022 · Big Data

How Tencent Cloud Boosted APM Metric Computation Speed 2‑3× with Flink Optimizations

This article explains how Tencent Cloud's APM metric calculation, which transforms massive Span data into aggregated metrics using Flink, faced performance bottlenecks and was optimized through job splitting, batch merging, and dimension pruning, ultimately achieving a 2‑3× speed increase and cutting resource usage to about 30% of the original.

APMBig DataCloud Monitoring
0 likes · 10 min read
How Tencent Cloud Boosted APM Metric Computation Speed 2‑3× with Flink Optimizations
IT Architects Alliance
IT Architects Alliance
Mar 14, 2022 · Big Data

Comprehensive Guide to Kafka Architecture, Core Concepts, and Production Deployment

This article provides an in‑depth overview of Kafka, covering why messaging systems are needed, core concepts, cluster architecture, performance optimizations such as sequential disk writes and zero‑copy, hardware sizing, replication, consumer groups, offset management, rebalance strategies, and practical deployment and operational guidelines.

Big DataCluster DeploymentDistributed Messaging
0 likes · 35 min read
Comprehensive Guide to Kafka Architecture, Core Concepts, and Production Deployment
Sanyou's Java Diary
Sanyou's Java Diary
Mar 14, 2022 · Databases

Why Is My Redis Slowing Down? Comprehensive Diagnosis & Optimization Guide

This article provides a thorough step‑by‑step guide to identify why Redis latency spikes, covering baseline performance testing, slowlog analysis, big‑key handling, expiration patterns, memory limits, fork overhead, huge pages, AOF settings, CPU binding, swap usage, memory fragmentation, network bandwidth, and practical optimization techniques.

LatencyOptimizationPerformance Tuning
0 likes · 39 min read
Why Is My Redis Slowing Down? Comprehensive Diagnosis & Optimization Guide
ITPUB
ITPUB
Mar 14, 2022 · Databases

Master MySQL Performance: Practical SQL, Index, Join, and Hardware Tuning

This article provides a comprehensive guide to MySQL performance improvement, covering pagination, index, join, sorting, UNION, slow‑query‑log, schema design, and hardware optimizations with concrete SQL examples, best‑practice tips, and cautionary notes for real‑world deployments.

Database DesignIndexingPerformance Tuning
0 likes · 16 min read
Master MySQL Performance: Practical SQL, Index, Join, and Hardware Tuning
Efficient Ops
Efficient Ops
Mar 1, 2022 · Operations

Master Linux Performance: Key Metrics, Tools, and Optimization Techniques

This guide explains Linux performance optimization by defining core metrics such as throughput, latency, and average load, describing how to select and benchmark indicators, outlining essential analysis tools like vmstat, pidstat, and perf, and providing practical CPU and memory tuning strategies to eliminate bottlenecks.

CPULinuxMonitoring
0 likes · 47 min read
Master Linux Performance: Key Metrics, Tools, and Optimization Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 22, 2022 · Databases

ClickHouse Best Practices: Table Engines, Cluster Architecture, and Operational Guidelines

This guide provides a comprehensive overview of ClickHouse, covering its core use cases, detailed table‑engine choices, cluster design, Zookeeper integration, query and data‑loading best practices, client tools, and key configuration parameters to ensure high performance and reliability in OLAP workloads.

ClickHouseCluster ArchitectureDatabases
0 likes · 23 min read
ClickHouse Best Practices: Table Engines, Cluster Architecture, and Operational Guidelines
政采云技术
政采云技术
Feb 15, 2022 · Big Data

Performance Investigation and Optimization of an Elasticsearch Search Service

This article describes a performance bottleneck in a high‑traffic search service, details the investigation of hardware limits, long‑tail query impact, load‑testing methodology, and the subsequent optimizations—including SSD upgrade, data‑structure reduction, and Elasticsearch segment tuning—that reduced disk I/O and improved throughput.

ElasticsearchPerformance TuningSegment Optimization
0 likes · 11 min read
Performance Investigation and Optimization of an Elasticsearch Search Service
Top Architect
Top Architect
Feb 14, 2022 · Databases

Elasticsearch Fundamentals: Architecture, Indexing, Sharding, and Performance Optimization

This comprehensive guide explains Elasticsearch’s core concepts—including its distributed architecture, indexing process, shard routing, refresh and translog mechanisms, segment merging, and performance tuning—while providing practical examples and configuration tips for building scalable, near‑real‑time search solutions.

ElasticsearchIndexingPerformance Tuning
0 likes · 35 min read
Elasticsearch Fundamentals: Architecture, Indexing, Sharding, and Performance Optimization
Liangxu Linux
Liangxu Linux
Feb 12, 2022 · Operations

20 Essential Linux Server Performance Tweaks Every Sysadmin Should Know

This guide outlines practical Linux server optimization techniques—from disabling unnecessary daemons and GUI to tuning kernel parameters, file systems, TCP settings, and monitoring tools—helping administrators boost stability, reduce resource usage, and improve overall system performance.

Performance Tuningoperating systemserver optimization
0 likes · 14 min read
20 Essential Linux Server Performance Tweaks Every Sysadmin Should Know
ITPUB
ITPUB
Feb 11, 2022 · R&D Management

When Open Source Meets Self‑Development: Lessons from a Decade of R&D

The article shares a senior engineer’s practical experience on combining open‑source and self‑developed components, analysing their advantages, lifecycle stages, and concrete strategies—including problem definition, selection, source‑code control, and ten actionable tips—to help teams balance cost, innovation, and stability.

Performance TuningProduct LifecycleR&D Management
0 likes · 37 min read
When Open Source Meets Self‑Development: Lessons from a Decade of R&D
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 9, 2022 · Databases

Performance Evaluation of Parallel DDL in MySQL 8.0.27

This article investigates how the innodb_ddl_threads, innodb_ddl_buffer_size, and innodb_parallel_read_threads variables introduced in MySQL 8.0.27 affect parallel DDL execution speed and resource consumption, using a 50‑million‑row test table and presenting detailed benchmark results.

InnoDBParallel DDLPerformance Tuning
0 likes · 7 min read
Performance Evaluation of Parallel DDL in MySQL 8.0.27
Alibaba Cloud Developer
Alibaba Cloud Developer
Jan 24, 2022 · Cloud Computing

How to Slash Cold-Start Delays for Spring Boot on Serverless Platforms

This article, part of a series analyzing Serverless platforms for Spring Boot, explains how to diagnose and reduce cold‑start latency, covering tracing, reserved instances, lazy initialization, JVM options, and instance concurrency tuning, using the high‑traffic Mall demo application as a concrete example.

Instance ConcurrencyPerformance TuningServerless
0 likes · 10 min read
How to Slash Cold-Start Delays for Spring Boot on Serverless Platforms
Tencent Qidian Tech Team
Tencent Qidian Tech Team
Jan 18, 2022 · Operations

Unlock Go Performance: Master pprof, trace, GODEBUG, and Escape Analysis

This comprehensive guide explores Go performance optimization techniques, covering pprof profiling, trace analysis, GODEBUG diagnostics, and escape analysis, while providing practical code examples and real‑world case studies to help developers identify and resolve CPU, memory, and goroutine bottlenecks in production services.

Escape AnalysisGODEBUGGo
0 likes · 40 min read
Unlock Go Performance: Master pprof, trace, GODEBUG, and Escape Analysis
Architect
Architect
Jan 7, 2022 · Big Data

Spark Performance Optimization: Principles, Memory Model, Resource Tuning, Data Skew and Shuffle Tuning

This article provides an in‑depth guide to Spark performance optimization, covering the ten development principles, static and unified memory models, resource parameter tuning, data skew detection and mitigation techniques, as well as shuffle‑related configuration adjustments, supplemented with practical code examples and diagrams.

Data SkewMemory ModelPerformance Tuning
0 likes · 40 min read
Spark Performance Optimization: Principles, Memory Model, Resource Tuning, Data Skew and Shuffle Tuning
Top Architect
Top Architect
Jan 7, 2022 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑diagnostic utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run them, and shows how to interpret their reports for optimizing database configuration and query performance.

Database ToolsPerformance Tuningmysql
0 likes · 8 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
Xianyu Technology
Xianyu Technology
Jan 4, 2022 · Backend Development

Full GC Diagnosis and Tuning for Xianyu Backend Services

The article details three Xianyu backend incidents where Full GC pauses caused latency spikes or outages, analyzes root causes ranging from survivor space shortage and mis‑tuned CMS to oversized async Log4j events and massive string‑concatenation logs, and presents remediation steps such as switching to G1GC, adjusting Log4j settings, and using parameterized logging to eliminate the pauses.

Garbage CollectionJVMJava
0 likes · 23 min read
Full GC Diagnosis and Tuning for Xianyu Backend Services
HomeTech
HomeTech
Dec 24, 2021 · Big Data

Handling java.lang.OutOfMemoryError in Hadoop MapReduce

This article explains the four locations where java.lang.OutOfMemoryError can occur in Hadoop's MapReduce framework—client, ApplicationMaster, Map, and Reduce phases—and provides configuration adjustments and best‑practice solutions to mitigate each type of OOM issue.

HadoopJavaMapReduce
0 likes · 11 min read
Handling java.lang.OutOfMemoryError in Hadoop MapReduce
IT Architects Alliance
IT Architects Alliance
Dec 15, 2021 · Databases

Comprehensive Redis Guide: Data Structures, Commands, Persistence, Performance Tuning, and Deployment Strategies

This article provides a thorough introduction to Redis, covering its core data structures and common commands, persistence options (RDB and AOF), memory‑management and eviction policies, pipelining, transactions and Lua scripting, performance optimization techniques, replication, Sentinel high‑availability, cluster sharding, and a comparison of popular Java clients.

Data StructuresIn-Memory DatabaseJava Client
0 likes · 40 min read
Comprehensive Redis Guide: Data Structures, Commands, Persistence, Performance Tuning, and Deployment Strategies
Ctrip Technology
Ctrip Technology
Dec 9, 2021 · Databases

TiDB Operational Practices at Ctrip: Architecture, Use Cases, Performance Tuning, Monitoring, and Tooling

This article details Ctrip's migration from MySQL to TiDB, describing the multi‑data‑center architecture, real‑world use cases such as the international CDP platform and hotel settlement, performance tuning measures, comprehensive monitoring and alerting, auxiliary tools, and future roadmap for the distributed NewSQL database.

HTAPMonitoringPerformance Tuning
0 likes · 16 min read
TiDB Operational Practices at Ctrip: Architecture, Use Cases, Performance Tuning, Monitoring, and Tooling
Open Source Linux
Open Source Linux
Nov 28, 2021 · Operations

Boost Linux Server Performance: 20 Proven Optimization Techniques

This guide presents twenty practical Linux server optimization methods—from kernel elevator tuning and daemon reduction to TCP tweaks, secure backups, and effective monitoring commands—helping administrators enhance reliability, speed, and security while reducing resource consumption.

LinuxPerformance Tuningkernel
0 likes · 14 min read
Boost Linux Server Performance: 20 Proven Optimization Techniques
Full-Stack DevOps & Kubernetes
Full-Stack DevOps & Kubernetes
Nov 25, 2021 · Cloud Native

Supercharge Jenkins Builds: Tune Pod Resources and Enable Parallel Stages

This guide explains why default Jenkins slave pods often suffer from slow builds or memory shortages, and provides concrete steps—adjusting CPU/memory limits, trimming plugins, using private artifact stores, disabling workspace cleanup, and configuring parallel stages—to dramatically improve Jenkins performance on Kubernetes.

CI/CDJenkinsKubernetes
0 likes · 4 min read
Supercharge Jenkins Builds: Tune Pod Resources and Enable Parallel Stages
StarRocks
StarRocks
Nov 24, 2021 · Big Data

Building a Scalable OLAP Platform at SF Express: StarRocks Evaluation and Lessons

SF Express’s data engineering team details how they migrated from a mixed‑component OLAP stack to a unified StarRocks platform, describing the evaluation criteria, performance‑critical design choices, import and query optimizations, and future roadmap for a high‑availability, low‑cost big‑data analytics solution.

Big DataOLAPPerformance Tuning
0 likes · 14 min read
Building a Scalable OLAP Platform at SF Express: StarRocks Evaluation and Lessons
Java Architect Essentials
Java Architect Essentials
Nov 17, 2021 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑tuning utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download, install, and run them, and shows how to interpret their diagnostic reports to identify configuration issues and optimize database performance.

Database ToolsPerformance Tuningmysql
0 likes · 9 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
Architect
Architect
Nov 10, 2021 · Fundamentals

Deep Dive into JVM: Class Loading, Memory Management, Debugging, Hot Deployment, and Performance Tuning

This comprehensive article explains the inner workings of the Java Virtual Machine, covering class file structure, class loaders, memory layout, garbage collection, execution engine, debugging via JPDA, hot deployment, hot swapping, and performance tuning techniques, providing practical code examples and configuration tips.

JVMMemory ManagementPerformance Tuning
0 likes · 74 min read
Deep Dive into JVM: Class Loading, Memory Management, Debugging, Hot Deployment, and Performance Tuning
Su San Talks Tech
Su San Talks Tech
Nov 8, 2021 · Fundamentals

Mastering JVM Memory: Layout, GC Algorithms, and Tuning Tips

This comprehensive guide explains the JVM memory layout, class‑loading and object‑creation process, the parent‑delegation model, various garbage‑collection algorithms and collectors, GC roots, triggers for YGC and Full GC, and practical tuning parameters to improve Java application performance.

Garbage CollectionJVMMemory Management
0 likes · 15 min read
Mastering JVM Memory: Layout, GC Algorithms, and Tuning Tips
Laiye Technology Team
Laiye Technology Team
Oct 30, 2021 · Databases

Introduction to MySQL Group Replication (MGR) and Its Application in Private Deployments

This article explains the fundamentals, architecture, deployment patterns, recovery procedures, performance tuning, and common troubleshooting of MySQL Group Replication (MGR) as a high‑availability solution for private deployments, illustrated with real‑world examples and practical SQL commands.

Group ReplicationHigh AvailabilityPerformance Tuning
0 likes · 16 min read
Introduction to MySQL Group Replication (MGR) and Its Application in Private Deployments
JavaEdge
JavaEdge
Oct 29, 2021 · Databases

Mastering MySQL: Normal Forms, Storage Engines, Indexes, Transactions, and Optimization

This comprehensive guide covers MySQL fundamentals such as the three normal forms, differences between InnoDB and MyISAM, auto‑increment primary key behavior, index types and design principles, transaction isolation levels, MVCC, logging mechanisms, two‑phase commit, query execution, replication, high‑availability architectures, and practical performance tuning techniques.

Database IndexesInnoDBPerformance Tuning
0 likes · 39 min read
Mastering MySQL: Normal Forms, Storage Engines, Indexes, Transactions, and Optimization
vivo Internet Technology
vivo Internet Technology
Oct 27, 2021 · Backend Development

JVM Garbage Collection Tuning for a Video Service to Reduce P99 Latency

By replacing the default Parallel GC with a ParNew‑CMS collector, enlarging the Young generation, fixing Metaspace settings, and tuning CMS occupancy thresholds, the video service cut Young and Full GC pauses dramatically, lowered Full GC count by over 80%, and achieved more than 30% P99 latency reduction, with some APIs improving up to 80%.

CMSGarbage CollectionJVM
0 likes · 16 min read
JVM Garbage Collection Tuning for a Video Service to Reduce P99 Latency
Liangxu Linux
Liangxu Linux
Oct 17, 2021 · Databases

Why MySQL Eats CPU and How to Slash Its Usage

This article explains which components—user processes, I/O wait, and system interrupts—consume most CPU in MySQL, describes the performance impact of high CPU, and provides concrete strategies such as reducing I/O, simplifying calculations, optimizing indexes, and judiciously scaling hardware to lower CPU usage.

CPU optimizationIO WaitPerformance Tuning
0 likes · 6 min read
Why MySQL Eats CPU and How to Slash Its Usage
Big Data Technology Architecture
Big Data Technology Architecture
Oct 14, 2021 · Databases

Performance Evaluation and Optimization of HBase 2.x Write Operations

This article presents a detailed performance test of HBase 2.x write throughput on a five‑node SSD cluster, identifies latency spikes caused by MemStore flush and ConcurrentSkipListMap size() overhead, and demonstrates how fixing the bug and applying in‑memory compaction dramatically reduces P999 and P9999 latency while preserving throughput.

HBaseIn-Memory CompactionMemStore
0 likes · 10 min read
Performance Evaluation and Optimization of HBase 2.x Write Operations
Liangxu Linux
Liangxu Linux
Sep 26, 2021 · Operations

Master Linux Swap: When, How Much, and How to Optimize Performance

This guide explains what Linux swap is, its advantages and drawbacks, how to size it for different memory configurations, and provides step‑by‑step commands for creating, managing, and tuning swap partitions or files, including swappiness and ZFS considerations.

Memory ManagementPerformance Tuningswap
0 likes · 15 min read
Master Linux Swap: When, How Much, and How to Optimize Performance
Wukong Talks Architecture
Wukong Talks Architecture
Sep 23, 2021 · Backend Development

Comprehensive JVM Garbage Collection Interview Questions and Answers

This article compiles a series of JVM interview questions covering heap partitioning, garbage‑collection algorithms, collector types, memory coordination, tuning strategies, and practical tooling such as jstat, jmap, and MAT, providing detailed explanations and command‑line examples for each topic.

Garbage CollectionJVMJava
0 likes · 27 min read
Comprehensive JVM Garbage Collection Interview Questions and Answers
DevOps Cloud Academy
DevOps Cloud Academy
Sep 21, 2021 · Operations

Practical Elasticsearch Operations and Performance Tuning Guide

This article extends previous Elasticsearch cheat sheets with practical commands and step‑by‑step instructions for shard allocation, replica adjustment, cluster settings, slow‑log configuration, mapping routing, force merge, bulk writes, refresh intervals, translog durability, heap sizing, disk‑space monitoring, and troubleshooting strategies.

ElasticsearchOperationsPerformance Tuning
0 likes · 7 min read
Practical Elasticsearch Operations and Performance Tuning Guide
Programmer DD
Programmer DD
Sep 21, 2021 · Backend Development

Why Adding More Dubbo Connections Doesn’t Always Boost Throughput

This article examines Dubbo’s connection‑control feature, demonstrates how long‑living TCP connections are created, runs benchmark tests with one and two connections, discovers that varying IO thread counts skew results, and shows that increasing connections alone rarely improves throughput.

Connection ControlDubboIO threads
0 likes · 14 min read
Why Adding More Dubbo Connections Doesn’t Always Boost Throughput
Architect
Architect
Sep 9, 2021 · Fundamentals

Understanding JVM Memory Structure: Areas, Allocation, and Tuning

This article provides a comprehensive overview of the Java Virtual Machine memory layout, explaining each region such as the heap, metaspace, stack, program counter, direct memory and code cache, along with allocation strategies, tuning parameters, and practical OOM demonstrations.

Garbage CollectionJVMJava
0 likes · 16 min read
Understanding JVM Memory Structure: Areas, Allocation, and Tuning
High Availability Architecture
High Availability Architecture
Aug 31, 2021 · Cloud Native

High‑Availability Architecture for etcd in Ant Group’s Massive Kubernetes Clusters

The article describes how Ant Group operates a world‑largest Kubernetes deployment of over 10,000 nodes, details the performance challenges of the etcd key‑value store at such scale, and outlines a comprehensive set of hardware upgrades, configuration tuning, monitoring, data‑splitting, and future distributed‑etcd strategies to achieve robust high‑availability.

EtcdPerformance Tuningscale-out
0 likes · 21 min read
High‑Availability Architecture for etcd in Ant Group’s Massive Kubernetes Clusters
FunTester
FunTester
Aug 20, 2021 · Databases

Why Is One MySQL CPU Core at 99%? A Step‑by‑Step Troubleshooting Guide

During a performance test a MySQL server showed one CPU core constantly at 99% while the others were idle, prompting a detailed investigation that checks I/O thread settings, multi‑core utilization, transaction locks, slow‑query logging, and index optimization to resolve the bottleneck.

InnoDBPerformance TuningSQL
0 likes · 6 min read
Why Is One MySQL CPU Core at 99%? A Step‑by‑Step Troubleshooting Guide
MaGe Linux Operations
MaGe Linux Operations
Aug 19, 2021 · Cloud Native

Mastering Kubernetes Scheduling: From Basics to Performance Tuning

This article provides a comprehensive guide to Kubernetes Scheduler, covering its architecture, extension points, API, node affinity, taints and tolerations, scheduling bottlenecks, priority classes, and performance tuning techniques to optimize pod placement in large clusters.

KubernetesNode AffinityPerformance Tuning
0 likes · 13 min read
Mastering Kubernetes Scheduling: From Basics to Performance Tuning
21CTO
21CTO
Aug 16, 2021 · Databases

Why LIMIT with Large Offsets Slows MySQL and How to Fix It

This article explains why MySQL queries using LIMIT with a large offset become extremely slow, demonstrates the inefficiency through a 950‑million‑row table example, and shows how rewriting the query with a sub‑select join reduces execution time from seconds to milliseconds while preserving results.

Buffer PoolInnoDBPerformance Tuning
0 likes · 9 min read
Why LIMIT with Large Offsets Slows MySQL and How to Fix It
Top Architect
Top Architect
Aug 14, 2021 · Big Data

Elasticsearch Overview: Architecture, Core Concepts, and Performance Optimization

This article provides a comprehensive introduction to Elasticsearch, covering its underlying Lucene-based inverted index, data types, shard routing, cluster roles, discovery mechanisms, refresh and translog handling, segment merging, and practical performance and JVM tuning tips for building scalable, near‑real‑time search systems.

ElasticsearchIndexingPerformance Tuning
0 likes · 35 min read
Elasticsearch Overview: Architecture, Core Concepts, and Performance Optimization
MaGe Linux Operations
MaGe Linux Operations
Aug 11, 2021 · Databases

Understanding Cloud MySQL: Instance Types, Replication Modes, and High Availability

This article explains the different Cloud MySQL instance architectures, details asynchronous, semi‑synchronous, and strong synchronous replication, describes high‑availability failover mechanisms, outlines upgrade procedures, and covers binlog usage, rollback methods, slow‑query optimization, and storage fragmentation.

High AvailabilityInstance TypesPerformance Tuning
0 likes · 11 min read
Understanding Cloud MySQL: Instance Types, Replication Modes, and High Availability
ITPUB
ITPUB
Aug 11, 2021 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

This guide introduces four practical MySQL performance‑tuning utilities—MySQLTuner, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run, and interpret their reports to identify configuration issues, memory overload, and slow‑query problems.

Performance Tuningmysqlmysqltuner
0 likes · 8 min read
Boost MySQL Performance: Essential Tools and How to Use Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 11, 2021 · Databases

Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors

The article explains why MySQL can hit the max_connections limit, introduces the MySQL 8.0 administrative connection interface and its configuration variables, demonstrates how to create a privileged user and test connection limits with code examples, and offers best‑practice recommendations to prevent connection saturation.

Administrative Connection InterfaceConnection PoolingDatabase Administration
0 likes · 9 min read
Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 7, 2021 · Big Data

Elasticsearch Optimization Practices and Performance Tuning Guide

This article presents a comprehensive guide on optimizing Elasticsearch for large‑scale data platforms, covering Lucene fundamentals, index and shard architecture, doc‑values usage, routing strategies, practical performance‑tuning techniques, and real‑world testing results to achieve sub‑second query responses on billions of records.

ElasticsearchIndex OptimizationLucene
0 likes · 12 min read
Elasticsearch Optimization Practices and Performance Tuning Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 5, 2021 · Backend Development

Deep Dive into JVM Tuning: Lessons from "Understanding the JVM" (3rd Edition)

The article shares the author’s experience reading the third edition of "Understanding the JVM," focusing on JVM memory management, garbage‑collection algorithms, tuning strategies, and practical tools, while providing concise summaries of each book section and actionable advice for Java performance optimization.

Garbage CollectionJDK toolsJVM
0 likes · 15 min read
Deep Dive into JVM Tuning: Lessons from "Understanding the JVM" (3rd Edition)
Tencent Architect
Tencent Architect
Aug 4, 2021 · Artificial Intelligence

How We Accelerated Feature Hashing for Ad Ranking on GPUs

This article explains how Tencent's Light platform reduced the massive overhead of feature hashing in ad‑ranking by moving integer‑to‑string conversion and hash computation to the GPU, introducing custom contiguous string tensors, and achieving up to 12× speed‑up on V100 GPUs.

GPU OptimizationPerformance TuningTensorFlow
0 likes · 14 min read
How We Accelerated Feature Hashing for Ad Ranking on GPUs
Open Source Linux
Open Source Linux
Aug 1, 2021 · Databases

Why Is MySQL Consuming CPU? Identify and Reduce CPU Bottlenecks

This article explains which components (user processes, IO wait, system interrupts) consume CPU in MySQL, shows their impact on performance, and provides practical strategies to reduce CPU usage through IO optimization, query tuning, data modeling, caching, and hardware upgrades.

CPU BottleneckIO WaitPerformance Tuning
0 likes · 6 min read
Why Is MySQL Consuming CPU? Identify and Reduce CPU Bottlenecks
ITPUB
ITPUB
Jul 28, 2021 · Databases

Master MySQL Performance: Essential SQL Optimization Techniques & Index Strategies

This comprehensive guide walks you through MySQL performance tuning, covering how to monitor server status, identify slow queries, use EXPLAIN for execution plans, create and manage various index types, and apply practical SQL optimizations such as import tricks, insert batching, efficient GROUP BY/ORDER BY, and pagination improvements.

EXPLAINIndexesPerformance Tuning
0 likes · 25 min read
Master MySQL Performance: Essential SQL Optimization Techniques & Index Strategies
Java Architect Essentials
Java Architect Essentials
Jul 25, 2021 · Backend Development

How I Cut Full GC Frequency by 80%: A JVM Tuning Case Study

Over a month of systematic JVM tuning reduced Full GC from 40 times per day to once every ten days and halved Young GC duration by adjusting heap sizes, survivor ratios, and metaspace settings while investigating and fixing a memory leak caused by an anonymous inner class listener.

Garbage CollectionJVMOperations
0 likes · 10 min read
How I Cut Full GC Frequency by 80%: A JVM Tuning Case Study