MySQL Forums
Forum List  »  NDB clusters

ERROR 1114 (HY000): The table '#sql-414_3d' is full
Posted by: Schinas Florian
Date: March 11, 2015 01:57AM

Hi all,
I am trying to set up a MySQL Cluster , and I think it will soon come to an end .

In order to test this in a manner " more real ", I decide to dump a DB InnoDB and restorer 's on one of my SQL nodes .

Once that do, I make the query:
SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=NDBCLUSTER;')
FROM information_schema.TABLES
WHERE 1=1
    AND engine = 'InnoDB'
    AND table_schema NOT IN ('information_schema', 'mysql', 'performance_schema');
in profit for all tables that are not NDBCLUSTER to migrate .
I then just do a copy paste the result on my MySQL console.

Everything seems to be done properly, or until errors are displayed ..
I redo my request this and I see that " there are two left , I copy the results and I have this error:
ERROR 1114 (HY000): The table '#sql-414_3d' is full

Followed by this: on my ndb_mgm :
Node 3: Data usage increased to 81%(2075 32K pages of total 2560)
Node 2: Data usage increased to 81%(2085 32K pages of total 2560)
Node 3: Data usage increased to 90%(2325 32K pages of total 2560)
Node 2: Data usage increased to 91%(2334 32K pages of total 2560)
Node 3: Data usage decreased to 58%(1503 32K pages of total 2560)
Node 2: Data usage decreased to 58%(1503 32K pages of total 2560)

When I REPORT ALL MEMORY USAGE I get this:
Node 2: Data usage is 58%(1503 32K pages of total 2560)
Node 2: Index usage is 28%(676 8K pages of total 2336)
Node 3: Data usage is 58%(2085 32K pages of total 2560)
Node 3: Index usage is 28%(2085 8K pages of total 2336)

In my config.ini i only have this options:
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
My nodes data have 1 GB RAM (i dont really understand how use all options on config.ini so, its probably bad).
Can you help me?

Thank you to you!

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.