Is there any record limitation in ndbcluster? Because I can't insert
more records after it reached 1080000 records. How to solve this?
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Have you checked the type of column you are using. Depending on what the
1080000 number means, it could be altering the table to say int or bigint
column. If it means total number of records, it does not seem to correspond
to a medint value, either signed or not. If it means the record number,
your column might have a large start number. Some new companies don't like
invoicing starting out at record 1. I have no experience in ndbcluster but
I would assume that it has some kind of column limit for performance gains
in indexing.
Mike O'Krongli
Acorg Inc
http://www.acorg.com
----- Original Message -----
From: "sangprabv"
To:
Sent: Thursday, June 18, 2009 1:10 PM
Subject: ndbcluster problem
> Is there any record limitation in ndbcluster? Because I can't insert
> more records after it reached 1080000 records. How to solve this?
>
>
>
> Willy
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mike_tmp@acorg.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
That 1080000 is the total number of records. This caused by the
DataMemory directive in the config and I must increase the value.
Willy
On Thu, 2009-06-18 at 14:10 -0400, Mike OK wrote:
> Have you checked the type of column you are using. Depending on what the
> 1080000 number means, it could be altering the table to say int or bigint
> column. If it means total number of records, it does not seem to correspond
> to a medint value, either signed or not. If it means the record number,
> your column might have a large start number. Some new companies don't like
> invoicing starting out at record 1. I have no experience in ndbcluster but
> I would assume that it has some kind of column limit for performance gains
> in indexing.
>
> Mike O'Krongli
> Acorg Inc
> http://www.acorg.com
>
> ----- Original Message -----
> From: "sangprabv"
> To:
> Sent: Thursday, June 18, 2009 1:10 PM
> Subject: ndbcluster problem
>
>
> > Is there any record limitation in ndbcluster? Because I can't insert
> > more records after it reached 1080000 records. How to solve this?
> >
> >
> >
> > Willy
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=mike_tmp@acorg.com
> >
> >
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org