… MySQL version used: 5.6….indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I used a 10GB key buffer. I used ALTER TABLE…ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…-links=0 innodb_…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
…table that has never had a full-text index on it, and then I create one, the following warning is generated: mysql> alter table…_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ I ran OPTIMIZE TABLE several more times, and each execution took between 6…
