Hi.
On Tue, Nov 20, 2001 at 09:26:51AM +0000, [EMAIL PROTECTED] wrote:
> 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 ?
Yes, I think so.
> Also will Mysql clear the slack space / optimize my database (not sure of
> wording) :) after a set length of time ?
No.
> or must I do this manually due to the length of time it must take ?
[...]
Yes.
You only need to do this, if you notice performance problems, or you
want to reclain the disk space.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
