This article details a step‑by‑step MySQL performance tuning process—starting from hardware and software environment description, through parameter‑level optimization of InnoDB buffer pool and redo logs, to additional tweaks—demonstrating up to three‑fold throughput improvements based on sysbench oltp_read_write testing.
This comprehensive guide explains the main factors that slow down MySQL queries—including inefficient SQL, concurrency limits, CPU and disk I/O bottlenecks, network issues, large tables, and transaction overhead—while offering concrete configuration tweaks, storage‑engine choices, indexing strategies, and sharding techniques to dramatically improve performance.
This article presents a detailed overview of Nginx performance optimizations, module types, load‑balancing algorithms, log rotation scripting, custom error page setup, smooth restart procedures, configuration checks, and a comparative analysis with Apache and LVS for backend server administrators.
This article explains the intelligent swing‑hang scheduling algorithm, an AI‑driven multi‑objective genetic approach that uses IoT data to visualize transport, generate cost‑effective vehicle plans, and iteratively evolve optimal routes, thereby reducing empty mileage and improving logistics efficiency.
This article presents seven practical techniques—ranging from using local variables and reducing function calls to employing generator expressions and compiling code—to significantly improve Python program performance and reduce unnecessary resource consumption.
This article compiles 52 practical SQL performance optimization strategies—including indexing best practices, query rewriting, use of temporary tables, storage engine selection, data type choices, backup procedures, and diagnostic tools—to help developers write faster, more efficient database queries.
TDH 5.2.3 introduces a series of stability and performance upgrades—including transaction and compaction optimizations, enhanced error handling, SQL length protection, improved Oracle‑compatible UDFs, default resource pool support, Guardian caching, TxSQL monitoring, and workflow and OLAP engine fixes—aimed at delivering a more reliable big‑data platform.
This article presents the design and technical details of 360 Easy Placement, an AI‑driven end‑to‑end advertising platform that automates creative generation, fast review, and optimization, addressing the challenges faced by small‑and‑medium advertisers through data‑rich models, multi‑task learning, and intelligent scene recommendation.
This article presents 19 practical MySQL optimization tips, ranging from using EXPLAIN and proper indexing to rewriting IN/EXISTS queries, avoiding costly ORDER BY RAND(), improving pagination, leveraging full‑text indexes, and applying join and execution‑plan strategies for faster, more efficient database performance.
This article explains Redis's memory model—including memory statistics, allocation strategies, object types, internal encodings, and practical optimization techniques—so developers can accurately estimate memory usage, reduce fragmentation, and improve overall system efficiency.
This article introduces several practical algorithmic tricks—using array indices as counters, applying modulo for circular traversal, employing two‑pointer methods for linked‑list problems, leveraging bit‑shift and bitwise operations, adding sentinel nodes, and optimizing recursive solutions with memoization and bottom‑up DP—each illustrated with Java code examples.
By preloading the MP4 header and initial frames and routing playback through a local proxy that caches range‑requested segments in an LRU disk store, the system moves the moov box to the file start (or fetches it separately), cutting short‑video start‑up latency to roughly 800 ms and delivering near‑instant playback.
This article walks through a real‑world ERP database performance case, detailing the symptoms, metric analysis, root‑cause investigation across hardware, environment, and code, and a three‑phase optimization strategy that dramatically reduced latency and improved system stability.
This article explains how to select the right index for mixed‑type queries, quantitatively compare query performance with and without LIMIT, and safely handle long‑running DELETE statements by using InnoDB status and proper kill techniques.
This article presents eight practical strategies—including upgrading Node.js, leveraging fast-json-stringify, optimizing promises, tuning V8 GC, using streams correctly, and employing node‑clinic tools—to dramatically improve the performance and scalability of Node.js applications.
This guide compiles essential MySQL optimization techniques—including index cardinality, common index pitfalls, effective use of EXPLAIN, handling character sets, online schema changes, and practical slow‑query analysis commands—providing developers with actionable tips to improve query performance and avoid common pitfalls.
This article explains how to assess and model system I/O capabilities, presents common disk and network I/O benchmarking tools, outlines key performance metrics and monitoring utilities, and offers detailed optimization approaches for storage, network, and low‑latency transaction scenarios.
Backend performance can be significantly improved through six key strategies—caching, hardware upgrades, business‑logic optimization, service‑oriented architecture, asynchronous processing, and leveraging search engines—each explained with practical considerations and real‑world examples to enhance system throughput and reliability.
This article curates a selection of essential AI and machine learning books, each introduced by expert recommenders who explain why the titles are valuable for deepening understanding, improving practical skills, and staying current with the latest research trends.
This article explains how Mozilla optimized the Firefox engine to dramatically speed up function calls between JavaScript and WebAssembly by reducing bookkeeping, eliminating trampolines, merging activations, applying monomorphic call optimizations, and improving built‑in function handling, resulting in call performance that now exceeds native JavaScript‑to‑JavaScript calls.
The 2018 Hangzhou Yunqi Conference featured a series of expert talks on intelligent operations, covering Alibaba's AI‑driven maintenance systems, robust supply‑chain optimization, data‑center automation, MSP transformation, and AI‑Ops practices, providing actionable insights for large‑scale infrastructure management.
Alibaba’s algorithm veterans share a curated list of essential AI books—from foundational machine‑learning theory and optimization to deep‑learning and NLP—detailing each title’s strengths, recommended readers, and why these works are indispensable for mastering modern artificial‑intelligence techniques.
This article presents 20 practical Python performance tips—from choosing O(1) data structures and reducing redundant data to leveraging generators, C extensions, multiprocessing, and profiling tools—complete with benchmark code snippets that demonstrate measurable speed gains across common coding patterns.
This guide outlines ten practical Laravel performance‑boosting techniques—from configuration and route caching to class‑map optimization, autoloader tuning, session storage, professional cache drivers, database query improvements, dataset caching, JIT compilers, and front‑end asset merging—providing clear commands and code examples for each.
The article outlines iQIYI’s iOS dynamic‑layout architecture, recommends CADisplayLink for frame‑rate checks and TimeProfiler for deep analysis, then details a two‑phase optimization workflow—eliminating main‑thread bottlenecks (e.g., string formatting, image loading, view hierarchy changes) and reducing off‑screen rendering and layer blending through layer tricks, caching, and asset adjustments—to achieve smoother UI on low‑end devices.
Alibaba's AI specialists present a curated list of essential AI books—covering machine learning fundamentals, optimization, deep learning, NLP, and classic Chinese texts—each with expert commentary on why they are indispensable for both beginners and seasoned practitioners.
This article walks through practical strategies for accelerating React application loading by optimizing first‑screen size, leveraging HTML placeholders, caching frameworks, dynamic polyfills, SplitChunksPlugin, proper Tree Shaking, code‑splitting, ES2015+ compilation, and lazy‑loading techniques, all illustrated with real‑world Webpack 4 configurations.
The article explains why CPython often runs slower than compiled or JIT‑enabled languages by examining the Global Interpreter Lock, the interpreted nature of Python, its dynamic typing, alternative runtimes, and practical optimisation techniques for improving performance.
This article outlines seven frequent misuse patterns in Redis development—such as improper use of collection types, missing expirations, oversized values, inefficient batch operations, unnecessary requests, poor key naming, and unsafe commands—provides real‑world case analyses, and offers practical recommendations to improve Redis health and performance.
This article provides a comprehensive overview of web performance optimization for frontend developers, covering metrics and goal setting, code and DOM optimizations, static asset compression, delivery techniques like async loading and resource hints, build strategies such as tree‑shaking and SSR, and monitoring tools.
This article outlines common geographic, device, browser, and Salesforce org configuration problems that cause slow page loads in Lightning Experience and provides practical mitigation steps such as network latency testing, browser benchmarking, disabling unnecessary plugins, and optimizing Visualforce and Lightning page designs.
Learn seven practical Python optimization techniques—from using local variables and reducing function calls to leveraging generators and pre-compiling code—that can noticeably improve execution speed, lower memory usage, and make your scripts more efficient.
Game AI relies on a variety of search techniques—ranging from uninformed breadth‑first and depth‑first methods to heuristic‑driven A*, minimax with alpha‑beta pruning, and Monte Carlo Tree Search—as well as optimization approaches such as hill climbing, simulated annealing, genetic and evolution strategies, multi‑objective evolutionary algorithms, and neuroevolutionary methods like NEAT to generate intelligent, balanced, and adaptable game behavior.
This article details how the Qidian reading page was optimized by advancing the scroll trigger, continuously preloading upcoming chapters, and applying a throttled scroll handler, resulting in sub‑second load times, minimal loading indicators, and a smoother user experience.
The talk covered Meipai’s personalized deep ranking model that balances depth and low latency, a behavior‑driven video clustering method that enriches recommendation beyond visual cues, and the use of advanced data structures to accelerate solving large‑scale optimization problems in business contexts.
This article introduces the most commonly used algorithms in engineering—recommendation, optimization, estimation, and classification—describes their typical application scenarios, and explores various testing methods and evaluation metrics such as offline experiments, user surveys, A/B testing, and performance indicators like accuracy, coverage, and robustness.
This article describes Qunar's approach to quantifying, automatically detecting, and optimizing performance issues in React Native mobile apps by defining measurable metrics, real‑time data sampling, automated analysis rules, and visual feedback to enable proactive APM during development and testing.
Meitu Technology’s technical salon on June 9, 2018 in Xiamen showcased how its AI‑driven deep ranking, video‑clustering, and data‑structure‑based optimization techniques improve personalization, recommendation and economic‑focused problem solving for billions of mobile users, targeting mid‑senior R&D and algorithm engineers.
The article examines Kerberos KDC performance issues on Meituan‑Dianping’s data platform, showing that PREAUTH halves throughput while RAID10 has little effect, and that a single‑CPU core limits QPS; deploying 40 processes and disabling PREAUTH raises throughput over tenfold, and a lock‑free shared‑memory monitoring module with the kstat tool provides real‑time metrics for troubleshooting.
The article explains how to extend MySQL’s built‑in lexer and Bison‑based parser to expose table names, query features, and optimization advice via a simple language‑agnostic service, illustrating core data structures, useless‑condition elimination, feature generation for slow‑query analysis, and practical learning tips.
This article introduces the most commonly used algorithms in engineering—recommendation, optimization, estimation, and classification—explains their typical application scenarios, and discusses various testing methods and evaluation metrics such as offline experiments, user surveys, A/B testing, and performance indicators like accuracy, coverage, diversity, and robustness.
This article details Suning's step‑by‑step Node.js performance improvements—including CSS/JS registration, EJS template caching, static route optimization, and TPS enhancements—that reduced request latency, cut resource loads, and boosted throughput by up to 75 percent.
This article explains Redis's memory model—including memory statistics, allocation, object structures, internal encoding, and practical optimization techniques—so developers can accurately estimate memory usage, reduce fragmentation, and choose the most efficient data representations for high‑performance applications.
This article explains Redis’s memory model—including memory statistics, allocation, object structures, internal encodings, and practical optimization strategies—providing detailed insights into how Redis stores data, manages memory fragmentation, and how developers can estimate and reduce memory usage for high‑performance deployments.
This article presents a comprehensive 2018 frontend performance checklist that guides teams from establishing a performance culture and selecting metrics to optimizing build processes, static assets, HTTP/2, security, and monitoring, while offering quick‑win actions for immediate impact.
This article presents practical Java backend optimization techniques, covering servlet session memory management, JSP buffering, include strategies, efficient HashMap traversal, array versus ArrayList choices, and best practices for strings, splits, and general code performance.
This article translates hardware latency into human‑scale time, revealing how disks, networks, memory and other components appear painfully slow from a CPU’s viewpoint and why performance optimization is a complex, system‑wide challenge.
This article outlines the most frequent SQL performance mistakes—such as misusing UPDATE, over‑selecting columns, unnecessary double queries, and improper use of GUIDs—and provides concrete, actionable techniques like CASE expressions, temporary tables, batch operations, and table‑valued functions to dramatically improve query speed and concurrency.
This article explains why traditional gradient descent struggles with massive datasets, introduces stochastic gradient descent and mini‑batch gradient descent as efficient alternatives, and provides practical guidance on batch size selection, data shuffling, and learning‑rate scheduling for deep learning models.
This article walks through turning a pure‑Python great‑circle distance function into a Cython‑accelerated version, compares timings, shows how to replace Python's math calls with C library functions, and demonstrates how pure C code can achieve up to a five‑fold performance boost.
This article explains how to improve Java application performance by defining measurable metrics, using load‑testing tools like Gatling, monitoring with APM solutions such as Stackify Retrace, applying code‑level best practices, tuning JVM heap and garbage collection, optimizing JDBC access, and scaling the architecture.
This article explains why MySQL can become a bottleneck as load grows and presents seven practical techniques—using EXPLAIN, building proper indexes, tweaking defaults, caching data in memory, adopting SSDs, scaling horizontally, and improving visibility—to keep MySQL fast and reliable.
This article walks through the design and implementation of a water‑pressure ring H5 game, covering technology selection, code architecture, integration of CreateJS with Matter.js physics, handling of ring rendering, needle collision detection, skill effects, performance optimizations, and practical tips for overcoming common challenges in 2D‑to‑3D simulation.
This article explains why vanilla Stochastic Gradient Descent often struggles in deep learning, describes the challenges of valleys and saddle points, and introduces three major SGD variants—Momentum, AdaGrad, and Adam—detailing their motivations, update rules, and advantages.
This article introduces classic optimization algorithms, distinguishing direct methods that require convexity and closed‑form solutions from iterative first‑ and second‑order methods, and explains their applicability, underlying theory, and key references for solving smooth unconstrained problems.
When all other tuning options fail, this article guides Java developers through a systematic GC optimization process—covering essential concepts, a goal‑oriented workflow, and three real‑world case studies that illustrate adjusting generation sizes, employing CMS flags, and fixing PermGen to dramatically reduce pause times and latency.
This article breaks down the essential mathematics—linear algebra, probability, calculus, and optimization—required for mastering deep learning, explains how each topic maps to core deep‑learning concepts, and outlines six progressive learning stages with concrete examples and recommended textbooks.
Learn a comprehensive methodology for SQL performance tuning, from identifying resource bottlenecks and understanding query processing stages to applying practical optimization tactics such as efficient joins, index usage, avoiding costly operations, and best‑practice guidelines that improve execution speed and resource consumption.
At PyCon China 2023, Dada‑JD Daojia’s algorithm team presented their AI‑driven practices for dynamic pricing, route planning, and order assignment, detailing how multi‑dimensional supply‑demand balancing, genetic‑algorithm‑based TSP solutions, and multi‑objective optimization improve real‑time logistics efficiency.
This guide explains how network bandwidth, quality, switch convergence, server CPU, memory, disk, NIC, Linux kernel parameters, and Nginx compilation and configuration choices together affect Nginx throughput, and provides concrete optimization steps for each layer.
This article explains how Baidu Waimai's risk‑control team uses recurrent neural networks, especially LSTM, within TensorFlow to detect fraudulent merchants and users, compares static and dynamic RNN implementations, demonstrates a MNIST digit‑recognition example, and discusses optimization algorithms and model trade‑offs for real‑time fraud detection.
This article introduces optimization as a core of machine learning, explains the challenges of large‑scale non‑convex problems, and presents a hands‑on gradient verification exercise that shows how to use objective‑value computations to confirm gradient correctness.
This guide presents thirty‑four practical Oracle SQL optimization techniques—from choosing the most efficient table order and rewriting WHERE clauses to leveraging indexes, avoiding SELECT *, using DECODE, and replacing costly operations—helping developers dramatically improve query speed and resource usage.
Part 3 of the Elasticsearch indexing optimization guide advises balancing shard and replica counts, using index aliases, leveraging the Bulk API with appropriately sized batches, dedicating data nodes, and upgrading storage (SSD/RAID 0) while monitoring resources to achieve higher throughput and scalable, reliable clusters.
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 seminar provides professionals with a comprehensive deep dive into Spark’s aggregation mechanisms, examining memory overhead, performance bottlenecks, and practical optimization techniques for large‑scale distributed data processing, enabling attendees to tackle real‑world big‑data challenges more efficiently.
This article presents four practical Java optimization strategies—targeted performance tuning, replacing primitive constants with enums, correctly overriding the equals() method, and increasing the use of polymorphism—to improve system efficiency and code readability while highlighting when each technique should be applied.
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.
The article compiles Meituan‑Dianping engineers' Q&A covering SQL book suggestions, relational versus NoSQL engine choices, performance tuning techniques, time‑series database uses, sharding versus partitioning strategies, query handling in distributed systems, proxy limitations, and practical advice on replication and pre‑database setups.
This article explains Docker's container engine, its layered image storage mechanism, and how leveraging these layers within DevOps pipelines can reduce redundancy, improve update efficiency, and optimize resource usage, illustrated with practical experiments and design guidelines for scalable image management.
This article explains how to measure, analyze, and dramatically improve iOS app launch performance through profiling, removing unused code, compressing assets, and restructuring view controller loading, illustrated with a real‑world WiFi manager case study.
This article explains how to construct regular expressions that balance matching expected strings, avoiding false matches, maintaining readability, and achieving performance, while covering when to use regex, practical JavaScript examples, accuracy techniques for phone numbers and floats, and key optimization strategies.
The paper describes Meituan‑Dianping’s two‑stage recommendation pipeline—recall and ranking—and how a Wide & Deep neural architecture, enriched with extensive user, item, and context features and trained with Adam and cross‑entropy loss, significantly boosts CTR and recommendation novelty, with future plans to add RNNs and reinforcement learning.
The article chronicles a front‑end team's evolution from a tangled 1.0 modular setup through incremental 2.0 and 3.0 optimizations—introducing better module management, automated conflict detection, caching strategies, and build‑time reductions—to achieve a smoother, faster development and release workflow.
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.
This article describes how to consolidate multiple WeChat mini‑programs into a single package by defining engineering standards, extracting common modules, and applying specialized packaging and compression tools to reduce the overall bundle size within the platform's strict limits.
This guide provides a comprehensive overview of MySQL, covering essential commands for login, service control, and status checks, explains SQL statement categories, details supported data types with optimization tips, and lists useful operators, functions, and status‑viewing commands.
This article introduces Ykit, a Webpack‑based build tool created to simplify environment setup, reduce configuration complexity, and accelerate build times through entry filtering, multi‑process compression, and a rich plugin ecosystem, sharing its adoption and future roadmap at Qunar.
Mobile pages load about 40% slower than PC pages, users abandon sites after three seconds, and this article offers practical frontend techniques—reducing HTTP requests, compressing assets, leveraging caching, and adopting HTTP/2—to dramatically improve mobile web performance.
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.
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 introduces the biological concepts behind genetic algorithms, explains their core operators—selection, crossover, mutation—and presents a complete pseudocode, then demonstrates a practical C# implementation using AForge.NET to solve the traveling salesman problem, including code snippets, optimization tips, and performance results.
This article explains how modern websites rely on HTTPS and CDN, details SSL/TLS and HTTP/2 fundamentals, describes Alibaba Cloud's CDN HTTPS architecture, dynamic certificate management, key‑server solutions, optimization techniques, and practical guidance for deploying HTTPS end‑to‑end.
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.
This article explains why page‑load speed matters, shows how to measure ready and load times, and provides concrete front‑end strategies—including reducing render‑blocking scripts and CSS, using responsive and lazy‑loaded images, applying gzip compression, cache‑control, ETag headers, DNS prefetching, and code‑level tweaks—to dramatically improve user experience and reduce bandwidth usage.
A production page stalled because a complex SQL query took over 20 seconds, leading the author to dissect joins and nested subqueries, pinpoint the bottleneck, validate assumptions with quick tests, and share practical lessons on query optimization and table‑size effects.
This article provides an extensive overview of frontend optimization techniques, covering work efficiency, speed performance, stability, responsive design, cross-browser compatibility, SEO best practices, and accessibility measures, offering practical tools, workflows, and strategies to improve web development productivity and user experience.
The article details Qunar's large‑scale adoption of React Native, analyzes the performance shortcomings of the standard RN ListView, and presents the QRN ListView and QRN InfiniteListView optimizations that improve scrolling smoothness, memory usage, and fixed‑height row handling on mobile devices.
This article describes how the YIcon project tackled severe React performance bottlenecks—such as repeated renders, slow diffing, and inefficient key usage—by applying shouldComponentUpdate, component splitting, immutable data structures, stable keys, and production‑grade webpack optimizations, ultimately achieving an 80% speed gain.
This article presents a comprehensive guide to front‑end performance optimization, covering ten practical techniques such as reducing HTTP requests, mastering repaint/reflow, minimizing DOM operations, using JSON, streamlining HTML/CSS, leveraging CDNs, externalizing assets, compressing resources, and managing cookies to improve page load speed and user experience.
This article details how JD.com rebuilt its 2016 homepage using the Athena front‑end engineering suite, covering overall architecture, unified development workflow, performance and experience optimizations, reliability mechanisms, data‑driven monitoring, and future directions such as static pre‑loading and architectural upgrades.
Learn why MySQL tables develop fragmentation, how to measure it using Data_free in INFORMATION_SCHEMA, and the appropriate commands—OPTIMIZE for MyISAM and ALTER ENGINE for InnoDB—to safely reclaim space, with practical scheduling tips to minimize impact on production workloads.
The article recounts a real‑world incident where a complex SQL query took over 20 seconds, explains how to pinpoint whether the slowdown originates from joins or nested subqueries, and shares practical steps and insights for diagnosing and fixing such performance issues.
This guide compiles 34 practical Oracle SQL optimization techniques—from selecting the optimal table order and rewriting WHERE clauses to leveraging indexes, avoiding costly operators, and fine‑tuning execution plans—helping developers dramatically reduce query execution time and resource consumption.
This article outlines a comprehensive set of front‑end optimization strategies—including resource merging, lazy loading, DNS prefetch, CSS/JS best practices, DOM rendering improvements, and image compression—to enhance performance on mobile networks such as 2G/3G/4G.
This article explains Java's String object characteristics—immutability, constant pool optimization, and final class—while offering practical performance tips such as avoiding split(), preferring StringBuilder over '+' concatenation, and choosing optimal conversion methods for primitive types.
This article explains Java String's immutability, constant pool optimization, the impact of the final keyword, and practical techniques such as using split alternatives, StringBuilder/StringBuffer, and efficient primitive-to-String conversions to dramatically improve performance.
This article highlights three of the most valuable performance optimization techniques used in the widely adopted Bluebird Promise library—minimizing function object allocation, reducing object size, and employing lazy‑overwritten no‑op functions—to help developers write faster, more efficient JavaScript code.
This guide walks through practical MySQL optimization steps, including status checks, variable inspection, slow‑query and general‑log configuration, essential management commands, detailed mysqldump usage, mysqldumpslow analysis, and the mysqlsla utility for performance diagnostics.
