Freeing DATA_FREE mysql HEAP tables?
I run an application which uses several Memory tables (heap).
Sometimes a script deletes a lot of data from them. But if I do "SHOW TABLE STATUS" Data_free field still has a lot of bytes (in order of 200Mb indeed). Is there any way to free that memory space without dropping and recreating those heap tables? Because of the proprietary application I run in those server I had to stick with old mysql version 3.23 ! Thanks! |
I Finally found the answer to this "problem":
Code:
ALTER TABLE my_table ENGINE=MEMORY; Code:
ALTER TABLE my_table TYPE=HEAP; Similar to OPTIMIZE TABLE for ordinary tables. |
All times are GMT -5. The time now is 05:13 PM. |