BestHub
Sign in
Tagged articles
986 articles
Page 1 of 10
IoT Full-Stack Technology
IoT Full-Stack Technology
May 29, 2026 · Backend Development

How We Cut a 30‑Second API Call to Under 1 Second on 2 Million Records

In a high‑concurrency transaction system, the author diagnosed a 30‑second API latency caused by costly SQL scans and Java Map creation on over two million rows, then applied SQL aggregation, moved counting logic into PostgreSQL, and introduced a Caffeine cache, ultimately reducing the response time to under 0.8 seconds while highlighting relational‑database limits for massive data.

Caffeine cacheJavaMyBatis
0 likes · 10 min read
How We Cut a 30‑Second API Call to Under 1 Second on 2 Million Records
ITPUB
ITPUB
May 22, 2026 · Databases

Quick Oracle DBA Guide: How to Pinpoint Database Hangs and Slowdowns

This guide outlines step‑by‑step procedures for diagnosing Oracle database performance problems, covering how to collect ADDM, AWR, and ASH reports, capture high‑CPU error stacks, obtain 10046 trace files for single or multiple sessions, and use Oracle hang‑analysis documents to differentiate true hangs from CPU spinning.

10046 TraceADDMASH
0 likes · 10 min read
Quick Oracle DBA Guide: How to Pinpoint Database Hangs and Slowdowns
Ops Community
Ops Community
May 22, 2026 · Databases

How a Single Slow Query Triggered a Database Avalanche – Full SQL Optimization Walkthrough

A real‑world MySQL incident where a batch UPDATE with an IN‑subquery caused a full‑table scan, connection pool exhaustion, and a system‑wide outage, and the step‑by‑step investigation, emergency mitigation, and comprehensive optimization that reduced query time from 45 seconds to 0.3 seconds.

MonitoringPerformance tuningSQL optimization
0 likes · 20 min read
How a Single Slow Query Triggered a Database Avalanche – Full SQL Optimization Walkthrough
Architect's Guide
Architect's Guide
May 20, 2026 · Databases

30 Essential SQL Query Optimization Techniques

This article presents thirty practical SQL optimization tips, covering index usage, avoiding full‑table scans caused by operators like !=, NULL checks, OR, LIKE, IN, functions, and expressions, as well as best practices for temporary tables, cursors, and transaction size to improve database performance.

DatabaseIndexesPerformance tuning
0 likes · 10 min read
30 Essential SQL Query Optimization Techniques
MaGe Linux Operations
MaGe Linux Operations
May 19, 2026 · Databases

How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds

This article walks through a real‑world MySQL slow‑query case, showing how to identify the bottleneck with EXPLAIN, design covering and composite indexes, rewrite the SQL, tune InnoDB parameters, and safely deploy the changes, ultimately shrinking execution time from seconds to a few milliseconds.

EXPLAINOptimizationPerformance tuning
0 likes · 32 min read
How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds
Linux Tech Enthusiast
Linux Tech Enthusiast
May 14, 2026 · Operations

9 Visual Guides to Linux Performance Tuning Tools

The article presents nine diagrams that illustrate Linux performance tooling categories—including observability, static analysis, benchmarking, tuning, sar, perf-tools, tracing, and BPF tools—providing a quick visual reference for system engineers.

BPFLinuxObservability
0 likes · 2 min read
9 Visual Guides to Linux Performance Tuning Tools
Deepin Linux
Deepin Linux
May 13, 2026 · Fundamentals

Don’t Claim Linux Memory‑Tuning Skills Without Mastering Memory Compaction

This article explains Linux memory compaction—from its core principles and page‑migration mechanics to the different compaction strategies, trigger conditions, practical test cases, and optimization tips—showing how proper compaction resolves fragmentation, improves allocation success, and boosts overall system performance.

LinuxMemory CompactionMemory Fragmentation
0 likes · 47 min read
Don’t Claim Linux Memory‑Tuning Skills Without Mastering Memory Compaction
IT Services Circle
IT Services Circle
May 12, 2026 · Databases

How to Diagnose and Resolve Online Slow SQL That Causes CPU Spikes

When a MySQL‑driven application shows sudden CPU spikes, this guide walks through a step‑by‑step process—using top/htop, SHOW PROCESSLIST, enabling slow‑query logs, analyzing EXPLAIN output, killing offending queries, adding appropriate indexes, rewriting joins, and establishing preventive monitoring—to quickly identify and fix the root cause.

CPU SpikePerformance tuningSQL optimization
0 likes · 12 min read
How to Diagnose and Resolve Online Slow SQL That Causes CPU Spikes
Deepin Linux
Deepin Linux
May 12, 2026 · Backend Development

From Zero to One: Mastering Linux NAPI High‑Concurrency Packet Reception

This article explains why traditional interrupt‑driven network I/O stalls under high traffic, introduces the NAPI (New API) mechanism that combines interrupt wake‑up with batch polling, details its core data structures and scheduling functions, and provides step‑by‑step configuration and tuning guidance to achieve efficient, low‑latency packet processing on Linux servers.

LinuxNAPIPerformance tuning
0 likes · 35 min read
From Zero to One: Mastering Linux NAPI High‑Concurrency Packet Reception
Ops Community
Ops Community
May 11, 2026 · Operations

Production‑Grade Linux Disk I/O Tuning: From Theory to Hands‑On Practice

This comprehensive guide walks you through the fundamentals of Linux disk I/O performance, explains how to interpret key metrics such as IOPS, throughput and latency, and provides step‑by‑step instructions, scripts and configuration examples for diagnosing bottlenecks, optimizing filesystems, kernel parameters, application settings and storage layouts in production environments.

FilesystemLinuxMonitoring
0 likes · 60 min read
Production‑Grade Linux Disk I/O Tuning: From Theory to Hands‑On Practice
ITPUB
ITPUB
May 6, 2026 · Databases

The Hidden MySQL File That Grows on Its Own—Why 90% of DBAs Miss It

A sudden disk‑usage alarm reveals MySQL's ibtmp1 file ballooning to 192 GB, prompting a step‑by‑step investigation that explains the file’s purpose, shows how to clear and cap its size, and demonstrates how inefficient SQL queries can trigger such runaway growth.

Performance tuningSQL optimizationdisk space
0 likes · 8 min read
The Hidden MySQL File That Grows on Its Own—Why 90% of DBAs Miss It
Deepin Linux
Deepin Linux
May 5, 2026 · Fundamentals

Master Linux Memory Performance with HugePages

Linux’s default 4 KB pages cause massive page tables and TLB misses in high‑memory workloads; this article explains the HugePage mechanism, its types, how it reduces page‑table entries, improves TLB hit rates, lowers fragmentation, and provides step‑by‑step configuration for static and transparent huge pages in production.

LinuxMemory OptimizationPerformance tuning
0 likes · 39 min read
Master Linux Memory Performance with HugePages
Su San Talks Tech
Su San Talks Tech
May 3, 2026 · Databases

How to Speed Up a 10‑Table JOIN Query in MySQL (JD Interview Scenario)

When a production MySQL query joins ten tables and exceeds 30 seconds, a systematic approach—starting with EXPLAIN analysis, profiling, and configuration checks—combined with layered optimizations such as indexing, join order adjustment, query splitting, temporary tables, materialized views, OLAP engines, and vertical partitioning—can dramatically improve performance.

JoinOLAPPerformance tuning
0 likes · 17 min read
How to Speed Up a 10‑Table JOIN Query in MySQL (JD Interview Scenario)
Ops Community
Ops Community
May 2, 2026 · Databases

How to Completely Resolve MySQL CPU Spikes: Real‑World Fault Replay and Optimization Guide

This article walks you through a systematic, step‑by‑step process for diagnosing and fixing MySQL CPU usage spikes—from identifying the symptoms and gathering system metrics, to pinpointing problematic queries, analyzing locks and buffers, applying index and configuration tweaks, and validating the performance gains with real‑world examples and command‑line tools.

CPUDatabaseIndex Optimization
0 likes · 44 min read
How to Completely Resolve MySQL CPU Spikes: Real‑World Fault Replay and Optimization Guide
Shuge Unlimited
Shuge Unlimited
Apr 29, 2026 · Databases

Milvus Storage Tuning in Practice: 25× Query Speedup and Three Tricks to Cut Memory Usage by Half

This article walks through Milvus 2.3‑2.6.x storage optimizations—Mmap, tiered storage, and clustering compaction—explaining their principles, configuration hierarchy, benchmark results, and concrete deployment templates that together can boost query performance up to 25‑fold while halving memory consumption.

MilvusPerformance tuningStorage Optimization
0 likes · 24 min read
Milvus Storage Tuning in Practice: 25× Query Speedup and Three Tricks to Cut Memory Usage by Half
Java Backend Full-Stack
Java Backend Full-Stack
Apr 27, 2026 · Databases

Proven Redis Tuning Techniques for Production Environments

This article compiles practical, interview‑ready Redis tuning tips—from strict memory limits and eviction policies to avoiding big keys, hot keys, slow commands, and optimizing persistence, networking, and high‑availability settings—so you can confidently handle Redis performance questions in real‑world deployments.

Performance tuningRedisconfiguration
0 likes · 9 min read
Proven Redis Tuning Techniques for Production Environments
Deepin Linux
Deepin Linux
Apr 27, 2026 · Fundamentals

Understanding the SLUB Memory Allocator: A Deep Dive into Linux Kernel Object Management

SLUB, the default Linux kernel memory allocator, reduces fragmentation and improves allocation speed for frequently created objects like task_struct and inode by using per‑CPU caches, object slabs, and NUMA‑aware node caches, with detailed structures, allocation/free paths, tuning parameters, and real‑world case studies.

Linux kernelNUMAPerformance tuning
0 likes · 46 min read
Understanding the SLUB Memory Allocator: A Deep Dive into Linux Kernel Object Management
Java Backend Full-Stack
Java Backend Full-Stack
Apr 26, 2026 · Databases

Mastering Redis: Core Concepts, Practical Roadmap, and Advanced Techniques

This comprehensive guide outlines a step‑by‑step learning path for Redis, covering foundational commands, core data structures, high‑performance internals, persistence options, clustering, common caching pitfalls, performance tuning, monitoring, source‑code exploration, and recommended resources for becoming a Redis expert.

CachingClusterData Structures
0 likes · 9 min read
Mastering Redis: Core Concepts, Practical Roadmap, and Advanced Techniques
Raymond Ops
Raymond Ops
Apr 23, 2026 · Operations

Advanced Nginx Load Balancing: How to Choose and Tune Layer 4 vs Layer 7

This guide walks through the differences between 4‑layer (TCP) and 7‑layer (HTTP) load balancing in Nginx, explains when to use each, and provides step‑by‑step configuration examples, health‑check setups, performance tuning, SSL handling, WebSocket support, and common pitfalls.

Layer 4Layer 7Performance tuning
0 likes · 25 min read
Advanced Nginx Load Balancing: How to Choose and Tune Layer 4 vs Layer 7
MaGe Linux Operations
MaGe Linux Operations
Apr 23, 2026 · Databases

How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes

This guide walks through a systematic approach to identify, analyze, and fix MySQL slow queries by enabling the slow‑query log, interpreting its format, using tools like mysqldumpslow and pt‑query‑digest, examining execution plans with EXPLAIN, designing proper indexes, rewriting SQL, tuning server parameters, and establishing continuous monitoring to prevent regressions.

EXPLAINIndex OptimizationPerformance tuning
0 likes · 34 min read
How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes
Java Architect Handbook
Java Architect Handbook
Apr 23, 2026 · Interview Experience

Meituan Second Interview: Solving High RocketMQ Consumption Latency in Production

During a Meituan second-round interview, the candidate explains how to diagnose and resolve high RocketMQ consumption latency in production, outlining a three‑step approach—stop the bleeding, recover service, and cure the root cause—through consumer scaling, message forwarding, logic optimization, concurrency tuning, queue expansion, and monitoring.

Consumer LagInterview preparationJava
0 likes · 14 min read
Meituan Second Interview: Solving High RocketMQ Consumption Latency in Production
Ops Community
Ops Community
Apr 22, 2026 · Databases

Is MySQL CPU Spike a Database Issue or an Application Issue? Troubleshooting Guide

When MySQL CPU usage spikes above 80% or hits 100%, this guide walks you through a systematic investigation—from confirming the MySQL process consumes CPU, checking system and MySQL status, analyzing connection counts, slow queries, lock waits, and configuration settings, to applying short‑term mitigations and long‑term architectural fixes.

CPUDatabase operationsPerformance tuning
0 likes · 17 min read
Is MySQL CPU Spike a Database Issue or an Application Issue? Troubleshooting Guide
Architect's Guide
Architect's Guide
Apr 18, 2026 · Databases

How to Import 1 Billion Records into MySQL at Lightning Speed

This article analyzes the constraints of loading a billion 1‑KB log records from HDFS/S3 into MySQL, evaluates single‑table limits, proposes batch inserts, sharding, file‑reading techniques, task coordination with Redis, Redisson, and Zookeeper, and offers practical performance‑tuning recommendations.

Bulk InsertPerformance tuningRedis
0 likes · 21 min read
How to Import 1 Billion Records into MySQL at Lightning Speed
Architecture & Thinking
Architecture & Thinking
Apr 16, 2026 · Databases

Mastering Database Performance: From Slow Queries to Deadlock Resolution

This guide presents a systematic, end-to-end diagnostic workflow for high-concurrency database environments, covering slow-SQL detection, execution-plan analysis, lock-conflict monitoring, deadlock investigation, and practical optimization techniques, illustrated with real-world cases, commands, and tool integrations to swiftly resolve performance bottlenecks.

Database DiagnosticsLock MonitoringPerformance tuning
0 likes · 18 min read
Mastering Database Performance: From Slow Queries to Deadlock Resolution
Architect Chen
Architect Chen
Apr 13, 2026 · Backend Development

How to Make Spring Cloud Gateway Handle a Million Concurrent Requests

This article explains how Spring Cloud Gateway leverages a reactive, non‑blocking architecture, OS‑level tuning, zero‑copy networking, and built‑in rate‑limiting and circuit‑breaker features to reliably sustain million‑level concurrent traffic in production environments.

NettyPerformance tuningRate Limiting
0 likes · 4 min read
How to Make Spring Cloud Gateway Handle a Million Concurrent Requests
Big Data Tech Team
Big Data Tech Team
Apr 8, 2026 · Interview Experience

Master Spark Tuning for Data Warehouse Interviews: Real Cases & Tips

Learn how to demonstrate real Spark optimization skills in data‑warehouse interviews by exploring two detailed case studies—small‑file merging in ODS‑to‑DWD ETL and shuffle‑skew mitigation in DWS aggregation—plus key interview questions and practical troubleshooting steps that separate theory from hands‑on expertise.

Data WarehouseInterview TipsPerformance tuning
0 likes · 9 min read
Master Spark Tuning for Data Warehouse Interviews: Real Cases & Tips
MaGe Linux Operations
MaGe Linux Operations
Apr 5, 2026 · Databases

Master MySQL Slow Query Optimization: From Logs to Indexes

This comprehensive guide explains how to detect, analyze, and optimize MySQL slow queries by configuring the slow‑query log, using pt‑query‑digest, interpreting EXPLAIN output, designing effective B+Tree indexes, avoiding common index pitfalls, optimizing count(*) operations, improving deep pagination, rewriting inefficient SQL patterns, and applying advanced table design techniques such as partitioning and sharding.

EXPLAINPerformance tuningSQL
0 likes · 40 min read
Master MySQL Slow Query Optimization: From Logs to Indexes
dbaplus Community
dbaplus Community
Mar 29, 2026 · Databases

Why MySQL’s ibtmp1 Swells to 192 GB and How to Stop It

A sudden disk‑usage alarm reveals MySQL’s ibtmp1 temporary tablespace ballooning to 192 GB, and the article walks through why it happens, how to safely clear it, set size limits, and pinpoint the inefficient SQL that caused the explosion.

Performance tuningSQL optimizationdisk usage
0 likes · 7 min read
Why MySQL’s ibtmp1 Swells to 192 GB and How to Stop It
Advanced AI Application Practice
Advanced AI Application Practice
Mar 29, 2026 · Operations

Mastering OpenClaw Enterprise Deployment: From Setup to Operations (Practices 7‑14)

This guide walks through a real‑world 500‑person tech company’s OpenClaw rollout, detailing environment requirements, quick Windows/Linux installation, security hardening, multi‑system troubleshooting, Docker/K8s containerization, multi‑model routing, office‑tool integrations, automation scripts, RBAC, performance tuning, and high‑availability configuration, all achievable within 8‑10 hours.

DockerEnterprise DeploymentKubernetes
0 likes · 10 min read
Mastering OpenClaw Enterprise Deployment: From Setup to Operations (Practices 7‑14)
Ops Community
Ops Community
Mar 27, 2026 · Backend Development

Master Nginx Reverse Proxy on Ubuntu 24.04 & Rocky Linux 9.4 – From Installation to Monitoring

This comprehensive guide walks you through installing Nginx 1.27 on Ubuntu 24.04 LTS and Rocky Linux 9.4, configuring reverse proxy, load balancing, SSL/TLS, WebSocket and gRPC support, tuning kernel and Nginx parameters, setting up health checks, high‑availability with Keepalived, and monitoring with Prometheus and Grafana, all with ready‑to‑use code snippets and scripts.

MonitoringPerformance tuningSSL
0 likes · 59 min read
Master Nginx Reverse Proxy on Ubuntu 24.04 & Rocky Linux 9.4 – From Installation to Monitoring
Coder Trainee
Coder Trainee
Mar 21, 2026 · Fundamentals

Understanding JVM Basics for Effective Tuning

The article explains the JVM's core components, execution workflow, garbage collection fundamentals—including GC roots and Stop-The-World pauses—and introduces basic tuning tools like VisualVM and Arthas, helping readers grasp where performance optimizations should focus.

ArthasGarbage CollectionJVM
0 likes · 3 min read
Understanding JVM Basics for Effective Tuning
Deepin Linux
Deepin Linux
Mar 18, 2026 · Operations

Unlock Linux Secrets: Master the /proc Filesystem for Monitoring & Debugging

This article explains the Linux /proc virtual filesystem, detailing its structure, dynamic file generation, key system and process files, and how to use it for real‑time monitoring, performance tuning, kernel parameter tweaking, and troubleshooting, complete with practical command examples and a sample monitoring script.

Kernel ParametersLinuxPerformance tuning
0 likes · 26 min read
Unlock Linux Secrets: Master the /proc Filesystem for Monitoring & Debugging
Raymond Ops
Raymond Ops
Mar 17, 2026 · Operations

Boost Nginx Performance: 10‑Minute Guide to Reverse Proxy Timeout and Connection Pool Tuning

This step‑by‑step guide shows how to optimize Nginx reverse‑proxy timeouts and enable connection‑pool reuse on Linux servers, covering prerequisites, configuration changes, kernel tuning, load‑testing, monitoring with Prometheus, security hardening, troubleshooting, rollback procedures, and best‑practice recommendations.

Connection PoolMonitoringPerformance tuning
0 likes · 26 min read
Boost Nginx Performance: 10‑Minute Guide to Reverse Proxy Timeout and Connection Pool Tuning
Raymond Ops
Raymond Ops
Mar 16, 2026 · Operations

Master Linux Disk Management & I/O Performance: A Hands‑On Guide from Expansion to Tuning

This comprehensive guide walks you through Linux disk space shortage scenarios, prerequisites, a quick checklist, step‑by‑step LVM and partition expansion, I/O scheduler tuning, fio benchmarking, kernel parameter optimization, Prometheus monitoring, security hardening, backup strategies, troubleshooting, and best‑practice recommendations for reliable disk management and performance.

I/O performanceLVMLinux
0 likes · 29 min read
Master Linux Disk Management & I/O Performance: A Hands‑On Guide from Expansion to Tuning
MaGe Linux Operations
MaGe Linux Operations
Mar 14, 2026 · Operations

Mastering NFS: A Complete Guide to Setup, Troubleshooting, and Performance Optimization

This comprehensive guide explains NFS fundamentals, version differences, mounting procedures, common failure categories, core concepts like RPC and file handles, environment requirements, step‑by‑step installation and configuration, performance tuning parameters, real‑world case studies, monitoring, backup, and best‑practice recommendations for reliable NFS deployments.

LinuxNFSNetwork File System
0 likes · 49 min read
Mastering NFS: A Complete Guide to Setup, Troubleshooting, and Performance Optimization
JavaGuide
JavaGuide
Mar 9, 2026 · Databases

Does SELECT * Always Invalidate Indexes? Why Some Teams Ban It

While many believe that using SELECT * inevitably disables indexes, MySQL’s optimizer only skips indexes when a full table scan is cheaper, and patterns such as violating the left‑most prefix, applying functions or implicit casts, leading‑wildcard LIKE, OR/IN misuse, and mismatched ORDER BY can cause index invalidation, prompting some companies to forbid SELECT * in production.

DatabaseIndex OptimizationPerformance tuning
0 likes · 14 min read
Does SELECT * Always Invalidate Indexes? Why Some Teams Ban It
Ops Community
Ops Community
Mar 8, 2026 · Databases

How to Diagnose and Fix MySQL Production Performance Drops

This comprehensive guide walks you through identifying the root causes of MySQL performance degradation in production, from gathering baseline metrics and analyzing slow‑query logs to examining execution plans, tuning parameters, applying configuration changes, and verifying improvements with concrete monitoring and backup strategies.

Database OptimizationPerformance tuningbackup
0 likes · 30 min read
How to Diagnose and Fix MySQL Production Performance Drops
Raymond Ops
Raymond Ops
Mar 6, 2026 · Cloud Native

Scaling Kubernetes from 1k to 5k Nodes: Complete Performance Tuning Playbook

This article presents a comprehensive, real‑world guide for expanding a Kubernetes cluster from 1,000 to 5,000 nodes, covering control‑plane HA, etcd optimization, network and scheduler tuning, monitoring, and automation, with detailed configurations, code snippets, and a step‑by‑step case study of a large‑scale production environment.

CNIControl PlanePerformance tuning
0 likes · 22 min read
Scaling Kubernetes from 1k to 5k Nodes: Complete Performance Tuning Playbook
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Mar 6, 2026 · Backend Development

How to Tune Nginx for Million‑Level Concurrency: Practical Configurations

This guide explains how to configure Nginx and Linux kernel parameters to support up to a million concurrent connections, covering worker processes, connection limits, system file‑descriptor settings, caching strategies, static file handling, and key reverse‑proxy directives with concrete code examples.

CachingLinux kernelPerformance tuning
0 likes · 5 min read
How to Tune Nginx for Million‑Level Concurrency: Practical Configurations
Ops Community
Ops Community
Mar 3, 2026 · Databases

Master PostgreSQL 17: Installation, Backup, Recovery, and Performance Tuning

This comprehensive guide walks you through PostgreSQL 17 deployment, explains its multi‑process architecture and MVCC model, details environment requirements, shows essential configuration parameters, provides step‑by‑step backup and PITR procedures, demonstrates streaming replication setup, and shares best‑practice tuning, security, and monitoring tips for reliable production use.

Database AdministrationHAPerformance tuning
0 likes · 24 min read
Master PostgreSQL 17: Installation, Backup, Recovery, and Performance Tuning
DeWu Technology
DeWu Technology
Mar 2, 2026 · Big Data

Mastering Spark UI: Deep Dive into Metrics, Tuning, and Real‑World Cases

This article provides a comprehensive guide to Spark UI, explaining each primary and secondary tab, the key metrics they expose, and how to interpret them for performance bottleneck detection, followed by two detailed case studies and practical tuning recommendations for Spark workloads.

Big DataMetricsOptimization
0 likes · 19 min read
Mastering Spark UI: Deep Dive into Metrics, Tuning, and Real‑World Cases
Ops Community
Ops Community
Mar 2, 2026 · Backend Development

How to Supercharge Tomcat 11 on JDK 21: Real‑World JVM, Connection Pool, and Virtual Thread Tuning

This guide walks you through practical performance tuning of Tomcat 11 on JDK 21, covering JVM memory settings, GC selection, connector and thread‑pool optimization, virtual‑thread integration, benchmark scripts, security hardening, high‑availability deployment, and comprehensive monitoring and troubleshooting techniques.

DockerJDK21JVM
0 likes · 51 min read
How to Supercharge Tomcat 11 on JDK 21: Real‑World JVM, Connection Pool, and Virtual Thread Tuning
Architect Chen
Architect Chen
Feb 13, 2026 · Databases

Boost MySQL Performance: Proven Tuning, Indexing, and Scaling Strategies

This guide presents practical MySQL optimization techniques—including SQL and index refinement, InnoDB and connection parameter tuning, cache layer integration, and architectural scaling with read‑write splitting and sharding—to dramatically increase query throughput and reduce latency.

Index OptimizationInnoDBPerformance tuning
0 likes · 6 min read
Boost MySQL Performance: Proven Tuning, Indexing, and Scaling Strategies
Raymond Ops
Raymond Ops
Feb 11, 2026 · Databases

Mastering Redis Memory: From Basics to Advanced Troubleshooting

This comprehensive guide walks you through the real costs of Redis memory problems, explains the three‑layer memory architecture and five major consumers, provides a toolbox of INFO and MEMORY commands plus monitoring scripts, and offers step‑by‑step solutions for seven common issues, best‑practice optimizations, real‑world case studies, a daily checklist, and advanced techniques such as Lua scripts and smart cache warm‑up.

Performance tuningRedisbackend
0 likes · 26 min read
Mastering Redis Memory: From Basics to Advanced Troubleshooting
Code Wrench
Code Wrench
Feb 7, 2026 · Backend Development

How Go’s Netpoller Powers Millions of Connections – 5 Real‑World Cases

This article explains why Go programs often fail to reach C10M concurrency, analyzes five real‑world incidents, reveals the inner workings of Go's netpoller, and provides concrete code‑level optimizations, configuration tweaks, and load‑testing practices to achieve stable million‑connection services.

GoPerformance tuninghigh concurrency
0 likes · 23 min read
How Go’s Netpoller Powers Millions of Connections – 5 Real‑World Cases
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Feb 2, 2026 · Big Data

Real‑Time Analytics with Alibaba Cloud Serverless Spark & Paimon for Taobao Flash Sale

This article details how Alibaba Cloud EMR Serverless Spark combined with the Paimon lakehouse framework enables Taobao Flash Sale’s retail data team to achieve low‑latency, high‑throughput real‑time analytics, batch processing, and feature generation, outlining architecture evolution, performance gains, and practical Spark tuning techniques.

Big DataLakehousePaimon
0 likes · 18 min read
Real‑Time Analytics with Alibaba Cloud Serverless Spark & Paimon for Taobao Flash Sale
Su San Talks Tech
Su San Talks Tech
Jan 30, 2026 · Backend Development

Why Kafka Rebalance Causes Backlog, Duplicates, and Data Loss—and How to Fix It

Kafka consumer group rebalances can trigger message backlogs, duplicate processing, and data loss; this article explains common rebalance triggers, their impact on consumption, and practical configuration and coding strategies—such as tuning timeout parameters, using manual offset commits, and sticky partition assignment—to minimize disruptions.

Data lossKafkaMessage Duplication
0 likes · 12 min read
Why Kafka Rebalance Causes Backlog, Duplicates, and Data Loss—and How to Fix It
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jan 24, 2026 · Backend Development

10 Hidden Spring Boot 3 Settings to Supercharge Your Application Performance

This article reveals ten hidden Spring Boot 3 configuration tricks—from disabling the whitelabel error page and shrinking Tomcat threads to enabling HTTP/2, tuning HikariCP, caching static assets, and leveraging Actuator metrics—each illustrated with code snippets and practical steps to boost application performance.

Backend DevelopmentJavaOptimization
0 likes · 7 min read
10 Hidden Spring Boot 3 Settings to Supercharge Your Application Performance
Raymond Ops
Raymond Ops
Jan 23, 2026 · Cloud Native

How to Triple Kubernetes Performance: End‑to‑End Node‑to‑Pod Tuning Guide

This article walks through a systematic, bottom‑up performance tuning process for Kubernetes clusters—covering kernel parameters, container runtime, kubelet, scheduler, and pod resource settings—backed by a real‑world e‑commerce case study that reduced latency by over 80% and cut OOM events by 97.5%.

KubernetesNode OptimizationPerformance tuning
0 likes · 12 min read
How to Triple Kubernetes Performance: End‑to‑End Node‑to‑Pod Tuning Guide
StarRocks
StarRocks
Jan 22, 2026 · Big Data

How Paimon + StarRocks Accelerates Double‑11 OLAP Queries by 80% Refresh Speed

This article explains how Taotian Group unified real‑time and offline data using Paimon as lake storage and StarRocks for high‑performance OLAP, eliminating costly sync pipelines, cutting refresh time by about 80%, saving nearly ten million yuan annually, and detailing the architecture, cluster safeguards, configuration tweaks, monitoring, and future roadmap for large‑scale promotional events.

Big DataData ArchitectureOLAP
0 likes · 24 min read
How Paimon + StarRocks Accelerates Double‑11 OLAP Queries by 80% Refresh Speed
Ops Community
Ops Community
Jan 22, 2026 · Operations

Master HAProxy 3.0: From System Tuning to Advanced Load‑Balancing Practices

This comprehensive guide walks you through HAProxy 3.0’s new features, hardware and OS requirements, step‑by‑step installation, detailed global, frontend, backend configurations, health‑check optimization, monitoring with Prometheus, troubleshooting tips, backup strategies, and best‑practice recommendations for high‑performance load balancing in production environments.

HAProxyLinuxMonitoring
0 likes · 29 min read
Master HAProxy 3.0: From System Tuning to Advanced Load‑Balancing Practices
Architect's Guide
Architect's Guide
Jan 22, 2026 · Big Data

Unlock Kafka’s Power: Core Concepts, High‑Performance Architecture & Real‑World Scaling Tips

This comprehensive guide explores Kafka’s core value as a message queue, explains producers, consumers, topics, partitions, and replication, dives into cluster architecture, zero‑copy I/O, resource planning for disks, memory, CPU and network, and provides practical configuration, consumer‑group management, and operational tooling tips for building high‑throughput, highly available Kafka deployments.

Distributed SystemsKafkaMessage Queue
0 likes · 31 min read
Unlock Kafka’s Power: Core Concepts, High‑Performance Architecture & Real‑World Scaling Tips
MaGe Linux Operations
MaGe Linux Operations
Jan 12, 2026 · Backend Development

Master JVM Tuning on JDK 21: Reduce GC Pauses and Boost Throughput

This comprehensive guide walks you through diagnosing Full GC pauses on a Java 2020 production outage, explains JVM memory structures, compares JDK 21 garbage collectors, and provides step‑by‑step installation, configuration, and tuning instructions for Tomcat, monitoring tools, and real‑world case studies to achieve stable, high‑throughput services.

JDK21JVMLinux
0 likes · 33 min read
Master JVM Tuning on JDK 21: Reduce GC Pauses and Boost Throughput
Raymond Ops
Raymond Ops
Jan 9, 2026 · Databases

Master MongoDB Sharding: From Single Server to Enterprise-Scale Cluster

When a single‑node MongoDB instance can no longer handle tens of millions of records, this guide walks you through the theory, architecture, deployment steps, shard key strategies, performance tuning, monitoring, backup, and troubleshooting needed to build a robust, production‑grade sharded cluster.

MongoDBPerformance tuningSharding
0 likes · 14 min read
Master MongoDB Sharding: From Single Server to Enterprise-Scale Cluster
Raymond Ops
Raymond Ops
Jan 6, 2026 · Operations

How to Boost Nginx to Over 1 Million QPS: Real‑World Optimization Guide

This guide walks you through a complete Nginx high‑concurrency tuning process—from basic worker and TCP settings to kernel parameters, caching, SSL, and advanced techniques like DPDK and JIT—showing performance improvements from 80 k to over a million QPS with real‑world examples and scripts.

LinuxOptimizationPerformance tuning
0 likes · 13 min read
How to Boost Nginx to Over 1 Million QPS: Real‑World Optimization Guide
java1234
java1234
Jan 1, 2026 · Backend Development

Spring Task Scheduling in 3 Lines: Automate Jobs and Eliminate Repetitive Code

This guide explains how Spring Task turns Java applications into self‑managed schedulers, showing three quick steps to add the dependency, enable @EnableScheduling, and write @Scheduled methods, then dives into cron syntax, common use cases, pitfalls, performance tuning, and future enhancements.

Backend DevelopmentCron ExpressionJava
0 likes · 8 min read
Spring Task Scheduling in 3 Lines: Automate Jobs and Eliminate Repetitive Code
macrozheng
macrozheng
Dec 30, 2025 · Backend Development

Mastering Druid Connection Pool in Spring Boot: Advanced Optimization Guide

This comprehensive guide walks through preparing the environment, fine‑tuning core Druid pool parameters, building a robust monitoring system, strengthening security, detecting connection leaks, applying advanced runtime tweaks, and avoiding common pitfalls to achieve high performance and stability in production Spring Boot applications.

Connection PoolDruidMonitoring
0 likes · 12 min read
Mastering Druid Connection Pool in Spring Boot: Advanced Optimization Guide
MaGe Linux Operations
MaGe Linux Operations
Dec 27, 2025 · Artificial Intelligence

How to Deploy and Optimize Enterprise‑Scale LLM Inference Services: A Practical Guide

This guide walks you through deploying large language models such as ChatGLM and Llama in production, covering environment setup, model quantization, dynamic batching, service configuration, Nginx load balancing, monitoring, troubleshooting, and best‑practice recommendations for high‑performance, cost‑effective AI inference.

GPULLMPerformance tuning
0 likes · 48 min read
How to Deploy and Optimize Enterprise‑Scale LLM Inference Services: A Practical Guide
Raymond Ops
Raymond Ops
Dec 27, 2025 · Databases

How to Cut MySQL Master‑Slave Lag to 0.2 seconds with Parallel Binlog Replication

This guide explains how to reduce MySQL master‑slave replication delay from seconds to sub‑second levels by configuring LOGICAL_CLOCK parallelism, binlog group‑commit tuning, and slave‑side optimizations, presenting concrete parameter settings, performance test results, monitoring scripts, advanced tips, and common pitfalls.

Database OptimizationPerformance tuningmysql
0 likes · 7 min read
How to Cut MySQL Master‑Slave Lag to 0.2 seconds with Parallel Binlog Replication
DevOps Coach
DevOps Coach
Dec 26, 2025 · Databases

Achieving Sub‑Second Queries on 1.2 B‑Row PostgreSQL Using BRIN, pg_cron & Query Folding

The article recounts how a PostgreSQL instance on a modest 2‑CPU, 4 GB VM handling 1.2 billion rows was dramatically accelerated by adding BRIN indexes, scheduling maintenance with pg_cron, applying query folding and tuning memory and parallel settings, achieving sub‑second query times without additional hardware.

BRIN IndexPartitioningPerformance tuning
0 likes · 9 min read
Achieving Sub‑Second Queries on 1.2 B‑Row PostgreSQL Using BRIN, pg_cron & Query Folding
Java Web Project
Java Web Project
Dec 25, 2025 · Databases

How to Super‑Optimize Druid Connection Pool in Spring Boot for Production

This guide walks through preparing the environment, fine‑tuning core Druid parameters, managing connection lifecycles, building a monitoring stack, hardening security, detecting leaks, applying advanced runtime tweaks, and avoiding common pitfalls to achieve stable, high‑performance database pooling in Spring Boot.

Connection PoolDruidMonitoring
0 likes · 12 min read
How to Super‑Optimize Druid Connection Pool in Spring Boot for Production
Java Companion
Java Companion
Dec 25, 2025 · Backend Development

Druid Crashed in Production? How to Optimize the Spring Boot Connection Pool

The article explains why Druid can fail in a live Spring Boot service and provides a comprehensive, step‑by‑step optimization guide covering core pool parameters, monitoring setup, security hardening, leak detection, dynamic tuning, and best‑practice pitfalls to achieve stable, high‑performance database connections.

Connection PoolDruidJava
0 likes · 12 min read
Druid Crashed in Production? How to Optimize the Spring Boot Connection Pool
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Dec 25, 2025 · Backend Development

How to Resolve Kafka Backlog Under High Load: Practical Tips

This article explains why Kafka experiences message backlog in high‑load environments, identifies producer‑consumer speed mismatches, I/O and resource bottlenecks, and offers concrete strategies such as scaling consumers, tuning hardware, and adjusting Kafka configurations to eliminate the backlog.

BacklogDistributed SystemsKafka
0 likes · 4 min read
How to Resolve Kafka Backlog Under High Load: Practical Tips
Architecture Digest
Architecture Digest
Dec 24, 2025 · Databases

Mastering Druid: Extreme Performance and Security Tuning in Spring Boot

This guide walks through step‑by‑step how to prepare the environment, fine‑tune core Druid connection‑pool parameters, set up comprehensive monitoring, harden security, detect leaks, and apply advanced runtime optimizations to achieve stable, high‑throughput database access in Spring Boot applications.

Connection PoolDruidMonitoring
0 likes · 13 min read
Mastering Druid: Extreme Performance and Security Tuning in Spring Boot
Full-Stack DevOps & Kubernetes
Full-Stack DevOps & Kubernetes
Dec 17, 2025 · Databases

10 Essential Steps to Optimize Your Database for High‑Performance E‑Commerce

This article shares practical, step‑by‑step guidance from a 15‑year e‑commerce veteran on why, when, and how to optimize databases—including segregation, archiving, query tuning, replication lag detection, parameter tweaks, partitioning, ProxySQL, caching, vertical scaling, and monitoring—to achieve faster, more reliable services.

Database OptimizationPerformance tuningScaling
0 likes · 10 min read
10 Essential Steps to Optimize Your Database for High‑Performance E‑Commerce
dbaplus Community
dbaplus Community
Dec 16, 2025 · Databases

83 Proven SQL Optimization Techniques to Supercharge Your Database

This comprehensive guide presents 83 practical SQL optimization scenarios—from avoiding SELECT * and replacing IN with EXISTS to leveraging materialized views, partitioning, and advanced indexing—each illustrated with real‑world use cases and exact code snippets to help developers dramatically improve query performance and reduce resource consumption.

Database OptimizationIndexesPerformance tuning
0 likes · 55 min read
83 Proven SQL Optimization Techniques to Supercharge Your Database
Raymond Ops
Raymond Ops
Dec 16, 2025 · Operations

Boost Linux Performance 30-50%: Full CPU, Memory & Disk I/O Tuning Guide

This guide provides a systematic, multi‑layered approach to Linux performance optimization, covering CPU usage analysis, memory management, disk I/O tuning, kernel parameter tweaks, NUMA and container adjustments, with concrete commands, real‑world case studies, monitoring scripts, and actionable best‑practice checklists.

CPULinuxMemory
0 likes · 14 min read
Boost Linux Performance 30-50%: Full CPU, Memory & Disk I/O Tuning Guide
Senior Tony
Senior Tony
Dec 15, 2025 · Databases

Avoid the 5 Hidden MySQL Pitfalls That Can Kill Your Performance

This article reveals five common MySQL pitfalls—including uncontrolled InnoDB lock granularity, low default IOPS, misleading VARCHAR length handling, undersized InnoDB Buffer Pool, and a fragile Buffer Pool LRU algorithm—and offers practical configuration tips to prevent performance degradation.

Database OptimizationInnoDBPerformance tuning
0 likes · 6 min read
Avoid the 5 Hidden MySQL Pitfalls That Can Kill Your Performance
MaGe Linux Operations
MaGe Linux Operations
Dec 14, 2025 · Operations

Mastering Nginx Load Balancing: Choosing and Tuning Layer 4 vs Layer 7

This guide explains the differences between Layer 4 and Layer 7 load balancing in Nginx, shows how to select the appropriate mode for various scenarios, provides detailed configuration examples—including upstream settings, health checks, SSL handling, and performance tuning—and shares best‑practice tips to avoid common pitfalls.

Layer 4Layer 7Performance tuning
0 likes · 24 min read
Mastering Nginx Load Balancing: Choosing and Tuning Layer 4 vs Layer 7
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Dec 9, 2025 · Backend Development

Boost Kafka to Over 1 Million Messages per Second: Metrics and Tuning Tips

This article explains what high concurrency means for Kafka, outlines key performance metrics such as QPS, TPS, throughput and latency, and provides concrete configuration and architectural techniques—including broker optimization, horizontal scaling, network batching, and zero‑copy—to achieve write rates exceeding one million records per second.

Distributed SystemsKafkaPerformance tuning
0 likes · 4 min read
Boost Kafka to Over 1 Million Messages per Second: Metrics and Tuning Tips
IT Services Circle
IT Services Circle
Dec 9, 2025 · Backend Development

Mastering Kafka Rebalance: Prevent Backlog, Duplicates, and Data Loss

When Kafka consumer groups rebalance, partitions are reassigned, often causing message backlog, duplicate processing, or loss; understanding the triggers, impact, and optimization techniques—like tuning timeouts, managing offset commits, and using sticky assignors—can keep your streaming pipelines reliable.

Duplicate ConsumptionKafkaOffset Management
0 likes · 13 min read
Mastering Kafka Rebalance: Prevent Backlog, Duplicates, and Data Loss
Architect Chen
Architect Chen
Dec 8, 2025 · Backend Development

Boost Nginx Concurrency: Master the 4 Key Performance Parameters

This guide explains how to maximize Nginx concurrency by configuring four key parameters—worker_processes, worker_connections, keepalive_timeout, and keepalive_requests—plus three I/O optimizations (sendfile, tcp_nopush, tcp_nodelay), and discusses related OS tuning for real‑world performance in production.

I/O optimizationPerformance tuningbackend
0 likes · 4 min read
Boost Nginx Concurrency: Master the 4 Key Performance Parameters
Su San Talks Tech
Su San Talks Tech
Dec 5, 2025 · Backend Development

Unlocking Java ThreadPoolExecutor: Deep Dive, Best Practices, and Real‑World Tuning

This article provides a comprehensive exploration of Java's ThreadPoolExecutor, covering why thread pools are essential, how the executor framework is designed, detailed source‑code analysis of core classes, parameter tuning, rejection policies, monitoring techniques, and practical best‑practice recommendations for production systems.

Backend DevelopmentJavaPerformance tuning
0 likes · 32 min read
Unlocking Java ThreadPoolExecutor: Deep Dive, Best Practices, and Real‑World Tuning
Java Architect Handbook
Java Architect Handbook
Nov 30, 2025 · Databases

When Sharding Fails: Debugging Pagination Bugs and Optimizing MySQL for Massive Tables

The article recounts a real‑world case where a massive device table (over 500 million rows) suffered from sharding and Elasticsearch integration issues, describes a pagination bug caused by Sharding‑JDBC, and presents a comprehensive set of hardware, software, and SQL optimization techniques—including MySQL configuration examples—to improve performance.

Database OptimizationElasticsearchPerformance tuning
0 likes · 13 min read
When Sharding Fails: Debugging Pagination Bugs and Optimizing MySQL for Massive Tables
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Nov 24, 2025 · Backend Development

Mastering Easysearch CCR: A Hands‑On Guide to Auto‑Follow

This step‑by‑step tutorial shows how to set up two Easysearch clusters, configure Cross‑Cluster Replication (CCR), enable the Auto‑Follow feature, apply minimal‑privilege roles, tune performance parameters, and avoid common pitfalls, enabling seamless multi‑region data sync and zero‑downtime migrations.

AutoFollowCCRCluster Configuration
0 likes · 10 min read
Mastering Easysearch CCR: A Hands‑On Guide to Auto‑Follow
Tech Stroll Journey
Tech Stroll Journey
Nov 22, 2025 · Operations

How to Maximize Linux Disk I/O Performance: Practical Optimization Techniques

This article walks through a comprehensive set of Linux disk I/O optimizations—including hardware health checks, SSD adoption, RAID configuration, block‑device scheduler tuning, sector size alignment, filesystem selection, swap and huge‑page settings, kernel cache tweaks, third‑party caches, and application‑level strategies—to dramatically improve storage throughput and latency.

FilesystemI/O schedulerLinux
0 likes · 12 min read
How to Maximize Linux Disk I/O Performance: Practical Optimization Techniques
Ops Community
Ops Community
Nov 22, 2025 · Databases

Why Is Your SQL Slow? 7 Common MySQL Index Failure Scenarios Explained

This article examines why MySQL queries can become sluggish by analyzing seven typical situations where indexes become ineffective, provides step‑by‑step testing procedures, performance comparisons, troubleshooting tips, and best‑practice recommendations to restore optimal query performance.

Index OptimizationPerformance tuningSQL
0 likes · 37 min read
Why Is Your SQL Slow? 7 Common MySQL Index Failure Scenarios Explained
Ray's Galactic Tech
Ray's Galactic Tech
Nov 19, 2025 · Databases

Master InnoDB: Architecture, Indexes, Transactions & Performance Tuning

This comprehensive guide walks you through MySQL InnoDB's core architecture, storage structures, indexing mechanisms, transaction and concurrency control, crash recovery, backup options, and practical performance‑tuning techniques, providing clear explanations and real‑world SQL examples.

Database ArchitectureInnoDBMVCC
0 likes · 8 min read
Master InnoDB: Architecture, Indexes, Transactions & Performance Tuning
Raymond Ops
Raymond Ops
Nov 18, 2025 · Operations

How to Optimize Linux Server Performance: Monitoring, Tuning, and Resource Management

This guide explains how to identify performance bottlenecks on Linux servers and improve stability by adjusting kernel parameters, using monitoring tools like vmstat, mpstat, iostat, and sar, and applying resource‑limit techniques such as ulimit, PAM, and cgroups across CPU, memory, disk, and network subsystems.

LinuxOptimizationPerformance tuning
0 likes · 39 min read
How to Optimize Linux Server Performance: Monitoring, Tuning, and Resource Management
Liangxu Linux
Liangxu Linux
Nov 17, 2025 · Fundamentals

30 Proven C Optimization Tricks to Supercharge Embedded Code Performance

This article presents a comprehensive collection of low‑level C optimization techniques for embedded systems, covering algorithm selection, data type choices, arithmetic shortcuts, loop transformations, structure layout, function inlining, register usage, and many practical code examples to dramatically improve execution speed and reduce code size.

C ProgrammingCode OptimizationPerformance tuning
0 likes · 26 min read
30 Proven C Optimization Tricks to Supercharge Embedded Code Performance
Architect's Tech Stack
Architect's Tech Stack
Nov 14, 2025 · Databases

8 MySQL Optimizations to Slash Query Times from Seconds to Milliseconds

This article presents eight practical MySQL performance‑tuning techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting updates and deletes with JOIN, handling mixed ordering, replacing EXISTS with JOIN, pushing conditions down, early range reduction, and using WITH clauses—to transform slow queries into millisecond‑level executions.

IndexesPerformance tuningQuery Rewrite
0 likes · 14 min read
8 MySQL Optimizations to Slash Query Times from Seconds to Milliseconds
Xiao Liu Lab
Xiao Liu Lab
Nov 12, 2025 · Operations

Why TIME_WAIT Isn't a Problem and How to Optimize It

TIME_WAIT is a normal TCP state designed to prevent stray packets, but high volumes can indicate inefficient connection handling; this guide explains its mechanics, common causes, monitoring commands, and practical kernel and application-level tuning strategies to reduce TIME_WAIT buildup in high‑traffic services.

Connection PoolLinuxPerformance tuning
0 likes · 12 min read
Why TIME_WAIT Isn't a Problem and How to Optimize It
Tech Stroll Journey
Tech Stroll Journey
Nov 11, 2025 · Operations

Why Swap Stays Full on Linux and How to Release 29 GB Quickly

After noticing 14 GB free RAM but a fully used 29 GB swap, the article explains how to diagnose hidden swap consumption using tools like smem and swap_stat_show, clarifies the difference between free’s Swap used and /proc/*/status VmSwap, and shows how adjusting transparent_hugepage defrag and toggling swap can reclaim the space.

LinuxPerformance tuningSwap
0 likes · 10 min read
Why Swap Stays Full on Linux and How to Release 29 GB Quickly
Tech Stroll Journey
Tech Stroll Journey
Nov 8, 2025 · Fundamentals

Understanding Linux Filesystems and Disk I/O for Performance Tuning

This article explains Linux filesystem structures, the virtual filesystem layer, various disk I/O mechanisms—including buffered, non‑buffered, blocking, non‑blocking, synchronous and asynchronous I/O—and provides practical commands for observing inode and dentry caches to aid performance optimization.

FilesystemLinuxPerformance tuning
0 likes · 8 min read
Understanding Linux Filesystems and Disk I/O for Performance Tuning
MaGe Linux Operations
MaGe Linux Operations
Nov 6, 2025 · Databases

Boost MySQL InnoDB Performance 300%: Complete Buffer Pool Tuning Guide for 32GB‑256GB

This comprehensive guide walks you through MySQL InnoDB buffer pool optimization—from assessing current settings and calculating optimal sizes for 32 GB to 256 GB servers, to configuring instances, enabling pre‑warming, tuning dirty‑page flushing, monitoring key metrics, and troubleshooting common issues—to achieve up to a 300 % throughput increase in production environments.

Database OptimizationInnoDBPerformance tuning
0 likes · 33 min read
Boost MySQL InnoDB Performance 300%: Complete Buffer Pool Tuning Guide for 32GB‑256GB
Ops Community
Ops Community
Nov 3, 2025 · Operations

Master Linux Memory Management: Core Commands & Tuning in 10 Minutes

This comprehensive guide walks you through Linux memory management fundamentals, from prerequisite environments and a quick checklist to step‑by‑step installation of monitoring tools, memory diagnostics, kernel parameter adjustments, THP and swap optimization, NUMA affinity tuning, validation, Prometheus alerts, security hardening, troubleshooting, rollback procedures, best‑practice recommendations, and ready‑to‑use scripts and configuration snippets.

LinuxNUMAPerformance tuning
0 likes · 24 min read
Master Linux Memory Management: Core Commands & Tuning in 10 Minutes