I have a customer who has run into an issue when they have data they want to query in information_schema tables but the tables have 100,000's+ records in them. The more records that get added the worse their query performs.
Could it be possible to set up a way to allow indexes be created against tables in the information_schema? Whether it be allowing
or some way to specify it in the MariaDB config file.
These indexes should not be created by default, and only by users who feel they need them.