Product_Features_Values 1.000.000 Rows Mysql Partitioning

cscart_product_features_values

1.000.000+ rows

150 MB

Product features too much, when the brands are involved, product indexing is very slow

mysql partition performance

feature_id product_id variant_id value value_int lang_code

is there anyone who can speed up the query?