blob: 6b29be5edb7d14cebbb5a33e9b66f4c7d849c46d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
DROP TABLE IF EXISTS diaries_innodb;
DROP TABLE IF EXISTS diaries_mroonga;
CREATE TABLE diaries_innodb (
id INT PRIMARY KEY AUTO_INCREMENT,
body TEXT,
flag TINYINT(2),
INDEX (flag)
) ENGINE = InnoDB DEFAULT CHARSET UTF8;
CREATE TABLE diaries_mroonga (
id INT PRIMARY KEY AUTO_INCREMENT,
body TEXT,
flag TINYINT(2),
INDEX (flag)
) COMMENT = 'ENGINE "InnoDB"' DEFAULT CHARSET UTF8;
INSERT INTO diaries_innodb (body) VALUES ("will start groonga!");
INSERT INTO diaries_innodb (body) VALUES ("starting groonga...");
INSERT INTO diaries_innodb (body) VALUES ("started groonga.");
INSERT INTO diaries_mroonga (body) VALUES ("will start groonga!");
INSERT INTO diaries_mroonga (body) VALUES ("starting groonga...");
INSERT INTO diaries_mroonga (body) VALUES ("started groonga.");
EXPLAIN SELECT COUNT(*) FROM diaries_innodb;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE diaries_innodb index NULL flag 2 NULL 3 Using index
EXPLAIN SELECT COUNT(*) FROM diaries_mroonga;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE diaries_mroonga index NULL flag 2 NULL 3 Using index
DROP TABLE diaries_innodb;
DROP TABLE diaries_mroonga;
|