Not the answer you need?
Register and ask your own question!

MySQL Query Tuning

PandyanPandyan EntrantInactive User Role Beginner
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


  • PandyanPandyan Entrant Inactive User Role Beginner
    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.
  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner

    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.