BestHub
Sign in
Tagged articles

performance tuning

1102 articles · Page 6 of 12
ITPUB
ITPUB
Jul 12, 2023 · Databases

How We Migrated a Multi‑Petabyte Elasticsearch Cluster Across Data Centers Without Downtime

This article details the end‑to‑end process of moving Qunar's massive Elasticsearch logging cluster from a saturated data‑center to a new facility, covering background constraints, migration planning, manual and automated steps, performance‑tuning parameters, shard‑balancing techniques, and the final outcomes achieved.

Cluster MigrationElasticsearchdata center
0 likes · 21 min read
How We Migrated a Multi‑Petabyte Elasticsearch Cluster Across Data Centers Without Downtime
DeWu Technology
DeWu Technology
Jun 30, 2023 · Mobile Development

Optimizing Android CPU Frequency, Core Affinity, and Thread Priority

The article explains how to boost Android app performance by programmatically raising CPU frequency using Qualcomm’s BoostFramework, setting thread‑core affinity with native sched_setaffinity calls, and increasing execution priority via Process.setThreadPriority, providing Kotlin and C examples that demonstrate measurable speed gains.

AndroidCPU OptimizationKotlin
0 likes · 20 min read
Optimizing Android CPU Frequency, Core Affinity, and Thread Priority
Architects' Tech Alliance
Architects' Tech Alliance
Jun 28, 2023 · Operations

Master Linux Performance: 8 Essential Tuning Techniques & Tools

This guide outlines eight practical Linux performance‑tuning methods—including kernel parameter tweaks, filesystem and network optimizations, process priority adjustments, memory management, scheduler configuration, software bloat removal, and log cleanup—while showcasing key tools and visual diagrams for effective system optimization.

LinuxSystem Optimizationfilesystem
0 likes · 5 min read
Master Linux Performance: 8 Essential Tuning Techniques & Tools
MaGe Linux Operations
MaGe Linux Operations
Jun 26, 2023 · Operations

Master Linux Performance: Essential Tools & Commands for System Monitoring

This article compiles a comprehensive guide to Linux performance analysis, covering essential tools such as vmstat, iostat, dstat, top, htop, pidstat, strace, netstat, lsof, perf and sar, explaining their usage, output interpretation, and how they fit into a systematic performance tuning workflow.

Linuxperformance tuningsystem tools
0 likes · 16 min read
Master Linux Performance: Essential Tools & Commands for System Monitoring
Programmer DD
Programmer DD
Jun 26, 2023 · Databases

Unlock Lightning-Fast Search: Proven Elasticsearch Performance Tuning Tips

This article presents comprehensive best‑practice recommendations for optimizing Elasticsearch deployments, covering hardware selection, RAID choices, index and shard planning, query and caching strategies, bulk indexing, refresh intervals, monitoring tools, version upgrades, and lifecycle management to achieve high performance, reliability, and scalability.

ElasticsearchSearch Optimizationindexing
0 likes · 18 min read
Unlock Lightning-Fast Search: Proven Elasticsearch Performance Tuning Tips
Java Architect Essentials
Java Architect Essentials
Jun 21, 2023 · Fundamentals

How to Increase IntelliJ IDEA Memory Allocation to Eliminate Lag

This guide explains why IntelliJ IDEA often feels sluggish due to low default memory limits, shows how to view current memory usage, and provides step‑by‑step instructions—including editing VM options, adjusting -Xmx and -Xms values, and clearing caches—to boost performance for Java developers.

IDE optimizationIntelliJ IDEAJava development
0 likes · 5 min read
How to Increase IntelliJ IDEA Memory Allocation to Eliminate Lag
Su San Talks Tech
Su San Talks Tech
Jun 19, 2023 · Backend Development

Master JVM Performance: Memory Model, OOM Cases, and Tuning Tools

This article reviews the Java HotSpot memory model, explains when JVM tuning is needed, details common OutOfMemoryError scenarios with reproducible code, introduces built‑in monitoring utilities and third‑party tools, and provides practical tuning parameters and case studies for optimizing Java applications.

JVMJavaMonitoring Tools
0 likes · 24 min read
Master JVM Performance: Memory Model, OOM Cases, and Tuning Tools
WeiLi Technology Team
WeiLi Technology Team
Jun 2, 2023 · Big Data

Flink RocksDB State Backend: Practical Tuning Guide for Large Jobs

This article explains how to optimize Flink’s RocksDB state backend for large‑scale streaming jobs, covering state types, enabling latency tracking, incremental checkpoints, predefined options, and advanced memory and thread settings, with practical configuration examples and performance comparisons.

FlinkRocksDBState Backend
0 likes · 16 min read
Flink RocksDB State Backend: Practical Tuning Guide for Large Jobs
Code Ape Tech Column
Code Ape Tech Column
May 31, 2023 · Backend Development

Tomcat Performance Tuning Guide: Core Components and Key Parameters

This article explains Tomcat's component architecture, describes the three critical parameters (maxThreads, maxConnections, acceptCount) that affect request handling, and provides practical tuning recommendations to improve backend performance without additional hardware costs.

BackendConnectorJava
0 likes · 11 min read
Tomcat Performance Tuning Guide: Core Components and Key Parameters
Top Architect
Top Architect
May 15, 2023 · Backend Development

Comprehensive Guide to Kafka: Architecture, Performance Tuning, and Operational Practices

This article provides an in-depth overview of Kafka, covering its core value as a message queue, fundamental concepts, cluster architecture, producer and consumer configurations, scaling strategies, monitoring tools, and practical operational commands for building and maintaining high‑throughput, highly available streaming systems.

BackendKafkaProducer Configuration
0 likes · 31 min read
Comprehensive Guide to Kafka: Architecture, Performance Tuning, and Operational Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
May 15, 2023 · Databases

Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques

The article investigates why pure‑read QPS drops significantly after bulk updates in OceanBase, reproduces the issue with a sysbench workload, analyses flame‑graph and SQL audit data, explains the LSM‑Tree read‑amplification mechanism, and proposes practical mitigation steps such as major freeze, plan binding, index creation, and the queuing‑table feature.

LSM TreeMajor FreezeOceanBase
0 likes · 16 min read
Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques
MaGe Linux Operations
MaGe Linux Operations
May 5, 2023 · Operations

Boost Your NGINX Performance: 8 Proven Tuning Tips

This guide explains how to optimize NGINX on Linux by adjusting worker processes, connection limits, GZIP compression, timeout values, buffer sizes, log handling, static content caching, and open file caching, providing step‑by‑step commands and configuration snippets for maximum server efficiency.

ConfigurationLinuxNginx
0 likes · 8 min read
Boost Your NGINX Performance: 8 Proven Tuning Tips
dbaplus Community
dbaplus Community
May 2, 2023 · Databases

How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained

This article explains why MySQL slave lag is a critical issue, compares the official parallel replication schemes—including Commit‑Parent‑Based, Lock‑Based, and WRITESET—details their internal mechanisms, presents benchmark results, and provides the exact configuration parameters needed to enable high‑performance parallel replication.

Group CommitMySQLParallel Replication
0 likes · 17 min read
How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained
Liangxu Linux
Liangxu Linux
Apr 26, 2023 · Operations

Essential Linux Ops Practices to Prevent Disasters

Drawing from years of sysadmin experience, this guide lists concrete Linux operational habits—such as rigorous backups, cautious use of rm‑rf, single‑person changes, SSH hardening, firewall rules, monitoring, and disciplined performance tuning—to help teams avoid costly production failures.

Linuxmonitoringperformance tuning
0 likes · 12 min read
Essential Linux Ops Practices to Prevent Disasters
ITPUB
ITPUB
Apr 24, 2023 · Databases

Master PostgreSQL Performance: From Hardware to Query Tuning

Effective PostgreSQL performance tuning requires a holistic approach, covering hardware sizing, OS sysctl tweaks, filesystem choices, query and schema design, key PostgreSQL parameters, concurrency settings, cache management, and careful scheduling of automated maintenance tasks to avoid resource conflicts.

OS ConfigurationPostgreSQLSQL
0 likes · 10 min read
Master PostgreSQL Performance: From Hardware to Query Tuning
Architecture Digest
Architecture Digest
Apr 23, 2023 · Backend Development

Kafka Core Concepts, Architecture, Performance Optimizations, and Production Deployment Guide

This article provides a comprehensive technical overview of Kafka, covering its core message‑queue value, architecture components such as producers, consumers, topics, partitions and replication, high‑performance mechanisms like zero‑copy and OS cache, resource planning for disks, memory, CPU and network, operational tools and commands, consumer‑group management, rebalance strategies, and internal scheduling mechanisms such as the time‑wheel.

KafkaReplicationbackend architecture
0 likes · 30 min read
Kafka Core Concepts, Architecture, Performance Optimizations, and Production Deployment Guide
JD Tech
JD Tech
Apr 18, 2023 · Backend Development

Case Study: Long GC Times Caused by Database Connection Pool Issues and Mitigation Strategies

This article analyzes a production incident where excessive Full GC pauses during a high‑traffic promotion were traced to stale database connections in the DBCP pool, explains the investigation steps, root cause, and presents several JVM and connection‑pool configuration solutions to prevent similar performance degradations.

Database Connection PoolGCJVM
0 likes · 8 min read
Case Study: Long GC Times Caused by Database Connection Pool Issues and Mitigation Strategies
Liangxu Linux
Liangxu Linux
Apr 11, 2023 · Operations

Master Linux Performance Tuning: Practical Steps for Faster Systems

This guide explains why Linux performance depends on both hardware and software, outlines key factors such as CPU, memory, disk I/O, network, OS installation, kernel parameters, file systems, and application design, and provides a step‑by‑step process for administrators, architects, and developers to diagnose and optimize system speed.

HardwareLinuxOptimization
0 likes · 16 min read
Master Linux Performance Tuning: Practical Steps for Faster Systems
Selected Java Interview Questions
Selected Java Interview Questions
Mar 29, 2023 · Backend Development

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

This article presents a comprehensive, step‑by‑step guide on estimating capacity, selecting and configuring garbage collectors, sizing heap, young and survivor spaces, tuning thread stacks, and adding diagnostic options for a Java service that must handle one million login requests per day on a server with 8 GB of memory.

CMSG1JVM
0 likes · 26 min read
JVM Parameter Tuning for a Platform Handling 1 Million Daily Login Requests on an 8 GB Node
Top Architect
Top Architect
Mar 27, 2023 · Big Data

Kafka Architecture, Performance Optimization, and Production Deployment Guide

This article provides a comprehensive overview of Kafka’s core concepts, high‑performance design, cluster planning, resource evaluation, deployment steps, producer and consumer configurations, fault‑tolerance mechanisms, and operational tools, offering practical guidance for building and managing a high‑throughput Kafka production environment.

Cluster DeploymentConsumerJava
0 likes · 31 min read
Kafka Architecture, Performance Optimization, and Production Deployment Guide
Java Backend Technology
Java Backend Technology
Mar 24, 2023 · Backend Development

Optimizing JVM Settings for 1M Daily Logins on an 8GB Server

This article walks through a step‑by‑step approach to sizing JVM heap, young generation, GC selection, and related parameters for a platform handling one million login requests per day on a node with 8 GB memory, providing practical formulas, example configurations, and tuning tips.

JVMJavagarbage collection
0 likes · 24 min read
Optimizing JVM Settings for 1M Daily Logins on an 8GB Server
Architect
Architect
Mar 18, 2023 · Backend Development

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

This article explains a step‑by‑step methodology for estimating capacity, selecting appropriate garbage collectors, sizing JVM memory regions, and tuning advanced parameters such as survivor ratio, tenuring threshold, and Metaspace to reliably support a login service that processes one million requests per day on a machine with 8 GB of RAM.

BackendJVMJava
0 likes · 25 min read
How to Configure JVM Parameters for a Platform Handling 1 Million Daily Login Requests on an 8 GB Server
Code Ape Tech Column
Code Ape Tech Column
Mar 13, 2023 · Backend Development

Diagnosing and Resolving 900% CPU Spikes in MySQL and Java Processes

This article explains common scenarios that cause CPU usage to soar above 200% in production, outlines step‑by‑step diagnosis and remediation for MySQL and Java processes, and shares real‑world case studies with command‑line tools, indexing, caching, and code adjustments to bring CPU load back to normal levels.

CPUJavaMySQL
0 likes · 11 min read
Diagnosing and Resolving 900% CPU Spikes in MySQL and Java Processes
ITPUB
ITPUB
Mar 12, 2023 · Databases

Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost

This article walks through a practical SQL optimization workflow, showing how to detect problematic queries via system metrics and execution plans, analyze table structures and indexes, apply concrete ALTER statements and index changes, and iteratively verify performance improvements, illustrated with a detailed MySQL case study that achieved a twenty‑fold speed increase.

Index OptimizationMySQLSQL
0 likes · 10 min read
Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost
Top Architect
Top Architect
Mar 8, 2023 · Backend Development

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

This article walks through a systematic approach to sizing and configuring JVM parameters—including heap, young generation, GC algorithm, Metaspace, and safety‑point settings—for a high‑traffic login service that receives one million requests per day on a server with 8 GB of memory, providing both practical code examples and interview‑style explanations.

BackendJVMJava
0 likes · 25 min read
JVM Parameter Tuning for a Service Handling 10 Million Daily Login Requests on an 8 GB Node
Selected Java Interview Questions
Selected Java Interview Questions
Mar 5, 2023 · Backend Development

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

This article walks through a systematic approach to sizing and configuring JVM memory and garbage‑collector parameters for a service handling one million login requests per day on an 8 GB server, covering capacity planning, GC selection, heap region sizing, thread‑stack settings, dynamic age thresholds, large‑object handling, and diagnostic options such as heap dumps and GC logging.

JVMJavagarbage collection
0 likes · 23 min read
JVM Parameter Tuning for a Platform with 1 Million Daily Login Requests on an 8 GB Node
Architect's Guide
Architect's Guide
Feb 25, 2023 · Big Data

Elasticsearch Optimization and Performance Tuning for Billion‑Scale Data

This article documents the evolution of a data platform, explains Elasticsearch and Lucene fundamentals, and presents practical index and search performance optimizations—including bulk writes, refresh control, memory allocation, doc‑values tuning, and pagination strategies—that enable cross‑month queries and sub‑second responses on billions of records.

ElasticsearchLuceneperformance tuning
0 likes · 11 min read
Elasticsearch Optimization and Performance Tuning for Billion‑Scale Data
dbaplus Community
dbaplus Community
Feb 19, 2023 · Databases

Essential MySQL Optimization Checklist: 46 Proven Practices to Boost Performance

This comprehensive guide outlines 46 practical MySQL optimization rules—from understanding the query execution flow and naming conventions to index design, join strategies, pagination techniques, and safe use of data types—providing concrete examples and code snippets that help developers dramatically improve database performance and reliability.

Database IndexingMySQLSQL optimization
0 likes · 26 min read
Essential MySQL Optimization Checklist: 46 Proven Practices to Boost Performance
dbaplus Community
dbaplus Community
Feb 14, 2023 · Databases

10 Common PostgreSQL Mistakes and How to Avoid Them

This article outlines the ten most frequent PostgreSQL pitfalls—from default configurations and poor schema design to inadequate backups and mismanaged extensions—providing concrete SQL queries, tuning tools, and best‑practice recommendations to help DBAs detect, diagnose, and prevent each issue before it harms production workloads.

PostgreSQLbackupconnection pooling
0 likes · 16 min read
10 Common PostgreSQL Mistakes and How to Avoid Them
Efficient Ops
Efficient Ops
Jan 29, 2023 · Operations

How Linux Kernel Handles TCP Connections: Deep Dive into sock_common and Lookup

This article explores Linux kernel TCP connection handling by examining socket data structures, port range and file descriptor tuning, core functions like tcp_v4_rcv, and lookup mechanisms, while offering practical tips to boost client-side concurrent connections beyond traditional limits.

Linux kernelNetworkingOperations
0 likes · 9 min read
How Linux Kernel Handles TCP Connections: Deep Dive into sock_common and Lookup
Liangxu Linux
Liangxu Linux
Jan 15, 2023 · Operations

Boost Your NGINX Performance: 8 Proven Configuration Tweaks

This guide walks you through eight essential NGINX configuration adjustments—including worker processes, connection limits, GZIP compression, timeout values, buffer sizes, logging, static content caching, and open file caching—to maximize web server performance on Linux systems.

Linuxperformance tuningserver optimization
0 likes · 8 min read
Boost Your NGINX Performance: 8 Proven Configuration Tweaks
MaGe Linux Operations
MaGe Linux Operations
Jan 15, 2023 · Backend Development

Cut Nginx HTTPS Latency by 30%: Practical TLS Tuning Guide

This article explains why low‑latency Nginx HTTPS is crucial for instant search, breaks down TLS handshake round‑trips, and provides step‑by‑step configuration changes—such as enabling HTTP/2, adjusting ciphers, activating OCSP stapling, tweaking buffer sizes and session cache—to achieve roughly a 30% reduction in request latency.

HTTP/2HTTPS latencyOCSP stapling
0 likes · 12 min read
Cut Nginx HTTPS Latency by 30%: Practical TLS Tuning Guide
Baidu Geek Talk
Baidu Geek Talk
Jan 5, 2023 · Artificial Intelligence

How Baidu’s AIAK‑Inference Supercharges AI Model Inference on GPUs

This article provides an end‑to‑end analysis of AI inference bottlenecks, reviews common industry acceleration techniques, and details Baidu Intelligent Cloud’s AIAK‑Inference suite—including its architecture, optimization strategies such as model pruning, operator fusion, and single‑operator tuning—followed by a demo showing significant latency reductions on ResNet‑50 and other models.

AI inferenceAIAK-InferenceBaidu Cloud
0 likes · 16 min read
How Baidu’s AIAK‑Inference Supercharges AI Model Inference on GPUs
Architect's Tech Stack
Architect's Tech Stack
Dec 30, 2022 · Big Data

Distributed Computing Is Not a Panacea for Big Data: Prioritize Single‑Node Performance First

While distributed clusters are popular for big‑data processing, they are not a universal solution; tasks that are hard to partition or involve heavy cross‑node communication often perform better on a well‑optimized single machine, making a careful analysis of workload characteristics essential before scaling out.

Distributed ComputingSPLalgorithm optimization
0 likes · 14 min read
Distributed Computing Is Not a Panacea for Big Data: Prioritize Single‑Node Performance First
dbaplus Community
dbaplus Community
Dec 13, 2022 · Big Data

How ClickHouse Powers Real-Time Self-Service Analytics at Scale

Facing massive daily data volumes and complex, ad‑hoc analytical needs, Zhaozhuan’s engineering team evaluated multiple OLAP engines and chose ClickHouse, then built a four‑layer self‑service analytics platform, detailing architecture, use‑cases, performance tuning, large‑scale joins, and future roadmap challenges.

ClickHouseOLAPSelf‑service analytics
0 likes · 14 min read
How ClickHouse Powers Real-Time Self-Service Analytics at Scale
Open Source Linux
Open Source Linux
Dec 13, 2022 · Databases

Boost MySQL Performance: 20 Proven SQL Optimization Techniques

This article presents a comprehensive collection of MySQL optimization tips, covering everything from avoiding SELECT * and OR conditions to proper use of indexes, joins, UNION, batch operations, and query planning, each illustrated with clear examples and practical reasons for better performance.

MySQLperformance tuningquery best practices
0 likes · 19 min read
Boost MySQL Performance: 20 Proven SQL Optimization Techniques
ITPUB
ITPUB
Dec 10, 2022 · Big Data

How ClickHouse Powers Real-Time Self-Service Analytics at Scale

This article examines why ClickHouse was chosen as the OLAP engine for a massive self‑service analytics platform, describes the system architecture, shares concrete memory and performance tuning parameters, and outlines current challenges and future roadmap for large‑scale real‑time data analysis.

ClickHouseOLAPSelf‑service analytics
0 likes · 14 min read
How ClickHouse Powers Real-Time Self-Service Analytics at Scale
Full-Stack DevOps & Kubernetes
Full-Stack DevOps & Kubernetes
Dec 7, 2022 · Cloud Native

How to Scale Kubernetes to 5,000 Nodes: Master, API Server, and Component Tuning

This guide explains how to push a Kubernetes cluster toward its theoretical limit of 5,000 nodes by detailing official limits, master node sizing for GCE and AWS, kube‑apiserver high‑availability and connection‑count tuning, scheduler and controller‑manager leader election settings, kubelet optimizations, and DNS anti‑affinity configuration.

Cloud NativeKubernetesOperations
0 likes · 6 min read
How to Scale Kubernetes to 5,000 Nodes: Master, API Server, and Component Tuning
Youzan Coder
Youzan Coder
Nov 28, 2022 · Backend Development

How Switching from CMS to G1 Boosted Java Service Stability and Cut Costs

The article details how a Java team diagnosed frequent Full GC pauses caused by CMS, migrated to G1GC, adjusted JVM flags, scaled container specs, and achieved dramatically lower pause times, reduced instance counts, and significant cost savings while improving overall service stability.

BackendCMSG1GC
0 likes · 13 min read
How Switching from CMS to G1 Boosted Java Service Stability and Cut Costs
Tencent Cloud Developer
Tencent Cloud Developer
Nov 24, 2022 · Backend Development

Kafka Stability Best Practices: Prevention, Monitoring, and Fault Resolution

This guide outlines Kafka stability best practices across three phases—pre‑prevention with tuning, producer/consumer guidelines, and cluster configuration; runtime monitoring using white‑box and black‑box metrics and alerts; and fault resolution strategies for backlogs, consumption blocks, and message loss, plus cost control and idempotence techniques.

Backend DevelopmentDistributed MessagingKafka
0 likes · 29 min read
Kafka Stability Best Practices: Prevention, Monitoring, and Fault Resolution
DataFunTalk
DataFunTalk
Nov 14, 2022 · Databases

Performance Optimization and Tuning of Apache Doris Vectorized Version for Xiaomi's A/B Experiment Platform

Xiaomi upgraded its Apache Doris from version 0.13 to the vectorized 1.1.2 release for its A/B experiment platform, conducting extensive single‑SQL and concurrent tests, identifying CPU, memory, and fragment timeout issues, and applying tuning such as memory decommit settings, string matching improvements, and patches to achieve up to 5× query speed gains and enhanced stability.

Apache Dorisdatabase optimizationperformance tuning
0 likes · 20 min read
Performance Optimization and Tuning of Apache Doris Vectorized Version for Xiaomi's A/B Experiment Platform
Selected Java Interview Questions
Selected Java Interview Questions
Nov 12, 2022 · Databases

MySQL Large‑Table Index Optimization and Maintenance Strategies

This article analyzes performance problems of a massive MySQL table, demonstrates how to use pt‑query‑digest and EXPLAIN to identify inefficient composite indexes, proposes index redesign, compares online DDL with pt‑osc for index rebuilding, and presents batch‑delete techniques to reduce SLA‑impacting latency.

Batch DeleteDDLIndex Optimization
0 likes · 14 min read
MySQL Large‑Table Index Optimization and Maintenance Strategies
Meituan Technology Team
Meituan Technology Team
Nov 10, 2022 · Big Data

Optimizing Spark mapPartitions: Memory Management and Best Practices

The article details how Meituan’s Turing machine‑learning platform cut offline resource use by 80% and task time by 63% through memory‑level techniques such as column pruning, adaptive caching, and a deep dive into Spark’s mapPartitions operator, including source‑code analysis, GC behavior, and a low‑memory batch‑iterator best practice.

Memory OptimizationSparkbig data
0 likes · 19 min read
Optimizing Spark mapPartitions: Memory Management and Best Practices
Data Thinking Notes
Data Thinking Notes
Oct 27, 2022 · Big Data

Boost Spark Performance: Proven Code Optimizations & Tuning Tips

This article outlines practical Spark job optimization techniques—from code-level improvements and resource tuning to data skew handling, persistence strategies, shuffle reduction, broadcast variables, Kryo serialization, and efficient data structures—demonstrating how each can dramatically cut execution time.

Kryo SerializationRDD PersistenceShuffle Optimization
0 likes · 19 min read
Boost Spark Performance: Proven Code Optimizations & Tuning Tips
Tuanzi Tech Team
Tuanzi Tech Team
Oct 26, 2022 · Backend Development

Master JVM Performance: Memory Structures, Tuning Parameters, and Monitoring Tips

Explore comprehensive JVM performance optimization, covering memory architecture, key tuning flags, garbage collector selection, common OOM scenarios, and essential monitoring tools such as jstack, jstat, JConsole, and VisualVM, with practical examples and code snippets to help you diagnose and resolve memory issues.

JVMJavagarbage collection
0 likes · 20 min read
Master JVM Performance: Memory Structures, Tuning Parameters, and Monitoring Tips
Top Architect
Top Architect
Oct 25, 2022 · Databases

Understanding Database Indexes: Storage Principles, Binary Search, and Optimization Techniques

This article explains how databases store data on various storage media, why indexes dramatically speed up queries through sorted structures and binary search, discusses different index types such as clustered indexes, and outlines common SQL optimization practices while warning against excessive indexing and typical pitfalls.

SQL optimizationbinary searchclustered index
0 likes · 12 min read
Understanding Database Indexes: Storage Principles, Binary Search, and Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 18, 2022 · Databases

Why MySQL Remains Popular and Its Logical Architecture

The article explains MySQL's continued dominance in the database market, presents recent developer survey statistics, describes its three‑layer logical architecture, and introduces the new edition of the "High Performance MySQL" book as a guide for modern database professionals.

Developer SurveyMySQLdatabase architecture
0 likes · 7 min read
Why MySQL Remains Popular and Its Logical Architecture
Liangxu Linux
Liangxu Linux
Oct 10, 2022 · Operations

Essential Linux Ops: 10 Hard‑Earned Rules for Safe Server Management

This article shares practical Linux operations guidelines—including thorough testing, cautious use of destructive commands, strict backup policies, security hardening, continuous monitoring, performance tuning, and a disciplined mindset—to help avoid costly incidents and maintain stable production environments.

Linuxperformance tuningsecurity
0 likes · 11 min read
Essential Linux Ops: 10 Hard‑Earned Rules for Safe Server Management
Java High-Performance Architecture
Java High-Performance Architecture
Oct 5, 2022 · Databases

How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion Strategies

This article analyzes a large MySQL table with frequent SLA alerts, demonstrates how to identify slow queries using pt‑query‑digest, proposes index redesign and online DDL versus pt‑osc methods, and shows testing, implementation, and batch‑delete techniques to dramatically reduce query time and maintenance overhead.

Batch DeletionDatabase MaintenanceIndex Optimization
0 likes · 17 min read
How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion Strategies
Java Backend Technology
Java Backend Technology
Sep 27, 2022 · Databases

Optimizing Massive MySQL Tables: Index Tuning, Online DDL & Batch Deletion

Facing SLA alerts due to slow queries on a billion‑row MySQL table, the article analyzes slow‑query logs, reveals index misuse, and demonstrates how removing a poor composite index, adding targeted indexes, employing online DDL or pt‑osc, and using batch deletions dramatically reduce query times and maintenance overhead.

Batch DeletionMySQLOnline DDL
0 likes · 16 min read
Optimizing Massive MySQL Tables: Index Tuning, Online DDL & Batch Deletion
Cloud Native Technology Community
Cloud Native Technology Community
Sep 23, 2022 · Cloud Native

What Cloud‑Native Networking Trends Kube‑OVN Reveals and How DeepFlow Enables Full‑Stack Observability

In this technical session, experts from Lingque Cloud and Yunshan Network discuss emerging cloud‑native networking trends through Kube‑OVN, demonstrate DeepFlow's full‑stack observability in Kube‑OVN environments, and answer a wide range of practical Q&A covering IP stability, underlay challenges, CNI support, and performance tuning.

CNICloud Native NetworkingDeepFlow
0 likes · 14 min read
What Cloud‑Native Networking Trends Kube‑OVN Reveals and How DeepFlow Enables Full‑Stack Observability
dbaplus Community
dbaplus Community
Sep 22, 2022 · Databases

Why MySQL IN Subqueries Turn Into Slow Full Scans—and How to Fix Them

A large‑scale user‑push system suffers from minutes‑long MySQL queries because the IN subquery materializes a temporary table and triggers a semi‑join that forces full table scans, but disabling the semi‑join optimizer or rewriting the query restores sub‑second performance.

MySQLSQL optimizationSemi-Join
0 likes · 8 min read
Why MySQL IN Subqueries Turn Into Slow Full Scans—and How to Fix Them
Code Ape Tech Column
Code Ape Tech Column
Sep 21, 2022 · Backend Development

Investigating Excessive Native Memory Usage in a Spring Boot Application Migrated to MDP Framework

After migrating a project to the MDP framework based on Spring Boot, the system repeatedly reported high swap usage despite a 4 GB heap configuration, leading to an investigation that uncovered native memory consumption caused by unchecked JAR scanning and allocator behavior, which was resolved by limiting scan paths and updating Spring Boot's inflater implementation.

JVMNative MemorySpring Boot
0 likes · 12 min read
Investigating Excessive Native Memory Usage in a Spring Boot Application Migrated to MDP Framework
ITPUB
ITPUB
Sep 18, 2022 · Databases

Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM

This article explains how Redis stores key‑value pairs, details the internal data structures such as dict, dictEntry and redisObject, and provides practical memory‑saving tricks—including key shortening, encoding choices, object sharing, bitmap usage, hash consolidation, fragmentation handling, and 32‑bit deployment—to dramatically reduce RAM consumption while maintaining performance.

Data StructuresMemory OptimizationRedis
0 likes · 19 min read
Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM
ITPUB
ITPUB
Sep 8, 2022 · Databases

Master MySQL Performance: 5 Key Optimization Strategies You Must Know

This guide explores five essential dimensions of MySQL performance tuning—including connection configuration, architectural choices such as caching and read‑write splitting, optimizer settings, storage engine selection, and schema design—providing concrete commands, formulas, and best‑practice recommendations to accelerate query execution and reduce load.

MySQLQuery Optimizationdatabase architecture
0 likes · 20 min read
Master MySQL Performance: 5 Key Optimization Strategies You Must Know
Code Ape Tech Column
Code Ape Tech Column
Sep 8, 2022 · Backend Development

Tomcat Performance Tuning: Core Components and Key Parameters

This article explains Tomcat's component architecture, describes the request‑processing flow, and provides practical guidance on tuning the three critical parameters—maxThreads, maxConnections, and acceptCount—along with additional settings to improve backend service performance without additional hardware.

BackendJavaServer configuration
0 likes · 11 min read
Tomcat Performance Tuning: Core Components and Key Parameters
JD Tech
JD Tech
Sep 6, 2022 · Big Data

Flink Streaming Job Tuning Guide: Memory Model, Network Stack, RocksDB, and More

This article presents a detailed guide for optimizing large‑scale Apache Flink streaming jobs on the JD Real‑Time Computing platform, covering TaskManager memory model tuning, network stack configuration, RocksDB state management, checkpoint strategies, and additional performance tips with practical examples and calculations.

Apache FlinkCheckpointRocksDB
0 likes · 22 min read
Flink Streaming Job Tuning Guide: Memory Model, Network Stack, RocksDB, and More
Cloud Native Technology Community
Cloud Native Technology Community
Sep 1, 2022 · Cloud Native

How to Supercharge Kube-OVN Performance: Benchmarks and Tuning Guide

This guide presents Kube-OVN performance benchmarks, explains the testing environment and qperf commands, and provides step‑by‑step data‑plane optimization techniques—including CPU mode, NIC queue tuning, tuned profiles, interrupt binding, OVN LB disabling, FastPath module, OVS kernel compilation, and STT tunnel activation—to help administrators achieve lower latency and higher throughput in Kubernetes clusters.

Kube-OVNKubernetesOVN
0 likes · 12 min read
How to Supercharge Kube-OVN Performance: Benchmarks and Tuning Guide
Programmer DD
Programmer DD
Aug 27, 2022 · Databases

Top 10 PostgreSQL Bulk Import Optimizations for Faster Data Loading

When loading massive amounts of data into PostgreSQL, disabling autocommit, postponing index and foreign‑key creation, adjusting memory settings, using COPY or pg_bulkload, and fine‑tuning WAL and trigger settings can dramatically improve import speed and overall performance.

Bulk ImportCOPYPostgreSQL
0 likes · 7 min read
Top 10 PostgreSQL Bulk Import Optimizations for Faster Data Loading
Sohu Tech Products
Sohu Tech Products
Aug 24, 2022 · Fundamentals

JVM JIT and CodeCache Parameter Configuration Guide

This article explains the JVM's Just‑In‑Time compilation mechanism and CodeCache memory area, detailing the purpose and default values of key JIT parameters such as TieredCompilation, CompileThreshold, OnStackReplacePercentage, CICompilerCount, as well as CodeCache settings like InitialCodeCacheSize, ReservedCodeCacheSize, Xmaxjitcodesize, CodeCacheMinimumFreeSpace and UseCodeCacheFlushing, and provides practical tuning advice for high‑traffic Java services.

HotSpotJITJVM
0 likes · 15 min read
JVM JIT and CodeCache Parameter Configuration Guide
Architects' Tech Alliance
Architects' Tech Alliance
Aug 22, 2022 · Fundamentals

DPDK Performance Tuning: Influencing Factors and Optimization Techniques

This article explains how hardware architecture, Linux OS version, kernel configuration, OVS integration, memory management, NUMA awareness, and CPU micro‑architecture affect DPDK application performance and provides concrete tuning steps such as CPU isolation, service disabling, huge‑page setup, and optimized memory allocation.

CPU OptimizationDPDKLinux
0 likes · 11 min read
DPDK Performance Tuning: Influencing Factors and Optimization Techniques
Ops Development Stories
Ops Development Stories
Aug 19, 2022 · Big Data

Master Kafka: From Core Concepts to Advanced Operations and Performance Tuning

This comprehensive guide explains Kafka’s origins, core architecture, data structures, write and read workflows, operational commands for topic and consumer‑group management, and practical performance‑tuning tips such as disk layout, JVM settings, flush policies, and log retention, providing a complete reference for engineers working with distributed streaming platforms.

Data StreamingDistributed MessagingKafka
0 likes · 32 min read
Master Kafka: From Core Concepts to Advanced Operations and Performance Tuning
Ctrip Technology
Ctrip Technology
Aug 18, 2022 · Databases

Nebula Graph Architecture, Deployment Strategies, and Performance Optimization at Ctrip

This article describes Ctrip's adoption of Nebula Graph, covering the reasons for choosing the open‑source distributed graph database, its modular architecture, multi‑data‑center and blue‑green deployment patterns, middleware integration, client session management, query language extensions, and a series of performance‑tuning practices that solved stability and CPU issues in production.

KubernetesNebula GraphSession Management
0 likes · 21 min read
Nebula Graph Architecture, Deployment Strategies, and Performance Optimization at Ctrip
dbaplus Community
dbaplus Community
Aug 7, 2022 · Databases

Mastering MySQL Performance: Practical Strategies for Slow‑SQL Optimization

This comprehensive guide examines why slow SQL queries degrade system performance, outlines key factors such as data volume, access patterns, and processing methods, and provides concrete optimization techniques, case studies, index design principles, and advanced features like MRR and index push‑down for MySQL‑InnoDB.

InnoDBMySQLQuery Planning
0 likes · 14 min read
Mastering MySQL Performance: Practical Strategies for Slow‑SQL Optimization
Su San Talks Tech
Su San Talks Tech
Aug 1, 2022 · Backend Development

Master Tomcat Performance: Key Components and Tuning Tips for Max Throughput

This article explains Tomcat’s internal component architecture, walks through the request‑processing flow, and details three crucial configuration parameters—maxThreads, maxConnections, and acceptCount—offering practical formulas and tuning guidelines to improve throughput without adding hardware.

BackendConnectorJava
0 likes · 12 min read
Master Tomcat Performance: Key Components and Tuning Tips for Max Throughput
Tencent Cloud Middleware
Tencent Cloud Middleware
Jul 25, 2022 · Operations

How Tencent Scaled Apache Pulsar to Process Billions of Messages Daily – Ops Lessons & Tuning Guide

This article details the design, deployment, and performance‑tuning techniques used by Tencent's TEG Data Platform to operate a massive Apache Pulsar cluster handling trillions of messages per day, covering server‑side parameters, client‑side configurations, common bottlenecks, and step‑by‑step troubleshooting advice.

Apache PulsarGo SDKLarge Scale Messaging
0 likes · 22 min read
How Tencent Scaled Apache Pulsar to Process Billions of Messages Daily – Ops Lessons & Tuning Guide
MaGe Linux Operations
MaGe Linux Operations
Jul 20, 2022 · Operations

What a Typical Ops Day Looks Like—and How to Make It More Productive

The author recounts a chaotic typical day for Chinese operations engineers, then proposes a balanced schedule that prioritizes urgent firefighting tasks while dedicating most time to proactive monitoring, performance tuning, tool development, and continuous learning for long‑term system stability.

DevOpsOperationsmonitoring
0 likes · 4 min read
What a Typical Ops Day Looks Like—and How to Make It More Productive
Programmer DD
Programmer DD
Jul 15, 2022 · Databases

Boost MySQL Performance: 8 Common SQL Pitfalls and How to Fix Them

This article examines frequent MySQL performance problems—such as inefficient LIMIT usage, implicit type conversion, suboptimal joins, mixed ordering, EXISTS subqueries, condition pushdown limitations, early range reduction, and intermediate result handling—and provides concrete rewrites and execution‑plan analyses that dramatically improve query speed.

Database IndexingMySQLQuery Rewriting
0 likes · 16 min read
Boost MySQL Performance: 8 Common SQL Pitfalls and How to Fix Them
Top Architect
Top Architect
Jul 14, 2022 · Big Data

A Comprehensive Introduction to Elasticsearch: Architecture, Core Concepts, and Practical Usage

This article provides a detailed overview of Elasticsearch, covering its data model, Lucene foundation, cluster architecture, shard and replica mechanisms, index mapping, installation steps, health monitoring, write and storage processes, segment management, and performance tuning techniques for large‑scale search applications.

Elasticsearchbig dataindexing
0 likes · 35 min read
A Comprehensive Introduction to Elasticsearch: Architecture, Core Concepts, and Practical Usage
Liangxu Linux
Liangxu Linux
Jul 9, 2022 · Databases

How Indexes Transform MySQL Subquery Performance: A Deep Dive

This article walks through a MySQL 5.6 scenario where a subquery that originally took over eight hours is accelerated by orders of magnitude through strategic index creation, query rewriting, and join optimization, illustrating the impact of single‑column, composite, and covering indexes on execution plans.

Index OptimizationJOINMySQL
0 likes · 13 min read
How Indexes Transform MySQL Subquery Performance: A Deep Dive
Youzan Coder
Youzan Coder
Jul 7, 2022 · Big Data

Optimizing Apache Doris Performance: A Case Study in Query Processing

Youzan replaced ClickHouse and Druid with Apache Doris, refined its vectorized engine by eliminating deserialization overhead in the merge‑aggregation phase, achieving roughly a 30 % query‑time boost, and validated compatibility through SQL rewriting and traffic replay, while planning further SIMD‑based optimizations and broader adoption.

Apache DorisClickHouseDruid
0 likes · 8 min read
Optimizing Apache Doris Performance: A Case Study in Query Processing
HelloTech
HelloTech
Jul 6, 2022 · Big Data

Investigation and Resolution of Elasticsearch Write Timeout Issues in a Real-Time Flink Data Sync Pipeline

The team diagnosed intermittent Elasticsearch write‑timeout failures in their real‑time Flink‑to‑Elasticsearch pipeline as lock contention from frequent duplicate updates to the same document IDs, and eliminated the issue by aggregating binlog events in a 5‑second sliding window to deduplicate writes, adjusting refresh intervals, using async translog durability, and disabling non‑essential fields.

ElasticsearchFlinkWrite Timeout
0 likes · 7 min read
Investigation and Resolution of Elasticsearch Write Timeout Issues in a Real-Time Flink Data Sync Pipeline
Su San Talks Tech
Su San Talks Tech
Jul 6, 2022 · Databases

Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM

This article explains Redis's internal storage mechanisms and presents seven practical optimization techniques—including key‑value compression, small‑collection encoding, object sharing, bitmap usage, hash structuring, memory‑fragment defragmentation, and 32‑bit deployment—to dramatically reduce memory consumption while increasing data capacity.

Data StructuresMemory OptimizationRedis
0 likes · 21 min read
Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM
macrozheng
macrozheng
Jul 1, 2022 · Operations

How to Optimize Server Performance: Config, Load Analysis, and Kernel Tuning

Learn practical methods to boost server performance by selecting appropriate hardware configurations, analyzing CPU, memory, disk I/O and network loads, and fine‑tuning kernel parameters such as file limits and TCP settings, with step‑by‑step commands and monitoring tools like htop, iostat, and nload.

Linuxkernel parametersmonitoring
0 likes · 14 min read
How to Optimize Server Performance: Config, Load Analysis, and Kernel Tuning
Open Source Linux
Open Source Linux
Jun 28, 2022 · Operations

Essential Ops Lessons: 22 Hard‑Earned Rules to Prevent Disasters

Drawing from three and a half years of DevOps experience, this guide compiles critical operational practices—ranging from cautious command execution and strict change control to robust backup, security hardening, continuous monitoring, performance tuning, and a disciplined mindset—to help engineers avoid costly outages and data loss.

DevOpsOperational Best Practicesbackup
0 likes · 12 min read
Essential Ops Lessons: 22 Hard‑Earned Rules to Prevent Disasters
Su San Talks Tech
Su San Talks Tech
Jun 25, 2022 · Backend Development

How Kafka Broker Handles High‑Throughput Requests: Deep Dive into Its Network Architecture

This article thoroughly examines Kafka Broker's network architecture and request‑handling pipeline, exploring sequential, multi‑threaded, and Reactor‑based designs, detailing Acceptor and Processor threads, NIO mechanisms, and offering practical tuning tips to achieve high concurrency and performance.

KafkaNetwork ArchitectureReactor Pattern
0 likes · 21 min read
How Kafka Broker Handles High‑Throughput Requests: Deep Dive into Its Network Architecture
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 22, 2022 · Databases

Diagnosing Excessive data_free Values in MySQL and Managing ibtmp1 Temporary Tablespace Bloat

This article walks through a real‑world case where a MySQL instance showed an abnormal 13 GB data_free value, explains how the ibtmp1 temporary tablespace caused the growth, demonstrates verification steps with sysbench and SQL queries, and provides configuration and operational solutions to prevent and resolve the issue.

MySQLdata_freeibtmp1
0 likes · 9 min read
Diagnosing Excessive data_free Values in MySQL and Managing ibtmp1 Temporary Tablespace Bloat