Details
-
Task
-
Status: In Review (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
If you have many thousands of databases, each with tables and an application you have no control over runs a query on I_S.COLUMNS or TABLES this can cause a significant amount of disk access which does not perform well.
In many cases all that is really needed is the output for the current default schema. This is particularly true for hosting environments where it is typically a schema per application and you do not have control over the queries being executed by the application.
The proposed solution is a new server variable with both a global and local option. When enabled I_S.COLUMNS and TABLES will only scan the current default schema if an explicit schema has not been provided in the WHERE condition.
Attachments
Issue Links
- is blocked by
-
MDEV-31535 optimize directory listing for information_schema tables based on privileges
- Open