Bug #40998 Delete Data Not Add Space Harddisk
Submitted: 25 Nov 2008 5:12 Modified: 25 Nov 2008 5:18
Reporter: hady ginanjar Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:4.0.13 OS:Any
Assigned to: CPU Architecture:Any

[25 Nov 2008 5:12] hady ginanjar 
Description:
Dear MySql Team,

I have problem with delete the records. When i delete many records in one table, but no any change space of my harddisk and size of the table.MYD still same with table.MYD before deleted. my code is "delete from po where ord_no='12345'". Any mistake with my code ?? Pls adv.

Thanks
Hady

How to repeat:
Dear MySql Team,

I have problem with delete the records. When i delete many records in one table, but no any change space of my harddisk and size of the table.MYD still same with table.MYD before deleted. my code is "delete from po where ord_no='12345'". Any mistake with my code ?? Pls adv.

Thanks
Hady
[25 Nov 2008 5:18] Valeriy Kravchuk 
This is not a bug. Please, read the manual, http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html, on how to reclaim the space after delete.