MariaDB FULLTEXT index on more than 16 columns?

Question

The MariaDB documentation for InnoDB Limitations states that:

A multicolumn index on InnoDB can use a maximum of 16 columns. If you attempt to create a multicolumn index that uses more than 16 columns, MariaDB returns an Error 1070.

Is there any way around this limitation, so that I may create a fulltext index on 17 columns?

I am using MariaDB 10.1.37 and Navicat 11.2.11 Standard. When I try to add a fulltext index on 17 columns I get this error:

score 0 · Answer 1 · answered Jul 26 '19 at 07:04

0

The multicolumn limitation doesn't apply for FULLTEXT Indexes. FULLTEXT Indexes have a maximum of 32 parts in InnoDB.

answered Jul 26 '19 at 07:04

Georg Richter

5,970
2
9
15

2

Could you link to a reference for this please? – Liam Jul 26 '19 at 16:02

score 0 · Answer 2 · answered Jul 27 '19 at 00:23

0

In such a situation, I would recommend having an extra column that is the combination of all the text columns you want to search on.

answered Jul 27 '19 at 00:23

Rick James

135,179
13
127
222

I considered this, but I also need to rank results with relevancy weighted differently on some columns. Maybe I can combine the columns I want with higher weights into one column, and the lower weight columns into another column. Although I know this will give different results, it might be sufficient. – Liam Jul 29 '19 at 15:20

MariaDB FULLTEXT index on more than 16 columns?

2 Answers2