Tagged articles
PGO
15 articles · Page 1 of 1
MySQL 9.7 LTS brings enterprise-grade features like replication observability, hypergraph optimizer, PGO, and JSON Duality Views DML to the community edition, delivering up to 14% performance gains via PGO, but lacks vector similarity search functions for RAG workloads.
Hypergraph optimizerJSON Duality ViewsLTS
0 likes · 14 min read


ITPUBMay 14, 2026 · Databases
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.
8.4.99.7.0Hypergraph optimizer
0 likes · 22 min read

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.
CompilerPGObackend services
0 likes · 48 min read


ITPUBMay 2, 2024 · Databases
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.
C++MySQLPGO
0 likes · 10 min read


DevOpsOct 29, 2023 · Fundamentals
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.
C++CompilerPGO
0 likes · 15 min read

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.
C++GoPGO
0 likes · 16 min read

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.
ARMMySQLPGO
0 likes · 12 min read

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).
PGOProgramming LanguageToolchain
0 likes · 6 min read

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.
ByteDancePGOcompiler optimization
0 likes · 12 min read

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.
BoltC++LTO
0 likes · 24 min read

This tutorial walks through installing the CrunchyData Postgres Operator, creating a PostgreSQL cluster named hippo with kustomize, inspecting its resources, configuring services, secrets, and TLS for secure connections, modifying service types, deploying a Keycloak application using the generated credentials, and finally deleting the cluster while handling PVC retention.
CrunchyDataKeycloakKubernetes
0 likes · 12 min read

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.
Node.jsPGOcold start
0 likes · 4 min read

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.
App LaunchBinary ReorderingHooking
0 likes · 13 min read


21CTOJan 2, 2016 · Backend Development
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.
HugePagesOPcachePGO
0 likes · 5 min read


21CTODec 8, 2015 · Backend Development
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.
HugePagesOPcachePGO
0 likes · 5 min read
