David wrote:
> As mentioned in MySQL Reference Manual, it has overheads in MySQL Cluster,so
> the size is theoretically bigger than original
> My calculation is:
> select table_name,engine,round(data_length/1024/1024,2) from
> Information_Schema.tables where table_name = 'user1'
> +------------+------------+--------------------------------+
> | table_name | engine | round(data_length/1024/1024,2) |
> +------------+------------+--------------------------------+
> | user1 | MyISAM | 332.81 |
> | user1 | NDBCLUSTER | 259.84 |
> +------------+------------+--------------------------------+
probably fragmentation on the MyISAM side, i'd guess that
OPTIMIZE TABLE would reduce the size of the MyISAM table
below the NDBCLUSTER value ...
--
Hartmut Holzgraefe, Senior Support Engineer .
MySQL AB, www.mysql.com
