Skip navigation links

MySQL Forums :: Cluster :: Getting Table got full error for "Disk Based Tables"


Advanced Search

Getting Table got full error for "Disk Based Tables"
Posted by: santhinesh kumar ()
Date: November 09, 2012 07:47PM

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

Options: ReplyQuote


Subject Views Written By Posted
Getting Table got full error for "Disk Based Tables" 606 santhinesh kumar 11/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.