BestHub
Sign in
Tagged articles

Performance Tuning

1016 articles · Page 4 of 11
Architects' Tech Alliance
Architects' Tech Alliance
Sep 20, 2024 · Operations

Unlocking Kunpeng CPU Performance: Real-World Optimization Techniques and Benchmarks

This article provides a comprehensive, step‑by‑step guide to tuning Kunpeng‑based servers, covering hardware characteristics, matrix‑multiplication benchmarks, NUMA‑aware scheduling, compiler and JDK optimizations, acceleration libraries, disk and NIC tuning, and a practical MariaDB performance‑tuning workflow.

CPU optimizationKunpengLinux
0 likes · 17 min read
Unlocking Kunpeng CPU Performance: Real-World Optimization Techniques and Benchmarks
MaGe Linux Operations
MaGe Linux Operations
Sep 19, 2024 · Backend Development

Mastering Nginx: From Basics to Advanced Configuration and Optimization

This comprehensive guide covers Nginx's history, core features, modular architecture, installation methods, global performance tuning, and detailed HTTP, server, and location directives, providing practical code examples and configuration snippets for building high‑performance web services.

ConfigurationNGINXPerformance Tuning
0 likes · 27 min read
Mastering Nginx: From Basics to Advanced Configuration and Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 19, 2024 · Databases

Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues

This article explains how to troubleshoot a slow OceanBase stored procedure by locating its trace_id, analyzing audit logs to identify non‑cached UPDATE statements, revealing that preceding TRUNCATE operations invalidate the plan cache, and finally recommending replacing TRUNCATE with DELETE to restore performance.

DatabaseOceanBasePerformance Tuning
0 likes · 10 min read
Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues
Architects' Tech Alliance
Architects' Tech Alliance
Sep 12, 2024 · Industry Insights

Managing and Optimizing Large‑Scale AI Compute Clusters: Practical Insights

This article examines the key pain points of massive AI compute clusters—including heterogeneous hardware compatibility, efficient scheduling, training and inference acceleration, and fault‑tolerant operations—while presenting practical management and performance‑tuning strategies, a cloud‑native AI platform implementation, and future directions for the ecosystem.

AI computingOperationsPerformance Tuning
0 likes · 7 min read
Managing and Optimizing Large‑Scale AI Compute Clusters: Practical Insights
dbaplus Community
dbaplus Community
Sep 10, 2024 · Databases

Boost MySQL Performance: Essential Tools, Installation & Report Analysis

This guide introduces four popular MySQL performance‑tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—provides download commands, usage examples, and detailed tips for interpreting their diagnostic reports to improve database configuration and query efficiency.

Database ToolsMySQLPerformance Tuning
0 likes · 8 min read
Boost MySQL Performance: Essential Tools, Installation & Report Analysis
Qunar Tech Salon
Qunar Tech Salon
Aug 28, 2024 · Databases

Why Vector Databases Are Needed, PgVector Installation, Usage, and Operational Practices in PostgreSQL

This article explains the necessity of vector databases for AI workloads, reviews the PostgreSQL ecosystem, compares vector database options, provides detailed PgVector installation and usage steps, shares operational best‑practices, performance tuning tips, and real‑world deployment cases at Qunar and Tujia.

AIPerformance TuningPostgreSQL
0 likes · 24 min read
Why Vector Databases Are Needed, PgVector Installation, Usage, and Operational Practices in PostgreSQL
Baidu Geek Talk
Baidu Geek Talk
Aug 26, 2024 · Artificial Intelligence

RLHF Performance Optimization: PPO Algorithm Acceleration Techniques

The article presents three RLHF‑PPO acceleration techniques—TRT‑LLM‑based text generation speedups, selective activation recomputation with sequence parallelism for dynamic memory reduction, and overlapping pipeline stages for system‑level parallelism—demonstrating a 350 % throughput boost on a 10 B model using 16 A100 GPUs.

GPU OptimizationLarge Language ModelsPPO optimization
0 likes · 16 min read
RLHF Performance Optimization: PPO Algorithm Acceleration Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 26, 2024 · Databases

Understanding and Managing MySQL Undo Tablespaces

This article explains the purpose, evolution, configuration parameters, and step‑by‑step maintenance procedures for MySQL Undo tablespaces, covering versions from pre‑5.6 to 8.0 and providing practical commands for viewing, creating, truncating, and dropping Undo tablespaces.

Database AdministrationInnoDBMySQL
0 likes · 11 min read
Understanding and Managing MySQL Undo Tablespaces
dbaplus Community
dbaplus Community
Aug 18, 2024 · Databases

Master MySQL Performance: Key Query Optimizations, Index Tips & Config Tweaks

This guide covers practical MySQL performance improvements, including choosing proper data types, avoiding SELECT *, optimizing joins and UNION usage, batch inserts, query cache settings, configuration parameters like innodb_buffer_pool_size, and comprehensive index strategies to accelerate queries and reduce resource consumption.

Database ConfigurationIndexingMySQL
0 likes · 18 min read
Master MySQL Performance: Key Query Optimizations, Index Tips & Config Tweaks
Architect
Architect
Aug 13, 2024 · Databases

Optimizing HBase for a Large‑Scale Content Platform: Selection, Performance Tuning, and Best Practices

This article examines why the unified content platform switched from MongoDB to HBase, outlines HBase’s high‑performance, scalability, and consistency features, and details four optimization techniques—including cluster upgrade, connection pooling, column‑read strategy, and compaction tuning—that significantly improved read/write latency and operational stability.

HBaseNoSQLPerformance Tuning
0 likes · 15 min read
Optimizing HBase for a Large‑Scale Content Platform: Selection, Performance Tuning, and Best Practices
Java Architect Essentials
Java Architect Essentials
Aug 9, 2024 · Databases

Comprehensive MySQL Query and Configuration Optimization Guide

This article provides a thorough guide to MySQL performance optimization, covering general query improvements, proper data types, index usage, configuration parameter tuning, avoiding common pitfalls, and detailed EXPLAIN analysis, with concrete SQL examples and practical recommendations for developers and DBAs.

Database ConfigurationIndexingMySQL
0 likes · 16 min read
Comprehensive MySQL Query and Configuration Optimization Guide
Architect
Architect
Aug 9, 2024 · Backend Development

Why Nginx Outperforms Others: Deep Dive into Architecture, Modules, and Tuning

This comprehensive guide explains Nginx's high‑performance architecture, module system, multi‑process model, FastCGI integration, configuration best practices, tuning techniques, error troubleshooting, and a known PHP‑related vulnerability, providing practical steps for optimal deployment on Linux servers.

LinuxNGINXPerformance Tuning
0 likes · 47 min read
Why Nginx Outperforms Others: Deep Dive into Architecture, Modules, and Tuning
Top Architect
Top Architect
Aug 3, 2024 · Backend Development

Optimizing a High‑Concurrency Transaction Statistics Interface from 30 seconds to Sub‑Second Performance

This article presents a real‑world case study of a high‑concurrency data‑processing interface whose response time was reduced from 30 seconds to under one second by diagnosing SQL bottlenecks, refactoring MyBatis code, applying PostgreSQL array aggregation, and introducing a Caffeine cache, while also discussing the limits of relational databases and promoting related AI services.

Backend DevelopmentCachingCaffeine
0 likes · 13 min read
Optimizing a High‑Concurrency Transaction Statistics Interface from 30 seconds to Sub‑Second Performance
JD Retail Technology
JD Retail Technology
Aug 2, 2024 · Operations

JVM Memory Model, Garbage Collection, and Optimization Guide

This article explains the JVM memory architecture, object lifecycle, young and old generation garbage‑collection mechanisms, tuning goals such as low latency, high throughput and large heap, and provides practical advice on monitoring, common memory‑related problems, and choosing appropriate collectors for different application scenarios.

Garbage CollectionJVMJava
0 likes · 17 min read
JVM Memory Model, Garbage Collection, and Optimization Guide
JD Tech
JD Tech
Jul 26, 2024 · Databases

Database Performance Governance and Optimization for a High‑Load MySQL Application

This technical report describes the current high‑resource MySQL deployment, analyzes disk, table‑space, QPS and slow‑SQL issues, and presents a set of governance goals and concrete solutions—including data migration, query interception, and read‑from‑slave strategies—backed by code samples, tables and scripts to reduce load and improve stability before a major sales event.

Data MigrationPerformance TuningQPS Reduction
0 likes · 23 min read
Database Performance Governance and Optimization for a High‑Load MySQL Application
Top Architect
Top Architect
Jul 24, 2024 · Databases

Top 20 SQL Optimization Techniques for Better Query Performance

This article presents twenty practical SQL optimization techniques—including index usage, selective column queries, avoiding functions in WHERE clauses, replacing subqueries with joins, limiting result sets, using EXISTS, batch inserts, covering indexes, proper data types, pagination, and transaction management—to significantly improve query performance and database efficiency.

IndexesPerformance TuningSQL
0 likes · 11 min read
Top 20 SQL Optimization Techniques for Better Query Performance
Programmer DD
Programmer DD
Jul 24, 2024 · Databases

How We Cut Redis Costs by $460k Monthly: 10 Proven Optimization Strategies

In 2023, a TapTap infra team reduced Redis operating costs by 460,000 CNY per month through low‑cost ESSD instances, traffic compression, unused‑instance cleanup, TTL management, data migration, online compression, and targeted cleaning, detailing ten concrete measures and the open‑source tools that enabled zero‑downtime optimization.

Database ManagementPerformance TuningRedis
0 likes · 17 min read
How We Cut Redis Costs by $460k Monthly: 10 Proven Optimization Strategies
ITPUB
ITPUB
Jul 13, 2024 · Databases

How One SQL Crashed a Core System for 12 Hours – Oracle Performance Troubleshooting

A single runaway SQL caused a 12‑hour outage of a core Oracle system; the article walks through the fault symptoms, AWR and ASH analysis, abnormal SQL identification, execution‑plan changes caused by partition operations, and the step‑by‑step remediation that restored performance.

AWRDirect Path ReadOracle
0 likes · 8 min read
How One SQL Crashed a Core System for 12 Hours – Oracle Performance Troubleshooting
JavaEdge
JavaEdge
Jul 8, 2024 · Backend Development

Master Java Metaspace: Tuning Metadata GC Threshold and JVM Flags

This article explains Java Metaspace and metadata GC thresholds, compares PermGen with Metaspace, and provides detailed JVM flag configurations—including size settings and compressed pointer options—to help developers optimize memory usage and garbage‑collection performance.

Garbage CollectionJavaMemory Management
0 likes · 8 min read
Master Java Metaspace: Tuning Metadata GC Threshold and JVM Flags
Architects' Tech Alliance
Architects' Tech Alliance
Jul 4, 2024 · Industry Insights

How to Optimize Kunpeng CPU Performance and Key Industry Trends

This article outlines the main directions for server performance tuning—CPU, memory, disk, and network—explains the typical workflow of metric collection, bottleneck analysis, and parameter optimization, and provides a curated list of recent CPU industry reports and technical resources.

CPUKunpengPerformance Tuning
0 likes · 5 min read
How to Optimize Kunpeng CPU Performance and Key Industry Trends
ITPUB
ITPUB
Jun 30, 2024 · Databases

How Implicit Type Conversion Can Kill PostgreSQL Query Performance by 10,000×

This article explains how implicit type conversions in PostgreSQL can cause index loss, drastically misestimate row counts, and force inefficient join strategies, illustrating the issue with concrete examples, detailed execution plans, and step‑by‑step optimizations that restore index usage and boost performance thousands of times.

Index OptimizationPerformance TuningPostgreSQL
0 likes · 13 min read
How Implicit Type Conversion Can Kill PostgreSQL Query Performance by 10,000×
High Availability Architecture
High Availability Architecture
Jun 27, 2024 · Backend Development

Understanding and Tuning Z Garbage Collector (ZGC) for Low‑Latency Java Applications

This article explains the principles, features, and workflow of Java's Z Garbage Collector, provides detailed configuration and logging guidance, and shares AutoMQ's practical tuning experiences that achieve sub‑millisecond pause times and improved performance for latency‑sensitive backend services.

AutoMQGarbage CollectionJava
0 likes · 26 min read
Understanding and Tuning Z Garbage Collector (ZGC) for Low‑Latency Java Applications
Practical DevOps Architecture
Practical DevOps Architecture
Jun 24, 2024 · Backend Development

Comprehensive Backend Development and Cloud Native Training Curriculum

This document outlines a detailed training curriculum covering backend development, cloud-native technologies, microservice frameworks, databases, messaging systems, containerization, orchestration, performance tuning, and related tools, presented as a series of numbered sessions with practical labs and theory.

Cloud NativeMicroservicesPerformance Tuning
0 likes · 7 min read
Comprehensive Backend Development and Cloud Native Training Curriculum
StarRocks
StarRocks
Jun 18, 2024 · Databases

How StarRocks Compaction Boosts Query Performance: Mechanics, Tuning, and Best Practices

This article explains StarRocks' compaction process that merges multiple data versions into larger files to reduce I/O, details the scheduler and executor roles, shows how to monitor and control compaction via SQL commands, and provides tuning parameters and best‑practice recommendations for optimal performance.

CompactionData ManagementPerformance Tuning
0 likes · 21 min read
How StarRocks Compaction Boosts Query Performance: Mechanics, Tuning, and Best Practices
Top Architect
Top Architect
Jun 16, 2024 · Databases

20 Essential SQL Optimization Techniques for Better Query Performance

This article presents twenty practical SQL optimization techniques—including index usage, selective column queries, avoiding functions in WHERE clauses, replacing subqueries with joins, limiting result sets, using prepared statements, proper data types, and transaction handling—to improve query performance and overall database efficiency.

IndexesPerformance TuningQueries
0 likes · 11 min read
20 Essential SQL Optimization Techniques for Better Query Performance
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Jun 3, 2024 · Databases

Master OpenGemini: From Schema Design to Performance Tuning Best Practices

This article summarizes a live session where Shawn explains how understanding business scenarios drives effective OpenGemini database design, and provides comprehensive best‑practice guidance on library and table design, data ingestion, query optimization, and performance tuning for time‑series workloads.

Performance TuningQuery OptimizationSharding
0 likes · 7 min read
Master OpenGemini: From Schema Design to Performance Tuning Best Practices
macrozheng
macrozheng
May 28, 2024 · Backend Development

Why Upgrading to JDK 17 with ZGC Can Slash GC Pauses to Sub‑millisecond

This article explains how moving to JDK 17 and the low‑latency ZGC garbage collector can reduce pause times to under 10 ms, improve throughput, and meet demanding real‑time service requirements, while providing practical upgrade steps, JVM tuning parameters, and performance comparisons.

Backend DevelopmentGarbage CollectionJava
0 likes · 8 min read
Why Upgrading to JDK 17 with ZGC Can Slash GC Pauses to Sub‑millisecond
Architecture Digest
Architecture Digest
May 27, 2024 · Backend Development

Upgrading to JDK 17 with ZGC: Performance Comparison and Migration Guide

This article explains why upgrading to JDK 17 and switching to the low‑latency ZGC garbage collector can dramatically reduce pause times and improve throughput, compares GC and CPU metrics against G1, and provides step‑by‑step installation and JVM tuning instructions with code examples.

Garbage CollectionJVMJava
0 likes · 6 min read
Upgrading to JDK 17 with ZGC: Performance Comparison and Migration Guide
Top Architect
Top Architect
May 9, 2024 · Databases

Effective Indexing Strategies for Database Performance

This article provides comprehensive guidance on effective database indexing, covering when and how to create various index types, practical SQL examples, strategies for equality, range, fuzzy, join, and composite queries, and tips for verifying index usage with EXPLAIN.

Performance Tuningdatabase indexingsql-optimization
0 likes · 11 min read
Effective Indexing Strategies for Database Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
May 8, 2024 · Databases

OceanBase DBA from Beginner to Practice: Comprehensive Tutorial and Learning Path

The OceanBase community offers a detailed, eight‑session DBA tutorial covering the platform’s architecture, deployment, migration, performance tuning, diagnostic tools, and ecosystem components, complemented by live streaming, hands‑on exercises, certification incentives, and real‑world user testimonials to help developers and DBAs master this distributed database.

Database AdministrationOceanBasePerformance Tuning
0 likes · 9 min read
OceanBase DBA from Beginner to Practice: Comprehensive Tutorial and Learning Path
Baidu Geek Talk
Baidu Geek Talk
Apr 17, 2024 · Industry Insights

Mastering Multi-CPU Performance: Challenges and One-Click Tuning with Btune

The talk outlines how modern data centers host diverse CPUs (Intel, AMD, Ampere, ARM), the multi‑layer performance‑tuning challenges this creates, and how Baidu Cloud’s one‑click Btune suite automates metric collection, bottleneck identification, and optimization across hardware, kernel, runtime, and application layers.

BtuneCPUData Center
0 likes · 19 min read
Mastering Multi-CPU Performance: Challenges and One-Click Tuning with Btune
Liangxu Linux
Liangxu Linux
Apr 16, 2024 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

Learn how to assess and optimize your MySQL database using four powerful open‑source tools—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—complete with download links, command‑line usage examples, and guidance on interpreting their diagnostic reports to improve performance and security.

Database ToolsMySQLOpen-source
0 likes · 9 min read
Boost MySQL Performance: Essential Tools and How to Use Them
Baidu Intelligent Cloud Tech Hub
Baidu Intelligent Cloud Tech Hub
Apr 16, 2024 · Operations

Tackling Multi-CPU Performance Challenges with Baidu’s One-Click Btune

At QCon 2024, Baidu Intelligent Cloud presented the complexities of optimizing diverse CPU architectures in data centers and introduced Btune, a one‑click solution that automates bottleneck detection, analysis, and performance tuning across Intel, AMD, and ARM platforms, enabling engineers to boost service efficiency.

BtuneCPU performanceCloud Computing
0 likes · 18 min read
Tackling Multi-CPU Performance Challenges with Baidu’s One-Click Btune
Liangxu Linux
Liangxu Linux
Apr 14, 2024 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article presents eight practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting joins, handling mixed ordering, replacing EXISTS with joins, pushing down conditions, pre‑filtering data, and using WITH clauses—to dramatically reduce query execution time.

IndexesMySQLPerformance Tuning
0 likes · 13 min read
Boost MySQL Performance: 8 Proven SQL Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2024 · Databases

OceanBase DBA: From Beginner to Practice – Comprehensive Tutorial Series and E‑Book

OceanBase, a distributed open‑source database, offers a free e‑book and an eight‑session tutorial series covering installation, migration, operation, performance tuning, diagnostics, and ecosystem tools such as OCP, OMS, ODC, and obdiag, aimed at students, developers, and DBAs seeking practical skills and certification.

DBAOceanBasePerformance Tuning
0 likes · 10 min read
OceanBase DBA: From Beginner to Practice – Comprehensive Tutorial Series and E‑Book
Linux Code Review Hub
Linux Code Review Hub
Apr 9, 2024 · Fundamentals

How PCIe Configuration Impacts Performance

This article explains how PCIe width, speed, Max Payload Size, and Max Read Request affect network adapter performance, shows how to query and adjust these attributes with lspci and setpci, and provides formulas and examples for calculating the resulting PCIe bandwidth limits.

Bandwidth CalculationNetwork AdapterPCIe
0 likes · 8 min read
How PCIe Configuration Impacts Performance
Efficient Ops
Efficient Ops
Apr 6, 2024 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article explores eight common MySQL performance pitfalls—from inefficient LIMIT usage and implicit type conversion to subquery joins, mixed ordering, EXISTS clauses, condition pushdown, early result limiting, and intermediate result set optimization—offering concrete rewrites and execution plan analyses to dramatically speed up queries.

DatabaseMySQLPerformance Tuning
0 likes · 14 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
MaGe Linux Operations
MaGe Linux Operations
Mar 31, 2024 · Backend Development

Mastering Tomcat Performance: Key Tuning Parameters and Best Practices

This article explains how to optimize Tomcat by adjusting server.xml parameters such as maxThreads, acceptCount, maxConnections, and connectionTimeout, while also covering related Linux kernel settings, file descriptor limits, and JVM options to achieve balanced performance for both CPU‑bound and I/O‑bound workloads.

JVMLinux kernelPerformance Tuning
0 likes · 14 min read
Mastering Tomcat Performance: Key Tuning Parameters and Best Practices
NetEase Cloud Music Tech Team
NetEase Cloud Music Tech Team
Mar 21, 2024 · Mobile Development

Payment Link Optimization Practices for NetEase Cloud Music

In 2023 NetEase Cloud Music’s membership team overhauled its payment link by optimizing React‑Native checkout pages, pre‑fetching iOS IAP data, updating Android third‑party SDKs, and adding failure‑reminder SMS, boosting FCP and LCP scores, purchase UV, conversion, and overall payment success rates.

AndroidHermesIAP
0 likes · 14 min read
Payment Link Optimization Practices for NetEase Cloud Music
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 21, 2024 · Fundamentals

Mastering JVM Memory: From Heap Layout to Garbage Collection Tuning

This article provides a comprehensive guide to JVM internals, covering runtime data areas, heap segmentation, object allocation, reference types, class loading phases, garbage collection algorithms, collector choices across JDK versions, performance tuning commands, and practical troubleshooting techniques for production Java applications.

Garbage CollectionJVMMemory Management
0 likes · 38 min read
Mastering JVM Memory: From Heap Layout to Garbage Collection Tuning
Zhuanzhuan Tech
Zhuanzhuan Tech
Mar 6, 2024 · Databases

Diagnosing and Resolving MySQL Optimizer Mis‑selection of Indexes

This article recounts a real‑world incident where MySQL 5.7 chose a sub‑optimal index, causing a three‑second slow query, and explains how the team identified the root cause, used EXPLAIN and optimizer trace, and applied fixes such as forced index hints and data cleanup.

EXPLAINIndex SelectionMySQL
0 likes · 11 min read
Diagnosing and Resolving MySQL Optimizer Mis‑selection of Indexes
MaGe Linux Operations
MaGe Linux Operations
Mar 1, 2024 · Operations

Master Linux Virtualization: Tuning KVM Performance with Tuned and KSM

This guide walks through Linux virtualization management and performance tuning, covering tuned profiles for guests and hosts, kernel parameters, NUMA awareness, CPU pinning, memory limits, KSM configuration, qcow2 image creation, disk cache modes, I/O throttling, and monitoring commands to optimize KVM workloads.

KSMKVMLinux
0 likes · 21 min read
Master Linux Virtualization: Tuning KVM Performance with Tuned and KSM
Su San Talks Tech
Su San Talks Tech
Mar 1, 2024 · Backend Development

Master JVM Tuning: When, How, and Which Tools to Optimize Java Performance

This article explains why JVM tuning matters, identifies scenarios that require tuning such as performance bottlenecks, memory overflows, and concurrency issues, and then details monitoring and diagnostic tools—including JDK command‑line utilities and third‑party solutions—followed by a comprehensive guide to JVM parameters, garbage‑collector selection, and practical ways to apply these settings in production environments.

JVMJavaPerformance Tuning
0 likes · 18 min read
Master JVM Tuning: When, How, and Which Tools to Optimize Java Performance
Top Architect
Top Architect
Feb 20, 2024 · Backend Development

JVM Garbage Collection Tuning Experience: Reducing FullGC Frequency and Solving Memory Leaks

Over a month of systematic JVM tuning, the author reduced FullGC frequency from 40 times per day to once every ten days, halved YoungGC time, identified and fixed a memory leak caused by anonymous inner‑class listeners, and documented the step‑by‑step optimization process with configuration changes and performance results.

Garbage CollectionJVMJava
0 likes · 12 min read
JVM Garbage Collection Tuning Experience: Reducing FullGC Frequency and Solving Memory Leaks
JD Cloud Developers
JD Cloud Developers
Feb 6, 2024 · Operations

How We Boosted Nginx Performance 50× by Tuning Gzip Settings

This article documents a real‑world Nginx optimization case where adjusting gzip compression levels and switching to static gzip reduced CPU usage dramatically, enabling a 9‑wan QPS load to be handled with only 7% CPU and achieving over a 50‑fold performance gain.

NGINXOperationsPerformance Tuning
0 likes · 8 min read
How We Boosted Nginx Performance 50× by Tuning Gzip Settings
ITPUB
ITPUB
Jan 8, 2024 · Databases

How I Cut an 8‑Second SQL Query to 0.7 Seconds: Step‑by‑Step Optimization

This article walks through a real‑world case of a slow MySQL query that took 8 seconds, explains how the original use of EXISTS and NOT EXISTS caused performance bottlenecks, and details two successive rewrites—first using JOIN + GROUP BY, then replacing NOT EXISTS with NOT IN—bringing execution time down to 0.7 seconds while highlighting key indexing and testing lessons.

DatabaseIndexesMySQL
0 likes · 7 min read
How I Cut an 8‑Second SQL Query to 0.7 Seconds: Step‑by‑Step Optimization
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Dec 31, 2023 · Operations

Master JDK Command-Line Tools for JVM Performance Tuning: A Practical Guide

This guide explores the JDK command‑line utilities located in %JAVA_HOME%\bin, explaining how tools such as jps, jstat, jinfo, jmap, jhat and jstack can be used to monitor JVM processes, analyze performance bottlenecks, inspect memory usage, generate heap dumps, and adjust runtime parameters for more efficient and stable Java applications.

Command-line ToolsJDKJVM
0 likes · 8 min read
Master JDK Command-Line Tools for JVM Performance Tuning: A Practical Guide
Huolala Tech
Huolala Tech
Dec 27, 2023 · Big Data

How HBase Compaction Tuning Boosts Performance at Scale

This article explains LSM‑Tree based HBase compaction concepts, compares Minor and Major compactions, and shares practical tuning steps—including disabling automatic major compactions, controlling merge size, leveraging off‑peak windows, and improving merge efficiency—to reduce I/O, CPU usage, and latency in production environments.

Big DataCompactionHBase
0 likes · 11 min read
How HBase Compaction Tuning Boosts Performance at Scale
Code Ape Tech Column
Code Ape Tech Column
Dec 26, 2023 · Databases

Eight Major Database Optimization Strategies for Backend Engineers

This article outlines eight comprehensive database optimization approaches—reducing data volume, using space for performance, selecting appropriate storage systems, and related techniques such as data archiving, intermediate tables, serialization, sharding, distributed caching, read‑write splitting, and CQRS—to help backend engineers systematically address common performance bottlenecks.

Backend EngineeringCQRSPerformance Tuning
0 likes · 23 min read
Eight Major Database Optimization Strategies for Backend Engineers
Su San Talks Tech
Su San Talks Tech
Dec 26, 2023 · Backend Development

How to Diagnose and Resolve RocketMQ Message Accumulation Issues

This article explains why RocketMQ messages can pile up, analyzes the consumer pull‑process bottlenecks of consumption latency and concurrency, and provides practical strategies—including logging, JVM stack inspection, and concurrency tuning—to identify and eliminate the root causes of message backlog.

Consumer LagJavaMessage Accumulation
0 likes · 10 min read
How to Diagnose and Resolve RocketMQ Message Accumulation Issues
dbaplus Community
dbaplus Community
Dec 24, 2023 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

When a system’s data grows, MySQL queries can become slow and cause latency; this article presents practical optimization strategies—including query tuning, pagination, join improvements, subquery replacement, order‑by and group‑by enhancements, and count() efficiency—illustrated with sample tables, code snippets, and performance screenshots.

GROUP BYIndexingJOIN
0 likes · 13 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 20, 2023 · Databases

Analyzing and Resolving Slow Query Plan Issues in OceanBase 3.2.3

This article presents a step‑by‑step investigation of a SELECT statement that became 1000× slower in OceanBase 3.2.3 BP8, explains why the optimizer chose an inefficient I5 index, describes the plan‑expiration logic, and provides reproducible scripts and practical recommendations for fixing the problem.

OceanBasePerformance TuningPlan Cache
0 likes · 19 min read
Analyzing and Resolving Slow Query Plan Issues in OceanBase 3.2.3
Sanyou's Java Diary
Sanyou's Java Diary
Dec 14, 2023 · Operations

Why Is My Redis Slowing Down? A Complete Diagnosis and Optimization Guide

This article explains how to determine whether Redis is truly experiencing latency spikes, outlines a step‑by‑step benchmarking process, identifies common causes such as high‑complexity commands, big keys, memory limits, fork overhead, AOF settings, CPU binding, swap usage, and provides concrete configuration and code examples to resolve each issue.

AOFLatencyPerformance Tuning
0 likes · 39 min read
Why Is My Redis Slowing Down? A Complete Diagnosis and Optimization Guide
JavaEdge
JavaEdge
Dec 10, 2023 · Backend Development

How to Size Java Thread Pools for Optimal Performance

This guide explains why thread pools are essential in Java, walks through factors such as CPU cores, I/O latency, and workload characteristics, and provides formulas and concrete code examples for calculating the ideal pool size for both CPU‑bound and I/O‑bound tasks.

CPU BoundI/O BoundJava
0 likes · 14 min read
How to Size Java Thread Pools for Optimal Performance
DataFunTalk
DataFunTalk
Dec 10, 2023 · Artificial Intelligence

PyTorch Model Training Performance Tuning Guide

This guide provides comprehensive techniques for optimizing PyTorch training performance and efficiency, covering all model types such as CNNs, RNNs, GANs, and transformers, and applicable across domains like computer vision and natural language processing, targeting AI/ML platform engineers, data engineers, backend developers, MLOps, SREs, architects, and machine learning engineers.

AIDeep LearningPerformance Tuning
0 likes · 2 min read
PyTorch Model Training Performance Tuning Guide
Architecture Digest
Architecture Digest
Dec 6, 2023 · Databases

MySQL Query Optimization and Index Tuning: From Subqueries to Joins

This article analyzes a slow MySQL query that scans millions of rows to find students scoring 100 in Chinese, then demonstrates how adding appropriate single‑column and composite indexes, rewriting the query as a join, and using covering indexes can reduce execution time from hours to milliseconds.

MySQLPerformance TuningQuery Optimization
0 likes · 10 min read
MySQL Query Optimization and Index Tuning: From Subqueries to Joins
DataFunSummit
DataFunSummit
Nov 18, 2023 · Artificial Intelligence

PyTorch Model Training Performance Tuning Guide with Alluxio

This guide explains how Ant Group uses Alluxio to overcome storage I/O, capacity, and latency challenges, delivering stability, performance, and scalability improvements for large‑scale PyTorch model training while reducing infrastructure costs and providing practical optimization techniques and code examples.

AIAlluxioPerformance Tuning
0 likes · 4 min read
PyTorch Model Training Performance Tuning Guide with Alluxio
Ops Development Stories
Ops Development Stories
Nov 16, 2023 · Fundamentals

Unlocking G1 GC: Why Your Java Service Hangs and How to Fix It

This article explains the G1 garbage collector’s heap layout, collection cycles, pause prediction, log analysis, and monitoring tools, helping Java developers diagnose and resolve performance issues such as frequent restarts, OOM, CPU spikes, and periodic latency spikes.

G1GCGarbage CollectionJVM
0 likes · 19 min read
Unlocking G1 GC: Why Your Java Service Hangs and How to Fix It
HelloTech
HelloTech
Nov 9, 2023 · Cloud Computing

Apollo Configuration Bandwidth Issues and Design Analysis

The article examines how Apollo’s long‑polling and push‑pull design cause massive database bandwidth spikes during large namespace updates in promotion periods, analyzes the RemoteConfigLongPollService and repository code, and proposes three optimizations—key‑level synchronization, MD5‑based change detection, and circuit‑breaker handling—while weighing real‑time versus periodic update trade‑offs.

ApolloCloud ComputingPerformance Tuning
0 likes · 10 min read
Apollo Configuration Bandwidth Issues and Design Analysis
政采云技术
政采云技术
Nov 7, 2023 · Databases

Sharding-JDBC Startup Optimization: Analyzing and Tuning max.connections.size.per.query

This article investigates why Sharding-JDBC takes over half of the application startup time to load metadata, explains the role of the max.connections.size.per.query setting, demonstrates how adjusting it speeds up startup, and discusses the trade‑offs and potential dead‑lock risks of increasing the value.

Connection PoolDatabase ConfigurationPerformance Tuning
0 likes · 7 min read
Sharding-JDBC Startup Optimization: Analyzing and Tuning max.connections.size.per.query
OPPO Kernel Craftsman
OPPO Kernel Craftsman
Nov 2, 2023 · Industry Insights

OPPO’s Kernel Tweaks: Dynamic HugePages and Scheduler Boosts for Smoother ColorOS

At the 18th China Linux Kernel Developer Conference, OPPO unveiled memory and scheduler optimizations—including a dynamic 64 KB huge‑page scheme, LRU reclamation improvements, and a latency‑aware scheduler balance—that collectively raise memory access performance by over 10 %, reduce lock contention, and lower frame‑drop and audio‑stutter rates, demonstrating the impact of programmable kernel technologies on Android smoothness.

Linux kernelMemory optimizationMobile OS
0 likes · 7 min read
OPPO’s Kernel Tweaks: Dynamic HugePages and Scheduler Boosts for Smoother ColorOS
Laravel Tech Community
Laravel Tech Community
Nov 1, 2023 · Databases

MySQL my.cnf Configuration Parameters Reference

This article presents a detailed reference of MySQL server configuration options (my.cnf), explaining each setting such as storage engine, networking, replication, logging, cache sizes, and performance‑related parameters to help administrators fine‑tune their databases.

Database ConfigurationMySQLPerformance Tuning
0 likes · 12 min read
MySQL my.cnf Configuration Parameters Reference
Liangxu Linux
Liangxu Linux
Oct 28, 2023 · Operations

Mastering Linux TCP Performance: Tuning Queues, Buffers, and Offloading

This guide explains how to optimize Linux TCP performance by classifying and tuning kernel parameters related to connection establishment, packet reception, and packet transmission, covering queues, buffers, NIC bonding, multi‑queue IRQ affinity, RingBuffer settings, and offloading features.

BuffersPerformance Tuningkernel parameters
0 likes · 14 min read
Mastering Linux TCP Performance: Tuning Queues, Buffers, and Offloading
ITPUB
ITPUB
Oct 16, 2023 · Databases

Why Did Our Redis Calls Take 1.2 Seconds? A Deep Dive into JedisPool Tuning

A load test revealed Redis latency soaring to 1.2 seconds, and a systematic investigation traced the root cause to mis‑configured JedisPool parameters, leading to excessive connection wait times and churn, which were fixed by aligning pool settings and enabling proper eviction, dramatically improving latency.

Connection PoolJedisPoolLatency
0 likes · 8 min read
Why Did Our Redis Calls Take 1.2 Seconds? A Deep Dive into JedisPool Tuning
Sanyou's Java Diary
Sanyou's Java Diary
Oct 6, 2023 · Backend Development

Inside Kafka Broker: How Its Network Architecture Handles Millions of Requests

This article deeply dissects Kafka Broker's network architecture and request‑processing pipeline, covering sequential, multithreaded, and event‑driven designs, the Reactor pattern, Acceptor and Processor threads, core request flow, and practical tuning parameters for high‑throughput, low‑latency deployments.

Backend DevelopmentHigh concurrencyKafka
0 likes · 22 min read
Inside Kafka Broker: How Its Network Architecture Handles Millions of Requests
ITPUB
ITPUB
Sep 28, 2023 · Databases

Redis Latency Mystery: How to Diagnose and Fix Slow Redis Calls

When a Redis‑backed service suddenly experiences high response times, this guide walks through systematic troubleshooting steps—checking server resources, network latency, Redis metrics, slow‑log, memory fragmentation, big keys, and hot keys—culminating in practical solutions such as pipelining, read/write splitting, and cache layering.

Performance TuningRedis
0 likes · 24 min read
Redis Latency Mystery: How to Diagnose and Fix Slow Redis Calls
Efficient Ops
Efficient Ops
Sep 24, 2023 · Big Data

Mastering Kafka: From Basics to Advanced Operations and Performance Tuning

This article provides a comprehensive overview of Apache Kafka, covering its architecture, core concepts such as topics, partitions, and replicas, common operational commands, and practical performance‑tuning tips for high‑throughput, low‑latency streaming workloads.

KafkaOperationsPerformance Tuning
0 likes · 23 min read
Mastering Kafka: From Basics to Advanced Operations and Performance Tuning
MaGe Linux Operations
MaGe Linux Operations
Sep 14, 2023 · Operations

9 Essential Linux Server Optimization Tips for Faster, Safer Operations

This guide presents nine practical Linux server optimization techniques—including time synchronization, SYN‑cookie protection, Squid and Nginx tuning, file‑descriptor limits, service minimization, IPv6 disabling, NIC activation, and memory‑management insights—to boost precision, stability, performance, and security.

LinuxNetworkPerformance Tuning
0 likes · 8 min read
9 Essential Linux Server Optimization Tips for Faster, Safer Operations
Bilibili Tech
Bilibili Tech
Sep 8, 2023 · Backend Development

Investigation of Goroutine Leak in Go

The article details how a sudden surge in goroutine and heap usage was traced to repeatedly creating gRPC clients instead of reusing a singleton, leading to blocked goroutines and TCP connections, and explains using pprof, stack traces, and tools like goleak to detect and prevent such leaks.

GoGo ProgrammingGoroutine
0 likes · 13 min read
Investigation of Goroutine Leak in Go
Sanyou's Java Diary
Sanyou's Java Diary
Sep 7, 2023 · Operations

How to Keep Kafka Stable: Proven Practices for Prevention, Monitoring, and Recovery

This comprehensive guide explains how to ensure Kafka stability by applying proactive prevention, continuous runtime monitoring, and effective fault‑resolution strategies, covering producer and consumer tuning, cluster configuration, performance optimization, alerting, and idempotent consumption to prevent message loss and service disruption.

KafkaPerformance TuningStability
0 likes · 30 min read
How to Keep Kafka Stable: Proven Practices for Prevention, Monitoring, and Recovery
Java Architect Essentials
Java Architect Essentials
Sep 6, 2023 · Backend Development

Understanding Spring Boot 2.7.10’s Embedded Tomcat: Defaults, Thread Pools, and Connection Limits

This article examines Spring Boot 2.7.10’s embedded Tomcat configuration, detailing default connection queue sizes, thread pool parameters, key Tomcat settings such as AcceptCount and MaxConnections, internal thread components, and practical testing results that reveal how connection limits affect client‑server handshakes.

Backend DevelopmentConnection ManagementEmbedded Server
0 likes · 15 min read
Understanding Spring Boot 2.7.10’s Embedded Tomcat: Defaults, Thread Pools, and Connection Limits
FunTester
FunTester
Aug 25, 2023 · Cloud Native

Introduction to SkyWalking: Architecture, Components, and Performance Tuning for Cloud‑Native Microservices

This article explains the background of cloud‑native microservices, introduces the open‑source SkyWalking observability platform and its core components (Agent, OAP server, storage, UI), and demonstrates how to extend SkyWalking with custom plugins and tune its performance to minimize monitoring overhead.

APMCloud NativeMicroservices
0 likes · 8 min read
Introduction to SkyWalking: Architecture, Components, and Performance Tuning for Cloud‑Native Microservices
vivo Internet Technology
vivo Internet Technology
Aug 23, 2023 · Backend Development

Memory Optimization for Core Services: JVM Tuning and Large Object Management

The article describes how vivo’s core music service reduced frequent garbage collections, long GC pauses, and RPC timeouts by switching to ParNew+CMS collectors, implementing fault‑transfer monitoring, optimizing large response objects, and adding non‑invasive payload checks, resulting in dramatically lower YGC/FGC frequencies and improved memory stability.

Backend DevelopmentGarbage CollectionJVM Optimization
0 likes · 12 min read
Memory Optimization for Core Services: JVM Tuning and Large Object Management
Sanyou's Java Diary
Sanyou's Java Diary
Aug 21, 2023 · Databases

Master MySQL Optimization: Indexing, Locking, Pagination & Profiling Tips

This article presents practical MySQL optimization techniques—including proper index creation, avoiding index invalidation, choosing appropriate lock granularity, efficient pagination strategies, steering clear of SELECT *, and using EXPLAIN and SHOW PROFILE—to help developers write faster, more reliable SQL queries.

Database LocksIndexingMySQL
0 likes · 10 min read
Master MySQL Optimization: Indexing, Locking, Pagination & Profiling Tips