Hello Renito -
What you are looking for is MySQL's OPTIMIZE function:
http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
It does exactly what you are looking for.
You can implement this manually, via shell script on a timer, etc. I have
written a multi-threaded perl solution which will c
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?
