I have a big database with 50 tables and each table can contain between 100,000 to 100 million records. On these tables are there are 1000s of indexes, but many of the indexes are now not in use.
How to find those indexes and remove them?
I am a beginner with MariaDB and MySQL, so with the answer, if you could mention resources to study this, that would be great.