Re: Can't create table (errno:4242 )

[Peter Schulz]

my config ini - configured by hoster... ... we want to use large databases (up 2 4gb, at least 700mb... but the sql i run was about 1MB or so... ) - > should we change some settings hmmm?... ,...

-------------------------
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.

# TCP/IP options:
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead

# Management process options:
[NDB_MGMD]
hostname=192.168.10.20 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
hostname=192.168.10.38 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# Options for data node "B":
[NDBD]
hostname=192.168.10.40 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# SQL node options:
#[MYSQLD]
#hostname=192.168.10.34 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)

#[MYSQLD]
#hostname=192.168.10.36 # Hostname or IP address
[MYSQLD]
[MYSQLD]
------------------------------------------------

hope it helps for anaylsis... we have 4 servers in our cluster - 2 for web, 2 for db, the db-servers we want to have that storage engine "ndbcluster" for performance purposes... the sql statement was send to the mgmtd...

_pete®