• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

HowTos | Basics | Concepts

  • Solaris
    • Solaris 11
    • SVM
    • ZFS
    • Zones
    • LDOMs
    • Hardware
  • Linux
    • CentOS/RHEL 7
    • RHCSA notes
    • SuSE Linux Enterprise
    • Linux Services
  • VCS
    • VxVM
  • Interview Questions
  • oracle
    • ASM
    • mysql
    • RAC
    • oracle 12c
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Hadoop
    • Hortonworks HDP
      • HDPCA
    • Cloudera
      • CCA 131

How to List Tables Per Tablespace In MySQL Cluster

By admin

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

Filed Under: mysql, MySQL Cluster

Some more articles you might also be interested in …

  1. MySQL Shell: Using External Python Modules
  2. Understanding MySQL Privileges
  3. How to Configure Multiple MySQL Servers On One System Using mysqld_multi
  4. How to Add Data Nodes to MySQL Cluster without Restarting the Cluster (version 6.4 and later)
  5. How To Reset MySQL 8.0 Root Password On Windows
  6. Understanding the REVOKE statement in MySQL
  7. What is the purpose of “mysql.sys@localhost” user
  8. How to reset MySQL database root password
  9. MySQL Fails to Start Using systemctl On systemd Linux Distributions
  10. How To Skip a Transaction on MySQL replication slave When GTIDs Are Enabled

You May Also Like

Primary Sidebar

Recent Posts

  • How to Configure Network Namespaces in Docker Containers
  • How to change the default IP address of docker bridge
  • “su: Authentication failure” – in Docker
  • How to Pause and Resume Docker Containers
  • How to find docker storage device and its size (device mapper storage driver)
  • Archives
  • Contact Us
  • Copyright

© 2019 · The Geek Diary