BestHub
Sign in
Tagged articles
982 articles
Page 4 of 10
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.

Database OptimizationQueriesSQL
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.

Time Series Databasedata ingestionopenGemini
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.

BackendGarbage CollectionJVM
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.

SQL Optimizationdatabase indexingperformance tuning
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 AdministrationOceanBaseSQL
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 ToolsSQLmysql
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 performanceMulti-Architecture
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.

Query RewriteSQL Optimizationindexes
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.

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

SQL Optimizationdatabasemysql
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 kernelTomcat
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
Su San Talks Tech
Su San Talks Tech
Mar 16, 2024 · Databases

Master MySQL Performance: Deep Dive into Indexes and Explain Plans

This comprehensive guide explains MySQL's architecture, the importance of SQL optimization, detailed index types and creation methods, how to interpret EXPLAIN output, and practical techniques to improve query performance while avoiding common pitfalls.

Explain PlanSQL Optimizationindexes
0 likes · 35 min read
Master MySQL Performance: Deep Dive into Indexes and Explain Plans
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.

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

JVMJavadiagnostics
0 likes · 18 min read
Master JVM Tuning: When, How, and Which Tools to Optimize Java Performance
dbaplus Community
dbaplus Community
Feb 20, 2024 · Databases

How to Migrate to AntDB with a Six‑Step Progressive Strategy and Optimize Key Parameters

This article outlines a six‑stage, progressive migration plan for replacing legacy databases with AntDB, covering deployment, extensive testing, SQL refactoring, data migration, go‑live procedures, and monitoring, while providing detailed tuning recommendations for dozens of critical database parameters.

AntDBData MigrationPostgreSQL Parameters
0 likes · 21 min read
How to Migrate to AntDB with a Six‑Step Progressive Strategy and Optimize Key Parameters
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.

BackendGzipNginx
0 likes · 8 min read
How We Boosted Nginx Performance 50× by Tuning Gzip Settings
Architecture Digest
Architecture Digest
Jan 11, 2024 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, and Percona Toolkit

This article introduces several MySQL performance‑tuning utilities—including mysqltuner.pl, tuning-primer.sh, and Percona Toolkit’s pt-variable-advisor and pt-query-digest—explaining how to download, run, and interpret their reports to optimize database configuration, memory usage, and query efficiency.

Database ToolsSQL OptimizationServer Administration
0 likes · 7 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, and Percona Toolkit
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.

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

JDKJVMJava
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 DataDatabase OptimizationHBase
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 EngineeringCQRSDatabase Optimization
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 BYJOINOrder By
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.

Database IndexOceanBasePlan 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.

AOFBigKeyLatency
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 LearningPyTorch
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.

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

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

Garbage CollectionJVMJava
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.

ApolloConfiguration ManagementSystem Design
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 ConfigurationSharding-JDBC
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 ConfigurationSQLmy.cnf
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.

BuffersKernel Parametersnetwork optimization
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 DevelopmentKafkaReactor Pattern
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.

Distributed SystemsKafkaOperations
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.

Kernel ParametersLinuxSysadmin
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.

DebuggingGoGo Programming
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.

Kafkafault-recoveryperformance tuning
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 ManagementSpring Boot
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 LocksSQL Optimizationindexing
0 likes · 10 min read
Master MySQL Optimization: Indexing, Locking, Pagination & Profiling Tips
Java Captain
Java Captain
Aug 18, 2023 · Backend Development

JVM GC Optimization: Reducing FullGC Frequency and Resolving Memory Leaks

This article documents a month‑long JVM garbage‑collection tuning effort that lowered FullGC from around 40 daily occurrences to one every ten days, halved YoungGC time, identified and fixed a memory‑leak caused by anonymous inner‑class listeners, and refined heap and metaspace settings to improve overall server throughput.

BackendGarbage CollectionJVM
0 likes · 10 min read
JVM GC Optimization: Reducing FullGC Frequency and Resolving Memory Leaks
Open Source Linux
Open Source Linux
Aug 17, 2023 · Fundamentals

Why CPU Cache Matters: Unlock Faster Code Execution

This article explains the purpose of CPU caches, their hierarchical structure and internal designs—including direct‑mapped, set‑associative, and fully‑associative caches—and demonstrates how understanding cache behavior can dramatically improve program performance, illustrated with C++ traversal benchmarks.

CPU cachecache hierarchycache optimization
0 likes · 12 min read
Why CPU Cache Matters: Unlock Faster Code Execution
Sohu Tech Products
Sohu Tech Products
Aug 16, 2023 · Big Data

Understanding HBase Compaction: Principles, Process, Throttling Strategies and Real‑World Optimizations

This article explains HBase’s LSM‑Tree compaction fundamentals—including minor and major compaction triggers, file‑selection policies, dynamic throughput throttling, and practical tuning examples that show how adjusting size limits, thread pools, and off‑peak settings can dramatically improve read latency and cluster stability.

Big DataHBaseJava
0 likes · 35 min read
Understanding HBase Compaction: Principles, Process, Throttling Strategies and Real‑World Optimizations
Senior Tony
Senior Tony
Aug 12, 2023 · Databases

Mastering SQL Optimization: 15 Practical Tips to Supercharge Your Queries

This article presents a comprehensive guide to SQL performance tuning, covering real‑world interview scenarios, deep‑pagination pitfalls, and fifteen concrete optimization techniques—including index usage, limit tricks, proper joins, batch operations, and data‑type choices—to help developers write faster, more efficient MySQL queries.

Database OptimizationSQLindexing
0 likes · 12 min read
Mastering SQL Optimization: 15 Practical Tips to Supercharge Your Queries
Senior Tony
Senior Tony
Jul 23, 2023 · Backend Development

Master JVM Tuning: Balancing Pause Time, Throughput, and Memory Usage

This article explains the core trade‑offs of JVM tuning—short pause times versus high throughput—provides quantitative goals, outlines when tuning is needed, details step‑by‑step optimization procedures, and lists common GC strategies and command‑line parameters for effective Java performance tuning.

Garbage CollectionJVMJava
0 likes · 12 min read
Master JVM Tuning: Balancing Pause Time, Throughput, and Memory Usage
Architect
Architect
Jul 21, 2023 · Fundamentals

JVM Basics, Class Loading, Runtime Data Areas, Garbage Collection and Tuning Guide

This article provides a concise yet comprehensive overview of the Java Virtual Machine, covering its core components, how Java source files are compiled and executed, class‑loader mechanisms, runtime memory areas, garbage‑collection algorithms, and practical JVM tuning parameters for optimal performance.

Garbage CollectionJVMJava
0 likes · 31 min read
JVM Basics, Class Loading, Runtime Data Areas, Garbage Collection and Tuning Guide
AI Cyberspace
AI Cyberspace
Jul 19, 2023 · Operations

Master HAProxy: Core Features, High Performance, and High Availability

HAProxy is an open‑source L4/L7 load balancer offering reverse‑proxy, session persistence, diverse balancing algorithms, ACL‑based routing, health checks, and a web UI; the guide details its high‑performance architecture, high‑availability deployment with Keepalived, configuration examples, and extensive kernel and system tuning for massive traffic.

HAProxykeepalivedload balancing
0 likes · 23 min read
Master HAProxy: Core Features, High Performance, and High Availability
Top Architect
Top Architect
Jul 18, 2023 · Fundamentals

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

This article provides a detailed overview of Elasticsearch, covering its underlying Lucene technology, data types, indexing mechanisms, cluster architecture, shard and replica management, mapping definitions, installation steps, health monitoring, write and storage processes, and performance optimization techniques for production deployments.

ElasticsearchReplicationindexing
0 likes · 36 min read
Comprehensive Introduction to Elasticsearch: Core Concepts, Architecture, and Practical Usage
Sanyou's Java Diary
Sanyou's Java Diary
Jul 17, 2023 · Backend Development

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

This article deeply analyzes Kafka broker’s network architecture and request‑handling pipeline, walking through simple sequential models, multithreaded async designs, the Reactor pattern with Java NIO, key thread roles, core processing flow, and practical tuning parameters for high‑throughput, low‑latency deployments.

Backend DevelopmentJava NIOKafka
0 likes · 21 min read
How Kafka’s Broker Handles Millions of Requests: Inside Its Network Architecture
Liangxu Linux
Liangxu Linux
Jul 16, 2023 · Operations

Essential Ops Checklist: Prevent Data Loss, Secure Servers, and Optimize Performance

This article compiles practical operations guidelines covering safe testing, rigorous confirmation before commands, limiting multi‑person access, mandatory backups, careful use of destructive commands, SSH hardening, firewall rules, fine‑grained permissions, continuous monitoring, performance tuning steps, and a disciplined mindset to avoid costly incidents.

BackupSecuritymonitoring
0 likes · 10 min read
Essential Ops Checklist: Prevent Data Loss, Secure Servers, and Optimize Performance
iQIYI Technical Product Team
iQIYI Technical Product Team
Jul 14, 2023 · Backend Development

Investigation and Optimization of Long GC Pauses Caused by Excessive FinalReference in Spring Cloud Gateway

The team discovered that frequent Logback file rotations created thousands of FileOutputStream objects whose finalize‑based FinalReference instances flooded the G1GC reference‑processing phase, causing 13‑second pauses, and resolved the issue by enabling parallel reference processing, enlarging log rotation size, and adjusting GC initiation thresholds.

FinalReferenceGC pauseJVM
0 likes · 13 min read
Investigation and Optimization of Long GC Pauses Caused by Excessive FinalReference in Spring Cloud Gateway
ITPUB
ITPUB
Jul 12, 2023 · Databases

How We Migrated a Multi‑Petabyte Elasticsearch Cluster Across Data Centers Without Downtime

This article details the end‑to‑end process of moving Qunar's massive Elasticsearch logging cluster from a saturated data‑center to a new facility, covering background constraints, migration planning, manual and automated steps, performance‑tuning parameters, shard‑balancing techniques, and the final outcomes achieved.

Cluster MigrationData centerElasticsearch
0 likes · 21 min read
How We Migrated a Multi‑Petabyte Elasticsearch Cluster Across Data Centers Without Downtime
DeWu Technology
DeWu Technology
Jun 30, 2023 · Mobile Development

Optimizing Android CPU Frequency, Core Affinity, and Thread Priority

The article explains how to boost Android app performance by programmatically raising CPU frequency using Qualcomm’s BoostFramework, setting thread‑core affinity with native sched_setaffinity calls, and increasing execution priority via Process.setThreadPriority, providing Kotlin and C examples that demonstrate measurable speed gains.

AndroidCPU optimizationKotlin
0 likes · 20 min read
Optimizing Android CPU Frequency, Core Affinity, and Thread Priority
Architects' Tech Alliance
Architects' Tech Alliance
Jun 28, 2023 · Operations

Master Linux Performance: 8 Essential Tuning Techniques & Tools

This guide outlines eight practical Linux performance‑tuning methods—including kernel parameter tweaks, filesystem and network optimizations, process priority adjustments, memory management, scheduler configuration, software bloat removal, and log cleanup—while showcasing key tools and visual diagrams for effective system optimization.

FilesystemKernel ParametersLinux
0 likes · 5 min read
Master Linux Performance: 8 Essential Tuning Techniques & Tools
MaGe Linux Operations
MaGe Linux Operations
Jun 26, 2023 · Operations

Master Linux Performance: Essential Tools & Commands for System Monitoring

This article compiles a comprehensive guide to Linux performance analysis, covering essential tools such as vmstat, iostat, dstat, top, htop, pidstat, strace, netstat, lsof, perf and sar, explaining their usage, output interpretation, and how they fit into a systematic performance tuning workflow.

LinuxSystem Toolsperformance tuning
0 likes · 16 min read
Master Linux Performance: Essential Tools & Commands for System Monitoring
Programmer DD
Programmer DD
Jun 26, 2023 · Databases

Unlock Lightning-Fast Search: Proven Elasticsearch Performance Tuning Tips

This article presents comprehensive best‑practice recommendations for optimizing Elasticsearch deployments, covering hardware selection, RAID choices, index and shard planning, query and caching strategies, bulk indexing, refresh intervals, monitoring tools, version upgrades, and lifecycle management to achieve high performance, reliability, and scalability.

Elasticsearchindexingperformance tuning
0 likes · 18 min read
Unlock Lightning-Fast Search: Proven Elasticsearch Performance Tuning Tips
Java Architect Essentials
Java Architect Essentials
Jun 21, 2023 · Fundamentals

How to Increase IntelliJ IDEA Memory Allocation to Eliminate Lag

This guide explains why IntelliJ IDEA often feels sluggish due to low default memory limits, shows how to view current memory usage, and provides step‑by‑step instructions—including editing VM options, adjusting -Xmx and -Xms values, and clearing caches—to boost performance for Java developers.

IDE optimizationIntelliJ IDEAJava development
0 likes · 5 min read
How to Increase IntelliJ IDEA Memory Allocation to Eliminate Lag
Su San Talks Tech
Su San Talks Tech
Jun 19, 2023 · Backend Development

Master JVM Performance: Memory Model, OOM Cases, and Tuning Tools

This article reviews the Java HotSpot memory model, explains when JVM tuning is needed, details common OutOfMemoryError scenarios with reproducible code, introduces built‑in monitoring utilities and third‑party tools, and provides practical tuning parameters and case studies for optimizing Java applications.

Garbage CollectionJVMJava
0 likes · 24 min read
Master JVM Performance: Memory Model, OOM Cases, and Tuning Tools
WeiLi Technology Team
WeiLi Technology Team
Jun 2, 2023 · Big Data

Flink RocksDB State Backend: Practical Tuning Guide for Large Jobs

This article explains how to optimize Flink’s RocksDB state backend for large‑scale streaming jobs, covering state types, enabling latency tracking, incremental checkpoints, predefined options, and advanced memory and thread settings, with practical configuration examples and performance comparisons.

Big DataFlinkRocksDB
0 likes · 16 min read
Flink RocksDB State Backend: Practical Tuning Guide for Large Jobs
Code Ape Tech Column
Code Ape Tech Column
May 31, 2023 · Backend Development

Tomcat Performance Tuning Guide: Core Components and Key Parameters

This article explains Tomcat's component architecture, describes the three critical parameters (maxThreads, maxConnections, acceptCount) that affect request handling, and provides practical tuning recommendations to improve backend performance without additional hardware costs.

BackendConnectorJava
0 likes · 11 min read
Tomcat Performance Tuning Guide: Core Components and Key Parameters
Top Architect
Top Architect
May 15, 2023 · Backend Development

Comprehensive Guide to Kafka: Architecture, Performance Tuning, and Operational Practices

This article provides an in-depth overview of Kafka, covering its core value as a message queue, fundamental concepts, cluster architecture, producer and consumer configurations, scaling strategies, monitoring tools, and practical operational commands for building and maintaining high‑throughput, highly available streaming systems.

BackendKafkaMessage Queue
0 likes · 31 min read
Comprehensive Guide to Kafka: Architecture, Performance Tuning, and Operational Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
May 15, 2023 · Databases

Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques

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

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

Boost Your NGINX Performance: 8 Proven Tuning Tips

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

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

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

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

Group CommitReplicationWriteSet
0 likes · 17 min read
How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained