|7.07||MariaDB 10.2.11, MariaDB 10.1.29||Stable|
|5.02||MariaDB 10.0.18, MariaDB 10.1.5||Stable|
Mroonga is a full text search storage engine based on Groonga, which is an open-source CJK-ready fulltext search engine using column base. See http://groonga.org for more.
Mroonga also supports Groonga's fast geolocation search by using MariaDB's geolocation SQL syntax.
Mroonga currently only supports Linux x86_64 (Intel64/AMD64).
How to Install
Before MariaDB 10.0.15, Mroonga was not available by default, and you needed to build the plugin. See the instructions at http://mroonga.org/docs/install.html. Since MariaDB 10.0.15, or once the plugin has been built, enable Mroonga with the following statement:
mysql> INSTALL SONAME 'ha_mroonga';
On Debian and Ubuntu mroonga engine will be installed with
sudo apt-get install mariadb-plugin-mroonga
See Plugin overview for details on installing and uninstalling plugins.
SHOW ENGINES can be used to check whether Mroonga is installed correctly:
SHOW ENGINES; ... *************************** 8. row *************************** Engine: Mroonga Support: YES Comment: CJK-ready fulltext search, column store Transactions: NO XA: NO Savepoints: NO ...
Once the plugin is installed, add a UDF (User-Defined Function) named "last_insert_grn_id", that returns the record ID assigned by groonga in INSERT, by the following SQL.
mysql> CREATE FUNCTION last_insert_grn_id RETURNS INTEGER SONAME 'ha_mroonga.so';
- The maximum size of a single key is 4096 bytes.
- The maximum size of all keys is 4GB.
- The maximum number of records in a fulltext index is 268,435,455
- The maximum number of distinct terms in a fulltext index is 268,435,455
- The maximum size of a fulltext index is 256GB
Note that the maximum sizes are not hard limits, and may vary according to circumstance.
For more details, see http://mroonga.org/docs/reference/limitations.html.
Available Character Sets
Mroonga supports a limited number of character sets. These include:
Further documentation for Mroonga can be found at http://mroonga.org/docs/