BestHub
Sign in
Tagged articles
982 articles
Page 3 of 10
Code Ape Tech Column
Code Ape Tech Column
May 9, 2025 · Databases

Efficient Strategies for Importing One Billion Records into MySQL

This article explains how to import 1 billion 1 KB log records stored in HDFS or S3 into MySQL by analyzing single‑table limits, using batch inserts, choosing storage engines, sharding, optimizing file‑reading methods, and coordinating distributed tasks with Redis, Redisson, and Zookeeper to ensure ordered, reliable, and high‑throughput data loading.

Batch InsertDistributed SystemsKafka
0 likes · 19 min read
Efficient Strategies for Importing One Billion Records into MySQL
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 1, 2025 · Databases

Common Scenarios Where MySQL Indexes Fail

This article explains various situations that cause MySQL indexes to become ineffective—such as leading wildcard LIKE queries, calculations on indexed columns, use of functions, data type mismatches, improper use of composite indexes, and character set differences—providing example SQL, execution plans, and practical testing steps.

Database OptimizationSQLindex
0 likes · 7 min read
Common Scenarios Where MySQL Indexes Fail
Cognitive Technology Team
Cognitive Technology Team
May 1, 2025 · Databases

MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios

This article systematically examines MySQL optimization techniques for both read‑many/write‑few and write‑many/read‑few business scenarios, covering architecture design, caching, sharding, asynchronous processing, monitoring, and emerging NewSQL/HTAP solutions to achieve high performance, consistency, and scalability.

Database Optimizationcachingmysql
0 likes · 9 min read
MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios
IT Services Circle
IT Services Circle
Apr 29, 2025 · Backend Development

Understanding JVM Garbage Collection Mechanisms for Interviews

This article humorously introduces a common interview scenario and then provides a comprehensive overview of JVM garbage collection, covering memory regions, GC roots, collector types like ParNew, G1, CMS, tuning parameters, code examples, and practical tips for diagnosing and optimizing GC behavior.

Garbage CollectionJVMJava
0 likes · 8 min read
Understanding JVM Garbage Collection Mechanisms for Interviews
ITPUB
ITPUB
Apr 26, 2025 · Databases

SQL Server Admin Essentials: Monitoring, Backup, Performance Tuning & Users

This guide compiles a comprehensive set of SQL Server commands for administrators, covering version checks, server and database properties, connection statistics, backup and restore procedures, user and role management, performance diagnostics, cache cleanup, and various maintenance tasks to streamline daily operations.

BackupDatabase AdministrationRestore
0 likes · 19 min read
SQL Server Admin Essentials: Monitoring, Backup, Performance Tuning & Users
Liangxu Linux
Liangxu Linux
Apr 20, 2025 · Operations

Discover Hidden Memory Consumers on Linux Using hcache – A Practical Guide

Learn how the open‑source hcache tool analyzes Linux page‑cache usage, provides global and per‑process cache rankings, supports multiple output formats, and offers step‑by‑step installation and command examples to pinpoint memory hogs, troubleshoot OOM alerts, and optimize system performance.

Cache MonitoringMemory analysisSystem Administration
0 likes · 8 min read
Discover Hidden Memory Consumers on Linux Using hcache – A Practical Guide
IT Xianyu
IT Xianyu
Apr 18, 2025 · Databases

Comprehensive Guide to SQL Basics, Advanced Queries, and Performance Optimization

This article provides a thorough tutorial on SQL fundamentals, including statement order, core clause rules, templates for SELECT/INSERT/UPDATE/DELETE, practical multi‑table query cases, join and subquery techniques, common pitfalls, index optimization strategies, experimental performance data, and a structured learning path for mastering database development.

JoinsSQLSubqueries
0 likes · 7 min read
Comprehensive Guide to SQL Basics, Advanced Queries, and Performance Optimization
Liangxu Linux
Liangxu Linux
Apr 13, 2025 · Operations

Boost Linux Server Performance: Essential Kernel and Sysctl Tweaks

This guide explains how to permanently disable SELinux, set the system runlevel, enlarge file descriptor limits, fine‑tune kernel networking parameters via /etc/sysctl.conf, configure firewall settings, and troubleshoot common Linux socket errors to significantly improve server performance.

LinuxNetwork SettingsSELinux
0 likes · 7 min read
Boost Linux Server Performance: Essential Kernel and Sysctl Tweaks
Code Ape Tech Column
Code Ape Tech Column
Apr 10, 2025 · Databases

Comprehensive Guide to SQL Optimization Steps and Common Scenarios

This article explains why SQL statements become performance bottlenecks as data grows, outlines a systematic optimization workflow—including slow‑query identification, EXPLAIN analysis, profiling, and tracing—and discusses practical solutions for index usage, query rewriting, pagination, range queries, and large‑scale data handling in MySQL.

Database OptimizationSQLexplain
0 likes · 12 min read
Comprehensive Guide to SQL Optimization Steps and Common Scenarios
Java Tech Enthusiast
Java Tech Enthusiast
Apr 4, 2025 · Databases

MySQL Large Table Index Optimization and Batch Deletion Strategies

By dropping a low‑selectivity composite index, adding targeted indexes on product_id‑sequence‑station_no and receive_time, and using online DDL with pt‑osc, the team reduced row scans and replication lag, then implemented batch deletions by primary‑key ranges, cutting delete time from minutes to seconds on a 100‑million‑row table.

Batch DeletionIndex OptimizationLarge Tables
0 likes · 14 min read
MySQL Large Table Index Optimization and Batch Deletion Strategies
Linux Kernel Journey
Linux Kernel Journey
Mar 23, 2025 · Fundamentals

Efficient Dynamic Memory Reclamation Techniques in Linux

The article provides an in‑depth technical analysis of Linux’s memory reclamation system, covering zones, watermarks, page flags, LRU lists, the shrink_zone workflow, kswapd, direct reclaim, OOM handling, page‑cache structures, and practical tuning tips for optimal performance.

LRULinuxSwap
0 likes · 97 min read
Efficient Dynamic Memory Reclamation Techniques in Linux
macrozheng
macrozheng
Mar 19, 2025 · Backend Development

Unlock Ultra‑Low Latency with Disruptor: Architecture, Features & Tuning Guide

This article introduces the high‑performance in‑memory queue Disruptor, covering its architecture—including ring buffer, sequence, sequencer, and wait strategies—its key features such as multicast events and lock‑free concurrency, and provides practical tuning advice and a complete Java example.

DisruptorIn-Memory QueueLow latency
0 likes · 12 min read
Unlock Ultra‑Low Latency with Disruptor: Architecture, Features & Tuning Guide
Java Architect Essentials
Java Architect Essentials
Mar 18, 2025 · Backend Development

Optimizing Spring Boot Startup Time: Interventions, Configuration Tweaks, and Performance Tips

This article provides a comprehensive guide to speeding up Spring Boot application startup by explaining configuration principles, code‑level interventions, lazy loading, dependency reduction, auto‑configuration exclusion, logging adjustments, compile‑time optimizations, and caching strategies, all illustrated with practical Java examples.

Backend DevelopmentJavaSpring Boot
0 likes · 30 min read
Optimizing Spring Boot Startup Time: Interventions, Configuration Tweaks, and Performance Tips
Top Architecture Tech Stack
Top Architecture Tech Stack
Mar 17, 2025 · Backend Development

JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Service Node

This article explains how to size and configure JVM options—including heap size, young generation, GC algorithm, thread stack, and metaspace—for a backend service that processes one million login requests per day on an 8 GB machine, providing step‑by‑step calculations, practical examples, and optimization tips.

Garbage CollectionJVMJava
0 likes · 24 min read
JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Service Node
Open Source Linux
Open Source Linux
Mar 17, 2025 · Operations

Boost Linux Server Performance: Essential Kernel and Sysctl Tweaks

Learn how to permanently disable SELinux, set runlevel to 3, increase file descriptor limits, fine-tune kernel network parameters via /etc/sysctl.conf, configure firewall settings, and address common Linux performance issues such as too many open files and TIME_WAIT overloads.

Kernel ParametersLinuxperformance tuning
0 likes · 8 min read
Boost Linux Server Performance: Essential Kernel and Sysctl Tweaks
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Mar 12, 2025 · Backend Development

10 Proven Spring Boot 3 Performance Tweaks to Supercharge Your Apps

Discover ten validated Spring Boot 3 performance optimization techniques—including lazy initialization, JVM tuning, connection pooling, caching, async processing, virtual threads, and Actuator monitoring—complete with configuration snippets and code examples, to accelerate startup, reduce memory usage, and improve response times for Java backend services.

ConfigurationJavaSpring Boot
0 likes · 9 min read
10 Proven Spring Boot 3 Performance Tweaks to Supercharge Your Apps
Programmer Xu Shu
Programmer Xu Shu
Feb 24, 2025 · Backend Development

Mastering Thread Pool Tuning: Real‑World Strategies from a Meituan Interview

This article breaks down essential thread‑pool parameters, explains how to set corePoolSize and maximumPoolSize for CPU‑ and IO‑bound tasks, and outlines a practical, dynamic adjustment process—including monitoring, strategy definition, load testing, and automation—to achieve optimal performance in production environments.

Backend DevelopmentDynamic ScalingJava concurrency
0 likes · 8 min read
Mastering Thread Pool Tuning: Real‑World Strategies from a Meituan Interview
Raymond Ops
Raymond Ops
Feb 20, 2025 · Databases

Master MySQL Slow Query Optimization: EXPLAIN Tips & Practical SQL Tuning

This guide walks through identifying slow MySQL queries using EXPLAIN, explains each output field, and presents practical optimization techniques—including proper index usage, pagination tricks, join improvements, and ORDER/GROUP BY tuning—to dramatically boost query performance.

SQL Optimizationexplainindexes
0 likes · 8 min read
Master MySQL Slow Query Optimization: EXPLAIN Tips & Practical SQL Tuning
Cognitive Technology Team
Cognitive Technology Team
Feb 20, 2025 · Backend Development

Understanding the Java Memory Model and Diagnosing OutOfMemoryError

This article explains the Java memory model, outlines common OutOfMemoryError types, and provides a step‑by‑step guide for diagnosing, fixing, and preventing memory‑related issues in large‑scale Java applications, including heap, metaspace, and stack analysis, JVM flag tuning, and best‑practice recommendations for resource handling and monitoring.

Backend DevelopmentJVMJava
0 likes · 8 min read
Understanding the Java Memory Model and Diagnosing OutOfMemoryError
Liangxu Linux
Liangxu Linux
Feb 16, 2025 · Databases

Essential MySQL Tuning Tools: Diagnose and Optimize Your Database

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

Database Toolsmysqlpercona-toolkit
0 likes · 9 min read
Essential MySQL Tuning Tools: Diagnose and Optimize Your Database
dbaplus Community
dbaplus Community
Feb 9, 2025 · Big Data

Mastering ODPS SQL Performance: From Logview to Advanced Optimizations

This guide walks through the end‑to‑end flow of SQL execution on Alibaba MaxCompute (ODPS), explains how to use Logview to pinpoint performance bottlenecks, enumerates common causes of slow queries, and presents concrete optimization techniques such as MapJoin hints, double‑group‑by rewrites, TRANS_COLS, bucket partitioning and UDF tuning, all illustrated with step‑by‑step examples and visual diagrams.

LogviewMaxComputeODPS
0 likes · 16 min read
Mastering ODPS SQL Performance: From Logview to Advanced Optimizations
Linux Kernel Journey
Linux Kernel Journey
Feb 5, 2025 · Fundamentals

Boost Code Performance by Leveraging CPU Cache Principles

This article explains how CPU caches bridge the speed gap between the processor and main memory, describes cache hierarchy, locality principles, write policies, coherence protocols, and provides concrete C code examples and practical tips such as data alignment and loop restructuring to improve cache hit rates and overall program speed.

CPU cacheMESI ProtocolMemory Hierarchy
0 likes · 30 min read
Boost Code Performance by Leveraging CPU Cache Principles
Architect's Guide
Architect's Guide
Jan 30, 2025 · Backend Development

JVM Parameter Tuning for 1 Million Daily Login Requests on an 8 GB Server

This article walks through a systematic, eight‑step approach to sizing and configuring JVM memory parameters—including heap, young generation, stack, object age thresholds, and garbage‑collector selection—so that a service handling one million daily logins on an 8 GB machine can achieve stable performance and predictable GC behavior.

Garbage CollectionJVMJava
0 likes · 24 min read
JVM Parameter Tuning for 1 Million Daily Login Requests on an 8 GB Server
IT Services Circle
IT Services Circle
Jan 29, 2025 · Backend Development

How to Handle Frequent Full GC and High CPU Usage in Java Backend Development

This article explains common interview questions on frequent Full GC and high CPU usage in Java backend development, detailing root causes, JVM parameter adjustments, memory leak prevention, and code optimization techniques, along with practical code examples and tool recommendations for effective performance tuning.

CPU optimizationFull GCJVM
0 likes · 8 min read
How to Handle Frequent Full GC and High CPU Usage in Java Backend Development
Efficient Ops
Efficient Ops
Dec 24, 2024 · Databases

Why Is My Redis Slowing Down? 10 Common Causes and How to Fix Them

Redis can appear slow for many reasons—including baseline latency differences, high‑complexity commands, big keys, concentrated expirations, memory limits, fork overhead, huge pages, CPU binding, swap usage, memory fragmentation, and AOF configuration—so this guide explains each cause, how to diagnose it, and practical optimization steps.

Database OptimizationLatencyMemory Management
0 likes · 34 min read
Why Is My Redis Slowing Down? 10 Common Causes and How to Fix Them
Raymond Ops
Raymond Ops
Dec 24, 2024 · Operations

How to Diagnose and Fix High CPU and Memory Usage in Java Applications

This guide walks through identifying Java processes that cause high CPU load, extracting the hottest threads with top and jstack, analyzing JVM memory regions, interpreting GC logs, and applying practical JVM tuning parameters and tools such as jmap, jstat, and MAT to resolve performance bottlenecks.

CPUJVMJava
0 likes · 18 min read
How to Diagnose and Fix High CPU and Memory Usage in Java Applications
Code Ape Tech Column
Code Ape Tech Column
Dec 24, 2024 · Backend Development

Understanding the Disruptor In-Memory Message Queue: Architecture, Features, and Tuning

This article introduces the Disruptor in‑memory message queue, explains its core components such as Ring Buffer, Sequence, Sequencer and Wait Strategies, describes its distinctive features like multicast events and lock‑free concurrency, and provides tuning guidelines and a complete Java example.

DisruptorIn-Memory QueueJava concurrency
0 likes · 11 min read
Understanding the Disruptor In-Memory Message Queue: Architecture, Features, and Tuning
Top Architecture Tech Stack
Top Architecture Tech Stack
Dec 23, 2024 · Backend Development

JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Node

This article explains how to plan capacity, choose the appropriate garbage collector, allocate heap and non‑heap memory, and configure JVM flags—including Xms, Xmx, Xmn, Xss, and GC‑specific options—to reliably support a service node with 8 GB RAM handling one million login requests per day.

Garbage CollectionJVMJava
0 likes · 25 min read
JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Node
JD Tech Talk
JD Tech Talk
Dec 19, 2024 · Backend Development

Optimizing Log4j2 Asynchronous Logging: Configuration, Diagnosis, and Load‑Testing

This article presents a detailed case study of a severe service outage caused by Log4j2 asynchronous logging bottlenecks, explains step‑by‑step diagnostics of JVM, disk, and RingBuffer metrics, and demonstrates how adjusting log4j2.asyncQueueFullPolicy and log4j2.discardThreshold dramatically improves recovery time during load testing.

ConfigurationJavaRingBuffer
0 likes · 14 min read
Optimizing Log4j2 Asynchronous Logging: Configuration, Diagnosis, and Load‑Testing
MaGe Linux Operations
MaGe Linux Operations
Dec 14, 2024 · Operations

Mastering iostat: How to Diagnose Linux I/O Bottlenecks

This guide explains how to use iostat and related Linux commands to monitor I/O performance, interpret key metrics such as %util, await, and svctm, and apply practical analysis and optimization techniques for diagnosing and resolving storage bottlenecks.

I/O MonitoringLinuxiostat
0 likes · 15 min read
Mastering iostat: How to Diagnose Linux I/O Bottlenecks
JD Tech
JD Tech
Dec 13, 2024 · Databases

MySQL Join Algorithms and Optimization Techniques

This article explains how multi‑table joins in MySQL can become performance bottlenecks and walks through the four join algorithms—Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop—showing their execution plans, code examples, and step‑by‑step optimizations using indexes and join buffers to dramatically improve query speed.

Join AlgorithmsSQL Optimizationdatabase
0 likes · 19 min read
MySQL Join Algorithms and Optimization Techniques
DataFunSummit
DataFunSummit
Dec 9, 2024 · Big Data

Spark SQL Expression Optimizations: LIKE ALL/ANY, TRIM Function Improvements, and Constant Folding

This article examines Spark SQL expression-level optimizations, focusing on redesigning LIKE ALL and LIKE ANY to reduce memory and stack usage, refactoring the TRIM function for better code reuse and performance, and implementing constant folding to cache computed constant expressions, thereby enhancing query efficiency in big-data workloads.

Big DataExpression OptimizationSpark SQL
0 likes · 16 min read
Spark SQL Expression Optimizations: LIKE ALL/ANY, TRIM Function Improvements, and Constant Folding
Java Tech Enthusiast
Java Tech Enthusiast
Dec 9, 2024 · Operations

Nginx Performance Optimization Techniques

To keep Nginx fast under heavy load, adjust worker processes and connections to match CPU cores, enable gzip compression, set browser and proxy caching headers, turn on sendfile with optimal chunk and TCP settings, tune log levels, and optionally use a CDN and HTTP/2.

ConfigurationNGINXWeb server
0 likes · 7 min read
Nginx Performance Optimization Techniques
Full-Stack DevOps & Kubernetes
Full-Stack DevOps & Kubernetes
Dec 6, 2024 · Operations

Boost Kubernetes API Server Performance: Tuning max-mutating-requests-inflight & watch-cache-size

This guide explains how to optimize Kubernetes API Server performance by configuring the max-mutating-requests-inflight limit and watch-cache-size, offering recommended values for different cluster sizes, monitoring metrics, and step‑by‑step adjustment strategies for stable, high‑throughput clusters.

API ServerKubernetescluster operations
0 likes · 7 min read
Boost Kubernetes API Server Performance: Tuning max-mutating-requests-inflight & watch-cache-size
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Nov 25, 2024 · Backend Development

What Elasticsearch Query Limits Should You Know?

This article explains the five major Elasticsearch query limits—including result size, max clause count, field data, join operations, and query throughput—detailing their default values, why they exist, and practical solutions such as using search_after, scroll API, and resource monitoring to keep clusters stable and performant.

Elasticsearchfielddatamax clause count
0 likes · 11 min read
What Elasticsearch Query Limits Should You Know?
dbaplus Community
dbaplus Community
Nov 24, 2024 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

This article walks through practical MySQL performance tuning methods—including pagination, join, subquery, ORDER BY, GROUP BY, and COUNT optimizations—illustrated with real‑world data volumes, step‑by‑step SQL examples, EXPLAIN analyses, index creation, and measurable query‑time improvements.

JOINOrder BySQL Optimization
0 likes · 14 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 23, 2024 · Big Data

Implementing a Basic Hadoop MapReduce Word Count with Extensible Design and Performance Tuning

This article explains Hadoop’s core concepts using a library analogy, details HDFS storage and MapReduce processing, provides complete Java implementations for a word‑count job with support for text, CSV, and JSON inputs, and discusses extensibility and performance optimizations such as combiners and custom partitioners.

Big DataHadoopJava
0 likes · 20 min read
Implementing a Basic Hadoop MapReduce Word Count with Extensible Design and Performance Tuning
Top Architect
Top Architect
Nov 22, 2024 · Backend Development

JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Node

This article walks through a systematic approach to sizing and configuring JVM parameters—including heap size, young generation, GC algorithm selection, and advanced options—for a high‑traffic login service that processes one million requests per day on a server with 8 GB of memory, while explaining the underlying performance‑analysis methodology.

Garbage CollectionJVMJava
0 likes · 27 min read
JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Node
Baidu Tech Salon
Baidu Tech Salon
Nov 20, 2024 · Big Data

Optimizing Multi‑Dimensional User Count Computation in Feed Using Data Tagging

By deduplicating logs and assigning compact numeric tags to each user‑dimension combination, the data‑tagging method replaces costly lateral‑view expansions with a user‑level aggregation, cutting shuffle volume from terabytes to gigabytes and reducing runtime from 49 minutes to 14 minutes, enabling scalable multi‑dimensional user‑count analysis for Baidu Feed.

HiveSQL Optimizationdata tagging
0 likes · 14 min read
Optimizing Multi‑Dimensional User Count Computation in Feed Using Data Tagging
ITPUB
ITPUB
Nov 15, 2024 · Databases

Why Vector Databases Matter: Deploying PgVector on PostgreSQL for Scalable AI Retrieval

This article explains the need for vector databases in the AI era, reviews PostgreSQL's extensible ecosystem, compares vector‑database options, provides step‑by‑step PgVector installation and usage, shares operational best practices, performance tuning tips, and real‑world Qunar & Tujia case studies.

AIPostgreSQLRAG
0 likes · 27 min read
Why Vector Databases Matter: Deploying PgVector on PostgreSQL for Scalable AI Retrieval
Architect
Architect
Nov 14, 2024 · Backend Development

How to Set JVM Parameters for a Platform Handling 1 Million Daily Login Requests on an 8 GB Server

This article explains, step by step, how to estimate capacity, choose the appropriate garbage collector, size the young and old generations, configure stack memory, adjust object aging thresholds, and fine‑tune CMS or G1 settings so that a Java service handling one million daily logins can run reliably on an 8 GB node.

BackendGarbage CollectionJVM
0 likes · 24 min read
How to Set JVM Parameters for a Platform Handling 1 Million Daily Login Requests on an 8 GB Server
Java Architecture Stack
Java Architecture Stack
Oct 30, 2024 · Operations

Why ZGC Is Revolutionizing Java Memory Management for Low‑Latency Apps

This article explains ZGC’s ultra‑low pause times, massive heap support, colored pointers, concurrent compaction, and generational optimizations, then shows how these features benefit real‑time analytics, high‑performance servers, and online transaction systems, and provides step‑by‑step instructions for enabling and tuning ZGC in Java.

Garbage CollectorJavaLow latency
0 likes · 9 min read
Why ZGC Is Revolutionizing Java Memory Management for Low‑Latency Apps
Su San Talks Tech
Su San Talks Tech
Oct 21, 2024 · Databases

How to Diagnose and Fix MySQL Master‑Slave Replication Lag

This article explains why MySQL master‑slave replication can become delayed in high‑traffic order systems, describes the underlying binlog synchronization mechanism, and provides practical steps—including network upgrades, server tuning, transaction reduction, version updates, and slave count limits—to eliminate the lag.

LatencyMaster‑SlaveReplication
0 likes · 7 min read
How to Diagnose and Fix MySQL Master‑Slave Replication Lag
Alibaba Cloud Native
Alibaba Cloud Native
Oct 20, 2024 · Backend Development

How Adaptive K‑Value Backoff Locks Boost RocketMQ Performance by Up to 38%

A recent CCF‑A conference paper reveals that an adaptive K‑value backoff lock, derived from queueing theory and implemented in Apache RocketMQ, can replace both spin and mutex locks, achieving up to 37.58% performance gains on x86 CPUs and 32.82% on ARM while reducing CPU usage and resource consumption.

RocketMQbackend systemshigh concurrency
0 likes · 7 min read
How Adaptive K‑Value Backoff Locks Boost RocketMQ Performance by Up to 38%
Sohu Tech Products
Sohu Tech Products
Oct 18, 2024 · Artificial Intelligence

Optimizing AI Inference with TorchServe: Tackling GPU Bottlenecks & Kubernetes

This article details a comprehensive engineering practice for optimizing AI inference services at ZhiZhuan, covering background analysis, selection of TorchServe over alternatives, GPU/CPU performance tuning, custom handlers, Torch‑TRT integration, and deployment on Kubernetes, with measured improvements in throughput and resource utilization.

AI inferenceGPU OptimizationKubernetes
0 likes · 16 min read
Optimizing AI Inference with TorchServe: Tackling GPU Bottlenecks & Kubernetes
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Oct 18, 2024 · Databases

Master MySQL Performance: 20 Essential SQL Optimization Techniques

This article presents a comprehensive guide for Java engineers on MySQL query optimization, covering index usage, avoiding SELECT *, proper JOINs, efficient WHERE clauses, LIMIT, EXISTS vs IN, function indexes, connection pooling, batch processing, data types, execution plan analysis, materialized views, and regular performance monitoring, all illustrated with practical code examples.

SQL Optimizationdatabaseindexes
0 likes · 19 min read
Master MySQL Performance: 20 Essential SQL Optimization Techniques
Java Architecture Stack
Java Architecture Stack
Oct 11, 2024 · Operations

25 Proven Linux Performance Tuning Tricks to Boost System Speed

Learn 25 practical Linux performance tuning techniques—from adjusting kernel parameters like swappiness and ulimit to optimizing I/O schedulers, network buffers, and enabling HugePages—each with clear commands and step‑by‑step instructions to help you maximize system responsiveness and throughput.

I/O schedulerKernel ParametersLinux
0 likes · 10 min read
25 Proven Linux Performance Tuning Tricks to Boost System Speed
Java Tech Enthusiast
Java Tech Enthusiast
Oct 3, 2024 · Databases

MySQL Large Table Data Deletion Optimization Strategy

To efficiently purge old user‑operation logs while retaining the most recent three months and preserving type‑c entries, the article recommends abandoning offset pagination and MyBatis PageHelper, using primary‑key‑based pagination with a tracked startId, in‑memory filtering, intelligent startId recalculation, and optional sleep intervals to avoid database overload.

Database Optimizationdata cleanuplarge table deletion
0 likes · 6 min read
MySQL Large Table Data Deletion Optimization Strategy
Top Architect
Top Architect
Sep 30, 2024 · Backend Development

Optimizing a High‑Concurrency Java Backend Interface: Reducing Response Time from 30 s to 0.8 s

This article details a real-world performance optimization of a high‑concurrency Java backend interface, reducing response time from 30 seconds to under 0.8 seconds through SQL analysis, array aggregation, moving logic to PostgreSQL, and introducing Caffeine caching, with code examples and lessons learned.

Backend DevelopmentJavaSQL Optimization
0 likes · 13 min read
Optimizing a High‑Concurrency Java Backend Interface: Reducing Response Time from 30 s to 0.8 s
Open Source Linux
Open Source Linux
Sep 24, 2024 · Backend Development

How to Tame 900% CPU Spikes in MySQL and Java Processes

This guide explains why MySQL and Java processes can exceed 900% CPU usage in production, and provides step‑by‑step methods—using top, show processlist, jstack, index tuning, caching, and code adjustments—to diagnose, mitigate, and prevent such spikes.

CPU optimizationJavaLinux
0 likes · 10 min read
How to Tame 900% CPU Spikes in MySQL and Java Processes
DevOps Operations Practice
DevOps Operations Practice
Sep 23, 2024 · Operations

Root Cause Analysis and Optimization of High Load on Alibaba Cloud RocketMQ Consumer Service

The article investigates why a RocketMQ consumer service running on a 4‑core ECS experiences sustained high load despite low CPU, I/O and memory usage, identifies excessive thread creation and frequent trace‑module context switches as the main causes, and proposes configuration and SDK upgrades to resolve the issue.

JavaRocketMQThread Management
0 likes · 9 min read
Root Cause Analysis and Optimization of High Load on Alibaba Cloud RocketMQ Consumer Service
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.

ConfigurationNGINXWeb server
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.

OceanBasePlan CacheSQL Optimization
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 computingCluster ManagementOperations
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 ToolsShell Scriptsmysql
0 likes · 8 min read
Boost MySQL Performance: Essential Tools, Installation & Report Analysis
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.

Distributed TrainingGPU OptimizationPPO 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 AdministrationInnoDBUndo Tablespace
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 ConfigurationSQL Optimizationindexing
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.

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

LinuxNGINXSecurity
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 DevelopmentCaffeineMyBatis
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 MigrationQPS Reductionperformance 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.

Database OptimizationSQLbest practices
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.

Cost OptimizationDatabase ManagementInfrastructure
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.

CPUHardware OptimizationKunpeng
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.

Implicit ConversionIndex OptimizationPostgreSQL
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 NativeDevOpsMicroservices
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.

Data ManagementSQLStarRocks
0 likes · 21 min read
How StarRocks Compaction Boosts Query Performance: Mechanics, Tuning, and Best Practices