MySQL Forums
Forum List  »  InnoDB

MySQL execute plan behaves different in Master and Slave
Posted by: Jagadeesh Chinnathambi
Date: August 11, 2024 12:24PM

I have one MySQL query, and that query is using an index on the master but not using an index on the slave.

The query is as simple as SELECT * FROM table1 JOIN table2 ON table1.primary_id = table2.fk_id with simple where condition.

We checked the structure, indexes, global variables, data, and everything else. Everything is in sync.

I am expecting the query to use the index on the slave.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL execute plan behaves different in Master and Slave
202
August 11, 2024 12:24PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.