This article explains why Redis achieves high throughput—up to 100,000 QPS—by leveraging in‑memory storage, simple data structures, a single‑threaded event loop with I/O multiplexing, and the optional multithreaded I/O model introduced in Redis 6.0, including configuration details and safety considerations.
The article introduces PowerImage, a new Flutter image library that combines external texture and FFI to enable direct ui.Image loading, pre‑caching, simulator support, and custom channels, and compares its performance against traditional Texture solutions with detailed memory and scrolling analyses.
Redis 7.0-rc2 introduces stream consumer group lag tracking, new ACL‑checking APIs, additional command options, extended replies, performance enhancements, and a series of bug fixes, providing a comprehensive update to the open‑source in‑memory database.
This article explains how to build a comprehensive monitoring system for both infrastructure and applications, introducing the USE (Utilization‑Saturation‑Errors) method, key performance metrics, and practical components such as Prometheus, Grafana, full‑link tracing, and the ELK stack to detect and diagnose performance bottlenecks.
The article explains how a MySQL 5.6 master‑slave setup experienced growing replication lag on an off‑site replica, how the issue was traced to page‑compression on a large table using show slave status, perf and pstack, and how disabling compression resolved the delay.
This article investigates MySQL's recommendation to use auto_increment primary keys instead of UUID or random snowflake IDs by comparing table designs, running SpringBoot‑based insert benchmarks, analyzing index structures, and discussing the performance trade‑offs and practical drawbacks of each approach.
This article compares Redis, Memcached, and MongoDB, outlining each system's strengths and weaknesses, performance characteristics, storage capabilities, availability, reliability, consistency, data analysis features, and typical application scenarios to help developers choose the appropriate NoSQL solution.
The article explains how using IN and NOT IN in SQL can cause performance problems and subtle bugs, especially with large tables or NULL values, and demonstrates safer alternatives such as EXISTS, NOT EXISTS, and JOIN with clear code examples.
This article provides a step‑by‑step methodology for identifying why a Redis instance becomes slow, covering baseline latency testing, slow‑log analysis, big‑key detection, expiration patterns, memory limits, fork overhead, huge‑page effects, AOF configuration, CPU binding, swap usage, memory fragmentation, network saturation, and practical remediation techniques.
This article recounts the author's experience of identifying and solving various backend interface performance bottlenecks—including slow MySQL queries, complex business logic, thread‑pool and lock design flaws, and machine issues—by applying targeted optimizations such as pagination redesign, indexing, concurrency, and caching.
This article analyzes why a MySQL query with a large LIMIT offset can take seconds to run, demonstrates the underlying index and buffer‑pool behavior, and shows how rewriting the query with a sub‑select of primary keys reduces execution time from over 16 seconds to under half a second.
This article explains how to detect Redis latency problems, measure baseline performance, monitor slow commands, and address common causes such as network round‑trip delays, fork‑generated RDB snapshots, transparent huge pages, swap usage, AOF settings, key expiration, and big‑key handling, providing practical troubleshooting steps and solutions.
This comprehensive guide explains what Nginx is, its key advantages, typical use cases, request processing flow, high‑concurrency model, proxy types, directory layout, configuration directives, load‑balancing strategies, rate‑limiting, compression, health checks, and differences from Apache, providing practical examples and code snippets for backend developers.
This article explains the concept of virtual DOM, its advantages over direct DOM manipulation, details the diff algorithm including same‑layer comparison, pointer techniques, and longest increasing subsequence optimizations in Vue2 and Vue3, and discusses key usage and performance considerations.
This article explains the inner workings of Java's CMS and G1 garbage collectors, detailing their four-phase processes, the need for stop‑the‑world pauses, strategies like incremental update and SATB to handle missed marks, and compares their advantages, drawbacks, and suitable replacement scenarios.
This article explains what constitutes a Redis big key, why it harms performance, how to detect it with tools like bigkeys, redis‑rdb‑tools, and monitoring, and provides practical removal, compression, and sharding strategies to mitigate the issue.
This article explains the core principles of Java's ThreadPoolExecutor, details its internal state management, demonstrates how to create and configure thread pools with various parameters and rejection policies, and provides practical recommendations for sizing and applying thread pools in backend applications.
The article examines the drawbacks of running MySQL in Docker containers, highlighting data safety, performance, state management, and resource isolation concerns while also discussing scenarios where containerizing MySQL might be feasible.
This extensive guide covers Redis fundamentals, data structures, persistence mechanisms, clustering, sentinel high‑availability, performance tuning, common pitfalls, and practical use‑case implementations, providing detailed answers and code examples for interview preparation and real‑world development.
To raise front‑end quality, the team implements gray‑release monitoring that triggers log analysis at a 5 % rollout, automatically generates reports within ten minutes, and uses dynamic thresholds and noise‑reduction tactics to detect errors early, enabling rapid rollback or expansion and markedly improving stability and release efficiency.
This article examines how to design enterprise‑grade data warehouses by evaluating development convenience, ecosystem, decoupling, performance and security, compares Hive and SparkSQL along with other engines such as Presto, Doris and ClickHouse, and outlines best‑practice component selections for long‑running batch and interactive analytics.
This article explains the benefits, costs, and various update, penetration, bottom‑hole, avalanche, and hot‑key rebuilding strategies for caches in high‑concurrency distributed systems, offering practical guidance on choosing eviction algorithms, using Bloom filters, and improving overall system performance and reliability.
This comprehensive guide explores Redis fundamentals, internal data structures, persistence options, multi‑threading, replication, sentinel failover, clustering, common performance pitfalls, and practical use‑case patterns, providing detailed explanations and code examples for developers and architects.
This article explains how to use JMH for precise Java micro‑benchmarks, covering JVM warm‑up, project setup with Maven, writing benchmark methods, configuring annotations, running tests, interpreting results, and provides practical code examples and tips for reliable performance measurement.
This article examines design patterns as a form of code standard, discussing their definition, relevance in everyday business development, common pain points such as performance overhead, class explosion, team skill gaps, project constraints, and offers practical recommendations for balancing best practices with real‑world constraints.
This article introduces DexInjector, a tool for directly instrumenting Android APK dex files to insert logging, performance monitoring, and third‑party hooks without recompiling, explains the underlying technical research, design choices, implementation details, handling of method limits, string jumbo, obfuscation, class conflicts, and provides code examples and workflow diagrams.
This article presents a comprehensive performance test of Go language channels, comparing them with Java's Disruptor and LinkedBlockingQueue across various object sizes, queue lengths, and producer/consumer thread counts, and provides practical recommendations based on the benchmark results.
This article details Alibaba’s experience building and deploying Flutter‑Web pages for the ICBU seller platform, covering version selection, code reuse, build optimization, deployment workflow, debugging, native JS integration, performance tuning, and compatibility fixes across various H5 containers.
This article examines the performance drawbacks and hidden type‑conversion issues of common Java property‑copy utilities such as Spring BeanUtils, CGLIB BeanCopier, and MapStruct, demonstrates concrete code examples, and recommends using explicit conversion classes or IDE‑generated getters/setters to avoid runtime errors.
After a traffic surge exposed severe latency in a 15-year-old multi-service web platform, we used monitoring to discover a DB-connection leak caused by a liveness probe, corrected it, and distilled four practical lessons on latency metrics, tooling, legacy maintenance, and code vigilance.
This guide explains Linux performance optimization by defining key metrics such as throughput and latency, interpreting average load, exploring CPU context switches, and providing practical step‑by‑step instructions for using tools like vmstat, pidstat, perf, strace, and memory analysis utilities to diagnose and resolve CPU, I/O, and memory bottlenecks.
This article compares the lookup speed of Python lists and sets on large datasets, presents benchmark code and results, and explains why sets are dramatically faster by examining the internal C‑level implementations of list (dynamic array) and set/dict (hash table) including resizing rules and collision‑resolution strategies.
This article consolidates front‑end performance knowledge by explaining the RAIL model, detailing user‑centric metrics such as FP, FCP, LCP, FID, TTI, TBT and CLS, describing how to capture them with tools like Lighthouse and web‑vitals, and offering concrete optimization techniques ranging from caching and HTTP/2 to code‑splitting, tree‑shaking, skeleton screens and server‑side rendering.
The article explains why using COUNT(*) to test for record existence is inefficient and demonstrates how replacing it with SELECT 1 … LIMIT 1 in SQL and a corresponding Java existence check can significantly improve database query performance.
This article walks through the design and implementation of Ant Design Mobile's Picker component, covering its API, gesture handling, animation techniques, performance optimizations, and accessibility improvements for screen‑reader users, while sharing practical code examples and visual diagrams.
This guide walks through MySQL's query execution sequence, then presents concrete optimization techniques—from selecting specific columns and avoiding OR conditions to proper indexing, using EXPLAIN, handling VARCHAR vs CHAR, limiting result sets, and improving joins, GROUP BY, and UNION operations—complete with code examples and visual explain plans.
This article explains how the open‑source Structured Process Language (SPL) streamlines report data preparation, replaces complex SQL and Java code, supports multi‑source processing, enables hot‑swap, and dramatically reduces development effort and performance bottlenecks.
From Svelte’s rapid rise and its compiler‑based performance edge to the enduring strength of React, Vue, and Angular, this article surveys 2022 front‑end trends, compares static versus dynamic rendering, and highlights optimization tools like Tailwind and Linaria, offering practical code snippets for modern web development.
The article presents go-monitor, an open‑source Go library that provides lightweight, lock‑free service quality monitoring, automatic analysis, configurable alerts, and flexible reporting for backend applications, complete with installation steps and code examples.
This article provides a detailed, line‑by‑line comparison of FPGA and ASIC across pre‑fabrication cost, unit cost, time‑to‑market, performance, power consumption, field update capability, density, design flow, verification, upgrade paths, and the role of structured ASICs, helping engineers decide the optimal solution for complex, high‑performance, non‑standard IC designs.
This article explains how modern web IDEs implement terminal functionality using xterm.js and node-pty, examines performance problems caused by massive output and communication bottlenecks, and presents a simple batch‑processing optimization inspired by Hyper that dramatically improves responsiveness.
When selecting a storage engine, evaluate business metrics such as user and data volume, read/write bias, and consistency needs, then match those requirements to the strengths and limits of relational databases, key‑value caches, column‑stores, document stores, search engines, and other NoSQL options to achieve the right balance of performance, scalability, and operational cost.
This article explains how React (pre‑16.8) batches multiple setState calls using batchedUpdates, demonstrates the internal mechanism with source‑level debugging, shows code examples including setTimeout edge cases, and summarizes the key steps that enable the framework’s performance optimization.
This article analyzes why using SET unique_checks=0 during large MySQL imports can bypass unique‑key checks when data is not cached in the InnoDB buffer pool, explains the underlying change‑buffer mechanism, demonstrates the behavior with sysbench tests, and offers a safe workaround.
This guide explains Linux performance optimization by covering key metrics such as throughput, latency, load average, CPU context switching, and memory management, and demonstrates how to use built‑in tools like vmstat, pidstat, perf, and cachetop to diagnose and resolve bottlenecks.
This article compares several Java microservice frameworks—including Spring Cloud, Vert.x, SparkJava, Micronaut, Javalin, and Quarkus—by describing their features, resource consumption, and performance test results, highlighting the trade‑offs between heavyweight and lightweight solutions for small‑to‑medium services.
This article provides a comprehensive overview of Nginx, covering its definition, advantages, typical use cases, request processing flow, high‑concurrency design, proxy types, directory layout, key configuration directives, load‑balancing algorithms, rate‑limiting mechanisms, security features, and practical deployment tips for modern web services.
Even when scanning a 200 GB InnoDB table on a server with only 100 GB RAM, MySQL streams results using a small net buffer and an optimized InnoDB buffer‑pool LRU, so the server’s memory never blows up, though I/O load remains high.
This article presents a lightweight, framework-agnostic canvas layout engine that parses CSS-like styles, performs document-flow layout, renders via a depth-first canvas draw, supports interactive events, works across web and mini-program environments, and demonstrates its API, debugging tools, performance results, and future extensions.
The article explains why placing databases inside Docker containers is generally unsuitable, outlining seven major issues—including data safety, performance, networking, statefulness, resource isolation, cloud platform incompatibility, and environment requirements—while also offering practical mitigation strategies.
KeyDB, a multithreaded fork of Redis, offers higher throughput, multi‑master replication, vertical and horizontal scaling, TLS encryption, JavaScript modules, and ARM support, making it a compelling alternative for boosting QPS without additional hardware, while remaining fully compatible with Redis.
A comprehensive collection of MySQL interview questions and answers covering storage engines, lock types, gap locks, deadlock avoidance, isolation levels, index types, covering indexes, the left‑most prefix rule, SQL tuning, master‑slave replication, latency handling, sharding challenges, and global ID generation.
This guide explains frequently confused Python operations, compares Python idioms with C/C++ conventions, introduces essential standard‑library tools, and offers performance‑oriented debugging techniques to help developers write cleaner, faster, and more reliable Python code.
This article evaluates how MySQL handles time data stored as datetime, timestamp, and bigint by inserting half a million records and measuring query, grouping, and sorting speeds, concluding that bigint generally offers the best performance for time‑range operations.
This article examines various methods for extracting subarrays in Swift, benchmarking loop‑based copying, range subscripting with map, while loops, and direct memory copying via memcpy, analyzing their execution times, compiler optimizations, and trade‑offs to guide developers toward efficient array handling in performance‑critical applications.
This article shares a detailed account of a backend engineer's multi‑stage interview process at Huanju (formerly YY), covering personal background, common Java and system design questions, database and caching strategies, distributed lock handling, and reflections on preparation and outcomes.
This article examines the role of caching in high‑concurrency distributed systems, outlining its performance benefits and associated costs, and detailing various cache‑update strategies—including LRU/LFU/FIFO, expiration, active refresh, Bloom‑filter protection, and solutions for penetration, avalanche, hot‑key rebuild, and the “no‑bottom‑hole” problem.
This tutorial explains Redis Bitmaps, covering their underlying concept, core commands such as SETBIT, GETBIT, BITCOUNT, BITOP, BITPOS, BITFIELD, and demonstrates practical uses like online‑status tracking, daily active‑user counting, Bloom filters, marketing segmentation, collaborative drawing, and handling non‑sequential IDs.
This roundup highlights ten essential front‑end articles covering performance metrics, refactoring principles, React Hooks, Markdown, modularization, H5 optimization, mini‑programs, async/await debates, Nohost open‑source insights, and Remix pre‑loading techniques, offering valuable knowledge for developers.
The article explains how to design a C++‑based multithreaded service that uses Pthreads, channels, and TensorRT to parallelize deep‑learning inference tasks, thereby reducing latency and dramatically increasing throughput for AI applications such as facial‑recognition access control systems.
CKV+, Tencent’s next‑generation high‑performance NoSQL KV database compatible with Redis, Memcached and ASN, evolves from early CMEM architectures, adopts a multi‑tenant shared‑memory design built on Seastar, integrates DPDK for user‑space networking, and achieves up to ten million QPS with significant cost and latency improvements.
This article benchmarks Python list versus set lookups on large datasets, explains why sets are dramatically faster, and delves into the internal C‑level implementations of list as a dynamic array and set/dict as hash tables, including resizing rules and collision handling.
Learn practical JVM tuning techniques by identifying high CPU usage, diagnosing deadlocks, and uncovering memory leaks using tools such as top, jstack, jps, jstat, and jmap, with step‑by‑step commands and code examples to help you optimize Java application performance.
RTLA (real‑time Linux analysis tool), developed by Red Hat kernel engineer Daniel Bristot de Oliveira, has been merged into the Linux 5.17 source tree, offering kernel‑level tracing of OS noise and timer latency, command‑line options for high‑priority task delay reporting, and trace output for debugging real‑time performance.
This article analyzes why MyBatis foreach‑based batch inserts become extremely slow with thousands of rows, explains the underlying SQL and PreparedStatement overhead, and demonstrates how switching to ExecutorType.BATCH or limiting foreach values to 20‑50 rows dramatically improves MySQL insertion performance.
The article explains the concept of white‑screen time, its impact on user experience, and presents multiple detection methods—including Navigation Timing API, MutationObserver, element‑point analysis, and headless‑browser simulation—along with implementation code and a monitoring‑alert architecture for front‑end performance optimization.
This article demonstrates how to generate, insert, and query ten‑million‑row MySQL tables, measures pagination query times under different offsets and limits, and presents practical optimization techniques such as sub‑queries, id‑range filtering, and column selection to improve performance on massive data sets.
This article explains Redis’s original single‑threaded event‑driven architecture, its performance bottlenecks, and how versions 4.0 and 6.0 introduced Lazy Free and multithreaded I/O mechanisms—including asynchronous key deletion, background freeing, and I/O thread pools—to improve scalability while outlining their implementation details, limitations, and comparisons with Tair.
Traditional Linux I/O using read() and write() involves multiple CPU and DMA copies and context switches, while modern techniques like zero‑copy, multiplexing, and page‑cache optimization reduce overhead; this article explains the classic I/O flow, read/write operations, network and disk I/O, and high‑performance strategies such as zero‑copy and Direct I/O.
During nightly peaks, a social‑e‑commerce startup experienced hour‑long service outages due to MySQL timeouts; by analyzing traffic spikes, CPU usage, and slow‑SQL logs, the team identified un‑cached ranking queries and a 20‑minute cache refresh bottleneck, then implemented targeted caching, monitoring scripts, and fallback static pages to eliminate the issue.
This article explains why a high‑traffic platform migrated from SQL Server to Elasticsearch, covering the technical motivations, performance characteristics, indexing strategies, data synchronization methods, API design, and operational monitoring to achieve a scalable, low‑latency search solution.
Learn how to enhance your Nginx server by creating custom 404 error pages, enabling and reading the stub_status module, increasing worker processes and connections, adjusting kernel limits, expanding header buffers, and configuring client-side caching for static assets, with step‑by‑step commands and examples.
This tutorial walks through creating a dynamic, multi‑stage like animation for H5 live streams using CSS keyframe animations and a Canvas‑based implementation, covering trajectory analysis, sprite handling, SCSS loops, performance comparison, and practical code snippets for seamless integration.
This article introduces Maven‑mvnd, an Apache‑backed, GraalVM‑powered Maven alternative that speeds up Java builds through daemon processes and JVM optimizations, explains its installation (including Homebrew on macOS and JDK version considerations), demonstrates usage, and discusses performance benefits and known issues.
This article presents a comprehensive guide to building maintainable, extensible backend systems by covering coding conventions, branch naming, commit messages, comment standards, result‑wrapping patterns, database normalization, algorithmic improvements, concurrency handling, service layering, and practical code examples.
This article explains the fundamentals of RabbitMQ, compares normal and mirrored cluster modes, details Google’s large‑scale test setup, and walks through advanced plugins such as sharding, consistent‑hash exchange, federation, and high‑availability strategies for achieving million‑level message throughput.
The article explains how using a large OFFSET in MySQL pagination forces the server to read and discard many rows, causing severe performance degradation, and demonstrates that rewriting the query to first fetch primary‑key IDs via a subquery dramatically reduces I/O and execution time, with buffer‑pool experiments confirming the improvement.
This comprehensive guide traces the evolution of open‑source monitoring solutions from the early 2000s to modern cloud‑native tools, comparing their strengths, weaknesses, and ideal deployment scenarios to help IT professionals select the most suitable monitoring product for their infrastructure.
This guide explains the background of TPC‑C, its key concepts, and provides a detailed, container‑based procedure for setting up the environment, preparing data, running the benchmark on RadonDB MySQL in Kubernetes, and interpreting throughput and price‑performance results.
Phoenix is Meituan’s client‑side CDN disaster‑recovery system that uses a Webpack‑based SDK, dynamic calculation service, and monitoring platform to automatically detect load failures, switch domains, isolate problems, and continuously hot‑standby resources, boosting resource success rates from 99.7 % to 99.9 % across hundreds of projects.
The 2021 Node.js Developer Survey reveals a healthy, steadily evolving ecosystem focused on improved usability, growing framework diversity, increased adoption beyond front‑end developers, and heightened attention to performance, memory management, and serverless architectures.
This article explains how InnoDB stores data in 16 KB pages, calculates how many rows a B+Tree index can hold, shows how to determine the tree height from the page level, and answers why MySQL uses B+Tree rather than other tree structures.
This article explains MySQL's experimental EXPLAIN FORMAT=TREE feature and the later EXPLAIN ANALYZE extension, showing how they present execution plans, estimated costs, actual runtime metrics, and how to interpret the tree output for query optimization.
The article explains how conventional SQL struggles with executing multiple grouping and Top‑N aggregations on massive tables, leading to repeated full scans and poor performance, and demonstrates how the SPL compute engine can perform these operations in a single pass with parallelism, improving speed and scalability.
This article explains why deploying Kubernetes on bare‑metal servers offers six key benefits—simpler networking, better cost efficiency for demanding workloads, superior performance, stronger security, workload‑specific optimization, and freedom from vendor lock‑in—making it a smarter choice than virtual‑machine‑based solutions.
The article examines the recent Xi'an health‑code system failure, highlighting that the crash stemmed from backend design flaws such as serving all static assets without a CDN, excessive bandwidth demand exceeding 125 Gbps, and inefficient QR‑code API handling.
This article evaluates MySQL insertion performance of three primary key strategies—auto‑increment, UUID, and random Snowflake‑like keys—by building identical tables, running Spring‑Boot/JdbcTemplate benchmarks, analyzing index structures, and discussing the advantages and drawbacks of each approach.
As agile development matures, QA moves beyond functional testing; this article explains test right‑shift in a game project, covering stable release strategies, log‑based monitoring, opinion monitoring, performance monitoring, and risk control mechanisms.
Luna is an in‑app debugging tool for React Native that works in non‑development environments, offering a floating trigger and a half‑screen panel with Log, Network, Redux, and Shopee sections, automatically injected via a simple init call and HOC, enabling real‑time inspection of console output, HTTP traffic, state and app metadata.
Over three years Gaode Map halved overall latency by systematically identifying bottlenecks, applying reverse‑order targeted fixes, establishing forward‑order long‑term controls, and deploying adaptive resource scheduling, engine acceleration, H5 container enhancements, high‑performance components, and CI automation, resulting in sustainable core‑chain performance improvements and a better user experience.
This article explains how to configure Logback in Spring Boot to separate logs by level, use asynchronous appenders to reduce I/O latency, and demonstrates a performance test showing a ten‑fold throughput increase, while also detailing the underlying async logging mechanism.
A detailed post examines why the Xi’an health‑code service collapsed, showing that the lack of CDN for static assets and the resulting 125 Gbps bandwidth demand at 33 k QPS overwhelmed a single data‑center link, rather than any server‑side QR‑code generation issue.
This article introduces Alibaba's EasyExcel library, demonstrates how to integrate it into SpringBoot, and provides step‑by‑step code examples for simple export, import, and complex one‑to‑many export using custom merge strategies, highlighting its performance advantages over EasyPoi.
This article explains why the Taobao mobile team migrated the product review list from Objective‑C to Swift, outlines Swift’s three main advantages—speed, safety, and expressiveness—shows concrete design‑pattern implementations, discusses the challenges faced during migration, and quantifies the resulting gains in code size, review efficiency, and crash reduction.
This article explains how to integrate Flutter widgets into the Kraken web rendering engine as custom elements, detailing the architecture, rendering pipelines, code examples, and advanced scenarios such as waterfall‑flow optimization to achieve dynamic, high‑performance, and easily extensible front‑end applications.
This article presents a collection of Python pitfalls such as random sampling, lambda binding, copying, equality vs identity, and type checks, followed by a concise guide for C/C++ programmers transitioning to Python, and showcases useful tools like CSV handling, itertools, collections, and performance‑debugging techniques.
This article explains the causes of Java out‑of‑memory problems, introduces essential diagnostic commands and memory‑analysis tools, and walks through a real‑world case study that shows how to locate, analyze, and fix a memory leak caused by unreleased OSS client connections.
This article details the background, current status, and engineering architecture of introducing Swift into 58 Group’s real‑estate iOS apps, explains the two main mixed‑compilation approaches (bridging header and module), presents practical module setup, discusses reflection pitfalls, binding solutions, and performance comparisons between Swift and Objective‑C implementations.
The article analyzes the trade‑offs of deploying container platforms on bare‑metal servers versus virtual machines in banks, covering performance, cost, management, security, workload flexibility, and IaaS capabilities to help decide the optimal underlying compute resource.
This article explains how to leverage OpenResty and Lua scripts to integrate Nginx with Redis for direct caching, compression, timed updates, request forwarding, and configurable URL management, thereby improving concurrency, reducing latency, and enhancing the resilience of backend web services.
