From: Date: March 13 2006 4:16am
Subject: Amazing with MySQL 5.1.7
List-Archive: http://lists.mysql.com/cluster/3285
Message-Id: <258a555a0603121916w4a542504l@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_4528_31291667.1142219767453"

------=_Part_4528_31291667.1142219767453
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I've posted a question in http://lists.mysql.com/cluster/3237
I have a table with MyISAM store engine and its size is about 340M with
5,000,000 rows
When I convert it to NDBCLUSTER with 5.0.18 store engine, its size becomes
1.4G
With MySQL 5.1.7 beta, its size becomes 259.84M
Huh, much smaller than MySQL 5.0.18
But I confused about it, why its smaller then the original ?
As mentioned in MySQL Reference Manual, it has overheads in MySQL Cluster,s=
o
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 =3D 'user1'
+------------+------------+--------------------------------+
| table_name | engine | round(data_length/1024/1024,2) |
+------------+------------+--------------------------------+
| user1 | MyISAM | 332.81 |
| user1 | NDBCLUSTER | 259.84 |
+------------+------------+--------------------------------+




Thanks, :)

------=_Part_4528_31291667.1142219767453--