Memory usage and recovery-opracowanie

Memory usage and recovery. Memory consumed when data is inserted into an NDB table is not
automatically recovered when deleted, as it is with other storage engines. Instead, the following rules
hold true:
• A DELETE statement on an NDB table makes the memory formerly used by the deleted rows
available for re-use by inserts on the same table only. However, this memory can be made available
for general re-use by performing OPTIMIZE TABLE.
A rolling restart of the cluster also frees any memory used by deleted rows. See Section 17.5.5,
“Performing a Rolling Restart of a MySQL Cluster”.
• A DROP TABLE or TRUNCATE TABLE operation on an NDB table frees the memory that was used by
this table for re-use by any NDB table, either by the same table or by another NDB table.
... zobacz całą notatkę