How to List Tables Per Tablespace In MySQL Cluster

Question: How to list tables inside tablespaces in a MuSQL cluster?

The following query meets the aim of the question, lists the database, table name and the corresponding tablespace:

SELECT DISTINCT t.table_schema, t.table_name, p.tablespace_name
FROM partitions p JOIN TABLES t ON (t.table_schema=p.table_schema and t.table_name = p.table_name)
WHERE t.engine='ndbcluster' and tablespace_name IS NOT NULL

You May Also Like