Forum Stats

  • 3,758,942 Users
  • 2,251,479 Discussions
  • 7,870,440 Comments

Discussions

Dropping Column in NDB Cluster when there is millions of records

I am using MySQL NDB Cluster with almost 1M records. I would like to DROP a column so that I can reduce the table size.

When I try to DROP the column, I am getting ERROR 1297. Is there any efficient way to perform the operation.

ERROR 1297 (HY000): Got temporary error 921 'Out of transaction memory in local data manager, copy tuples (increase SharedGlobalMemory)' from NDBCLUSTER


Please advice.

Answers