I'm using MariaDB version 10.2.22 with a InnoDB engine, utf8 charset, it has one column that is indexed FULLTEXT. The table itself is only 4.4 GB with avg row length at 255. When I do a query such as:
SELECT m.id as id FROM table1 m, table2 d where m.id= d.id AND MATCH ([column]) AGAINST ('"CE20-2019"' in boolean mode)
I get a "
SQL Error  [HY000]:Table handler out of memory". I suspect that the "-2019" is being searched or not included, I'm not sure, and that the found matches exceeds the memory allowed. The [column] is a "LongText" datatype.
I've tried changing the innodb_buffer_pool_size to 4 GB and then 8 GB, but still get this error.
(System has 24 GB of RAM, not sure if my comfortable changing it to 70% of RAM listed on their documentation found here: https://mariadb.com/kb/en/mariadb-memory-allocation/), since I'm on version 10.2.22, this innodb_buffer_pool_size variable is suppose to be dynamic so I don't have to restart the MariaDB service to restart Mysqld.
Any ideas what's causing the Table handler out of memory?