The 2020-12-03: mysql, Heap table is what? # # f greatly architects a daily topic

CodePudding user response:

TYPE=HEAP table and table is the same as the ordinary, use the field TYPE and the where condition limit comparison operators

CodePudding user response:

Mysql, 8.0
MEMORY table, it is on the table in the MEMORY, the size of the MEMORY used by My... the CNF max_heap_table_size specified, when creating a table in the last specified ENGINE=MEMORY
1, the table definition in disk, extension. FRM, restart is not lost
2, the data stored in memory, the restart will lose
3, supporting the AUTO_INCREMENT column, do not support transaction
4, all client sharing, performance when the data changes frequently
5, multi-threaded Shared, all user connections is visible