List:Cluster« Previous MessageNext Message »
From:Karl Kloppenborg Date:September 30 2010 4:15am
Subject:MySQL Cluster -- Table Full
View as plain text  
Hi,
We have setup a MySQL cluster (pretty standard two NDB nodes + two management servers)
2x cluster processing nodes (running the MySQL NDB daemon + MySQL server)
      - 144GB ram
      -  8x 300GB SAS - Raid 10 
      - Data-Storage = 135GB Ram 
      - Index-Storage = 5GB RAM
However at 92Million rows in a table, it is returning the TableFull error?

My config is as follows:
[NDBD DEFAULT]
NoOfReplicas=2
LockPagesInMainMemory=1

DataMemory=131G
IndexMemory=10G

TimeBetweenLocalCheckpoints=6
NoOfFragmentLogFiles=500


[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]
SendBufferMemory=8M
ReceiveBufferMemory=8M

# Section for the cluster management node
[NDB_MGMD]
ID=1 #LB1 ID is 1
Datadir=/var/lib/mysql-cluster
HostName=#.#.#.# #PRIVATE IP OF LB1

[NDB_MGMD]
HostName=#.#.#.# #PRIVATE IP OF LB2
ID=2 #ID of LB2 is 2
Datadir=/var/lib/mysql-cluster

# Section for the storage nodes
[NDBD]
# IP address of the first storage node
HostName=#.#.#.# # PRIVATE IP OF DB1
DataDir=/var/lib/mysql-cluster

[NDBD]
# IP address of the second storage node
HostName=#.#.#.# #PRIVATE IP OF DB2
DataDir=/var/lib/mysql-cluster

# one [MYSQLD] per storage node
[MYSQLD]
[MYSQLD]



Can anyone please shed some light on this matter?

Cheers,
Karl Kloppenborg 
Thread
MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
  • Re: MySQL Cluster -- Table FullAdam Dixon30 Sep
    • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
  • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
    • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
      • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
        • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
          • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
            • Re: MySQL Cluster -- Table FullJohan Andersson30 Sep
              • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
                • Re: MySQL Cluster -- Table FullJohan Andersson30 Sep
                  • Re: MySQL Cluster -- Table FullKarl Kloppenborg1 Oct
                    • Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm1 Oct
                      • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct
                        • Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm7 Oct
                      • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct
                      • Re: MySQL Cluster -- Table FullJon Stephens1 Oct
  • Re: MySQL Cluster -- Table FullMoses28 Apr
    • Re: MySQL Cluster -- Table FullJohan Andersson28 Apr
  • Re: MySQL Cluster -- Table FullMoses6 May
Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm1 Oct
  • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct