MySQL Forums
Forum List  »  InnoDB

Re: "ERROR 1030 (HY000): Got error 100" when adding index to very large (2B rows) table
Posted by: Steve Drangus
Date: May 05, 2022 07:07PM

Ah I'd just figured out it was the tmpdir before I saw your post! Good suggestion.

It was filling up the root partition to 100% causing the index command to fail. A bit counter intuitive to me because my mysql data dir is on a separate array (with heaps of space). I'd never seen mysql use up temporary storage on / to that degree.

Changing the tmpdir seems to have fixed the issue.

One very weird thing though is that the tmpdir is always empty according to ls and du. And yet the disk space is steadily consumed according to df as the index command progresses. How is that possible?

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.