Ruslan Spivak <[EMAIL PROTECTED]> wrote on 21/06/2004 12:22:04:
> I have quite big database - around 15Gb(~ 180 million of rows).
> My problem is that after deleting 70million of rows(with 'delete from'
> statement) database file size didn't decrease - it's still 15Gb.
>
> Can anybody give me advice, what i'm doing wrong, why db size is the
> same after deleting around 1/3 of all rows.
> Thanks in advance
I am assuming you are using MyISAM table type. MySQL does not normally
compress the files when deleting records because that would mean shuffling
up all the data in the file, which would be a very slow operation.
Instead, it leaves holes which are filled in when new records are added.
If you want to reclaim the space, you must OPTIMIZE the tables, which
rebuilds them in a new file and discards the old.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
