On April 21, 2026 MySQL 8.0 officially ends its eight‑year run as Oracle releases 8.4.9 LTS and 9.7.0 LTS, introducing long‑term support, new security plugins, Hypergraph Optimizer, JSON Duality Views, cgroup enhancements, and detailed upgrade paths, while warning of severe risks for unpatched 8.0 deployments.
This article details the year‑long exploration of Profile‑Guided Optimization (PGO) for WeChat’s backend, covering its theory, compiler implementations, practical experiments with Propeller and BOLT, transparent eBPF sampling, engineering challenges, and the measurable CPU and memory savings achieved across production services.
This article explains how Profile‑Guided Optimization (PGO) can increase MySQL throughput by 30‑50% without changing application code, detailing the required compilation steps, necessary CMake flags, and real‑world benchmark results that demonstrate the performance gains and their limitations.
This article explains the principles of Profile‑Guided Optimization, outlines the three‑step workflow, demonstrates practical PGO implementations for Go and C++ with code examples and devirtualization techniques, and presents benchmark results showing significant latency reduction and throughput improvement.
Profile‑Guided Optimization (PGO) collects runtime profiling data to recompile programs for higher performance, reducing branch mispredictions and improving code layout; Go gained built‑in PGO in 1.21 with typical 5 % gains, while C++ sees 15‑18 % QPS improvements and devirtualization benefits, and future work aims at deeper block ordering and register allocation.
This technical report details the background, hardware configuration, database setup, tuning results, and step‑by‑step optimization procedures—including BIOS, OS, network, container NUMA binding, MySQL CRC32 patching, and Go PGO tuning—performed to improve JED performance on ARM compared with Intel.
Go 1.21 has been officially released, introducing toolchain improvements such as GA‑ready profile‑guided optimization, new built‑in functions, several standard library packages, performance boosts, and experimental support for the WebAssembly System Interface (WASI).
This article explains ByteDance's large‑scale adoption of profile‑guided optimization (PGO), covering its principles, instrumentation and sampling methods, the automated platform built for data collection and compilation, and the resulting performance gains across dozens of critical services.
The article details OMAX’s end‑to‑end platform for large‑scale C/C++ service compilation, covering optimization flags, profile‑guided and link‑time techniques, Facebook BOLT post‑link tuning, and real‑world results that cut CPU use, latency and deployment time while shrinking binary size.
Alinode PGO leverages profile‑guided optimization to generate a cache of hot startup code for Node.js functions, cutting cold‑start latency by up to 61% (150% speed‑up) and allowing further reductions by launching solely from the PGO cache, as demonstrated with real‑world benchmarks.
By generating an order file that places frequently executed code contiguously, the authors reduce iOS app cold‑launch page faults by about 15%, achieving roughly a 10% launch‑time improvement without code changes, using runtime hooking and static analysis to build the symbol ordering.
This guide outlines five practical steps—enabling Zend Opcache, compiling with GCC 4.8+, activating HugePages, configuring Opcache file cache, and applying PGO—to extract the maximum speed from PHP 7 installations, especially for high‑traffic sites like WordPress.
This article introduces PHP 7.0.0’s major performance enhancements and provides five practical tuning steps—including enabling Opcache, using a newer GCC compiler, activating HugePages, configuring Opcache file cache, and applying profile‑guided optimization—to maximize speed and efficiency for backend applications.
