MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Keith C. Ivey Date:November 26 2002 2:58pm
Subject:Re: [MySQL v3.23.53a] BLOB Data and Table Size
View as plain text  
On 26 Nov 2002, at 8:52, Pae Choi wrote:

> Q: How come the size of table does not decrease
>     after deletion?

MySQL will reuse that space when you insert new records.  To recover 
the space, you need to optimize the table:

http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html


> P.S.: MySQL, SQL, and Query(to clarify that it's not
> spam nor OT).


-- 
Keith C. Ivey <keith@stripped>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653
Thread
[MySQL v3.23.53a] BLOB Data and Table SizePae Choi26 Nov
  • Re: [MySQL v3.23.53a] BLOB Data and Table SizeKeith C. Ivey26 Nov
    • Re: [MySQL v3.23.53a] BLOB Data and Table SizePae Choi26 Nov
      • Re: [MySQL v3.23.53a] BLOB Data and Table SizePaul DuBois26 Nov
    • Re: [MySQL v3.23.53a] BLOB Data and Table SizePae Choi26 Nov
  • re: [MySQL v3.23.53a] BLOB Data and Table SizeEgor Egorov26 Nov
  • Re: [MySQL v3.23.53a] BLOB Data and Table SizeJohn Ragan26 Nov