Solved

MySQL error 4000 - MEMORY ALLOCATION ERROR

Posted on 2012-04-09
1
985 Views
Last Modified: 2012-08-14
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
Comment
Question by:alex3948
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
alex3948 earned 0 total points
ID: 37848879
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question