---
title: "Storage Engine"
manual: "ke_search"
version: "main"
source: "Configuration/StorageEngine.rst"
rendered: "2026-09-18T09:39:22+00:00"
---

# Storage Engine {#storage-engine}

## Why not use InnoDB for the index table? {#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 {#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.

-   [https://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html](https://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html)
-   [https://github.com/teaminmedias-pluswerk/ke_search/issues/226](https://github.com/teaminmedias-pluswerk/ke_search/issues/226)

As a workaround you could add the @ character to the list of additional word
characters as explained in [Additional word characters](AdditionalWordCharacters.html#configuration-additional-word-characters).

## Phrase search is not supported {#phrase-search-is-not-supported}

Phrase search using double quotes ("my search word") is not supported in InnoDB.

-   [https://bugs.mysql.com/bug.php?id=78485](https://bugs.mysql.com/bug.php?id=78485)
-   [https://github.com/teaminmedias-pluswerk/ke_search/issues/214](https://github.com/teaminmedias-pluswerk/ke_search/issues/214)