Impact of Querying Table Information From information_schema
Percona
MARCH 27, 2023
A lot of useful information can be retrieved from this schema, for example, table metadata and foreign key relations, but trying to query I_S can induce performance degradation if your server is under heavy load, as shown in the following example test. ” under heavy load + I_S queries” to check for performance degradation.
Let's personalize your content