MySQL Forums
Forum List  »  NDB clusters

transaction failed due to disk full
Posted by: Alax Liu
Date: January 14, 2013 02:27AM

Hello,

I have a quite simple table called mytbl, which has 10 million rows and runs on NDB cluster.

When excuting a query like 'alter table mytbl partition by key(myid)', mysql crashed. the errror says "the file system is full" and "unable to store fragment during LCP”."

it's clear that the query run out of disk. I saw many REDO and LCP files.

my question is how can I do if I
- cannot change OS filesystem
- cannot lose data

Thanks

Alax

Options: ReplyQuote


Subject
Views
Written By
Posted
transaction failed due to disk full
1632
January 14, 2013 02:27AM


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.