BestHub
Sign in
Tagged articles

Performance Tuning

1016 articles · Page 7 of 11
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 22, 2021 · Big Data

Comprehensive Overview of SparkSQL: History, Architecture, Execution Process, and Optimization Techniques

This article provides a detailed exploration of SparkSQL, covering its evolution from Shark, core components, execution workflow, Catalyst optimizer, various optimization strategies, and practical configuration tips for achieving high performance in big‑data processing.

Adaptive Query ExecutionCatalyst OptimizerDataFrames
0 likes · 19 min read
Comprehensive Overview of SparkSQL: History, Architecture, Execution Process, and Optimization Techniques
Efficient Ops
Efficient Ops
Jul 6, 2021 · Operations

Mastering TCP TIME-WAIT: When to Optimize and How

This article explains the purpose of the TCP TIME-WAIT state, the scenarios it protects against, common misconceptions, and practical Linux kernel tweaks—such as fast recycle, socket reuse, and tw_buckets settings—to manage TIME-WAIT efficiently on high‑concurrency servers.

LinuxNetwork OperationsPerformance Tuning
0 likes · 8 min read
Mastering TCP TIME-WAIT: When to Optimize and How
Architects Research Society
Architects Research Society
Jul 3, 2021 · Backend Development

Optimizing NGINX and Linux Settings for High Performance

This article provides a practical guide to tuning Linux kernel parameters and NGINX configuration directives—such as backlog queues, file descriptors, worker processes, keepalive connections, access‑log buffering, sendfile, limits, caching and compression—to achieve optimal web server performance for high‑traffic sites.

LinuxNGINXPerformance Tuning
0 likes · 11 min read
Optimizing NGINX and Linux Settings for High Performance
Code Ape Tech Column
Code Ape Tech Column
Jun 20, 2021 · Backend Development

Master JVM Performance: Essential Tools and Real‑World Debugging Guide

This article introduces core JVM performance and monitoring utilities—including jps, jstack, jmap, jhat, jstat, and hprof—explains their command syntax, demonstrates practical steps to locate high‑CPU threads, analyze heap dumps, and interpret GC statistics, and provides concrete code examples for Java developers.

JVMJavaPerformance Tuning
0 likes · 13 min read
Master JVM Performance: Essential Tools and Real‑World Debugging Guide
Kuaishou Tech
Kuaishou Tech
Jun 8, 2021 · Mobile Development

Flutter Audio-Video Practice and Optimization in Kuaishou

This article details Kuaishou's Flutter audio-video implementation, optimization practices, and engineering support, covering video playback via external textures, data communication strategies, FFI integration, and performance tuning.

FFIFlutterKuaishou
0 likes · 17 min read
Flutter Audio-Video Practice and Optimization in Kuaishou
Programmer DD
Programmer DD
May 27, 2021 · Operations

How We Cut Full GC Frequency from 40×/Day to Once Every 10 Days

Over a month of JVM tuning, the author reduced Full GC from more than 40 times per day to once every ten days and halved Young GC duration by adjusting heap sizes, fixing memory leaks, and tuning metaspace, ultimately improving server throughput and stability.

Garbage CollectionJVMJava
0 likes · 12 min read
How We Cut Full GC Frequency from 40×/Day to Once Every 10 Days
Programmer DD
Programmer DD
May 23, 2021 · Operations

How I Cut Full GC Frequency from 40 to 1 in 10 Days: A JVM Tuning Journey

Over a month of systematic investigation, the author reduced Full GC occurrences on a 2‑core, 4 GB Java server cluster from 40 times a day to roughly once every ten days by adjusting heap settings, fixing a memory‑leak caused by an anonymous listener, and tuning Metaspace and CMS thresholds, ultimately achieving stable performance and lower latency.

Garbage CollectionJVMJava
0 likes · 11 min read
How I Cut Full GC Frequency from 40 to 1 in 10 Days: A JVM Tuning Journey
Aikesheng Open Source Community
Aikesheng Open Source Community
May 21, 2021 · Databases

Investigating MySQL InnoDB Spin‑Lock Parameters: innodb_spin_wait_delay and innodb_sync_spin_loops

This article examines MySQL InnoDB spin‑lock tuning by adjusting innodb_spin_wait_delay and innodb_sync_spin_loops, describing spin‑lock mechanics, detailing an experiment with performance_schema metrics, and concluding that modest spin settings are preferable to aggressive tuning.

InnoDBPerformance Tuningdatabase optimization
0 likes · 5 min read
Investigating MySQL InnoDB Spin‑Lock Parameters: innodb_spin_wait_delay and innodb_sync_spin_loops
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 15, 2021 · Backend Development

JVM Tuning Guide: Understanding GC, Memory Model, and Configuration Options

This article provides a comprehensive guide to JVM performance tuning, covering the JVM architecture, runtime data areas, various garbage collectors, configuration flags for heap and GC settings, and practical recommendations for selecting the optimal GC strategy based on workload characteristics.

Backend DevelopmentGarbage CollectionJVM
0 likes · 6 min read
JVM Tuning Guide: Understanding GC, Memory Model, and Configuration Options
Java Architect Essentials
Java Architect Essentials
May 11, 2021 · Databases

Comprehensive MySQL Query Optimization and Best Practices

This article presents an extensive collection of MySQL performance‑tuning techniques, covering index design, query rewriting, use of UNION and EXISTS, temporary tables, NOLOCK hints, join limits, backup strategies, storage engine choices, data‑type selection, and other practical tips to improve query efficiency and overall database reliability.

Database DesignIndexesPerformance Tuning
0 likes · 18 min read
Comprehensive MySQL Query Optimization and Best Practices
DeWu Technology
DeWu Technology
Apr 29, 2021 · Backend Development

JVM Garbage Collection: CMS Principles and Tuning

Understanding JVM garbage collection with the CMS collector involves grasping class‑loader hierarchies, memory regions such as Young, Old and Metaspace, the multithreaded ParNew young collector, CMS’s four‑phase mark‑sweep‑compact cycle, and applying tuning parameters—like survivor ratios, tenuring thresholds, and concurrent marking options—to minimize stop‑the‑world pauses and full GCs on typical 4‑core, 8 GB servers.

CMSGarbage CollectionJVM
0 likes · 18 min read
JVM Garbage Collection: CMS Principles and Tuning
Code Ape Tech Column
Code Ape Tech Column
Apr 25, 2021 · Operations

JVM Garbage Collection Tuning: Reducing FullGC Frequency and Improving Throughput

This article documents a month-long JVM garbage‑collection tuning effort on a 2‑core, 4 GB server cluster, detailing initial problems with frequent FullGC, successive configuration adjustments, memory‑leak investigations, and the final optimizations that cut FullGC occurrences and significantly improved overall throughput.

FullGCGarbage CollectionJVM
0 likes · 10 min read
JVM Garbage Collection Tuning: Reducing FullGC Frequency and Improving Throughput
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 21, 2021 · Backend Development

Understanding Java Thread Pools: Core Concepts, Rejection Policies, and Sizing Guidelines

This article explains Java thread pool fundamentals—including core parameters, task submission behavior, rejection policies, queue selection, thread factory usage, keep-alive settings—and provides practical guidance on determining optimal thread counts for I/O‑bound and CPU‑bound workloads.

Backend DevelopmentJavaPerformance Tuning
0 likes · 11 min read
Understanding Java Thread Pools: Core Concepts, Rejection Policies, and Sizing Guidelines
Laravel Tech Community
Laravel Tech Community
Apr 20, 2021 · Databases

Diagnosing and Increasing MySQL Max Connections

This guide explains how to identify MySQL max‑connection errors, check the current limit, and increase it using configuration files, global variables, source‑code changes, or mysqld_safe adjustments, with detailed commands and code examples for various MySQL versions.

Database ConfigurationPerformance TuningSQL
0 likes · 4 min read
Diagnosing and Increasing MySQL Max Connections
dbaplus Community
dbaplus Community
Apr 20, 2021 · Big Data

10 Common Pitfalls When Migrating Spark Jobs to Flink (And How to Avoid Them)

This article shares ten practical pitfalls encountered when moving hourly Spark session jobs to Flink, covering parallelism load imbalance, state TTL, checkpointing strategies, logging, JMX debugging, state migration risks, reduce vs process choices, input data validation, event‑time handling, and external storage considerations, along with concrete configuration snippets and performance tips.

FlinkPerformance TuningSpark migration
0 likes · 20 min read
10 Common Pitfalls When Migrating Spark Jobs to Flink (And How to Avoid Them)
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 19, 2021 · Backend Development

Comprehensive Guide to Java JVM: Architecture, Class Loading, Garbage Collection, and Performance Tuning

This article provides an in‑depth overview of the Java Virtual Machine, covering JDK/JRE/JVM relationships, compilation process, class loading mechanisms, the parent‑delegation model, runtime memory areas, garbage collection algorithms and collectors, and practical JVM performance tuning tips for backend developers.

Garbage CollectionJVMJava
0 likes · 50 min read
Comprehensive Guide to Java JVM: Architecture, Class Loading, Garbage Collection, and Performance Tuning
Architects' Tech Alliance
Architects' Tech Alliance
Apr 11, 2021 · Industry Insights

How to Supercharge Ceph on Huawei Kunpeng ARM: Deep Performance Tuning Guide

This article examines Ceph’s architecture, identifies performance bottlenecks on Huawei’s Kunpeng ARM platform, and presents practical tuning methods—including NUMA placement, cache tagging, vector acceleration, thread scaling, and monitoring tools—to improve storage efficiency, reduce latency, and lower power consumption.

ArmCache OptimizationCeph
0 likes · 17 min read
How to Supercharge Ceph on Huawei Kunpeng ARM: Deep Performance Tuning Guide
Java Interview Crash Guide
Java Interview Crash Guide
Apr 9, 2021 · Backend Development

Mastering Java Thread Pools: Benefits, Creation, Tuning & Monitoring

This article explores Java's thread pool framework in depth, covering its advantages, internal workflow, creation parameters, task submission, lifecycle states, tuning strategies, monitoring metrics, and common pitfalls, providing code examples and practical guidance for effective concurrency management in backend applications.

JavaPerformance TuningThreadPoolExecutor
0 likes · 17 min read
Mastering Java Thread Pools: Benefits, Creation, Tuning & Monitoring
macrozheng
macrozheng
Apr 6, 2021 · Backend Development

Boost Tomcat Performance: Essential Configurations for Faster Servers

This guide explains the most important Tomcat configuration parameters—including concurrency, thread pool, JVM settings, and key Connector options—so you can optimize the web container for higher throughput and lower latency without getting lost in hundreds of obscure options.

ConfigurationJVMPerformance Tuning
0 likes · 9 min read
Boost Tomcat Performance: Essential Configurations for Faster Servers
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 4, 2021 · Big Data

Flink Performance Tuning Guide: Memory Configuration, Parallelism, Checkpoint Optimization, and Common Issues

This guide details comprehensive Flink performance tuning techniques, covering memory configuration, GC settings, parallelism adjustments, process parameters, partitioning strategies, Netty network tuning, checkpoint optimization, and common issues such as data skew and resource bottlenecks.

CheckpointFlinkMemory Management
0 likes · 18 min read
Flink Performance Tuning Guide: Memory Configuration, Parallelism, Checkpoint Optimization, and Common Issues
Architect
Architect
Apr 3, 2021 · Big Data

Advanced Spark Performance Optimization: Data Skew and Shuffle Tuning

This article explains advanced Spark performance tuning techniques, focusing on diagnosing and resolving data skew and shuffle bottlenecks through stage analysis, key distribution inspection, and a variety of practical solutions such as Hive pre‑processing, key filtering, parallelism increase, two‑stage aggregation, map‑join, and combined strategies, while also covering ShuffleManager internals and related configuration parameters.

Big DataData SkewPerformance Tuning
0 likes · 47 min read
Advanced Spark Performance Optimization: Data Skew and Shuffle Tuning
360 Smart Cloud
360 Smart Cloud
Apr 1, 2021 · Databases

Using TiDB Data Migration (DM) for MySQL‑to‑TiDB Sync: Architecture, Features, Tuning and Troubleshooting

This article shares practical experience with TiDB Data Migration (DM), covering its background, architecture, key features, online DDL support, common error handling such as duplicate‑key issues, large‑scale import tuning, configuration limits, and cleanup recommendations for reliable MySQL‑to‑TiDB synchronization.

DMData MigrationDatabase Synchronization
0 likes · 16 min read
Using TiDB Data Migration (DM) for MySQL‑to‑TiDB Sync: Architecture, Features, Tuning and Troubleshooting
360 Tech Engineering
360 Tech Engineering
Mar 22, 2021 · Databases

Analyzing and Optimizing High Memory and Disk I/O Consumption of InfluxDB 1.8 on a Production Server

This article investigates why an InfluxDB 1.8 instance on a 32‑core, 64 GB server consumes over 58 GB of resident memory and generates heavy disk I/O, examines Go runtime memory accounting, uses system tools such as top, pmap, pprof and iostat for diagnosis, and presents configuration and runtime tweaks that reduce memory pressure and I/O load.

InfluxDBLinuxPerformance Tuning
0 likes · 13 min read
Analyzing and Optimizing High Memory and Disk I/O Consumption of InfluxDB 1.8 on a Production Server
360 Smart Cloud
360 Smart Cloud
Mar 19, 2021 · Databases

Root Cause Analysis and Performance Optimization of InfluxDB 1.8 Memory and Disk I/O on a Production Server

The article investigates why an InfluxDB 1.8 instance on a 32‑core, 64 GB production server consumes over 95% memory and generates heavy disk I/O, analyzes runtime statistics, pprof data, and Go memory‑release behavior, and presents configuration and runtime tweaks that reduce memory usage to ~55% and I/O load to acceptable levels.

InfluxDBPerformance Tuningdatabase optimization
0 likes · 12 min read
Root Cause Analysis and Performance Optimization of InfluxDB 1.8 Memory and Disk I/O on a Production Server
Architect's Tech Stack
Architect's Tech Stack
Mar 15, 2021 · Databases

Optimizing a 20‑Million‑Row MySQL Table: Design, Indexing, Partitioning, and Migration Strategies

This article describes how to improve the performance of a massive MySQL 5.6 user‑log table by redesigning schema, applying proper indexes, using partitioning, considering table sharding, and evaluating upgrade paths to compatible cloud or big‑data databases, with concrete SQL examples and cost analysis.

Cloud DatabasesIndexingLarge Tables
0 likes · 16 min read
Optimizing a 20‑Million‑Row MySQL Table: Design, Indexing, Partitioning, and Migration Strategies
Top Architect
Top Architect
Mar 5, 2021 · Big Data

Elasticsearch Indexing and Search Optimization: Principles, Lucene Internals, and Performance Tuning

This article explains the architecture and core concepts of Elasticsearch and Lucene, outlines the requirements for cross‑month and high‑speed queries on massive datasets, and provides detailed index and search performance tuning techniques—including bulk writes, shard routing, doc‑values management, and pagination strategies—to achieve sub‑second response times on billions of records.

Big DataElasticsearchIndex Optimization
0 likes · 13 min read
Elasticsearch Indexing and Search Optimization: Principles, Lucene Internals, and Performance Tuning
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 3, 2021 · Backend Development

Design and Deployment of an Online Messaging System Using RocketMQ at Kuaishou

This article explains why Kuaishou needed a dedicated online messaging system, how RocketMQ was chosen and integrated, the deployment strategies, client SDK design, load‑balancing and disaster‑recovery mechanisms, diverse message features, distributed reconciliation monitoring, and performance‑tuning parameters.

Messaging SystemPerformance TuningRocketMQ
0 likes · 15 min read
Design and Deployment of an Online Messaging System Using RocketMQ at Kuaishou
21CTO
21CTO
Feb 7, 2021 · Backend Development

Why We Chose RocketMQ for Our Online Messaging System and How We Built It

This article explains why the team built a dedicated online messaging system, the scenarios where Kafka fell short, the decision to adopt RocketMQ, deployment strategies, SDK design, load‑balancing, distributed monitoring, and performance tuning tips for a robust backend solution.

Messaging SystemPerformance TuningRocketMQ
0 likes · 14 min read
Why We Chose RocketMQ for Our Online Messaging System and How We Built It
Alibaba Cloud Native
Alibaba Cloud Native
Feb 4, 2021 · Backend Development

Why Spring Boot’s War‑to‑Jar Deployment Slows Down Feign Calls and How to Fix It

After upgrading an internal framework, a company’s UAT environment saw throughput drop from 53.9/s to 6.4/s due to abnormal Feign latency, prompting a deep dive with Arthas profiling, code tracing, and class‑loader analysis that uncovered costly JodaModule loading and class‑loader overhead, leading to targeted fixes that restored and even improved performance.

FeignJavaPerformance Tuning
0 likes · 16 min read
Why Spring Boot’s War‑to‑Jar Deployment Slows Down Feign Calls and How to Fix It
Laravel Tech Community
Laravel Tech Community
Jan 24, 2021 · Databases

MySQL Slow Query Optimization: Reducing Execution Time from 30 Seconds to 0.19 Seconds

This article documents a MySQL slow‑query case where a 5‑million‑row table took over 30 seconds to execute, explores several ineffective optimization attempts, uncovers a client‑side LIMIT issue, and finally resolves the performance problem by forcing the use of the idx_end_time index, cutting the runtime to under a second.

Execution PlanIndexesPerformance Tuning
0 likes · 5 min read
MySQL Slow Query Optimization: Reducing Execution Time from 30 Seconds to 0.19 Seconds
Java Interview Crash Guide
Java Interview Crash Guide
Jan 14, 2021 · Backend Development

Mastering JVM: Memory Areas, GC, and Class Loading Explained

This comprehensive guide walks through the Java Virtual Machine's runtime data areas, memory model, heap layout, garbage‑collection mechanisms, HotSpot internals, performance tuning flags, and class‑loading process, providing developers with the essential knowledge to optimize Java applications.

Garbage CollectionJVMPerformance Tuning
0 likes · 29 min read
Mastering JVM: Memory Areas, GC, and Class Loading Explained
Youzan Coder
Youzan Coder
Jan 13, 2021 · Big Data

Flink Real-time Task Resource Optimization Practice at Youzan

At Youzan, Flink real‑time tasks running on Kubernetes are optimized by daily GC‑log memory analysis and Kafka‑throughput monitoring, which compute recommended heap sizes and parallelism adjustments to eliminate over‑provisioned CPU and memory, automate alerts, and pave the way for fully automated resource tuning.

FlinkGC TuningPerformance Tuning
0 likes · 16 min read
Flink Real-time Task Resource Optimization Practice at Youzan
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 10, 2021 · Fundamentals

Understanding the JVM Memory Model, Garbage Collection Algorithms, and Performance Optimizations

This comprehensive guide explains the JVM memory layout, object allocation, garbage collection mechanisms such as mark‑sweep, copying, and mark‑compact, details GC roots, reference types, collector types, tuning parameters, and related Java performance tools, providing practical code examples and diagrams.

Garbage CollectionJVMJava
0 likes · 42 min read
Understanding the JVM Memory Model, Garbage Collection Algorithms, and Performance Optimizations
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 9, 2021 · Big Data

Performance Optimization of Elasticsearch in an ELK Log Architecture

This article summarizes a year‑long performance tuning of an ELK logging system, analyzing bottlenecks such as write thread pool saturation, JVM heap and GC settings, refresh intervals, translog durability, merge threads, shard and replica counts, and provides concrete configuration changes that reduced latency, eliminated data loss, and stabilized node resource usage.

ELKElasticsearchJVM
0 likes · 20 min read
Performance Optimization of Elasticsearch in an ELK Log Architecture
ITPUB
ITPUB
Jan 6, 2021 · Databases

Why Do MySQL Queries Slow Down? Understanding Write/Read Bottlenecks

This article explains why MySQL queries become slow by examining write‑operation issues such as dirty‑page flushing and locking, read‑operation problems like missing indexes and buffer‑pool evictions, and provides practical steps to diagnose and prevent these performance bottlenecks.

EXPLAINPerformance TuningSlow Query
0 likes · 11 min read
Why Do MySQL Queries Slow Down? Understanding Write/Read Bottlenecks
Open Source Linux
Open Source Linux
Jan 6, 2021 · Operations

Boost Nginx Performance: Essential Linux System Parameter Tweaks

This guide explains how to optimize Linux kernel parameters and Nginx settings—such as file descriptor limits, TCP queue lengths, temporary ports, worker processes, KeepAlive, and log buffering—to significantly improve server performance and handle high traffic loads.

LinuxNGINXPerformance Tuning
0 likes · 8 min read
Boost Nginx Performance: Essential Linux System Parameter Tweaks
Code Ape Tech Column
Code Ape Tech Column
Jan 5, 2021 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

This article explains why SQL query optimization matters and presents five practical rules—return only needed rows, use the right indexes, avoid subqueries, replace OFFSET‑based pagination, and master the logical execution order—to help developers write faster, more efficient database queries across major relational systems.

IndexesPerformance TuningQuery Optimization
0 likes · 14 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Big Data Technology & Architecture
Big Data Technology & Architecture
Jan 2, 2021 · Fundamentals

Understanding G1 Garbage Collector: Architecture, Algorithms, and Tuning

This article explains the different types of Java garbage collectors, focuses on the G1 (Garbage‑First) collector’s region‑based architecture, key data structures and algorithms such as TLAB, PLAB, CSet, Card Table, RSet, and SATB, and provides detailed log analysis and tuning recommendations to improve pause times and throughput.

G1 GCGarbage CollectionJVM
0 likes · 37 min read
Understanding G1 Garbage Collector: Architecture, Algorithms, and Tuning
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 31, 2020 · Fundamentals

Unlocking JVM Secrets: Memory Leaks, GC, Class Loading and Performance Tuning

This comprehensive guide explores Java's JVM internals, covering memory leaks, data type sizes, differences between Serial and Parallel GC, reference types, compressed OOPs, JVM bitness detection, heap limits, JRE/JDK/JVM/JIT distinctions, memory regions, garbage collection algorithms, class loading mechanisms, and practical tuning commands and tools, providing developers with deep insights into Java performance and memory management.

Garbage CollectionJavaMemory Management
0 likes · 63 min read
Unlocking JVM Secrets: Memory Leaks, GC, Class Loading and Performance Tuning
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 28, 2020 · Big Data

Optimizing OLAP Data Source Integration with SparkSQL: Cluster and Node Tuning, Profiling, and GC

This article details the end‑to‑end process of connecting an OLAP data source to SparkSQL and presents a comprehensive performance‑tuning guide covering cluster‑level resource allocation, single‑node On‑CPU/Off‑CPU analysis, flame‑graph profiling, Java Flight Recorder usage, and garbage‑collection optimization.

Cluster OptimizationGCOLAP
0 likes · 16 min read
Optimizing OLAP Data Source Integration with SparkSQL: Cluster and Node Tuning, Profiling, and GC
Liangxu Linux
Liangxu Linux
Dec 26, 2020 · Databases

Master MySQL Performance: Practical Soft and Hard Optimization Techniques

This guide explains how to boost MySQL performance through soft optimizations like query analysis, index usage, and table restructuring, as well as hard optimizations involving hardware upgrades, configuration tuning, sharding, read‑write splitting, and cache clustering.

CacheIndexingPerformance Tuning
0 likes · 8 min read
Master MySQL Performance: Practical Soft and Hard Optimization Techniques
Top Architect
Top Architect
Dec 14, 2020 · Databases

Understanding MySQL Query Execution and Optimization Techniques

This article explains MySQL’s logical architecture, query processing steps, caching mechanisms, index structures, and provides practical performance‑tuning advice—including schema design, index creation, query rewriting, and pagination—helping readers grasp the underlying principles and apply effective optimizations in real‑world workloads.

IndexesPerformance TuningQuery Optimization
0 likes · 34 min read
Understanding MySQL Query Execution and Optimization Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 13, 2020 · Big Data

Elasticsearch Write, Read, Search Processes and Performance Tuning Guide

This article explains Elasticsearch's data ingestion, retrieval, and search workflows, details the underlying indexing mechanisms, and provides comprehensive system‑level, shard‑level, and query‑level tuning recommendations—including configuration snippets and best‑practice strategies for high‑throughput and low‑latency deployments.

Cluster ConfigurationElasticsearchIndexing
0 likes · 20 min read
Elasticsearch Write, Read, Search Processes and Performance Tuning Guide
Laravel Tech Community
Laravel Tech Community
Dec 10, 2020 · Databases

MySQL Single‑Table Optimization, Partitioning, Sharding and Scaling Strategies

This article provides a comprehensive guide to improving MySQL performance by optimizing single‑table schemas, indexes, queries, engine settings, system parameters, and then discusses read/write separation, caching layers, table partitioning, vertical and horizontal sharding, compatible scalable databases and when to consider NoSQL alternatives.

Performance TuningShardingdatabase optimization
0 likes · 21 min read
MySQL Single‑Table Optimization, Partitioning, Sharding and Scaling Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Dec 8, 2020 · Backend Development

High‑Concurrency Performance Tuning of a Java SSM E‑commerce Project: Diagnosis, Optimization, and Results

This article details a complete end‑to‑end high‑concurrency tuning process for a Java SSM monolithic e‑commerce system, covering problem identification, root‑cause analysis, a series of JVM, Tomcat, Redis and JDBC optimizations, horizontal scaling, code refactoring, and the resulting stability improvements.

High concurrencyJVMJava
0 likes · 9 min read
High‑Concurrency Performance Tuning of a Java SSM E‑commerce Project: Diagnosis, Optimization, and Results
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 3, 2020 · Big Data

Hive Query Optimization Techniques and Best Practices

This article presents a comprehensive guide to optimizing Hive queries, covering limit adjustments, join strategies, local mode execution, parallelism, strict mode, mapper and reducer tuning, JVM reuse, dynamic partitioning, speculative execution, data skew handling, and small‑file mitigation techniques.

HiveMapReducePerformance Tuning
0 likes · 20 min read
Hive Query Optimization Techniques and Best Practices
Xueersi Online School Tech Team
Xueersi Online School Tech Team
Nov 13, 2020 · Backend Development

Building Robust Backend Systems: Architecture, Best Practices, and Operational Guidelines

This article explains why robust systems are essential, outlines key architectural and design principles, presents practical implementation details such as service layering, micro‑service migration, container simulation code, timeout handling, monitoring, security measures, and performance tuning to help engineers build reliable, scalable backend applications.

Performance TuningRobustnesssecurity
0 likes · 22 min read
Building Robust Backend Systems: Architecture, Best Practices, and Operational Guidelines
Big Data Technology & Architecture
Big Data Technology & Architecture
Nov 8, 2020 · Big Data

Flume Tuning Guide for High‑Throughput Data Ingestion

This article explains how to identify and resolve performance bottlenecks in Apache Flume by configuring Taildir sources, optimizing channel capacities, tuning Kafka sinks, adjusting JVM options, and using simple monitoring scripts, enabling a single Flume‑NG agent to sustain over 50,000 RPS in production.

Big DataConfigurationFlume
0 likes · 10 min read
Flume Tuning Guide for High‑Throughput Data Ingestion
Qunar Tech Salon
Qunar Tech Salon
Nov 5, 2020 · Databases

Managing Excessive WAL Growth in PostgreSQL 11: Diagnosis and Resolution

This article explains why a low‑traffic PostgreSQL 11 database can accumulate massive WAL files, analyzes relevant configuration parameters and replication slots, demonstrates diagnostic SQL commands, and provides step‑by‑step actions—including adjusting archive_timeout, handling replication slots, and forcing a checkpoint—to reclaim disk space.

Database AdministrationPerformance TuningPostgreSQL
0 likes · 8 min read
Managing Excessive WAL Growth in PostgreSQL 11: Diagnosis and Resolution
Big Data Technology Architecture
Big Data Technology Architecture
Nov 3, 2020 · Big Data

Performance Optimization of Apache Kylin at Beike: HBase Tuning, Region Management, and Slow‑Query Mitigation

This article details how Beike's engineering team scaled Apache Kylin to handle tens of millions of daily queries by optimizing HBase configurations, reducing region count, improving data locality, addressing IO and JVM GC bottlenecks, and implementing comprehensive slow‑query detection and active‑defense mechanisms.

Apache KylinHBaseJVM GC
0 likes · 15 min read
Performance Optimization of Apache Kylin at Beike: HBase Tuning, Region Management, and Slow‑Query Mitigation
Efficient Ops
Efficient Ops
Nov 1, 2020 · Databases

Why Is Redis Slowing Down? Diagnose and Fix Common Latency Issues

This article explains the typical reasons behind Redis latency spikes—such as complex commands, big keys, concentrated expirations, memory limits, fork overhead, CPU binding, AOF settings, swap usage, and network overload—and provides practical steps and monitoring techniques to identify and resolve each problem.

LatencyMonitoringPerformance Tuning
0 likes · 18 min read
Why Is Redis Slowing Down? Diagnose and Fix Common Latency Issues
Java Captain
Java Captain
Oct 29, 2020 · Databases

MySQL Single‑Table Optimization, Partitioning, Sharding and Scaling Strategies

When a MySQL table grows large, CRUD performance degrades, so this article presents comprehensive optimization techniques—including field design, indexing, query rewriting, engine selection, system parameters, hardware upgrades, read‑write separation, caching, partitioning, vertical and horizontal splitting, sharding architectures, and recommendations for compatible scalable databases—to help maintain high performance and scalability.

Performance Tuningdatabase optimizationmysql
0 likes · 26 min read
MySQL Single‑Table Optimization, Partitioning, Sharding and Scaling Strategies
Programmer DD
Programmer DD
Oct 28, 2020 · Databases

Master MySQL Performance: Essential Database Optimization Techniques

This guide explains how to identify bottlenecks and boost MySQL performance through both soft (query, index, schema) and hard (hardware, configuration, sharding, caching) optimizations, offering practical commands, best‑practice tips, and visual illustrations for each step.

IndexesPerformance TuningSQL
0 likes · 9 min read
Master MySQL Performance: Essential Database Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 22, 2020 · Databases

Improving Large Transaction Rollback Speed in MySQL: Buffer Pool Tuning and Force Recovery

This article evaluates two techniques for accelerating rollback of large MySQL transactions—dynamically enlarging the InnoDB buffer pool and using innodb_force_recovery=3 with instance shutdown—by presenting experimental steps, code examples, performance measurements, and practical recommendations.

InnoDBPerformance Tuningdatabase
0 likes · 7 min read
Improving Large Transaction Rollback Speed in MySQL: Buffer Pool Tuning and Force Recovery
Laravel Tech Community
Laravel Tech Community
Oct 20, 2020 · Databases

Analyzing and Troubleshooting Redis Latency Issues

This article explains common causes of Redis latency spikes, such as high‑complexity commands, large keys, concentrated expirations, memory limits, fork overhead, CPU binding, AOF settings, swap usage, and network saturation, and provides step‑by‑step troubleshooting commands and best‑practice recommendations.

AOFLarge KeysLatency
0 likes · 18 min read
Analyzing and Troubleshooting Redis Latency Issues
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 13, 2020 · Databases

Database Optimization Methodology and Parameter Tuning for Oracle, MySQL, PostgreSQL, and DM

This article presents a comprehensive methodology for database performance optimization, covering objectives, key metrics, common pitfalls, a step‑by‑step process, instance‑level best practices, and detailed parameter‑tuning tables for Oracle, MySQL (InnoDB), PostgreSQL, and DM databases.

DM DatabaseOraclePerformance Tuning
0 likes · 10 min read
Database Optimization Methodology and Parameter Tuning for Oracle, MySQL, PostgreSQL, and DM
Selected Java Interview Questions
Selected Java Interview Questions
Oct 3, 2020 · Databases

SQL Query Optimization Tips and Common Pitfalls

This article presents a comprehensive collection of SQL query optimization techniques, covering index usage, avoiding full table scans, proper handling of NULLs, functions, LIKE patterns, temporary tables, cursors, and other best practices to improve database performance and maintainability.

IndexesPerformance TuningSQL
0 likes · 11 min read
SQL Query Optimization Tips and Common Pitfalls
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 3, 2020 · Databases

Why Is Redis Slowing Down? Common Causes and How to Diagnose Them

This article explains the typical reasons for Redis latency spikes—including complex commands, large keys, expiration bursts, memory limits, fork overhead, AOF settings, swap usage, and network saturation—and provides practical steps and commands to identify and mitigate each issue.

LatencyOperationsPerformance Tuning
0 likes · 18 min read
Why Is Redis Slowing Down? Common Causes and How to Diagnose Them
Programmer DD
Programmer DD
Sep 20, 2020 · Operations

Why Is Your Redis Slowing Down? 7 Common Latency Culprits and How to Fix Them

This article examines typical Redis latency spikes—such as complex O(n) commands, large keys, concentrated expirations, memory limits, fork overhead, CPU binding, AOF settings, swap usage, and network saturation—explaining how to detect, monitor, and mitigate each issue to maintain high‑performance operation.

AOFLatencyMemory Management
0 likes · 17 min read
Why Is Your Redis Slowing Down? 7 Common Latency Culprits and How to Fix Them
Top Architect
Top Architect
Sep 19, 2020 · Databases

MySQL Performance Optimization: Design, Indexing, Partitioning, and Migration Strategies

This article analyzes a severe MySQL performance issue caused by massive user‑access logs, then presents three solution paths—optimizing the existing database, migrating to a compatible high‑performance database, and adopting big‑data technologies—detailing design best practices, indexing, partitioning, sharding, and cloud‑native options to restore query speed and scalability.

IndexingPerformance Tuningcloud database
0 likes · 18 min read
MySQL Performance Optimization: Design, Indexing, Partitioning, and Migration Strategies
Java Architect Essentials
Java Architect Essentials
Sep 17, 2020 · Databases

Optimizing Large-Scale SQL Queries with Stored Procedures and Indexing

The article details how a half‑hour SSRS report query on a massive MES database was transformed into a sub‑second operation by analyzing the original SQL, eliminating full table scans, adding proper indexes, using temporary tables and a well‑designed stored procedure, while also discussing common pitfalls and best‑practice tips for high‑performance database querying.

IndexingPerformance TuningSQL
0 likes · 20 min read
Optimizing Large-Scale SQL Queries with Stored Procedures and Indexing
Wukong Talks Architecture
Wukong Talks Architecture
Sep 15, 2020 · Fundamentals

JVM Parameter Types and Hands‑On Experiments

This tutorial explains the three main categories of JVM parameters—standard, X, and XX—demonstrates how to view, modify, and verify them using command‑line tools such as java, jps, and jinfo, and provides step‑by‑step hands‑on labs for each type.

JInfoJVMJVM Parameters
0 likes · 9 min read
JVM Parameter Types and Hands‑On Experiments
Programmer DD
Programmer DD
Sep 12, 2020 · Databases

Mastering SQL Server: Essential Commands, Tips, and Advanced Techniques

This comprehensive guide covers SQL Server fundamentals and advanced operations, including database creation, table manipulation, indexing, view management, backup and restore procedures, performance tuning, replication setup, linked servers, and a collection of practical code snippets for everyday database tasks.

Database ManagementPerformance TuningSQL Commands
0 likes · 25 min read
Mastering SQL Server: Essential Commands, Tips, and Advanced Techniques
Top Architect
Top Architect
Sep 10, 2020 · Operations

Elasticsearch Performance Tuning Guide: Configuration, System, and Usage Optimizations

This article provides a comprehensive guide to improving Elasticsearch performance and stability by covering configuration file tweaks, system‑level settings, and usage‑level optimizations such as hot‑thread analysis, pending tasks, field storage, translog handling, refresh intervals, shard management, and best practices for routing and alias usage.

Cluster ConfigurationPerformance TuningSearch Engine
0 likes · 20 min read
Elasticsearch Performance Tuning Guide: Configuration, System, and Usage Optimizations
Programmer DD
Programmer DD
Sep 7, 2020 · Databases

How to Speed Up Massive MySQL Tables: Practical Optimization Strategies

This article examines why a MySQL 5.6 RDS table with tens of millions of rows becomes unbearably slow, then presents three concrete approaches—optimizing the existing database, migrating to a MySQL‑compatible service, and adopting a big‑data engine—detailing design, indexing, partitioning, sharding, and cloud options to restore performance.

IndexingPerformance Tuningdatabase optimization
0 likes · 18 min read
How to Speed Up Massive MySQL Tables: Practical Optimization Strategies
Architecture Digest
Architecture Digest
Sep 5, 2020 · Databases

Understanding SQL Server Lock Escalation and How to Prevent It

This article explains the fundamentals of SQL Server locking, illustrates how row‑level locks can automatically escalate to table‑level locks during large batch operations, and provides practical techniques—such as batching deletes, adding appropriate indexes, and holding intent locks—to avoid lock escalation and improve concurrency.

Database LocksLock EscalationPerformance Tuning
0 likes · 12 min read
Understanding SQL Server Lock Escalation and How to Prevent It
Architecture Digest
Architecture Digest
Sep 3, 2020 · Databases

Practical Elasticsearch Performance and Stability Tuning Guide

This article consolidates practical Elasticsearch tuning techniques—including configuration file adjustments, system‑level optimizations, and usage‑level settings—to improve cluster performance, stability, and resource efficiency for production environments.

Big DataCluster ConfigurationElasticsearch
0 likes · 15 min read
Practical Elasticsearch Performance and Stability Tuning Guide