Horimoto Yasuhiro [ANN] Mroonga 8.00 - Fast fulltext search for all languages on MySQL
Feb 09, 2018; 22:23
Horimoto Yasuhiro
[ANN] Mroonga 8.00 - Fast fulltext search for all languages on MySQL
Hi,
Mroonga 8.00 has been released! This is a major version up! But It keeps backward compatibility. You can upgrade to 8.0.0 without rebuilding database.
Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine.
Document: http://mroonga.org/docs/
How to install: Install Guide http://mroonga.org/docs/install.html
How to upgrade: Upgrade Guide http://mroonga.org/docs/upgrade.html
* When create hash index, tiny hash is used for reducing consumption of resources. * [percona57] Added gap lock detection support.
## When create hash index, used tiny hash for reducing used resource
Hash index is less resouce to used from this release. Note:that rebuilding indexes are required to enable this feature for existence indexes
## [percona57] Added gap lock detection support
A gap lock was being attempted while the transaction isolation level was either REPEATABLE READ or SERIALIZABLE, the following SQL error was returned to the client and no actual gap lock was taken on the affected rows.
ERROR 1105 (HY000): Using Gap Lock without full unique key in multi-table or multi-statement transactions is not allowed. You need to either rewrite queries to use all unique key columns in WHERE equal conditions, or rewrite to single-table, single-statement transaction. Query: ALTER TABLE t ENGINE=InnoDB
From this release, as the above situation, gap lock will be taken on the affected rows.
Regards,
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!