BestHub
Sign in
Tagged articles
986 articles
Page 2 of 10
21CTO
21CTO
Nov 2, 2025 · Databases

How to Slash Database Costs by 60% Without Sacrificing Performance

This article explains why database expenses balloon, then walks through ten practical techniques—including smart indexing, selective column queries, caching, partitioning, archiving, data‑type tuning, simplifying joins, regular maintenance, query monitoring, and right‑sized hardware—to cut costs up to 60% while preserving or even boosting query speed.

Cost ReductionDatabase OptimizationPerformance tuning
0 likes · 10 min read
How to Slash Database Costs by 60% Without Sacrificing Performance
Data Party THU
Data Party THU
Nov 2, 2025 · Operations

How to Maximize vLLM Throughput: Batch Size, Quantization, and Monitoring Tips

This guide explains how to unleash vLLM’s full potential by optimizing batch size, leveraging 4‑bit quantization, tuning concurrency parameters, planning capacity with token‑per‑second metrics, and implementing robust monitoring to balance latency, cost, and scalability in production deployments.

BatchingLLM servingMonitoring
0 likes · 10 min read
How to Maximize vLLM Throughput: Batch Size, Quantization, and Monitoring Tips
Su San Talks Tech
Su San Talks Tech
Oct 30, 2025 · Backend Development

7 Proven Techniques to Slash Spring Boot Startup Time by Over 70%

This article walks through seven practical Spring Boot startup‑time optimizations—lazy initialization, precise component scanning, JVM tuning, auto‑configuration pruning, class‑loading reduction, lazy database connections, and AOT/layered compilation—backed by real‑world case studies and measurable performance gains.

AoTJVMPerformance tuning
0 likes · 10 min read
7 Proven Techniques to Slash Spring Boot Startup Time by Over 70%
Raymond Ops
Raymond Ops
Oct 28, 2025 · Operations

Master Linux Kernel Tuning: From Theory to Practical Sysctl Configuration

This guide walks system administrators and DevOps engineers through the purpose of key Linux kernel parameters, how to set them temporarily or permanently—including in Docker and Kubernetes—verify their effect, troubleshoot common issues, and apply best‑practice tuning for improved performance and stability.

ContainerLinuxPerformance tuning
0 likes · 9 min read
Master Linux Kernel Tuning: From Theory to Practical Sysctl Configuration
Xiao Liu Lab
Xiao Liu Lab
Oct 27, 2025 · Databases

Boost MySQL Performance: 6 Essential Config Tweaks for 5000+ QPS

Even when CPU and memory appear idle, MySQL can suffer connection timeouts, query stalls, and 100% CPU spikes during peak traffic, but by adjusting six key configuration parameters and following solid SQL‑optimization practices you can reliably support thousands of queries per second.

Database ConfigurationPerformance tuningSQL optimization
0 likes · 6 min read
Boost MySQL Performance: 6 Essential Config Tweaks for 5000+ QPS
MaGe Linux Operations
MaGe Linux Operations
Oct 25, 2025 · Operations

Master Linux Disk Management & I/O Optimization: Expand and Tune

This comprehensive guide walks you through Linux disk expansion, LVM provisioning, filesystem resizing, I/O scheduler tuning, performance benchmarking with fio, monitoring with Prometheus, security hardening, troubleshooting common disk issues, and best‑practice recommendations for reliable production environments.

I/O optimizationLVMLinux
0 likes · 27 min read
Master Linux Disk Management & I/O Optimization: Expand and Tune
MaGe Linux Operations
MaGe Linux Operations
Oct 24, 2025 · Operations

Why Did TCP Connections Skyrocket from 15K to 65K? Full Diagnosis and Fix

This postmortem details a production outage caused by a sudden surge of TCP connections from 15 K to 65 K, explains how to reproduce the issue, walks through step‑by‑step diagnostics, root‑cause analysis, and permanent remediation using Linux kernel tuning, connection‑pool configuration, and monitoring alerts.

Connection leakLinuxPerformance tuning
0 likes · 32 min read
Why Did TCP Connections Skyrocket from 15K to 65K? Full Diagnosis and Fix
Top Architect
Top Architect
Oct 15, 2025 · Backend Development

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

This article walks through a step‑by‑step guide for configuring JVM memory, selecting the right garbage collector, and fine‑tuning parameters to reliably handle a platform receiving one million login requests per day on a service node with 8 GB RAM, covering capacity planning, GC choice, heap sizing, thread stack, object aging, and monitoring.

Garbage CollectionJVMJava
0 likes · 27 min read
How to Tune JVM for 1M Daily Logins on an 8 GB Server
Selected Java Interview Questions
Selected Java Interview Questions
Oct 15, 2025 · Backend Development

How to Turbocharge Java Spring Boot Startup: From Seconds to Milliseconds

This article explains why Java applications often start slowly, identifies the main culprits such as excessive class loading, bloated JARs, and reflection, and provides a comprehensive set of JVM, Spring Boot, code‑level, and deployment optimizations—including lazy loading, auto‑configuration pruning, GraalVM native images, and container probes—to dramatically reduce startup time and ace interview questions.

JVMJavaPerformance tuning
0 likes · 13 min read
How to Turbocharge Java Spring Boot Startup: From Seconds to Milliseconds
MaGe Linux Operations
MaGe Linux Operations
Oct 14, 2025 · Cloud Native

Scaling Kubernetes from 1,000 to 5,000 Nodes: Real‑World Performance Tuning Guide

This article details a step‑by‑step, production‑grade guide for expanding a Kubernetes cluster from 1,000 to 5,000 nodes, covering control‑plane HA, etcd tuning, network and scheduler optimizations, monitoring, and real‑world case studies to achieve stable, high‑performance large‑scale deployments.

Control PlaneKubernetesPerformance tuning
0 likes · 27 min read
Scaling Kubernetes from 1,000 to 5,000 Nodes: Real‑World Performance Tuning Guide
BirdNest Tech Talk
BirdNest Tech Talk
Oct 12, 2025 · Artificial Intelligence

What Happens When a Token Travels Through GPU Villages via RDMA and NVLink?

The article uses a whimsical journey to illustrate how token data is dispatched across GPU clusters—detailing functions like get_dispatch_layout, notify_dispatch, and combine_token, showing RDMA and NVLink pathways, performance experiments, and the final verification of token integrity.

AIDistributed SystemsGPU
0 likes · 5 min read
What Happens When a Token Travels Through GPU Villages via RDMA and NVLink?
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Oct 12, 2025 · Backend Development

Master Nginx Performance: 5 Key Settings to Boost Your Backend

This guide explains five essential Nginx configuration parameters—worker_processes, worker_connections, keepalive_timeout, sendfile/tcp_nopush/tcp_nodelay, and client_max_body_size—detailing their meanings, optimization recommendations, and practical considerations for high‑performance backend services.

Performance tuningconfiguration
0 likes · 4 min read
Master Nginx Performance: 5 Key Settings to Boost Your Backend
Deepin Linux
Deepin Linux
Oct 12, 2025 · Operations

Unlock Linux Performance: Mastering CFS Process Scheduling and Tuning

This comprehensive guide explains Linux’s Completely Fair Scheduler (CFS), covering its core principles, virtual runtime calculations, red‑black tree implementation, multi‑core load balancing, real‑time priority handling, and practical tuning techniques with full C++ examples to help developers and sysadmins optimize CPU allocation and system responsiveness.

CFSLinuxPerformance tuning
0 likes · 66 min read
Unlock Linux Performance: Mastering CFS Process Scheduling and Tuning
Ops Community
Ops Community
Oct 5, 2025 · Databases

Master MySQL Slow Query Optimization: Proven Methods & Pitfall Guide

This comprehensive guide walks you through a systematic methodology for diagnosing and fixing MySQL slow queries, covering proper log configuration, EXPLAIN analysis, index design, query rewriting, table restructuring, and practical caching techniques, while highlighting common misconceptions and real‑world case studies.

DatabaseIndex OptimizationPerformance tuning
0 likes · 35 min read
Master MySQL Slow Query Optimization: Proven Methods & Pitfall Guide
MaGe Linux Operations
MaGe Linux Operations
Sep 30, 2025 · Cloud Native

Boosting Docker CPU Utilization: From 30% to 90% in 3 Months

This article recounts a three‑month deep‑dive into Docker container performance, detailing how we identified root causes such as Java container‑awareness, CPU pinning, memory limits, I/O bottlenecks, and network overhead, and applied systematic tuning of cgroups, JVM flags, Docker Compose settings, and storage/network configurations to raise CPU usage to 90% and double throughput.

Container OptimizationDockerJVM
0 likes · 26 min read
Boosting Docker CPU Utilization: From 30% to 90% in 3 Months
Tech Freedom Circle
Tech Freedom Circle
Sep 28, 2025 · Backend Development

Midnight TODO That Nearly Crashed the Whole Department: A JVM Performance Tuning Case Study

During a midnight promotion launch, a forgotten TODO caused thread‑pool exhaustion and frequent Full GC, bringing down an e‑commerce service; the article presents a five‑step end‑to‑end JVM tuning methodology, from data collection to root‑cause verification and code fix, showing how to diagnose and resolve such incidents.

Full GCHeap DumpJVM
0 likes · 24 min read
Midnight TODO That Nearly Crashed the Whole Department: A JVM Performance Tuning Case Study
Ops Community
Ops Community
Sep 27, 2025 · Operations

Boost Your Server Performance: Practical Nginx Tuning Guide for 10× Speed

This comprehensive guide walks operations engineers through advanced Nginx configuration and performance‑tuning techniques—including worker process settings, event model tweaks, HTTP module optimizations, caching strategies, load‑balancing, security hardening, monitoring, and testing—to dramatically improve web service throughput and stability.

Performance tuningload balancingnginx
0 likes · 10 min read
Boost Your Server Performance: Practical Nginx Tuning Guide for 10× Speed
Su San Talks Tech
Su San Talks Tech
Sep 25, 2025 · Databases

Boost MySQL Query Speed: Indexing, Subqueries vs Joins Explained

This article walks through a MySQL 5.6 scenario where a sub‑query to find students scoring 100 runs for hours, demonstrates how adding single‑column indexes cuts execution time dramatically, explores join‑based rewrites, composite indexes, left‑most prefix rules, covering indexes and sorting optimizations, and provides practical performance‑tuning tips.

JoinPerformance tuningSQL optimization
0 likes · 12 min read
Boost MySQL Query Speed: Indexing, Subqueries vs Joins Explained
Ray's Galactic Tech
Ray's Galactic Tech
Sep 23, 2025 · Databases

Master PostgreSQL: Installation, Configuration, and Performance Tuning Guide

This comprehensive guide walks you through installing PostgreSQL on Linux, Windows, macOS, and Docker, configuring users, databases, and remote access, using daily psql commands, performing backups, applying advanced features like tablespaces and replication, and optimizing performance with key tuning parameters.

DatabaseInstallationPerformance tuning
0 likes · 7 min read
Master PostgreSQL: Installation, Configuration, and Performance Tuning Guide
Open Source Linux
Open Source Linux
Sep 23, 2025 · Operations

20 Essential Linux Commands Every Ops Engineer Must Master

This guide walks you through twenty indispensable Linux commands—covering system monitoring, performance analysis, process management, networking, disk handling, and tuning—explaining their basic and advanced usages, real‑world pitfalls, and how they stay relevant in the cloud‑native era.

LinuxOperationsPerformance tuning
0 likes · 12 min read
20 Essential Linux Commands Every Ops Engineer Must Master
Liangxu Linux
Liangxu Linux
Sep 22, 2025 · Operations

How to Boost Nginx to Over 1 Million QPS: Real‑World High‑Concurrency Tuning

This article presents a step‑by‑step, production‑tested guide for tuning Nginx from 100 k QPS to over a million requests per second, covering worker process settings, TCP tweaks, kernel parameters, caching, compression, SSL optimization, monitoring, and extreme‑case techniques such as DPDK and LuaJIT.

Performance tuningSystem Optimizationload balancing
0 likes · 14 min read
How to Boost Nginx to Over 1 Million QPS: Real‑World High‑Concurrency Tuning
MaGe Linux Operations
MaGe Linux Operations
Sep 22, 2025 · Databases

Redis Ops Survival Guide: From Data Loss Nightmares to Mastering High‑Availability

This comprehensive guide walks you through real‑world Redis failure stories, explains why Redis is a critical backbone for modern applications, and provides step‑by‑step high‑availability designs, troubleshooting mind maps, monitoring setups, security hardening, automation scripts, cloud‑native deployments, and future‑proofing tips for engineers.

Performance tuningRedishigh availability
0 likes · 35 min read
Redis Ops Survival Guide: From Data Loss Nightmares to Mastering High‑Availability
Ops Community
Ops Community
Sep 22, 2025 · Operations

20 Essential Linux Commands Every Ops Engineer Must Master

This guide presents twenty indispensable Linux commands—covering system monitoring, performance analysis, process management, networking, disk handling, and system tuning—along with practical examples, tips, and common pitfalls, empowering operations engineers to quickly diagnose and resolve production issues in modern cloud‑native environments.

DevOpsLinuxOperations
0 likes · 14 min read
20 Essential Linux Commands Every Ops Engineer Must Master
Cognitive Technology Team
Cognitive Technology Team
Sep 21, 2025 · Databases

How Druid’s PreparedStatement Cache Breaks ShardingSphere Routing and Fixes

An unexpected data loss issue in a ShardingSphere‑JDBC setup was traced to Druid’s poolPreparedStatements cache, which reuses PreparedStatement objects across different shards, bypassing dynamic routing; disabling the cache or switching to HikariCP restores correct sharding behavior with minimal performance impact.

Connection PoolDruidPerformance tuning
0 likes · 12 min read
How Druid’s PreparedStatement Cache Breaks ShardingSphere Routing and Fixes
Deepin Linux
Deepin Linux
Sep 16, 2025 · Operations

Master Linux Performance: Proven Tips to Boost Speed and Stability

This comprehensive guide explains how to identify and resolve common Linux performance bottlenecks—covering key metrics, hardware upgrades, kernel parameter tuning, process and memory management, and network optimization—while providing practical commands, code examples, and step‑by‑step troubleshooting techniques to keep servers and desktops running smoothly.

LinuxPerformance tuningSystem Optimization
0 likes · 35 min read
Master Linux Performance: Proven Tips to Boost Speed and Stability
Selected Java Interview Questions
Selected Java Interview Questions
Sep 14, 2025 · Backend Development

Mastering Spring Boot with KingbaseES: Which Connection Pool Wins?

This article explains the importance of database connection pools in Spring Boot projects using KingbaseES, compares four popular pools (DBCP, C3P0, Druid, HikariCP), provides configuration examples, highlights common pitfalls, and offers practical tuning and monitoring guidance for optimal performance.

Database Connection PoolDruidHikariCP
0 likes · 18 min read
Mastering Spring Boot with KingbaseES: Which Connection Pool Wins?
MaGe Linux Operations
MaGe Linux Operations
Sep 13, 2025 · Databases

Master MySQL Performance: From Slow Queries to Billion-Row Optimization

This comprehensive guide walks you through real-world MySQL performance tuning, covering slow query analysis, index design, query optimization, parameter tuning, hardware considerations, sharding, and fault handling, with practical scripts and case studies to help you transform sluggish databases into high‑throughput, scalable systems.

Index OptimizationPerformance tuningdatabase scaling
0 likes · 24 min read
Master MySQL Performance: From Slow Queries to Billion-Row Optimization
Su San Talks Tech
Su San Talks Tech
Sep 11, 2025 · Databases

Why Redis Handles Millions of Requests: Deep Dive into Its High‑Performance Architecture

This article explains how Redis achieves ultra‑high concurrency by combining a single‑threaded event‑driven core, highly optimized in‑memory data structures, efficient I/O multiplexing, smart memory management, asynchronous persistence, and scalable clustering, allowing it to comfortably serve hundreds of thousands of simultaneous requests.

Event-drivenMemory OptimizationPerformance tuning
0 likes · 16 min read
Why Redis Handles Millions of Requests: Deep Dive into Its High‑Performance Architecture
MaGe Linux Operations
MaGe Linux Operations
Sep 10, 2025 · Backend Development

Apache vs Nginx: Complete Performance Comparison & Tuning Guide

This comprehensive guide compares Apache and Nginx architectures, benchmarks static and dynamic workloads, explores high‑concurrency testing, and provides detailed tuning steps for both servers along with real‑world case studies and future trends such as HTTP/3 and container deployment.

ApachePerformance tuningWeb server
0 likes · 21 min read
Apache vs Nginx: Complete Performance Comparison & Tuning Guide
Java Backend Technology
Java Backend Technology
Sep 10, 2025 · Databases

8 Proven MySQL Tricks to Supercharge Query Performance

This article walks through eight practical MySQL optimization techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting UPDATE/DELETE with JOINs, handling mixed sorting, replacing EXISTS with joins, pushing predicates, narrowing result sets early, and leveraging WITH clauses—to dramatically reduce query execution time from seconds to milliseconds.

Performance tuningQuery Planningdatabase indexing
0 likes · 13 min read
8 Proven MySQL Tricks to Supercharge Query Performance
DevOps Coach
DevOps Coach
Sep 8, 2025 · Operations

How I Cut Kubernetes Pod Startup Time by 80% with Simple Tweaks

The article explains practical steps—shrinking container images, fixing probe delays, streamlining init containers, and right‑sizing resources—to dramatically reduce pod startup latency from minutes to seconds without rewriting Kubernetes itself.

Container image optimizationInit containersKubernetes
0 likes · 6 min read
How I Cut Kubernetes Pod Startup Time by 80% with Simple Tweaks
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.

Performance tuningfailoverhigh availability
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 GCInterviewJVM
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.

Kernel ParametersLinuxOperations
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 IndexDatabase 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%.

Kernel ParametersPerformance tuningSystem Optimization
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 MonitoringPerformance tuningmysql
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 tuningWeighted Round Robin
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.

Event-drivenPerformance tuningasync I/O
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.

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

KubernetesPerformance tuningconntrack
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.

GTIDPerformance tuningmysql
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.

ElasticsearchPerformance tuningThread Pool
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.

Database OptimizationPerformance tuninghigh availability
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
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.

Performance tuningmysqlreplication
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.

Database OptimizationInnoDBPerformance tuning
0 likes · 15 min read
Master MySQL 8.0 Performance: 20+ Proven Optimization Tips
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.

AlmaLinuxDatabase OptimizationDocker-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 HttpClientConnection PoolJava
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.

Performance tuningbinlogdatabase reliability
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.

InterruptsLinuxPacket Loss
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 AdministrationPerformance tuningbackup and recovery
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 OptimizationPerformance tuningfalse sharing
0 likes · 10 min read
How False Sharing Slows Your Java Apps and How to Eliminate It
dbaplus Community
dbaplus Community
Jun 30, 2025 · Backend Development

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

This article walks through a real‑world production case, showing how to systematically detect, analyze, and resolve severe JVM garbage‑collection pauses that caused service timeouts, by examining CPU, memory, GC logs, adjusting collector settings, and aligning JVM threads with Kubernetes resource limits.

JVMKubernetesParallelGCThreads
0 likes · 15 min read
How to Diagnose and Fix JVM GC Pause Issues in High‑Concurrency Microservices
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.

Distributed SystemsJavaMessage Queue
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 BYPerformance tuningindexing
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 CertificationExam PreparationPerformance tuning
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.

Garbage CollectionJVMKubernetes
0 likes · 16 min read
How to Diagnose and Fix JVM GC Pauses in High‑Concurrency Microservices
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 DataKafkaMessage Queue
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 PulsarCloud NativeMessaging
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.

DevOpsKernel ParametersPerformance tuning
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 ConfigurationElasticsearchOperations
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.

Performance tuningbufferdd
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.

JVMJavaPerformance tuning
0 likes · 7 min read
Boost Spring Boot Performance 3× with JVM Tuning: Practical Parameters