Tagged articles
Query Rewrite
14 articles · Page 1 of 1
This article walks through common MySQL performance pitfalls such as inefficient pagination, implicit type conversion, costly UPDATE/DELETE subqueries, mixed sorting, and EXISTS clauses, and demonstrates practical rewrites—including index usage, JOIN conversion, condition push‑down, early LIMIT, and WITH‑clauses—to transform slow queries into millisecond‑level executions.
IndexMySQLPagination
0 likes · 13 min read

This article presents eight practical MySQL performance‑tuning techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting updates and deletes with JOIN, handling mixed ordering, replacing EXISTS with JOIN, pushing conditions down, early range reduction, and using WITH clauses—to transform slow queries into millisecond‑level executions.
MySQLQuery RewriteSQL Optimization
0 likes · 14 min read

This article explores eight common MySQL performance pitfalls—from inefficient LIMIT clauses and implicit type conversions to suboptimal JOIN updates, mixed sorting, EXISTS usage, condition pushdown, early result limiting, and intermediate result set handling—offering rewritten queries and execution plan analyses that dramatically improve execution times.
Database IndexesMySQLQuery Rewrite
0 likes · 13 min read

WeTune 2.0, a revolutionary tool developed by Shanghai Jiao Tong University and GaussDB experts, automatically discovers and validates SQL rewrite rules, dramatically improving query performance in Huawei Cloud GaussDB by eliminating manual rule creation, supporting extensive rule enumeration, equivalence verification, and cost‑based evaluation, while addressing scalability challenges.
GaussDBQuery RewriteSQL Optimization
0 likes · 11 min read

This article presents eight practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting joins, handling mixed ordering, replacing EXISTS with joins, pushing down conditions, pre‑filtering data, and using WITH clauses—to dramatically reduce query execution time.
MySQLQuery RewriteSQL Optimization
0 likes · 13 min read

This article examines common MySQL performance pitfalls—such as large OFFSET limits, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, and condition push‑down—and demonstrates concise rewrites, including JOINs, UNION ALL, early range reduction, and WITH clauses that can reduce query execution from seconds to milliseconds.
MySQLQuery RewriteSQL Optimization
0 likes · 13 min read

In this article the author walks through a real‑world slow‑query case, using EXPLAIN, rewriting EXISTS clauses with JOIN + GROUP BY and swapping NOT EXISTS for NOT IN, ultimately reducing execution time from 8 seconds to 0.7 seconds while sharing key indexing insights.
EXPLAINQuery RewriteSQL
0 likes · 6 min read

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.
MySQLPerformance OptimizationQuery Rewrite
0 likes · 13 min read

This article analyzes the requirements, design choices, and implementation details of materialized views in StarRocks, covering demand analysis, synchronous and asynchronous refresh solutions, partition binding, task scheduling, partition‑refresh maintenance, Insert‑Overwrite mechanics, view invalidation handling, and the upcoming features planned for version 2.5.
Async RefreshInsert OverwriteMaterialized View
0 likes · 14 min read

This article examines frequent MySQL performance pitfalls—such as misuse of LIMIT, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, and condition push‑down failures—and demonstrates how rewriting queries with proper indexes, JOINs, early range reduction, and WITH statements can dramatically reduce execution time.
MySQLQuery RewriteSQL Optimization
0 likes · 15 min read

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.
MySQLQuery Rewriteplugin
0 likes · 8 min read

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.
MySQLQuery RewriteSQL Performance
0 likes · 8 min read


ITPUBJul 31, 2019 · Databases
This article presents practical MySQL performance tricks—including smarter LIMIT usage, avoiding implicit type conversion, rewriting UPDATE/DELETE with JOIN, handling mixed ordering, replacing EXISTS with JOIN, pushing down conditions, narrowing result sets early, and leveraging WITH clauses—to dramatically reduce query execution times.
MySQLQuery RewriteSQL Optimization
0 likes · 14 min read

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.
MogujiePersonalizationQuery Rewrite
0 likes · 11 min read
