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!