ch huang wrote:
> hi all,i have a big table ,and i do disk data file with it ,and i allocate
> the DM 5900M,IM 660M ,after i put the whole table to the NDB,it took the 70%
> DM and 32% IM ,so i want to do optimize with it ,but i wonder if it is
> helpful to do so,because a put a lot of data in the disk not the memory.
>
Hi,
OPTIMIZE TABLE is currently not supported for NDB Disk Data tables. It
is supported only for dynamic columns of in-memory tables.
See http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html and the
section beginning with "Recovery of memory from deleted rows" on
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations-resolved.html.
cheers
jon.
--
Jon Stephens - jon.stephens@stripped
Technical Writer
MySQL Documentation Team
Sun Microsystems AB
MySQL and Software Infrastructure Group
Liljeholmen (Stockholm), Sweden
Summer: UTC +02.00 / Winter: UTC +01.00
Mobile: +46 (0) 736 773 993
Skype: plastic-fish
MySQL: www.mysql.com
Sun: www.sun.com
