1CREATE TABLE t1 ( 2id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, 3value VARCHAR(1024) 4) ENGINE=InnoDB; 5CREATE FULLTEXT INDEX idx1 ON t1(value); 6SET @save_debug = @@GLOBAL.debug_dbug; 7SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_sync_before_syncing,ib_trunc_sleep_before_fts_cache_clear'; 8INSERT INTO t1 (value) VALUES 9('By default or with the IN NATURAL LANGUAGE MODE modifier') 10; 11TRUNCATE TABLE t1; 12DROP TABLE t1; 13SET GLOBAL debug_dbug = @save_debug; 14CREATE TABLE t1 ( 15id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, 16value VARCHAR(1024) 17) ENGINE=InnoDB; 18CREATE FULLTEXT INDEX idx1 ON t1(value); 19SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_write_words_before_select_index,ib_trunc_sleep_before_fts_cache_clear'; 20INSERT INTO t1 (value) VALUES 21('By default or with the IN NATURAL LANGUAGE MODE modifier'), 22('performs a natural language search for a string'), 23('collection is a set of one or more columns included'), 24('returns a relevance value; that is, a similarity measure'), 25('and the text in that row in the columns named in'), 26('By default, the search is performed in case-insensitive'), 27('sensitive full-text search, use a binary collation '), 28('example, a column that uses the latin1 character'), 29('collation of latin1_bin to make it case sensitive') 30; 31TRUNCATE TABLE t1; 32DROP TABLE t1; 33SET GLOBAL debug_dbug = @save_debug; 34CREATE TABLE t1 ( 35value VARCHAR(1024) 36) ENGINE=InnoDB; 37CREATE FULLTEXT INDEX idx1 ON t1(value); 38SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep'; 39INSERT INTO t1 (value) VALUES 40('By default or with the IN NATURAL LANGUAGE MODE modifier'), 41('performs a natural language search for a string'), 42('collection is a set of one or more columns included'), 43('returns a relevance value; that is, a similarity measure'), 44('and the text in that row in the columns named in'), 45('By default, the search is performed in case-insensitive'), 46('sensitive full-text search, use a binary collation '), 47('example, a column that uses the latin1 character'), 48('collation of latin1_bin to make it case sensitive') 49; 50DROP INDEX idx1 ON t1; 51DROP TABLE t1; 52SET GLOBAL debug_dbug = @save_debug; 53CREATE TABLE t1 ( 54value VARCHAR(1024) 55) ENGINE=InnoDB; 56CREATE FULLTEXT INDEX idx1 ON t1(value); 57SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep'; 58INSERT INTO t1 (value) VALUES 59('By default or with the IN NATURAL LANGUAGE MODE modifier'), 60('performs a natural language search for a string'), 61('collection is a set of one or more columns included'), 62('returns a relevance value; that is, a similarity measure'), 63('and the text in that row in the columns named in'), 64('By default, the search is performed in case-insensitive'), 65('sensitive full-text search, use a binary collation '), 66('example, a column that uses the latin1 character'), 67('collation of latin1_bin to make it case sensitive') 68; 69ALTER TABLE t1 70DROP INDEX idx1, 71ALGORITHM=INPLACE; 72DROP TABLE t1; 73SET GLOBAL debug_dbug = @save_debug; 74CREATE TABLE t1 ( 75value VARCHAR(1024) 76) ENGINE=InnoDB; 77CREATE FULLTEXT INDEX idx1 ON t1(value); 78SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep'; 79INSERT INTO t1 (value) VALUES 80('example, a column that uses the latin1 character'), 81('collation of latin1_bin to make it case sensitive') 82; 83ALTER TABLE t1 84DROP INDEX idx1, 85ALGORITHM=COPY; 86DROP TABLE t1; 87SET GLOBAL debug_dbug = @save_debug; 88CREATE TABLE t1 ( 89id1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 90value VARCHAR(1024) 91) ENGINE=InnoDB; 92CREATE FULLTEXT INDEX idx1 ON t1(value); 93SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep'; 94INSERT INTO t1 (value) VALUES 95('example, a column that uses the latin1 character'), 96('collation of latin1_bin to make it case sensitive') 97; 98ALTER TABLE t1 99DROP COLUMN id1, 100ADD COLUMN id2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 101DROP INDEX idx1, 102ADD FULLTEXT INDEX idx2(value), 103ALGORITHM=INPLACE; 104DROP TABLE t1; 105SET GLOBAL debug_dbug = @save_debug; 106