"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
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 says
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 modifie
