innodb_stats_on_metadata to OFF on the source database.innodb_stats_on_metadata: If this parameter is enabled, InnoDB updates the information_schema.statistics table whenever tables in the information_schema metadata database are queried, increasing access time. You can disable this parameter to accelerate access to schema databases and tables.innodb_stats_on_metadata is ON and must be changed to OFF. For MySQL 5.6.6 and later versions, the preset value is OFF, and no issue exists.innodb_stats_on_metadata to OFF.set global innodb_stats_on_metadata = OFF;
show global variables like '%innodb_stats_on_metadata%';
mysql> show global variables like '%innodb_stats_on_metadata%';+--------------------------+-------+| Variable_name | Value |+--------------------------+-------+| innodb_stats_on_metadata | OFF |+--------------------------+-------+1 row in set (0.00 sec)
피드백