Re: NDBCLUSTER engine - Table is full

[taner selim]

Thanx for hte reply Matthew, well here it comes,

1,000,000 entries (random text and auto generated s_id for each row) to the following table (the only one in the DB):

show create table section;

Result:
CREATE TABLE `section` (
`s_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`s_name` varchar(50) NOT NULL,
PRIMARY KEY (`s_id`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8

and the output of

ndb_mgm> ALL REPORT MemoryUsage

Connected to Management Server at: localhost:1186

Node 2: Data usage increased to 83%(2136 32K pages of total 2560)
Node 2: Data usage is 83%(2136 32K pages of total 2560)
Node 2: Index usage is 81%(1905 8K pages of total 2336)
Node 3: Data usage is 83%(2136 32K pages of total 2560)
Node 3: Index usage is 81%(1904 8K pages of total 2336)
----

How is it possible that 1 million entries could take up 83% of 1500M data and 81% index ???