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

Query plan is different in master and slave

ikonraoikonrao ContributorCurrent User Role Beginner
Hello,

I was working on query optimization, during which I found that query plan on master and slave is different. Mysql version is same on both the servers. On Master it takes around 6 seconds to execute whereas in slave it takes around 1 second.

Only difference is query plan, rest all is same.

mysql version: 5.6.21

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi ikonrao;

    I would try running analyze table on both the master and slave and see if it matches after that. You could also rebuild the table with pt-online-schema-change for an "online" variation.

    -Scott
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.