gistfile1.txt

$ perl wiki.pl ## https://gist.github.com/yoku0825/7ee787766999ad5c42f9

mysql [localhost] {msandbox} (wikipedia) > show create table articles\G
*************************** 1. row ***************************
       Table: articles
Create Table: CREATE TABLE `articles` (
  `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` text,
  `content` longtext,
  `timestamp` datetime DEFAULT NULL,
  UNIQUE KEY `seq` (`seq`)
) ENGINE=Mroonga AUTO_INCREMENT=1914065 DEFAULT CHARSET=utf8
1 row in set (0.06 sec)

mysql [localhost] {msandbox} (wikipedia) > ALTER TABLE articles ADD FULLTEXT KEY(content) Comment 'parser "TokenMecab"';
Query OK, 0 rows affected (53 min 3.23 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql [localhost] {msandbox} (wikipedia) > SELECT COUNT(*) FROM articles WHERE match(content) against ('データベース');
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.36 sec)

mysql [localhost] {msandbox} (wikipedia) > show create table articles\G
*************************** 1. row ***************************
       Table: articles
Create Table: CREATE TABLE `articles` (
  `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` text,
  `content` longtext,
  `timestamp` datetime DEFAULT NULL,
  UNIQUE KEY `seq` (`seq`),
  FULLTEXT KEY `content` (`content`) COMMENT 'parser "TokenMecab"'
) ENGINE=Mroonga AUTO_INCREMENT=1914065 DEFAULT CHARSET=utf8
1 row in set (0.57 sec)

[kou@v157-7-154-209 ~]$ pwd  ## groonga.log is here.
/home/kou
[kou@v157-7-154-209 ~]$ ll
total 179952
-rw-rw-r-- 1 kou kou 184266702 Mar  2 13:05 groonga.log.gz