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

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • 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. MySQL Fails to Start Using systemctl On systemd Linux Distributions
  2. How to Configure Multiple MySQL Servers On One System Using mysqld_multi
  3. Multi-Versioning in MySQL Database
  4. MySQL Grants – Setting User Permissions On Different Tables
  5. How to configure resource groups for MySQL Server running on Linux
  6. How To Create a Local Yum Repository for MySQL Enterprise Packages
  7. MySQL Server Error – “Can’t Create A New Thread (errno 11)”
  8. MySQL: how to figure out which session holds which table level or global read locks
  9. MySQL: How to Set Account Resource Limits
  10. What is the MySQL Enterprise Monitor?

You May Also Like

Primary Sidebar

Recent Posts

  • aws ec2: CLI for AWS EC2 (Command Examples)
  • aws cur – Create, query, and delete AWS usage report definitions (Command Examples)
  • aws configure – Manage configuration for the AWS CLI (Command Examples)
  • aws cognito-idp: Manage Amazon Cognito user pool and its users and groups using the CLI

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright