Add index management

[drupaladmin]

It would be great if releem can analyze defined indexes. Some things to consider: indexes on low cardinality columns. Indexes that are subset of another index. And this one don't know if it is possible on the server side (without monitoring all queries) - but unused indexes.

[drupaladmin]

unused indexes are just as annoying as they add to disk costs, increase times in insert/update/delete operations, etc

SELECT DISTINCT a.OBJECT_SCHEMA as Schema_Name
	  ,a.OBJECT_NAME as Table_Name
	  ,a.INDEX_NAME as Index_Name
	  ,date(b.last_update)  AS Last_Update_Stat
	  ,(SELECT NOW() - INTERVAL variable_value SECOND as Last_Restart_Date FROM performance_schema.global_status WHERE variable_name='Uptime') AS Last_Restart_Server_Date
	  ,(SELECT DATEDIFF(NOW(),NOW() - INTERVAL variable_value SECOND) AS Days_Since_Last_Restarted  FROM performance_schema.global_status WHERE variable_name='Uptime') AS Days_Since_Server_Last_Restarted
FROM performance_schema.table_io_waits_summary_by_index_usage a
INNER JOIN mysql.innodb_index_stats b ON a.OBJECT_SCHEMA  =b.database_name 
AND a.object_name = b.table_name 
WHERE a.index_name IS NOT NULL 
AND a.count_star = 0 
ORDER BY a.object_schema, a.object_name;

[drupaladmin]

Added in the 1.19.5