BestHub
search
Sign in
Tag

query-rewrite

1 views collected around this technical thread.

Laravel Tech Community
Laravel Tech Community
Aug 28, 2023 · Databases

Common MySQL Performance Issues and Their Optimization Techniques

This article examines frequent MySQL performance problems such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, and intermediate result handling, and provides concrete SQL rewrites and execution‑plan analyses to dramatically improve query speed.

Execution PlanIndexingMySQL
0 likes · 13 min read
Common MySQL Performance Issues and Their Optimization Techniques
Python Programming Learning Circle
Python Programming Learning Circle
Dec 5, 2020 · Databases

Using MySQL Query Rewrite Plugin: Installation, Configuration, and Performance Evaluation

This article explains how to install MySQL's Query Rewrite plugin, define and manage rewrite rules, test its impact on large‑scale SELECT queries with sysbench, and demonstrates that enabling the plugin can reduce count(*) execution time from seconds to milliseconds with minimal overall database overhead.

DatabaseMySQLPerformance
0 likes · 8 min read
Using MySQL Query Rewrite Plugin: Installation, Configuration, and Performance Evaluation
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 15, 2020 · Databases

Using MySQL 8.0 Statement Digest and Digest Text Functions for SQL Summarization

The article explains MySQL 8.0's new statement_digest() and statement_digest_text() functions, showing how they generate normalized SQL texts and SHA2 hashes to group similar queries, and demonstrates practical applications in performance schema analysis and query‑rewrite plugins with concrete code examples.

Database OptimizationSQL performanceStatement Digest
0 likes · 8 min read
Using MySQL 8.0 Statement Digest and Digest Text Functions for SQL Summarization
Architecture Digest
Architecture Digest
Apr 2, 2017 · Artificial Intelligence

Mogujie's Search System Architecture and Online Request Flow

This article introduces Mogujie's end‑to‑end search system architecture, detailing its online and offline components such as Topn, ABTest, QR, fine‑ranking, search engine, UPS, and feature platforms, and then walks through a real‑world online request example to illustrate how queries are processed, rewritten, personalized, and finally ranked.

MogujieRankingonline flow
0 likes · 11 min read
Mogujie's Search System Architecture and Online Request Flow