Huge Performance degradation seen with pushdown ON

create database federated;use federated;

source remote.sql

create user r1@localhost;

grant all on *.* to r1@localhost;

create database federated;use federated;

source federated.sql

set global federated_pushdown=ON;

DELETE 

FROM 

  OUTR1 USING D AS OUTR1 

  RIGHT JOIN 

  ( B AS OUTR2 JOIN D AS OUTR3 ON ( OUTR2.pk > OUTR3.col_int_key ) )

    ON ( OUTR1.col_int_nokey = OUTR2.col_int_key ) 

WHERE 

  OUTR1.col_int_key IN (  SELECT DISTINCT INNR1.pk 

                          FROM CC AS INNR1 

                          WHERE INNR1.col_int_nokey <= 1 OR NOT INNR1.pk > 4 

                        UNION DISTINCT 

                          SELECT INNR1.pk 

                          FROM AA AS INNR1 

                          GROUP BY INNR1.col_int_uniq 

                          HAVING COUNT(*) >= 2

                       );