MySQL administration

[thoand]

Hi,
If I've got this right MySQL actually does not delete from the HD when I do a "DELETE FORM foo WHERE id = 4", so I save no HD space when doing this, right?

Is there any commands that will somehow compress my table so all those "empty holes" goes away and I save harddisk space?

I read about this in the SQL lites FAQs
http://www.hwaci.com/sw/sqlite/faq.html#q14

As it says "When you delete information from an SQLite database, the unused disk space is added to an internal "free-list" and is reused the next time you insert data"

Does MySQL do the same?

And in SQL lite you can shrink the file using VACUUM command,
I did not found this in the MySQL manual, but since MySQL table is divided in different files, the concept is a bit different,

can anyone provide me with som help on this issue?

Thanks in advance,
Thomas A.

[nemonoman]

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

You can find the optimize table option in phpmyadmin by selecting a table and choosing the 'OPERATIONS' tab