• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1051
  • Last Modified:

MySQL error 4000 - MEMORY ALLOCATION ERROR

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 '10.1.0.1' is blocked because of many connection errors
0
alex3948
Asked:
alex3948
1 Solution
 
alex3948Author 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.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now