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

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

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. Beginners Guide to MySQL Data Types
  2. Granting All Privileges On All databases Except One Specific Table in MySQL
  3. How To Rotate the MySQL Enterprise Audit Log Plugin Log Based On Size
  4. MySQL : how to set (change) user password
  5. How to Configure Multiple MySQL Servers On One System Using mysqld_multi
  6. Managing MySQL Using Systemd As A Non Root User
  7. MySQL Cluster Point-In-Time Recovery (PITR)
  8. Examples of mysqldump partial backups
  9. What is the MySQL Enterprise Monitor?
  10. How to install and configure MySQL sys schema

You May Also Like

Primary Sidebar

Recent Posts

  • How to disable ACPI in CentOS/RHEL 7
  • How to Use real-time query to access data on a physical standby database
  • CentOS/RHEL 8: “ACPI MEMORY OR I/O RESET_REG” Server Hung after reboot
  • How to Create a Physical Standby Database by Using SQL and RMAN Commands
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary