Why Do We Get Different Explain Results From Master And Slave. (Doc ID 1499963.1)

Last updated on JANUARY 16, 2017

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Symptoms

Master server and Slave server has same data and schema even hardware, however SQL executed on the SLAVE can differ from the MASTER.

Checking the EXECUTION PLAN for the SQL shows differences , either in the order of the tables or different indexes completely.

This difference can persist even after running ANALYZE TABLE to update InnoDB statistics for the tables.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms