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 !
I Finally found the answer to this "problem":
Similar to OPTIMIZE TABLE for ordinary tables.
|All times are GMT -5. The time now is 12:16 PM.|