Why MySQL Crashes on TempTable Index Scans and How MySQL 8.0.30 Fixed It

A customer on MySQL 8.0.28 experienced a crash when a complex query used an internal temporary table, exposing a bug in the TempTable storage engine that caused a null pointer dereference during index initialization, a problem that was resolved in MySQL 8.0.30 with additional safety checks.

Database CrashIndex Scan BugMySQL 8.0.30 Fix

0 likes · 23 min read

Why MySQL Crashes on TempTable Index Scans and How MySQL 8.0.30 Fixed It

Aikesheng Open Source Community

Aug 30, 2021 · Databases

Changes in MySQL Internal Temporary Table Storage from 5.6 to 8.0

This article explains how MySQL handles internal temporary tables, detailing the evolution of storage mechanisms and related parameters from version 5.6 through 5.7 to 8.0, including the shift to TempTable, shared session temporary tables, memory‑mapped files, and configuration tips to avoid space issues.

ConfigurationTempTableinternal temporary tables

0 likes · 9 min read

Changes in MySQL Internal Temporary Table Storage from 5.6 to 8.0

Aikesheng Open Source Community

Jul 11, 2019 · Databases

Understanding MySQL Temporary Table Engines and Their Configuration

This article explains the two types of MySQL temporary tables, the Memory and user‑defined engines, how to create them, monitor their usage with status variables, and the new TempTable engine introduced in MySQL 8.0 along with relevant configuration parameters.

MEMORY engineTempTablemysql

0 likes · 5 min read

Understanding MySQL Temporary Table Engines and Their Configuration

Why MySQL Crashes on TempTable Index Scans and How MySQL 8.0.30 Fixed It

Changes in MySQL Internal Temporary Table Storage from 5.6 to 8.0

Understanding MySQL Temporary Table Engines and Their Configuration

Why MySQL Crashes on TempTable Index Scans and How MySQL 8.0.30 Fixed It