Mroonga blog

2018-04-29

Mroonga 8.02 has been released!

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.

Mroonga 8.02 has been released!

Changes

The main changes are as follows. We recommend you to upgrade because some bugs are fixed.

  • Supported Ubuntu 18.04 LTS (Bionic Beaver).
  • [CentOS][Percona Server] Supported upgrading from "< 5.6.34" and "< 5.7.21".
  • Fixed a crash bug when some complex condition in ORDER BY such as ORDER BY 1 + 1, id, content.
  • Fixed a bug that MATCH AGAINST condition is ignored if SQL containing such as AND (x = 1 OR x = 2) when condition push down is enabled.
  • Fixed a memory leak for column caches.

Conclusion

See Release 8.02 - 2018-04-29 about detailed changes since 8.01.

Let's search by Mroonga!

2018-03-29

Mroonga 8.01 has been released!

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.

Mroonga 8.01 has been released!

In this release, Mroonga requires latest Groonga 8.0.1 to fix bugs. It means that MySQL/MariaDB must be restarted to upgrade package correctly.

If you have already installed Mroonga via apt or yum, MySQL/MariaDB will be restarted automatically during upgrading package.

Changes

The main changes are as follows.

  • Fixed a bug that wrong cache for other database is used

Fixed a bug that wrong cache for other database is used

In this release, wrong cache related bug was fixed.

This bug occurs the following conditions are met.

  • Multiple database are created
  • Use mroonga_command() against one of them

If you don't use mroonga_command() in query, above conditions are not met, so this bug doesn't affect you.

Conclusion

See Release 8.01 - 2018-03-29 about detailed changes since 8.00.

Let's search by Mroonga!

2018-02-09

Mroonga 8.00 has been released!

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.

This is a major version up! But It keeps backward compatibility. You can upgrade to 8.0.0 without rebuilding database.

Mroonga 8.00 has been released!

Changes

The main changes are as follows.

  • 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.

Conclusion

See Release 8.00 - 2018-02-09 about detailed changes since 7.11.

Let's search by Mroonga!

2018-01-29

Mroonga 7.11 has been released!

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.

Mroonga 7.11 has been released!

Changes

In this release, packages for MariaDB 10.1, 10.3 support has been improved on CentOS 6/7 and Ubuntu 17.10.

We are glad if you try these packages and give us feedbacks.

The main changes are as follows.

  • [Experimental] MariaDB 10.3 package has been supported on CentOS 6/7
  • [Ubuntu] MariaDB 10.1 package has been supported on Ubuntu 17.10

[Experimental] MariaDB 10.3 package has been supported on CentOS 6/7

In this release, official MariaDB 10.3 packages has been supported on CentOS 6/7.

To install on each supported environment, see install documents.

[Ubuntu] MariaDB 10.1 package has been supported on Ubuntu 17.10

In this release, MariaDB 10.1 package has been supported.

To install it, see install documents.

Conclusion

See Release 7.11 - 2018-01-29 about detailed changes since 7.10.

Let's search by Mroonga!

2017-12-29

Mroonga 7.10 has been released!

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.

Mroonga 7.10 has been released!

Changes

In this release, some improvements for optimization and speedup are included. It also have experimental features, so we are glad if you try the feature and report to us.

And, Groonga 7.1.0 or later is required from this release. Note that you will need to restart MySQL after upgrading to Mroonga 7.10.

The main changes are as follows.

  • [Experimental] Made it possible to always enable condition push down
  • Improved performance for to get fixed size column value
  • Supported count skip optimization with multi column index
  • [CentOS] Supported Percona Server 5.6.38 and 5.7.20
  • Supported MariaDB 10.3

[Experimental] Made it possible to always enable condition push down

Added some variables related to condition push down (Optimization to process search condition at Groonga level rather than MySQL level).

The default value is ONE_FULL_TEXT_SEARCH. It means that condition push down is enabled only when WHERE clause has one MATCH AGAINST condition. It is the same behavior as before.

If the value ALL is set, condition push down is always used (ALL is experimental for now. We are glad if you use it and tell us if it got faster or not).

Setting the value of mroonga_condition_push_down_type to ALL will always use condition push down, which is expected to be faster. However, ALL is an experimental feature for now. We are glad if you to use it and tell us if it got faster or not. The setting method is as follows.

SET mroonga_condition_push_down_type = ALL

Please choose an easy-to-use way for you from the following links. Even if it goes well, it will be nice if you let me know if it does not work. If it fails, please add logs and reproduction steps to the report.

We are waiting for your report.

Improved performance for to get fixed size column value

Supported column cache when to get fixed size column value to improve performance. This function needs to Groonga 7.1.0 or later, Groonga 7.1.0 or later is required from Mroonga 7.10 as described above.

Supported count skip optimization with multi column index

Enable count skip optimization for multi-column index. For details of count skip optimization, refer to the reference manual.

[CentOS] Supported Percona Server 5.6.38 and 5.7.20

In this release, Percona Server 5.6.38 and 5.7.20 has been supported. RPM packages are ready for above versions on CentOS 6 and CentOS 7.

Supported MariaDB 10.3

Supported MariaDB 10.3. If you are using MariaDB 10.3, please try it. Packages for CentOS will be released soon.

Conclusion

See Release 7.10 - 2017-12-29 about detailed changes since 7.09.

Let's search by Mroonga!