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 check, repair and optimize tables simultaneously to save time: http://dbuettner.dyndns.org/blog/?page_id=88 HTH, Dan On 9/30/07, Renito 73 <[EMAIL PROTECTED]> wrote: > > 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/[EMAIL PROTECTED] > >
