MySQL Forums
Forum List  »  NDB clusters

Re: ERROR 1114 (HY000): The table '#sql-414_3d' is full
Posted by: Jonathan Stephens
Date: March 11, 2015 08:59AM

To install Perl modules when you're running ActiveState Perl, you can use ActiveState's PPM (Perl Package Manage), which comes as part of their distribution. We have an example showing how to install the DBI module with it in our documentation, here. More information about using PPM to find a particular package or module can be found in ActiveState's documentation, here.

A machine running running a Cluster data node does not automatically allocate all RAM to the data node process (this would be bad, because you might need some of it for other processes, and you definitely do not want data nodes to start using swap, as this would kill the node's performance very quickly). DataMemory controls how much RAM is reserved for data, and IndexMemory controls how much is reserved for indexes.

Just to make sure you understood what I said earlier: To make changes to DataMemory and IndexMemory take effect, you need to restart all nodes, not just the management node. Normally, you'd do this with a rolling restart so that you don't have to take the cluster down, but in this particular case (since you don't yet have all the data imported), it's fine to shut the whole cluster down, then start it back up.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.