Xrhrft

0 I'm trying to find out how to optimize our mysql server because for some reason this request takes 10 minutes to complete and all the time it stays on status "Copying to tmp table" : SELECT count(val_varchar_1) as le_nb_occurences, val_varchar_1 AS intitule FROM my_base_fiche_valeur WHERE 1 AND id_my_base=1 AND id_my_base_lien_base_champ=45 AND val_varchar_1!='' AND my_base_fiche_valeur.id_my_base_fiche IN ( SELECT distinct my_base_fiche.id_my_base_fiche FROM my_base_fiche LEFT JOIN my_base_fiche_valeur ON my_base_fiche_valeur.id_my_base_fiche=my_base_fiche.id_my_base_fiche WHERE ( my_base_fiche.id_my_base='1' AND ( 1 AND ( my_base_fiche.my_base_fiche_visible=1) AND 1 AND my_base_fiche.id_my_base_fiche IN ( SELECT DISTINCT(id_my_base_fiche...