This guide explains MySQL B+Tree index structures, their advantages, how to create primary, unique, ordinary, full‑text, composite and prefix indexes, and provides practical rules and tips for designing efficient indexes, query patterns, and sorting strategies to dramatically improve database performance.
This article presents a comprehensive overview of a universal FPGA‑based CNN accelerator, detailing its motivation, flexible architecture, compiler workflow, memory and compute unit designs, and performance comparisons that demonstrate significant latency and cost advantages over CPU and GPU solutions for real‑time AI inference.
The USE Method provides a concise, structured framework for quickly locating resource bottlenecks and errors in complex systems by examining utilization, saturation, and error metrics across hardware, software, and cloud environments, enabling practitioners to prioritize and resolve performance issues efficiently.
The article examines why PHP is often labeled the worst mainstream language, highlighting its chaotic function naming, inconsistent APIs, lack of async I/O and multithreading, historical design flaws, community attitudes, and recent improvements like PHP 7, while acknowledging its early deployment advantages.
This article walks through diagnosing a sluggish Oracle search query with many optional filters, removing unnecessary joins and function calls, applying conditional MyBatis joins, and creating composite indexes to dramatically lower the execution plan cost from 13902 to under 100.
This guide details practical MySQL performance enhancements across hardware BIOS settings, disk I/O choices, filesystem and kernel tuning, and MySQL configuration—including version selection, key innodb parameters, schema design rules, and operational best‑practices—to achieve substantial IOPS and query speed gains.
The article explains why Linux appears to consume most memory when using the free command, clarifies the roles of buffers and cache, shows how to interpret free’s output, and demonstrates through experiments how caching dramatically speeds up repeated file reads.
This article explains how to identify, extract, and inline critical CSS using the Critical Node.js module and a custom Webpack plugin, while deferring non‑critical CSS loading to improve first meaningful paint and overall page performance.
This article recounts the discovery, root‑cause analysis, and engineering solution for a severe Android WeChat chat freeze bug, detailing a custom TextView layout that improves text alignment, handles edge‑case languages, and delivers near‑native performance.
This article explains Vim’s powerful, extensible features, presents benchmark comparisons of memory consumption and operation speed against editors like Emacs, Nano, VS Code, Atom, Sublime, and shows why many developers still prefer Vim for efficient text editing.
The article reviews Oracle's high‑availability and sharding advances in 18c, including RAC Sharding 2.0 and Active Data Guard features, and examines MySQL 8.0's major improvements such as the removal of MyISAM, data‑dictionary optimizations, self‑tuning, enhanced security, and new performance capabilities, while also comparing MySQL with PostgreSQL.
This article explains the Android ANR mechanism, common scenarios that trigger it, how the system detects and logs ANR events, and provides step‑by‑step methods for locating and fixing ANR issues, illustrated with a recent WeChat bug example.
This guide presents twenty practical Python performance tips—from algorithmic complexity and data structure choices to generator usage, loop optimizations, C extensions, parallel processing, and profiling tools—each backed by concrete code examples and timing benchmarks.
This article explains Redis's five core data structures, their internal representations, practical use‑cases, memory‑saving configuration parameters, and the four persistence mechanisms, providing concrete examples and recommendations to improve performance and stability.
This article reviews Java 9’s extensive new features—including the module system, jshell REPL, performance and security enhancements—explains their impact on development practices, and discusses the challenges and future directions for the Java platform.
The article investigates a performance regression in MySQL 5.7.18 where partitioned tables cause excessive InnoDB row locking, leading to lock timeouts and slower updates, explains the root cause through source‑code analysis, reproduces the issue, validates the findings, and confirms it as a MySQL bug.
The article introduces Android’s ConstraintLayout, explains how it solves performance and nesting problems of RelativeLayout, LinearLayout, and TableLayout, guides developers through setup and step‑by‑step conversions—including proportional spacing, aspect‑ratio, gone margins, and chains—present a modest 10 % performance gain versus claims, and shares practical developer insights.
The article answers twelve Java concurrency questions, covering Meituan’s simple Akka use, when to prefer ReentrantLock or synchronized, queue rejection policies, Java 8 ConcurrentHashMap internals, ThreadPoolExecutor workflow, read‑write locks and Conditions, interview preparation, beginner resources, volatile ordering nuances, and notes on unclear flash‑sale overselling safeguards.
When you need to diagnose a Linux server performance issue, this guide shows the ten most useful command‑line tools you should run in the first minute, explaining what each metric means and how it helps you spot CPU, memory, disk, or network bottlenecks.
Lottie, Airbnb’s open‑source animation library, parses After Effects‑exported JSON to render vector animations natively on Android, iOS, and React Native, letting developers share a single asset across platforms, simplify code, manage assets from assets, SD card or network, while balancing modest APK size increase against performance limits for complex scenes.
The article analyzes a lottery‑service bottleneck caused by massive concurrent database reads and writes and presents a comprehensive set of backend optimization techniques—including caching, queue‑based peak‑shaving, optimistic locking, asynchronous processing, read‑write splitting, and semaphore‑based rate limiting—to improve throughput and stability under high load.
This article investigates the performance degradation and lock timeout issues observed in MySQL 5.7.18 partition tables, reproduces the problem with test cases, analyzes InnoDB lock behavior through source code debugging, validates the root cause related to partition scan locking, and confirms it as a regression bug in MySQL 5.7.
This article examines the client‑server architecture of Memcached, the slab‑based memory management of both Memcached and Redis, compares their performance, memory efficiency, persistence, data structures and networking models, and presents practical Redis use cases such as caching, ranking, pub/sub, queues, and real‑time analytics.
This article explains why caching is essential for backend services, outlines common cache problems such as penetration, concurrency, and avalanche, and compares cache-aside, read/write‑through, and write‑back patterns with practical guidance on choosing and updating caches.
This article explains how Go’s compiled single‑binary output, static type system, superior performance, built‑in libraries, and strong IDE support helped a micro‑service platform replace a Python/Django stack, cutting code by 64% and boosting backend speed by up to 30%.
The article explains how set‑based SQL queries outperform procedural, row‑by‑row approaches by showing concrete examples, AUTOTRACE statistics, and PL/SQL function alternatives, highlighting massive differences in consistent gets, recursive calls, and overall resource consumption for large production data sets.
The article outlines essential software architecture concerns—including functionality, variability, performance, capacity, ecosystem integration, modularity, buildability, productization, and security—while also discussing evaluation methods and scaling strategies for large‑scale systems such as MMOs.
This article compiles a Java club’s Q&A covering backend development essentials—from network bandwidth checks and static‑method hooking to JNI choices, OSGi modularity, plugin performance, CPU‑heavy thread analysis, ConcurrentHashMap improvements, micro‑service frameworks, cross‑data-center protocols, JVM GC mechanisms, inheritance alternatives, ThreadLocal pitfalls, career advice, cloning, generics erasure, JVM tuning, multithreading strategies, lock upgrades, monitoring tools, database failure handling, Spring Data JPA design, and distributed transaction practices.
This article reviews the compatibility of various Node.js versions with ES6 features, explains key ES6 constructs such as let, const, template literals, default parameters, destructuring, and classes, and presents performance benchmarks comparing these features to their ES5 equivalents, concluding with practical recommendations for developers.
This article compiles ten classic MySQL error scenarios—from connection limits and replication conflicts to charset issues and file‑open limits—explaining the root causes, diagnostic commands, and step‑by‑step solutions so beginners and seasoned DBAs can troubleshoot confidently.
This article compares FMDB and WCDB, detailing smooth migration steps, benchmark results showing WCDB's superior write and multithreaded performance, reduced code complexity, built‑in encryption, statistics and repair tools, and provides practical guidance for developers considering a database switch.
This guide explains how to analyze MySQL performance with EXPLAIN statements, composite indexes, slow‑query logging, storage engine locking differences, and transaction settings, providing practical examples and detailed descriptions of each EXPLAIN output column.
At HBaseCon 2017 Asia, Alibaba showcased a series of groundbreaking HBase enhancements—including strong synchronous replication, SQL-on-HBase capabilities, cross‑cluster range data copy, and read/write path optimizations—that dramatically improve performance, reliability, and usability for large‑scale big‑data storage.
This article provides a comprehensive guide to server performance optimization, covering the fundamentals of CPU, memory, and I/O analysis, practical methodologies, essential tools, and real‑world case studies to help operations engineers identify bottlenecks and improve system stability.
This article explains key website performance metrics such as response time, concurrency, and throughput, presents typical values for various operations, and outlines practical optimization strategies for front‑end, application‑server, and storage layers, including caching, CDN, reverse proxy, clustering, and code improvements.
The article explains the fundamental architectural factors of large‑scale web systems—performance, availability, scalability, extensibility, and security—detailing practical optimization techniques, measurement metrics, and design principles that guide robust software architecture decisions.
This article explains Oracle's system structure, the physical files used by RAC and ASM, their I/O patterns for OLTP and OLAP workloads, and provides detailed recommendations for ASM diskgroup design, redundancy, AU sizing, RAID choices, and SSD optimization for read and write intensive database operations.
This guide introduces the powerful sysstat suite, explains how to install sar, outlines its key features and statistics, and provides step‑by‑step commands for troubleshooting CPU, memory, I/O, and network problems on Linux servers.
This article details the QQ Membership front‑end team's performance, componentization, and continuous‑integration practices for hybrid H5 pages on Mobile QQ, covering challenges of load speed, development efficiency, high availability, and the solutions they implemented to keep page loading around one second.
This article lists ten classic MySQL error scenarios—from connection limits and replication conflicts to startup failures and charset issues—explaining each problem, showing the exact error output, and providing step‑by‑step commands and configuration tweaks to resolve them.
A production MySQL incident showed sudden system CPU spikes and many running threads despite low query throughput, which was traced to the server's time_zone=system setting causing timestamp conversion to lock a global mutex, leading to excessive spin‑locks, context switches, and degraded performance that was resolved by changing the time_zone to a fixed offset.
This guide presents ten practical MySQL performance techniques—from workload profiling and resource awareness to smart indexing, pagination, and monitoring—offering concrete steps, tool recommendations, and common pitfalls to help database administrators keep their servers fast, stable, and scalable.
This article introduces essential live‑streaming terminology and outlines a step‑by‑step testing process—including test case design, execution, and verification—to ensure that a live streaming application launches and operates reliably.
This article explains the motivations, scenarios, architecture, core components, performance characteristics, and future roadmap of Sharding-JDBC, a lightweight Java framework that enables transparent database sharding and scaling for high‑volume, high‑concurrency applications.
The article defines dynamic image formats, traces their history from GIF to WebP, compares GIF, APNG and WebP features and Android decoding performance, showing WebP offers smaller files and faster loading at higher CPU cost, while GIF remains most compatible and CPU‑efficient.
This article details JD.com's front‑end architecture for its homepage, covering the challenges of massive DOM growth, static page generation via CDN, layered page loading strategies, disaster‑recovery measures, performance optimizations, and the JDF engineering toolchain that enables modular development, automated builds, and efficient deployment in a high‑traffic e‑commerce environment.
The article examines why the author favors React for server‑side rendering despite the rise of lightweight libraries like Preact and Inferno, discussing checksum handling, compatibility, maintainability, future roadmap, and presenting benchmark data that shows React@16’s performance gains.
This article explains how to enable SSL encryption for MySQL 5.7, details the necessary configuration steps, demonstrates security testing versus unencrypted connections, and measures the resulting performance penalty, helping DBAs decide when to use SSL in production.
These ten essential Java programming commandments—ranging from adding comments and avoiding hard‑coding to proper GUI design, unit testing, and performance‑aware coding—provide developers with practical guidelines to write clearer, more maintainable, and efficient code while preventing common pitfalls.
This guide explains how to fine‑tune Linux kernel parameters and NGINX directives—such as backlog queues, file descriptors, worker processes, keep‑alive settings, access‑log buffering, sendfile, and request limits—to achieve optimal web server performance for high‑traffic sites.
This article explores a scrolling issue caused by a CSS ::after‑generated line that creates an unexpected rendering layer, explains how will‑change and transform can influence layer creation, and documents the puzzling paint/composite behavior observed during debugging.
This article translates and expands on Mark Callaghan’s sysbench benchmark, revealing that MySQL 5.6‑5.7 suffers the steepest QPS drop in low‑concurrency tests, compares configurations across versions, presents detailed charts, and concludes that most performance regressions are isolated to the 5.7 release.
An in‑depth case study of a no‑card payment system reveals common backend pitfalls—database deadlocks, long‑running transactions, thread‑pool misuse, excessive logging, and missing monitoring—and demonstrates practical fixes using Redis locks, refined transaction scopes, controlled thread pools, and optimized logging to dramatically improve scalability and reliability.
The 2016 China Mobile App Performance Report, released by leading APM provider Tingyun, analyzes iOS and Android crash rates, network performance, error distributions, and third‑party API responsiveness, revealing that iOS apps crash five times more often than Android, network errors dominate failures, and certain industries suffer higher latency, offering developers data‑driven guidance to improve user experience.
This article explores WebGL rendering fundamentals, compares vertex and fragment shader workloads, and presents practical optimization techniques such as moving calculations to shaders, reducing uniform updates, and minimizing program switches to achieve smoother frame rates.
This article examines how PHP's foreach construct consumes memory under different reference modes, explains the internal structure of PHP arrays, buckets, and zvals, and provides practical recommendations for choosing reference or value iteration to minimize memory usage.
This article explains RAID fundamentals, compares common RAID levels, shows how to identify the configured RAID using MegaCli, evaluates write policies and battery status, and recommends optimal RAID configurations for MySQL data, binary logs, and redo files.
This article explains the internal architecture of modern browsers, covering their core components, network request flow, the critical rendering path, DOM and render tree construction, layout and repaint processes, and practical performance optimization techniques for front‑end developers.
The article examines the 2017 TOP500, Green500, HPCG, Graph500 and Green Graph 500 rankings, explains why Linpack is becoming insufficient, compares benchmark methodologies, and introduces major application and micro‑benchmarks that illustrate the evolving performance metrics of modern supercomputers.
This article compares NVIDIA's Tesla and GeForce GPU families, detailing their target markets, design differences, core architectures, double‑precision performance, ECC support, memory bandwidth, interface options, software and OS compatibility, power efficiency, and management features to help readers choose the right GPU for HPC or gaming workloads.
This article explains the new shared temporary tablespace introduced in MySQL 5.7, how to configure its size and location with innodb_temp_data_file_path, compares it with tmpdir, demonstrates the impact on compressed and uncompressed InnoDB temporary tables, and highlights related parameters and potential pitfalls.
This guide explains how to identify performance bottlenecks in WebGL applications by examining CPU and GPU workloads, using tools such as stats.js, Chrome DevTools, Web Tracing Framework, and offers concrete optimization strategies for shaders, draw calls, state changes, and resource management.
This article explains how WCDB for Android simplifies encryption with SQLiteCipherSpec, enables seamless data migration, provides a custom FTS3/4 tokenizer with dynamic ICU loading, and offers log redirection and performance monitoring tools, plus an optimized cursor implementation for high‑performance mobile apps.
The review evaluates Huawei's ES3600 v3 enterprise NVMe SSD, detailing its specifications, benchmark methodology, and performance results across SQL Server, MySQL, and synthetic workloads, and concludes with an assessment of its strengths, weaknesses, and suitability for latency‑sensitive database applications.
This article explores three progressive implementations for a complex e‑commerce search interface, comparing a monolithic SQL solution, an optimized multi‑query approach, and a Redis‑based caching strategy that leverages sets and sorted sets for fast, scalable results.
This article explains the fundamentals of web animation performance, examines a complex canvas‑based weather animation case, introduces tools like Chrome's FPS meter and stats.js, and details browser rendering pipelines, CPU/GPU roles, and practical optimization techniques for smoother front‑end experiences.
This article provides a comprehensive overview of the MariaDB Spider storage engine, covering its architecture, advantages, disadvantages, common DBA scenarios, installation steps, practical sharding examples, and performance testing guidance for distributed MySQL databases.
This article chronicles the development of WCDB, WeChat’s open‑source mobile database, detailing its early challenges, performance bottlenecks, security risks, concurrency improvements, cross‑platform collaboration, and future roadmap for a more reliable and efficient data layer on iOS and Android.
Node.js’s rapid v8.x releases introduce async/await, async_hooks, util.promisify and other core updates that can boost performance up to 50%, simplify asynchronous monitoring, and replace third‑party Promise libraries, urging developers to upgrade from older versions while staying mindful of stability.
This guide shares a senior DBA’s hard‑learned lessons on mastering MySQL environments, ensuring data security, handling routine operations, designing robust architectures, and adopting the right mindset to reduce costly mistakes and improve reliability in production systems.
Google’s Guetzli JPEG compressor, which prioritizes perceptually important details, can dramatically shrink image sizes but demands high memory and CPU time; the article details real‑world tests, quality‑vs‑size trade‑offs, memory requirements, installation tips, and practical recommendations for using Guetzli in web projects.
This article explains how MySQL 5.7 automatically saves and restores InnoDB buffer‑pool pages, how to tune the innodb_buffer_pool_dump_pct setting, monitor load progress, and handle multi‑node deployments or crashes to achieve faster, more predictable startup performance.
The article discusses how expert programmers must continuously learn and balance humility with confidence, explores the end‑to‑end design principle, examines complexity, layering, and componentization in large systems, and highlights performance considerations, distributed‑system realities, and management lessons for building robust software.
This article examines how different server‑side languages model I/O, compares blocking and non‑blocking approaches, discusses scheduling overhead, presents sample code for PHP, Java, Node.js, and Go, and offers benchmark insights to help developers choose the right technology for high‑load web applications.
This guide explains why the default Linux kernel settings are unsuitable for high‑concurrency Nginx servers, shows how to edit /etc/sysctl.conf, and provides a curated list of TCP and network parameters with practical comments to improve throughput and latency.
This article provides a comprehensive overview of large‑scale website architecture, covering key metrics, evolutionary stages, core design patterns, performance testing, high‑availability strategies, scalability techniques, and security measures essential for building and operating robust web systems.
This article examines how Tomcat connector settings such as acceptCount, maxConnections, maxThreads, executor, and protocol affect concurrency and throughput in asynchronous servlet environments, and demonstrates tuning steps that significantly improve performance.
This guide provides comprehensive PostgreSQL best‑practice recommendations covering naming conventions, column design, constraints, index strategies, NULL handling, development standards, and administration tips to help users quickly adopt consistent and efficient database practices.
This article describes the background, architecture, encountered performance bottlenecks, and a three‑level caching strategy (Redis‑based) implemented in Python to accelerate a measurement platform that aggregates bug, issue, and code metrics for a rapidly growing development team.
Before profiling performance you must locate slow queries, enable MySQL's slow query log, use EXPLAIN to analyze execution plans, and add appropriate indexes—such as on picture.album_id—to dramatically reduce scanned rows and boost query speed by hundreds of times, while balancing read/write trade‑offs.
This article explains the fundamental time units of system performance, outlines various measurement dimensions and tools, and guides readers through analysis, profiling, and improvement techniques to achieve high‑performance, reliable applications.
This article provides a comprehensive guide to JavaScript's console API, covering basic logging methods, object inspection, grouping, clearing, performance timing, profiling, tracing, assertions, and counting, with practical code examples and tips for effective debugging in development environments.
This article describes the architecture, deployment, configuration, maintenance, and performance results of a large‑scale near real‑time logging platform built with Kafka, Flume, and Elasticsearch, highlighting practical lessons and future plans for resource‑efficient operation.
Learn how to boost MySQL performance for massive tables by optimizing schema design, indexing, query patterns, engine selection, system parameters, hardware upgrades, read/write splitting, caching layers, partitioning, vertical and horizontal sharding, and choosing appropriate client or proxy sharding solutions.
This article chronicles Toutiao’s evolution from a monolithic Python/C++/PHP stack to a large‑scale Go‑based microservice architecture, detailing the reasons for adopting Go, the design of the kite framework, concurrency models, timeout control, performance tuning, monitoring, and a reusable DAO component for efficient RPC aggregation.
This article explains how to design a high‑traffic website architecture by layering the system, addressing performance, availability, scalability, extensibility, and security, and outlines metrics and testing methods for ensuring reliable, fast, and secure operation.
This article reviews how GPU memory bandwidth, architecture, and price affect deep‑learning workloads, compares popular NVIDIA models and alternatives, discusses multi‑GPU scaling, and provides practical guidance for selecting the most suitable GPU for various budgets and use cases.
This article presents a comprehensive Java benchmark that compares JSON libraries (Jackson, Fastjson, DSL‑JSON, Jsoniter, Thrift) with Google Protocol Buffers across various data types and structures, revealing where Protobuf truly outperforms JSON and where modern JSON parsers narrow the gap.
WeChat reduced its SQLite chat‑record corruption rate by over 50% by optimizing storage space, enforcing full file synchronization (including iOS fullfsync), and implementing a dual‑backup strategy for the master table with CRC checks and pre‑allocated space, dramatically improving repair success.
This article explains the key SSD benchmark indicators—4K random I/O, sustained throughput, performance consistency, durability, and write amplification—while describing why they matter for evaluating storage solutions and guiding proper SSD selection for production workloads.
This article explains how Twitter Lite, one of the world’s largest React.js PWAs, eliminates a range of performance bottlenecks through route‑based code splitting, avoiding frame‑dropping functions, using smaller images, optimizing React lifecycle methods, improving Redux updates, and leveraging Service Workers for faster asset delivery.
This article dissects the inner workings of jQuery’s Sizzle selector engine, explaining its tokenization, compilation, matcher generation, and performance optimizations, while offering practical tips for writing faster CSS selectors in modern web development.
This article recounts the Huajiao team's migration from PHP 5 to PHP 7, detailing the motivations, upgrade hurdles, extensive performance benchmarks, gray‑release strategy, and operational steps that together delivered up to 30% CPU savings and significant cost reductions.
This article presents ten practical Linux system‑administration tricks—from unmounting a stuck DVD and recovering a frozen screen to using SSH tunnels for VNC, resetting root passwords, measuring bandwidth with iperf, and gathering system information—each designed to save time and improve efficiency for busy administrators.
This guide reviews the most powerful Node.js command‑line options—including version checks, inline evaluation, debugging inspectors, zero‑filled buffers, and profiler processing—explaining their syntax, use cases, and examples to help developers improve productivity and security when running Node applications.
This guide introduces St-load, a Linux‑based streaming load testing tool, and provides step‑by‑step instructions for installing, compiling, and using its RTMP, HTTP, and HLS testing features, including command‑line examples and parameter explanations for both push and pull scenarios.
This article reports a benchmark of seven WebSocket server frameworks (Netty, Undertow, Jetty, Vert.x, Grizzly, spray-websocket, Node.js) plus a Go implementation, describing the test setup on AWS C3.4xlarge instances, detailed per‑framework results, and an analysis of latency, CPU and memory usage.
This article presents a comprehensive methodology for reviewing internet‑scale system architectures, focusing on non‑functional quality attributes such as performance, availability, scalability, security, and maintainability, and provides detailed guidelines, metrics tables, and a classic case study for capacity and performance planning.
This article examines why a seemingly simple MySQL IN subquery on tens of thousands of rows can take 33 seconds, explains the optimizer’s behavior in MySQL 5.5, and presents practical fixes such as using temporary tables or JOINs to dramatically improve performance.
This article presents a comprehensive guide to front‑end performance optimization, covering reduction of HTTP requests, proper handling of repaint/reflow, minimizing DOM operations, using JSON, efficient HTML/CSS, CDN acceleration, external resource loading, minification, image compression, and cookie management.
