kou
commented
8 years ago mysql.shの結果。（うまくいかなくて何度も途中からやり直したものを切り貼りしている。）
環境はConoHaの3CPU、メモリー4GB、SSD 250GB。
CPU:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 45
model name : Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz
stepping : 7
microcode : 0x1
cpu MHz : 2593.748
cache size : 4096 KB
physical id : 0
siblings : 1
core id : 0
cpu cores : 1
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc rep_good nopl eagerfpu pni pclmulqdq vmx ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt aes xsave avx hypervisor lahf_lm xsaveopt
bogomips : 5187.49
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 45
model name : Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz
stepping : 7
microcode : 0x1
cpu MHz : 2593.748
cache size : 4096 KB
physical id : 1
siblings : 1
core id : 0
cpu cores : 1
apicid : 1
initial apicid : 1
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc rep_good nopl eagerfpu pni pclmulqdq vmx ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt aes xsave avx hypervisor lahf_lm xsaveopt
bogomips : 5187.49
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:
processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 45
model name : Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz
stepping : 7
microcode : 0x1
cpu MHz : 2593.748
cache size : 4096 KB
physical id : 2
siblings : 1
core id : 0
cpu cores : 1
apicid : 2
initial apicid : 2
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc rep_good nopl eagerfpu pni pclmulqdq vmx ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt aes xsave avx hypervisor lahf_lm xsaveopt
bogomips : 5187.49
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:
processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 45
model name : Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz
stepping : 7
microcode : 0x1
cpu MHz : 2593.748
cache size : 4096 KB
physical id : 3
siblings : 1
core id : 0
cpu cores : 1
apicid : 3
initial apicid : 3
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc rep_good nopl eagerfpu pni pclmulqdq vmx ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt aes xsave avx hypervisor lahf_lm xsaveopt
bogomips : 5187.49
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:
Memory:
total used free shared buff/cache available
Mem: 3882516 140056 3313580 9116 428880 3515956
Swap: 16777212 0 16777212
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Resolving Dependencies
--> Running transaction check
---> Package epel-release.noarch 0:7-5 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
epel-release noarch 7-5 extras 14 k
Transaction Summary
================================================================================
Install 1 Package
Total download size: 14 k
Installed size: 24 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : epel-release-7-5.noarch 1/1
Verifying : epel-release-7-5.noarch 1/1
Installed:
epel-release.noarch 0:7-5
Complete!
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* epel: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Resolving Dependencies
--> Running transaction check
---> Package wget.x86_64 0:1.14-10.el7_0.1 will be installed
---> Package xz.x86_64 0:5.1.2-9alpha.el7 will be updated
---> Package xz.x86_64 0:5.1.2-12alpha.el7 will be an update
--> Processing Dependency: xz-libs = 5.1.2-12alpha.el7 for package: xz-5.1.2-12alpha.el7.x86_64
--> Running transaction check
---> Package xz-libs.x86_64 0:5.1.2-9alpha.el7 will be updated
---> Package xz-libs.x86_64 0:5.1.2-12alpha.el7 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
wget x86_64 1.14-10.el7_0.1 base 545 k
Updating:
xz x86_64 5.1.2-12alpha.el7 base 200 k
Updating for dependencies:
xz-libs x86_64 5.1.2-12alpha.el7 base 102 k
Transaction Summary
================================================================================
Install 1 Package
Upgrade 1 Package (+1 Dependent package)
Total download size: 847 k
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
--------------------------------------------------------------------------------
Total 2.4 MB/s | 847 kB 00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : xz-libs-5.1.2-12alpha.el7.x86_64 1/5
Updating : xz-5.1.2-12alpha.el7.x86_64 2/5
Installing : wget-1.14-10.el7_0.1.x86_64 3/5
Cleanup : xz-5.1.2-9alpha.el7.x86_64 4/5
Cleanup : xz-libs-5.1.2-9alpha.el7.x86_64 5/5
Verifying : wget-1.14-10.el7_0.1.x86_64 1/5
Verifying : xz-libs-5.1.2-12alpha.el7.x86_64 2/5
Verifying : xz-5.1.2-12alpha.el7.x86_64 3/5
Verifying : xz-libs-5.1.2-9alpha.el7.x86_64 4/5
Verifying : xz-5.1.2-9alpha.el7.x86_64 5/5
Installed:
wget.x86_64 0:1.14-10.el7_0.1
Updated:
xz.x86_64 0:5.1.2-12alpha.el7
Dependency Updated:
xz-libs.x86_64 0:5.1.2-12alpha.el7
Complete!
2016-02-08 08:55:52 URL:http://packages.groonga.org/tmp/ja-all-pages.csv.xz [1586151400/1586151400] -> "ja-all-pages.csv.xz" [1]
/home/kou
Loaded plugins: fastestmirror
Examining /var/tmp/yum-root-rExb7z/mysql-community-release-el7-7.noarch.rpm: mysql-community-release-el7-7.noarch
Marking /var/tmp/yum-root-rExb7z/mysql-community-release-el7-7.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-release.noarch 0:el7-7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version
Repository Size
================================================================================
Installing:
mysql-community-release
noarch el7-7 /mysql-community-release-el7-7.noarch 7.8 k
Transaction Summary
================================================================================
Install 1 Package
Total size: 7.8 k
Installed size: 7.8 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-community-release-el7-7.noarch 1/1
Verifying : mysql-community-release-el7-7.noarch 1/1
Installed:
mysql-community-release.noarch 0:el7-7
Complete!
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* epel: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Resolving Dependencies
--> Running transaction check
---> Package yum-utils.noarch 0:1.1.31-34.el7 will be installed
--> Processing Dependency: python-kitchen for package: yum-utils-1.1.31-34.el7.noarch
--> Running transaction check
---> Package python-kitchen.noarch 0:1.1.1-5.el7 will be installed
--> Processing Dependency: python-chardet for package: python-kitchen-1.1.1-5.el7.noarch
--> Running transaction check
---> Package python-chardet.noarch 0:2.2.1-1.el7_1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
yum-utils noarch 1.1.31-34.el7 base 113 k
Installing for dependencies:
python-chardet noarch 2.2.1-1.el7_1 base 227 k
python-kitchen noarch 1.1.1-5.el7 base 267 k
Transaction Summary
================================================================================
Install 1 Package (+2 Dependent packages)
Total download size: 607 k
Installed size: 2.8 M
Downloading packages:
--------------------------------------------------------------------------------
Total 1.8 MB/s | 607 kB 00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : python-chardet-2.2.1-1.el7_1.noarch 1/3
Installing : python-kitchen-1.1.1-5.el7.noarch 2/3
Installing : yum-utils-1.1.31-34.el7.noarch 3/3
Verifying : python-kitchen-1.1.1-5.el7.noarch 1/3
Verifying : yum-utils-1.1.31-34.el7.noarch 2/3
Verifying : python-chardet-2.2.1-1.el7_1.noarch 3/3
Installed:
yum-utils.noarch 0:1.1.31-34.el7
Dependency Installed:
python-chardet.noarch 0:2.2.1-1.el7_1 python-kitchen.noarch 0:1.1.1-5.el7
Complete!
Loaded plugins: fastestmirror
=========================== repo: mysql56-community ============================
[mysql56-community]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7
baseurl = http://repo.mysql.com/yum/mysql-5.6-community/el/7/x86_64/
cache = 0
cachedir = /var/cache/yum/x86_64/7/mysql56-community
check_config_file_age = True
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage =
enabled = 0
enablegroups = True
exclude =
failovermethod = priority
gpgcadir = /var/lib/yum/repos/x86_64/7/mysql56-community/gpgcadir
gpgcakey =
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7/mysql56-community/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
hdrdir = /var/cache/yum/x86_64/7/mysql56-community/headers
http_caching = all
includepkgs =
ip_resolve =
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid =
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink =
minrate = 0
mirrorlist =
mirrorlist_expire = 86400
name = MySQL 5.6 Community Server
old_base_cache_dir =
password =
persistdir = /var/lib/yum/repos/x86_64/7/mysql56-community
pkgdir = /var/cache/yum/x86_64/7/mysql56-community/packages
proxy = False
proxy_dict =
proxy_password =
proxy_username =
repo_gpgcheck = False
retries = 10
skip_if_unavailable = False
ssl_check_cert_permissions = True
sslcacert =
sslclientcert =
sslclientkey =
sslverify = True
throttle = 0
timeout = 30.0
ui_id = mysql56-community/x86_64
ui_repoid_vars = releasever,
basearch
username =
Loaded plugins: fastestmirror
=========================== repo: mysql57-community ============================
[mysql57-community]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7
baseurl = http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/
cache = 0
cachedir = /var/cache/yum/x86_64/7/mysql57-community
check_config_file_age = True
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage =
enabled = 1
enablegroups = True
exclude =
failovermethod = priority
gpgcadir = /var/lib/yum/repos/x86_64/7/mysql57-community/gpgcadir
gpgcakey =
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7/mysql57-community/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
hdrdir = /var/cache/yum/x86_64/7/mysql57-community/headers
http_caching = all
includepkgs =
ip_resolve =
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid =
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink =
minrate = 0
mirrorlist =
mirrorlist_expire = 86400
name = MySQL 5.7 Community Server
old_base_cache_dir =
password =
persistdir = /var/lib/yum/repos/x86_64/7/mysql57-community
pkgdir = /var/cache/yum/x86_64/7/mysql57-community/packages
proxy = False
proxy_dict =
proxy_password =
proxy_username =
repo_gpgcheck = False
retries = 10
skip_if_unavailable = False
ssl_check_cert_permissions = True
sslcacert =
sslclientcert =
sslclientkey =
sslverify = True
throttle = 0
timeout = 30.0
ui_id = mysql57-community/x86_64
ui_repoid_vars = releasever,
basearch
username =
Loaded plugins: fastestmirror
Examining /var/tmp/yum-root-rExb7z/groonga-release-1.1.0-1.noarch.rpm: groonga-release-1.1.0-1.noarch
Marking /var/tmp/yum-root-rExb7z/groonga-release-1.1.0-1.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package groonga-release.noarch 0:1.1.0-1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
groonga-release noarch 1.1.0-1 /groonga-release-1.1.0-1.noarch 3.8 k
Transaction Summary
================================================================================
Install 1 Package
Total size: 3.8 k
Installed size: 3.8 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : groonga-release-1.1.0-1.noarch 1/1
Verifying : groonga-release-1.1.0-1.noarch 1/1
Installed:
groonga-release.noarch 0:1.1.0-1
Complete!
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* epel: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Resolving Dependencies
--> Running transaction check
---> Package mysql57-community-mroonga.x86_64 0:5.12-2.el7.centos will be installed
--> Processing Dependency: mysql-community-client = 5.7.11-1.el7 for package: mysql57-community-mroonga-5.12-2.el7.centos.x86_64
--> Processing Dependency: mysql-community-server = 5.7.11-1.el7 for package: mysql57-community-mroonga-5.12-2.el7.centos.x86_64
--> Processing Dependency: groonga-libs >= 5.1.0 for package: mysql57-community-mroonga-5.12-2.el7.centos.x86_64
--> Processing Dependency: groonga-normalizer-mysql for package: mysql57-community-mroonga-5.12-2.el7.centos.x86_64
--> Processing Dependency: libgroonga.so.0()(64bit) for package: mysql57-community-mroonga-5.12-2.el7.centos.x86_64
--> Running transaction check
---> Package groonga-libs.x86_64 0:5.1.2-1.el7.centos will be installed
---> Package groonga-normalizer-mysql.x86_64 0:1.1.0-1.el7.centos will be installed
---> Package mysql-community-client.x86_64 0:5.7.11-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) = 5.7.11-1.el7 for package: mysql-community-client-5.7.11-1.el7.x86_64
---> Package mysql-community-server.x86_64 0:5.7.11-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.11-1.el7 for package: mysql-community-server-5.7.11-1.el7.x86_64
--> Processing Dependency: net-tools for package: mysql-community-server-5.7.11-1.el7.x86_64
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.41-2.el7_0 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.11-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:5.7.11-1.el7 will be obsoleting
---> Package net-tools.x86_64 0:2.0-0.17.20131004git.el7 will be installed
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.7.11-1.el7 will be obsoleting
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-community-libs x86_64 5.7.11-1.el7 mysql57-community 2.2 M
replacing mariadb-libs.x86_64 1:5.5.41-2.el7_0
mysql-community-libs-compat x86_64 5.7.11-1.el7 mysql57-community 2.0 M
replacing mariadb-libs.x86_64 1:5.5.41-2.el7_0
mysql57-community-mroonga x86_64 5.12-2.el7.centos groonga 215 k
Installing for dependencies:
groonga-libs x86_64 5.1.2-1.el7.centos groonga 1.7 M
groonga-normalizer-mysql x86_64 1.1.0-1.el7.centos groonga 39 k
mysql-community-client x86_64 5.7.11-1.el7 mysql57-community 25 M
mysql-community-common x86_64 5.7.11-1.el7 mysql57-community 270 k
mysql-community-server x86_64 5.7.11-1.el7 mysql57-community 143 M
net-tools x86_64 2.0-0.17.20131004git.el7
base 304 k
Transaction Summary
================================================================================
Install 3 Packages (+6 Dependent packages)
Total download size: 174 M
Downloading packages:
warning: /var/cache/yum/x86_64/7/groonga/packages/groonga-normalizer-mysql-1.1.0-1.el7.centos.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
Public key for groonga-normalizer-mysql-1.1.0-1.el7.centos.x86_64.rpm is not installed
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.11-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-5.7.11-1.el7.x86_64.rpm is not installed
--------------------------------------------------------------------------------
Total 5.6 MB/s | 174 MB 00:31
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
Package : mysql-community-release-el7-7.noarch (@/mysql-community-release-el7-7.noarch)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Importing GPG key 0x45499429:
Userid : "groonga Key (groonga Official Signing Key) <packages@groonga.org>"
Fingerprint: c97e 4649 a205 1d0c ea1a 73f9 72a7 496b 4549 9429
Package : groonga-release-1.1.0-1.noarch (@/groonga-release-1.1.0-1.noarch)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : groonga-libs-5.1.2-1.el7.centos.x86_64 1/10
Installing : mysql-community-common-5.7.11-1.el7.x86_64 2/10
Installing : mysql-community-libs-5.7.11-1.el7.x86_64 3/10
Installing : mysql-community-client-5.7.11-1.el7.x86_64 4/10
Installing : groonga-normalizer-mysql-1.1.0-1.el7.centos.x86_64 5/10
Installing : net-tools-2.0-0.17.20131004git.el7.x86_64 6/10
Installing : mysql-community-server-5.7.11-1.el7.x86_64 7/10
Installing : mysql57-community-mroonga-5.12-2.el7.centos.x86_64 8/10
Redirecting to /bin/systemctl status mysqld.service
Redirecting to /bin/systemctl start mysqld.service
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
Redirecting to /bin/systemctl stop mysqld.service
Installing : mysql-community-libs-compat-5.7.11-1.el7.x86_64 9/10
Erasing : 1:mariadb-libs-5.5.41-2.el7_0.x86_64 10/10
Verifying : mysql-community-common-5.7.11-1.el7.x86_64 1/10
Verifying : mysql-community-libs-compat-5.7.11-1.el7.x86_64 2/10
Verifying : net-tools-2.0-0.17.20131004git.el7.x86_64 3/10
Verifying : mysql-community-libs-5.7.11-1.el7.x86_64 4/10
Verifying : mysql57-community-mroonga-5.12-2.el7.centos.x86_64 5/10
Verifying : mysql-community-client-5.7.11-1.el7.x86_64 6/10
Verifying : mysql-community-server-5.7.11-1.el7.x86_64 7/10
Verifying : groonga-normalizer-mysql-1.1.0-1.el7.centos.x86_64 8/10
Verifying : groonga-libs-5.1.2-1.el7.centos.x86_64 9/10
Verifying : 1:mariadb-libs-5.5.41-2.el7_0.x86_64 10/10
Installed:
mysql-community-libs.x86_64 0:5.7.11-1.el7
mysql-community-libs-compat.x86_64 0:5.7.11-1.el7
mysql57-community-mroonga.x86_64 0:5.12-2.el7.centos
Dependency Installed:
groonga-libs.x86_64 0:5.1.2-1.el7.centos
groonga-normalizer-mysql.x86_64 0:1.1.0-1.el7.centos
mysql-community-client.x86_64 0:5.7.11-1.el7
mysql-community-common.x86_64 0:5.7.11-1.el7
mysql-community-server.x86_64 0:5.7.11-1.el7
net-tools.x86_64 0:2.0-0.17.20131004git.el7
Replaced:
mariadb-libs.x86_64 1:5.5.41-2.el7_0
Complete!
log-bin
server-id=1
character-set-server=utf8mb4
validate-password=off
mysql: [Warning] Using a password on the command line interface can be insecure.
Mroonga: data: load:
real 5m45.425s
user 0m0.816s
sys 0m5.392s
Mroonga: data: load: size:
4.0K /var/lib/mysql/benchmark_mroonga.mrn
28K /var/lib/mysql/benchmark_mroonga.mrn.0000000
236K /var/lib/mysql/benchmark_mroonga.mrn.0000100
17M /var/lib/mysql/benchmark_mroonga.mrn.0000101
21M /var/lib/mysql/benchmark_mroonga.mrn.0000102
7.1M /var/lib/mysql/benchmark_mroonga.mrn.0000103
29M /var/lib/mysql/benchmark_mroonga.mrn.0000109
7.1M /var/lib/mysql/benchmark_mroonga.mrn.000010A
78M /var/lib/mysql/benchmark_mroonga.mrn.000010B
860M /var/lib/mysql/benchmark_mroonga.mrn.000010C
862M /var/lib/mysql/benchmark_mroonga.mrn.000010C.001
890M /var/lib/mysql/benchmark_mroonga.mrn.000010C.002
912M /var/lib/mysql/benchmark_mroonga.mrn.000010C.003
921M /var/lib/mysql/benchmark_mroonga.mrn.000010C.004
923M /var/lib/mysql/benchmark_mroonga.mrn.000010C.005
925M /var/lib/mysql/benchmark_mroonga.mrn.000010C.006
920M /var/lib/mysql/benchmark_mroonga.mrn.000010C.007
903M /var/lib/mysql/benchmark_mroonga.mrn.000010C.008
59M /var/lib/mysql/benchmark_mroonga.mrn.000010C.009
28K /var/lib/mysql/benchmark_mroonga.mrn.001
16K /var/lib/mysql/benchmark_mroonga.mrn.conf
8.2G total
InnoDB: ngram: data: load:
real 6m51.708s
user 0m0.875s
sys 0m5.959s
InnoDB: ngram: data: load: size:
4.0K /var/lib/mysql/benchmark_innodb_ngram/db.opt
12K /var/lib/mysql/benchmark_innodb_ngram/wikipedia.frm
10G /var/lib/mysql/benchmark_innodb_ngram/wikipedia.ibd
10G total
InnoDB: mecab: data: load:
real 6m22.854s
user 0m0.947s
sys 0m5.984s
InnoDB: mecab: data: load: size:
4.0K /var/lib/mysql/benchmark_innodb_mecab/db.opt
12K /var/lib/mysql/benchmark_innodb_mecab/wikipedia.frm
10G /var/lib/mysql/benchmark_innodb_mecab/wikipedia.ibd
10G total
Mroonga: create index: 1:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP INDEX fulltext_index' at line 1
real 22m24.943s
user 0m0.007s
sys 0m0.003s
Mroonga: create index: size:
4.0K /var/lib/mysql/benchmark_mroonga.mrn
32K /var/lib/mysql/benchmark_mroonga.mrn.0000000
236K /var/lib/mysql/benchmark_mroonga.mrn.0000100
17M /var/lib/mysql/benchmark_mroonga.mrn.0000101
21M /var/lib/mysql/benchmark_mroonga.mrn.0000102
7.1M /var/lib/mysql/benchmark_mroonga.mrn.0000103
29M /var/lib/mysql/benchmark_mroonga.mrn.0000109
7.1M /var/lib/mysql/benchmark_mroonga.mrn.000010A
78M /var/lib/mysql/benchmark_mroonga.mrn.000010B
860M /var/lib/mysql/benchmark_mroonga.mrn.000010C
862M /var/lib/mysql/benchmark_mroonga.mrn.000010C.001
890M /var/lib/mysql/benchmark_mroonga.mrn.000010C.002
912M /var/lib/mysql/benchmark_mroonga.mrn.000010C.003
921M /var/lib/mysql/benchmark_mroonga.mrn.000010C.004
923M /var/lib/mysql/benchmark_mroonga.mrn.000010C.005
925M /var/lib/mysql/benchmark_mroonga.mrn.000010C.006
920M /var/lib/mysql/benchmark_mroonga.mrn.000010C.007
903M /var/lib/mysql/benchmark_mroonga.mrn.000010C.008
59M /var/lib/mysql/benchmark_mroonga.mrn.000010C.009
131M /var/lib/mysql/benchmark_mroonga.mrn.000010D
97M /var/lib/mysql/benchmark_mroonga.mrn.000010E
32M /var/lib/mysql/benchmark_mroonga.mrn.000010E.001
779M /var/lib/mysql/benchmark_mroonga.mrn.000010E.c
793M /var/lib/mysql/benchmark_mroonga.mrn.000010E.c.001
763M /var/lib/mysql/benchmark_mroonga.mrn.000010E.c.002
748M /var/lib/mysql/benchmark_mroonga.mrn.000010E.c.003
781M /var/lib/mysql/benchmark_mroonga.mrn.000010E.c.004
791M /var/lib/mysql/benchmark_mroonga.mrn.000010E.c.005
265M /var/lib/mysql/benchmark_mroonga.mrn.000010E.c.006
28K /var/lib/mysql/benchmark_mroonga.mrn.001
16K /var/lib/mysql/benchmark_mroonga.mrn.conf
14G total
InnoDB: ngram: create index: 1:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP INDEX fulltext_index' at line 1
real 186m58.159s
user 0m0.003s
sys 0m0.009s
InnoDB: ngram: create index: size:
5.4G /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_0000000000000055_INDEX_1.ibd
317M /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_0000000000000055_INDEX_2.ibd
169M /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_0000000000000055_INDEX_3.ibd
629M /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_0000000000000055_INDEX_4.ibd
825M /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_0000000000000055_INDEX_5.ibd
3.8G /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_0000000000000055_INDEX_6.ibd
96K /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_BEING_DELETED.ibd
96K /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_BEING_DELETED_CACHE.ibd
96K /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_CONFIG.ibd
96K /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_DELETED.ibd
96K /var/lib/mysql/benchmark_innodb_ngram/FTS_0000000000000050_DELETED_CACHE.ibd
4.0K /var/lib/mysql/benchmark_innodb_ngram/db.opt
12K /var/lib/mysql/benchmark_innodb_ngram/wikipedia.frm
11G /var/lib/mysql/benchmark_innodb_ngram/wikipedia.ibd
22G total
InnoDB: mecab: create index: 1:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP INDEX fulltext_index' at line 1
real 101m55.589s
user 0m0.003s
sys 0m0.005s
InnoDB: mecab: create index: size:
2.5G /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_0000000000000063_INDEX_1.ibd
189M /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_0000000000000063_INDEX_2.ibd
125M /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_0000000000000063_INDEX_3.ibd
305M /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_0000000000000063_INDEX_4.ibd
413M /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_0000000000000063_INDEX_5.ibd
1.9G /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_0000000000000063_INDEX_6.ibd
96K /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_BEING_DELETED.ibd
96K /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_BEING_DELETED_CACHE.ibd
96K /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_CONFIG.ibd
96K /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_DELETED.ibd
96K /var/lib/mysql/benchmark_innodb_mecab/FTS_000000000000005c_DELETED_CACHE.ibd
4.0K /var/lib/mysql/benchmark_innodb_mecab/db.opt
12K /var/lib/mysql/benchmark_innodb_mecab/wikipedia.frm
11G /var/lib/mysql/benchmark_innodb_mecab/wikipedia.ibd
16G total
Mroonga: search: MATCH(title, text) AGAINST('*D+ テレビアニメ' IN BOOLEAN MODE): 1:
COUNT(*)
22954
real 0m1.381s
user 0m0.002s
sys 0m0.005s
Mroonga: search: MATCH(title, text) AGAINST('*D+ テレビアニメ' IN BOOLEAN MODE): 2:
COUNT(*)
22954
real 0m0.108s
user 0m0.004s
sys 0m0.001s
Mroonga: search: MATCH(title, text) AGAINST('*D+ テレビアニメ' IN BOOLEAN MODE): 3:
COUNT(*)
22954
real 0m0.115s
user 0m0.001s
sys 0m0.004s
Mroonga: search: MATCH(title, text) AGAINST('*D+ テレビアニメ' IN BOOLEAN MODE): 4:
COUNT(*)
22954
real 0m0.111s
user 0m0.000s
sys 0m0.006s
Mroonga: search: MATCH(title, text) AGAINST('*D+ テレビアニメ' IN BOOLEAN MODE): 5:
COUNT(*)
22954
real 0m0.112s
user 0m0.002s
sys 0m0.003s
Mroonga: search: MATCH(title, text) AGAINST('*D+ データベース' IN BOOLEAN MODE): 1:
COUNT(*)
17180
real 0m0.484s
user 0m0.001s
sys 0m0.003s
Mroonga: search: MATCH(title, text) AGAINST('*D+ データベース' IN BOOLEAN MODE): 2:
COUNT(*)
17180
real 0m0.099s
user 0m0.003s
sys 0m0.002s
Mroonga: search: MATCH(title, text) AGAINST('*D+ データベース' IN BOOLEAN MODE): 3:
COUNT(*)
17180
real 0m0.098s
user 0m0.005s
sys 0m0.004s
Mroonga: search: MATCH(title, text) AGAINST('*D+ データベース' IN BOOLEAN MODE): 4:
COUNT(*)
17180
real 0m0.093s
user 0m0.002s
sys 0m0.003s
Mroonga: search: MATCH(title, text) AGAINST('*D+ データベース' IN BOOLEAN MODE): 5:
COUNT(*)
17180
real 0m0.096s
user 0m0.003s
sys 0m0.002s
Mroonga: search: MATCH(title, text) AGAINST('*D+ PostgreSQL OR MySQL' IN BOOLEAN MODE): 1:
COUNT(*)
368
real 0m0.324s
user 0m0.004s
sys 0m0.003s
Mroonga: search: MATCH(title, text) AGAINST('*D+ PostgreSQL OR MySQL' IN BOOLEAN MODE): 2:
COUNT(*)
368
real 0m0.030s
user 0m0.004s
sys 0m0.001s
Mroonga: search: MATCH(title, text) AGAINST('*D+ PostgreSQL OR MySQL' IN BOOLEAN MODE): 3:
COUNT(*)
368
real 0m0.027s
user 0m0.002s
sys 0m0.004s
Mroonga: search: MATCH(title, text) AGAINST('*D+ PostgreSQL OR MySQL' IN BOOLEAN MODE): 4:
COUNT(*)
368
real 0m0.028s
user 0m0.005s
sys 0m0.002s
Mroonga: search: MATCH(title, text) AGAINST('*D+ PostgreSQL OR MySQL' IN BOOLEAN MODE): 5:
COUNT(*)
368
real 0m0.028s
user 0m0.004s
sys 0m0.001s
Mroonga: search: MATCH(title, text) AGAINST('*D+ 日本' IN BOOLEAN MODE): 1:
COUNT(*)
627724
real 0m0.498s
user 0m0.005s
sys 0m0.001s
Mroonga: search: MATCH(title, text) AGAINST('*D+ 日本' IN BOOLEAN MODE): 2:
COUNT(*)
627724
real 0m0.217s
user 0m0.004s
sys 0m0.001s
Mroonga: search: MATCH(title, text) AGAINST('*D+ 日本' IN BOOLEAN MODE): 3:
COUNT(*)
627724
real 0m0.211s
user 0m0.002s
sys 0m0.004s
Mroonga: search: MATCH(title, text) AGAINST('*D+ 日本' IN BOOLEAN MODE): 4:
COUNT(*)
627724
real 0m0.210s
user 0m0.004s
sys 0m0.005s
Mroonga: search: MATCH(title, text) AGAINST('*D+ 日本' IN BOOLEAN MODE): 5:
COUNT(*)
627724
InnoDB: ngram: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 1:
COUNT(*)
22954
real 3m11.663s
user 0m0.005s
sys 0m0.007s
InnoDB: ngram: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 2:
COUNT(*)
22954
real 3m9.741s
user 0m0.005s
sys 0m0.006s
InnoDB: ngram: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 3:
COUNT(*)
22954
real 3m10.991s
user 0m0.003s
sys 0m0.005s
InnoDB: ngram: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 4:
COUNT(*)
22954
real 3m3.489s
user 0m0.005s
sys 0m0.002s
InnoDB: ngram: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 5:
COUNT(*)
22954
real 3m2.963s
user 0m0.004s
sys 0m0.005s
InnoDB: ngram: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 1:
COUNT(*)
17180
real 2m18.245s
user 0m0.005s
sys 0m0.006s
InnoDB: ngram: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 2:
COUNT(*)
17180
real 2m25.429s
user 0m0.007s
sys 0m0.006s
InnoDB: ngram: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 3:
COUNT(*)
17180
real 1m6.103s
user 0m0.003s
sys 0m0.003s
InnoDB: ngram: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 4:
COUNT(*)
17180
real 0m39.167s
user 0m0.002s
sys 0m0.004s
InnoDB: ngram: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 5:
COUNT(*)
17180
real 0m36.665s
user 0m0.003s
sys 0m0.006s
InnoDB: ngram: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 1:
ERROR 188 (HY000) at line 1: FTS query exceeds result cache limit
real 0m5.448s
user 0m0.003s
sys 0m0.004s
InnoDB: ngram: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 2:
ERROR 188 (HY000) at line 1: FTS query exceeds result cache limit
real 1m2.850s
user 0m0.003s
sys 0m0.009s
InnoDB: ngram: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 3:
ERROR 188 (HY000) at line 1: FTS query exceeds result cache limit
real 0m17.105s
user 0m0.006s
sys 0m0.002s
InnoDB: ngram: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 4:
ERROR 188 (HY000) at line 1: FTS query exceeds result cache limit
real 0m15.969s
user 0m0.005s
sys 0m0.006s
InnoDB: ngram: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 5:
ERROR 188 (HY000) at line 1: FTS query exceeds result cache limit
real 0m6.812s
user 0m0.001s
sys 0m0.006s
InnoDB: ngram: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 1:
COUNT(*)
627724
real 0m1.653s
user 0m0.003s
sys 0m0.002s
InnoDB: ngram: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 2:
COUNT(*)
627724
real 0m1.587s
user 0m0.003s
sys 0m0.003s
InnoDB: ngram: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 3:
COUNT(*)
627724
real 0m1.271s
user 0m0.004s
sys 0m0.003s
InnoDB: ngram: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 4:
COUNT(*)
627724
real 0m1.325s
user 0m0.003s
sys 0m0.002s
InnoDB: ngram: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 5:
COUNT(*)
627724
real 0m1.298s
user 0m0.004s
sys 0m0.002s
InnoDB: mecab: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 1:
COUNT(*)
33525
real 6m28.953s
user 0m0.003s
sys 0m0.004s
InnoDB: mecab: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 2:
COUNT(*)
33525
real 6m20.654s
user 0m0.001s
sys 0m0.006s
InnoDB: mecab: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 3:
COUNT(*)
33525
real 6m24.842s
user 0m0.006s
sys 0m0.007s
InnoDB: mecab: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 4:
COUNT(*)
33525
real 6m24.504s
user 0m0.008s
sys 0m0.004s
InnoDB: mecab: search: MATCH(title, text) AGAINST('テレビアニメ' IN BOOLEAN MODE): 5:
COUNT(*)
33525
real 6m29.784s
user 0m0.004s
sys 0m0.005s
InnoDB: mecab: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 1:
COUNT(*)
16108
real 0m0.218s
user 0m0.003s
sys 0m0.003s
InnoDB: mecab: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 2:
COUNT(*)
16108
real 0m0.030s
user 0m0.003s
sys 0m0.003s
InnoDB: mecab: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 3:
COUNT(*)
16108
real 0m0.030s
user 0m0.003s
sys 0m0.003s
InnoDB: mecab: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 4:
COUNT(*)
16108
real 0m0.030s
user 0m0.003s
sys 0m0.002s
InnoDB: mecab: search: MATCH(title, text) AGAINST('データベース' IN BOOLEAN MODE): 5:
COUNT(*)
16108
real 0m0.030s
user 0m0.004s
sys 0m0.000s
InnoDB: mecab: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 1:
COUNT(*)
368
real 0m0.144s
user 0m0.002s
sys 0m0.003s
InnoDB: mecab: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 2:
COUNT(*)
368
real 0m0.006s
user 0m0.003s
sys 0m0.001s
InnoDB: mecab: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 3:
COUNT(*)
368
real 0m0.005s
user 0m0.004s
sys 0m0.001s
InnoDB: mecab: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 4:
COUNT(*)
368
real 0m0.005s
user 0m0.002s
sys 0m0.002s
InnoDB: mecab: search: MATCH(title, text) AGAINST('PostgreSQL MySQL' IN BOOLEAN MODE): 5:
COUNT(*)
368
real 0m0.005s
user 0m0.003s
sys 0m0.001s
InnoDB: mecab: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 1:
COUNT(*)
568978
real 0m1.336s
user 0m0.004s
sys 0m0.000s
InnoDB: mecab: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 2:
COUNT(*)
568978
real 0m1.316s
user 0m0.004s
sys 0m0.002s
InnoDB: mecab: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 3:
COUNT(*)
568978
real 0m1.328s
user 0m0.004s
sys 0m0.000s
InnoDB: mecab: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 4:
COUNT(*)
568978
real 0m1.318s
user 0m0.003s
sys 0m0.004s
InnoDB: mecab: search: MATCH(title, text) AGAINST('日本' IN BOOLEAN MODE): 5:
COUNT(*)
568978
real 0m1.353s
user 0m0.003s
sys 0m0.002s
このリポジトリーに含まれるベンチマークを実行してその結果を貼る。
ベンチマークを実行するためにはクリーンな（インストール直後）のCentOS 7 x86_64が必要。ディスクは200GBは必要。ディスクがSSDでも12時間はかかる。（InnoDB FTSとpg_bigmのインデックス作成に数時間単位で時間がかかる。）
ベンチマークを実行するユーザーは
sudoでrootユーザーとpostgresユーザーになれること。ベンチマークの実行方法は次の通り。
↑の最後の行に2文含まれているのはこのコマンドを実行したら順番にベンチマークを実行するため。
disownを実行すればログアウトしてもOKだが、その前にvisudoしてに
!を追加してにしておくこと。（
disownを実行していなければ↑は必要ない。）benchmark-log-mysql.txtとbenchmark-log-postgresql.txtをここに貼り付ける。なお、↑のベンチマークスクリプトの内容は次の通り。
mysql.shの方：postgresql.shの方：パフォーマンスチューニングはほとんどしていない。基本的にデフォルトである。MySQLはバイナリーログを有効にしている。これはレプリケーションをすることを想定しているからである。（そのくせにPostgreSQLの
wal_levelをhot_standbyにしていないことは片手落ちである。）実行するクエリーは https://github.com/groonga/wikipedia-search/blob/master/benchmark/search-words.list にある。
少ししかヒットしないクエリーとややヒット数が多いクエリーとかなりヒット数が多いクエリーがある。
日本語Wikipediaのデータなので、データは次の傾向がある。