2023-04-17
Mroonga 13.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 13.01 has been released!
Changes
Here are important changes in this release:
Improvements
-
CentOS, AlmaLinux Added newly support for MariaDB 10.11.
-
Amazon Linux 2 Added support for MariaDB 10.5.18-1.amzn2.
-
CentOS, AlmaLinux Added support for Percona Server 8.0.32-24.
-
CentOS, AlmaLinux Added support for Percona Server 5.7.41-44.
-
[Oracle Linux] Dropped support for Oracle Linux 8 and 9
We supported Oracle Linux for installing Mroonga to MySQL official Docker image. However, a package that needed to install to MySQL official Docker image is Mroonga for MySQL community server minimal
Therefore, we cann't install Mroonga to MySQL official Docker image even if we use Mroonga for Oracle Linux.
-
Ubuntu Dropped support for Ubuntu 18.04.
Because Ubuntu 18.04 reached EOL.
-
AlmaLinux Added support for MySQL community server minimal 8.0.
This is for supporting the mysql:8.0-oracle Docker image.
Conclusion
Please refer to release note about the detail of changes in this release.
Let's search by Mroonga!
2023-02-09
Mroonga 13.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.
Mroonga 13.00 has been released!
This is a major version up! But It keeps backward compatibility. We can upgrade to 13.00 without rebuilding database.
Note
Currently, we don't provide packages of Mroonga 13.00 for Percona Server.
Because there is a problem with buildong packages of Mroonga 13.00 for Percona Server.
If we will resolve this problem, we will provide packages of Mroonga for Percona Server again.
Changes
Here are important changes in this release:
Improvements
- CentOS, AlmaLinux Added support for MariaDB 10.3.38, 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, and 10.10.3.
Conclusion
Please refer to release note about the detail of changes in this release.
Let's search by Mroonga!
2023-01-29
Mroonga 12.12 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.12 has been released!
Changes
Here are important changes in this release:
Improvements
We could not update normal columns when we set composite primary keys using Mroonga storage engine as below.
CREATE TABLE scores (
name char(30) NOT NULL,
score int NOT NULL,
PRIMARY KEY (name, score),
note char(30),
FULLTEXT INDEX search_note_idx (note)
) ENGINE = Mroonga DEFAULT CHARSET=utf8mb4;
INSERT INTO scores (name, score) VALUES ("Taro Yamada", 29);
UPDATE scores SET note = "Note"
WHERE name = "Taro Yamada" AND score = 29;
ERROR 1265 (01000): data truncated for primary key column: <name>
This error doesn’t occur Mroonga with MariaDB.
Thanks
Conclusion
Please refer to release note about the detail of changes in this release.
Let's search by Mroonga!
2023-01-06
Mroonga 12.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 12.11 has been released!
Changes
The main changes are as follows.
Improvements
Fixes
-
mroonga_highlight_html() Fixed memory leak when we use mroonga_highlight_html()
with AS query
.
-
Fixed a bug that initialization of MeCab is fail when we use Mroonga on MariaDB 10.9 or later for Windows.
Conclusion
Please refer to release note about the detail of changes in this release.
Let's search by Mroonga!
2022-11-29
Mroonga 12.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 12.10 has been released!
Changes
The main changes are as follows.
Improvements
-
CentOS, AlmaLinux Added support for MariaDB 10.3.37, 10.4.27, 10.5.18,
10.6.11, 10.7.7, 10.8.6, 10.9.4.
-
CentOS, AlmaLinux Added support for Percona Server 8.0.30-22.
-
CentOS Added support for Percona Server 5.7.40-43.
-
Windows Added support for MariaDB 10.7, 10.8, 10.9.
-
Windows Dropped support for 32bit versions.
Because recent MariaDB can't be built for 32bit Windows, and the official packages for 32bit don't exist.
-
mroonga_highlight_html() Added new parameters: open_tag
and close_tag
.
Now we can specify a tag for highlighting with open_tag
and close_tag
.
It was inconvinient for us to unable specifying different tags or changing class
because the fixed tag <span class="keyword">...</span>
was used.
Now, this new parameter provides more convenience for us because it allows specifying tags to highlight, such as <mark>...</mark>
.
SELECT mroonga_highlight_html('Mroonga is the Groonga based storage engine.', 'groonga',
'<mark>' AS open_tag, '</mark>' AS close_tag) AS highlighted;
-- +-----------------------------------------------------------+
-- | highlighted |
-- +-----------------------------------------------------------+
-- | Mroonga is the <mark>Groonga</mark> based storage engine. |
-- +-----------------------------------------------------------+
Please refer to mroonga_highlight_html() for details.
-
Added support for reference count mode.
Though this feature can keep fixed memory usage, its performance would be dropped.
Thus, memory increments should be first consideration before using this feature.
The reference count mode is used with table_open_cache of MySQL.
MySQL can cache specified number of tables with table_open_cache
.
Groonga's object would not be released because the cached tables are still in use.
The tables with low usage would be closed if number of open tables is larger than number specified with table_open_cache
.
Groonga objects would be released at the same time with table closing if the reference count mode is enabled.
These are how the reference count mode keep fixed memory usage.
For actual use, we need to adjust balance between memory usage and perfomance with value of table_open_cache
while checking
memory usage and value of status variables Open_tables.
Because this feature can keep fixed memory usage, but its performance would be dropped.
There is how to check Open_tables
as follows.
SHOW GLOBAL STATUS LIKE 'Open_tables';
-- +---------------+-------+
-- | Variable_name | Value |
-- +---------------+-------+
-- | Open_tables | 643 |
-- +---------------+-------+
Normally, all of tables in use are cached by setting table_open_cache
larger than Open_tables
.
However, if there is limited memory, memory usage would be decreased by releasing memory for tables with low usage dropping from the cache.
In order to releasing tables with low usage from the cache, table_open_cache
should be set smaller than Open_tables
.
The smaller Open Tables
setting , the more tables dropping from the cache.
As cache is released, memory usage decrease, yet performance become worse due to reopen tables.
The smaller table_open_cache
, the more necessary to reopen tables. table_open_cache
should set as much value as only to reaching memory tolerance.
In order to enable reference count mode, we need to specify values in my.cnf as follows;
loose-mroonga-enable-reference-count = ON
Note: The reference count mode would not be enabled with variables after booting MySQL.
It is necesarry to specify values in my.cnf.
SET GLOBAL mroonga_enable_reference_count = ON
Fixes
Conclusion
Please refer to release note about the detail of changes in this release.
Let's search by Mroonga!