MYSQL Database Speed

[Guest]

Hi?

I have an OSC MS2 Database with over 60,000 products and its on a dedicated server. I have optmized MYSQL DB performance on the server but Its very slow when adding attributes.

 

I get the following from the Slow_query Log that mysql generates...

 

# User@Host:hostname ] @ [mysqlhost]
# Query_time: 17  Lock_time: 0  Rows_sent: 2120  Rows_examined: 4485904
select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id from products_options_values pov left join products_options_values_to_products_options pov2po on pov.products_options_values_id = pov2po.products_options_values_id where pov.language_id = '1' order by pov.products_options_values_id;

 

Is there any way to optimize or index any specific tables to increase overall perfomance???

 

thanks :P