On Wed, 2006-03-01 at 10:40 +0800, David wrote:
> On Wed, 01 Mar 2006 07:52:40 +0800, Stewart Smith <stewart@stripped>
> wrote:
>
> > On Tue, 2006-02-28 at 14:49 +0800, David wrote:
> >> 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 store engine, its size becomes 1.4G
> >> My table architecture is:
> >
> > My guess is you're using 4.1 or 5.0, which have fixed sized rows for
> > cluster.
>
> Do you mean if I use MySQL 5.1.16, the table will become much small?
yes.
Although keep in mind that 5.1 isn't GA yet. So we don't recommend use
in production.
--
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@stripped
Mobile: +61 4 3 8844 332
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
