Re: shrink data file of a myisam table
Posted by:
James Day
Date: April 25, 2005 05:02PM
For MyISAM, optimize table will rebuild the whole table and reduce the size, if there's enough information deleted that it makes a visible difference.
For InnoDB it won't decrease the size of the shared tablespace.
Subject
Views
Written By
Posted
20204
March 31, 2005 01:07PM
11442
March 31, 2005 10:30PM
11784
April 01, 2005 10:20AM
9844
April 25, 2005 02:58AM
Re: shrink data file of a myisam table
10863
April 25, 2005 05:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.