Hi there, I have a table with three columns, two varchar(12) identifiers and a longtext column with very long (some > 50 MB) strings. The size of the chromosomes.MYD table was about 2.8 GB. The table was used transiently and I no longer needed to store the strings, so in the interest of freeing up space I did the following:
mysql> UPDATE chromosomes SET sequence = ""; When I query the database I can see that the sequence field is a null string for each record. However, the size of the chromosomes.MYD file in the data directory has not changed (i.e. it is still about 2.8 GB). SHOW TABLE STATUS (in mysql) and df (at the shell prompt) both report the same value. How can I get the table size to correspond to the small amount of data that actually remains in the table? Thanks for your assistance. Best regards, Craig Cummings, Ph.D. Research Associate Relman Laboratory Stanford University School of Medicine Department of Microbiology and Immunology and VA Palo Alto Health Care System e-mail: [EMAIL PROTECTED] phone: 650-493-5000 x63249 fax: 650-852-3291 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
