BestHub
Sign in
Tagged articles
986 articles
Page 6 of 10
Liangxu Linux
Liangxu Linux
Apr 7, 2022 · Databases

Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More

This comprehensive guide covers MySQL fundamentals including the three normal forms, permission tables, ACID properties, index design principles, SQL statement categories, sharding, deadlock resolution, isolation anomalies, view characteristics, SQL lifecycle, primary key choices, performance troubleshooting, replication, GTID, backup tools, and backup planning.

Database DesignMySQLPerformance tuning
0 likes · 13 min read
Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More
Xiaolei Talks DB
Xiaolei Talks DB
Apr 7, 2022 · Databases

Why Did One Aerospike Node’s XDR Lag So High? Diagnosis and Fix

A single Aerospike node experienced extreme XDR replication lag due to a misconfigured forward setting, and the article walks through terminology, monitoring data, root‑cause analysis, and step‑by‑step commands to resolve the issue and improve cluster performance.

AerospikeDatabase LagNoSQL
0 likes · 11 min read
Why Did One Aerospike Node’s XDR Lag So High? Diagnosis and Fix
Open Source Linux
Open Source Linux
Apr 1, 2022 · Databases

Master MySQL Performance: Deep Dive into Indexes, Explain Plans, and Optimization Techniques

This comprehensive guide explores MySQL's architecture, explains how indexes work, details the use of EXPLAIN to analyze query execution, and provides practical optimization strategies—including index creation, avoiding common pitfalls, and improving single- and multi-table queries—to dramatically boost database performance.

IndexesMySQLPerformance tuning
0 likes · 33 min read
Master MySQL Performance: Deep Dive into Indexes, Explain Plans, and Optimization Techniques
Laravel Tech Community
Laravel Tech Community
Mar 31, 2022 · Databases

SQL Optimization Steps and Common Cases for Improving Query Performance

This article outlines a systematic approach to identifying and fixing slow MySQL queries, explains how to interpret EXPLAIN output and profiling information, and presents multiple real‑world cases illustrating index usage, implicit conversion, large pagination, IN queries, and other optimization techniques.

Database OptimizationExplain PlanMySQL
0 likes · 10 min read
SQL Optimization Steps and Common Cases for Improving Query Performance
Efficient Ops
Efficient Ops
Mar 29, 2022 · Big Data

How Tencent Cloud Boosted APM Metric Computation Speed 2‑3× with Flink Optimizations

This article explains how Tencent Cloud's APM metric calculation, which transforms massive Span data into aggregated metrics using Flink, faced performance bottlenecks and was optimized through job splitting, batch merging, and dimension pruning, ultimately achieving a 2‑3× speed increase and cutting resource usage to about 30% of the original.

APMBig DataFlink
0 likes · 10 min read
How Tencent Cloud Boosted APM Metric Computation Speed 2‑3× with Flink Optimizations
IT Architects Alliance
IT Architects Alliance
Mar 14, 2022 · Big Data

Comprehensive Guide to Kafka Architecture, Core Concepts, and Production Deployment

This article provides an in‑depth overview of Kafka, covering why messaging systems are needed, core concepts, cluster architecture, performance optimizations such as sequential disk writes and zero‑copy, hardware sizing, replication, consumer groups, offset management, rebalance strategies, and practical deployment and operational guidelines.

Big DataCluster DeploymentDistributed Messaging
0 likes · 35 min read
Comprehensive Guide to Kafka Architecture, Core Concepts, and Production Deployment
Sanyou's Java Diary
Sanyou's Java Diary
Mar 14, 2022 · Databases

Why Is My Redis Slowing Down? Comprehensive Diagnosis & Optimization Guide

This article provides a thorough step‑by‑step guide to identify why Redis latency spikes, covering baseline performance testing, slowlog analysis, big‑key handling, expiration patterns, memory limits, fork overhead, huge pages, AOF settings, CPU binding, swap usage, memory fragmentation, network bandwidth, and practical optimization techniques.

DatabaseLatencyOptimization
0 likes · 39 min read
Why Is My Redis Slowing Down? Comprehensive Diagnosis & Optimization Guide
ITPUB
ITPUB
Mar 14, 2022 · Databases

Master MySQL Performance: Practical SQL, Index, Join, and Hardware Tuning

This article provides a comprehensive guide to MySQL performance improvement, covering pagination, index, join, sorting, UNION, slow‑query‑log, schema design, and hardware optimizations with concrete SQL examples, best‑practice tips, and cautionary notes for real‑world deployments.

Database DesignMySQLPerformance tuning
0 likes · 16 min read
Master MySQL Performance: Practical SQL, Index, Join, and Hardware Tuning
Efficient Ops
Efficient Ops
Mar 1, 2022 · Operations

Master Linux Performance: Key Metrics, Tools, and Optimization Techniques

This guide explains Linux performance optimization by defining core metrics such as throughput, latency, and average load, describing how to select and benchmark indicators, outlining essential analysis tools like vmstat, pidstat, and perf, and providing practical CPU and memory tuning strategies to eliminate bottlenecks.

CPULinuxMemory
0 likes · 47 min read
Master Linux Performance: Key Metrics, Tools, and Optimization Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 22, 2022 · Databases

ClickHouse Best Practices: Table Engines, Cluster Architecture, and Operational Guidelines

This guide provides a comprehensive overview of ClickHouse, covering its core use cases, detailed table‑engine choices, cluster design, Zookeeper integration, query and data‑loading best practices, client tools, and key configuration parameters to ensure high performance and reliability in OLAP workloads.

ClickHouseCluster ArchitectureOLAP
0 likes · 23 min read
ClickHouse Best Practices: Table Engines, Cluster Architecture, and Operational Guidelines
政采云技术
政采云技术
Feb 15, 2022 · Big Data

Performance Investigation and Optimization of an Elasticsearch Search Service

This article describes a performance bottleneck in a high‑traffic search service, details the investigation of hardware limits, long‑tail query impact, load‑testing methodology, and the subsequent optimizations—including SSD upgrade, data‑structure reduction, and Elasticsearch segment tuning—that reduced disk I/O and improved throughput.

ElasticsearchPerformance tuningSegment Optimization
0 likes · 11 min read
Performance Investigation and Optimization of an Elasticsearch Search Service
Top Architect
Top Architect
Feb 14, 2022 · Databases

Elasticsearch Fundamentals: Architecture, Indexing, Sharding, and Performance Optimization

This comprehensive guide explains Elasticsearch’s core concepts—including its distributed architecture, indexing process, shard routing, refresh and translog mechanisms, segment merging, and performance tuning—while providing practical examples and configuration tips for building scalable, near‑real‑time search solutions.

ElasticsearchPerformance tuningindexing
0 likes · 35 min read
Elasticsearch Fundamentals: Architecture, Indexing, Sharding, and Performance Optimization
Liangxu Linux
Liangxu Linux
Feb 12, 2022 · Operations

20 Essential Linux Server Performance Tweaks Every Sysadmin Should Know

This guide outlines practical Linux server optimization techniques—from disabling unnecessary daemons and GUI to tuning kernel parameters, file systems, TCP settings, and monitoring tools—helping administrators boost stability, reduce resource usage, and improve overall system performance.

Performance tuningoperating systemserver optimization
0 likes · 14 min read
20 Essential Linux Server Performance Tweaks Every Sysadmin Should Know
ITPUB
ITPUB
Feb 11, 2022 · R&D Management

When Open Source Meets Self‑Development: Lessons from a Decade of R&D

The article shares a senior engineer’s practical experience on combining open‑source and self‑developed components, analysing their advantages, lifecycle stages, and concrete strategies—including problem definition, selection, source‑code control, and ten actionable tips—to help teams balance cost, innovation, and stability.

Performance tuningR&D ManagementTeam Organization
0 likes · 37 min read
When Open Source Meets Self‑Development: Lessons from a Decade of R&D
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 9, 2022 · Databases

Performance Evaluation of Parallel DDL in MySQL 8.0.27

This article investigates how the innodb_ddl_threads, innodb_ddl_buffer_size, and innodb_parallel_read_threads variables introduced in MySQL 8.0.27 affect parallel DDL execution speed and resource consumption, using a 50‑million‑row test table and presenting detailed benchmark results.

Database OptimizationInnoDBMySQL
0 likes · 7 min read
Performance Evaluation of Parallel DDL in MySQL 8.0.27
Alibaba Cloud Developer
Alibaba Cloud Developer
Jan 24, 2022 · Cloud Computing

How to Slash Cold-Start Delays for Spring Boot on Serverless Platforms

This article, part of a series analyzing Serverless platforms for Spring Boot, explains how to diagnose and reduce cold‑start latency, covering tracing, reserved instances, lazy initialization, JVM options, and instance concurrency tuning, using the high‑traffic Mall demo application as a concrete example.

Instance ConcurrencyPerformance tuningServerless
0 likes · 10 min read
How to Slash Cold-Start Delays for Spring Boot on Serverless Platforms
Tencent Qidian Tech Team
Tencent Qidian Tech Team
Jan 18, 2022 · Operations

Unlock Go Performance: Master pprof, trace, GODEBUG, and Escape Analysis

This comprehensive guide explores Go performance optimization techniques, covering pprof profiling, trace analysis, GODEBUG diagnostics, and escape analysis, while providing practical code examples and real‑world case studies to help developers identify and resolve CPU, memory, and goroutine bottlenecks in production services.

Escape AnalysisGODEBUGGo
0 likes · 40 min read
Unlock Go Performance: Master pprof, trace, GODEBUG, and Escape Analysis
Architect
Architect
Jan 7, 2022 · Big Data

Spark Performance Optimization: Principles, Memory Model, Resource Tuning, Data Skew and Shuffle Tuning

This article provides an in‑depth guide to Spark performance optimization, covering the ten development principles, static and unified memory models, resource parameter tuning, data skew detection and mitigation techniques, as well as shuffle‑related configuration adjustments, supplemented with practical code examples and diagrams.

Data SkewMemory ModelPerformance tuning
0 likes · 40 min read
Spark Performance Optimization: Principles, Memory Model, Resource Tuning, Data Skew and Shuffle Tuning
Top Architect
Top Architect
Jan 7, 2022 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑diagnostic utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run them, and shows how to interpret their reports for optimizing database configuration and query performance.

Database ToolsMySQLMySQLTuner
0 likes · 8 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
Xianyu Technology
Xianyu Technology
Jan 4, 2022 · Backend Development

Full GC Diagnosis and Tuning for Xianyu Backend Services

The article details three Xianyu backend incidents where Full GC pauses caused latency spikes or outages, analyzes root causes ranging from survivor space shortage and mis‑tuned CMS to oversized async Log4j events and massive string‑concatenation logs, and presents remediation steps such as switching to G1GC, adjusting Log4j settings, and using parameterized logging to eliminate the pauses.

Full GCGarbage CollectionJVM
0 likes · 23 min read
Full GC Diagnosis and Tuning for Xianyu Backend Services
HomeTech
HomeTech
Dec 24, 2021 · Big Data

Handling java.lang.OutOfMemoryError in Hadoop MapReduce

This article explains the four locations where java.lang.OutOfMemoryError can occur in Hadoop's MapReduce framework—client, ApplicationMaster, Map, and Reduce phases—and provides configuration adjustments and best‑practice solutions to mitigate each type of OOM issue.

HadoopJavaMapReduce
0 likes · 11 min read
Handling java.lang.OutOfMemoryError in Hadoop MapReduce
IT Architects Alliance
IT Architects Alliance
Dec 15, 2021 · Databases

Comprehensive Redis Guide: Data Structures, Commands, Persistence, Performance Tuning, and Deployment Strategies

This article provides a thorough introduction to Redis, covering its core data structures and common commands, persistence options (RDB and AOF), memory‑management and eviction policies, pipelining, transactions and Lua scripting, performance optimization techniques, replication, Sentinel high‑availability, cluster sharding, and a comparison of popular Java clients.

ClusterData StructuresIn-Memory Database
0 likes · 40 min read
Comprehensive Redis Guide: Data Structures, Commands, Persistence, Performance Tuning, and Deployment Strategies
Ctrip Technology
Ctrip Technology
Dec 9, 2021 · Databases

TiDB Operational Practices at Ctrip: Architecture, Use Cases, Performance Tuning, Monitoring, and Tooling

This article details Ctrip's migration from MySQL to TiDB, describing the multi‑data‑center architecture, real‑world use cases such as the international CDP platform and hotel settlement, performance tuning measures, comprehensive monitoring and alerting, auxiliary tools, and future roadmap for the distributed NewSQL database.

HTAPPerformance tuningTiDB
0 likes · 16 min read
TiDB Operational Practices at Ctrip: Architecture, Use Cases, Performance Tuning, Monitoring, and Tooling
Open Source Linux
Open Source Linux
Nov 28, 2021 · Operations

Boost Linux Server Performance: 20 Proven Optimization Techniques

This guide presents twenty practical Linux server optimization methods—from kernel elevator tuning and daemon reduction to TCP tweaks, secure backups, and effective monitoring commands—helping administrators enhance reliability, speed, and security while reducing resource consumption.

LinuxPerformance tuningSecurity
0 likes · 14 min read
Boost Linux Server Performance: 20 Proven Optimization Techniques
Full-Stack DevOps & Kubernetes
Full-Stack DevOps & Kubernetes
Nov 25, 2021 · Cloud Native

Supercharge Jenkins Builds: Tune Pod Resources and Enable Parallel Stages

This guide explains why default Jenkins slave pods often suffer from slow builds or memory shortages, and provides concrete steps—adjusting CPU/memory limits, trimming plugins, using private artifact stores, disabling workspace cleanup, and configuring parallel stages—to dramatically improve Jenkins performance on Kubernetes.

JenkinsKubernetesParallel Stages
0 likes · 4 min read
Supercharge Jenkins Builds: Tune Pod Resources and Enable Parallel Stages
StarRocks
StarRocks
Nov 24, 2021 · Big Data

Building a Scalable OLAP Platform at SF Express: StarRocks Evaluation and Lessons

SF Express’s data engineering team details how they migrated from a mixed‑component OLAP stack to a unified StarRocks platform, describing the evaluation criteria, performance‑critical design choices, import and query optimizations, and future roadmap for a high‑availability, low‑cost big‑data analytics solution.

Big DataOLAPPerformance tuning
0 likes · 14 min read
Building a Scalable OLAP Platform at SF Express: StarRocks Evaluation and Lessons
Java Architect Essentials
Java Architect Essentials
Nov 17, 2021 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑tuning utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download, install, and run them, and shows how to interpret their diagnostic reports to identify configuration issues and optimize database performance.

Database ToolsMySQLPerformance tuning
0 likes · 9 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
Architect
Architect
Nov 10, 2021 · Fundamentals

Deep Dive into JVM: Class Loading, Memory Management, Debugging, Hot Deployment, and Performance Tuning

This comprehensive article explains the inner workings of the Java Virtual Machine, covering class file structure, class loaders, memory layout, garbage collection, execution engine, debugging via JPDA, hot deployment, hot swapping, and performance tuning techniques, providing practical code examples and configuration tips.

DebuggingJVMPerformance tuning
0 likes · 74 min read
Deep Dive into JVM: Class Loading, Memory Management, Debugging, Hot Deployment, and Performance Tuning
Su San Talks Tech
Su San Talks Tech
Nov 8, 2021 · Fundamentals

Mastering JVM Memory: Layout, GC Algorithms, and Tuning Tips

This comprehensive guide explains the JVM memory layout, class‑loading and object‑creation process, the parent‑delegation model, various garbage‑collection algorithms and collectors, GC roots, triggers for YGC and Full GC, and practical tuning parameters to improve Java application performance.

Garbage CollectionJVMPerformance tuning
0 likes · 15 min read
Mastering JVM Memory: Layout, GC Algorithms, and Tuning Tips
JavaEdge
JavaEdge
Oct 29, 2021 · Databases

Mastering MySQL: Normal Forms, Storage Engines, Indexes, Transactions, and Optimization

This comprehensive guide covers MySQL fundamentals such as the three normal forms, differences between InnoDB and MyISAM, auto‑increment primary key behavior, index types and design principles, transaction isolation levels, MVCC, logging mechanisms, two‑phase commit, query execution, replication, high‑availability architectures, and practical performance tuning techniques.

Database IndexesInnoDBMySQL
0 likes · 39 min read
Mastering MySQL: Normal Forms, Storage Engines, Indexes, Transactions, and Optimization
vivo Internet Technology
vivo Internet Technology
Oct 27, 2021 · Backend Development

JVM Garbage Collection Tuning for a Video Service to Reduce P99 Latency

By replacing the default Parallel GC with a ParNew‑CMS collector, enlarging the Young generation, fixing Metaspace settings, and tuning CMS occupancy thresholds, the video service cut Young and Full GC pauses dramatically, lowered Full GC count by over 80%, and achieved more than 30% P99 latency reduction, with some APIs improving up to 80%.

CMSGarbage CollectionJVM
0 likes · 16 min read
JVM Garbage Collection Tuning for a Video Service to Reduce P99 Latency
Liangxu Linux
Liangxu Linux
Oct 17, 2021 · Databases

Why MySQL Eats CPU and How to Slash Its Usage

This article explains which components—user processes, I/O wait, and system interrupts—consume most CPU in MySQL, describes the performance impact of high CPU, and provides concrete strategies such as reducing I/O, simplifying calculations, optimizing indexes, and judiciously scaling hardware to lower CPU usage.

CPU optimizationDatabaseIO Wait
0 likes · 6 min read
Why MySQL Eats CPU and How to Slash Its Usage
Big Data Technology Architecture
Big Data Technology Architecture
Oct 14, 2021 · Databases

Performance Evaluation and Optimization of HBase 2.x Write Operations

This article presents a detailed performance test of HBase 2.x write throughput on a five‑node SSD cluster, identifies latency spikes caused by MemStore flush and ConcurrentSkipListMap size() overhead, and demonstrates how fixing the bug and applying in‑memory compaction dramatically reduces P999 and P9999 latency while preserving throughput.

HBaseIn-Memory CompactionMemStore
0 likes · 10 min read
Performance Evaluation and Optimization of HBase 2.x Write Operations
Liangxu Linux
Liangxu Linux
Sep 26, 2021 · Operations

Master Linux Swap: When, How Much, and How to Optimize Performance

This guide explains what Linux swap is, its advantages and drawbacks, how to size it for different memory configurations, and provides step‑by‑step commands for creating, managing, and tuning swap partitions or files, including swappiness and ZFS considerations.

Performance tuningSwapSystem Administration
0 likes · 15 min read
Master Linux Swap: When, How Much, and How to Optimize Performance
Wukong Talks Architecture
Wukong Talks Architecture
Sep 23, 2021 · Backend Development

Comprehensive JVM Garbage Collection Interview Questions and Answers

This article compiles a series of JVM interview questions covering heap partitioning, garbage‑collection algorithms, collector types, memory coordination, tuning strategies, and practical tooling such as jstat, jmap, and MAT, providing detailed explanations and command‑line examples for each topic.

Garbage CollectionInterviewJVM
0 likes · 27 min read
Comprehensive JVM Garbage Collection Interview Questions and Answers
DevOps Cloud Academy
DevOps Cloud Academy
Sep 21, 2021 · Operations

Practical Elasticsearch Operations and Performance Tuning Guide

This article extends previous Elasticsearch cheat sheets with practical commands and step‑by‑step instructions for shard allocation, replica adjustment, cluster settings, slow‑log configuration, mapping routing, force merge, bulk writes, refresh intervals, translog durability, heap sizing, disk‑space monitoring, and troubleshooting strategies.

Cluster ManagementElasticsearchOperations
0 likes · 7 min read
Practical Elasticsearch Operations and Performance Tuning Guide
Programmer DD
Programmer DD
Sep 21, 2021 · Backend Development

Why Adding More Dubbo Connections Doesn’t Always Boost Throughput

This article examines Dubbo’s connection‑control feature, demonstrates how long‑living TCP connections are created, runs benchmark tests with one and two connections, discovers that varying IO thread counts skew results, and shows that increasing connections alone rarely improves throughput.

BenchmarkConnection ControlDubbo
0 likes · 14 min read
Why Adding More Dubbo Connections Doesn’t Always Boost Throughput
Architect
Architect
Sep 9, 2021 · Fundamentals

Understanding JVM Memory Structure: Areas, Allocation, and Tuning

This article provides a comprehensive overview of the Java Virtual Machine memory layout, explaining each region such as the heap, metaspace, stack, program counter, direct memory and code cache, along with allocation strategies, tuning parameters, and practical OOM demonstrations.

Garbage CollectionHeapJVM
0 likes · 16 min read
Understanding JVM Memory Structure: Areas, Allocation, and Tuning
MaGe Linux Operations
MaGe Linux Operations
Sep 8, 2021 · Cloud Native

How to Scale Kubernetes Clusters: Quotas, Kernel Tweaks, and Best Practices

This guide outlines essential steps for scaling large Kubernetes clusters on public clouds, covering node quota adjustments, kernel parameter tuning, etcd high‑availability setup, API server and pod configurations, and best‑practice recommendations to ensure stable performance as node counts grow.

KubernetesPerformance tuningcluster scaling
0 likes · 7 min read
How to Scale Kubernetes Clusters: Quotas, Kernel Tweaks, and Best Practices
High Availability Architecture
High Availability Architecture
Aug 31, 2021 · Cloud Native

High‑Availability Architecture for etcd in Ant Group’s Massive Kubernetes Clusters

The article describes how Ant Group operates a world‑largest Kubernetes deployment of over 10,000 nodes, details the performance challenges of the etcd key‑value store at such scale, and outlines a comprehensive set of hardware upgrades, configuration tuning, monitoring, data‑splitting, and future distributed‑etcd strategies to achieve robust high‑availability.

Performance tuningetcdscale-out
0 likes · 21 min read
High‑Availability Architecture for etcd in Ant Group’s Massive Kubernetes Clusters
FunTester
FunTester
Aug 20, 2021 · Databases

Why Is One MySQL CPU Core at 99%? A Step‑by‑Step Troubleshooting Guide

During a performance test a MySQL server showed one CPU core constantly at 99% while the others were idle, prompting a detailed investigation that checks I/O thread settings, multi‑core utilization, transaction locks, slow‑query logging, and index optimization to resolve the bottleneck.

Database OptimizationInnoDBMySQL
0 likes · 6 min read
Why Is One MySQL CPU Core at 99%? A Step‑by‑Step Troubleshooting Guide
MaGe Linux Operations
MaGe Linux Operations
Aug 19, 2021 · Cloud Native

Mastering Kubernetes Scheduling: From Basics to Performance Tuning

This article provides a comprehensive guide to Kubernetes Scheduler, covering its architecture, extension points, API, node affinity, taints and tolerations, scheduling bottlenecks, priority classes, and performance tuning techniques to optimize pod placement in large clusters.

KubernetesNode AffinityPerformance tuning
0 likes · 13 min read
Mastering Kubernetes Scheduling: From Basics to Performance Tuning
21CTO
21CTO
Aug 16, 2021 · Databases

Why LIMIT with Large Offsets Slows MySQL and How to Fix It

This article explains why MySQL queries using LIMIT with a large offset become extremely slow, demonstrates the inefficiency through a 950‑million‑row table example, and shows how rewriting the query with a sub‑select join reduces execution time from seconds to milliseconds while preserving results.

InnoDBMySQLPerformance tuning
0 likes · 9 min read
Why LIMIT with Large Offsets Slows MySQL and How to Fix It
Top Architect
Top Architect
Aug 14, 2021 · Big Data

Elasticsearch Overview: Architecture, Core Concepts, and Performance Optimization

This article provides a comprehensive introduction to Elasticsearch, covering its underlying Lucene-based inverted index, data types, shard routing, cluster roles, discovery mechanisms, refresh and translog handling, segment merging, and practical performance and JVM tuning tips for building scalable, near‑real‑time search systems.

ElasticsearchPerformance tuningSharding
0 likes · 35 min read
Elasticsearch Overview: Architecture, Core Concepts, and Performance Optimization
MaGe Linux Operations
MaGe Linux Operations
Aug 11, 2021 · Databases

Understanding Cloud MySQL: Instance Types, Replication Modes, and High Availability

This article explains the different Cloud MySQL instance architectures, details asynchronous, semi‑synchronous, and strong synchronous replication, describes high‑availability failover mechanisms, outlines upgrade procedures, and covers binlog usage, rollback methods, slow‑query optimization, and storage fragmentation.

Instance TypesMySQLPerformance tuning
0 likes · 11 min read
Understanding Cloud MySQL: Instance Types, Replication Modes, and High Availability
ITPUB
ITPUB
Aug 11, 2021 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

This guide introduces four practical MySQL performance‑tuning utilities—MySQLTuner, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run, and interpret their reports to identify configuration issues, memory overload, and slow‑query problems.

MySQLMySQLTunerPerformance tuning
0 likes · 8 min read
Boost MySQL Performance: Essential Tools and How to Use Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 11, 2021 · Databases

Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors

The article explains why MySQL can hit the max_connections limit, introduces the MySQL 8.0 administrative connection interface and its configuration variables, demonstrates how to create a privileged user and test connection limits with code examples, and offers best‑practice recommendations to prevent connection saturation.

Administrative Connection InterfaceConnection PoolingDatabase Administration
0 likes · 9 min read
Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 7, 2021 · Big Data

Elasticsearch Optimization Practices and Performance Tuning Guide

This article presents a comprehensive guide on optimizing Elasticsearch for large‑scale data platforms, covering Lucene fundamentals, index and shard architecture, doc‑values usage, routing strategies, practical performance‑tuning techniques, and real‑world testing results to achieve sub‑second query responses on billions of records.

ElasticsearchIndex OptimizationPerformance tuning
0 likes · 12 min read
Elasticsearch Optimization Practices and Performance Tuning Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 5, 2021 · Backend Development

Deep Dive into JVM Tuning: Lessons from "Understanding the JVM" (3rd Edition)

The article shares the author’s experience reading the third edition of "Understanding the JVM," focusing on JVM memory management, garbage‑collection algorithms, tuning strategies, and practical tools, while providing concise summaries of each book section and actionable advice for Java performance optimization.

Garbage CollectionJDK toolsJVM
0 likes · 15 min read
Deep Dive into JVM Tuning: Lessons from "Understanding the JVM" (3rd Edition)
Tencent Architect
Tencent Architect
Aug 4, 2021 · Artificial Intelligence

How We Accelerated Feature Hashing for Ad Ranking on GPUs

This article explains how Tencent's Light platform reduced the massive overhead of feature hashing in ad‑ranking by moving integer‑to‑string conversion and hash computation to the GPU, introducing custom contiguous string tensors, and achieving up to 12× speed‑up on V100 GPUs.

GPU optimizationMachine LearningPerformance tuning
0 likes · 14 min read
How We Accelerated Feature Hashing for Ad Ranking on GPUs
Open Source Linux
Open Source Linux
Aug 1, 2021 · Databases

Why Is MySQL Consuming CPU? Identify and Reduce CPU Bottlenecks

This article explains which components (user processes, IO wait, system interrupts) consume CPU in MySQL, shows their impact on performance, and provides practical strategies to reduce CPU usage through IO optimization, query tuning, data modeling, caching, and hardware upgrades.

CPU BottleneckDatabase OptimizationIO Wait
0 likes · 6 min read
Why Is MySQL Consuming CPU? Identify and Reduce CPU Bottlenecks
ITPUB
ITPUB
Jul 28, 2021 · Databases

Master MySQL Performance: Essential SQL Optimization Techniques & Index Strategies

This comprehensive guide walks you through MySQL performance tuning, covering how to monitor server status, identify slow queries, use EXPLAIN for execution plans, create and manage various index types, and apply practical SQL optimizations such as import tricks, insert batching, efficient GROUP BY/ORDER BY, and pagination improvements.

EXPLAINIndexesMySQL
0 likes · 25 min read
Master MySQL Performance: Essential SQL Optimization Techniques & Index Strategies
Java Architect Essentials
Java Architect Essentials
Jul 25, 2021 · Backend Development

How I Cut Full GC Frequency by 80%: A JVM Tuning Case Study

Over a month of systematic JVM tuning reduced Full GC from 40 times per day to once every ten days and halved Young GC duration by adjusting heap sizes, survivor ratios, and metaspace settings while investigating and fixing a memory leak caused by an anonymous inner class listener.

Garbage CollectionJVMMemory Leak
0 likes · 10 min read
How I Cut Full GC Frequency by 80%: A JVM Tuning Case Study
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
Python Crawling & Data Mining
Python Crawling & Data Mining
Jul 18, 2021 · Databases

How Indexing Can Slash Oracle Query Time from Minutes to Seconds

This article examines a real‑world Oracle SQL query, identifies costly full‑table scans and low‑selectivity columns, and demonstrates how creating an index on a key column reduces execution time from 24 minutes to just one second, highlighting essential SQL performance‑tuning techniques.

AWRDatabase OptimizationOracle
0 likes · 7 min read
How Indexing Can Slash Oracle Query Time from Minutes to Seconds
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.

LinuxPerformance tuningTCP
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.

LinuxPerformance tuningServer Configuration
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.

Full GCGarbage CollectionJVM
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
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 DesignIndexesMySQL
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 DevelopmentConcurrencyJava
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 ConfigurationMySQLPerformance tuning
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.

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

JVMPerformance tuningTomcat
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.

CheckpointFlinkPerformance tuning
0 likes · 18 min read
Flink Performance Tuning Guide: Memory Configuration, Parallelism, Checkpoint Optimization, and Common Issues