tencent cloud

Feedback

Peripheral Check

Last updated: 2024-08-01 14:47:33

    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.
    Contact Us

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

    Technical Support

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

    7x24 Phone Support