New answers tagged full-text-search
The problem was: ft_min_word_len is only for MyIsam and the correct variable is innodb_ft_min_token_size
You should denormalize the tables as such a normalization is leading to too many inner joins and multiple nested select statements. If normalization is very necessary try maintaining another table. As the number of images is low (~700), you might just skip the image_to_tag table. Otherwise, if the number of tags per image is very low (3-4), try keeping ...
Top 50 recent answers are included