Check Details
The innodb_stats_on_metadata
environment variable in the source database must be set to OFF
.
Troubleshooting
1. Log in to the source database.
2. Change the value of innodb_stats_on_metadata
to OFF
.
set global innodb_stats_on_metadata = OFF;
3. Check whether the configuration takes effect.
show global variables like '%innodb_stats_on_metadata%';
The system should display a result similar to the following:
mysql> show global variables like '%innodb_stats_on_metadata%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| innodb_stats_on_metadata | OFF |
+--------------------------+-------+
1 row in set (0.00 sec)
4. Run the verification task again.
Was this page helpful?