Mroonga blog

2022-08-30

Mroonga 12.07 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 12.07 has been released!

Changes

The main changes are as follows.

Improvements

  • CentOS, AlmaLinux Added support for MariaDB 10.3.36, 10.4.26, 10.5.17, 10.6.9, 10.7.5 and 10.8.4.

  • CentOS, AlmaLinux Added support for Percona Server 5.7.39-42.

  • CentOS, AlmaLinux Added support for Percona Server 8.0.29-21.

    MySQL 8.0.29 used by Percona Server 8.0.29 has a critical issue. So we do not recommend to use this version.

    See MySQL 8.0.29 Release Notes for details about the issue.

Fixes

  • Fixed a bug to fail to install or upgrade Mroonga with install.sql.

    Broken install.sql caused this bug. This bug had occurred since Mroonga 12.06.

  • Fixed a bug that mroonga_command() returns results with hex dump for MySQL 8.0 and above.

    mroonga_command() returns results with a correct character code form this version.

  • AlmaLinux Fixed an installation document for Mroonga on AlmaLinux 8.

Conclusion

Let's search by Mroonga!

2022-08-04

Mroonga 12.06 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 12.06 has been released!

Changes

The main changes are as follows.

Improvements

  • CentOS Added support for MySQL 5.7.39.

  • CentOS, AlmaLinux Added support for MySQL 8.0.39.

  • CentOS, AlmaLinux Added support for Percona Server 8.0.28-20.

  • CentOS, AlmaLinux Added support for MariaDB 10.8.

  • CentOS, AlmaLinux Dropped support for MariaDB 10.2.

  • Debian Dropped support for Debian 10 (buster).

  • Changed to not require to run update.sql for registering Mroonga to MySQL.

    Mroonga has required to run both install.sql and update.sql to register to MySQL since Mroonga 12.04.

    % mysql -u root < /usr/share/mroonga/install.sql
    % mysql -u root < /usr/share/mroonga/update.sql
    

    This improvement has changed Mroonga to only require to run install.sql to register to MySQL as before than Mroonga 12.04.

    % mysql -u root < /usr/share/mroonga/install.sql
    

Conclusion

Let's search by Mroonga!

2022-06-06

Mroonga 12.04 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 12.04 has been released!

Changes

The main changes are as follows.

Improvements

  • Server variables Add a new status variable Mroonga_memory_map_size.

    We can get the total memory map size in bytes of Mroonga as below.

      mysql> SHOW STATUS LIKE 'Mroonga_memory_map_size';
      +-------------------------+----------+
      | Variable_name           | Value    |
      +-------------------------+----------+
      | Mroonga_memory_map_size | 83406848 |
      +-------------------------+----------+
      1 row in set (0.00 sec)
    

    In Windows, If Mroonga uses up physical memory and swap area, Mroonga can't more mapping memory than that. Therefore, we can control properly memory map size by monitoring this value even if the environment does have not enough memory.

  • CentOS, AlmaLinux Added support for Percona Server 8.0.28-19.

  • CentOS, AlmaLinux Added support for Percona Server 5.7.38-41.

  • CentOS, AlmaLinux Added support for MariaDB 10.2.44, 10.3.35, 10.4.25, 10.5.16, 10.6.8, and 10.7.4.

Fixes

  • Fixed a bug that Mroonga may update failed.

    If this bug occurs, Mroonga is disabled after Mroonga update with such as "apt update". In that case, we install Mroonga manually with the following procedure.

      % mysql -u root < /usr/share/mroonga/install.sql
    

Conclusion

Let's search by Mroonga!

2022-05-06

Mroonga 12.03 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 12.03 has been released!

Changes

The main changes are as follows.

Improvements

  • [CentOS] Added support for Percona Server 5.7.37-40.

  • [CentOS] Added support for MySQL 5.7.38.

  • [CentOS][AlmaLinux] Added support for MySQL 8.0.29.

Fixes

  • Fixed a bug that Mroonga may fail create the index on MariaDB 10.5.14.

  • Fixed a memory leak on full text search.

    This is occurred when order limit optimization is used.

    However, if we use MariaDB, this occurs even if we don't use order limit optimization. This bug had occurred since Mroonga 11.03.

Conclusion

Let's search by Mroonga!

2022-03-29

Mroonga 12.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 12.02 has been released!

Changes

The main changes are as follows.

Improvements

  • Dropped support wrapper mode with MySQL 8.0 or later.

  • Added support for disabling a back trace by the server variable.

    We can disable a back trace by "SET GLOBAL mroonga_enable_back_trace = false;".

  • Added support for float32 weight vector.

    We can store weight as float32. We need to add WEIGHT_FLOAT32 flag when we define a column to use this feature.

  • CentOS, AlamLinux Added support for MariaDB 10.3.34, 10.4.24, 10.5.15, 10.6.7, and 10.7.3.

  • CentOS Added support for MariaDB 10.2.43.

  • CentOS, AlamLinux Added support for Percona Server 8.0.27-18.

  • Added support for MISSING_* and INVALID_* flags

    Please refer to https://groonga.org/docs/news.html#release-12-0-2 about details of these flags.

Conclusion

Let's search by Mroonga!