Server System Variables For users that have the  CONNECTION_ADMIN  privilege (or the deprecated  SUPER  privilege), the content of  init_connect  is not executed. This is done so that an erroneous value for  init_connect  does not prevent all clients from connecting. For example, the value might contain a statement that has a syntax error, thus causing client connections to fail. Not executing  init_connect  for users that have the  CONNECTION_ADMIN  or  SUPER  privilege enables them to open a connection and fix the init_connect  value. init_connect  execution is skipped for any client user with an expired password. This is done because such a user cannot execute arbitrary statements, and thus  init_connect  execution fails, leaving the client unable to connect. Skipping  init_connect  execution enables the user to connect and change password. The server discards any result sets produced by statements in the value of  init_connect . Those columns represent dynamic table metadata; that is, information that changes as table contents change. Some  INFORMATION_SCHEMA  tables contain columns that provide table statistics: By default, MySQL retrieves cached values for those columns from the  mysql.index_stats  and mysql.table_stats  dictionary tables when the columns are queried, which is more efficient than retrieving statistics directly from the storage engine. If cached statistics are not available or have expired, MySQL retrieves the latest statistics from the storage engine and caches them in the STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH TABLES.INDEX_LENGTH TABLES.MAX_DATA_LENGTH TABLES.TABLE_ROWS TABLES.UPDATE_TIME • information_schema_stats_expiry Command-Line Format --information-schema-stats-expiry=# System Variable information_schema_stats_expiry Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 86400 Minimum Value 0 Maximum Value 31536000 808