Aman Raheja [EMAIL PROTECTED] wrote:
$ perror 28
Error code 28: No space left on device
I agree that there is not much disk space.
THE ISSUE: I want to reclaim the disk space that should be freed because
of the millions of records I deleted. I need disk space to reclaim disk
space?
I have a HUGE table, with hundreds of millions of records.
mytab.MYD 78GB
mytab.MYI 16GB
I decided to get rid of some old data because I can't INSERT into this
table anymore, since the MAX for index file is reached.
Following is what I did and what I got.
mysql DELETE FROM mytab WHERE
When you delete records, space is freed up within the table, not from
the disk. Just like when you delete a file, it's not deleted, the space
is just marked as available. So technically you do now have space in
your table and you may be able to do inserts. I'm pretty sure the
documentation