Performance Optimization Practices for KwaiBI Big Data Analysis Platform

This article introduces KwaiBI, the internal data analysis product of Kuaishou, outlines its five major functional areas, details the performance challenges of large‑scale analytics, and presents a comprehensive set of optimization techniques—including cache warming, query rewriting, materialized acceleration, and the Bleem lake‑house engine—along with future directions and a brief Q&A.

Big DataData AnalyticsKwaiBI

0 likes · 15 min read

Performance Optimization Practices for KwaiBI Big Data Analysis Platform

Aikesheng Open Source Community

Sep 21, 2020 · Databases

Understanding Semi‑join Materialization in MySQL Subquery Optimization

This article explains how MySQL transforms eligible subqueries into semi‑joins, describes the four semi‑join strategies, and details the Semi‑join Materialization approach—including Materialization‑scan and Materialization‑lookup—while showing how to identify the chosen strategy via EXPLAIN output.

Database PerformanceMaterializationSemi-Join

0 likes · 9 min read

Understanding Semi‑join Materialization in MySQL Subquery Optimization

dbaplus Community

Dec 5, 2015 · Databases

Why Adding an OR Clause Makes a MySQL Query 40× Faster – Materialization vs Semi‑Join

An expert MySQL case study compares two similar queries—one using a materialized subquery and the other with an OR condition that triggers index reads—showing the former runs about 40 times slower, and explains the impact of materialization, semi‑join optimization, and index usage on performance.

Index UsageMaterializationSemi-Join

0 likes · 7 min read

Why Adding an OR Clause Makes a MySQL Query 40× Faster – Materialization vs Semi‑Join