Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.190.207.23
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
innodb_fts /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
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--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : tablespace_location.result
# # BUG#20527217 - INNODB: PUT FTS AUXILIARY TABLES INTO THE SAME GENERAL # TABLESPACE AS THE PRIMARY # SET DEFAULT_STORAGE_ENGINE=InnoDB; SET GLOBAL innodb_file_per_table = ON; SHOW VARIABLES LIKE 'innodb_file_per_table'; Variable_name Value innodb_file_per_table ON # Strict-mode has no affect on CREATE TABLESPACE. # It rejects all invalid input, as if strict mode is always ON. SET SESSION innodb_strict_mode = OFF; SHOW VARIABLES LIKE 'innodb_strict_mode'; Variable_name Value innodb_strict_mode OFF CREATE TABLESPACE s_def ADD DATAFILE 's_def.ibd'; CREATE TABLESPACE s_zip ADD DATAFILE 's_zip.ibd' FILE_BLOCK_SIZE=2k; === information_schema.innodb_sys_tablespaces and innodb_sys_datafiles === Space_Name Space_Type Page_Size Zip_Size Formats_Permitted Path s_def General DEFAULT 0 Any MYSQLD_DATADIR/s_def.ibd s_zip General DEFAULT 2048 Compressed MYSQLD_DATADIR/s_zip.ibd === information_schema.files === Space_Name File_Type Engine Status Tablespace_Name Path s_def TABLESPACE InnoDB NORMAL s_def MYSQLD_DATADIR/s_def.ibd s_zip TABLESPACE InnoDB NORMAL s_zip MYSQLD_DATADIR/s_zip.ibd # # tablespace=s_def row_format=redundant # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def ROW_FORMAT=redundant ; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_2 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_3 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_4 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_5 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_6 s_def 128 8 Redundant 0 General test/FTS_AUX_BEING_DELETED s_def 128 4 Redundant 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 128 4 Redundant 0 General test/FTS_AUX_CONFIG s_def 128 5 Redundant 0 General test/FTS_AUX_DELETED s_def 128 4 Redundant 0 General test/FTS_AUX_DELETED_CACHE s_def 128 4 Redundant 0 General test/t1 s_def 128 6 Redundant 0 General INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_2 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_3 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_4 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_5 s_def 128 8 Redundant 0 General test/FTS_AUX_INDEX_6 s_def 128 8 Redundant 0 General test/FTS_AUX_BEING_DELETED s_def 128 4 Redundant 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 128 4 Redundant 0 General test/FTS_AUX_CONFIG s_def 128 5 Redundant 0 General test/FTS_AUX_DELETED s_def 128 4 Redundant 0 General test/FTS_AUX_DELETED_CACHE s_def 128 4 Redundant 0 General test/t1 s_def 128 6 Redundant 0 General INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # tablespace=s_def row_format=compact # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def ROW_FORMAT=compact ; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_2 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_3 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_4 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_5 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_6 s_def 129 8 Compact 0 General test/FTS_AUX_BEING_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 129 4 Compact 0 General test/FTS_AUX_CONFIG s_def 129 5 Compact 0 General test/FTS_AUX_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_DELETED_CACHE s_def 129 4 Compact 0 General test/t1 s_def 129 6 Compact 0 General INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_2 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_3 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_4 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_5 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_6 s_def 129 8 Compact 0 General test/FTS_AUX_BEING_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 129 4 Compact 0 General test/FTS_AUX_CONFIG s_def 129 5 Compact 0 General test/FTS_AUX_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_DELETED_CACHE s_def 129 4 Compact 0 General test/t1 s_def 129 6 Compact 0 General INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # tablespace=s_def row_format=dynamic # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def ROW_FORMAT=dynamic ; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_2 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_3 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_4 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_5 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_6 s_def 161 8 Dynamic 0 General test/FTS_AUX_BEING_DELETED s_def 161 4 Dynamic 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 161 4 Dynamic 0 General test/FTS_AUX_CONFIG s_def 161 5 Dynamic 0 General test/FTS_AUX_DELETED s_def 161 4 Dynamic 0 General test/FTS_AUX_DELETED_CACHE s_def 161 4 Dynamic 0 General test/t1 s_def 161 6 Dynamic 0 General INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_2 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_3 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_4 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_5 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_6 s_def 161 8 Dynamic 0 General test/FTS_AUX_BEING_DELETED s_def 161 4 Dynamic 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 161 4 Dynamic 0 General test/FTS_AUX_CONFIG s_def 161 5 Dynamic 0 General test/FTS_AUX_DELETED s_def 161 4 Dynamic 0 General test/FTS_AUX_DELETED_CACHE s_def 161 4 Dynamic 0 General test/t1 s_def 161 6 Dynamic 0 General INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # tablespace=s_zip row_format=compressed KEY_BLOCK_SIZE=2 # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_zip ROW_FORMAT=compressed KEY_BLOCK_SIZE=2; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_2 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_3 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_4 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_5 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_6 s_zip 165 8 Compressed 2048 General test/FTS_AUX_BEING_DELETED s_zip 165 4 Compressed 2048 General test/FTS_AUX_BEING_DELETED_CACHE s_zip 165 4 Compressed 2048 General test/FTS_AUX_CONFIG s_zip 165 5 Compressed 2048 General test/FTS_AUX_DELETED s_zip 165 4 Compressed 2048 General test/FTS_AUX_DELETED_CACHE s_zip 165 4 Compressed 2048 General test/t1 s_zip 165 6 Compressed 2048 General INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_2 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_3 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_4 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_5 s_zip 165 8 Compressed 2048 General test/FTS_AUX_INDEX_6 s_zip 165 8 Compressed 2048 General test/FTS_AUX_BEING_DELETED s_zip 165 4 Compressed 2048 General test/FTS_AUX_BEING_DELETED_CACHE s_zip 165 4 Compressed 2048 General test/FTS_AUX_CONFIG s_zip 165 5 Compressed 2048 General test/FTS_AUX_DELETED s_zip 165 4 Compressed 2048 General test/FTS_AUX_DELETED_CACHE s_zip 165 4 Compressed 2048 General test/t1 s_zip 165 6 Compressed 2048 General INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # tablespace=innodb_file_per_table row_format=dynamic # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_file_per_table ROW_FORMAT=dynamic ; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 33 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 33 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 33 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 33 4 Dynamic 0 Single test/t1 test/t1 33 6 Dynamic 0 Single INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 33 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 33 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 33 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 33 4 Dynamic 0 Single test/t1 test/t1 33 6 Dynamic 0 Single INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # tablespace=innodb_file_per_table row_format=compressed KEY_BLOCK_SIZE=2 # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=2; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 37 8 Compressed 2048 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 37 4 Compressed 2048 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 37 4 Compressed 2048 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 37 5 Compressed 2048 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 37 4 Compressed 2048 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 37 4 Compressed 2048 Single test/t1 test/t1 37 6 Compressed 2048 Single INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 37 8 Compressed 2048 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 37 8 Compressed 2048 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 37 4 Compressed 2048 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 37 4 Compressed 2048 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 37 5 Compressed 2048 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 37 4 Compressed 2048 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 37 4 Compressed 2048 Single test/t1 test/t1 37 6 Compressed 2048 Single INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # tablespace=innodb_system row_format=redundant # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_system ROW_FORMAT=redundant ; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_2 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_3 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_4 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_5 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_6 innodb_system 128 8 Redundant 0 System test/FTS_AUX_BEING_DELETED innodb_system 128 4 Redundant 0 System test/FTS_AUX_BEING_DELETED_CACHE innodb_system 128 4 Redundant 0 System test/FTS_AUX_CONFIG innodb_system 128 5 Redundant 0 System test/FTS_AUX_DELETED innodb_system 128 4 Redundant 0 System test/FTS_AUX_DELETED_CACHE innodb_system 128 4 Redundant 0 System test/t1 innodb_system 128 6 Redundant 0 System INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_2 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_3 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_4 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_5 innodb_system 128 8 Redundant 0 System test/FTS_AUX_INDEX_6 innodb_system 128 8 Redundant 0 System test/FTS_AUX_BEING_DELETED innodb_system 128 4 Redundant 0 System test/FTS_AUX_BEING_DELETED_CACHE innodb_system 128 4 Redundant 0 System test/FTS_AUX_CONFIG innodb_system 128 5 Redundant 0 System test/FTS_AUX_DELETED innodb_system 128 4 Redundant 0 System test/FTS_AUX_DELETED_CACHE innodb_system 128 4 Redundant 0 System test/t1 innodb_system 128 6 Redundant 0 System INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # tablespace=innodb_system row_format=compact # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_system ROW_FORMAT=compact ; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_2 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_3 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_4 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_5 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_6 innodb_system 129 8 Compact 0 System test/FTS_AUX_BEING_DELETED innodb_system 129 4 Compact 0 System test/FTS_AUX_BEING_DELETED_CACHE innodb_system 129 4 Compact 0 System test/FTS_AUX_CONFIG innodb_system 129 5 Compact 0 System test/FTS_AUX_DELETED innodb_system 129 4 Compact 0 System test/FTS_AUX_DELETED_CACHE innodb_system 129 4 Compact 0 System test/t1 innodb_system 129 6 Compact 0 System INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_2 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_3 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_4 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_5 innodb_system 129 8 Compact 0 System test/FTS_AUX_INDEX_6 innodb_system 129 8 Compact 0 System test/FTS_AUX_BEING_DELETED innodb_system 129 4 Compact 0 System test/FTS_AUX_BEING_DELETED_CACHE innodb_system 129 4 Compact 0 System test/FTS_AUX_CONFIG innodb_system 129 5 Compact 0 System test/FTS_AUX_DELETED innodb_system 129 4 Compact 0 System test/FTS_AUX_DELETED_CACHE innodb_system 129 4 Compact 0 System test/t1 innodb_system 129 6 Compact 0 System INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # tablespace=innodb_system row_format=dynamic # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_system ROW_FORMAT=dynamic ; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_2 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_3 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_4 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_5 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_6 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_BEING_DELETED innodb_system 161 4 Dynamic 0 System test/FTS_AUX_BEING_DELETED_CACHE innodb_system 161 4 Dynamic 0 System test/FTS_AUX_CONFIG innodb_system 161 5 Dynamic 0 System test/FTS_AUX_DELETED innodb_system 161 4 Dynamic 0 System test/FTS_AUX_DELETED_CACHE innodb_system 161 4 Dynamic 0 System test/t1 innodb_system 161 6 Dynamic 0 System INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show TRUNCATE TABLE t1; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_2 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_3 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_4 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_5 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_INDEX_6 innodb_system 161 8 Dynamic 0 System test/FTS_AUX_BEING_DELETED innodb_system 161 4 Dynamic 0 System test/FTS_AUX_BEING_DELETED_CACHE innodb_system 161 4 Dynamic 0 System test/FTS_AUX_CONFIG innodb_system 161 5 Dynamic 0 System test/FTS_AUX_DELETED innodb_system 161 4 Dynamic 0 System test/FTS_AUX_DELETED_CACHE innodb_system 161 4 Dynamic 0 System test/t1 innodb_system 161 6 Dynamic 0 System INSERT INTO t1 (a,b) VALUES ('MySQL Tutorial','DBMS stands for DataBase') , ('How To Use MySQL Well','After you went through a'), ('Optimizing MySQL','In this tutorial we will show'); INSERT INTO t1 (a,b) VALUES ('1001 MySQL Tricks','1. Never run mysqld as root'), ('MySQL vs. YourSQL','In the following database comparison'), ('MySQL Security','When configured properly, MySQL'); SELECT * FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); a b MySQL Tutorial DBMS stands for DataBase Optimizing MySQL In this tutorial we will show DROP TABLE t1; # # Without TABLESPACE=, innodb_file_per_table=ON(default); # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b));; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 33 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 33 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 33 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 33 4 Dynamic 0 Single test/t1 test/t1 33 6 Dynamic 0 Single DROP TABLE t1; # # Without TABLESPACE=, innodb_file_per_table=OFF # SET GLOBAL innodb_file_per_table=OFF; CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b));; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 innodb_system 33 8 Dynamic 0 System test/FTS_AUX_INDEX_2 innodb_system 33 8 Dynamic 0 System test/FTS_AUX_INDEX_3 innodb_system 33 8 Dynamic 0 System test/FTS_AUX_INDEX_4 innodb_system 33 8 Dynamic 0 System test/FTS_AUX_INDEX_5 innodb_system 33 8 Dynamic 0 System test/FTS_AUX_INDEX_6 innodb_system 33 8 Dynamic 0 System test/FTS_AUX_BEING_DELETED innodb_system 33 4 Dynamic 0 System test/FTS_AUX_BEING_DELETED_CACHE innodb_system 33 4 Dynamic 0 System test/FTS_AUX_CONFIG innodb_system 33 5 Dynamic 0 System test/FTS_AUX_DELETED innodb_system 33 4 Dynamic 0 System test/FTS_AUX_DELETED_CACHE innodb_system 33 4 Dynamic 0 System test/t1 innodb_system 33 6 Dynamic 0 System DROP TABLE t1; SET GLOBAL innodb_file_per_table=default; CREATE TEMPORARY TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT(a,b)) TABLESPACE=innodb_temporary ROW_FORMAT=compact; ERROR HY000: Cannot create FULLTEXT index on temporary InnoDB table # Test with FTS TABLES in remote DATA DIRECTORY CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) DATA DIRECTORY 'REMOTE_DIR'; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 97 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 97 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 97 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 97 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 97 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 97 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 97 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 97 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 97 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 97 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 97 4 Dynamic 0 Single test/t1 test/t1 97 6 Dynamic 0 Single # list files in REMOTE_DIR FTS_AUX_INDEX_1.ibd FTS_AUX_INDEX_2.ibd FTS_AUX_INDEX_3.ibd FTS_AUX_INDEX_4.ibd FTS_AUX_INDEX_5.ibd FTS_AUX_INDEX_6.ibd FTS_AUX_BEING_DELETED.ibd FTS_AUX_BEING_DELETED_CACHE.ibd FTS_AUX_CONFIG.ibd FTS_AUX_DELETED.ibd FTS_AUX_DELETED_CACHE.ibd t1.ibd TRUNCATE TABLE t1; # restart TRUNCATE TABLE t1; # list files in REMOTE_DIR after TRUNCATE FTS_AUX_INDEX_1.ibd FTS_AUX_INDEX_2.ibd FTS_AUX_INDEX_3.ibd FTS_AUX_INDEX_4.ibd FTS_AUX_INDEX_5.ibd FTS_AUX_INDEX_6.ibd FTS_AUX_BEING_DELETED.ibd FTS_AUX_BEING_DELETED_CACHE.ibd FTS_AUX_CONFIG.ibd FTS_AUX_DELETED.ibd FTS_AUX_DELETED_CACHE.ibd t1.ibd DROP TABLE t1; # list files after DROP TABLE. Should be empty # Test with FTS , IMPORT & EXPORT tablespace CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def; FLUSH TABLES t1 FOR EXPORT; Warnings: Warning 1235 InnoDB: This version of MySQL doesn't yet support 'FLUSH TABLES FOR EXPORT on table `test`.`t1` in a general tablespace.' UNLOCK TABLES; DROP TABLE t1; # Test with ALTER. Add a FTS Index and also move the current # table to general tablespace CREATE TABLE t1 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200) ) ENGINE=InnoDB; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/t1 test/t1 33 5 Dynamic 0 Single ALTER TABLE t1 ADD FULLTEXT INDEX (title), TABLESPACE=s_def; Warnings: Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_2 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_3 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_4 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_5 s_def 161 8 Dynamic 0 General test/FTS_AUX_INDEX_6 s_def 161 8 Dynamic 0 General test/FTS_AUX_BEING_DELETED s_def 161 4 Dynamic 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 161 4 Dynamic 0 General test/FTS_AUX_CONFIG s_def 161 5 Dynamic 0 General test/FTS_AUX_DELETED s_def 161 4 Dynamic 0 General test/FTS_AUX_DELETED_CACHE s_def 161 4 Dynamic 0 General test/t1 s_def 161 6 Dynamic 0 General DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT fts_idx(a,b), c INT PRIMARY KEY) TABLESPACE=s_def ROW_FORMAT=compact; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_2 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_3 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_4 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_5 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_6 s_def 129 8 Compact 0 General test/FTS_AUX_BEING_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 129 4 Compact 0 General test/FTS_AUX_CONFIG s_def 129 5 Compact 0 General test/FTS_AUX_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_DELETED_CACHE s_def 129 4 Compact 0 General test/t1 s_def 129 7 Compact 0 General INSERT INTO t1 VALUES ('MySQL Tutorial','DBMS stands for DataBase', 1) , ('How To Use MySQL Well','After you went through a', 2), ('Optimizing MySQL','In this tutorial we will show', 3); INSERT INTO t1 VALUES ('1001 MySQL Tricks','1. Never run mysqld as root', 4), ('MySQL vs. YourSQL','In the following database comparison', 5), ('MySQL Security','When configured properly, MySQL', 6); SELECT c FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); c 1 3 ALTER TABLE t1 ADD UNIQUE INDEX idx1(b(20)), ALGORITHM=INPLACE; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_2 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_3 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_4 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_5 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_6 s_def 129 8 Compact 0 General test/FTS_AUX_BEING_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 129 4 Compact 0 General test/FTS_AUX_CONFIG s_def 129 5 Compact 0 General test/FTS_AUX_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_DELETED_CACHE s_def 129 4 Compact 0 General test/t1 s_def 129 7 Compact 0 General SELECT c FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); c 1 3 # Test with ALGORITHM=COPY and with FTS Index ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_2 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_3 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_4 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_5 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_6 s_def 129 8 Compact 0 General test/FTS_AUX_BEING_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 129 4 Compact 0 General test/FTS_AUX_CONFIG s_def 129 5 Compact 0 General test/FTS_AUX_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_DELETED_CACHE s_def 129 4 Compact 0 General test/t1 s_def 129 8 Compact 0 General SELECT pk FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); pk 1 3 # Before drop FTS index === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_2 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_3 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_4 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_5 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_6 s_def 129 8 Compact 0 General test/FTS_AUX_BEING_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 129 4 Compact 0 General test/FTS_AUX_CONFIG s_def 129 5 Compact 0 General test/FTS_AUX_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_DELETED_CACHE s_def 129 4 Compact 0 General test/t1 s_def 129 8 Compact 0 General # Test with DROP FTS Index & ADD FTS Index ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a,b); === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_2 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_3 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_4 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_5 s_def 129 8 Compact 0 General test/FTS_AUX_INDEX_6 s_def 129 8 Compact 0 General test/FTS_AUX_BEING_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_BEING_DELETED_CACHE s_def 129 4 Compact 0 General test/FTS_AUX_CONFIG s_def 129 5 Compact 0 General test/FTS_AUX_DELETED s_def 129 4 Compact 0 General test/FTS_AUX_DELETED_CACHE s_def 129 4 Compact 0 General test/t1 s_def 129 8 Compact 0 General SELECT pk FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); pk 1 3 DROP TABLE t1; # Test with file-per-table tablespace CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT fts_idx(a,b), c INT PRIMARY KEY) ; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 33 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 33 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 33 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 33 4 Dynamic 0 Single test/t1 test/t1 33 7 Dynamic 0 Single INSERT INTO t1 VALUES ('MySQL Tutorial','DBMS stands for DataBase', 1) , ('How To Use MySQL Well','After you went through a', 2), ('Optimizing MySQL','In this tutorial we will show', 3); INSERT INTO t1 VALUES ('1001 MySQL Tricks','1. Never run mysqld as root', 4), ('MySQL vs. YourSQL','In the following database comparison', 5), ('MySQL Security','When configured properly, MySQL', 6); SELECT c FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); c 1 3 ALTER TABLE t1 ADD UNIQUE INDEX idx1(b(20)), ALGORITHM=INPLACE; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 33 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 33 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 33 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 33 4 Dynamic 0 Single test/t1 test/t1 33 7 Dynamic 0 Single SELECT c FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); c 1 3 # Test with ALGORITHM=COPY and with FTS Index ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 33 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 33 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 33 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 33 4 Dynamic 0 Single test/t1 test/t1 33 8 Dynamic 0 Single SELECT pk FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); pk 1 3 # Before drop FTS index === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 33 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 33 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 33 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 33 4 Dynamic 0 Single test/t1 test/t1 33 8 Dynamic 0 Single # Test with DROP FTS Index & ADD FTS Index ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a,b); === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/FTS_AUX_INDEX_1 test/FTS_AUX_INDEX_1 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_2 test/FTS_AUX_INDEX_2 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_3 test/FTS_AUX_INDEX_3 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_4 test/FTS_AUX_INDEX_4 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_5 test/FTS_AUX_INDEX_5 33 8 Dynamic 0 Single test/FTS_AUX_INDEX_6 test/FTS_AUX_INDEX_6 33 8 Dynamic 0 Single test/FTS_AUX_BEING_DELETED test/FTS_AUX_BEING_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_BEING_DELETED_CACHE test/FTS_AUX_BEING_DELETED_CACHE 33 4 Dynamic 0 Single test/FTS_AUX_CONFIG test/FTS_AUX_CONFIG 33 5 Dynamic 0 Single test/FTS_AUX_DELETED test/FTS_AUX_DELETED 33 4 Dynamic 0 Single test/FTS_AUX_DELETED_CACHE test/FTS_AUX_DELETED_CACHE 33 4 Dynamic 0 Single test/t1 test/t1 33 8 Dynamic 0 Single SELECT pk FROM t1 WHERE MATCH (a,b) AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); pk 1 3 DROP TABLE t1; DROP TABLESPACE s_def; DROP TABLESPACE s_zip; SET GLOBAL innodb_file_per_table = default;
Close
