LongVNIT

Manually extracting relevant information from repeated incantations of SHOW ENGINE INNODB STATUS while trying to figure out what InnoDB is doing is not only error prone, it’s just plain hard to do. And since MySQL doesn’t expose the data you really want in an INFORMATION_SCHEMA table (yet?), the option is use an external program [...]

When working with InnoDB, you have two ways for managing the tablespace storage:

Throw everything in one big file (optionally split).
Have one file per table.