BestHub
Sign in
Tag

temporary table

0 views collected around this technical thread.

Java Tech Enthusiast
Java Tech Enthusiast
Jun 7, 2025 · Databases

How to Optimize Multi-Table Joins in MySQL: Practical Strategies

This article explains why excessive MySQL joins can cause performance problems and provides a comprehensive set of techniques—including query splitting, temporary tables, denormalization, index tuning, query rewriting, result‑set reduction, configuration tweaks, big‑data tools, and summary tables—to effectively optimize multi‑table join queries.

Join OptimizationMySQLSQL indexing
0 likes · 10 min read
How to Optimize Multi-Table Joins in MySQL: Practical Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 13, 2022 · Databases

Bypassing GTID Restrictions on CREATE TABLE … SELECT and Temporary Tables in MySQL 5.6/5.7 and Their Removal in MySQL 8.0

The article explains the strict GTID‑based replication limits on CREATE TABLE … SELECT and temporary‑table statements in MySQL 5.6/5.7, demonstrates practical work‑arounds such as splitting statements or using CREATE TABLE LIKE, and shows how MySQL 8.0’s native DDL atomicity eliminates these constraints.

DDLGTIDMySQL
0 likes · 12 min read
Bypassing GTID Restrictions on CREATE TABLE … SELECT and Temporary Tables in MySQL 5.6/5.7 and Their Removal in MySQL 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
May 12, 2022 · Databases

MySQL 5.7 Crash Analysis: Temporary Table Bug, Reproduction with MTR, and Mitigation Strategies

This article investigates a MySQL 5.7.30 replica crash caused by an InnoDB assertion in btr0btr.cc when handling temporary tables, reproduces the issue using the MySQL Test Run framework, analyzes logs and parameters, and proposes configuration and SQL‑optimisation fixes.

Database ConfigurationInnoDBMTR
0 likes · 15 min read
MySQL 5.7 Crash Analysis: Temporary Table Bug, Reproduction with MTR, and Mitigation Strategies
Selected Java Interview Questions
Selected Java Interview Questions
May 5, 2021 · Databases

Understanding MySQL Temporary Tables, MEM_ROOT Memory Management, and Query Optimization

This article explains how MySQL processes a GROUP BY query on a user view table, detailing the creation and use of memory and disk temporary tables, the MEM_ROOT allocation mechanism, the execution stages revealed by EXPLAIN, and how adding a composite index can eliminate temporary tables and filesort for better performance.

GROUP BYMySQLindex
0 likes · 13 min read
Understanding MySQL Temporary Tables, MEM_ROOT Memory Management, and Query Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 3, 2020 · Databases

Optimizing a Slow MySQL Query with Derived Tables and UNION ALL

This article analyzes a slow MySQL aggregation query that joins a large table with a derived table built from many UNION ALL subqueries, explains the execution plan and derived‑table materialization, and presents two optimization approaches—adding taskname indexes and rewriting the query or using a temporary indexed table—to dramatically reduce execution time while preserving result semantics.

Derived TableMySQLSQL
0 likes · 11 min read
Optimizing a Slow MySQL Query with Derived Tables and UNION ALL
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 11, 2017 · Databases

Why a Simple MySQL IN Subquery Takes 33 Seconds and How to Fix It

This article examines why a seemingly simple MySQL IN subquery on tens of thousands of rows can take 33 seconds, explains the optimizer’s behavior in MySQL 5.5, and presents practical fixes such as using temporary tables or JOINs to dramatically improve performance.

IN clauseMySQLjoin
0 likes · 5 min read
Why a Simple MySQL IN Subquery Takes 33 Seconds and How to Fix It