Gecko [ www.jdcpatala.org ]

Name	Size	Permission
basic.result	12.32 KB	-rw-r--r--
bug_32831765.result	6.29 KB	-rw-r--r--
compatibility.result	9.81 KB	-rw-r--r--
compatibility_win.result	9.81 KB	-rw-r--r--
ddl.result	10.34 KB	-rw-r--r--
fic.result	8.01 KB	-rw-r--r--
foreign_key_check.result	808 B	-rw-r--r--
foreign_key_update.result	663 B	-rw-r--r--
fulltext.result	28.64 KB	-rw-r--r--
fulltext2.result	8.45 KB	-rw-r--r--
fulltext3.result	1.79 KB	-rw-r--r--
fulltext_cache.result	2.77 KB	-rw-r--r--
fulltext_distinct.result	1.45 KB	-rw-r--r--
fulltext_left_join.result	4.27 KB	-rw-r--r--
fulltext_misc.result	8.19 KB	-rw-r--r--
fulltext_multi.result	965 B	-rw-r--r--
fulltext_order_by.result	6.42 KB	-rw-r--r--
fulltext_table_evict.result	688 B	-rw-r--r--
fulltext_update.result	1.12 KB	-rw-r--r--
fulltext_var.result	1.33 KB	-rw-r--r--
index_table.result	6.84 KB	-rw-r--r--
innobase_drop_fts_index_table....	209 B	-rw-r--r--
large_records.result	9.04 KB	-rw-r--r--
limit_union.result	6 KB	-rw-r--r--
mecab_sjis.result	6.62 KB	-rw-r--r--
mecab_ujis.result	6.62 KB	-rw-r--r--
mecab_utf8.result	6.65 KB	-rw-r--r--
misc.result	62.97 KB	-rw-r--r--
misc_1.result	38.56 KB	-rw-r--r--
misc_debug.result	3.72 KB	-rw-r--r--
multiple_index.result	9.16 KB	-rw-r--r--
ngram.result	38.03 KB	-rw-r--r--
ngram_1.result	395.4 KB	-rw-r--r--
ngram_2.result	5.11 KB	-rw-r--r--
ngram_debug.result	8.63 KB	-rw-r--r--
opt.result	68.87 KB	-rw-r--r--
phrase.result	2.1 KB	-rw-r--r--
phrase_clear_no_match.result	2.68 KB	-rw-r--r--
plugin.result	7.52 KB	-rw-r--r--
plugin_1.result	14.8 KB	-rw-r--r--
plugin_debug.result	13.39 KB	-rw-r--r--
proximity.result	7.33 KB	-rw-r--r--
result_cache_limit.result	1.48 KB	-rw-r--r--
savepoint.result	8.69 KB	-rw-r--r--
stopword.result	31.83 KB	-rw-r--r--
stopword_charset.result	10.47 KB	-rw-r--r--
subexpr.result	3.88 KB	-rw-r--r--
sync.result	5.56 KB	-rw-r--r--
sync_block.result	2.64 KB	-rw-r--r--
sync_ddl.result	4.61 KB	-rw-r--r--
tablespace_location.result	43.89 KB	-rw-r--r--
tablespace_location_error.resu...	16.93 KB	-rw-r--r--
transaction.result	42.15 KB	-rw-r--r--
truncate.result	1.22 KB	-rw-r--r--

Code Editor : index_table.result

SET GLOBAL INNODB_OPTIMIZE_FULLTEXT_ONLY=1;
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
content TEXT
) ENGINE= InnoDB;
CREATE FULLTEXT INDEX idx ON articles (title, content);
Warnings:
Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
INSERT INTO articles (title, content) VALUES
('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
('How To Use MySQL Well','After you went through a ...'),
('Optimizing MySQL','In this tutorial we will show ...'),
('1001 MySQL Tricks','How to use full-text search engine'),
('Go MySQL Tricks','How to use full text search engine');
SET GLOBAL innodb_ft_aux_table="test/articles";
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
1001	6	6	1	6	0
after	4	4	1	4	22
database	3	3	1	3	37
dbms	3	3	1	3	15
engine	6	7	2	6	46
engine	6	7	2	7	44
full	6	7	2	6	29
full	6	7	2	7	27
mysql	3	7	5	3	0
mysql	3	7	5	3	31
mysql	3	7	5	4	11
mysql	3	7	5	5	11
mysql	3	7	5	6	5
mysql	3	7	5	7	3
optimizing	5	5	1	5	0
search	6	7	2	6	39
search	6	7	2	7	37
show	5	5	1	5	42
stands	3	3	1	3	20
text	6	7	2	6	34
text	6	7	2	7	32
through	4	4	1	4	37
tricks	6	7	2	6	11
tricks	6	7	2	7	9
tutorial	3	5	2	3	6
tutorial	3	5	2	5	25
use	4	7	3	4	7
use	4	7	3	6	25
use	4	7	3	7	23
well	4	4	1	4	17
went	4	4	1	4	32
you	4	4	1	4	28
OPTIMIZE TABLE articles;
Table	Op	Msg_type	Msg_text
test.articles	optimize	status	OK
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
1001	6	6	1	6	0
after	4	4	1	4	22
database	3	3	1	3	37
dbms	3	3	1	3	15
engine	6	7	2	6	46
engine	6	7	2	7	44
full	6	7	2	6	29
full	6	7	2	7	27
mysql	3	7	5	3	0
mysql	3	7	5	3	31
mysql	3	7	5	4	11
mysql	3	7	5	5	11
mysql	3	7	5	6	5
mysql	3	7	5	7	3
optimizing	5	5	1	5	0
search	6	7	2	6	39
search	6	7	2	7	37
show	5	5	1	5	42
stands	3	3	1	3	20
text	6	7	2	6	34
text	6	7	2	7	32
through	4	4	1	4	37
tricks	6	7	2	6	11
tricks	6	7	2	7	9
tutorial	3	5	2	3	6
tutorial	3	5	2	5	25
use	4	7	3	4	7
use	4	7	3	6	25
use	4	7	3	7	23
well	4	4	1	4	17
went	4	4	1	4	32
you	4	4	1	4	28
SET SESSION debug="+d,fts_instrument_result_cache_limit";
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
1001	6	6	1	6	0
after	4	4	1	4	22
database	3	3	1	3	37
dbms	3	3	1	3	15
engine	6	7	2	6	46
engine	6	7	2	7	44
full	6	7	2	6	29
full	6	7	2	7	27
mysql	3	7	5	3	0
mysql	3	7	5	3	31
mysql	3	7	5	4	11
mysql	3	7	5	5	11
mysql	3	7	5	6	5
mysql	3	7	5	7	3
optimizing	5	5	1	5	0
search	6	7	2	6	39
search	6	7	2	7	37
show	5	5	1	5	42
stands	3	3	1	3	20
text	6	7	2	6	34
text	6	7	2	7	32
through	4	4	1	4	37
tricks	6	7	2	6	11
tricks	6	7	2	7	9
tutorial	3	5	2	3	6
tutorial	3	5	2	5	25
use	4	7	3	4	7
use	4	7	3	6	25
use	4	7	3	7	23
well	4	4	1	4	17
went	4	4	1	4	32
you	4	4	1	4	28
SET SESSION debug="-d,fts_instrument_result_cache_limit";
DROP TABLE articles;
SET GLOBAL innodb_ft_result_cache_limit=default;
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
content TEXT
) ENGINE= InnoDB;
CREATE FULLTEXT INDEX idx_t ON articles (title);
Warnings:
Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
CREATE FULLTEXT INDEX idx_c ON articles (content);
INSERT INTO articles (title, content) VALUES
('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
('How To Use MySQL Well','After you went through a ...'),
('Optimizing MySQL','In this tutorial we will show ...'),
('1001 MySQL Tricks','How to use full-text search engine'),
('Go MySQL Tricks','How to use full text search engine');
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
1001	6	6	1	6	0
mysql	3	7	5	3	0
mysql	3	7	5	4	11
mysql	3	7	5	5	11
mysql	3	7	5	6	5
mysql	3	7	5	7	3
optimizing	5	5	1	5	0
tricks	6	7	2	6	11
tricks	6	7	2	7	9
tutorial	3	3	1	3	6
use	4	4	1	4	7
well	4	4	1	4	17
after	4	4	1	4	0
database	3	3	1	3	22
dbms	3	3	1	3	0
engine	6	7	2	6	28
engine	6	7	2	7	28
full	6	7	2	6	11
full	6	7	2	7	11
mysql	3	3	1	3	16
search	6	7	2	6	21
search	6	7	2	7	21
show	5	5	1	5	25
stands	3	3	1	3	5
text	6	7	2	6	16
text	6	7	2	7	16
through	4	4	1	4	15
tutorial	5	5	1	5	8
use	6	7	2	6	7
use	6	7	2	7	7
went	4	4	1	4	10
you	4	4	1	4	6
SET GLOBAL innodb_ft_aux_table="test/articles";
OPTIMIZE TABLE articles;
Table	Op	Msg_type	Msg_text
test.articles	optimize	status	OK
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
1001	6	6	1	6	0
mysql	3	7	5	3	0
mysql	3	7	5	4	11
mysql	3	7	5	5	11
mysql	3	7	5	6	5
mysql	3	7	5	7	3
optimizing	5	5	1	5	0
tricks	6	7	2	6	11
tricks	6	7	2	7	9
tutorial	3	3	1	3	6
use	4	4	1	4	7
well	4	4	1	4	17
after	4	4	1	4	0
database	3	3	1	3	22
dbms	3	3	1	3	0
engine	6	7	2	6	28
engine	6	7	2	7	28
full	6	7	2	6	11
full	6	7	2	7	11
mysql	3	3	1	3	16
search	6	7	2	6	21
search	6	7	2	7	21
show	5	5	1	5	25
stands	3	3	1	3	5
text	6	7	2	6	16
text	6	7	2	7	16
through	4	4	1	4	15
tutorial	5	5	1	5	8
use	6	7	2	6	7
use	6	7	2	7	7
went	4	4	1	4	10
you	4	4	1	4	6
DROP TABLE articles;
SET NAMES utf8;
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE FULLTEXT INDEX idx ON articles (title);
Warnings:
Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
INSERT INTO articles (title) VALUES
('相亲相爱'),('怜香惜爱'),('充满可爱'),('爱恨交织');
SET GLOBAL innodb_ft_aux_table="test/articles";
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
充满可爱	5	5	1	5	0
怜香惜爱	4	4	1	4	0
爱恨交织	6	6	1	6	0
相亲相爱	3	3	1	3	0
OPTIMIZE TABLE articles;
Table	Op	Msg_type	Msg_text
test.articles	optimize	status	OK
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
充满可爱	5	5	1	5	0
怜香惜爱	4	4	1	4	0
爱恨交织	6	6	1	6	0
相亲相爱	3	3	1	3	0
DROP TABLE articles;
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200)
) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
CREATE FULLTEXT INDEX idx ON articles (title);
Warnings:
Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
INSERT INTO articles (title) VALUES
('相亲相爱'),('怜香惜爱'),('充满可爱'),('爱恨交织');
SET GLOBAL innodb_ft_aux_table="test/articles";
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
爱恨交织	6	6	1	6	0
充满可爱	5	5	1	5	0
怜香惜爱	4	4	1	4	0
相亲相爱	3	3	1	3	0
OPTIMIZE TABLE articles;
Table	Op	Msg_type	Msg_text
test.articles	optimize	status	OK
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
WORD	FIRST_DOC_ID	LAST_DOC_ID	DOC_COUNT	DOC_ID	POSITION
怜香惜爱	4	4	1	4	0
充满可爱	5	5	1	5	0
相亲相爱	3	3	1	3	0
爱恨交织	6	6	1	6	0
DROP TABLE articles;
SET GLOBAL innodb_ft_aux_table=default;
SET GLOBAL INNODB_OPTIMIZE_FULLTEXT_ONLY=default;

${this.title}

Code Editor : index_table.result