tencent cloud

All product documents
Data Transfer Service
DocumentationData Transfer ServiceData MigrationMigration to MySQL SeriesProcessing for MySQL Series Pre-Check FailurePeripheral Check
Peripheral Check
Download PDF
Last updated: 2024-07-08 19:41:52
Peripheral Check
Last updated: 2024-07-08 19:41:52
Download PDF

MySQL/TDSQL for MySQL/TDSQL-C check details

Check requirements: The innodb_stats_on_metadata environment variable in the source database must be set to OFF. -- Check description:
If the 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.
On MySQL versions earlier than 5.6.6, the default value of the 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.

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?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon