Web lists-archives.com

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 <samiii@xxxxxxxxxxxxxx> 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 <hayashi@xxxxxxxxxxxxxx>

-- 
Kentaro Hayashi <hayashi@xxxxxxxxxxxxxx>

Attachment: pgpkNW3AKZshF.pgp
Description: PGP signature