Files never get smaller. They can only grow. Deleteing a record marks the area used as available, but does not remove it from the file. I believe you will have to optimize the table to pack out the unused records.
This is another good argument for storing images in the filesystem, and only their locations in the database. [EMAIL PROTECTED] wrote: >Hi > >I am a mysql user. I use a long blob field to store image data. >But whenever I make a deletion with my image data I find that the >hard disk availability is still intact. There is no change. What >could be the problem with my delete statement. > >Please Help > > > >Regards > > > >Roslee AJ > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
