MySQL 8.0 changed INFORMATION_SCHEMA to only update once every 24 hours

[cah]

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:

Code: Select all

SET GLOBAL information_schema_stats_expiry=0;

That will make INFORMATION_SCHEMA update immediately, at the cost of some overhead on your system.