Hi all! I've setup a MySQL cluster with 3 servers (1 arbitrator, 2 nodes, the mysqld process is on the same machine as arbitrator), I keep getting error 4000 - MEMORY ALLOCATION ERROR when reading the "vw_users" view. It is a join with a table and a "postal codes" table which has 500k records.

Part of my config:
[ndbd default]
NoOfReplicas = 2
DataDir = /var/lib/mysql-ndb-data
DataMemory = 1G
IndexMemory = 256M
TransactionBufferMemory = 8M
TransactionInactiveTimeout = 2000
MaxNoOfOrderedIndexes = 1024
MaxNoOfAttributes = 10000
MaxNoOfTables = 2500
MaxNoOfConcurrentOperations = 100000
MaxNoOfConcurrentIndexOperations = 100000

Sometimes it works, sometimes it fails. The machines all have 2GB Ram. Am I doing something wrong?

Today, my PHP scripts gave my this error if it is releavant, but I fixed it, it's OK:
Host '' is blocked because of many connection errors
Who is Participating?
alex3948Connect With a Mentor Author Commented:
Issue has been resolved. This was a very tricky bug in MySQL cluster with pushdown joints. Solution was to call "set ndb_join_pushdown = off" right after the connection and the problem goes away.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.