MySQL Query Tuning

MySQL & MariaDB Other MySQL® Questions
1

Hi All,

I am a new user for MySQL, I need to improve one slow performance query which is using joins commonly. I need some help to improve it, Does anyone knows about Query tuning. Thank you

2

Hi Tom, thank you for the reply. The links are quit useful for me. But I am looking for an alternate of Left join and where if classes, Which is in that slow performance query.

3

Hi,

Can you provide the query which you want to tune and “SHOW CREATE TABLE” for all those tables which are involved in that query? Explain plan will be also helpful. Thanks.