Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.16, 10.6.8, 10.7.4, 10.8.3, 10.9.1
-
None
-
WINDOWS 10 X64
Description
Hello,
I hope everyone is okay.
ALTER TABLE [TABLE_NAME] ADD FULLTEXT INDEX [INDEX]
This is causing a degradation of the operating system, crashing windows to the point of needing to restart the computer.
This also happens with versions older than MySql 8 (like mysql 5.7, 5.6), but not in mysql 8.
The table in question contains a few megabytes of data and field datatype is LONGTEXT. When creating the fulltext index (ALTER TABLE tbl_documentos_comp ADD FULLTEXT INDEX C_IND_20 (C_OCR);), MariaDB does not respect the limit of the innodb_buffer_pool_size variable and increases memory consumption progressively without stopping.
With 100% memory spikes, the operating system is slow and the computer crashes.
Please download dump file:
https://drive.google.com/file/d/1_IYgC9_ls0f1nlPBlP7YX8RQSMf_S4JJ/view?usp=sharing
Regards!