Hello team, I’ve come to ask for your help because I’ve had difficulty finding a query that allows us to retrieve the objects (tables/indexes) that are hosted in a particular tablespace.
Version: 8.0.27-18 Percona Server.
I appreciate any assistance in advance!
Hello @Percona_new,
Check out information_schema.tables and information_schema.constraints
Thank you Matthew! The version we are running does not have information_schema.constraints and in information_schema.tables I cannot find the relation with the tablespace where the table is located.
Can you clarify please?
Look at INNODB_TABLESPACES. There are many tables inside information_schema that have information on tables, tablespaces, indexes, etc.
The version we are running does not have information_schema.constraints
I’m using Percona Server 8.0.34 which is the current GA release. If you have an earlier version, you’ll have to just take time and look through all the INNODB_* tables inside the information_schema and you will find the info that you need.