BestHub
Sign in
Tagged articles
986 articles
Page 7 of 10
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.

InfluxDBLinuxMemory Leak
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.

Database OptimizationInfluxDBMemory Leak
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 DatabasesDatabase OptimizationLarge 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.

Backend ArchitectureMessaging SystemPerformance tuning
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.

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

DatabaseIndexesMySQL
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 CollectionJVMJava Memory Model
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 tuningKubernetes
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.

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

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

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

Garbage CollectionJVMJava
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 OptimizationOLAPPerformance tuning
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.

CacheDatabase OptimizationMySQL
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.

DatabaseIndexesMySQL
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 ConfigurationElasticsearchPerformance tuning
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.

Database OptimizationMySQLPartitioning
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.

JVMJavaPerformance tuning
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 DataFlumeKafka
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.

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

Database OptimizationMySQLPartitioning
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.

Database OptimizationIndexesMySQL
0 likes · 9 min read
Master MySQL Performance: Essential Database Optimization Techniques
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
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.

Database OptimizationIndexesPerformance tuning
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.

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

Database OptimizationMySQLPartitioning
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.

Database OptimizationPerformance 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 tuningSystem Optimization
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.

Database OptimizationMySQLPartitioning
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
Architecture Digest
Architecture Digest
Aug 23, 2020 · Backend Development

End-to-End Performance Optimization of a High-Concurrency SSM E‑Commerce System

This article presents a comprehensive, practical case study of diagnosing and resolving high‑concurrency performance issues in an SSM‑based e‑commerce system, covering architecture overview, problem identification, root‑cause analysis, JVM/Tomcat/Redis/MySQL tuning, load‑balancing, and post‑optimization monitoring results.

Backend DevelopmentJVM OptimizationPerformance tuning
0 likes · 8 min read
End-to-End Performance Optimization of a High-Concurrency SSM E‑Commerce System
Senior Brother's Insights
Senior Brother's Insights
Aug 19, 2020 · Operations

Essential Ops Lessons: Avoid Disasters with Backups, Monitoring, and Secure Practices

This guide shares hard‑earned lessons from real‑world server administration, emphasizing careful testing, confirming commands before execution, limiting simultaneous operators, always backing up configurations, protecting data, tightening SSH and firewall security, implementing comprehensive monitoring, and applying disciplined performance‑tuning practices to maintain stable, reliable services.

OperationsPerformance tuningSystem Administration
0 likes · 12 min read
Essential Ops Lessons: Avoid Disasters with Backups, Monitoring, and Secure Practices
Java Backend Technology
Java Backend Technology
Aug 11, 2020 · Databases

How I Turned a Half‑Hour SSRS Report into a Sub‑Second Query with a Stored Procedure

The author describes how they transformed a sluggish SSRS report that took over thirty minutes to run into a fast, sub‑second query by analyzing the original SQL, adding missing indexes, avoiding full table scans, and rewriting the logic as a flexible stored procedure, complete with code examples and performance tips.

MESPerformance tuningSQL optimization
0 likes · 24 min read
How I Turned a Half‑Hour SSRS Report into a Sub‑Second Query with a Stored Procedure
Selected Java Interview Questions
Selected Java Interview Questions
Aug 8, 2020 · Databases

MySQL Single‑Table Optimization, Sharding, and Scaling Strategies

This article explains why MySQL tables with massive row counts suffer performance degradation and provides practical guidance on single‑table optimization, field and index design, query tuning, engine selection, system parameters, hardware upgrades, read‑write splitting, caching layers, partitioning, vertical and horizontal sharding, as well as client‑side and proxy‑side sharding solutions.

Database OptimizationMySQLPerformance tuning
0 likes · 26 min read
MySQL Single‑Table Optimization, Sharding, and Scaling Strategies
Big Data Technology Architecture
Big Data Technology Architecture
Aug 8, 2020 · Big Data

Overview of SQL Performance Improvements in Apache Spark 3.0

Apache Spark 3.0 introduces extensive SQL performance enhancements, including a new explain format, expanded join hints, adaptive query execution, dynamic partition pruning, enhanced nested column pruning, improved aggregation code generation, and support for newer Scala and Java versions, all aimed at optimizing query planning and execution.

Adaptive Query ExecutionApache SparkPerformance tuning
0 likes · 14 min read
Overview of SQL Performance Improvements in Apache Spark 3.0
Wukong Talks Architecture
Wukong Talks Architecture
Aug 7, 2020 · Fundamentals

JVM Interview Questions and Java Mind Map Resources

This article presents a comprehensive collection of JVM interview questions covering memory areas, garbage collection, class loading, and performance tuning, along with eleven detailed Java mind‑map images that visually summarize core concepts such as the JVM architecture, GC algorithms, and thread management.

Garbage CollectionInterviewJVM
0 likes · 8 min read
JVM Interview Questions and Java Mind Map Resources
Meituan Technology Team
Meituan Technology Team
Aug 6, 2020 · Backend Development

ZGC: Principles, Tuning Practices, and Production Upgrade Experience

The article explains how Meituan’s risk‑control platform eliminated frequent 40 ms CMS pauses by adopting JDK 11’s ZGC—detailing its concurrent mark‑copy design, practical tuning parameters, real‑world case fixes, and measured latency reductions of up to 74 % while noting trade‑offs.

Garbage CollectionJDK11Java
0 likes · 27 min read
ZGC: Principles, Tuning Practices, and Production Upgrade Experience
Tencent Cloud Developer
Tencent Cloud Developer
Aug 6, 2020 · Big Data

ClickHouse Real‑Time Analytics at QQ Music: Challenges, Solutions, and Tencent Cloud Best Practices

QQ Music replaced its slow Hive warehouse with a massive ClickHouse cluster, achieving sub‑second to ten‑second query latency on petabyte‑scale data, enabling real‑time analytics for non‑technical users, and following five operational best practices—ZooKeeper planning, idempotent writes, sensible partitions, read‑write separation, and localized joins—while leveraging Tencent Cloud’s managed ClickHouse service.

ClickHouseDatabase OptimizationOLAP
0 likes · 24 min read
ClickHouse Real‑Time Analytics at QQ Music: Challenges, Solutions, and Tencent Cloud Best Practices
Programmer DD
Programmer DD
Jul 27, 2020 · Databases

Boost MySQL Performance: Bulk Insert, GROUP BY, ORDER BY, and OR Query Optimizations

This article presents practical MySQL performance tricks, covering bulk data insertion with DISABLE/ENABLE KEYS, loading data in primary‑key order, multi‑value INSERTs, INSERT DELAYED, separating index and data files, GROUP BY sorting elimination, index‑driven ORDER BY, OR‑condition indexing, replacing sub‑queries with JOINs, and using SQL hints such as USE, IGNORE, and FORCE INDEX.

Bulk InsertMySQLPerformance tuning
0 likes · 14 min read
Boost MySQL Performance: Bulk Insert, GROUP BY, ORDER BY, and OR Query Optimizations
Laravel Tech Community
Laravel Tech Community
Jul 25, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps

This article presents a thorough overview of MySQL optimization, covering the query execution process, philosophical principles, risk assessment, required participants, optimization dimensions, commonly used diagnostic tools, emergency and regular tuning procedures, hardware and system level adjustments, as well as detailed configuration parameters for both the server and the database engine.

Database OptimizationMySQLPerformance tuning
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps
MaGe Linux Operations
MaGe Linux Operations
Jul 19, 2020 · Databases

Optimizing Zabbix with MySQL: Version Tips, Permissions, and Partitioning Strategies

This guide details recommended MySQL versions for Zabbix, proper grant statements for read/write and read‑only users, essential MySQL configuration tweaks, SQL techniques for item and function updates, read‑write splitting, upgrade procedures, backup strategies, and comprehensive partition maintenance scripts to improve performance and manage data growth.

MySQLPerformance tuningSQL
0 likes · 14 min read
Optimizing Zabbix with MySQL: Version Tips, Permissions, and Partitioning Strategies
ITPUB
ITPUB
Jul 15, 2020 · Databases

Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization

This guide compiles essential MySQL optimization techniques—including index cardinality, function indexes, EXPLAIN usage, covering indexes, ICP, slow‑query log analysis, online schema changes, and common SQL pitfalls—to help developers efficiently tune database performance.

Database OptimizationEXPLAINIndexes
0 likes · 19 min read
Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization
21CTO
21CTO
Jul 9, 2020 · Databases

How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Efficient Deletion

This article walks through diagnosing severe SLA alerts caused by slow queries on a massive MySQL table, analyzes query patterns with pt‑query‑digest, redesigns indexes, applies online DDL and pt‑osc for index changes, and demonstrates batch‑delete techniques that dramatically reduce execution time and replication lag.

Batch DeleteIndex OptimizationLarge Tables
0 likes · 15 min read
How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Efficient Deletion
Ctrip Technology
Ctrip Technology
Jul 9, 2020 · Backend Development

Lessons from QMQ: Network and Disk I/O Problems and Their Mitigations

The article analyzes real‑world network and disk I/O issues encountered in Qunar Message Queue (QMQ), explains root causes such as Netty OOM, file‑handle exhaustion, TCP timeout handling, and large‑traffic bursts, and presents practical mitigation strategies for backend systems.

Message QueueNetwork IOPerformance tuning
0 likes · 11 min read
Lessons from QMQ: Network and Disk I/O Problems and Their Mitigations
iQIYI Technical Product Team
iQIYI Technical Product Team
Jul 3, 2020 · Artificial Intelligence

Optimizing Video Inference Services for High GPU Utilization in AI Applications

By moving decoding, color conversion, preprocessing, inference, and re‑encoding entirely onto the GPU and enabling batch processing with flexible Python scripts, iQIYI’s video‑image enhancement service achieved ten‑fold throughput, over 90 % GPU utilization, and dramatically lower resource use, accelerating AI video inference deployment.

AI deploymentDeepStreamGPU optimization
0 likes · 14 min read
Optimizing Video Inference Services for High GPU Utilization in AI Applications
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 3, 2020 · Databases

PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices

This article compiles a series of questions and answers from a recent PostgreSQL live session, covering recommended scenarios, differences with Oracle, backup and recovery, clustering, PostGIS, stored procedures, migration tips, version recommendations, performance tuning, high‑availability, and real‑world adoption across industries.

DatabaseOracle migrationPerformance tuning
0 likes · 10 min read
PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices
Efficient Ops
Efficient Ops
Jul 1, 2020 · Databases

Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases

This guide outlines comprehensive MySQL best practices covering naming conventions, table engine and charset choices, field type selection, index design principles, common index column recommendations, ordering of composite indexes, avoidance of redundant and foreign‑key constraints, SQL development rules, and operational guidelines for large‑scale data handling.

Database DesignIndex OptimizationMySQL
0 likes · 21 min read
Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 30, 2020 · Databases

MySQL View Optimization: Fixing Slow Query Caused by Character Set Conversion

This article analyzes a slow MySQL view query caused by mismatched character sets, demonstrates how the automatic charset conversion prevents index usage, and shows step‑by‑step how altering the table charset and removing the conversion restores index usage and reduces execution time from seconds to fractions of a second.

MySQLPerformance tuningSQL optimization
0 likes · 7 min read
MySQL View Optimization: Fixing Slow Query Caused by Character Set Conversion
Java Architect Essentials
Java Architect Essentials
Jun 22, 2020 · Operations

ActiveMQ Message Queue Optimization: Removing Synchronized Lock and Tuning queuePrefetch

This article analyzes a severe ActiveMQ message‑queue backlog caused by a synchronized onMessage listener, then demonstrates how removing the lock and tuning the queuePrefetch parameter, along with a dual‑queue redesign, can boost consumption throughput by over thirty times, eliminating the data pile‑up.

ActiveMQConcurrencyMessage Queue
0 likes · 8 min read
ActiveMQ Message Queue Optimization: Removing Synchronized Lock and Tuning queuePrefetch
Java Captain
Java Captain
Jun 14, 2020 · Databases

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

This article presents comprehensive techniques for improving MySQL performance on large single tables, covering column choices, index design, query writing, engine selection, system parameters, hardware upgrades, read‑write splitting, caching, table partitioning, vertical and horizontal sharding, and guidance on selecting mature sharding solutions.

Database OptimizationMySQLPartitioning
0 likes · 27 min read
MySQL Single‑Table Optimization, Indexing, Partitioning, and Sharding Strategies
Programmer DD
Programmer DD
Jun 13, 2020 · Fundamentals

Mastering Java Garbage Collection: Goals, Tuning, and Collector Choices

This article explains Java HotSpot VM garbage‑collection ergonomics, detailing pause‑time and throughput goals, generational collection mechanics, default heap sizing, and how to select and tune Serial, Parallel, G1, and ZGC collectors for optimal performance.

GC ErgonomicsGarbage CollectionJVM
0 likes · 32 min read
Mastering Java Garbage Collection: Goals, Tuning, and Collector Choices
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 10, 2020 · Backend Development

Elasticsearch Index and Search Optimization Guide

This article provides a comprehensive overview of Elasticsearch architecture and presents practical index and search optimization techniques, configuration recommendations, stress‑testing methods, and monitoring tools to improve cluster performance and reliability.

Cluster ConfigurationElasticsearchPerformance tuning
0 likes · 13 min read
Elasticsearch Index and Search Optimization Guide