This article explains how Redis introduced Lua scripting to combine multiple commands atomically, covers Lua basics, data types, control structures, script execution with EVAL/EVALSHA, script management commands, and practical tips for writing efficient, safe Redis Lua scripts.
This article explains the various MySQL index implementations—including B‑Tree, B+Tree, hash, clustered, non‑clustered, and covering indexes—illustrates their internal structures with diagrams, provides SQL examples, and offers practical guidelines for selecting and using indexes efficiently.
To eliminate Xianyu’s Weex pages’ long white-screen delays, the team identified large bundles, slow first-screen data requests, and heavy UI as root causes and applied offline bundle caching, data prefetching, progressive and on-demand rendering, and bundle slimming, cutting first-screen load to under two seconds on low-end phones and achieving near-instant display on higher-end devices.
This article provides an in‑depth tutorial on Glide 4.11, covering its basic usage, the four‑step decode task startup, six‑step image loading flow, caching mechanisms, initialization process, and extensive configuration options for Android developers.
A detailed investigation of a slow Elasticsearch cluster revealed that massive Stop‑The‑World (STW) safepoint pauses caused by a buggy ARM‑based JDK version were the root cause, and switching to a proper Kona JDK eliminated the frequent ForceSafepoint interruptions and restored performance.
This article revisits memory allocation and reclamation concepts by examining Java's Netty memory pool implementation, its theoretical basis in jemalloc, and practical design choices such as arena allocation, thread‑local caches, pool chunks, sub‑pages, and multi‑threaded performance considerations.
This article analyzes common questions about Netty‑based push services, presents a real‑world IoT case study, and provides detailed design guidelines—including kernel tuning, connection handling, heartbeat configuration, buffer management, memory pooling, logging pitfalls, TCP and JVM tuning—to help engineers build stable, scalable, and high‑performance million‑connection push systems.
This article examines the YYCache iOS library, covering its multi‑level architecture, LRU implementation, thread‑safe APIs, eviction policies, lock choices, disk‑storage strategies, Swift integration, performance benchmarks, and practical takeaways for building high‑performance mobile caches.
ClickHouse is a PB‑scale, open‑source columnar OLAP database that uses a ZooKeeper‑coordinated sharded cluster, columnar storage, vectorized execution, advanced compression, data‑skipping indexes, and materialized views to deliver high‑performance interactive analytics, yet it requires manual shard management, lacks a mature MPP optimizer, and handles real‑time single‑row writes poorly.
This guide details a systematic approach to diagnosing Java service failures by sequentially checking CPU, disk, memory, and network issues, using tools like ps, top, jstack, jstat, iostat, jmap, and netstat to pinpoint root causes and apply appropriate fixes.
This article explains why MySQL's default InnoDB storage engine uses B+ trees instead of B trees or hash indexes, covering storage engine basics, query performance, I/O considerations, and the structural advantages that make B+ trees ideal for OLTP workloads.
This article benchmarks Java's ArrayList and LinkedList by measuring insertion and lookup times at the head, tail, and middle of a list with 100,000 elements, then explains the underlying source‑code mechanisms that cause the observed performance differences.
This article examines MySQL pagination on a multi‑million‑row table, compares plain LIMIT queries with subquery, ID‑range, and temporary‑table techniques, provides SQL examples and performance measurements, and offers recommendations for fast, scalable paging.
The article outlines five common performance problems affecting Salesforce SaaS deployments—location latency, bandwidth competition from multimedia traffic, low‑quality bandwidth, ineffective caching, and heavy plugin usage—and provides practical mitigation strategies for IT teams to ensure reliable user experiences.
This article presents a series of Java Stream API performance experiments—comparing serial and parallel streams on primitive, object, and reduction tasks—showing that while serial streams are slower than traditional loops for simple operations, parallel streams can significantly outperform both in multi‑core environments.
This article provides a comprehensive overview of Redis interview topics, covering persistence mechanisms, cache avalanche and penetration problems, hot and cold data concepts, differences from Memcached, single‑thread performance, data structures, expiration policies, clustering solutions, distributed locks, transactions, and practical troubleshooting tips.
The article details a real‑world investigation of a Java HTTP service that experienced a sudden QPS increase and response‑time spikes, tracing the issue through database queries, local method latency, CPU load, frequent ParNew GCs, and large response payloads, and presents concrete remediation steps.
An in‑depth guide explains Guava’s Stopwatch utility, showing how to create, start, stop, and reset timers, customize the time source via Ticker, compare it with raw System.nanoTime or System.currentTimeMillis, and highlights its advantages for accurate performance measurement in Java and Android projects.
These Java performance optimization guidelines cover best practices such as appropriate use of singletons, minimizing static variables, reducing object creation, leveraging final modifiers, preferring local variables, efficient handling of collections, avoiding costly operations like synchronized blocks and split, and proper resource management to improve application efficiency.
This article compiles a comprehensive list of frequent Vue development challenges when building WeChat mini‑programs—covering routing parameters, cross‑origin requests, Axios encapsulation, UI library on‑demand loading, scoped CSS overrides, timer cleanup, responsive rem handling, Swiper integration, source‑map suppression, gzip compression, bundle analysis, lazy loading, keep‑alive caching, v‑model customization, mixins, and deployment considerations.
This article details Youzan’s testing team’s evolving API automation strategy, covering architectural context, dual‑approach request simulation, regression efficiency enhancements, blind‑spot elimination through online validation and traffic recording‑replay, and practical lessons for large‑scale product delivery.
This article investigates whether Java reflection impacts performance by running systematic benchmarks that compare direct method calls, reflective method calls, direct field access, and reflective field access across varying iteration counts, presenting detailed results, analysis of the slow paths, and practical guidelines to mitigate any overhead.
The article examines the difficulties of reusing SQL Server stored procedures to obtain simple boolean checks, illustrates a concrete example of counting jobs with temporary tables, discusses maintenance pitfalls, and concludes that business logic is often better implemented outside stored procedures.
This article explains the design and implementation of a Java‑based fixed QPS load‑testing framework, covering its multithreaded base class, concurrent executor, compensation thread, performance metrics collection, and provides source code links for practical use and further development.
The article explains how Kafka implements a hierarchical time‑wheel—a ring of bucket sets with a map for O(1) insertion, removal and expiration—to replace costly per‑tick scans, enabling efficient management of millions of delayed tasks across multiple timeout layers.
A concise collection of Linux command‑line snippets helps you query Oracle client IPs, kill specific processes, count connections, summarize traffic, find large files, measure copy time, and monitor CPU and memory usage, all useful for DB and system administrators.
This comprehensive guide explains what Redis is, its data structures and features, demonstrates how to use Redis as a cache in Spring Boot applications, discusses cache eviction policies, persistence mechanisms, replication, Sentinel high‑availability, and performance characteristics while also covering common interview questions such as cache snowball, penetration and breakdown.
This article explains the internal structure and algorithms of Java’s HashMap, covering its array‑based storage, collision handling with linked lists and red‑black trees, key methods like put, get, resize, and thread‑safety considerations, complete with code examples and diagrams.
This article presents a systematic benchmark of Java reflection versus direct method and field access, analyzes the measured latency across varying call counts, identifies the costly operations within reflection (such as getMethod, getDeclaredField, invoke, and set), and offers practical guidelines to mitigate reflection‑induced performance overhead.
This comprehensive guide explains what software architecture is, distinguishes systems, subsystems, modules, components, and frameworks, outlines architecture layers and classifications, describes strategic versus tactical design, tracks the evolution from monoliths to micro‑services, and highlights how to evaluate and avoid common architectural pitfalls.
This article systematically compares Redis and Memcached across thread models, supported data structures, eviction strategies, pipelining, transactions, persistence, high‑availability mechanisms, and clustering, helping developers choose the most suitable in‑memory database for their specific workload requirements.
This article presents a comprehensive guide to MySQL performance tuning, covering the use of EXPLAIN, proper handling of IN clauses, selective column queries, limit usage, index best practices, avoiding costly operations, pagination techniques, full‑text search, join optimization, and advanced directives such as FORCE INDEX and STRAIGHT_JOIN.
This article explains how JD Cloud’s JCHDB, built on ClickHouse, achieves millisecond‑level queries on billions of rows through columnar storage, distributed multi‑master architecture, SIMD vector engine, sparse indexing, and specialized table engines, and outlines the ideal use cases and deployment details.
Understanding Linux load average and CPU utilization, this guide explains process states, how load is calculated, the difference between load and CPU usage, common bottlenecks, and practical troubleshooting steps using tools like top, vmstat, pidstat, iostat, and perf to pinpoint performance issues.
This article presents a detailed comparison between Swift and Objective‑C, covering language popularity, community activity, real‑world app adoption, performance benchmarks, Swift's advantages and disadvantages, ABI and module stability, Apple’s strategic support, binary size effects, and deep compiler optimizations such as SIL, inlining, generic specialization, and dispatch mechanisms.
This article analyzes common database performance bottlenecks such as I/O and CPU limits, explains horizontal and vertical sharding techniques, reviews available sharding tools, discusses the challenges of distributed transactions, cross‑node joins, pagination, and global primary‑key generation, and offers practical mitigation strategies.
This article examines the challenges of running Spark on Kubernetes, introduces the Remote Shuffle Service architecture to overcome shuffle bottlenecks, details EMR on ACK integration, showcases performance gains with Terasort benchmarks, and outlines future cloud‑native big‑data strategies such as mixed‑cluster and serverless deployments.
This article presents a comprehensive Q&A guide for developers covering MySQL index structures, transaction principles, table schema design, storage engine choices, and various practical issues such as char vs varchar, binlog formats, large pagination, and stored procedures.
This article provides a systematic, step‑by‑step guide for diagnosing and resolving Java runtime problems—including CPU spikes, memory leaks, disk I/O bottlenecks, network timeouts, and GC inefficiencies—by using native Linux tools and JVM utilities such as top, ps, jstack, jmap, jstat, iostat, vmstat, pidstat, netstat, ss, and tcpdump.
This article examines why naïve LIMIT‑OFFSET pagination on a multi‑million‑row MySQL table becomes increasingly slow, presents several optimization techniques—including simple LIMIT usage, sub‑query id lookup, ID‑range queries, and temporary‑table tricks—along with concrete benchmark results to guide developers toward faster data paging.
This article introduces Redis's advanced bitmap capabilities, detailing the SETBIT, GETBIT, BITCOUNT, and BITOP commands, their syntax, underlying SDS data structure, performance characteristics, storage calculations, and practical use cases such as user sign‑in tracking and online status monitoring.
This article explains why restoring MySQL backups can fail due to missing SUPER privileges, describes the DEFINER and SQL SECURITY concepts, and details how the mysqldump source code was altered for MySQL 5.7 to strip DEFINER clauses, show backup progress, and improve performance testing.
Unity has launched the public beta of version 2020.2, introducing significant performance boosts, C# 8 support, enhanced editor workflows, and numerous rendering and optimization upgrades, while also outlining future plans for Unity 2021 and the upcoming 2020 LTS release.
The article explains how Redis caching boosts high‑concurrency applications by outlining common use cases such as counters, session storage, rate limiting, leaderboards and distributed locks, then details best‑practice guidelines, typical pitfalls like TTL overwrites and cache stampedes, and essential monitoring techniques for performance and reliability.
By tracking the discrepancy between the number of EngineLayer objects actually rendered each frame and the total EngineLayer instances retained in native memory, developers can detect and pinpoint Flutter memory leaks caused by lingering Dart references, using SceneBuilder monitoring and WeakPersistentHandle inspection.
A high‑traffic Java backend service suddenly suffered seconds‑long response times, prompting a systematic investigation that traced the issue from unexpected QPS spikes through database checks, local call delays, CPU load, and frequent ParNew GC, ultimately revealing oversized responses and memory pressure as the root cause.
This article explains why Redis latency can suddenly increase—covering high‑complexity commands, large keys, concentrated expirations, memory limits, fork overhead, CPU binding, AOF settings, swap usage, and network saturation—and provides practical diagnostic steps and mitigation techniques.
The article introduces Facebook's HipHop VM (HHVM) as a PHP JIT compiler, highlights the performance gains and memory savings, details the release of version 4.75 with its supported versions, and outlines new highlights and upcoming deprecations such as the removal of is_array().
Database read/write separation, alongside sharding and master‑slave architectures, mitigates high‑concurrency bottlenecks by distributing reads to replicas and writes to a primary, offering scalability and performance benefits while introducing challenges such as replication lag, routing complexity, and resource utilization trade‑offs.
This article reviews Java WebSocket options—including the Java EE specification, SockJS, Socket.IO, and reactive stream implementations—detailing their advantages, drawbacks, and performance characteristics, and provides benchmark data to help developers choose the most suitable solution for their backend communication needs.
This article explains why a high‑performance Redis instance can suddenly experience high latency, covering complex commands, large keys, expiration bursts, memory limits, fork overhead, CPU binding, AOF settings, swap usage, and network saturation, and provides practical troubleshooting and mitigation steps.
This article demonstrates how to create a test database, export data with mysqldump, and then replay a large SQL dump into a busy MySQL instance while throttling the import speed with the pv tool to keep CPU usage low and avoid disrupting ongoing business operations.
This article examines several production incidents where using SELECT * caused dramatic performance degradation in Oracle databases, detailing shadow‑table differences, LOB handling, temporary‑table transformations, wide‑table scans, and memory‑intensive joins, and explains why the rule to avoid SELECT * is essential.
This article benchmarks Java's Fork/Join framework, Parallel Streams, and ExecutorService across IO‑bound and CPU‑bound workloads on an 8‑core machine, analyzing how thread count and pool configuration affect performance and offering practical recommendations for concurrent Java applications.
This article explains Java reflection, describing its ability to inspect and modify classes at runtime, the core reflection classes, practical use cases, performance considerations, and provides comprehensive code examples that demonstrate class, method, field, and interface introspection.
This article demonstrates how the open‑source Java diagnostic tool Arthas can be employed in various production scenarios—such as CPU spikes, class‑loading conflicts, method‑level monitoring, performance bottlenecks, and hot‑code replacement—to rapidly locate and resolve runtime problems without restarting services.
This article explores MySQL performance limits, concurrency settings, query‑time best practices, table design choices, index classifications, and a comprehensive set of SQL optimizations—including batch processing, operator rewrites, and pagination tricks—to help developers eliminate slow queries and build scalable database solutions.
This article investigates whether Java reflection impacts performance by conducting systematic benchmarks that compare direct method/field access with reflective calls, analyzing the measured overhead, identifying the costly reflection operations, and offering practical guidelines to mitigate any performance penalties.
This article introduces ClickHouse as an OLAP columnar database, compares its storage model with row‑based databases, details migration from MySQL, presents performance benchmarks showing query speeds under one second for 50 million rows, and shares practical deployment tips and pitfalls.
This article explains the InnoDB logical storage hierarchy of segments, extents, and pages, then details MySQL horizontal partitioning concepts, types (RANGE, LIST, HASH, KEY), example DDL and DML, and discusses how partitioning impacts performance for OLTP and OLAP workloads.
To accurately benchmark and reduce end-to-end latency on large live-streaming platforms, this article details practical measurement frameworks for both HTTP-FLV—using custom SEI timestamps and cloud-synced clocks—and WebRTC—leveraging RTCPeerConnection stats to dissect uplink, server, jitter, decoding, and render delays.
Although Docker has become popular for containerizing applications, this article outlines seven key drawbacks—ranging from data safety and performance to networking, statefulness, resource isolation, cloud platform incompatibility, and hardware demands—that make deploying databases in Docker containers generally unsuitable.
This article describes how the WeChat Pay team rebuilt the client‑side payment flow using a C++ cross‑platform framework, detailing the architectural redesign, performance improvements, routing mechanism, network request handling, and data‑flow safeguards that unified iOS and Android implementations while reducing code size and enhancing reliability.
This article walks through designing and implementing a lightweight front‑end monitoring platform that captures JavaScript runtime and compile‑time errors, Promise rejections, resource loading failures, and network request issues, while also recording user interactions, page navigation, and environment details using modular code and browser APIs.
Streaming ZIP decompression enables extracting files while downloading, eliminating the need to fetch the entire archive; by leveraging Local File Header metadata and supporting both traditional and AES encryption, this technique dramatically reduces latency, as demonstrated by Youku’s 0.91‑second load for 30 MB books.
This guide explains how to identify Nginx bottlenecks, apply a series of configuration and kernel tweaks—including worker processes, event model, connection limits, gzip, proxy timeouts, and sysctl settings—and then validate the improvements with Apache ab load testing to achieve up to 100 000 concurrent requests.
This comprehensive guide explains how to start, stop, and configure Apache HTTP on Windows and UNIX, covering default ports, key configuration files, version checking, security hardening, logging, virtual hosts, proxy setup, performance tuning, and common troubleshooting techniques.
This article examines a real flash‑sale incident where Redis distributed locks expired, causing overselling, analyzes the root causes such as lock safety and non‑atomic stock checks, and presents safer lock implementations, atomic stock operations, and architectural reflections to prevent future failures.
This article presents a collection of common Java coding pitfalls—such as using 'where 1=1' in MyBatis, inefficient Map iteration, improper collection checks, and suboptimal string handling—and provides concise, performance‑oriented best‑practice alternatives with code examples.
This article provides a comprehensive guide to upgrading Apache Kafka across multiple versions, detailing rolling upgrade procedures, configuration adjustments, protocol changes, new features, deprecations, and performance considerations for Kafka brokers, producers, consumers, and Kafka Streams applications.
UI testing ensures that a website’s interface functions correctly and delivers a smooth user experience, covering manual and automated approaches, cross‑browser compatibility, exploratory and scripted techniques, and performance considerations, illustrated with real‑world ticket‑booking examples and practical Selenium automation benefits.
This article explains how Suning's big‑data center leverages ClickHouse’s columnar OLAP engine and a full‑chain monitoring platform to achieve real‑time query tracing, slow‑query analysis, cluster health checks, and resource‑level alerts across diverse business scenarios.
The article introduces Offline Prerender (OPR), explains why traditional SSR and SPA first‑screen optimizations have limitations, details the OPR workflow—including scheduled Puppeteer rendering, HTML capture, data injection, diffing, CDN upload, and delayed mounting—and shares practical enhancements such as CSS tree‑shaking, async script loading, and downgrade strategies, demonstrating significant speed gains.
This article provides a detailed guide to various Java lock types—including optimistic, pessimistic, spin, reentrant, read‑write, fair, unfair, shared, exclusive, heavyweight, lightweight, biased, segment, mutex, synchronization, deadlock, lock coarsening, and lock elimination—explaining their principles, typical usages, advantages, disadvantages, and related JVM optimizations.
This article explains how to tune Java ThreadPoolExecutor parameters—including corePoolSize, maxPoolSize, keepAliveTime, and queue length—for both CPU‑bound and IO‑bound workloads, offering practical formulas, example calculations, and a step‑by‑step adjustment workflow.
This article provides a step‑by‑step troubleshooting guide for Java production incidents, covering CPU, disk, memory, GC, and network problems with practical commands, analysis techniques, and tools such as jstack, jmap, iostat, netstat, and native memory tracking.
This article benchmarks UCloud’s Kuaijie‑based UDB against a self‑built MySQL instance on UHost, detailing environment setup, sysbench testing parameters, QPS, insert/delete and update results, and evaluates performance gains of over 20% alongside a cost analysis showing UDB’s better price‑performance ratio.
This article presents practical Python performance‑boosting techniques—including avoiding global variables, minimizing attribute access, eliminating unnecessary abstractions, reducing data copies, optimizing loops, leveraging built‑in functions, and using tools like numba—each illustrated with before‑and‑after code snippets and measured speed improvements.
This article provides a detailed, step‑by‑step methodology for diagnosing and resolving common Java production problems—including CPU spikes, disk bottlenecks, memory leaks, garbage‑collection anomalies, and network timeouts—by leveraging native Linux tools and JVM utilities such as ps, top, jstack, jmap, jstat, iostat, vmstat, pidstat, and netstat.
This article explains the performance differences between IN, EXISTS, NOT IN, and NOT EXISTS in SQL queries, provides guidance on when to use each construct based on table sizes and indexes, and demonstrates the concepts with practical code examples.
The article explains why traditional OFFSET and LIMIT pagination becomes inefficient for large tables due to full‑table scans, demonstrates the performance gap with real‑world examples, and presents keyset (cursor‑based) pagination as a fast, index‑driven alternative with practical query patterns.
This article provides a comprehensive tutorial on using EF Core in .NET, covering DbContext setup for MySQL and SQL Server, thread‑safety considerations, connection‑pooling benefits, logging of generated SQL, various insertion techniques (single, cascade, bulk), querying methods, and efficient update patterns.
This guide details the end‑to‑end process for performing a 50,000‑user concurrent load test with JMeter and BlazeMeter, including script creation, local validation, sandbox execution, engine scaling, cluster testing, and Master/Slave configuration to achieve the required concurrency.
This article summarizes the key challenges and solutions when using SVGA animations in mobile live‑gift scenarios, covering import issues, frame extraction, compression, composition size, frame‑rate rules, and supported effects to help developers create smooth, lightweight animations.
This article walks through a real‑world production incident involving intermittent interface timeouts, demonstrates how tracing with SkyWalking and log analysis revealed a downstream service problem, explores GC log diagnostics, uncovers misconfigured c3p0 connection‑pool settings, and shares practical lessons for Java backend performance tuning.
The article explains how Log4j2 can cause thread blocking under heavy exceptions due to class‑loading locks, describes the JVM's reflection optimization mechanism, shows how to verify it with sample code, and outlines ways to disable or tune the optimization using system properties.
This article explains how to apply incremental thinking to ESLint code checks and webpack builds by using Git diff to detect changed files, running targeted linting and bundling, and demonstrates significant time savings in large front‑end projects.
This article explains Kafka's role as a message system, details its fundamental components such as topics, partitions, producers, consumers, and replicas, describes how Zookeeper coordinates the cluster, and explores performance optimizations like sequential writes, zero‑copy, and network design.
This guide explains what MySQL temporary tables are, how they exist only for the current connection, provides step‑by‑step SQL examples for creating, inserting, querying, and dropping a temporary table, and discusses practical scenarios such as high‑concurrency writes.
This article provides a comprehensive guide on using Prometheus for Kubernetes monitoring, covering fundamental principles, exporter selection, Grafana dashboard creation, memory and storage optimization, high‑availability designs, query performance, cardinality management, and integration with alerting and logging systems.
This article explains the internal mechanics of Java Stream’s pipeline, covering how operations are recorded as stages, how intermediate and terminal operations are composed via the Sink interface, and why the implementation achieves lazy evaluation and efficient parallel execution.
This document explains the differences between OLTP and OLAP workloads, introduces the CSTORE columnar storage engine architecture, its core technologies, performance advantages, typical use cases, benchmark results, and future development plans for MySQL 8.0.
This article explains the distinction between Linux Buffers and Cache, how they appear in the free command, their representation in /proc/meminfo, and demonstrates practical experiments using vmstat and dd to observe their behavior during read and write operations, concluding with clear usage guidelines.
An in‑depth look at bare metal servers explains how they differ from virtualized cloud instances, why they’re needed for performance‑critical or security‑sensitive workloads, their integration with cloud services, and market trends driving their growing adoption.
The article demonstrates how moving the LIMIT‑OFFSET condition into a subquery that selects only primary‑key IDs and then joining back to the main table can cut execution time from over 16 seconds to a few hundred milliseconds by avoiding massive index and data‑page scans.
This article examines the rise of ARM‑based CPUs, details AWS's Graviton 2 processor and its deployment in M6G instances, and presents extensive performance, cost, and third‑party benchmark comparisons to illustrate the emerging shift toward ARM in cloud computing.
This article explains how to replace complex Java NIO callback code with lightweight Quasar coroutines to boost throughput, simplify asynchronous programming, and reduce thread usage in high‑concurrency backend systems, while also covering integration with Netty, RPC, and handling of blocking operations.
The article explains why using NULL columns in MySQL can lead to extra storage, index complications, query errors, and performance degradation, and provides concrete examples and best‑practice recommendations to prefer NOT NULL constraints whenever possible.
An intermittent slowdown in a Java SaaS app, even during low traffic, was traced to a Log4j locking bug that blocked hundreds of threads; capturing a thread dump, analyzing it with fastthread.io, and upgrading to Log4j2 resolved the issue.
This article explains the internal workings of Java's ArrayList and LinkedList, covering their dynamic array and linked list structures, growth mechanisms, performance characteristics for random access, insertion, and deletion, and includes source code excerpts and visual diagrams to illustrate key differences.
