…_INCREMENT PRIMARY KEY, c FLOAT) ENGINE=InnoDB; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t(c) VALUES (RAND… TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a special case of the… index creation chapter in the MySQL manual: “… you can generally speed the overall process of creating and loading an indexed table…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
… engine is MyISAM rather than InnoDB. Loading the data was done via a simple Perl script, inserting one row at a time… improving bulk insert performance. At the very bottom, the page claims that you can speed up bulk loading into an InnoDB FT index….00 sec) mysql> insert into dir_test_innodb (full_name, details) SELECT reverse(full_name), details FROM dir_test_innodb WHERE id < 500000…
