# To determine that table resides in which datafile of the tablespace??

**URL:** <https://forums.percona.com/t/to-determine-that-table-resides-in-which-datafile-of-the-tablespace/208>\
**Category:** Other MySQL® Questions\
**Created:** [February 21, 2007, 3:47am UTC](https://forums.percona.com/t/to-determine-that-table-resides-in-which-datafile-of-the-tablespace/208 "2007-02-21T03:47:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![subhanshu4u](https://avatars.discourse-cdn.com/v4/letter/s/ba8739/32.png) [@subhanshu4u](https://forums.percona.com/u/subhanshu4u)\
**Post date:** [February 21, 2007, 3:47am UTC](https://forums.percona.com/t/to-determine-that-table-resides-in-which-datafile-of-the-tablespace/208/1 "2007-02-21T03:47:17Z")

</div>

Hi,

I am a newbie to the MySQL Cluster. I have a doubt. Hope someone will help me out.

I am using MySQL 5.1.15-beta version

My question is :

How can one get to know that which table in a database is stored in which datafile of the tablespace in which the table exists??

For example, a table (say) ‘abc’ belonging to database (say) ‘xyz’ is stored in the tablespace ‘ts\_1’ and i have alloted two datafiles viz ‘data\_1.dat’ and ‘data\_2.dat’ to the tablespace ‘ts\_1’. So now how will i know that the data of the table ‘abc’ is residing in which datafile i.e ‘data\_1.dat’ or ‘data\_2.dat’??

thanks in advance