Getting Table got full error for "Disk Based Tables"
Description:
I am trying to implement cluster for one of my client who has tables in 30 GB to 150 GB each and the total size of the DB is 1+ TB. They wanted to see how cluster might be suitable for their environment. They wanted mainly disk Based tables for this.
My config file
[ndb_mgmd]
Id=1
HostName=localhost
datadir=/dat/my_cluster/ndb_data
LogDestination=SYSLOG:facility=syslog;FILE:filename=/var/log/mgmd_1
[ndbd default]
NoOfReplicas=2
DataDir=/dat/my_cluster/ndb_data
DataMemory=2080M
IndexMemory=500M
MaxNoOfAttributes=10000
MaxNoOfOrderedIndexes=512
Created undo and tablespace from DB prompt instead of giving it through config file.
UNDO log files
NODEGROUP=0 INITIAL_SIZE=209715200 engine=ndbcluster;
TABLESPACE
USE LOGFILE GROUP ul_log EXTENT_SIZE 16777216 AUTOEXTEND_SIZE 8388608 ENGINE =NDB
DATA FILES
1) ADD DATAFILE 'tb1.dat' INITIAL_SIZE 8388608 ENGINE=ndb
2) ADD DATAFILE 'tb2.dat' INITIAL_SIZE 134217728 ENGINE=ndb;
3) ADD DATAFILE 'tb3.dat' INITIAL_SIZE 32212254720 ENGINE=ndb;
My doubts :
a) I am just loading 35 GB dump of a single partitioned table which is always getting table Full messages.
b) Is there a way to auto_extend a datafile from the initial size ?
c) Please help me out with proper variables that needs to be set for this disk based tables in ndbcluster.
I couldn't find lot of help from any docs so I am in need of some help terribly.
Thanks,
Santhinesh
Subject
Views
Written By
Posted
Getting Table got full error for "Disk Based Tables"
1436
November 09, 2012 07:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.