…index. But the result was that it created a temporary table to count the movies per production year for each kind_id. It was more…columns. It turned out this solution was 150x faster for this case, so your suggestion is a good one! Thanks again for…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
…indexes with InnoDB in the same ALTER TABLE statement, but it’s not possible to CREATE more than one at a time. If you try it, this is what happens: mysql> alter table dir_test_innodb ADD FULLTEXT KEY…
