Best way to determine if a MySQL InnoDB table is in its own file, not in system tablespace
Not relevant to readers using very old versions of MySQL, but on more recent versions of MySQL you can use: 
SELECT i.name FROM information_schema.INNODB_SYS_TABLES i WHERE i.space = 0;
to see which tables are in the shared table space and use:
SELECT i.name FROM information_schema.INNODB_SYS_TABLES i WHERE i.space &lt;&gt; 0;
to see which ones are in their own files.