Hi
Thanks a lot for you answer, but i think I am
doing something wrong.. I still get some errors,
and I think I do not have well configured my
cluster. .. Now asking for advise
My DB has aprox 6 Millon registers tables with
100 attributes most Varchar and indexing only
5 of these attributes.
DataMemory on 1000M and IndexMemory on 400M
I have two DB servers dual P4 with 2G RAM
Could someone tell me if I am missing some
other configuration value ..
Pleeeasee .. .. Cheers
----- Original Message -----
From: Martin Skold <Martin.Skold@stripped>
Date: Mon, 20 Sep 2004 20:39:32 +0200
To: kasandra Padisha <kasandra@stripped>
Subject: Re: create and alter table CAN'T
> Hi Kasandra!
>
> Error 708 means "No more attribute metadata records".
> Have you created many tables (and attributes)?
> Try increasing MaxNoOfAttributes.
>
> BR
> -- Martin
>
>
> kasandra Padisha wrote:
>
> >Hi again
> >
> >I got my cluster running after altering the DataMemory..
> >and then we continue making tests and we have two more interesting problem: ....
>
> >when creating some tables we got a "can't create table".
> >And when trying an alter table .. it could not
> >rename !!.
> >
> >Thanks in advance for the help .. cheers
> >
> >-------------------------------
> >
> >
> >>mysql> create table nueva(
> >> -> recordType varchar(2),
> >> -> callTransactionType varchar(3),
> >> -> servedmsisdn varchar(15),
> >> -> servedIMEITAC varchar(6),
> >> -> servedIMEIFAC varchar(2),
> >> -> servedIMEISNR varchar(6),
> >> -> servedIMEISP varchar(2),
> >> -> servedMSRN varchar(15),
> >> -> startOfChargingdate date,
> >> -> timeStamp time,
> >> -> callDuration integer,
> >> -> otherpartylongnumberb varchar(20),
> >> -> dialledOtherPartyB varchar(20),
> >> -> thirdpartyb varchar(20),
> >> -> exchangeId varchar(15),
> >> -> tgrpNameIc varchar(10),
> >> -> cicIc varchar(6),
> >> -> tgrpNameOg varchar(10),
> >> -> cicOg varchar(6),
> >> -> sequenceNumber integer,
> >> -> CIDMCC varchar(3),
> >> -> CIDMNC varchar(3),
> >> -> CIDLAC varchar(3),
> >> -> cId varchar(5),
> >> -> inflag varchar(2),
> >> -> inservicekey varchar(2),
> >> -> intermediateSequenceNumber integer,
> >> -> drcCallId varchar(16),
> >> -> drcCallRN varchar(16)
> >> -> )
> >> -> TYPE=NDB
> >> -> ;
> >>ERROR 1005 (HY000): Can't create table './cdr/nueva.frm' (errno: 4336)
> >>
> >>
> >>
> >>
> >.---------------------------------
> >
> >
> >mysql> alter table bog_20040514 rename to new_20040514;
> >ERROR 1025 (HY000): Error on rename of './cdr/bog_20040514' to
> './cdr/new_20040514' (errno: 708)
> >
> >----------------------------------------------------
> >
> >
> >
> >
> >
> >-------------------- old mail ------------------
> >
> >
> >>Hi
> >>
> >>I have a cluster running using mysql-4.1.4a-gamma, on debians 3.0
> >>stable. It has a master (MGM), two DBs and two (API). I included
> >>the config.ini file at the end.
> >>
> >>It works pretty well, we have test it all, from one API, from the
> >>other, the sync works OK, .. everything looking good
> >>
> >>
> >>--------------------------------------- config.ini ---------------
> >>[DB DEFAULT]
> >>NoOfReplicas: 2
> >>
> >>[COMPUTER]
> >>Id: 1
> >>HostName: mgm
> >>
> >>[COMPUTER]
> >>Id: 2
> >>HostName: proc1
> >>
> >>[COMPUTER]
> >>Id: 3
> >>HostName: proc2
> >>
> >>[MGM]
> >>Id: 1
> >>ExecuteOnComputer: 1
> >>
> >>[DB]
> >>Id: 2
> >>ExecuteOnComputer: 2
> >>FileSystemPath: /var/mysql/ndb/data
> >>
> >>[DB]
> >>Id: 3
> >>ExecuteOnComputer: 3
> >>FileSystemPath: /var/mysql/ndb/data
> >>
> >>[API]
> >>Id: 4
> >>ExecuteOnComputer: 2
> >>
> >>[API]
> >>Id: 5
> >>ExecuteOnComputer: 3
> >>
> >>[TCP DEFAULT]
> >>PortNumber: 10002
> >>---------------------------------------------------
> >>
> >>
> >>--
> >>_____________________________________________________________
> >>Web-based SMS services available at http://www.operamail.com.
> >>From your mailbox to local or overseas cell phones.
> >>
> >>Powered by Outblaze
> >>
> >>--
> >>MySQL Cluster Mailing List
> >>For list archives: http://lists.mysql.com/cluster
> >>To unsubscribe: http://lists.mysql.com/cluster?unsub=1
> >>
> >>
> >>
> >
> >
> >
>
> --
> Martin Sköld, Software Engineer
> MySQL AB, www.mysql.com
> Office: +46 (0)730 31 26 21
>
>
--
_____________________________________________________________
Web-based SMS services available at http://www.operamail.com.
From your mailbox to local or overseas cell phones.
Powered by Outblaze
