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?
Subject
Written By
Posted
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.