Tagged articles

performance tuning

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

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

QPS Reductiondata migrationperformance tuning
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.

SQLbest practicesdatabase optimization
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 ManagementInfrastructureRedis
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.

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

CPUKunpengServer
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 OptimizationPostgreSQLSQL
0 likes · 13 min read
How Implicit Type Conversion Can Kill PostgreSQL Query Performance by 10,000×
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 NativeDevOpsMicroservices
0 likes · 7 min read
Comprehensive Backend Development and Cloud Native Training Curriculum
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.

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

Data IngestionQuery OptimizationTime Series Database
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 DevelopmentJavaZGC
0 likes · 8 min read
Why Upgrading to JDK 17 with ZGC Can Slash GC Pauses to Sub‑millisecond
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.

Database IndexingSQL optimizationperformance 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.

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

BtuneCPUOptimization
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 ToolsMySQLSQL
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.

MySQLQuery RewriteSQL optimization
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.

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

JVMgarbage collectionmemory 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 PlanMySQLSQL optimization
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.

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.

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.

AntDBPostgreSQL ParametersSQL Refactoring
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.

JVMJavaMemory Leak
0 likes · 12 min read
JVM Garbage Collection Tuning Experience: Reducing FullGC Frequency and Solving Memory Leaks
Pupu Technology
Pupu Technology
Feb 7, 2024 · Databases

How Pupu APM Boosted Write Speed and Cut Storage Costs with ClickHouse

Facing soaring data volumes and rising Elasticsearch costs, Pupu's platform team migrated its APM storage to ClickHouse, achieving up to three million spans per second writes, 38% storage savings, and faster query performance through materialized views and careful deployment tuning.

APMClickHouseCloud Native
0 likes · 11 min read
How Pupu APM Boosted Write Speed and Cut Storage Costs with ClickHouse
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
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.

MySQLQuery OptimizationSQL
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.

HBaseLSM Treebig data
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 BYJOINMySQL
0 likes · 13 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
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.

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

AIPyTorchdeep learning
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.

MySQLQuery OptimizationSQL
0 likes · 10 min read
MySQL Query Optimization and Index Tuning: From Subqueries to Joins
dbaplus Community
dbaplus Community
Dec 5, 2023 · Databases

How I Cut an 8‑Second Slow Query to 0.7 Seconds with Two Optimizations

The article walks through a real‑world case of a slow MySQL query that took 8 seconds, explains why simple indexing wasn't enough, and demonstrates two successive rewrites using JOIN‑GROUP BY and NOT IN that reduced execution time to 0.7 seconds while detailing the EXPLAIN analysis.

EXPLAINMySQLQuery Optimization
0 likes · 6 min read
How I Cut an 8‑Second Slow Query to 0.7 Seconds with Two Optimizations
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
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.

Cloud ComputingSystem DesignTechnical Analysis
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.

Database ConfigurationSharding-JDBCconnection pool
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 ConfigurationMySQLSQL
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.

JedisPoolRedisconnection pool
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 DevelopmentKafkaNetwork Architecture
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.

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

KafkaOperationsdistributed systems
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.

Linuxkernel parametersnetwork
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 ProgrammingMemory Leak
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 DevelopmentEmbedded ServerSpring 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 DevelopmentJVM Optimizationfault transfer
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 LocksMySQLSQL optimization
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.

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

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

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

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

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

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

backupmonitoringperformance tuning
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