BestHub
Sign in
Tagged articles

Performance Tuning

1057 articles · Page 3 of 11
MaGe Linux Operations
MaGe Linux Operations
Sep 8, 2025 · Cloud Computing

Master KVM Virtualization: From Beginner Setup to Production Performance Tuning

This comprehensive guide walks you through KVM virtualization architecture, host preparation, installation, network design, storage management, performance tuning, high availability, security hardening, monitoring, and automation, providing practical scripts and real‑world examples to build a robust, production‑grade virtual environment.

Cloud ComputingKVMPerformance Tuning
0 likes · 26 min read
Master KVM Virtualization: From Beginner Setup to Production Performance Tuning
Architect
Architect
Sep 6, 2025 · Operations

Master High-Concurrency Nginx: Core Configs, Advanced Tuning, and Real-World Checklist

This guide walks you through the common high‑traffic pain points of Nginx, explains why configuration and tuning matter more than hardware, and provides step‑by‑step core, advanced, OS‑level, monitoring, and troubleshooting configurations to reliably handle tens of thousands of concurrent connections.

LinuxMonitoringPerformance Tuning
0 likes · 11 min read
Master High-Concurrency Nginx: Core Configs, Advanced Tuning, and Real-World Checklist
MaGe Linux Operations
MaGe Linux Operations
Sep 6, 2025 · Databases

How to Build a High‑Availability MySQL Master‑Slave Cluster and Automate Failover

This guide walks through the reasons for MySQL master‑slave replication, explains its core mechanisms, details step‑by‑step environment planning, configuration, data initialization, replication setup, monitoring, failover with MHA, read‑write splitting using ProxySQL, performance tuning, troubleshooting, and best‑practice recommendations for enterprise‑grade high availability.

FailoverMySQLPerformance Tuning
0 likes · 27 min read
How to Build a High‑Availability MySQL Master‑Slave Cluster and Automate Failover
MaGe Linux Operations
MaGe Linux Operations
Sep 5, 2025 · Cloud Native

How to Triple Your K8s Cluster Performance with Full‑Stack Node‑to‑Pod Optimization

This article details a systematic, end‑to‑end Kubernetes performance tuning plan—from kernel and container‑runtime tweaks on the node level to resource limits, scheduler policies, and pod‑level configurations—that can triple cluster throughput, cut latency by up to 80%, and dramatically improve stability.

Cluster OptimizationKubernetesNode Configuration
0 likes · 13 min read
How to Triple Your K8s Cluster Performance with Full‑Stack Node‑to‑Pod Optimization
Tech Freedom Circle
Tech Freedom Circle
Sep 5, 2025 · Interview Experience

How to Diagnose Frequent Full GC in Java Interviews

This article explains the root‑cause analysis and step‑by‑step troubleshooting process for frequent Full GC events in Java applications, covering trigger mechanisms, impact assessment, common causes, monitoring tools, heap‑dump analysis, and both short‑term fixes and long‑term architectural improvements.

Full GCJVMJava
0 likes · 47 min read
How to Diagnose Frequent Full GC in Java Interviews
Raymond Ops
Raymond Ops
Sep 3, 2025 · Operations

Boost Linux Server Performance: Essential Kernel and Sysctl Tweaks

Learn how to optimize Linux server performance by permanently disabling SELinux, setting runlevel 3, increasing file descriptor limits, fine-tuning kernel network parameters via /etc/sysctl.conf, configuring firewall settings, and handling common issues such as too many open files and connection timeouts.

LinuxPerformance Tuningkernel parameters
0 likes · 7 min read
Boost Linux Server Performance: Essential Kernel and Sysctl Tweaks
DataFunSummit
DataFunSummit
Sep 1, 2025 · Artificial Intelligence

How We Cut ERNIE Model Resource Use by 75% with Pruning, Structured Slimming, and ONNX Runtime

In this detailed engineering guide we diagnose a heavyweight ERNIE‑Base text‑classification service consuming 128 CPU cores and 96 GB RAM, then apply a three‑step optimization—model selection, structured pruning with PaddleSlim, and engine migration to ONNX Runtime—achieving a 75% reduction in resource usage while keeping recall above 99.5% and boosting inference speed by over 20%.

AI Model OptimizationModel PruningONNX Runtime
0 likes · 11 min read
How We Cut ERNIE Model Resource Use by 75% with Pruning, Structured Slimming, and ONNX Runtime
IT Services Circle
IT Services Circle
Aug 26, 2025 · Databases

Mastering Database Indexes: 10 Essential Questions Every Developer Should Know

This article demystifies database indexes by explaining their purpose, inner workings, and best‑practice design, covering common pitfalls such as slow queries, over‑indexing, NULL handling, composite index ordering, covering indexes, sorting, grouping, and maintenance across different database systems.

Composite IndexCovering IndexPerformance Tuning
0 likes · 11 min read
Mastering Database Indexes: 10 Essential Questions Every Developer Should Know
Architect
Architect
Aug 24, 2025 · Backend Development

Avoid Hidden SpringBoot Pitfalls: Optimize Default Settings for Production

This article examines common default configuration issues in SpringBoot—such as Tomcat connection limits, HikariCP pool size, JPA lazy loading, Jackson timezone handling, logging, caching, file upload limits, async execution, and transaction timeouts—and provides practical adjustments to improve performance and reliability in production environments.

JavaPerformance TuningSpringBoot
0 likes · 13 min read
Avoid Hidden SpringBoot Pitfalls: Optimize Default Settings for Production
MaGe Linux Operations
MaGe Linux Operations
Aug 23, 2025 · Operations

Unlock Hidden Linux System Tweaks: Secrets 99% of Engineers Miss

This guide presents a collection of advanced Linux performance optimizations—including kernel parameter tweaks, filesystem and I/O settings, CPU affinity, memory management, network tuning, and automated monitoring scripts—demonstrated with a real‑world e‑commerce case study that boosted QPS from 2 000 to 12 000 and reduced latency by 75%.

Performance TuningSystem Optimizationkernel parameters
0 likes · 13 min read
Unlock Hidden Linux System Tweaks: Secrets 99% of Engineers Miss
MaGe Linux Operations
MaGe Linux Operations
Aug 23, 2025 · Operations

Master Linux Server Performance: From Beginner to Expert with Real‑World Tuning Guide

This comprehensive guide walks you through Linux server performance bottlenecks, monitoring fundamentals, CPU, memory, disk, and network optimizations, application‑level tweaks, automated scripts, real‑world case studies, and evaluation methods, providing step‑by‑step commands and expert tips to dramatically improve system responsiveness.

Performance Tuningserver optimizationsysadmin
0 likes · 18 min read
Master Linux Server Performance: From Beginner to Expert with Real‑World Tuning Guide
MaGe Linux Operations
MaGe Linux Operations
Aug 22, 2025 · Databases

How to Turn Slow MySQL Queries into Millisecond Responses: Real‑World Optimization Case Study

This article walks through a real e‑commerce incident where order queries took 15‑30 seconds, identifies bottlenecks via system metrics and slow‑query logs, analyzes execution plans, adds composite indexes, rewrites SQL, applies partitioning, read‑write splitting and caching, and ultimately achieves up to a 230‑fold performance boost.

Database MonitoringMySQLPerformance Tuning
0 likes · 15 min read
How to Turn Slow MySQL Queries into Millisecond Responses: Real‑World Optimization Case Study
Ops Development Stories
Ops Development Stories
Aug 20, 2025 · Databases

Master Elasticsearch: Core Concepts, Architecture, Queries & Performance for Interviews

This comprehensive guide covers Elasticsearch fundamentals—including core concepts, data model, cluster roles, indexing, mapping, inverted index, query DSL, aggregation, pagination, performance tuning, operational monitoring, security, high availability, and real‑world use cases—providing interview‑ready knowledge and practical tips for developers and ops engineers.

ElasticsearchPerformance TuningQuery DSL
0 likes · 15 min read
Master Elasticsearch: Core Concepts, Architecture, Queries & Performance for Interviews
Architect's Guide
Architect's Guide
Aug 20, 2025 · Backend Development

How to Tune JVM for 1M Daily Logins on an 8GB Server Node

This article walks through a systematic, interview‑style guide for sizing and configuring JVM heap, young generation, GC choice, and related parameters to reliably support a platform that processes one million login requests per day on an 8 GB memory node.

Garbage CollectionJVMJava
0 likes · 24 min read
How to Tune JVM for 1M Daily Logins on an 8GB Server Node
MaGe Linux Operations
MaGe Linux Operations
Aug 18, 2025 · Operations

Which Nginx Load‑Balancing Strategy Wins in Production? A Real‑World Guide

An experienced ops engineer shares a production incident caused by mis‑chosen Nginx load‑balancing, compares Weighted Round‑Robin and IP‑Hash in depth, presents a week‑long stress test, offers best‑practice configurations, common pitfalls, performance‑tuning tips, and actionable recommendations for reliable traffic distribution.

IP HashPerformance Tuningload balancing
0 likes · 9 min read
Which Nginx Load‑Balancing Strategy Wins in Production? A Real‑World Guide
dbaplus Community
dbaplus Community
Aug 17, 2025 · Databases

Rescuing Crashing Databases: Real‑World Bad SQL Cases and How to Fix Them

This article walks through four real‑world SQL performance disasters—chaotic joins, NULL‑value scans, LOB full‑table scans, and massive batch deletions—explaining why they cripple databases and providing concrete, step‑by‑step rewrite and indexing solutions to restore stability and speed.

DBADatabaseOptimization
0 likes · 7 min read
Rescuing Crashing Databases: Real‑World Bad SQL Cases and How to Fix Them
MaGe Linux Operations
MaGe Linux Operations
Aug 17, 2025 · Operations

Master Linux Performance: Proven Monitoring & Tuning Techniques to Boost System Speed 300%

This comprehensive guide shares a seasoned sysadmin's proven Linux performance monitoring and tuning methods—including CPU, memory, disk I/O, and network optimization, real‑world case studies, and ready‑to‑run shell scripts—so you can transform from a firefighting engineer into a performance expert.

Performance TuningShell Scriptssysadmin
0 likes · 26 min read
Master Linux Performance: Proven Monitoring & Tuning Techniques to Boost System Speed 300%
mikechen
mikechen
Aug 14, 2025 · Backend Development

How Nginx Handles High Concurrency: Event‑Driven Model, Async I/O, and Tuning Tips

This article explains how Nginx achieves high‑concurrency handling through its event‑driven architecture, asynchronous non‑blocking I/O, modular design, and key configuration optimizations such as worker processes, connections, keepalive timeout, and sendfile, providing practical code examples and performance tips.

Async I/OPerformance Tuningbackend
0 likes · 6 min read
How Nginx Handles High Concurrency: Event‑Driven Model, Async I/O, and Tuning Tips
JD Tech Talk
JD Tech Talk
Aug 13, 2025 · Backend Development

Why MySQL getUiToken Times Out: PhantomReference GC Bottleneck & Fix

The article investigates frequent timeout alerts on the getUiToken API, tracing the issue to excessive PhantomReference objects causing long GC pauses, explains how MySQL’s AbandonedConnectionCleanupThread and default Druid pool settings generate these references, and presents configuration tweaks, JVM flags, and cleanup tasks that reduced GC pause times from 1.25 s to 0.1 s.

DruidGCJava
0 likes · 11 min read
Why MySQL getUiToken Times Out: PhantomReference GC Bottleneck & Fix
MaGe Linux Operations
MaGe Linux Operations
Aug 4, 2025 · Operations

Boost K8s Node Network Performance by 30% with Linux Kernel Tuning

This article explains how fine‑tuning Linux kernel parameters—such as TCP connection queues, buffer sizes, conntrack limits, interrupt affinity, and container network settings—can improve Kubernetes node network throughput by over 30% in high‑concurrency microservice environments, with real‑world examples and verification scripts.

KubernetesNetwork PerformancePerformance Tuning
0 likes · 11 min read
Boost K8s Node Network Performance by 30% with Linux Kernel Tuning
MaGe Linux Operations
MaGe Linux Operations
Aug 3, 2025 · Databases

Why MySQL Replication Lag Can Crash Your System – Binlog, Semi‑Sync & GTID Explained

An experienced DBA recounts a midnight MySQL replication disaster where slave lag exceeded 60 seconds, then dissects the root causes—binlog formats, semi‑synchronous replication, and GTID—offering detailed configurations, performance tweaks, monitoring scripts, and best‑practice recommendations to prevent and resolve such failures.

GTIDMySQLPerformance Tuning
0 likes · 15 min read
Why MySQL Replication Lag Can Crash Your System – Binlog, Semi‑Sync & GTID Explained
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Jul 31, 2025 · Operations

How to Fix Elasticsearch Sync Bottlenecks: Practical Optimization Steps

This article walks through a real‑world case where syncing over 12 million records to Elasticsearch stalled, analyzes memory pressure, thread‑pool limits, and Netty I/O logs, and then presents concrete configuration tweaks, batch‑by‑time‑slice loading, DSL bulk‑API adjustments, and cluster‑health monitoring that reduced the import time to about two hours.

Data synchronizationElasticsearchPerformance Tuning
0 likes · 6 min read
How to Fix Elasticsearch Sync Bottlenecks: Practical Optimization Steps
MaGe Linux Operations
MaGe Linux Operations
Jul 27, 2025 · Databases

Master MySQL Performance Tuning & Troubleshooting on Linux: A Complete Guide

This comprehensive guide walks you through why MySQL performance matters, how to benchmark and establish baselines, apply Linux system and MySQL configuration optimizations, fine‑tune SQL queries, diagnose common failures, set up robust monitoring, and implement high‑availability architectures for production environments.

MySQLPerformance Tuningdatabase optimization
0 likes · 18 min read
Master MySQL Performance Tuning & Troubleshooting on Linux: A Complete Guide
MaGe Linux Operations
MaGe Linux Operations
Jul 26, 2025 · Operations

How to Build a High‑Availability Prometheus Monitoring System: Pitfalls & Performance Tuning

This article walks you through building a production‑grade, highly available Prometheus monitoring system, covering architecture design with federation and sharding, common pitfalls such as memory bloat, query latency and storage growth, plus practical tuning, deployment, alerting and advanced optimization techniques.

KubernetesPerformance Tuninghigh availability
0 likes · 10 min read
How to Build a High‑Availability Prometheus Monitoring System: Pitfalls & Performance Tuning
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Jul 25, 2025 · Backend Development

Pitfall Diary: Practical Lessons on Using Elasticsearch Nested Types

After a failed flatten‑field migration from MySQL to Elasticsearch caused incorrect product matches, the team introduced nested types, redesigned mappings, rewrote queries with nested and inner_hits, optimized performance, documented pitfalls, and concluded that nested types solve one‑to‑many relations but require careful evaluation.

ElasticsearchNested TypePerformance Tuning
0 likes · 15 min read
Pitfall Diary: Practical Lessons on Using Elasticsearch Nested Types
Programmer1970
Programmer1970
Jul 25, 2025 · Backend Development

Netty Performance Tuning: Zero‑Copy, Off‑Heap Memory Management, and EventLoop Thread Model Optimization

This article analyzes the root causes of high CPU usage, GC pauses, and thread contention in Netty‑based messaging systems and presents a step‑by‑step solution covering zero‑copy with CompositeByteBuf and FileRegion, off‑heap Direct Buffers with PooledByteBufAllocator, and fine‑tuned EventLoopGroup configurations, backed by concrete benchmark data.

Java NIONettyOff-heap memory
0 likes · 11 min read
Netty Performance Tuning: Zero‑Copy, Off‑Heap Memory Management, and EventLoop Thread Model Optimization
MaGe Linux Operations
MaGe Linux Operations
Jul 25, 2025 · Databases

Master MySQL Ops: From Config Tuning to Query Performance Boost

This comprehensive guide walks you through a real production incident and then details MySQL configuration tuning, memory and thread settings, InnoDB core parameters, index design, query optimization cases, slow‑query analysis, read‑write splitting, monitoring scripts, sharding strategies, fault diagnosis, backup and recovery best practices, and high‑availability deployment, providing actionable tips and code examples for robust database performance.

MySQLPerformance TuningReplication
0 likes · 12 min read
Master MySQL Ops: From Config Tuning to Query Performance Boost
Ops Community
Ops Community
Jul 23, 2025 · Operations

Why Did My JVM Show 900% CPU? Uncovering Container Limit Misconfigurations

An 8‑year ops veteran investigates a night‑time alert showing 900% CPU usage, discovers that a JVM inside a Kubernetes pod misreads host cores while the container is limited to two CPUs, and outlines how improper thread‑pool settings and monitoring metrics caused massive throttling before presenting concrete fixes.

CPU throttlingJVMKubernetes
0 likes · 10 min read
Why Did My JVM Show 900% CPU? Uncovering Container Limit Misconfigurations
MaGe Linux Operations
MaGe Linux Operations
Jul 21, 2025 · Artificial Intelligence

Master Multi‑GPU Load Balancing for OLLAMA: From Zero to Production

This guide walks you through configuring OLLAMA for multi‑GPU load balancing, covering hardware checks, CUDA setup, native and Docker deployment methods, detailed parameter tuning, advanced sharding strategies, troubleshooting, performance optimization, and production‑grade monitoring to maximize throughput and stability of large language models.

AI deploymentCUDAOllama
0 likes · 16 min read
Master Multi‑GPU Load Balancing for OLLAMA: From Zero to Production
Deepin Linux
Deepin Linux
Jul 21, 2025 · Operations

Master Linux CPU Performance: Metrics, Tools, and Optimization Strategies

This comprehensive guide explains Linux CPU performance fundamentals, key metrics like load average and utilization, common bottlenecks, and step‑by‑step usage of tools such as top, htop, vmstat, iostat, perf, and stress, followed by practical tuning techniques and real‑world case studies for developers and system administrators.

CPU performanceLinuxPerformance Tuning
0 likes · 61 min read
Master Linux CPU Performance: Metrics, Tools, and Optimization Strategies
MaGe Linux Operations
MaGe Linux Operations
Jul 19, 2025 · Databases

Master MySQL 8.0 Performance: 20+ Proven Optimization Tips

This guide presents more than twenty practical MySQL 8.0 optimization recommendations—including hardware tuning, InnoDB configuration, index design, query rewriting, security hardening, monitoring, backup strategies, and benchmarking—to help engineers dramatically improve database throughput, latency, and stability.

InnoDBMySQLPerformance Tuning
0 likes · 15 min read
Master MySQL 8.0 Performance: 20+ Proven Optimization Tips
Programmer1970
Programmer1970
Jul 17, 2025 · Cloud Native

Nacos in Spring Cloud: Split‑Brain, Timeout, and Performance Deep Dive

This article analyzes three critical issues when using Nacos as a service registry in Spring Cloud—network partition (split‑brain), registration timeout, and high‑concurrency performance bottlenecks—explaining their root causes, code‑level mechanisms, and practical mitigation strategies, and concludes with a feature‑by‑feature comparison of Nacos, Eureka, and Zookeeper.

CAP theoremNacosPerformance Tuning
0 likes · 9 min read
Nacos in Spring Cloud: Split‑Brain, Timeout, and Performance Deep Dive
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jul 15, 2025 · Backend Development

9 Proven Ways to Speed Up Spring Boot 3 Startup Time

This article explains nine practical techniques—including narrowing component scans, enabling lazy initialization, excluding unused auto‑configurations, using a component indexer, tuning the database pool, avoiding heavy bean init tasks, leveraging CDS, running exploded jars, and employing GraalVM native images—to dramatically reduce Spring Boot 3 application startup time.

JavaPerformance TuningSpring Boot
0 likes · 11 min read
9 Proven Ways to Speed Up Spring Boot 3 Startup Time
IT Xianyu
IT Xianyu
Jul 14, 2025 · Databases

Master MySQL Performance: Essential my.cnf Tweaks with Docker Compose

This guide walks you through setting up a MySQL instance on AlmaLinux using Docker Compose and explains the most impactful my.cnf parameters—innodb_buffer_pool_size, max_connections, innodb_flush_log_at_trx_commit, and sync_binlog—so you can safely boost database performance.

AlmaLinuxConfigurationDocker Compose
0 likes · 12 min read
Master MySQL Performance: Essential my.cnf Tweaks with Docker Compose
Cognitive Technology Team
Cognitive Technology Team
Jul 12, 2025 · Backend Development

Mastering Apache HttpClient Connection Pool: Limits, Pitfalls, and Optimization

This article explores Apache HttpClient’s connection pool mechanism, detailing key parameters such as maxConnTotal, maxConnPerRoute, and timeToLive, explains how connections are allocated and reused, highlights common misconfigurations, and provides best‑practice tuning recommendations for high‑concurrency Java applications.

Apache HttpClientJavaPerformance Tuning
0 likes · 9 min read
Mastering Apache HttpClient Connection Pool: Limits, Pitfalls, and Optimization
MaGe Linux Operations
MaGe Linux Operations
Jul 9, 2025 · Databases

Mastering Chinese Domestic Databases: Deep Dive into DM, TiDB, and openGauss

Explore the technical features, architecture, deployment steps, performance tuning, monitoring, backup, security hardening, and comparative analysis of three leading Chinese databases—DM (Dameng), TiDB, and openGauss—providing a comprehensive guide for operations engineers to implement and manage these systems effectively.

DatabasePerformance Tuning
0 likes · 25 min read
Mastering Chinese Domestic Databases: Deep Dive into DM, TiDB, and openGauss
Su San Talks Tech
Su San Talks Tech
Jul 9, 2025 · Databases

Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety

This article explains how MySQL’s three essential logs—redo, undo, and binlog—work together to guarantee data durability, enable crash recovery, support transaction rollback, and power master‑slave replication, while providing practical configuration tips, monitoring queries, and recovery procedures for production environments.

MySQLPerformance TuningRedo Log
0 likes · 10 min read
Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety
Deepin Linux
Deepin Linux
Jul 8, 2025 · Operations

Unlock Linux NUMA Performance: A Practical Multithreaded Tuning Guide

This article explains the fundamentals of NUMA architecture, why it matters for multithreaded Linux applications, and provides step‑by‑step practical guidance—including kernel internals, memory allocation policies, useful commands, and performance‑monitoring tools—to help developers optimize memory locality and boost overall program efficiency.

LinuxNUMAPerformance Tuning
0 likes · 37 min read
Unlock Linux NUMA Performance: A Practical Multithreaded Tuning Guide
Raymond Ops
Raymond Ops
Jul 7, 2025 · Operations

Understanding Linux NIC Packet Reception and How to Fix Drop Issues

This article explains the Linux network interface card packet reception flow, how to identify and interpret RX errors, dropped packets and overruns, and provides practical commands and tuning methods such as adjusting ring buffers, IRQ affinity, RSS/RPS, and netdev_max_backlog to resolve packet loss.

LinuxNetworkPerformance Tuning
0 likes · 12 min read
Understanding Linux NIC Packet Reception and How to Fix Drop Issues
Java Architect Essentials
Java Architect Essentials
Jul 6, 2025 · Backend Development

How to Slash Spring Boot Startup Time by 80%: 10 Proven Optimizations

This article shares ten practical techniques—including lazy bean loading, removing unused auto‑configurations, classloader tweaks, thread‑pool tuning, logging reduction, health‑check disabling, SSD upgrades, Maven packaging fixes, and Arthas monitoring—that together can reduce Spring Boot startup from minutes to seconds, dramatically boosting developer productivity.

Performance TuningSpring Bootstartup-optimization
0 likes · 7 min read
How to Slash Spring Boot Startup Time by 80%: 10 Proven Optimizations
Ops Community
Ops Community
Jul 5, 2025 · Operations

Unlock 300% Linux Performance: Proven Kernel Tuning Secrets from 10 Years of Ops

Discover how deep understanding of Linux kernel architecture, process, memory, filesystem, and network subsystems combined with practical Bash scripts can boost system performance by up to 300%, offering step‑by‑step tuning, monitoring, and debugging techniques essential for senior operations engineers.

Bash ScriptingLinux kernelMemory Management
0 likes · 18 min read
Unlock 300% Linux Performance: Proven Kernel Tuning Secrets from 10 Years of Ops
MaGe Linux Operations
MaGe Linux Operations
Jul 5, 2025 · Databases

Essential DBA Guide: Mastering Enterprise MySQL Management & Optimization

This comprehensive guide walks DBAs through enterprise‑level MySQL architecture, master‑slave replication, high‑availability clustering, performance tuning, index optimization, backup and recovery strategies, monitoring, security hardening, fault diagnosis, and best‑practice checklists to build a stable, efficient, and secure database environment.

Database AdministrationMySQLPerformance Tuning
0 likes · 15 min read
Essential DBA Guide: Mastering Enterprise MySQL Management & Optimization
JD Tech Talk
JD Tech Talk
Jul 1, 2025 · Fundamentals

How False Sharing Slows Down Multithreaded Java Apps—and How to Fix It

This article explains the hidden performance killer of cache false sharing in multicore Java applications, demonstrates its impact with benchmark code, and shows how padding, the @Contended annotation, and Caffeine's internal structures can eliminate the issue for faster execution.

Cache OptimizationCaffeineContended
0 likes · 10 min read
How False Sharing Slows Down Multithreaded Java Apps—and How to Fix It
JD Cloud Developers
JD Cloud Developers
Jul 1, 2025 · Fundamentals

How False Sharing Slows Your Java Apps and How to Eliminate It

This article explains the cache architecture behind false sharing, demonstrates its dramatic performance impact with benchmark code, and shows how Java's @Contended annotation and Caffeine's memory‑padding techniques can effectively eliminate the issue for high‑concurrency applications.

Cache OptimizationFalse sharingPerformance Tuning
0 likes · 10 min read
How False Sharing Slows Your Java Apps and How to Eliminate It
Lin is Dream
Lin is Dream
Jun 27, 2025 · Backend Development

How to Solve Common RocketMQ Issues: Duplicates, Throttling, Retries, and Loss

This article examines frequent RocketMQ problems such as duplicate sending, flow‑control throttling, message retries, duplicate consumption, backlog, and loss, and provides practical configuration tweaks, scaling strategies, batch sending, idempotent handling, and retry mechanisms to ensure reliable message delivery.

JavaMessage QueuePerformance Tuning
0 likes · 9 min read
How to Solve Common RocketMQ Issues: Duplicates, Throttling, Retries, and Loss
IT Services Circle
IT Services Circle
Jun 20, 2025 · Databases

Why MySQL GROUP BY Can Be Slow and How to Optimize It

This article explains why MySQL GROUP BY queries may run slowly due to missing indexes, temporary tables, and filesort, and provides practical optimization techniques such as removing unnecessary sorting, adding indexes, tuning buffers, and using application‑level or materialized view solutions.

GROUP BYIndexingMySQL
0 likes · 6 min read
Why MySQL GROUP BY Can Be Slow and How to Optimize It
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 19, 2025 · Databases

How OceanBase CPU Quotas and Large Queries Shape Performance

This article explores OceanBase v4 CPU‑related parameters such as workers_per_cpu_quota, cpu_quota_concurrency, and parallel_servers_target, explains their formulas, demonstrates experimental setups and results on tenant thread limits, large‑query impact, and provides practical tuning recommendations based on observed performance data.

Database ConcurrencyOceanBasePerformance Tuning
0 likes · 17 min read
How OceanBase CPU Quotas and Large Queries Shape Performance
StarRocks
StarRocks
Jun 17, 2025 · Databases

How to Ace the StarRocks SRCA Certification: Key Topics and Study Strategies

This guide outlines the StarRocks SRCA certification exam, highlights essential study resources, breaks down the core topics such as architecture, data import/export, SQL optimization and performance tuning, and offers practical tips, mock‑exam details, and personal experience to help candidates succeed.

Database CertificationPerformance TuningSQL optimization
0 likes · 9 min read
How to Ace the StarRocks SRCA Certification: Key Topics and Study Strategies
IT Services Circle
IT Services Circle
Jun 15, 2025 · Backend Development

How to Diagnose and Fix JVM GC Pauses in High‑Concurrency Microservices

This article walks through a real‑world production case, detailing how to systematically detect, analyze, and resolve severe JVM garbage‑collection pauses in a high‑concurrency Spring Boot microservice, covering resource analysis, JVM flag tuning, G1GC migration, JMX listeners, and GC‑log investigation.

G1GCGarbage CollectionJVM
0 likes · 16 min read
How to Diagnose and Fix JVM GC Pauses in High‑Concurrency Microservices
Programmer1970
Programmer1970
Jun 8, 2025 · Operations

Top 10 Essential Linux Ops Questions Every Interviewer and Engineer Should Master

This guide walks through ten core Linux operations topics—precise system resource monitoring, deep process diagnostics, network and port‑conflict troubleshooting, permission models, link‑type comparison, boot sequence analysis, layered log auditing, automation with cron, advanced file search, and systematic performance‑tuning—providing concrete commands, examples, and step‑by‑step procedures for interview and on‑the‑job success.

Boot SequenceLinuxLog Auditing
0 likes · 11 min read
Top 10 Essential Linux Ops Questions Every Interviewer and Engineer Should Master
Instant Consumer Technology Team
Instant Consumer Technology Team
Jun 5, 2025 · Big Data

Mastering Kafka in Production: Boost Throughput, Ensure Reliability, and Avoid Data Loss

This article shares practical Kafka production insights, covering architecture overview, producer throughput tuning, message loss prevention, broker and consumer configurations, duplicate consumption avoidance, backlog mitigation, ordering guarantees, and the mechanics of consumer group rebalancing, helping engineers build stable, high‑performance streaming pipelines.

Big DataConsumer GroupKafka
0 likes · 15 min read
Mastering Kafka in Production: Boost Throughput, Ensure Reliability, and Avoid Data Loss
vivo Internet Technology
vivo Internet Technology
Jun 4, 2025 · Cloud Native

Deep Dive into Apache Pulsar Producer: Architecture, Parameters, and Performance Tuning

This article provides a comprehensive analysis of Apache Pulsar's Producer component, detailing its message-sending workflow, key design principles, configuration parameters, and practical performance tuning techniques to improve throughput, reduce latency, and lower resource consumption in large‑scale cloud‑native messaging systems.

Apache PulsarPerformance TuningProducer
0 likes · 26 min read
Deep Dive into Apache Pulsar Producer: Architecture, Parameters, and Performance Tuning
MaGe Linux Operations
MaGe Linux Operations
May 27, 2025 · Operations

Master Linux Kernel Tuning: From Theory to Practical Sysctl Configuration

Learn how to configure and verify essential Linux kernel parameters using sysctl, covering temporary and permanent settings, container-specific adjustments, validation techniques, common pitfalls, and best practices to boost network performance, stability, and security for system administrators and DevOps engineers.

DevOpsPerformance Tuningkernel parameters
0 likes · 9 min read
Master Linux Kernel Tuning: From Theory to Practical Sysctl Configuration
Mingyi World Elasticsearch
Mingyi World Elasticsearch
May 27, 2025 · Operations

The Deep‑Dive Elasticsearch Settings List You Must Know

This article presents a comprehensive, source‑code‑derived list of every Elasticsearch configuration option—including hidden and undocumented settings—explains their scopes, default values, and types, and shows how the list can be used for quick lookups, performance tuning, debugging, and automation.

Cluster ConfigurationElasticsearchPerformance Tuning
0 likes · 10 min read
The Deep‑Dive Elasticsearch Settings List You Must Know
Deepin Linux
Deepin Linux
May 22, 2025 · Operations

Understanding Buffers and Cache in Linux Memory Management

This article explains the concepts, working principles, and system parameters of Linux buffers and cache, compares their roles in read/write operations, and provides practical vmstat and dd command examples to illustrate how they affect memory usage and I/O performance.

BufferPerformance Tuningdd
0 likes · 19 min read
Understanding Buffers and Cache in Linux Memory Management
Programmer DD
Programmer DD
May 15, 2025 · Backend Development

Boost Spring Boot Performance 3× with JVM Tuning: Practical Parameters

After caching, indexing, and async optimizations still leave a Spring Boot REST API sluggish, this guide shows how fine‑tuning JVM options—such as enabling G1GC, adjusting pause targets, compressing class metadata, shrinking thread stacks, and pre‑touching memory—can triple response speed without changing application code.

G1GCJVMJava
0 likes · 7 min read
Boost Spring Boot Performance 3× with JVM Tuning: Practical Parameters
Liangxu Linux
Liangxu Linux
May 13, 2025 · Operations

Boost Linux Server Performance: Essential Kernel Tweaks and Sysctl Settings

Learn how to permanently disable SELinux, set runlevel to 3, increase file descriptor limits, fine‑tune kernel sysctl parameters, configure firewall settings, and resolve common Linux performance issues such as too many open files and connection timeouts to dramatically improve server throughput.

Performance Tuningkernel parametersserver optimization
0 likes · 7 min read
Boost Linux Server Performance: Essential Kernel Tweaks and Sysctl Settings
Su San Talks Tech
Su San Talks Tech
May 12, 2025 · Databases

How to Diagnose and Fix Slow MySQL Queries: A Surgeon’s Guide

This article walks you through diagnosing slow MySQL queries using EXPLAIN, fixing index issues, reordering joins, forcing optimal indexes, monitoring index usage, and applying systematic governance such as SQL sanitization and sharding to dramatically improve performance.

EXPLAINMySQLPerformance Tuning
0 likes · 9 min read
How to Diagnose and Fix Slow MySQL Queries: A Surgeon’s Guide
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 InsertKafkaMySQL
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.

IndexMySQLPerformance Tuning
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.

MySQLPerformance Tuningcaching
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.

Database AdministrationPerformance TuningRestore
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 AnalysisPerformance Tuning
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.

IndexingJoinsPerformance Tuning
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 SettingsPerformance Tuning
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.

EXPLAINMySQLPerformance Tuning
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 DeletionMySQLOnline DDL
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.

LRULinuxPerformance Tuning
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 QueuePerformance Tuning
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.

JavaPerformance TuningSpring 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.

LinuxPerformance Tuningkernel parameters
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.

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

Dynamic ScalingJava concurrencyPerformance Tuning
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.

EXPLAINMySQLPerformance Tuning
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.

JVMJavaMemory Management
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 ToolsMySQLPerformance Tuning
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 cacheCache OptimizationMESI Protocol
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