Re: Cluster load averages

[Alastair Symon]

We have three databases on the cluster which previously took up <25M on a standard MySQL install. all dump 1000 is showing Data usage of 65% (15719 32k pages) and Index usage of 23% (730 8k pages).


#config.ini:
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=750M
IndexMemory=24M
DataDir=/var/lib/mysql-cluster

[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
DataDir=/var/lib/mysql-cluster

[TCP DEFAULT]

# Management Server
[NDB_MGMD]
Id=1
HostName=10.20.30.200 # IP address of this server

# Storage Nodes
[NDBD]
Id=2
HostName=10.20.30.210 # IP address of storage-node-1
DataDir=/var/lib/mysql-cluster

#db1
[NDBD]
Id=3
HostName=10.20.30.211 # IP address of storage-node-2
DataDir=/var/lib/mysql-cluster

# Setup node IDs for mySQL API-servers (clients of the cluster)
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]