[ANN] Mroonga 9.01 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 9.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. 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 Blog: http://mroonga.org/en/blog/2019/03/29/mroonga-9.01.html Changes: http://mroonga.org/docs/news.html#release-9.01 Here are some topics in this release. * Improved support for more table and comment parameter about tokenizer/normalizer/indexes. * See above blog entry about details. * Added support for latest MariaDB/Percona Server. * Percona Server 5.7.25-28. * MariaDB 10.3.13. * MariaDB 10.2.23. * Added support for building bundled MariaDB package on AppVeyor. Let's search by Mroonga! Regards, -- Kentaro Hayashi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
[ANN] Mroonga 8.01 - Fast fulltext search for all languages on MySQL
Hi, 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. 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 Blog: http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html Changes: http://mroonga.org/docs/news.html#release-8.01 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. Here is a topic in this release. ## 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. Regards, -- Kentaro Hayashi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
[ANN] Mroonga 7.11 - Fast fulltext search for all languages on MySQL
Hi, 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. 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 Blog: http://mroonga.org/en/blog/2018/01/29/mroonga-7.11.html Changes: http://mroonga.org/docs/news.html#release-7.11 Here are some topics in this release. * [Experimental] MariaDB 10.3 package has been supported on CentOS 6/7 * [Ubuntu] MariaDB 10.1 package has been supported on Ubuntu 17.10 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. ### [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. * MariaDB 10.3 on CentOS 6 http://mroonga.org/docs/install/centos.html#centos-6-with-mariadb-10-3-package * MariaDB 10.3 on CentOS 7 http://mroonga.org/docs/install/centos.html#centos-7-with-mariadb-10-3-package ## [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. * Install from Launchpad PPA http://mroonga.org/docs/install/ubuntu.html Regards, -- Kentaro Hayashi pgp_ncUlbX40a.pgp Description: PGP signature
[ANN] Mroonga 7.09 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 7.09 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. 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 Blog: http://mroonga.org/en/blog/2017/11/29/mroonga-7.09.html Changes: http://mroonga.org/docs/news.html#release-7.09 Here is the topic in this release. * MariaDB 10.1.29/10.2.11 package has been supported on CentOS 6/7 In this release, some test related patch files are merged into Mroonga. These patch files are deliverables from MariaDB community. Thanks, MariaDB community! ### MariaDB 10.1.29/10.2.11 package has been supported on CentOS 6/7 In this release, official MariaDB 10.1.29/10.2.11 packages has been supported on CentOS 6/7. To install on each supported environment, see install documents. * MariaDB 10.1 on CentOS 6 http://mroonga.org/docs/install/centos.html#centos-6-with-mariadb-10-1-package * MariaDB 10.2 on CentOS 6 http://mroonga.org/docs/install/centos.html#centos-6-with-mariadb-10-2-package * MariaDB 10.1 on CentOS 7 http://mroonga.org/docs/install/centos.html#centos-7-with-mariadb-10-1-package * MariaDB 10.2 on CentOS 7 http://mroonga.org/docs/install/centos.html#centos-7-with-mariadb-10-2-package Regards, -- Kentaro Hayashi pgpYaMBZ_F8Ik.pgp Description: PGP signature
[ANN] Mroonga 7.07 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 7.08 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. 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 Blog: http://mroonga.org/en/blog/2017/10/29/mroonga-7.08.html Changes: http://mroonga.org/docs/news.html#release-7.08 Here is the topic in this release. * Supported Ubuntu 17.10 (Artful Aardvark). * Supported table level flags option. You can specify TABLE_HASH_KEY, TABLE_PAT_KEY, TABLE_DAT_KEY, and KEY_LARGE table options. ## [ubuntu] Supported Ubuntu 17.10 (Artful Aardvark) In this release, Ubuntu 17.10 (Artful Aardvark) has been supported. To install Mroonga via PPA (Personal Package Archive), See http://mroonga.org/docs/install/ubuntu.html in details. ### Supported table level flags option. You can specify TABLE_HASH_KEY, TABLE_PAT_KEY, TABLE_DAT_KEY, and KEY_LARGE table options. In the previous version, when you create table in Mroonga, could not set Groonga's table flag. So, if you want create table for saving many big data, you needed to use mroonga_command. In this release, when you create table, you can specify KEY_LARGE flag. You can more easily make table for saving many big data from this. Here is how to specify KEY_LARGE. CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, content VARCHAR(255), FULLTEXT INDEX (content) ) ENGINE = Mroonga COMMENT = 'engine "InnoDB"' DEFAULT CHARSET utf8 flags "TABLE_HASH_KEY|KEY_LARGE"; To details of specify flags, see the below documents. * Groonga v7.0.8 documentation http://groonga.org/docs/reference/commands/table_create.html#flags Regards, -- Kentaro Hayashi pgp_up_ZHWEuF.pgp Description: PGP signature
[ANN] Mroonga 7.07 - Fast fulltext search for all languages on MySQL
Hi,
Mroonga 7.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.
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
Blog:
http://mroonga.org/en/blog/2017/10/12/mroonga-7.07.html
Changes:
http://mroonga.org/docs/news.html#release-7.07
Here is the topic in this release.
* MariaDB 10.1/10.2 package has been supported on CentOS 6/7
* mroonga_query_expand UDF has been supported
### MariaDB 10.1/10.2 package has been supported on CentOS 6/7
In this release, official MariaDB 10.1/10.2 packages has been
supported on CentOS 6/7.
To install on each supported environment, see install documents.
* MariaDB 10.1 on CentOS 6
http://mroonga.org/docs/install/centos.html#centos-6-with-mariadb-10-1-package
* MariaDB 10.2 on CentOS 6
http://mroonga.org/docs/install/centos.html#centos-6-with-mariadb-10-2-package
* MariaDB 10.1 on CentOS 7
http://mroonga.org/docs/install/centos.html#centos-7-with-mariadb-10-1-package
* MariaDB 10.2 on CentOS 7
http://mroonga.org/docs/install/centos.html#centos-7-with-mariadb-10-2-package
### mroonga_query_expand UDF has been supported
In this release, mroonga_query_expand UDF has been supported.
Here is the sample schema to use this UDF.
CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
content VARCHAR(255),
FULLTEXT INDEX (content)
) ENGINE = Mroonga DEFAULT CHARSET utf8;
CREATE TABLE synonyms (
term varchar(255),
synonym varchar(255),
INDEX (term)
) ENGINE= Mroonga DEFAULT CHARSET utf8;
diaries is table for full text search. synonym table is used to define
synonyms.
Then insert sample data:
INSERT INTO synonyms VALUES ('Groonga', 'Groonga Mroonga Rroonga');
INSERT INTO diaries (content) VALUES ("Groonga is fast.");
INSERT INTO diaries (content) VALUES ("Mroonga is fast.");
INSERT INTO diaries (content) VALUES ("PGroonga is fast.");
Let's use mroonga_query_expand UDF.
If you want to search with synonym term, just use
mroonga_query_expand("synonyms", "term", "synonym", "Groonga"). This
enable you to do full text search by 'Groonga', 'Mroonga', 'Roonga' at
once even though specified term is only 'Groonga'.
mysql> SELECT * FROM diaries WHERE MATCH(content)
AGAINST(mroonga_query_expand("synonyms", "term", "synonym", "Groonga") IN
BOOLEAN MODE);
++--+
| id | content |
++--+
| 1 | Groonga is fast. |
| 2 | Mroonga is fast. |
++--+
2 rows in set (0.01 sec)
Regards,
--
Kentaro Hayashi
pgpwGRghM20cV.pgp
Description: PGP signature
[ANN] Mroonga 7.06 - Fast fulltext search for all languages on MySQL
Hi,
Mroonga 7.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.
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
Blog:
http://mroonga.org/en/blog/2017/08/29/mroonga-7.06.html
Changes:
http://mroonga.org/docs/news.html#release-7.06
Here is the topic in this release.
* Generated Column has been supported
### Generated Column has been supported
In this release, Generated Column has been supported!
Here is the sample schema to use generated column.
CREATE TABLE logs (
id INT,
record JSON,
message VARCHAR(255) GENERATED ALWAYS AS (json_extract(`record`,
'$.message')) STORED,
FULLTEXT INDEX(message) comment 'tokenizer
"TokenBigramSplitSymbolAlphaDigit"'
) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4;
As you can see, the partial value of `record` column is used as `message`
column.
Then, you can do full text search against `message` column by the following
query.
> SELECT * FROM logs WHERE MATCH(message) AGAINST("ar" IN BOOLEAN MODE);
+--+-+---+
| id | record | message |
+--+-+---+
|1 | {"level": "info", "message": "start"} | "start" |
|2 | {"level": "info", "message": "restart"} | "restart" |
+--+-+---+
2 rows in set (0.02 sec)
You can also define `VIRTUAL` without actual data column.
CREATE TABLE logs (
id INT,
record JSON,
message VARCHAR(255) GENERATED ALWAYS AS (json_extract(`record`,
'$.message')) VIRTUAL
) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4;
But note that `FULLTEXT INDEX(message)` is not supported yet.
Regards,
--
Kentaro Hayashi
pgpesmZoNWTia.pgp
Description: PGP signature
[ANN] Mroonga 7.05 - Fast fulltext search for all languages on MySQL
Hi,
Mroonga 7.05 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.
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
Blog:
http://mroonga.org/en/blog/2017/07/29/mroonga-7.05.html
Changes:
http://mroonga.org/docs/news.html#release-7.05
There are some topics in this release.
* Groonga query log has been supported
* MariaDB 10.2.7 has been supported
* Auto command syntax escape feature has been supported
* Ubuntu 16.10 (Yekkety Yak) support has been dropped
# Groonga query log has been supported
In this release, Groonga query log has been supported.
Use mroonga_query_log_file variable to use this feature.
mysql> SET GLOBAL mroonga_query_log_file = "/tmp/query.log";
It is useful to analyze query where is bottleneck in Groonga layer.
## MariaDB 10.2.7 has been supported
In this release, MariaDB 10.2.7 has been supported.
Thanks Tomohiro 'Tomo-p' KATO for contributing to fix build error
against MariaDB 10.2.7..
## Auto command syntax escape feature has been supported
In this release, auto command syntax escape feature has been
supported in mroonga_command.
mroonga_command is used to cooperate with Groonga layer.
You can specify command name and its argument separately in
mroonga_command.
Using new syntax, arguments are automatically escaped, so you don't need to
consider what query is actually passed to Groonga layer.
SELECT mroonga_command('COMMAND_NAME',
'PARAMETER_NAME_1', 'PARAMETER_VALUE_1',
...,
'PARAMETER_NAME_N', 'PARAMETER_VALUE_N');
Example:
SELECT mroonga_command('select',
'table', 'diaries',
'filter', 'title @ "Groonga"');
It is useful for active mroonga_command user.
## Ubuntu 16.10 (Yekkety Yak) support has been dropped
In this release, Ubuntu 16.10 (Yakkety Yak) support was dropped. It
has reached EOL at July 20, 2017.
Regards,
--
Kentaro Hayashi
pgp2ggO7o_aV2.pgp
Description: PGP signature
[ANN] Mroonga 7.04 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 7.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. 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 Blog: http://mroonga.org/en/blog/2017/06/29/mroonga-7.04.html Changes: http://mroonga.org/docs/news.html#release-7.04 # Supported Debian 9 (stretch) In this release, Debian 9 (stretch) has been supported! Here is the Debian 9 specific install procedure: Add apt configuration in /etc/apt/sources.list.d/groonga.list: deb https://packages.groonga.org/debian/ stretch main deb-src https://packages.groonga.org/debian/ stretch main Run the following commands to install Mroonga: % sudo apt-get install apt-transport-https % sudo apt-get update % sudo apt-get install -y --allow-unauthenticated groonga-keyring % sudo apt-get update % sudo apt-get install -y -V mariadb-server-10.1-mroonga Since Debian 9, MariaDB 10.1 is adopted as a MySQL variant. mariadb-server-10.1-mroonga is corresponding package for it. Note that mariadb-plugin-mroonga is bundled version of Mroonga in MariaDB 10.1. It is a bit old version of Mroonga. We recommends to use mariadb-server-10.1-mroonga package! Regards, -- Kentaro Hayashi pgpeNDd1NXEII.pgp Description: PGP signature
[ANN] Mroonga 7.03 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 7.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. 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 Blog: http://mroonga.org/en/blog/2017/05/29/mroonga-7.03.html Changes: http://mroonga.org/docs/news.html#release-7.03 There are some topics in this release. * Supported INDEX_MEDIUM and INDEX_SMALL flags * [CentOS] Supported recent Percona Server 5.6.36 and 5.7.18 # Supported INDEX_MEDIUM and INDEX_SMALL flags In this release, the two flags which is supported since Groonga 6.0.8 are also supported in Mroonga. This two flags are used to create compact indexes in contrast to traditional Mroonga indexes. By using above two flags, you will be able to reduce memory consumption efficiently. Here is the example how to use these flags. CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, content VARCHAR(255), FULLTEXT INDEX (content) COMMENT 'flags "INDEX_SMALL"' ) ENGINE = Mroonga DEFAULT CHARSET utf8; Regards, pgpHUHe7wUkO0.pgp Description: PGP signature
[ANN] Mroonga 7.02 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 7.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. 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 Blog: http://mroonga.org/en/blog/2017/04/29/mroonga-7.02.html Changes: http://mroonga.org/docs/news.html#release-7.02 Here are the improvements in this release. * Supported Ubuntu 17.04 (Zesty Zapus) * Dropped Ubuntu 12.04 (Precise Pangolin) because of EOL * Fixed build error with MySQL 5.6.36 and 5.7.18 -- Kentaro Hayashi pgpjy29UmdZlE.pgp Description: PGP signature
[ANN] Mroonga 7.01 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 7.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. 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 Blog: http://mroonga.org/en/blog/2017/03/29/mroonga-7.01.html Changes: http://mroonga.org/docs/news.html#release-7.01 There are some topics in this release. * Dropped CentOS 5 support because of EOL * [Storage mode] Supported fast ORDER LIMIT with ENUM. * Supported COMPRESS_ZSTD column compression flag. * Visual Studio 2015 or later is required to build from source. Thanks. -- Kentaro Hayashi pgpDYoZLrtZ7r.pgp Description: PGP signature
[ANN] Mroonga 7.00 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 7.00 has been released! Even though major version upgrade, it keeps compatibility of Mroonga 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 Blog: http://mroonga.org/en/blog/2017/02/09/mroonga-7.00.html Changes: http://mroonga.org/docs/news.html#release-7.00 There are two topics in this release. * Supported FOREIGN KEY constrain on UPDATE and DELETE parent row. In the previous versions, only FOREIGN KEY constrain on INSERT is supported. * [Storage mode] Supported updating row even though its table has primary key with ROW binlog format. In the previous version, it causes update statement error. -- Kentaro Hayashi pgpHKkASWJG_I.pgp Description: PGP signature
[ANN] Mroonga 6.11 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 6.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. 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 Blog: http://mroonga.org/en/blog/2016/11/29/mroonga-6.11.html Changes: http://mroonga.org/docs/news.html#release-6.11 There is a topic in this release. * Supported MariaDB 10.x package for Debian jessie ## Supported MariaDB 10.x package for Debian jessie In this release, we began to support Mroonga packages for MariaDB 10.x on Debian jessie. This support is provided for Debian jessie because MariaDB 10.x packages are also available on this release and it aims to make it easy to try Mroonga for user of MariaDB. To install Mroonga package for MariaDB, use mariadb-server-10.0-mroonga. $ sudo apt-get install -y -V mariadb-server-10.0-mroonga Regards, -- Kentaro Hayashi pgpy0OMZLfse8.pgp Description: PGP signature
Re: [ANN] Mroonga 6.10 - Fast fulltext search for all languages on MySQL
Hi, sorry for late response. Currently we have NO RECENT benchmark for direct comparison of Mroonga vs Elasticsearch. However, there are some helpful benchmarks. 1) Groonga 4.0.1 vs Elasticsearch 1.1.1 at 2014 http://blog.createfield.com/entry/2014/04/21/120023 (Japanese) (Note: Groonga is the core component of Mroonga.) 2) Groonga 4.0.3 vs Elasticsearch 1.1.2 at 2014, around indexing http://blog.createfield.com/entry/2014/07/22/080958 (Japanese) 3) Mroonga vs InnoDB[ngram] vs InnoDB[MeCab] benchamrk on MySQL 5.7 at July 2016 https://slide.rabbit-shocker.org/authors/kou/mariadb-community-event-2016-07-21/ (Note: both Mroogna and InnoDB are storage engines for MySQL. Both ngram and MeCab are major tokenizers for indexing of Japanese text.) Summary of 1) Groonga : Elasticsearch * Update / 1 : 2.5~3.13 (Elasticsearch is faster) * Disk usage / 1 : 1.14~1.5 (Elasticsearch's disk usage is smaller) * Search performance / 2.5~4.31 : 1 (Groonga is faster) Summary of 2) * The delay for a new record, until it appears in the search result after it is added: - Groonga: 0.09sec (a new record appears in the search result immediately) - Elasticsearch: 1.01sec (you need to wait for a refresh) * Estimated time to search (tested with 1000 queries): - Groonga[dynamic indexing]: ave=0.050sec, min=0.00215sec, max=0.339sec - Groonga[static indexing]: ave=0.052sec, min=0.00182sec, max=0.401sec - Elasticsearch[not optimized]: ave=0.216sec, min=0.000960sec, max=4.313sec - Elasticsearch[optimized]: ave=0.141sec, min=0.00317sec, max=1.037sec => - Groonga is constantly fast, without optimization. (On Groonga, static indexing is similar to "optimization". However, Groonga is enough fast even if the index is built dynamically, so you don't need to do periodical "optimization".) - Elasticsearch seems to require periodical optimization. Summary of 3), search performances of Mroonga : InnoDB[ngram] : InnoDB[MeCab] * case1, 23K hits / 3454 : 1654 : 1 (Mroonga is fastest) * case2, 17K hits / 400 : 1 : 1200 (InnoDB[MeCab] is fastest, Mroonga is the second) * case3, 400 hits / 1 : N/A : 5.6 (InnoDB[MeCab] is fastest, Mroonga is the second) * case4, 630K hits / 6 : 1 : 1 (Mroonga is fastest) => - Mroonga is constantly fast. - InnoDB[ngram] is constantly slow. - InnoDB[MeCab] is sometimes fast, sometimes slow. I hope it may helps. Regards, On Sat, 29 Oct 2016 04:15:47 -0400 Sami wrote: > Can you post some benchmarks or comparison with elasticsearch? > > > Sent from ProtonMail mobile > > > > ---- Original Message > On 29 ott 2016 05:03, Kentaro Hayashi wrote: > > Hi, > > Mroonga 6.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. > > 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 > > Blog: > http://mroonga.org/en/blog/2016/10/29/mroonga-6.10.html > > Changes: > http://mroonga.org/docs/news.html#release-6.10 > > There are two topics in this release. > > * Supported Ubuntu 16.10 (Yakkety Yak) > * Supported Mroonga with MariaDB 10.x for Ubuntu 16.04 or later > > ## Supported Ubuntu 16.10 (Yakkety Yak) > > In this release, we began to support Ubuntu 16.10 (Yakkety Yak). > > Mroonga packages are provided on PPA, you can install as follows: > > $ sudo apt-get install -y -V software-properties-common lsb-release > $ sudo add-apt-repository -y universe > $ sudo add-apt-repository \ > "deb http://security.ubuntu.com/ubuntu $(lsb_release --short > --codename)-security main restricted" > $ sudo add-apt-repository -y ppa:groonga/ppa > $ sudo apt-get update > $ sudo apt-get install -y -V mysql-server-mroonga > > ## Supported Mroonga with MariaDB 10.x for Ubuntu 16.04 or later > > In this release, we began to support Mroonga packages for MariaDB > 10.x. > > This support is provided for Ubuntu 16.04 or later because MariaDB > 10.x packages are available on these releases and it aims to make it > easy to try Mroonga for user of MariaDB. > > To install Mroonga package for MariaDB, use mariadb-server-mroonga. > > $ sudo apt-get install -y -V mariadb-server-mroonga > > > -- > Kentaro Hayashi -- Kentaro Hayashi pgpSSQIyjKEX1.pgp Description: PGP signature
[ANN] Mroonga 6.10 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 6.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. 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 Blog: http://mroonga.org/en/blog/2016/10/29/mroonga-6.10.html Changes: http://mroonga.org/docs/news.html#release-6.10 There are two topics in this release. * Supported Ubuntu 16.10 (Yakkety Yak) * Supported Mroonga with MariaDB 10.x for Ubuntu 16.04 or later ## Supported Ubuntu 16.10 (Yakkety Yak) In this release, we began to support Ubuntu 16.10 (Yakkety Yak). Mroonga packages are provided on PPA, you can install as follows: $ sudo apt-get install -y -V software-properties-common lsb-release $ sudo add-apt-repository -y universe $ sudo add-apt-repository \ "deb http://security.ubuntu.com/ubuntu $(lsb_release --short --codename)-security main restricted" $ sudo add-apt-repository -y ppa:groonga/ppa $ sudo apt-get update $ sudo apt-get install -y -V mysql-server-mroonga ## Supported Mroonga with MariaDB 10.x for Ubuntu 16.04 or later In this release, we began to support Mroonga packages for MariaDB 10.x. This support is provided for Ubuntu 16.04 or later because MariaDB 10.x packages are available on these releases and it aims to make it easy to try Mroonga for user of MariaDB. To install Mroonga package for MariaDB, use mariadb-server-mroonga. $ sudo apt-get install -y -V mariadb-server-mroonga -- Kentaro Hayashi pgpptGHRGqava.pgp Description: PGP signature
[ANN] Mroonga 6.09 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 6.09 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. 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 Blog: http://mroonga.org/en/blog/2016/09/29/mroonga-6.09.html Changes: http://mroonga.org/docs/news.html#release-6.09 Here is the topic in this release. * Supported nonexistent reference insert check for FOREIGN KEY ## Supported nonexistent reference insert check for FOREIGN KEY In the previous versions, there is no support about reference insert check for FOREIGN KEY. create table HOGES( ID INT PRIMARY KEY AUTO_INCREMENT, HOGE VARCHAR(255) ) ENGINE=Mroonga; create table FOODS( ID INT PRIMARY KEY AUTO_INCREMENT, HOGE_IDINT(10), FOOVARCHAR(255), foreign key(HOGE_ID) references HOGES(ID) ) ENGINE=Mroonga ; so, invalid data was inserted without error if you use above schema. Note that FOREIGN KEY check doesn't work for old version of MySQL and folks such as MySQL 5.5 or MariaDB 5.5, and FOREIGN KEY check for INSERT/DELETE is not supported yet. (it will be supported in the future release!) -- Kentaro Hayashi pgp7gYQrFC4RI.pgp Description: PGP signature
[ANN] Mroonga 6.08 - storage engine, fast fulltext search, CJK ready
Hi, Mroonga 6.08 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. 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 Blog: http://mroonga.org/en/blog/2016/08/29/mroonga-6.08.html Changes: http://mroonga.org/docs/news.html#release-6.08 There are two topics in this release. * Supported MariaDB 10.2.1 * Limitation about the maximum number record is relaxed ## Supported MariaDB 10.2.1 In this release, MariaDB 10.2.1 which is released 4 Jul, 2016 has been supported. As official Mroonga packages are not provided (because MariaDB 10.2.1 is alpha release), please see the following instruction to install it from source archive. http://mroonga.org/docs/install/others.html ## Limitation about the maximum number record is relaxed A table had the following limitations. This limitation is derived from Groonga. * The maximum one key size: 4KiB * The maximum total size of keys: 4GiB * The maximum number of records: 268,435,455 (more than 268 million) In the past, the maximum number of records is announced as 268 million. With recent research, it turns out that there is a capability to store more records than ever. Here is the updated limitation about the maximum number of records: * No primary key table: 1,073,741,815 (2^30 - 9) * PRIMARY KEY or PRIMARY KEY USING BTREE table: 1,073,741,823 (2^30 - 1) * PRIMARY KEY USING HASH table: 536,870,912 (2^29) Keep in mind that these limitations may vary depending on conditions. -- Kentaro Hayashi pgpcLewJWoSNM.pgp Description: PGP signature
[ANN] Mroonga 6.07 - Fast fulltext search for all languages on MySQL
Hi, Mroonga 6.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. 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 Blog: http://mroonga.org/en/blog/2016/08/04/mroonga-6.07.html Changes: http://mroonga.org/docs/news.html#release-6.07 There are two topics in this release. * Updated bundled MariaDB to 10.1.16 on Windows * Dropped Ubuntu 15.10 (Wily Werewolf) support ## Updated bundled MariaDB to 10.1.16 on Windows In this release, bundled MariaDB is updated to 10.1.16. MariaDB 10.1.16 is the latest stable (GA) release. You can use it with latest Groonga (6.0.7) and Mroonga (6.07). ## Dropped Ubuntu 15.10 (Wily Werewolf) support In this release, Ubuntu 15.10 support is dropped. It reached EOL on July 28, 2016. Ubuntu 15.10 (Wily Werewolf) reaches End of Life on July 28 2016. We recommends to migrate to Ubuntu 16.04 because Mroonga 6.07 package for 16.04 is provided as PPA. -- Kentaro Hayashi pgpXqVgSMlM0y.pgp Description: PGP signature
