innodb_stats_on_metadata environment variable in the source database must be set to OFF. 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)
フィードバック