Hello,
The datafiles and tablespace are as they are described (same values)
in the MySQL Cluster documentation
Table Impagos is as follows:
CREATE TABLE IF NOT EXISTS `Impagos` (
`Telefono` varchar(12) NOT NULL default '',
`Ani` varchar(12) NOT NULL default '',
`Importe` double NOT NULL default '0',
`Fecha` date NOT NULL default '0000-00-00',
`Anio` varchar(8) NOT NULL default '',
`Mes` varchar(4) NOT NULL default '',
`Duracion` int(11) NOT NULL default '0',
`Operador` enum('BT','ONO','Telefonica') default NULL,
`Archivo` varchar(255) NOT NULL default '',
`Propietario` varchar(64) NOT NULL default '',
`Id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`Id`),
KEY `Telefono` (`Telefono`),
KEY `Fecha` (`Fecha`),
KEY `Operador` (`Operador`)
) TABLESPACE sta STORAGE DISK ENGINE NDB;
And the config.ini is as follows
[NDB_MGMD DEFAULT]
DataDir=/cluster
LogDestination=SYSLOG:facility=daemon
ArbitrationRank=1
PortNumber=1186
[NDBD DEFAULT]
NoOfReplicas=2
DataDir=/cluster
DataMemory=100M
IndexMemory=300M
StopOnError=FALSE
MaxNoOfTables=512
MaxNoOfAttributes=4000
MaxNoOfUniqueHashIndexes=128
MaxNoOfConcurrentOperations=200000
TransactionDeadLockDetectionTimeout=6000
[NDB_MGMD]
Id=1
HostName=10.0.2.41
[MYSQLD]
Id=2
HostName=10.0.2.46
[MYSQLD]
Id=3
HostName=10.0.2.42
[NDBD]
Id=4
HostName=10.0.2.46
[NDBD]
Id=5
HostName=10.0.2.42
Jose
Jonas Oreland wrote:
>José Gómez wrote:
>
>
>>Hello,
>>
>> I'm testing MySQL 5.1.9 with two ndbd nodes, two mysql nodes and one
>>manager node, if I load data in tables with Data Disk Storage disable I
>>haven't any problem (186000 rows), but if I try to load the same data in
>>the same tables with Data Disk Storage enabley in the row 85000 aprox I
>>get the following error: ERROR 1114 (HY000) at line X: The table
>>'Impagos' is full, I can't find anything in the syslog and in the error
>>files in nodes.
>> Why with the same configuration I can insert more data without Data
>>Disk Storage than with Data Disk Storage?
>>
>>Greetings
>>
>>
>
>Hi,
>
>How does your tablespace look like?
> (tablespace/datafiles)
>How does your table 'Impagos' look like?
>How does you config.ini look like?
>
>/Jonas
>
>
