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