Reusing deleted variable-size record space

Hello

I have a database with variable-size fields, some of them may be modified/deleted during the usage and administration, so my doubt is: how can I compact the records to remove those blank spaces and save space, lets say "defragment" the database file so data is continuous and contiguous?

This task should be performed just once or twice a month, so no matter if it could take a while.

Is there an internal function to do that? I could copy existing records to a new table, delete all the original ones and then insert them back and drop the second table but don't like it too much.

Thanks for any suggestion

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com