Bug #78554 Convert MEMORY to an optional storage engine plugin
Submitted: 25 Sep 2015 8:22 Modified: 25 Sep 2015 8:23
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Memory storage engine Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[25 Sep 2015 8:22] Laurynas Biveinis 
Description:
Convert MEMORY to an optional (but built and tested by default) storage engine plugin

- Use InnoDB temp tables for small / non-BLOB optimizer temp tables too, remove the memory -> disk temp table conversion, --big-tables, tmp-table-size, created_disk_tmp_tables, etc.
- Prepend memory- prefix to all the MEMORY-specific options (e.g. max_heap_table_size) so that they can be moved to the plugin from the server core.
- Make MEMORY build as a shared library plugin, ensure server works without it present, remove as many "if (table se is memory) then this else that" checks from the core server as possible (if actually present after MEMORY temp table cleanup).
- Move MEMORY tests to a separate MTR suite.

The above list is probably incomplete.

How to repeat:
.

Suggested fix:
.
[25 Sep 2015 8:23] Laurynas Biveinis 
See also bug 78553
[18 Jun 2016 21:28] Omer Barnir 
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0