…delete some data, and see what happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb’; mysql> set global innodb_optimize_fulltext…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
Post: Duplicate indexes and redundant indexes
August 17, 2006 By 38 Comments
…to have indexes of different types to created on the same column(s) – perfect example is BTREE index and FULLTEXT…query to run as index covered query (retrieve all columns from the index) – such indexes may become way too long to…
