The configuration community:
Search the Site:

max_heap_table_size

Information

This variable sets the maximum size to which MEMORY (HEAP) tables are allowed to grow. The value of the variable is used to calculate MEMORY table MAX_ROWS values. Setting this variable has no effect on any existing MEMORY table unless the table is re-created with a statement such as CREATE TABLE or altered with ALTER TABLE or TRUNCATE TABLE. This variable was added in MySQL 3.23.0.

Syntax

Example

728x90