MySQL Forums
Forum List  »  Newbie

Full text index runs out of storage
Posted by: Hor Kol
Date: April 22, 2023 07:36AM

I have a table with 1 MEDIUMTEXT column.
Table has 130,000 rows, size is about 3GB

When I try to add full text index:

ALTER TABLE `mydb`.`mytable`
ADD FULLTEXT INDEX `textfull` (`text`) VISIBLE;

I get error
Error Code: 1030. Got error 100 - 'InnoDB error' from storage engine

There is 13GB available disk space.

I have change tmpdir to my temp dir, but doesn't work.

Can you help me?

Options: ReplyQuote

Written By
Full text index runs out of storage
April 22, 2023 07:36AM

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.