BestHub
Sign in
Tagged articles

performance tuning

1102 articles · Page 7 of 12
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.

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

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

Index OptimizationInnoDBMySQL
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.

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

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

Load TestingPTSmini-program
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.

ClickHouseOLAPTable Engines
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.

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

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

MySQLindexesperformance tuning
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 PlanMySQLSQL
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.

APMFlinkbig data
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.

Cluster DeploymentDistributed MessagingKafka
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.

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

MySQLSQL optimizationdatabase design
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.

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

ClickHouseOLAPTable Engines
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.

ElasticsearchSegment Optimizationdisk I/O
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.

operating systemperformance tuningserver 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.

Product LifecycleR&D managementperformance tuning
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.

InnoDBMySQLParallel DDL
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 ConcurrencyServerlessSpring Boot
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.

GODEBUGGoProfiling
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 SkewShuffleSpark
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 ToolsMySQLmysqltuner
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.

BackendFull GCJVM
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.

ClusterData StructuresIn-Memory Database
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.

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

KernelLinuxperformance tuning
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.

OLAPSF ExpressStarRocks
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 ToolsMySQLmysqltuner.pl
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.

Class LoadingJVMbytecode enhancement
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.

JVMgarbage collectionmemory management
0 likes · 15 min read
Mastering JVM Memory: Layout, GC Algorithms, and Tuning Tips
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 IndexesInnoDBMySQL
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%.

CMSJVMJava
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 WaitMySQL
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.

Swapmemory managementperformance tuning
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.

JVMJavagarbage collection
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.

ElasticsearchOperationscluster-management
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.

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

Scale-Outetcdperformance tuning
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.

InnoDBMySQLSQL
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 AffinityTaints
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 PoolInnoDBLIMIT OFFSET
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.

Cloud DatabaseInstance TypesMySQL
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.

MySQLmysqltunerpercona-toolkit
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 InterfaceMySQLconnection pooling
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
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 optimizationTensorFlowad ranking
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 WaitMySQL
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.

EXPLAINMySQLSQL optimization
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.

BackendJVMMemory Leak
0 likes · 10 min read
How I Cut Full GC Frequency by 80%: A JVM Tuning Case Study
Efficient Ops
Efficient Ops
Jul 6, 2021 · Operations

Mastering TCP TIME-WAIT: When to Optimize and How

This article explains the purpose of the TCP TIME-WAIT state, the scenarios it protects against, common misconceptions, and practical Linux kernel tweaks—such as fast recycle, socket reuse, and tw_buckets settings—to manage TIME-WAIT efficiently on high‑concurrency servers.

LinuxTCPnetwork operations
0 likes · 8 min read
Mastering TCP TIME-WAIT: When to Optimize and How
Architects Research Society
Architects Research Society
Jul 3, 2021 · Backend Development

Optimizing NGINX and Linux Settings for High Performance

This article provides a practical guide to tuning Linux kernel parameters and NGINX configuration directives—such as backlog queues, file descriptors, worker processes, keepalive connections, access‑log buffering, sendfile, limits, caching and compression—to achieve optimal web server performance for high‑traffic sites.

BackendLinuxNginx
0 likes · 11 min read
Optimizing NGINX and Linux Settings for High Performance
Code Ape Tech Column
Code Ape Tech Column
Jun 20, 2021 · Backend Development

Master JVM Performance: Essential Tools and Real‑World Debugging Guide

This article introduces core JVM performance and monitoring utilities—including jps, jstack, jmap, jhat, jstat, and hprof—explains their command syntax, demonstrates practical steps to locate high‑CPU threads, analyze heap dumps, and interpret GC statistics, and provides concrete code examples for Java developers.

JVMJavajmap
0 likes · 13 min read
Master JVM Performance: Essential Tools and Real‑World Debugging Guide
Kuaishou Tech
Kuaishou Tech
Jun 8, 2021 · Mobile Development

Flutter Audio-Video Practice and Optimization in Kuaishou

This article details Kuaishou's Flutter audio-video implementation, optimization practices, and engineering support, covering video playback via external textures, data communication strategies, FFI integration, and performance tuning.

FFIFlutterKuaishou
0 likes · 17 min read
Flutter Audio-Video Practice and Optimization in Kuaishou
Programmer DD
Programmer DD
May 27, 2021 · Operations

How We Cut Full GC Frequency from 40×/Day to Once Every 10 Days

Over a month of JVM tuning, the author reduced Full GC from more than 40 times per day to once every ten days and halved Young GC duration by adjusting heap sizes, fixing memory leaks, and tuning metaspace, ultimately improving server throughput and stability.

Full GCJVMJava
0 likes · 12 min read
How We Cut Full GC Frequency from 40×/Day to Once Every 10 Days