innodb_stats_on_metadata environment variable in the source database must be set to OFF.
-- Check description:innodb_stats_on_metadata parameter is enabled, every time tables in the information_schema metadatabase are queried, InnoDB will update the information_schema.statistics table, causing slower access. After this parameter is disabled, access to the schema table can be faster.innodb_stats_on_metadata parameter is ON, and you need to change it to OFF. On MySQL 5.6.6 or later, the default value is OFF, which has no problem.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)
피드백