In MySQL, structural information about database objects — table names, column definitions, index structures, foreign key relationships — stored in information_schema and performance_schema. MySQL’s query optimiser relies on metadata statistics to choose efficient execution plans.
