Re: how to refresh the memory allocation for a database after a huge delete operation?

[Yuvaraj Thiagarajan]

Thanks Umesh!

That's exactly what I was looking for...


Umesh Shastry wrote:
> Hi!!..
>
> (Take the backup of your DB before doing anything
> here)
>
> I think you can make use of OPTIMIZE command to do
> the cleanup after deletion of records/structure..
>
>
>
> An optimized table structure is different than a
> well-designed table. Table structure optimization
> has to do with reclaiming unused space after
> deletions and basically cleaning up the table
> after structural modifications have been made. The
> OPTIMIZE SQL command takes care of this, using the
> following syntax:
>
> OPTIMIZE TABLE table_name[,table_name]
>
> Be aware that the table is locked while it is
> optimized, so if your table is large, optimize it
> during scheduled downtime or when little traffic
> is flowing to your system.
>
> NOTE
>
> You can use OPTIMIZE on only MyISAM and BDB
> tables
>