MEMORY engine | BestHub

Selected Java Interview Questions

Dec 4, 2024 · Databases

Performance Comparison of MySQL MEMORY Engine vs InnoDB Using Large Test Data

This article demonstrates how to create a test table, bulk‑insert two million rows via a stored procedure, convert the table to the MEMORY engine, and compare query performance against the original InnoDB table, highlighting speed gains, configuration tweaks, and practical usage considerations.

DatabaseMEMORY enginePerformance

0 likes · 7 min read

Performance Comparison of MySQL MEMORY Engine vs InnoDB Using Large Test Data

Aikesheng Open Source Community

Dec 30, 2020 · Databases

Understanding MySQL Hash Index Implementation and Use Cases

This article explains how MySQL implements hash indexes, illustrates their data distribution on memory tables, and evaluates their suitable scenarios and limitations compared with B‑tree indexes through detailed SQL examples and performance analysis.

Hash IndexMEMORY enginePerformance

0 likes · 13 min read

Understanding MySQL Hash Index Implementation and Use Cases

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 enginePerformance SchemaTempTable

0 likes · 5 min read

Understanding MySQL Temporary Table Engines and Their Configuration