Storage Engine¶
Why not use InnoDB for the index table?¶
The storage engine for the index table (tx_kesearch_index
) is MyISAM while all other tables use the default InnoDB storage engine.
Unfortunately this prevents using ke_search in Galera Clusters.
The reasons are explained below.
If the behaviour explained below does not affect how you use ke_search, you may switch to InnoDB for tx_kesearch_index
.
Search for @-character ist not supported¶
You cannot search for the "at"-Character in InnoDB tables:
InnoDB full-text search does not support the use of the @ symbol in boolean full-text searches. The @ symbol is reserved for use by the @distance proximity search operator.
Phrase search is not supported¶
Phrase search using double quotes ("my search word") is not supported in InnoDB.