MySQL 8.0 changed INFORMATION_SCHEMA to only update once every 24 hours
Posted: Thu Jan 20, 2022 2:38 am
The INFORMATION_SCHEMA doesn't update to reflect recent alterations. MySQL 8.0 changed it so it only updates once every 24 hours.
You can set this:
That will make INFORMATION_SCHEMA update immediately, at the cost of some overhead on your system.
You can set this:
Code: Select all
SET GLOBAL information_schema_stats_expiry=0;