Just to clarify; My understanding now,
If I delete row 14 (example) the next time I create any data in my database it will be put in the now slack space that used to contain row 14 ? if it does not entirely fit in this space, the data that did not fit will be put in the next empty / slack space in my databases files, this will continue until I have no more slack / empty space, then the file will get grow ? eg if I create a 200 Meg database, then delete almost all the contents it will not reduce in size on my disk. If I run optimize table or another such command it will clear the data from the disk and my database will reduce in size (disk space). Am I now correct ? Also will Mysql clear the slack space / optimize my database (not sure of wording) :) after a set length of time ? or must I do this manually due to the length of time it must take ? Gratefully, Steve. On Monday 19 November 2001 17:24, you wrote: > the deleted rows will get re-used by inserts. > > however, you can always run OPTIMIZE TABLE XXX and that will clear the > deleted rows > > thanks, > > -- Andrew --------------------------------------------------------------------- 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
