Add index usage information

[rebelice]

Development Task

After discussing, my development plan is as follows

• Add SCHEMA_INDEX_USAGE system table and functions to update
  • Add SCHEMA_INDEX_USAGE system table(session: add mysql.schema_index_usage table #19254 )
  • Add functions to update
    • Add index-usage-sync-lease config variable(*: add index-usage-sync-lease config variable #19842 )
    • Collect index usage information from point get and dump them to KV(*: collect index usage information from point get and dump them to KV #20126 )
    • Use ID instead of NAME in MySQL.SCHEMA_INDEX_USAGE(*: use ID instead of NAME in mysql.schema_index_usage #20589 )
    • Collect index usage information from other DataScan executors(statistics: collect index usage information #20877 )
  • Add GC function(statistics: GC index usage information #21014 )
• Add sys schema and sys.SCHEMA_UNUSED_INDEXES view(*: add sys schema, sys.SCHEMA_UNUSED_INDEXES view and sys.SCHEMA_INDEX_USAGE view #22126)
• Add sys.SCHEMA_INDEX_USAGE view(*: add sys schema, sys.SCHEMA_UNUSED_INDEXES view and sys.SCHEMA_INDEX_USAGE view #22126)
• Add FLUSH SCHEMA_INDEX_USAGE command
• Collect execution details in unistore.(This is to add unit tests)(unistore: collect ExecutorExecutionSummary and return by DAGResponse #20769 )

[rebelice]

/label component/infoschema

[rebelice]

/assign

[rebelice]

/assign

[rebelice]

/label epic/access-path, component/stats

[ti-srebot]

These labels are not found component/stats.

[rebelice]

/label component/statistics