shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
0 stars 2 forks source link

Add dashboards for redundant and unused indexes #268

Open gordan-bobic opened 2 weeks ago

gordan-bobic commented 2 weeks ago

Not entirely where in the menu it would be best to put this yet - they are more related to QAN than other dashboards. Possibly under Insight / Advisor - Indexing

We need a dashboard showing redundant and unused (separately) indexes, based on st-duplicate-key-checker and st-unused-key-checker.. Against each we should show (in GB and with a bar graph) how much space (and thus memory) it consumes, relative to innodb_buffer_pool_size.